os x Server 3.1 breaks Profile Manager

Question

Level 1

0 points

os x Server 3.1 breaks Profile Manager

Hi all,

since i update to server 3.1, the Profile Manager wont start.

In the ive got these Error:

###########################################################################

0:: [245] [2014/03/20 20:15:14.725] Waiting for postgres to startup....

0:: [245] [2014/03/20 20:15:18.445] +[PGConnection reloadPreferences]: DBDebug = NO, DBLogNotices = NO, DBLogSQL = NO, DBMonitor = NO

0:: [245] [2014/03/20 20:15:29.432] Profile Manager service STOPPED

1:: [245] [2014/03/20 20:15:29.927] Incoming request: noOp

1:: [245] [2014/03/20 20:15:29.928] Incoming request: getWebAppState

1:: [245] [2014/03/20 20:15:29.963] Registering for network reachability notifications to "gateway.push.apple.com".

0:: [245] [2014/03/20 20:15:29.981] Profile Manager service stopped.

0:: [245] [2014/03/20 20:15:29.987] APNS topic = com.apple.mgmt.XServer.dcbf90a0-c0ba-4dee-bcb6-39de366d4e87

1:: [245] [2014/03/20 20:15:30.681] >>> networkSettingsChanged: "gateway.push.apple.com" is apparently reachable (flags = 0x2)

1:: [245] [2014/03/20 20:16:03.409] Incoming request: getWebAppState

0:: [245] [2014/03/20 20:16:03.727] Profile Manager service stopped.

1:: [245] [2014/03/20 20:16:07.547] Incoming request: readSettings

1:: [245] [2014/03/20 20:16:07.798] Incoming request: readAppDistributionSettings

1:: [245] [2014/03/20 20:16:07.856] Incoming request: readSimplifiedDeviceEnrollmentSettings

1:: [245] [2014/03/20 20:25:39.511] Incoming request: readSettings

1:: [245] [2014/03/20 20:25:39.578] Incoming request: readAppDistributionSettings

1:: [245] [2014/03/20 20:25:39.637] Incoming request: readSimplifiedDeviceEnrollmentSettings

1:: [245] [2014/03/20 20:25:40.054] Incoming request: readSettings

1:: [245] [2014/03/20 20:25:40.116] Incoming request: readAppDistributionSettings

1:: [245] [2014/03/20 20:25:40.170] Incoming request: readSimplifiedDeviceEnrollmentSettings

1:: [245] [2014/03/20 20:25:41.165] Incoming request: writeSettings

0:: [245] [2014/03/20 20:25:41.508] -[NSString(devicemgr_Additions) dateFromOpenSSLString]: 'Jan 27 19:45:36 2015 GMT'

0:: [245] [2014/03/20 20:25:41.672] -[Settings setSigningState:]: self.signing_org = cgrx

0:: [245] [2014/03/20 20:25:41.679] Loaded strings for locale 'de'.

0:: [245] [2014/03/20 20:25:42.105] EXCEPTION: Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-864.18/Compiled/Fra mework-Models/Postgres/PGConnection.m:421): "Postgres error 23503 (ERROR: insert or update on table "internal_tasks" violates foreign key constraint "internal_tasks_internal_task_id_fkey"

DETAIL: Key (internal_task_id)=(4) is not present in table "internal_tasks".

CONTEXT: SQL statement "INSERT INTO internal_tasks (internal_task_id, profile_substitution_cache_id) VALUES(p_it_id, psc.id) RETURNING id"

PL/pgSQL function _dm_internal_psc_generation_task(profile_substitution_caches,integer,integer) line 19 at SQL statement

SQL statement "SELECT _dm_internal_psc_generation_task(p, NEW.signing_certificate_id)

FROM profile_substitution_caches AS p

WHERE p.profile_cache IS NOT NULL

AND p.signing_certificate_id <> NEW.signing_certificate_id"

PL/pgSQL function _dm_trigger_after_settings_update() line 30 at PERFORM

)">

0:: [245] [2014/03/20 20:25:42.108] Caught unhandled exception -[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-864.18/Compiled/Fra mework-Models/Postgres/PGConnection.m:421): "Postgres error 23503 (ERROR: insert or update on table "internal_tasks" violates foreign key constraint "internal_tasks_internal_task_id_fkey"

DETAIL: Key (internal_task_id)=(4) is not present in table "internal_tasks".

CONTEXT: SQL statement "INSERT INTO internal_tasks (internal_task_id, profile_substitution_cache_id) VALUES(p_it_id, psc.id) RETURNING id"

