Hi Richard, ERROR: could not open MySQL4 connection to database 'sogo': Access denied > for user 'sogo'@'localhost' (using password: YES)
Could you check if skip-name-resolve is enabled in your MySQL config? And if is, remove it, restart MySQL, and see if SOGo is communicating again with MySQL. Kind regards On Fri, Jul 21, 2023 at 12:03 AM Richard Rosner <users@sogo.nu> wrote: > Hi Quentin, > > I didn't only not change the password, I even made double sure the user > still had all permissions for the database in question. And like I said, I > did try username and password manually, which did work. > > I enabled MySQL4DebugEnabled, but outout doesn't seem to have changed: > > > Jul 20 17:41:15 sogod [79585]: <0x0x7f8a1a4b7340[WOWatchDogChild]> > watchdog request timeout set to 10 minutes > Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> preparing 3 > children > Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child > spawned with pid 79586 > Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child > spawned with pid 79587 > Jul 20 17:41:15 sogod [79585]: <0x0x55ce03e91c70[WOWatchDog]> child > spawned with pid 79588 > 2023-07-20 17:41:16.020 sogod[79588:79588] ERROR: could not open MySQL4 > connection to database 'sogo': Access denied for user 'sogo'@'localhost' > (using password: YES) > Jul 20 17:41:16 sogod [79588]: [ERROR] > <0x0x55ce03f47520[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x55ce03f707c0] connection=0x(null)> for > mysql://localhost/sogo/sogo_user_profile > Jul 20 17:41:16 sogod [79588]: [WARN] > <0x0x55ce03f47520[GCSChannelManager]> will prevent opening of this > channel 5 seconds after 2023-07-20 17:41:15 +0200 > 2023-07-20 17:41:16.026 sogod[79587:79587] ERROR: could not open MySQL4 > connection to database 'sogo': Access denied for user 'sogo'@'localhost' > (using password: YES) > Jul 20 17:41:16 sogod [79587]: [ERROR] > <0x0x55ce03e5a8c0[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x55ce03f707c0] connection=0x(null)> for > mysql://localhost/sogo/sogo_user_profile > Jul 20 17:41:16 sogod [79587]: [WARN] > <0x0x55ce03e5a8c0[GCSChannelManager]> will prevent opening of this > channel 5 seconds after 2023-07-20 17:41:15 +0200 > 2023-07-20 17:41:16.034 sogod[79586:79586] ERROR: could not open MySQL4 > connection to database 'sogo': Access denied for user 'sogo'@'localhost' > (using password: YES) > Jul 20 17:41:16 sogod [79586]: [ERROR] > <0x0x55ce03e56270[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x55ce03f707c0] connection=0x(null)> for > mysql://localhost/sogo/sogo_user_profile > Jul 20 17:41:16 sogod [79586]: [WARN] > <0x0x55ce03e56270[GCSChannelManager]> will prevent opening of this > channel 5 seconds after 2023-07-20 17:41:15 +0200 > Jul 20 17:41:16 sogod [79588]: <0x0x55ce04083130[WOHttpAdaptor]> notified > the watchdog that we are ready > Jul 20 17:41:16 sogod [79587]: <0x0x55ce040840a0[WOHttpAdaptor]> notified > the watchdog that we are ready > Jul 20 17:41:16 sogod [79586]: <0x0x55ce04087de0[WOHttpAdaptor]> notified > the watchdog that we are ready > > > Richard > > Am 20.07.2023 um 17:08 schrieb qhivert (qhiv...@alinto.eu): > > Hello Richard, > Strange indeed. I assume you didn’t change the sogo.conf nor the password > between? > Is this the log with the param *MySQL4DebugEnabled = YES* in your > sogo.conf? If not could you add it and show us the logs? > > Regards, > Quentin > > > > *From:* users-requ...@sogo.nu <users-requ...@sogo.nu> > <users-requ...@sogo.nu> *On Behalf Of *Richard Rosner > *Sent:* jeudi 20 juillet 2023 16:23 > *To:* users@sogo.nu > *Subject:* [SOGo] SOGo no longer talking to mysql > > > > Hi, > > 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 > > > > 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 > > 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. > >
