Hi Kenren,
skip-name-resolve is alraedy commented out.
Richard
Am 21.07.2023 um 02:13 schrieb Kenren Taisho (toushin.tai...@gmail.com):
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>
<mailto: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
<http://127.0.0.1:3306/sogo/sogo_user_profile>"; << and I have
verified that mariadb is actually listening to 127.0.0.1:3306
<http://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.