Arch Linux

tritron4

Member

Registered: 2012-04-14

Posts: 153

sogo login and samba

I had setup samba as dc, openchange server  and sogo following directions in wiki. I cant get sers to login into sogo.
I see sogod [26021]: <0x0x7fc448af34c0[SOGoWebAuthenticator]> tried wrong password for user '0boEweBEnrtt2sovRGl3x4GUx8Ek0/B8Iv6zv+NlFYj0xHHOR5SRZ2m7ehTZOTgATCTHwpQFfI605AQzQtCocTxXXMQdLwwdoDNnZHPLPXAp+4aaidMNhQJk/aByfDKsarTd2kI6vJxVG9RaUztJZHyZmKbOMcOLcSB+PdP0eYWlMfCu5iPRgGoEWEEOUaFM8/32NoyUCDP1qeAe0yEnyg=='!
What I should check to get this working

tritron4

Member

Registered: 2012-04-14

Posts: 153

Re: sogo login and samba

I noticed that the wiki does not mentions steps required to create PostgreSQL database sogo. My server log showed no sogo
su - postgres
createuser --no-superuser --no-createdb --no-createrole --encrypted --pwprompt sogo
createdb -O sogo sogo
exit
That seems to let me login but I need to setup ssl first

tritron4

Member

Registered: 2012-04-14

Posts: 153

Re: sogo login and samba

I narrowed down my login issues to this error in postgresql
Dec 03 18:20:58 zafire postgres[2903]: STATEMENT:  CREATE TABLE sogo_sessions_folder ( c_id VARCHAR(255) PRIMARY KEY, c_value VARCHAR(255) NOT NULL, c_crea... NOT NULL)
Dec 03 18:20:58 zafire postgres[2903]: ERROR:  duplicate key value violates unique constraint "pg_type_typname_nsp_index"
Dec 03 18:20:58 zafire postgres[2903]: DETAIL:  Key (typname, typnamespace)=(sogo_sessions_folder, 2200) already exists.
Dec 03 18:20:58 zafire postgres[2903]: STATEMENT:  CREATE TABLE sogo_sessions_folder ( c_id VARCHAR(255) PRIMARY KEY, c_value VARCHAR(255) NOT NULL, c_crea... NOT NULL)

sogo
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'jacek+dn': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'jacek+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'jacek+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'jacek@hebe.us+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'session:947K+RGQflZ1Ja4fxH2RVA==': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'jacek+settings': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'jacek@+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'jacek+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'jacek@hebe.us+attributes': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
Dec 03 20:32:39 zafire sogod[3251]: Dec 03 20:32:39 sogod [3254]: <0x0x7f258412b7f0[SOGoCache]> an error occurred when caching value for key 'session:947K+RGQflZ1Ja4fxH2RVA==': "SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"
[root@zafire ~]#

Dec 03 18:20:58 zafire postgres[2903]: ERROR:  duplicate key value violates unique constraint "pg_type_typname_nsp_index"
Dec 03 18:20:58 zafire postgres[2903]: DETAIL:  Key (typname, typnamespace)=(sogo_sessions_folder, 2200) already exists.
Dec 03 18:20:58 zafire postgres[2903]: STATEMENT:  CREATE TABLE sogo_sessions_folder ( c_id VARCHAR(255) PRIMARY KEY, c_value VARCHAR(255) NOT NULL, c_crea... NOT NULL)
Dec 03 18:20:58 zafire postgres[2903]: ERROR:  duplicate key value violates unique constraint "pg_type_typname_nsp_index"
Dec 03 18:20:58 zafire postgres[2903]: DETAIL:  Key (typname, typnamespace)=(sogo_sessions_folder, 2200) already exists.
Dec 03 18:20:58 zafire postgres[2903]: STATEMENT:  CREATE TABLE sogo_sessions_folder ( c_id VARCHAR(255) PRIMARY KEY, c_value VARCHAR(255) NOT NULL, c_crea... NOT NULL)
Hint: Some lines were ellipsized, use -l to show in full.
[root@zafire ~]#