FATAL: role "collab" does not exist

Can you please help? I'm trying to run the script in the folder (/System/Library/ServerSetup/CommonExtras/PostgreSQLExtras/CoreCollaborationPos tg)..but I get an error;

postgres:state = "RUNNING"

eserver:~ erod$ sudo psql -U _postgres -d postgres

psql (9.0.4)

Type "help" for help.

postgres=# create the collabd db user

postgres-# /usr/bin/createuser -U _postgres -d -s collab

postgres-# create and initialize the collabd database

postgres-# /usr/bin/createdb -U collab collab

postgres-# /usr/bin/psql -U collab -f /usr/share/postgresql/contrib/_int.sql

postgres-# /usr/bin/psql -U collab -f /usr/share/postgresql/contrib/hstore.sql

postgres-# /usr/bin/psql -U collab -f /usr/share/collabd/server/sql/schema.sql

postgres-# \g

ERROR: syntax error at or near "the"

LINE 1: create the collabd db user

^

What am I doing wrong?

I don't want to reinstall lion server again. any help will be appreciated.

Doug - awesome - I don't usually reply in forums but this was the magic sauce. Got server up and running now.

Thanks

It seems your script /System/Library/ServerSetup/CommonExtras/PostgreSQLExtras/CoreCollaborationPost g reSQLExtras.sh isn't ok. The error outlines a probably missing # at the start of the offending line.

I think the best thing for you to do is to use the correct version of the script. Here it is:

# create the collabd db user

/usr/bin/createuser -U _postgres -d -s collab

# create and initialize the collabd database

/usr/bin/createdb -U collab collab

/usr/bin/psql -U collab -f /usr/share/postgresql/contrib/_int.sql

/usr/bin/psql -U collab -f /usr/share/postgresql/contrib/hstore.sql

/usr/bin/psql -U collab -f /usr/share/collabd/server/sql/schema.sql

Ethiel, it is not clear the way you execute the script. You should first go into its directory with:

$ cd /System/Library/ServerSetup/CommonExtras/PostgreSQLExtras

Then, try running the script with:

$ sudo ./CoreCollaborationPostgreSQLExtras.sh

If it doesn't work, check inside the script: there is probably a # missing at the start of the comment lines...

Good morning,

This is what I'm doing

Ok, now it's clear where you fail ;-) Once assured postgres is running and correcty functioning, you hace to exit from postgres shell (postgre=#) and return to terminal shell ($) from which you have to run the script. So, once returned into the terminal shell:

1) You should first go into the script's directory with:

$ cd /System/Library/ServerSetup/CommonExtras/PostgreSQLExtras

2) Then, try running the script with:

$ sudo ./CoreCollaborationPostgreSQLExtras.sh

That sould work.

Thank you Perry for you help. When I run the commands you have giving me. I get the below errors. Do you know why?

eserver:~ erod$ cd /System/Library/ServerSetup/CommonExtras/PostgreSQLExtras

eserver:PostgreSQLExtras erod$ sudo ./CoreCollaborationPostgreSQLExtras.sh

createuser: creation of new role failed: ERROR: role "collab" already exists

createdb: database creation failed: ERROR: database "collab" already exists

SET

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:25: ERROR: type "query_int" already exists

CREATE FUNCTION

CREATE FUNCTION

COMMENT

CREATE FUNCTION

COMMENT

psql:/usr/share/postgresql/contrib/_int.sql:55: ERROR: operator @@ already exists

psql:/usr/share/postgresql/contrib/_int.sql:64: ERROR: operator ~~ already exists

CREATE FUNCTION

COMMENT

CREATE FUNCTION

COMMENT

CREATE FUNCTION

COMMENT

CREATE FUNCTION

COMMENT

CREATE FUNCTION

COMMENT

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:131: ERROR: operator && already exists

psql:/usr/share/postgresql/contrib/_int.sql:162: ERROR: operator @> already exists

psql:/usr/share/postgresql/contrib/_int.sql:171: ERROR: operator <@ already exists

psql:/usr/share/postgresql/contrib/_int.sql:181: ERROR: operator @ already exists

psql:/usr/share/postgresql/contrib/_int.sql:190: ERROR: operator ~ already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:206: ERROR: operator # already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:242: ERROR: operator # already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:263: ERROR: operator + already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:275: ERROR: operator + already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:286: ERROR: operator - already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:297: ERROR: operator | already exists

psql:/usr/share/postgresql/contrib/_int.sql:304: ERROR: operator | already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:315: ERROR: operator - already exists

psql:/usr/share/postgresql/contrib/_int.sql:322: ERROR: operator & already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:379: ERROR: operator class "gist__int_ops" for access method "gist" already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:401: ERROR: type "intbig_gkey" already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:457: ERROR: operator class "gist__intbig_ops" for access method "gist" already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/_int.sql:485: ERROR: operator class "gin__int_ops" for access method "gin" already exists

SET

psql:/usr/share/postgresql/contrib/hstore.sql:6: ERROR: type "hstore" already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:35: ERROR: type "hstore" already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:51: ERROR: operator -> already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:62: ERROR: operator -> already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:85: ERROR: operator ? already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:98: ERROR: operator ?| already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:111: ERROR: operator ?& already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:142: ERROR: operator - already exists

psql:/usr/share/postgresql/contrib/hstore.sql:148: ERROR: operator - already exists

psql:/usr/share/postgresql/contrib/hstore.sql:154: ERROR: operator - already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:165: ERROR: operator || already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:184: ERROR: operator @> already exists

psql:/usr/share/postgresql/contrib/hstore.sql:193: ERROR: operator <@ already exists

psql:/usr/share/postgresql/contrib/hstore.sql:203: ERROR: operator @ already exists

psql:/usr/share/postgresql/contrib/hstore.sql:212: ERROR: operator ~ already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:228: WARNING: => is deprecated as an operator name

DETAIL: This name may be disallowed altogether in future versions of PostgreSQL.

psql:/usr/share/postgresql/contrib/hstore.sql:228: ERROR: operator => already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:238: ERROR: function "hstore" already exists with same argument types

psql:/usr/share/postgresql/contrib/hstore.sql:241: ERROR: cast from type text[] to type hstore already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:256: ERROR: operator %% already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:266: ERROR: operator %# already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:304: ERROR: operator #= already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:353: ERROR: operator = already exists

psql:/usr/share/postgresql/contrib/hstore.sql:362: ERROR: operator <> already exists

psql:/usr/share/postgresql/contrib/hstore.sql:376: ERROR: operator #<# already exists

psql:/usr/share/postgresql/contrib/hstore.sql:385: ERROR: operator #<=# already exists

psql:/usr/share/postgresql/contrib/hstore.sql:394: ERROR: operator #># already exists

psql:/usr/share/postgresql/contrib/hstore.sql:403: ERROR: operator #>=# already exists

psql:/usr/share/postgresql/contrib/hstore.sql:413: ERROR: operator class "btree_hstore_ops" for access method "btree" already exists

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:426: ERROR: operator class "hash_hstore_ops" for access method "hash" already exists

psql:/usr/share/postgresql/contrib/hstore.sql:430: ERROR: type "ghstore" already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:446: ERROR: type "ghstore" already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:500: ERROR: operator class "gist_hstore_ops" for access method "gist" already exists

CREATE FUNCTION

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/postgresql/contrib/hstore.sql:530: ERROR: operator class "gin_hstore_ops" for access method "gin" already exists

psql:/usr/share/collabd/server/sql/schema.sql:54: ERROR: relation "entity_type" already exists

psql:/usr/share/collabd/server/sql/schema.sql:90: ERROR: relation "entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:92: ERROR: relation "idx_entity_tinyid" already exists

psql:/usr/share/collabd/server/sql/schema.sql:93: ERROR: relation "idx_entity_owner" already exists

psql:/usr/share/collabd/server/sql/schema.sql:94: ERROR: relation "idx_entity_parents" already exists

CREATE FUNCTION

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:137: ERROR: trigger "update_entity_parents" for relation "entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:150: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.Entity) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:155: ERROR: relation "entity_attrs" already exists

psql:/usr/share/collabd/server/sql/schema.sql:160: ERROR: relation "entity_private_attrs" already exists

psql:/usr/share/collabd/server/sql/schema.sql:179: ERROR: relation "entity_changesets" already exists

