Q: Profile Manager, Wiki and Postgre problems
Hi everybody,
I am running professionnaly a MacMini with OS X server 10.9.5 and Server.app 3.2.2 mainly for email and web services for my customers.
The box is hosted 1,000 Km away from me so I do not have physical acces to it.
Everything was runing smooth until I updated Server.app to 3.2.2 version. Since this update, ProfileManager and Wiki service are now broken.
When I try to use Profile Manager within Safari, I get this message :
« Profile manager not found. Check that PM is activated in Server App » (translated from French)
And when I try to use Wiki service, I get a Safari page displaying that :
Caught exception "Connection to DB failed" [CSDatabaseError] executing route /app-context/wiki/:
(
0 CoreFoundation 0x00007fff9443625c __exceptionPreprocess + 172
1 libobjc.A.dylib 0x00007fff91415e75 objc_exception_throw + 43
2 CSService 0x000000010dadc76d -[CSConnectionPool openConnection] + 3309
3 CSService 0x000000010dadd13a -[CSConnectionPool currentConnection] + 98
4 CSService 0x000000010db5c839 -[CSAuthService unauthenticatedSession] + 82
5 CSService 0x000000010db5ce13 -[CSAuthService currentOrNewSession] + 154
6 CSService 0x000000010db4e6b1 +[CSHTTPRouteHelper setCurrentSessionForRequest:] + 264
7 CSService 0x000000010db6271a __27-[CSAppContextService init]_block_invoke230 + 107
8 CSService 0x000000010db4a2aa __53-[CSRoutingHTTPConnection httpResponseForMethod:URI:]_block_invoke + 95
9 CSService 0x000000010db4d7b4 -[CSHTTPBackgroundResponse bounce:] + 286
10 Foundation 0x00007fff906e4d8b __NSThread__main__ + 1318
11 libsystem_pthread.dylib 0x00007fff89222899 _pthread_body + 138
12 libsystem_pthread.dylib 0x00007fff8922272a _pthread_struct_init + 0
13 libsystem_pthread.dylib 0x00007fff89226fc9 thread_start + 13
)
So I understand that probably none of those services have real problems but as they both relies on PostGre, I suppose that PostGre IS the problem …
I do not know much about Terminal command lines and do not how to investigate a possible Posgre problem. Postgre seems down but I am not sure and do not know how to repair it without any risks.
I tried to restore Profile Manager in it original state but this does not solve the problem of course.
I dare not too much work on that server because I do not want to damage other services that might be also based on Postgres. And also because this is a production machine with 500 active email accounts and about thirty websites.
Does anybody have an idea of what went wrong after this update ?
Thank you for any help,
Mac mini, OS X Mavericks (10.9.5), Server 3.2.2 - Core i7 - 2.3 Ghz
Posted on Feb 24, 2016 4:54 AM