Hi,
I'm using fedora40 with mariadb and noticed my logs are being rotated, but
not flushed to start logging to the new file. This is the bottom of
/etc/logrotate.d/mariadb:
# After each rotation, run this custom script to flush the logs. Note that
# this assumes that the mariadb-admin command has database access, which
it
# has thanks to the default use of Unix socket authentication for the
'mysql'
# (or root on Debian) account used everywhere since MariaDB 10.4.
postrotate
if test -x /usr/bin/mariadb-admin
then
/usr/bin/mariadb-admin $EXTRAPARAM --local flush-error-log \
flush-engine-log flush-general-log flush-slow-log
fi
endscript
However, when I run that command manually as root or the mysql user, it
fails with access denied.
$ /usr/bin/mariadb-admin --local flush-error-log flush-engine-log
flush-general-log flush-slow-log
/usr/bin/mariadb-admin: connect to server at 'localhost' failed
error: 'Access denied for user 'mysql'@'localhost' (using password: NO)'
Where is access supposed to be provided securely for this? Do you know what
privileges I should enable to allow the mysql user to flush the logs
without privileges?
--
_______________________________________________
users mailing list -- users@lists.fedoraproject.org
To unsubscribe send an email to users-le...@lists.fedoraproject.org
Fedora Code of Conduct:
https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives:
https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org
Do not reply to spam, report it:
https://pagure.io/fedora-infrastructure/new_issue
