phil98

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

Close

Q: Profile Manager, Wiki and Postgre problems

  • All replies
  • Helpful answers

  • by phil98,

    phil98 phil98 Feb 25, 2016 5:52 AM in response to phil98
    Level 1 (11 points)
    Servers Enterprise
    Feb 25, 2016 5:52 AM in response to phil98

    I reply to myself :

     

    I ran the command  "serveradmin fullstatus postgres" and it retruned :

     

    postgres:dataDirHasBeenInitialized = yes

    postgres:PG_VERSION = "9.3.4"

    postgres:dataDir = "/Library/Server/PostgreSQL/Data"

    postgres:postgresIsResponding = yes

    postgres:dataDirIsDirectory = yes

    postgres:PGserverVersion = 90304

    postgres:dataDirExists = yes

    postgres:setStateVersion = 1

    postgres:state = "RUNNING"

     

    Postgres seems ok, then I am still stuck with this problem … :-((

     

    A little help would be appreciated. Thanks. :-)