psql:/usr/share/collabd/server/sql/schema.sql:180: ERROR: relation "idx_entity_changesets_entity_revision" already exists

psql:/usr/share/collabd/server/sql/schema.sql:181: ERROR: relation "idx_entity_changesets_entity_changetime" already exists

psql:/usr/share/collabd/server/sql/schema.sql:182: ERROR: relation "idx_entity_changesets_entity_revision_concat" already exists

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:206: ERROR: trigger "update_changeset_moddates" for relation "entity_changesets" already exists

psql:/usr/share/collabd/server/sql/schema.sql:215: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.Document) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:220: ERROR: relation "document_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:230: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.Page) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:237: ERROR: relation "page_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:247: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.User) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:260: ERROR: relation "user_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:262: ERROR: relation "entity_user_shortname" already exists

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:278: ERROR: duplicate key value violates unique constraint "entity_pkey"

DETAIL: Key (uid)=(742d3a53-c7b0-4911-9465-90a98fd3cf7c) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:280: ERROR: duplicate key value violates unique constraint "user_entity_pkey"

DETAIL: Key (entity_uid_fk)=(742d3a53-c7b0-4911-9465-90a98fd3cf7c) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:281: ERROR: duplicate key value violates unique constraint "entity_attrs_pkey"

DETAIL: Key (entity_uid_fk)=(742d3a53-c7b0-4911-9465-90a98fd3cf7c) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:282: ERROR: duplicate key value violates unique constraint "entity_private_attrs_pkey"

DETAIL: Key (entity_uid_fk)=(742d3a53-c7b0-4911-9465-90a98fd3cf7c) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:286: ERROR: duplicate key value violates unique constraint "entity_pkey"

DETAIL: Key (uid)=(6e5c400d-cbe1-475f-81fc-9e010259c99b) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:288: ERROR: duplicate key value violates unique constraint "user_entity_pkey"

DETAIL: Key (entity_uid_fk)=(6e5c400d-cbe1-475f-81fc-9e010259c99b) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:289: ERROR: duplicate key value violates unique constraint "entity_attrs_pkey"

DETAIL: Key (entity_uid_fk)=(6e5c400d-cbe1-475f-81fc-9e010259c99b) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:290: ERROR: duplicate key value violates unique constraint "entity_private_attrs_pkey"

DETAIL: Key (entity_uid_fk)=(6e5c400d-cbe1-475f-81fc-9e010259c99b) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:294: ERROR: duplicate key value violates unique constraint "entity_pkey"

DETAIL: Key (uid)=(19a307c1-82bc-45c7-845a-21839fb222c7) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:295: ERROR: duplicate key value violates unique constraint "document_entity_pkey"

DETAIL: Key (entity_uid_fk)=(19a307c1-82bc-45c7-845a-21839fb222c7) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:297: ERROR: duplicate key value violates unique constraint "page_entity_pkey"

DETAIL: Key (entity_uid_fk)=(19a307c1-82bc-45c7-845a-21839fb222c7) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:298: ERROR: duplicate key value violates unique constraint "entity_attrs_pkey"

DETAIL: Key (entity_uid_fk)=(19a307c1-82bc-45c7-845a-21839fb222c7) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:299: ERROR: duplicate key value violates unique constraint "entity_private_attrs_pkey"

DETAIL: Key (entity_uid_fk)=(19a307c1-82bc-45c7-845a-21839fb222c7) already exists.

UPDATE 1

ALTER TABLE

psql:/usr/share/collabd/server/sql/schema.sql:308: ERROR: trigger "handle_user_entity_creation" for relation "user_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:322: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.FileData) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:343: ERROR: relation "filedata_entity" already exists

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:374: ERROR: trigger "update_filedata_owner" for relation "filedata_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:389: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.File) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:407: ERROR: relation "file_entity" already exists

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:430: ERROR: trigger "handle_file_filedata_change" for relation "file_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:432: ERROR: constraint "entity_avatar_uid_fk_fkey" for relation "entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:442: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.Project) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:448: ERROR: relation "project_entity" already exists

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:463: ERROR: trigger "handle_project_entity_creation" for relation "entity" already exists

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:480: ERROR: trigger "handle_project_entity_deletion" for relation "entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:489: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.Blog) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:493: ERROR: relation "blog_entity" already exists

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:505: ERROR: trigger "update_blog_entity_avatars" for relation "entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:515: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.SavedQuery) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:521: ERROR: relation "savedquery_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:531: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.Migration) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:535: ERROR: relation "migration_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:545: ERROR: duplicate key value violates unique constraint "entity_type_pkey"

