Issue with logrotate and mariadb?? After upgrade to Fedora 40

[Michael D. Setzer II]

Worked fine with Fedora before 40, but now get message.
Line in /etc/logrotate.d/mariadb

/usr/bin/mariadb-admin $EXTRAPARAM --local flush-error-log \
       flush-engine-log flush-general-log flush-slow-log
#OUTPUT
#/usr/bin/mariadb-admin: connect to server at 'localhost' failed
#error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Message would probable not be seen with regular lograte run?

Edit the file and add -u root -p(password) and it runs fine.

/usr/bin/mariadb-admin $EXTRAPARAM --local flush-error-log -u root -p*******\
       flush-engine-log flush-general-log flush-slow-log

Don't like having password in files, so wondering if there is a 
solution. Didn't see this with versions before 40 update.

Files in /etc/logrotate.d have 
ls -l mariadb 
-rw-r--r-- 1 root root 1702 Feb  7 10:00 mariadb

So, seems public would be able to look at file?

Thanks.

+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)     
 mailto:[e-mail]                            
 mailto:[e-mail]
 mailto:[e-mail]
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

[Roger Heflin]

That would have to have been a mariadb config file/code change to no
longer allow root at localhost to access without a password.

Based on this change adding the root@localhost type auth on Windows
then it should work.
https://jira.mariadb.org/browse/MDEV-26715

Those changes were 10.11.0 so I wonder if there is something wrong
with the change.

This seems to be the defect:
https://jira.mariadb.org/browse/MDEV-21194

There is an explanation in there and notes on how to correct the issue.

On Sat, Jun 1, 2024 at 10:59 AM Michael D. Setzer II via users
 wrote:
> Worked fine with Fedora before 40, but now get message.
> Line in /etc/logrotate.d/mariadb
> /usr/bin/mariadb-admin $EXTRAPARAM --local flush-error-log \
>        flush-engine-log flush-general-log flush-slow-log
> #OUTPUT
> #/usr/bin/mariadb-admin: connect to server at 'localhost' failed
> #error: 'Access denied for user 'root'@'localhost' (using password: NO)'
> Message would probable not be seen with regular lograte run?
> Edit the file and add -u root -p(password) and it runs fine.
> /usr/bin/mariadb-admin $EXTRAPARAM --local flush-error-log -u root -p*******\
>        flush-engine-log flush-general-log flush-slow-log
> Don't like having password in files, so wondering if there is a solution. Didn't see this with versions before 40 update.
> Files in /etc/logrotate.d have
> ls -l mariadb
> -rw-r--r-- 1 root root 1702 Feb  7 10:00 mariadb
> So, seems public would be able to look at file?
> Thanks.
> +------------------------------------------------------------+
>  Michael D. Setzer II - Computer Science Instructor (Retired)
>  mailto:[e-mail]
>  mailto:[e-mail]
>  mailto:[e-mail]
>  Guam - Where America's Day Begins
>  G4L Disk Imaging Project maintainer
>  http://sourceforge.net/projects/g4l/
> +------------------------------------------------------------+
>
> users mailing list -- [e-mail]
> To unsubscribe send an email to [e-mail]
> 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/[e-mail]
> Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue