IowaBoy
Level 1 (105 points)

Q: FATAL:  role "collab" does not exist

So, I am not able to read the Wiki settings in the Server application.  I notice that in the system log, I'm getting the following error:

 

FATAL:  role "collab" does not exist

 

How do I go about adding the collab role?

Posted on Jul 22, 2011 10:24 AM

by Doug Whitmore,Solvedanswer
Doug Whitmore Doug Whitmore
Level 2 (235 points)
A:

Look at

/System/Library/ServerSetup/CommonExtras/PostgreSQLExtras/CoreCollaborationPostg reSQLExtras.sh

 

That will build the roles and set up the database for use with wiki.

Posted on Jul 29, 2011 1:12 PM

Close
IowaBoy

Q: FATAL:  role "collab" does not exist

  • All replies
  • Helpful answers

Previous Page 2 of 3 last Next

  • by Jager2247,

    Jager2247 Jager2247 Sep 11, 2011 2:15 PM in response to perry9956
    Level 1 (0 points)
    Sep 11, 2011 2:15 PM in response to perry9956

    Ok sorry about that, I was being a total idiot.  I couldn't figure out how to get to the System folder. Anyway, finally got there, and I too had to run every script in the folder, but it works now. I tried calling Apple last night and after a bunch of troubleshooting steps, they were going to have me wipe the HD and start from scratch reinstalling Lion Server. Really glad I didn't have to do that! Thanks!

  • by Ethiel RODRIGUEZ,

    Ethiel RODRIGUEZ Ethiel RODRIGUEZ Oct 12, 2011 7:26 PM in response to Doug Whitmore
    Level 1 (0 points)
    Oct 12, 2011 7:26 PM in response to Doug Whitmore

    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.

  • by Chippett,

    Chippett Chippett Oct 15, 2011 4:56 PM in response to Doug Whitmore
    Level 1 (0 points)
    Oct 15, 2011 4:56 PM in response to Doug Whitmore

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

     

    Thanks

  • by perry9956,

    perry9956 perry9956 Oct 16, 2011 3:17 AM in response to Ethiel RODRIGUEZ
    Level 1 (0 points)
    Oct 16, 2011 3:17 AM in response to Ethiel RODRIGUEZ

    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

  • by perry9956,

    perry9956 perry9956 Oct 16, 2011 3:24 AM in response to Ethiel RODRIGUEZ
    Level 1 (0 points)
    Oct 16, 2011 3:24 AM in response to Ethiel RODRIGUEZ

    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...

  • by Ethiel RODRIGUEZ,

    Ethiel RODRIGUEZ Ethiel RODRIGUEZ Oct 16, 2011 4:25 AM in response to Ethiel RODRIGUEZ
    Level 1 (0 points)
    Oct 16, 2011 4:25 AM in response to Ethiel RODRIGUEZ

    Good morning,

     

    This is what I'm doing

    First, assure the postgres database service is running:

     

     

    $ sudo serveradmin start postgres 

    postgres:state = "RUNNING",

     

    Now I checked that postgres is functioning trying to connect,

     

    $ sudo psql -U _postgres -d postgres THEN I HIT RETURN and I get

    postgre=#


    now What? do I exit the terminal or run the script using postgre=#

     

    Can you give me step by step instructions on how to run the scripts.  This is all new to me, an I know nothing about scripts. Your help is appriciated. Thanks

     

    Ethiel

  • by perry9956,

    perry9956 perry9956 Oct 16, 2011 6:30 AM in response to Ethiel RODRIGUEZ
    Level 1 (0 points)
    Oct 16, 2011 6:30 AM in response to Ethiel RODRIGUEZ

    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.

  • by Ethiel RODRIGUEZ,

    Ethiel RODRIGUEZ Ethiel RODRIGUEZ Oct 16, 2011 7:21 AM in response to perry9956
    Level 1 (0 points)
    Oct 16, 2011 7:21 AM in response to perry9956

    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$

  • by bluesimmo,

    bluesimmo bluesimmo Nov 5, 2011 2:55 PM in response to perry9956
    Level 1 (0 points)
    Nov 5, 2011 2:55 PM in response to perry9956

    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

  • by Chris Connors,

    Chris Connors Chris Connors Jan 4, 2012 6:18 PM in response to bluesimmo
    Level 1 (120 points)
    Jan 4, 2012 6:18 PM in response to bluesimmo

    bluesimmo,

     

    me too.

     

    HALP!

  • by Chris Connors,

    Chris Connors Chris Connors Jan 4, 2012 6:28 PM in response to bluesimmo
    Level 1 (120 points)
    Jan 4, 2012 6:28 PM in response to bluesimmo

    Here's how to get Postgres running again:

    https://discussions.apple.com/message/16192642#16192642

  • by CyberKen,

    CyberKen CyberKen Jan 15, 2012 5:26 AM in response to Doug Whitmore
    Level 1 (4 points)
    Jan 15, 2012 5:26 AM in response to Doug Whitmore

    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.

  • by CyberKen,

    CyberKen CyberKen Jan 15, 2012 5:56 AM in response to Doug Whitmore
    Level 1 (4 points)
    Jan 15, 2012 5:56 AM in response to Doug Whitmore

    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

  • by Hamburger_gamer,

    Hamburger_gamer Hamburger_gamer Jan 22, 2012 4:30 AM in response to chris.cam
    Level 1 (0 points)
    Jan 22, 2012 4:30 AM in response to chris.cam

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

  • by Kevin Pera,

    Kevin Pera Kevin Pera Apr 17, 2012 10:46 AM in response to IowaBoy
    Level 1 (5 points)
    Apr 17, 2012 10:46 AM in response to IowaBoy

    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"

Previous Page 2 of 3 last Next