Ditto for me! Any ideas, where/how are the roles defined? Or even what is the role? This affects my new "test" server on my macbool pro as well as my upgraded main server on a mac mini server.
I think that when I've got this sorted I've got the upgrade sorted! Certainly not a simple upgrade!
1. server app access vanished (servermgrd listener disabled after upgrade)
2. invalid path in one of the configuration files
3. invalid permissions on one of the log directories
4. collab role does not exist
5. remote server admin does not work (but local does), not a "show stopper", but frustrating!
It's a postgresl error.
The postgresql role 'collab' used byt the collaboration services is missing.
You might have a database corruption.
You can try to restore from a backup the database:
Either the /var/pgsql directory (Postgres being stopped when you do this)
or a postgresql dump made with pg_dump or pg_dumpall
do a ls /var to see if you have any backups
Most of the problems could be realted to the db being broken
As a last resort you can try reinitializing the deviceManager postgresql DB with this command
I suspect though you would loose all you Profiles in profileManager
You'd go back to factory defaults but at least it could fix you missing role...
Just a guess...Hope this helps!
Can someone please give more details for this resolution?
I get an error message when trying to run the script:
could not connect to server: Permission denied
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
Even though I tried running it with sudo.
First, assure the postgres database service is running:
$ sudo serveradmin start postgres
It should respond:
postgres:state = "RUNNING"
Now check that postgres is functioning trying to connect, e.g.:
$ sudo psql -U _postgres -d postgres
where _postgres is the superuser and postgres is a database to connect to.
Then, try again running the script, which I assume you run with:
In order to have PostgreSQL functioning on your Mac OS X Lion Server please read:
Also download and install PGAdmin (ax excellent graphical front-end to PostgreSQL instead of the command line approach):
I'm sorry, I'm not really that familiar with server or the command line interface. I bought my new mac mini server in part to mess around with it and try to teach myself more about both topics. So could you explain how to run the scripts you are referencing in your post? I'm sure this is a stupid comment, but I tried to find the folder referenced above (/System/Library/ServerSetup/CommonExtras/PostgreSQLExtras/CoreCollaborationPos tg), and could not find it in the Library. Thanks in advance...
This seems very strange. What is the first subdirectory you don't have? Surely you have /System/Library/ServerSetup, otherwise you haven't Lion Server! If, for some strange reason, you lost subdirectories CommonExtras or PostGreSQLExtras I think you should try to re-install the server part of Lion. Otherwise, if you miss the only script CoreCollaborationPostgreSQLExtras.sh, let me know and I'll send you it.