PL/pgSQL function _dm_internal_psc_generation_task(profile_substitution_caches,integer,integer) line 19 at SQL statement

SQL statement "SELECT _dm_internal_psc_generation_task(p, NEW.signing_certificate_id)

FROM profile_substitution_caches AS p

WHERE p.profile_cache IS NOT NULL

AND p.signing_certificate_id <> NEW.signing_certificate_id"

PL/pgSQL function _dm_trigger_after_settings_update() line 30 at PERFORM

)"

1:: [245] [2014/03/20 20:25:53.541] Incoming request: readSettings

1:: [245] [2014/03/20 20:25:53.605] Incoming request: readAppDistributionSettings

1:: [245] [2014/03/20 20:25:53.664] Incoming request: readSimplifiedDeviceEnrollmentSettings

OS X Mavericks (10.9.2)

Posted on Mar 20, 2014 12:32 PM

Reply

Answer 1

Linc Davis

Level 10

209,547 points

Mar 20, 2014 5:30 PM in response to Uzilurcs

The database is corrupt.

OS X Server: How to reset Profile Manager to its original state

Reply

Answer 2

Uzilurcs Author

Level 1

0 points

Mar 23, 2014 1:57 AM in response to Linc Davis

Great, now i have a new problem:

sudo /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/wipeDB .sh

Password:

{

}

{

}

{

}

********************************************************************

*** Failed to create/update new Profile Manager database! ***

********************************************************************

*** Please check /Library/Logs/ProfileManager/migration_tool.log ***

*** for more information. Profile Manager will be non-functional ***

*** until a new database can be successfully created/updated. ***

********************************************************************

[1034] [2014/03/23 09:56:07.266] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES

0:: [1034] [2014/03/23 09:56:07.268]

############################################################################### #

migration_tool-864.18 (PID:1034, OS:13C64, SERVER:13S4138, ARCH:x86_64) starting

LA: migration_tool --wipeDB

Log verbosity level = 1

UID = 220, EUID = 220

############################################################################### #

1:: [1034] [2014/03/23 09:56:13.050] DropPostgresDatabase RESULT:

————————+—————————————————————————————————————————————————————————————————————— —————————————————————————————————————————————————————————————

COMMAND | /Applications/Server.app/Contents/ServerRoot/usr/bin/dropdb devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL

WD | /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr

————————+—————————————————————————————————————————————————————————————————————— —————————————————————————————————————————————————————————————

STATUS | 1

————————+—————————————————————————————————————————————————————————————————————— —————————————————————————————————————————————————————————————

STDERR | dropdb: database removal failed: ERROR: database "devicemgr_v2m0" is being accessed by other users

| DETAIL: There are 10 other sessions using the database.

————————+—————————————————————————————————————————————————————————————————————— —————————————————————————————————————————————————————————————

STDOUT |

————————+—————————————————————————————————————————————————————————————————————— —————————————————————————————————————————————————————————————

0:: [1034] [2014/03/23 09:56:13.050] EXCEPTION: !IF <void DropPostgresDatabase(NSString *__strong) (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-864.18/Compiled/Fra mework-Base/Support/PGUtilities.m:81): "'((status != 0))'">

0:: [1034] [2014/03/23 09:56:13.052] Terminating on unhandled exception void DropPostgresDatabase(NSString *__strong) (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-864.18/Compiled/Fra mework-Base/Support/PGUtilities.m:81): "'((status != 0))'", ? | 140735467216501

? | 4437587723

? | 4437841481

? | 4437841694

? | 4437434900

? | 140735464949245

? | 2

0:: [1034] [2014/03/23 09:56:13.053] ShutdownMigrator: 2014-03-23 08:56:13 +0000

0:: [1034] [2014/03/23 09:56:13.053] BYE

Reply

Answer 3

Linc Davis

Level 10

209,547 points

Mar 23, 2014 10:05 PM in response to Uzilurcs

Did you quit Server.app before running the command?

Reply

Answer 4

GodDar

Level 1

0 points

Mar 24, 2014 9:37 AM in response to Uzilurcs

I ran into the same issue last week. I ended up reinstalling the OS but once I had everything up and running again now I have the issue of not all of my AD groups enumerated in profile manager and only a fraction of my users are enumerated. After talking to Apple Support they informed me it was an known issue and they are working on it but could not provide a time frame. They also told to try a work around which consisted of creating OD groups and adding AD users as members which was useless, besides being a very time consuming project it didn't work because most of my users still aren't enumerating in profile manager.

Reply