Aug 5, 2024: iRedMail-1.7.1 has been released.

**test** · 2015-01-20 21:35:47

test
Member
Offline

Registered: 2014-11-18
Posts: 7

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"

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.

**ZhangHuangbin** · 2015-01-20 21:48:50

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,094

Re: SOGo integration

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

**test** · 2015-01-20 22:37:21

test
Member
Offline

Registered: 2014-11-18
Posts: 7

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

**ZhangHuangbin** · 2015-01-20 22:51:03

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,094

Re: SOGo integration

Does other mail account work? Or all are failed?

**test** · 2015-01-20 23:38:34

test
Member
Offline

Registered: 2014-11-18
Posts: 7

Re: SOGo integration

All failed

**test** · 2015-01-21 16:13:55

test
Member
Offline

Registered: 2014-11-18
Posts: 7

Re: SOGo integration

Should i make new install of SOGo from the beginning?

**test** · 2015-01-21 17:44:10

test
Member
Offline

Registered: 2014-11-18
Posts: 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

**ZhangHuangbin** · 2015-01-21 21:55:30

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,094

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 , then restart sogo service?

**test** · 2015-01-21 22:08:17

test
Member
Offline

Registered: 2014-11-18
Posts: 7

Re: SOGo integration

Ok i found problem myself. Ty for help.

**test** · 2015-01-21 22:10:10

test
Member
Offline

Registered: 2014-11-18
Posts: 7

Re: SOGo integration

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

**ZhangHuangbin** · 2015-01-21 22:28:01

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,094

Re: SOGo integration

Weird...

Aug 5, 2024: iRedMail-1.7.1 has been released.

[ Closed ] SOGo integration

Posts: 11

1 Topic by test 2015-01-20 21:35:47

Topic: SOGo integration

2 Reply by ZhangHuangbin 2015-01-20 21:48:50

Re: SOGo integration

3 Reply by test 2015-01-20 22:37:21

Re: SOGo integration

4 Reply by ZhangHuangbin 2015-01-20 22:51:03

Re: SOGo integration

5 Reply by test 2015-01-20 23:38:34

Re: SOGo integration

6 Reply by test 2015-01-21 16:13:55

Re: SOGo integration

7 Reply by test 2015-01-21 17:44:10

Re: SOGo integration

8 Reply by ZhangHuangbin 2015-01-21 21:55:30

Re: SOGo integration

9 Reply by test 2015-01-21 22:08:17

Re: SOGo integration

10 Reply by test 2015-01-21 22:10:10

Re: SOGo integration

11 Reply by ZhangHuangbin 2015-01-21 22:28:01

Re: SOGo integration

Posts: 11