[SOLVED] ERROR after update 22/10/21

noplan · 2021-10-22T13:07:20+00:00

baseline: Die folgenden 6 Pakete werden aktualisiert: grommunio-admin-web gromox gromox-debuginfo gromox-debugsource libexmdbpp0 python3-pyexmdb rpm -q...

noplan

on my way sir !

noplan

2021/10/22 17:31:44 [data_source]: Failed to connect to mysql server, reason: Can't connect to local MySQL server through socket '/run/mysql/mysql.sock' (2)

noplan

HOLD MY BEER .... rollin back some config tests ....
time to do reboot ... 17:45

gromm:~ # systemctl --failed
UNIT LOAD ACTIVE SUB DESCRIPTION
0 loaded units listed.

still:

tail -f /var/log/mysql/mysqld.log
2021-10-22 17:49:29 41 [Warning] Access denied for user 'gromm'@'localhost' (using password: NO)

tail -f /var/log/gromox/sa.log
2021/10/22 17:50:01 [data_source]: Failed to connect to mysql server, reason: Access denied for user 'gromm'@'localhost' (using password: NO)

I was pretty sure @mwilliams that i got rid of those error messages in the past !
gonna look ... password / passwd / passwort ? ;)

mwilliams

noplan https://community.grommunio.com/d/83-mail-is-not-delivered-to-user-not-shwowing-up-in-inbox/10

mwilliams

noplan

2021-10-22 17:49:29 41 [Warning] Access denied for user 'gromm'@'localhost' (using password: NO)

2021/10/22 17:50:01 [data_source]: Failed to connect to mysql server, reason: Access denied for user 'gromm'@'localhost' (using password: NO)

what this shows is that (whatever service you are using) is not using password authentication. Since it is assumed the user "gromm" has a password (btw: not a default user created by the appliance), it is not trying to use the password for the authentication.

Maybe some (incomplete) though misconfigured postfix file trying authentication without password in your setup?

noplan

mwilliams

yes ture but i thought the error was gone after edit the my.cnf
socket = /run/mysql/mysql.sock
as find / -type s | grep my tells us

WalterH

I have the same update installed but no error in both log files.
Is your /etc/gromox/adaptor.cfg file setup correctly (user name and password)?

noplan

WalterH

mysql_username = gromm
mysql_password = Mvj1A
mysql_dbname = grommunio
schema_upgrade = host:gromm.domain.com

021/10/22 19:13:59 [data_source]: Failed to connect to mysql server, reason: Can't connect to local MySQL server through socket '/run/mysql/mysql.sock' (2)

WalterH

You can log into mysql with these credentials like:
mysql -u gromm -p

noplan

WalterH

yes of course first thing i checked ;)

WalterH

On my system, the socket /run/mysql/mysql.sock exists. But in /etc/my.cnf there is no active variable for it. Possibly a SLE issue?

mwilliams

WalterH

As outlined in the link: It indeed is a SUSE issue and our workaround is placed in the upcoming ISO version. However SUSE should fix it imho.

Bug is reported, no progress there (yet), but again, we have a workaround soon in place.

noplan

should there be a a mysql.sock in /var/lib/mysql/

gromm:/var/run # cat /etc/my.cnf | grep sock
socket = /run/mysql/mysql.sock

gromm:/var/run # find / -type s | grep my
/run/mysql/mysql.sock

same here ...

ignore the log file ?

WalterH

My system:
find / -type s | grep my /run/mysql/mysql.sock

noplan ignore the log file ?

I would never ignore an error message, always look for the error or at least watch until the solution is found.

noplan

mwilliams

mwilliams 2021-10-22 17:49:29 41 [Warning] Access denied for user 'gromm'@'localhost' (using password: NO)

this was fixed by changing

passwd to password in/etc/gromox/adaptor.cfg

noplan

@mwilliams

so we can ignore the log ?
not riskin blowin the sys to the moon ;)
grommunio space camp ?

WalterH

This is my adaptor.cfg:
cat /etc/gromox/adaptor.cfg mysql_username = grommunio mysql_password = PWD mysql_dbname = grommunio schema_upgrade = host:localhost

noplan

WalterH

username here waschanged during the setup to gromm
host from localhost or 127.0.0.1 to gromm.domain.com

do u think tahts the issue ?

mysql_username = gromm
mysql_password = Mvj1A
mysql_dbname = grommunio
schema_upgrade = host:gromm.domain.com

mwilliams

WalterH

@noplan was probably using a bit an older version of the appliance. He's right, there was once a typo (bug) in the setup process, which though has been fixed in the meanwhile.

WalterH

The adaptor.cfg from customer system:
cat /etc/gromox/adaptor.cfg mysql_username = grommunio mysql_password = PWD mysql_dbname = grommunio schema_upgrade = host:email.customer.at
I changed host:email.customer.at to host:localhost, but did noch solved this issue.

noplan username here was changed during the setup to gromm
host from localhost or 127.0.0.1 to gromm.domain.com

do u think tahts the issue ?

This question can only be answered by a grommunio engineer.

WalterH

mwilliams was probably using a bit an older version of the appliance. He's right, there was once a typo (bug) in the setup process, which though has been fixed in the meanwhile.

But why I see on an about 2 weeks old system the same error in sa.log as noplan ?
But the system works.

WalterH

I looked at a customer system and I see the same errors in sa.log but the system works as expected. So I will monitor this error.