DETAIL: Key (name)=(com.apple.entity.MigrationPlaceholder) already exists.

psql:/usr/share/collabd/server/sql/schema.sql:549: ERROR: relation "migrationplaceholder_entity" already exists

psql:/usr/share/collabd/server/sql/schema.sql:562: ERROR: relation "global_settings" already exists

psql:/usr/share/collabd/server/sql/schema.sql:574: ERROR: relation "entity_lock" already exists

psql:/usr/share/collabd/server/sql/schema.sql:592: ERROR: relation "relationship" already exists

psql:/usr/share/collabd/server/sql/schema.sql:600: ERROR: type "acl_action" already exists

psql:/usr/share/collabd/server/sql/schema.sql:611: ERROR: relation "entity_acls" already exists

psql:/usr/share/collabd/server/sql/schema.sql:613: ERROR: relation "idx_entity_acls" already exists

psql:/usr/share/collabd/server/sql/schema.sql:614: ERROR: relation "idx_entity_acls_login" already exists

psql:/usr/share/collabd/server/sql/schema.sql:615: ERROR: relation "idx_entity_acls_externalid" already exists

psql:/usr/share/collabd/server/sql/schema.sql:621: ERROR: relation "groups" already exists

psql:/usr/share/collabd/server/sql/schema.sql:630: ERROR: relation "entity_acls_defaults" already exists

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

psql:/usr/share/collabd/server/sql/schema.sql:654: ERROR: relation "session" already exists

psql:/usr/share/collabd/server/sql/schema.sql:655: ERROR: relation "idx_session_login" already exists

psql:/usr/share/collabd/server/sql/schema.sql:675: ERROR: relation "search_index" already exists

psql:/usr/share/collabd/server/sql/schema.sql:676: ERROR: relation "idx_search_index_entity_uid_fk" already exists

psql:/usr/share/collabd/server/sql/schema.sql:677: ERROR: relation "idx_search_index" already exists

psql:/usr/share/collabd/server/sql/schema.sql:678: ERROR: relation "idx_search_index_literal" already exists

psql:/usr/share/collabd/server/sql/schema.sql:691: ERROR: relation "search_results" already exists

psql:/usr/share/collabd/server/sql/schema.sql:692: ERROR: relation "idx_search_results_uid" already exists

psql:/usr/share/collabd/server/sql/schema.sql:693: ERROR: relation "idx_search_results_create_time" already exists

psql:/usr/share/collabd/server/sql/schema.sql:706: ERROR: relation "user_entity_read_status" already exists

psql:/usr/share/collabd/server/sql/schema.sql:719: ERROR: relation "user_entity_favorites" already exists

psql:/usr/share/collabd/server/sql/schema.sql:732: ERROR: relation "user_entity_updates" already exists

psql:/usr/share/collabd/server/sql/schema.sql:744: ERROR: relation "user_entity_watched" already exists

psql:/usr/share/collabd/server/sql/schema.sql:768: ERROR: relation "entity_comment" already exists

psql:/usr/share/collabd/server/sql/schema.sql:769: ERROR: relation "idx_entity_comment_entity" already exists

CREATE FUNCTION

psql:/usr/share/collabd/server/sql/schema.sql:788: ERROR: trigger "update_comment_moddates" for relation "entity_comment" already exists

psql:/usr/share/collabd/server/sql/schema.sql:802: ERROR: relation "subscription" already exists

psql:/usr/share/collabd/server/sql/schema.sql:820: ERROR: relation "notification" already exists

psql:/usr/share/collabd/server/sql/schema.sql:843: ERROR: relation "migration_status" already exists

DELETE 1

INSERT 0 1

eserver:PostgreSQLExtras erod$

Hi Perry,

I get the following:

postgres:error = "CANNOT_START_SERVICE_TIMEOUT_ERR"

After trying your commard from below.

perry9956 wrote:

First, assure the postgres database service is running:

$ sudo serveradmin start postgres

