Out of curiosity, have you found a solution to this?
Nope, I have been sitting on a beach for the last week
Out of curiosity, have you found a solution to this?
Nope, I have been sitting on a beach for the last week
I've looked in to this a little more, but I still haven't come up with anything. If anybody has any suggestions, please let me know.
I've looked in to this a little more, but I still haven't come up with anything. If anybody has any suggestions, please let me know.
What is the output of this query: select user,plugin from mysql.user;
What is the output of this query: [tt]select user,plugin from mysql.user;[/tt
Here is the output: https://pastebin.com/FvRDsBLU
I apologize for the Pastebin link, but putting it in a code tag here on the forum causes some undesirable behavior.
UPDATE mysql.user SET plugin = 'unix_socket' WHERE user = 'root';
FLUSH PRIVILEGES;
This should let you login as the root user without a password.
UPDATE mysql.user SET plugin = 'unix_socket' WHERE user = 'root';
FLUSH PRIVILEGES;
This should let you login as the root user without a password.
Okay, I've done it! Now I'll just wait to see if I get another one of those e-mails tomorrow. I've accumulated quite a collection of them. Still one question though: isn't it dangerous to allow logins as the root user without requiring as password?
isn't it dangerous to allow logins as the root user without requiring as password?
If someone can login to your system as root, a mysql password doesn't mean anything because they could start mysql in safe mode and change the password anyway.
If you really want to change it, you can:
GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY 'password';
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root';
FLUSH PRIVILEGES;
If someone can login to your system as root, a mysql password doesn't mean anything because they could start mysql in safe mode and change the password anyway.
If you really want to change it, you can:
GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY 'password';
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root';
FLUSH PRIVILEGES;
Okay, that makes sense. Thanks for the tip!
Unfortunately though, the issue is still unsolved. I got another one of those e-mails again in the middle of the night. The error message is the same as the one included in my initial post in this thread.
Unfortunately though, the issue is still unsolved. I got another one of those e-mails again in the middle of the night. The error message is the same as the one included in my initial post in this thread.
The message says the debian-sys-admin can't login and that mysql user doesn't exist on my install. What is the output of:
cat /etc/logrotate.d/mysql-server
sudo grep -r debian-sys-admin /etc/*
cat /etc/logrotate.d/mysql-server
# - I put everything in one block and added sharedscripts, so that mysql gets
# flush-logs'd only once.
# Else the binary logs would automatically increase by n times every day.
# - The error log is obsolete, messages go to syslog now.
/var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/error.log {
daily
rotate 7
missingok
create 640 mysql adm
compress
sharedscripts
postrotate
test -x /usr/bin/mysqladmin || exit 0
if [ -f `my_print_defaults --mysqld | grep -m 1 -oP "pid-file=\K.+$"` ]; then
# If this fails, check debian.conf!
mysqladmin --defaults-file=/etc/mysql/debian.cnf --local flush-error-log \
flush-engine-log flush-general-log flush-slow-log
fi
endscript
}
Alles anzeigen
sudo grep -r debian-sys-admin /etc/*
No output for this one.
I'm just going to post a message here with @ryecoaaron tagged so he doesn't miss it.
so he doesn't miss it
Ok, I would try removing the debian-sys-admin:
DELETE FROM mysql.user WHERE user = 'debian-sys-admin';
FLUSH PRIVILEGES;
Then try this again:
sudo logrotate -f /etc/logrotate.d/mysql-server
Ok, I would try removing the debian-sys-admin:DELETE FROM mysql.user WHERE user = 'debian-sys-admin';
FLUSH PRIVILEGES;
Then try this again:
sudo logrotate -f /etc/logrotate.d/mysql-server
Nope! Still happening.
Nope! Still happening.
What is the output of: sudo cat /etc/mysql/debian.cnf
What is the output of: sudo cat /etc/mysql/debian.cnf
I apologize for not getting back to you sooner. I've been on vacation.
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = EHnxGN6TFjcqqJXA
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = EHnxGN6TFjcqqJXA
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
Alles anzeigen
I apologize for not getting back to you sooner. I've been on vacation
And we have finally found your problem. This is what the file should look like:
I think that worked! Thanks! I tried running logrotate manually again and there were no errors this time.
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!