1

Topic: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.4.0 MARIADB edition
- Deployed with iRedMail Easy or the downloadable installer? iRedMail Easy
- Linux/BSD distribution name and version: Linux gen-ubuntu-server-01 5.8.0-1032-raspi #35-Ubuntu SMP PREEMPT Wed Jul 14 10:51:21 UTC 2021 aarch64 aarch64 aarch64 GNU/Linux
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MYSQL
- Web server (Apache or Nginx): NGINX
- Manage mail accounts with iRedAdmin-Pro? NO
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hello i am newbie trying to get SOGo to work with my iRedMail GUI, every time i tried to access the SOGo webpage with username/password already created in mysql sogo.sogo_users i get the following error

Aug 18 19:29:56 sogod [1285658]: SOGoRootPage Login from '192.168.1.147' for user 'user1' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
Aug 18 19:29:56 sogod [1285658]: 192.168.1.147 "POST /SOGo/connect HTTP/1.0" 403 34/67 0.010 - - 0

i had manually added the user via mysql command INSERT and all looks good but GUI keeps telling me Wrong username or password RETRY

SOGo version: 4.3.2

Please help


Thank you

----

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

2

Re: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

- Turn on debug mode in SOGo and try again, check its log file and try to figure out why it doesn't work.
- SOGo 4.3.2 is too old, 5.2.0 was released today. Please upgrade.
- It's better use iRedAdmin(-Pro) to create mail account. I'm not sure whether some required sql record(s) is missing if you do it manually.

3

Re: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

i got further once i check my sogo.conf and find out that userPasswordAlgorithm = md5-ecrypt; then i change it to userPasswordAlgorithm = md5; and i am able to log but i ma getting this on the /var/log/sogo/sogo.log after restarting sogo services

