View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005735SOGoGUIpublic2023-04-11 03:552023-04-19 11:29
Reporterghorchem Assigned Tosebastien  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionwon't fix 
Platform[Server] LinuxOSUbuntuOS Version16.04 LTS
Product Version5.8.2 
Summary0005735: blank Calendar and Contacts page in webmail, mysql issues
Description

Hello I have installed version 5.8.2 on Ubuntu 22.04 when i login and try to read an e-mail mess it either shows a blank popup or sql code. also the calendar and contacts page are blank. in my log file the error: sogod [2139]: [ERROR] <0x0x560f193aebe0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null) is show quite a bit as well.

Steps To Reproduce

sogod [2139]: [ERROR] <0x0x560f193aebe0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)

Tagswebmail

Activities

ghorchem

ghorchem

2023-04-11 20:29

reporter   ~0016819

Log file errors:

Apr 11 06:04:49 sogod [3046]: version 5.8.2 (build @d39ee0f6f583 202304102310) -- starting
Apr 11 06:04:49 sogod [3046]: vmem size check enabled: shutting down app when vmem > 384 MB. Currently at 88 MB
Apr 11 06:04:50 sogod [3046]: <0x0x55a248bd8290[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Apr 11 06:04:50 sogod [3046]: <0x0x55a248bd8290[SOGoProductLoader]> PreferencesUI.SOGo, ActiveSync.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, AdministrationUI.SOGo, SchedulerUI.SOGo, Mailer.SOGo, CommonUI.SOGo, Contacts.SOGo, Appointments.SOGo, MainUI.SOGo, ContactsUI.SOGo
Apr 11 06:04:50 sogod [3046]: All products loaded - current memory usage at 98 MB
Apr 11 06:04:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> listening on 127.0.0.1:20000
Apr 11 06:04:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> watchdog process pid: 3046
Apr 11 06:04:50 sogod [3046]: <0x0x7f98d04bb360[WOWatchDogChild]> watchdog request timeout set to 10 minutes
Apr 11 06:04:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> preparing 3 children
Apr 11 06:04:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> child spawned with pid 3049
Apr 11 06:04:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> child spawned with pid 3050
Apr 11 06:04:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> child spawned with pid 3051
2023-04-11 06:04:50.561 sogod[3050:3050] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
2023-04-11 06:04:50.561 sogod[3051:3051] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
2023-04-11 06:04:50.561 sogod[3049:3049] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
Apr 11 06:04:50 sogod [3051]: <0x0x55a248e3c520[WOHttpAdaptor]> notified the watchdog that we are ready
Apr 11 06:04:50 sogod [3050]: <0x0x55a248e3c520[WOHttpAdaptor]> notified the watchdog that we are readyApr 11 06:04:50 sogod [3049]: <0x0x55a248e3c520[WOHttpAdaptor]> notified the watchdog that we are ready

Apr 11 13:16:32 sogod [3049]: |SOGo| starting method 'GET' on uri '/SOGo/'
Apr 11 13:16:32 sogod [3049]: <0x0x55a248dd79a0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Apr 11 13:16:32 sogod [3049]: <0x0x55a248dd79a0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
Apr 11 13:16:32 sogod [3049]: [WARN] <0x0x7f98d04dcaa0[WOxElemBuilder]> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: |SOGo| constructed root-url: /SOGo/
Apr 11 13:16:32 sogod [3049]: |SOGo| setting root-url in context: /SOGo/
Apr 11 13:16:32 sogod [3049]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: [ERROR] <0x0x55a248ffed40[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 13:16:32 sogod [3049]: |SOGo| request took 0.062682 seconds to execute
Apr 11 13:16:32 sogod [3049]: 192.168.2.1 "GET /SOGo/ HTTP/1.1" 200 38713/0 0.064 - - 6M - 11
Apr 11 14:52:47 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:47 sogod [3046]: <0x0x55a248cd1dd0[WOWatchDogChild]> sending terminate signal to pid 3051
Apr 11 14:52:47 sogod [3046]: <0x0x55a248cd2860[WOWatchDogChild]> sending terminate signal to pid 3050
Apr 11 14:52:47 sogod [3046]: <0x0x55a248cd2960[WOWatchDogChild]> sending terminate signal to pid 3049
Apr 11 14:52:48 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:48 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:49 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:49 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 14:52:50 sogod [3046]: <0x0x55a248cd2860[WOWatchDogChild]> child 3050 exited
Apr 11 14:52:50 sogod [3046]: <0x0x55a248cd2960[WOWatchDogChild]> child 3049 exited
Apr 11 14:52:50 sogod [3046]: <0x0x55a248cd1dd0[WOWatchDogChild]> child 3051 exited
Apr 11 14:52:50 sogod [3046]: <0x0x55a248c19e50[WOWatchDog]> all children exited. We now terminate.
Apr 11 14:52:53 sogod [29961]: version 5.8.2 (build @d39ee0f6f583 202304102310) -- starting
Apr 11 14:52:53 sogod [29961]: vmem size check enabled: shutting down app when vmem > 384 MB. Currently at 88 MB
Apr 11 14:52:53 sogod [29961]: <0x0x55c4e9e27480[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Apr 11 14:52:53 sogod [29961]: <0x0x55c4e9e27480[SOGoProductLoader]> PreferencesUI.SOGo, ActiveSync.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, AdministrationUI.SOGo, SchedulerUI.SOGo, Mailer.SOGo, CommonUI.SOGo, Contacts.SOGo, Appointments.SOGo, MainUI.SOGo, ContactsUI.SOGo
Apr 11 14:52:53 sogod [29961]: All products loaded - current memory usage at 98 MB
Apr 11 14:52:53 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> listening on 127.0.0.1:20000
Apr 11 14:52:53 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> watchdog process pid: 29961
Apr 11 14:52:53 sogod [29961]: <0x0x7f2cf0ebb360[WOWatchDogChild]> watchdog request timeout set to 10 minutes
Apr 11 14:52:53 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> preparing 3 children
Apr 11 14:52:53 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> child spawned with pid 29963
Apr 11 14:52:53 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> child spawned with pid 29964
Apr 11 14:52:53 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> child spawned with pid 29965
2023-04-11 14:52:53.559 sogod[29963:29963] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
Apr 11 14:52:53 sogod [29963]: <0x0x55c4ea08b710[WOHttpAdaptor]> notified the watchdog that we are ready
2023-04-11 14:52:53.560 sogod[29964:29964] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
Apr 11 14:52:53 sogod [29964]: <0x0x55c4ea08b710[WOHttpAdaptor]> notified the watchdog that we are ready
2023-04-11 14:52:53.561 sogod[29965:29965] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
Apr 11 14:52:53 sogod [29965]: <0x0x55c4ea08b710[WOHttpAdaptor]> notified the watchdog that we are ready
Apr 11 14:53:04 sogod [29965]: |SOGo| starting method 'GET' on uri '/SOGo/'
Apr 11 14:53:04 sogod [29965]: <0x0x55c4ea012a70[SOGoCache]> Cache cleanup interval set every 3600.000000 seconds
Apr 11 14:53:04 sogod [29965]: <0x0x55c4ea012a70[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
Apr 11 14:53:04 sogod [29965]: [WARN] <0x0x7f2cf0edcaa0[WOxElemBuilder]> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 14:53:04 sogod [29965]: [ERROR] <0x0x55c4ea24b410[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
2023-04-11 14:53:04.193 sogod[29965:29965] EXCEPTION: <NSException: 0x55c4ea18a720> NAME:NSGenericException REASON:private key file '/etc/sogo/saml.pem' could not be read INFO:(null)
Apr 11 14:53:04 sogod [29965]: |SOGo| request took 0.032018 seconds to execute
Apr 11 14:53:04 sogod [29965]: 192.168.2.2 "GET /SOGo/ HTTP/1.1" 501 0/0 0.035 - - 9M - 11
Apr 11 14:53:12 sogod [29965]: |SOGo| starting method 'GET' on uri '/SOGo/'
2023-04-11 14:53:12.614 sogod[29965:29965] EXCEPTION: <NSException: 0x55c4ea1a2dd0> NAME:NSGenericException REASON:private key file '/etc/sogo/saml.pem' could not be read INFO:(null)
Apr 11 14:53:12 sogod [29965]: |SOGo| request took 0.000583 seconds to execute
Apr 11 14:53:12 sogod [29965]: 192.168.2.2 "GET /SOGo/ HTTP/1.1" 501 0/0 0.001 - - 0 - 11
Apr 11 14:58:54 sogod [29965]: |SOGo| starting method 'GET' on uri '/SOGo/'
2023-04-11 14:58:54.935 sogod[29965:29965] EXCEPTION: <NSException: 0x55c4ea194a90> NAME:NSGenericException REASON:private key file '/etc/sogo/saml.pem' could not be read INFO:(null)
Apr 11 14:58:54 sogod [29965]: |SOGo| request took 0.000597 seconds to execute
Apr 11 14:58:54 sogod [29965]: 192.168.2.2 "GET /SOGo/ HTTP/1.1" 501 0/0 0.001 - - 92K - 11
Apr 11 15:05:20 sogod [29965]: |SOGo| starting method 'GET' on uri '/SOGo/'
2023-04-11 15:05:20.479 sogod[29965:29965] EXCEPTION: <NSException: 0x55c4ea194860> NAME:NSGenericException REASON:private key file '/etc/sogo/saml.pem' could not be read INFO:(null)
Apr 11 15:05:20 sogod [29965]: |SOGo| request took 0.000890 seconds to execute
Apr 11 15:05:20 sogod [29965]: 192.168.2.2 "GET /SOGo/ HTTP/1.1" 501 0/0 0.002 - - 0 - 11
Apr 11 15:15:12 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:12 sogod [29961]: <0x0x55c4e9f43ec0[WOWatchDogChild]> sending terminate signal to pid 29965
Apr 11 15:15:12 sogod [29961]: <0x0x55c4e9fc2160[WOWatchDogChild]> sending terminate signal to pid 29964
Apr 11 15:15:12 sogod [29961]: <0x0x55c4e9fee1b0[WOWatchDogChild]> sending terminate signal to pid 29963
Apr 11 15:15:12 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:13 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:13 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:14 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:14 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:15 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:15 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:16 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:16 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:17 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:17 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:18 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:18 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:19 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:19 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:20 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:20 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:21 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:21 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:22 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:22 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:23 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:23 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:23 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:23 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> Terminating with SIGINT or SIGTERM
Apr 11 15:15:23 sogod [29961]: <0x0x55c4e9fee1b0[WOWatchDogChild]> child 29963 exited
Apr 11 15:15:23 sogod [29961]: <0x0x55c4e9fc2160[WOWatchDogChild]> child 29964 exited
Apr 11 15:15:23 sogod [29961]: <0x0x55c4e9f43ec0[WOWatchDogChild]> child 29965 exited
Apr 11 15:15:23 sogod [29961]: <0x0x55c4e9e69040[WOWatchDog]> all children exited. We now terminate.
Apr 11 15:15:26 sogod [39316]: version 5.8.2 (build @d39ee0f6f583 202304102310) -- starting
Apr 11 15:15:26 sogod [39316]: vmem size check enabled: shutting down app when vmem > 384 MB. Currently at 88 MB
Apr 11 15:15:26 sogod [39316]: <0x0x5606bc893940[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Apr 11 15:15:26 sogod [39316]: <0x0x5606bc893940[SOGoProductLoader]> PreferencesUI.SOGo, ActiveSync.SOGo, MailerUI.SOGo, MailPartViewers.SOGo, AdministrationUI.SOGo, SchedulerUI.SOGo, Mailer.SOGo, CommonUI.SOGo, Contacts.SOGo, Appointments.SOGo, MainUI.SOGo, ContactsUI.SOGo
Apr 11 15:15:26 sogod [39316]: All products loaded - current memory usage at 98 MB
Apr 11 15:15:26 sogod [39316]: <0x0x5606bc8d5500[WOWatchDog]> listening on 127.0.0.1:20000
Apr 11 15:15:26 sogod [39316]: <0x0x5606bc8d5500[WOWatchDog]> watchdog process pid: 39316
Apr 11 15:15:26 sogod [39316]: <0x0x7fd6412bb360[WOWatchDogChild]> watchdog request timeout set to 10 minutes
Apr 11 15:15:26 sogod [39316]: <0x0x5606bc8d5500[WOWatchDog]> preparing 3 children
Apr 11 15:15:26 sogod [39316]: <0x0x5606bc8d5500[WOWatchDog]> child spawned with pid 39348
Apr 11 15:15:26 sogod [39316]: <0x0x5606bc8d5500[WOWatchDog]> child spawned with pid 39350
Apr 11 15:15:26 sogod [39316]: <0x0x5606bc8d5500[WOWatchDog]> child spawned with pid 39352
2023-04-11 15:15:26.638 sogod[39348:39348] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
Apr 11 15:15:26 sogod [39348]: <0x0x5606bcaf7bd0[WOHttpAdaptor]> notified the watchdog that we are ready
2023-04-11 15:15:26.639 sogod[39350:39350] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
Apr 11 15:15:26 sogod [39350]: <0x0x5606bcaf7bd0[WOHttpAdaptor]> notified the watchdog that we are ready
2023-04-11 15:15:26.639 sogod[39352:39352] ERROR(+[GCSFolderManager defaultFolderManager]): default 'OCSFolderInfoURL' is not a valid URL: 'mysql://sogo:gOldfloor59?9835236!@127.0.0.1:3306/sogo/sogo_folder_info'
Apr 11 15:15:26 sogod [39352]: <0x0x5606bcaf7bd0[WOHttpAdaptor]> notified the watchdog that we are ready
Apr 11 15:15:41 sogod [39352]: |SOGo| starting method 'GET' on uri '/SOGo/'
Apr 11 15:15:41 sogod [39352]: <0x0x5606bca7ef30[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Apr 11 15:15:41 sogod [39352]: <0x0x5606bca7ef30[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
Apr 11 15:15:41 sogod [39352]: [WARN] <0x0x7fd6412dcaa0[WOxElemBuilder]> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: |SOGo| constructed root-url: /SOGo/
Apr 11 15:15:41 sogod [39352]: |SOGo| setting root-url in context: /SOGo/
Apr 11 15:15:41 sogod [39352]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: [ERROR] <0x0x5606bccb7cc0[SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
Apr 11 15:15:41 sogod [39352]: |SOGo| request took 0.050889 seconds to execute
Apr 11 15:15:41 sogod [39352]: 192.168.2.2 "GET /SOGo/ HTTP/1.1" 200 38713/0 0.053 - - 6M - 11
ghorchem

ghorchem

2023-04-12 13:17

reporter   ~0016821

I think there my be issues with MySQL connecting to it. MySQL SSL is disabled. They both are hosted on a Ubuntu 22.04 Jammy LTS server.
ghorchem

ghorchem

2023-04-13 15:54

reporter   ~0016822

I configured Sogo tor try to connect to the database using a socket connect still no luck.

/ Database configuration (mysql://, postgresql:// or oracle://) /
MySQL4Encoding = "utf8mb4";
SOGoProfileURL = "mysql://sogo:maskedpassword@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_user_profile";
OCSFolderInfoURL = "mysql://sogo:maskedpassword@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_folder_info";
OCSSessionsFolderURL = "mysql://sogo:maskedpassword@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL = "mysql://sogo:maskedpassword@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_alarms_folder";
OCSStoreURL = "mysql://sogo:maskedpassword@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_store";
OCSAclURL = "mysql://sogo:maskedpassword@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_acl";
OCSCacheFolderURL = "mysql://sogo:maskedpassword@%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock/sogo/sogo_cache_folder";

//SAML configuration

// SOGoCacheCleanupInterval = 3600;
// SOGoAuthenticationType = saml2;
// NGImap4AuthMechanism = PLAIN;
// SOGoSAML2PrivateKeyLocation = "/etc/sogo/saml.pem";
// SOGoSAML2CertificateLocation = "/etc/sogo/saml.crt";
// SOGoSAML2IdpMetadataLocation = "/etc/sogo/idp-metadata.xml";
// SOGoSAML2IdpPublicKeyLocation = "/etc/sogo/idp.key";
// SOGoSAML2IdpCertificateLocation = "/etc/sogo/idp.crt";
// SOGoSAML2LoginAttribute = "mail";
// SOGoSAML2LogoutEnabled = YES;
// SOGoSAML2LogoutURL = "https://webmail.gary-springfield-mo.net/SOGo/&quot;;

/ Mail /
SOGoDraftsFolderName = Drafts;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoJunkFolderName = Junk;
SOGoIMAPServer = "imap://127.0.0.1";
//SOGoSieveServer = "sieve://127.0.0.1:4190";
SOGoSMTPServer = "smtp://127.0.0.1";
SOGoMailDomain = gary-springfield-mo.net;
SOGoMailingMechanism = smtp;
SOGoForceExternalLoginWithEmail = NO;
SOGoMailSpoolPath = /var/spool/sogo;
NGImap4AuthMechanism = "plain";
NGImap4ConnectionStringSeparator = "/";
SOGoMaximumMessageSizeLimit = 30000;

/ Notifications /
SOGoAppointmentSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;

/ Authentication /
SOGoPasswordChangeEnabled = NO;

/ LDAP AD/Samba4 example /
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
UIDFieldName = sAMAccountName;
baseDN = "CN=users,dc=msp,dc=gary-springfield-mo,dc=net";
bindDN = "CN=administrator,CN=users,DC=msp,DC=gary-springfield-mo,DC=net";
bindFields = (sAMAccountName, mail);
bindPassword = maskedpassword
canAuthenticate = YES;
displayName = "Public";
hostname = "ldap://server-1.msp.gary-springfield-mo.net:389/????!StartTLS";
filter = "mail = '*'";
id = directory;
isAddressBook = NO;
passwordPolicy = NO;
}
);

/ Web Interface /
SOGoPageTitle = SOGo;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = NO;
SOGoSieveScriptsEnabled = NO;
SOGoMailAuxiliaryUserAccountsEnabled = NO;
SOGoTrustProxyAuthentication = YES;
SOGoXSRFValidationEnabled = YES;
SOGoDefaultCalendar = personal;
SOGoDayStartTime = 8;
SOGoDayEndTime = 5;
SOGoFirstDayOfWeek = 0;
SOGoFirstWeekOfYear = January1;
SOGoMailMessageForwarding = inline;
SOGoMailReplyPlacement = below;
SOGoLanguage = English;
SOGoTimeZone = America/Chicago;
SOGoCalendarDefaultRoles = (
PublicDAndTViewer,
ConfidentialDAndTViewer
);
SOGoSuperUsernames = (sogo_user); // This is an array - keep the parens!
SxVMemLimit = 384;
WOPidFile = "/var/run/sogo/sogo.pid";
SOGoMemcachedHost = "127.0.0.1";
WOWorkersCount = "20";

/ Debug /
SOGoDebugRequests = YES;
SoDebugBaseURL = YES;
ImapDebugEnabled = YES;
LDAPDebugEnabled = YES;
PGDebugEnabled = YES;
MySQL4DebugEnabled = YES;
SOGoUIxDebugEnabled = YES;
WODontZipResponse = YES;
WOLogFile = /var/log/sogo/sogo.log;
}
sebastien

sebastien

2023-04-18 07:12

administrator   ~0016844

Duplicate 0005738 ?
sebastien

sebastien

2023-04-19 11:29

administrator   ~0016852

Closed due to inactivity

Issue History

Date Modified Username Field Change
2023-04-11 03:55 ghorchem New Issue
2023-04-11 03:55 ghorchem Tag Attached: webmail
2023-04-11 20:29 ghorchem Note Added: 0016819
2023-04-12 13:17 ghorchem Note Added: 0016821
2023-04-13 15:54 ghorchem Note Added: 0016822
2023-04-18 07:12 sebastien Note Added: 0016844
2023-04-18 07:12 sebastien Assigned To => sebastien
2023-04-18 07:12 sebastien Status new => feedback
2023-04-19 11:29 sebastien Status feedback => closed
2023-04-19 11:29 sebastien Resolution open => won't fix
2023-04-19 11:29 sebastien Note Added: 0016852