[SOGo] SOGo no longer talking to mysql

[Richard Rosner]

Hi,





   Jul 20 15:53:10 sogod [73521]: <0x0x7fb00f4b7340[WOWatchDogChild]>
   watchdog request timeout set to 10 minutes
   Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]>
   preparing 3 children
   Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child
   spawned with pid 73522
   Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child
   spawned with pid 73523
   Jul 20 15:53:10 sogod [73521]: <0x0x55bdab397b90[WOWatchDog]> child
   spawned with pid 73524
   2023-07-20 15:53:10.948 sogod[73523:73523] ERROR: could not open
   MySQL4 connection to database 'sogo': Access denied for user
   'sogo'@'localhost' (using password: YES)
   Jul 20 15:53:10 sogod [73523]: [ERROR]
   <0x0x55bdab3912c0[GCSChannelManager]> could not open channel
   <MySQL4Channel[0x0x55bdab4766e0] connection=0x(null)> for
   mysql://localhost/sogo/sogo_user_profile
   Jul 20 15:53:10 sogod [73523]: [WARN]
   <0x0x55bdab3912c0[GCSChannelManager]>   will prevent opening of this
   channel 5 seconds after 2023-07-20 15:53:10 +0200
   2023-07-20 15:53:10.948 sogod[73524:73524] ERROR: could not open
   MySQL4 connection to database 'sogo': Access denied for user
   'sogo'@'localhost' (using password: YES)
   2023-07-20 15:53:10.948 sogod[73522:73522] ERROR: could not open
   MySQL4 connection to database 'sogo': Access denied for user
   'sogo'@'localhost' (using password: YES)
   Jul 20 15:53:10 sogod [73522]: [ERROR]
   <0x0x55bdab390df0[GCSChannelManager]> could not open channel
   <MySQL4Channel[0x0x55bdab4766e0] connection=0x(null)> for
   mysql://localhost/sogo/sogo_user_profile
   Jul 20 15:53:10 sogod [73524]: [ERROR]
   <0x0x55bdab373020[GCSChannelManager]> could not open channel
   <MySQL4Channel[0x0x55bdab4766e0] connection=0x(null)> for
   mysql://localhost/sogo/sogo_user_profile
   Jul 20 15:53:10 sogod [73522]: [WARN]
   <0x0x55bdab390df0[GCSChannelManager]>   will prevent opening of this
   channel 5 seconds after 2023-07-20 15:53:10 +0200
   Jul 20 15:53:10 sogod [73524]: [WARN]
   <0x0x55bdab373020[GCSChannelManager]>   will prevent opening of this
   channel 5 seconds after 2023-07-20 15:53:10 +0200
   Jul 20 15:53:11 sogod [73522]: <0x0x55bdab1b0510[WOHttpAdaptor]>
   notified the watchdog that we are ready
   Jul 20 15:53:11 sogod [73523]: <0x0x55bdab589fc0[WOHttpAdaptor]>
   notified the watchdog that we are ready
   Jul 20 15:53:11 sogod [73524]: <0x0x55bdab589050[WOHttpAdaptor]>
   notified the watchdog that we are ready

I had to reinstall SOGo because for some strange reason it just refused to accept any changes to the config. Now for some reason it can't connect to mysql anymore. In the sogo.conf I have e.g. >> SOGoProfileURL = "mysql://sogo:/password/@127.0.0.1:3306/sogo/sogo_user_profile"; << and I have verified that mariadb is actually listening to 127.0.0.1:3306. But when I restart SOGo to activate the config, I get So of course I tried logging in manually to mysql, but this succedes without any complaints. Now what's the problem with it? I'm using mariadb-server 10.11.3.

smime.p7s
Description: S/MIME Cryptographic Signature