1

Topic: SOGo integration

==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: CentOS 6
- Related log if you're reporting an issue: don`t know where to search for log for this issue
====
First - thanks for great mail Server ZhangHuangbin!

I just upgraded from 0.8.7 to 0.9.0 - iRedMail server is working ok.

Then i did SOGo integration. http://www.iredmail.org/docs/sogo-centos-6-mysql.html

When i log to https://[your_server]/SOGo  with my iredmail credentials i have an error "Wrong login or password"

I checked DB sogo TABLE users
mysql> select * from users;
+-------------------------------+-------------------------------+------------------------------------+--------------------------+           
| c_uid                         | c_name                        | c_password                         | c_cn                     | mail                          |                  home                                                                        |
+-------------------------------+-------------------------------+------------------------------------+--------------------------+
| admin@xxxx.xx       | admin@xxxx.xx     | $1$8uQr5D32$8HjDm3wK2WTdHWAhjftQ1. | admin   | admin@xxxx.xx     
             
Looks like all users are on their places.

Please could you help to find right direction to solve the problem?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: SOGo integration

Any related log in /var/log/sogo/sogo.log?

3

Re: SOGo integration

Jan 20 08:43:33 sogod [21212]: SOGoRootPage Login from '111.111.111.111' for user 'admin@xxxxx.xx' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
111.111.111.111 - - [20/Jan/2015:08:43:33 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/91 0.004 - - 0
Jan 20 09:33:37 sogod [21212]: SOGoRootPage Login from '111.111.111.111' for user 'admin@xxxxx.xx' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0

4

Re: SOGo integration

Does other mail account work? Or all are failed?

5

Re: SOGo integration

All failed

6

Re: SOGo integration

Should i make new install of SOGo from the beginning?

7

Re: SOGo integration

SOGo log after enabling
SoSecurityManagerDebugEnabled = YES;
MySQL4DebugEnabled = YES;

Jan 21 04:34:48 sogod [32380]: <0x0x7fbb967a75c8[WOWatchDogChild]> child 32389 exited
Jan 21 04:34:48 sogod [32380]: <0x0x7fbb965a1388[WOWatchDog]> all children exited. We now terminate.
Jan 21 04:34:49 sogod [1119]: version 2.2.13 (build root@shiva.inverse 201412300836) -- starting
Jan 21 04:34:49 sogod [1119]: vmem size check enabled: shutting down app when vmem > 384 MB
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81f4292d8[SOGoProductLoader]> SOGo products loaded from '/usr/lib64/GNUstep/SOGo':
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81f4292d8[SOGoProductLoader]>   SchedulerUI.SOGo, MailerUI.SOGo, ContactsUI.SOGo, Contacts.SOGo, MailPartViewers.SOGo, Appointments.SOGo, PreferencesUI.SOGo, CommonUI.SOGo, Mailer.SOGo, AdministrationUI.SOGo, MainUI.SOGo, ActiveSync.SOGo
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81f2ac388[WOWatchDog]> listening on 127.0.0.1:20000
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81f2ac388[WOWatchDog]> watchdog process pid: 1119
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81d65f960[WOWatchDogChild]> watchdog request timeout set to 10 minutes
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81f2ac388[WOWatchDog]> preparing 3 children
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81f2ac388[WOWatchDog]> child spawned with pid 1128
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81f2ac388[WOWatchDog]> child spawned with pid 1129
Jan 21 04:34:49 sogod [1119]: <0x0x7fe81f2ac388[WOWatchDog]> child spawned with pid 1130
2015-01-21 04:34:49.315 sogod[1130] MySQL4 connection established 0x0x7fe81f490af0
2015-01-21 04:34:49.315 sogod[1129] MySQL4 connection established 0x0x7fe81f490af0
2015-01-21 04:34:49.315 sogod[1128] MySQL4 connection established 0x0x7fe81f490af0
2015-01-21 04:34:49.315 sogod[1130] MySQL4 channel 0x0x7fe81f58b438 opened (connection=0x0x7fe81f490af0,sogo)
2015-01-21 04:34:49.315 sogod[1129] MySQL4 channel 0x0x7fe81f58b438 opened (connection=0x0x7fe81f490af0,sogo)
2015-01-21 04:34:49.315 sogod[1128] MySQL4 channel 0x0x7fe81f58b438 opened (connection=0x0x7fe81f490af0,sogo)
2015-01-21 04:34:49.315 sogod[1129] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_user_profile;
2015-01-21 04:34:49.315 sogod[1130] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_user_profile;
2015-01-21 04:34:49.316 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_user_profile;
2015-01-21 04:34:49.316 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.316 sogod[1129] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.316 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_folder_info;
2015-01-21 04:34:49.316 sogod[1130] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.316 sogod[1129] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_folder_info;
2015-01-21 04:34:49.316 sogod[1130] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_folder_info;
2015-01-21 04:34:49.316 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.316 sogod[1129] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.316 sogod[1130] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.318 sogod[1129] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_sessions_folder;
2015-01-21 04:34:49.318 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_sessions_folder;
2015-01-21 04:34:49.318 sogod[1130] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_sessions_folder;
2015-01-21 04:34:49.318 sogod[1129] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.318 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.318 sogod[1130] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.318 sogod[1129] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_alarms_folder;
2015-01-21 04:34:49.318 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_alarms_folder;
2015-01-21 04:34:49.319 sogod[1130] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT count(*) FROM sogo_alarms_folder;
2015-01-21 04:34:49.319 sogod[1129] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.319 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:34:49.319 sogod[1130] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
2015-01-21 04:35:05.108 sogod[1128] Note: Using UTF-8 as URL encoding in NGExtensions.
Jan 21 04:35:05 sogod [1128]: <0x0x7fe81f593cd8[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Jan 21 04:35:05 sogod [1128]: <0x0x7fe81f593cd8[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
2015-01-21 04:35:05.111 sogod[1128] Note(SoObject): SoDebugKeyLookup is enabled!
2015-01-21 04:35:05.111 sogod[1128] Note(SoObject): SoDebugBaseURL is enabled!
2015-01-21 04:35:05.111 sogod[1128] Note(SoObject): relative base URLs are enabled.
2015-01-21 04:35:05.130 sogod[1128] WOCompoundElement: pool embedding is on.
2015-01-21 04:35:05.130 sogod[1128] WOCompoundElement: id logging is on.
2015-01-21 04:35:05.134 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0> SQL: SELECT c_password FROM users WHERE c_uid = 'admin@xxxx.xx';
2015-01-21 04:35:05.135 sogod[1128] <MySQL4Channel[0x0x7fe81f58b438] connection=0x0x7fe81f490af0>   query has results, entering fetch-mode.
Jan 21 04:35:05 sogod [1128]: SOGoRootPage Login from '111.111.111.111' for user 'admin@xxxx.xx' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
111.111.111.111 - - [21/Jan/2015:04:35:05 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/91 0.030 - - 2M

8

Re: SOGo integration

No idea yet, Google returns many result related to LDAP authentication, but not SQL.

Does it work if you disable Memcached in /etc/sogo/sogo.conf (SOGoMemcachedHost smile, then restart sogo service?

9

Re: SOGo integration

Ok i found problem myself. Ty for help.

10

Re: SOGo integration

I don`t know why - but when i changed passwords again for all users in iRedAdmin  - SOGo started to work.

11

Re: SOGo integration

Weird...