Aug 18 21:13:35 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:35 sogod [1308669]: <0x0xaaaaefe66dd0[WOWatchDogChild]> sending terminate signal to pid 1308672
Aug 18 21:13:35 sogod [1308669]: <0x0xaaaaefe84460[WOWatchDogChild]> sending terminate signal to pid 1308671
Aug 18 21:13:35 sogod [1308669]: <0x0xaaaaefe7d210[WOWatchDogChild]> sending terminate signal to pid 1308670
Aug 18 21:13:36 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:36 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:37 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:37 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:38 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:38 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Error (objc-load):/usr/lib/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: OPENSSL_init_ssl
Error (objc-load):/usr/lib/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_UIxMailSizeFormatter
Error (objc-load):/usr/lib/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: OPENSSL_init_ssl
Error (objc-load):/usr/lib/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_UIxMailSizeFormatter
Error (objc-load):/usr/lib/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: OPENSSL_init_ssl
Error (objc-load):/usr/lib/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_UIxMailSizeFormatter
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefe66dd0[WOWatchDogChild]> child 1308672 exited
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefe7d210[WOWatchDogChild]> child 1308670 exited
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefe84460[WOWatchDogChild]> child 1308671 exited
Aug 18 21:13:39 sogod [1308669]: <0x0xaaaaefdb7c20[WOWatchDog]> all children exited. We now terminate.
Error (objc-load):/usr/lib/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: OPENSSL_init_ssl
Error (objc-load):/usr/lib/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_UIxMailSizeFormatter
Aug 18 21:13:39 sogod [1310507]: version 4.3.2 -- starting
Aug 18 21:13:39 sogod [1310507]: vmem size check enabled: shutting down app when vmem > 384 MB. Currently at 87 MB
Aug 18 21:13:39 sogod [1310507]: <0x0xaaab0679bf00[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Aug 18 21:13:39 sogod [1310507]: <0x0xaaab0679bf00[SOGoProductLoader]>   AdministrationUI.SOGo, MainUI.SOGo, CommonUI.SOGo, SchedulerUI.SOGo, Mailer.SOGo, MailPartViewers.SOGo, Contacts.SOGo, MailerUI.SOGo, Appointments.SOGo, ContactsUI.SOGo, PreferencesUI.SOGo
Aug 18 21:13:39 sogod [1310507]: [so-product-registry] could not load product: MailPartViewers
Aug 18 21:13:40 sogod [1310507]: [so-product-registry] could not load product: MailerUI
Aug 18 21:13:40 sogod [1310507]: All products loaded - current memory usage at 97 MB
Aug 18 21:13:40 sogod [1310507]: <0x0xaaab067ccc20[WOWatchDog]> listening on 127.0.0.1:20000
Aug 18 21:13:40 sogod [1310507]: <0x0xaaab067ccc20[WOWatchDog]> watchdog process pid: 1310507
Aug 18 21:13:40 sogod [1310507]: <0x0xffff88cc43c0[WOWatchDogChild]> watchdog request timeout set to 10 minutes
Aug 18 21:13:40 sogod [1310507]: <0x0xaaab067ccc20[WOWatchDog]> preparing 3 children
Aug 18 21:13:40 sogod [1310507]: <0x0xaaab067ccc20[WOWatchDog]> child spawned with pid 1310508
Aug 18 21:13:40 sogod [1310507]: <0x0xaaab067ccc20[WOWatchDog]> child spawned with pid 1310509
Aug 18 21:13:40 sogod [1310507]: <0x0xaaab067ccc20[WOWatchDog]> child spawned with pid 1310510
Aug 18 21:13:40 sogod [1310508]: <0x0xaaab066010b0[WOHttpAdaptor]> notified the watchdog that we are ready
Aug 18 21:13:40 sogod [1310509]: <0x0xaaab06636690[WOHttpAdaptor]> notified the watchdog that we are ready
Aug 18 21:13:40 sogod [1310510]: <0x0xaaab06636690[WOHttpAdaptor]> notified the watchdog that we are ready
Aug 18 21:13:58 sogod [1310510]: <0x0xaaab0695c850[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Aug 18 21:13:58 sogod [1310510]: <0x0xaaab0695c850[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
Aug 18 21:13:58 sogod [1310510]: <0x0xaaab0695c850[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Aug 18 21:13:58 sogod [1310510]: <0x0xaaab0695c850[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
Aug 18 21:13:59 sogod [1310510]: 192.168.1.147 "GET /SOGo/so/rmendoza/Mail/view HTTP/1.0" 404 208/0 0.073 - - 2M
Aug 18 21:14:05 sogod [1310510]: 192.168.1.147 "GET /SOGo/so/rmendoza/Mail/view HTTP/1.0" 404 208/0 0.012 - - 0


the GUI shows me
An error occurred during object publishing

the requested object could not be found!

Thank you, waiting on your response. I appriciated

4

Re: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

Below the sogo.log with DEBUG Enabled

Error (objc-load):/usr/lib/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: OPENSSL_init_ssl
Error (objc-load):/usr/lib/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_UIxMailSizeFormatter
Error (objc-load):/usr/lib/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: OPENSSL_init_ssl
Error (objc-load):/usr/lib/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_UIxMailSizeFormatter
Error (objc-load):/usr/lib/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: OPENSSL_init_ssl
Error (objc-load):/usr/lib/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_UIxMailSizeFormatter
Aug 18 21:46:12 sogod [1317166]: <0x0xaaaaf717eed0[WOWatchDog]> Terminating with SIGINT or SIGTERM
Aug 18 21:46:12 sogod [1317166]: <0x0xaaaaf72444c0[WOWatchDogChild]> child 1317167 exited
Aug 18 21:46:12 sogod [1317166]: <0x0xaaaaf724b710[WOWatchDogChild]> child 1317168 exited
Aug 18 21:46:12 sogod [1317166]: <0x0xaaaaf722e080[WOWatchDogChild]> child 1317169 exited
Aug 18 21:46:12 sogod [1317166]: <0x0xaaaaf717eed0[WOWatchDog]> all children exited. We now terminate.
Error (objc-load):/usr/lib/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: OPENSSL_init_ssl
Error (objc-load):/usr/lib/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_UIxMailSizeFormatter
Aug 18 21:46:12 sogod [1317208]: version 4.3.2 -- starting
Aug 18 21:46:12 sogod [1317208]: vmem size check enabled: shutting down app when vmem > 384 MB. Currently at 87 MB
Aug 18 21:46:12 sogod [1317208]: <0x0xaaaafa3e71b0[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Aug 18 21:46:12 sogod [1317208]: <0x0xaaaafa3e71b0[SOGoProductLoader]>   AdministrationUI.SOGo, MainUI.SOGo, CommonUI.SOGo, SchedulerUI.SOGo, Mailer.SOGo, MailPartViewers.SOGo, Contacts.SOGo, MailerUI.SOGo, Appointments.SOGo, ContactsUI.SOGo, PreferencesUI.SOGo
Aug 18 21:46:12 sogod [1317208]: [so-product-registry] could not load product: MailPartViewers
Aug 18 21:46:12 sogod [1317208]: [so-product-registry] could not load product: MailerUI
Aug 18 21:46:12 sogod [1317208]: All products loaded - current memory usage at 97 MB
Aug 18 21:46:12 sogod [1317208]: <0x0xaaaafa417ed0[WOWatchDog]> listening on 127.0.0.1:20000
Aug 18 21:46:12 sogod [1317208]: <0x0xaaaafa417ed0[WOWatchDog]> watchdog process pid: 1317208
Aug 18 21:46:12 sogod [1317208]: <0x0xffffbea993c0[WOWatchDogChild]> watchdog request timeout set to 10 minutes
Aug 18 21:46:12 sogod [1317208]: <0x0xaaaafa417ed0[WOWatchDog]> preparing 3 children
Aug 18 21:46:12 sogod [1317208]: <0x0xaaaafa417ed0[WOWatchDog]> child spawned with pid 1317209
Aug 18 21:46:12 sogod [1317208]: <0x0xaaaafa417ed0[WOWatchDog]> child spawned with pid 1317210
Aug 18 21:46:12 sogod [1317208]: <0x0xaaaafa417ed0[WOWatchDog]> child spawned with pid 1317211
2021-08-18 21:46:12.875 sogod[1317209:1317209] MySQL4 connection established 0x0xaaaafa50c070
2021-08-18 21:46:12.876 sogod[1317209:1317209] MySQL4 channel 0x0xaaaafa4790e0 opened (connection=0x0xaaaafa50c070,sogo)
2021-08-18 21:46:12.876 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070> SQL: SELECT count(*) FROM sogo_user_profile;
2021-08-18 21:46:12.876 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070>   query has results, entering fetch-mode.
2021-08-18 21:46:12.877 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070> SQL: SELECT count(*) FROM sogo_folder_info;
2021-08-18 21:46:12.877 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070>   query has results, entering fetch-mode.
2021-08-18 21:46:12.877 sogod[1317210:1317210] MySQL4 connection established 0x0xaaaafa50c010
2021-08-18 21:46:12.877 sogod[1317210:1317210] MySQL4 channel 0x0xaaaafa4790e0 opened (connection=0x0xaaaafa50c010,sogo)
2021-08-18 21:46:12.878 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070> SQL: SELECT count(*) FROM sogo_store;
2021-08-18 21:46:12.878 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_user_profile;
2021-08-18 21:46:12.878 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070>   query has results, entering fetch-mode.
2021-08-18 21:46:12.878 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.879 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070> SQL: SELECT count(*) FROM sogo_acl;
2021-08-18 21:46:12.879 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070>   query has results, entering fetch-mode.
2021-08-18 21:46:12.879 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070> SQL: SELECT count(*) FROM sogo_cache_folder;
2021-08-18 21:46:12.879 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070>   query has results, entering fetch-mode.
2021-08-18 21:46:12.880 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070> SQL: SELECT count(*) FROM sogo_quick_contact;
2021-08-18 21:46:12.880 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070>   query has results, entering fetch-mode.
2021-08-18 21:46:12.880 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070> SQL: SELECT count(*) FROM sogo_quick_appointment;
2021-08-18 21:46:12.880 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_folder_info;
2021-08-18 21:46:12.881 sogod[1317211:1317211] MySQL4 connection established 0x0xaaaafa50c010
2021-08-18 21:46:12.881 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.881 sogod[1317211:1317211] MySQL4 channel 0x0xaaaafa4790e0 opened (connection=0x0xaaaafa50c010,sogo)
2021-08-18 21:46:12.881 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_store;
2021-08-18 21:46:12.881 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_user_profile;
2021-08-18 21:46:12.881 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070>   query has results, entering fetch-mode.
2021-08-18 21:46:12.882 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.882 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.882 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_folder_info;
2021-08-18 21:46:12.883 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_acl;
2021-08-18 21:46:12.883 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.883 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.883 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_cache_folder;
2021-08-18 21:46:12.884 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.884 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_quick_contact;
2021-08-18 21:46:12.884 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_store;
2021-08-18 21:46:12.884 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.885 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_quick_appointment;
2021-08-18 21:46:12.885 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.885 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.886 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_acl;
2021-08-18 21:46:12.886 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070> SQL: SELECT count(*) FROM sogo_sessions_folder;
2021-08-18 21:46:12.886 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.887 sogod[1317209:1317209] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c070>   query has results, entering fetch-mode.
2021-08-18 21:46:12.887 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_cache_folder;
Aug 18 21:46:12 sogod [1317209]: <0x0xaaaafa2ce790[WOHttpAdaptor]> notified the watchdog that we are ready
2021-08-18 21:46:12.887 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.888 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_quick_contact;
2021-08-18 21:46:12.888 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.889 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_quick_appointment;
2021-08-18 21:46:12.889 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:46:12.889 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_sessions_folder;
2021-08-18 21:46:12.890 sogod[1317210:1317210] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
Aug 18 21:46:12 sogod [1317210]: <0x0xaaaafa316a30[WOHttpAdaptor]> notified the watchdog that we are ready
2021-08-18 21:46:12.893 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_sessions_folder;
2021-08-18 21:46:12.893 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
Aug 18 21:46:12 sogod [1317211]: <0x0xaaaafa316ad0[WOHttpAdaptor]> notified the watchdog that we are ready
2021-08-18 21:46:12.893 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT count(*) FROM sogo_sessions_folder;
2021-08-18 21:46:12.893 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
Aug 18 21:46:12 sogod [1317211]: <0x0xaaaafa316ad0[WOHttpAdaptor]> notified the watchdog that we are ready
Aug 18 21:48:32 sogod [1317211]: |SOGo| starting method 'GET' on uri '/SOGo/so/rmendoza/Mail/view'
Aug 18 21:48:32 sogod [1317211]: <0x0xaaaafa548180[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Aug 18 21:48:32 sogod [1317211]: <0x0xaaaafa548180[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
2021-08-18 21:48:32.160 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: BEGIN;
2021-08-18 21:48:32.161 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has no results.
2021-08-18 21:48:32.161 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM  sogo_sessions_folder t1 WHERE t1.c_id='cUHXWJ2z3d6MXbEyvDeBQw==';
2021-08-18 21:48:32.162 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:48:32.163 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: ROLLBACK;
2021-08-18 21:48:32.163 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has no results.
2021-08-18 21:48:32.167 sogod[1317211:1317211] MySQL4 connection established 0x0xaaaafa557a70
2021-08-18 21:48:32.167 sogod[1317211:1317211] MySQL4 channel 0x0xaaaafa55a510 opened (connection=0x0xaaaafa557a70,sogo)
2021-08-18 21:48:32.167 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70> SQL: BEGIN;
2021-08-18 21:48:32.167 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70>   query has no results.
2021-08-18 21:48:32.168 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70> SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM  sogo_sessions_folder t1 WHERE t1.c_id='cUHXWJ2z3d6MXbEyvDeBQw==';
2021-08-18 21:48:32.168 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70>   query has results, entering fetch-mode.
2021-08-18 21:48:32.168 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70> SQL: ROLLBACK;
2021-08-18 21:48:32.169 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70>   query has no results.
2021-08-18 21:48:32.169 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: BEGIN;
2021-08-18 21:48:32.169 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has no results.
2021-08-18 21:48:32.170 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: UPDATE sogo_sessions_folder SET c_lastseen = 1629348512, c_creationdate = 1629341938, c_value = 'FATIw/Kl7hDyHj6Nv9oTiuqZ9RFxm1SFq+B8D5aGiiyoe5w028vkyWLoMmrECnkM0DwwemS4kvNCeECqc2A2UkmYOnGUaF60B5E/p2tm4pVXHwXXYC/e/1/cAkL5TszIiCuPCJFIXby07Bx+9ddy3XIH907QkdxsgyioSgHg+iSyZ5G5t+gpTB24umHGzm7wKwc/wxBNaCfWhk+YceD3cg==', c_id = 'cUHXWJ2z3d6MXbEyvDeBQw==' WHERE c_id='cUHXWJ2z3d6MXbEyvDeBQw==';
2021-08-18 21:48:32.171 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has no results.
2021-08-18 21:48:32.171 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: COMMIT;
2021-08-18 21:48:32.218 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has no results.
2021-08-18 21:48:32.220 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70> SQL: SELECT c_password FROM sogo_users WHERE c_uid = 'rmendoza';
2021-08-18 21:48:32.220 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70>   query has results, entering fetch-mode.
2021-08-18 21:48:32.228 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT * FROM sogo_users WHERE (c_uid = 'rmendoza') OR (mail = 'rmendoza');
2021-08-18 21:48:32.229 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:48:32.233 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70> SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'rmendoza';
2021-08-18 21:48:32.234 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70>   query has results, entering fetch-mode.
2021-08-18 21:48:32.235 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'rmendoza';
2021-08-18 21:48:32.235 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa4790e0] connection=0x0xaaaafa50c010>   query has results, entering fetch-mode.
2021-08-18 21:48:32.236 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70> SQL: SELECT * FROM sogo_users WHERE (c_uid = 'rmendoza') OR (mail = 'rmendoza');
2021-08-18 21:48:32.236 sogod[1317211:1317211] <MySQL4Channel[0x0xaaaafa55a510] connection=0x0xaaaafa557a70>   query has results, entering fetch-mode.
Aug 18 21:48:32 sogod [1317211]: |SOGo| request took 0.083734 seconds to execute
Aug 18 21:48:32 sogod [1317211]: 192.168.1.147 "GET /SOGo/so/rmendoza/Mail/view HTTP/1.0" 404 208/0 0.089 - - 1M

i hope that helps to resolve my issue - thanks

5

Re: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

Try this: Delete this user first, then re-create it with iRedAdmin(-Pro).

6

Re: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

instead of removing the client account, i have created a new one same results still no view from the GUI still missing objects as per 404 code

response from gui
An error occurred during object publishing
the requested object could not be found!

sogo.log error below
Aug 19 12:55:44 sogod [1318154]: 192.168.1.147 "POST /SOGo/connect HTTP/1.0" 403 34/67 0.005 - - 0
Aug 19 13:00:36 sogod [1318154]: SOGoRootPage successful login from '192.168.1.147' for user 'fncbot68' - expire = -1  grace = -1
Aug 19 13:00:36 sogod [1318154]: [WARN] <0x0xaaaafffb07a0[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
Aug 19 13:00:36 sogod [1318154]: [WARN] <0x0xaaaafffb07a0[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
Aug 19 13:00:36 sogod [1318154]: [WARN] <0x0xaaaafffb07a0[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
Aug 19 13:00:36 sogod [1318154]: 192.168.1.147 "POST /SOGo/connect HTTP/1.0" 200 52/67 0.051 - - 0
Aug 19 13:00:37 sogod [1318154]: 192.168.1.147 "GET /SOGo/fncbot68 HTTP/1.0" 302 0/0 0.008 - - 0
Aug 19 13:00:37 sogod [1318154]: 192.168.1.147 "GET /SOGo/fncbot68/view HTTP/1.0" 302 0/0 0.042 - - 0
Aug 19 13:00:51 sogod [1318154]: 192.168.1.147 "GET /SOGo/so/fncbot68/Mail HTTP/1.0" 302 0/0 0.119 - - 0
Aug 19 13:00:51 sogod [1318154]: 192.168.1.147 "GET /SOGo/so/fncbot68/Mail/view HTTP/1.0" 404 208/0 0.023 - - 0
Aug 19 13:01:44 sogod [1318154]: 192.168.1.147 "GET /SOGo/so/fncbot68/Mail/view HTTP/1.0" 404 208/0 0.010 - - 0

7

Re: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

"404" error looks like normal.
Did you login with full email address or just the username part in email address?

8

Re: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

Topic: SOGo MySQL connection
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 1.6.4 MARIADB edition.
- Linux/BSD distribution name and version: Debian 11.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): 10.5.19-MariaDB
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue: userPasswordAlgorithm = md5
====


2023-07-31 09:38:09.760 sogod[4953:4953] MySQL4 connection established 0x0x564cdcad60f0
2023-07-31 09:38:09.760 sogod[4953:4953] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x564cdccc6620] connection=0x0x564cdcad60f0> opens channel count[0]
2023-07-31 09:38:09.760 sogod[4953:4953] MySQL4 channel 0x0x564cdccc6620 opened (connection=0x0x564cdcad60f0,sogo)
2023-07-31 09:38:09.760 sogod[4953:4953] <MySQL4Channel[0x0x564cdccc6620] connection=0x0x564cdcad60f0> SQL: SELECT c_password FROM users WHERE c_uid = 'daniel@xxxx.com.cn';
2023-07-31 09:38:09.761 sogod[4953:4953] <MySQL4Channel[0x0x564cdccc6620] connection=0x0x564cdcad60f0>   query has results, entering fetch-mode.
Jul 31 09:38:09 sogod [4953]: SOGoRootPage Login from '192.168.0.12' for user 'daniel@xxxxx.com.cn' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
Jul 31 09:38:09 sogod [4953]: |SOGo| request took 0.003477 seconds to execute

9

Re: SOGo issues with user loging to GUI - password policy: 65535 grace: -1

open a own thread