bluesimmo,

me too.

HALP!

Here's how to get Postgres running again:

https://discussions.apple.com/thread/3336521

I haven't managed to get a fully operational server since the minute that I unpacked this machine! I am chasing errors everywhere trying to find fixes. I am more wondering if there is a problem in the restore image. I have reinstalled the OS 5 times now after a week of trying to solve problems. The miniute that I boot the OS on a fresh install, before I do anything, I start all of the services except mail, podcast, & netboot. One of the processes states taht I must install a Directory, which I do and set that up. Then I am asked to associate my SSL certiicate with the service.

All loks good till I reboot. Either the services have all shutdown and now Wiki and Profile Manager no longer work, or I am locked out of the Server app totally.

A fresh install does not fix this. There has got to be something globally wrong since I am not installing, configuring or anything from the base install. The only maybe custom detail that is not Apple, is the SSL cert that I am selecting. That cert is not one that I am creating, is is already there once the directory is created.

I do not know if that is the problem, just an educated guess.

There has got to be a better way to setup a server. I had less trouble building a linux server from scratch.

When performed as Mr. Whitemore states, this fixed works perfect. All services operate normal, BUT on restart, the errorcomes back and I am right back where i started.

I tried to erase the db but after it is clear I then get this error:

FATAL: role "_devicemgr" does not exist

Also when I run the scripts in /System/Library/ServerSetup/CommonExtras/PostgreSQLExtras, I now get permission denied. Where the "blank" is all of this coming from on a fresh install? I have found that a fresh install does not help, so now am attacking each individual problem, trying to fix it so that I have an operational server. Why? Whay can I not just plug this thing in and go?

I never tried Snow Leopard Server, so I think I am missing out. This Lion Server is almost too problematic to implement in an SMB

yes, running all scripts with sudo ./(Scriptname) made running webmail possible, thanky everybody.

So I try to run the scripts, it just says direcory doesn't exist, if I try to wipe the DB, this is the error I get. Keep in mind this worked great for two days.

sudo /usr/share/devicemgr/backend/wipeDB.sh

Password:

devicemgr:state = "STOPPED"

postgres:error = "CANNOT_START_SERVICE_TIMEOUT_ERR"

(in /usr/share/devicemgr/backend)

Couldn't drop device_management : #<PGError: fe_sendauth: no password supplied

>

(in /usr/share/devicemgr/backend)

fe_sendauth: no password supplied

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/postgresql_adapter.rb:941:in `initialize'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/postgresql_adapter.rb:941:in `connect'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/postgresql_adapter.rb:941:in `connect'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/postgresql_adapter.rb:217:in `initialize'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/postgresql_adapter.rb:37:in `new'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/postgresql_adapter.rb:37:in `postgresql_connection'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:223:in `send'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:223:in `new_connection'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:188:in `checkout'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:184:in `loop'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:184:in `checkout'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor. rb:242:in `synchronize'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:183:in `checkout'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:98:in `connection'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_specification.rb:123:in `retrieve_connection'

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connect ion_adapters/abstract/connection_specification.rb:115:in `connection'

/usr/share/devicemgr/backend/vendor/rails/railties/lib/tasks/databases.rake:70:i n `create_database'

/usr/share/devicemgr/backend/vendor/rails/railties/lib/tasks/databases.rake:31

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 636:in `call'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 636:in `execute'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 631:in `each'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 631:in `execute'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 597:in `invoke_with_call_chain'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor. rb:242:in `synchronize'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 590:in `invoke_with_call_chain'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 583:in `invoke'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 2051:in `invoke_task'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 2029:in `top_level'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 2029:in `each'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 2029:in `top_level'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 2068:in `standard_exception_handling'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 2023:in `top_level'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 2001:in `run'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 2068:in `standard_exception_handling'

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rake.rb: 1998:in `run'

/usr/bin/rake:31

Couldn't create database for {"encoding"=>"UTF8", "username"=>"_devicemgr", "adapter"=>"postgresql", "database"=>"device_management", "pool"=>5}

(in /usr/share/devicemgr/backend)

rake aborted!

fe_sendauth: no password supplied

(See full trace by running task with --trace)

devicemgr:state = "STARTING"

What do you look at and what do you do with it?