#43 Problem with MYSQL stats module

[Anonymous]

I'm using the mysql 1.11 module and getting no stats.
I've read previous discussions on the same issue, not finding the solution.

The module gives me this alarm:
module mysql 1.11 : run ( alarm : 2017/05/03 18:36:02 can not find Abortedclients in mysql status can not find Abortedconnects in mysql status can not find Bytesreceived in mysql status can not find Bytessent in mysql status can not find Connections in mysql status can not find Uptime in mysql status )

The /etc/webmin/sysstats/modules/mysql/config file has been set as required and contains the correct password (password contains some ? ! - chars and also standard letters/numbers, but similar pwd was correctly working in previous module versions on another box (I don't remember which one)

Looking at the syslog register, I found this:

May 4 08:06:01 - CRON[13486]: (root) CMD (/etc/webmin/sysstats/sysstats.pl)
May 4 08:06:01 - mysqld[4279]: 2017-05-04 8:06:01 139890877938432 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

It seems to indicate the password is NOT currently used, but it has ben set in the config file (written without surrounding ' ', I believe it should be correct)

OS is Ubuntu 16.04.2 (updated to latest distribution patches), db is both MariaDB (latest debian version) and MySQL (latest debian version), on two different virtual machines running the same OS version but different db
manager

[eric gerbier]

To improve the security anf follow mysql recommandations, this module is now using a /root/.my.cnf file to store the password, and avoid pass it on command line (everybody can see it with the ps command).
Check this file.
Next, there are 2 methods to recover the data : mysqladmin and mysql
you can test with the following shell commands :
sudo mysqladmin extended-status
sudo echo 'show status' | mysql

[Anonymous]

I don't have any /root/.my.cnf file in my installations. Is there a way to get it?

[eric gerbier]

it should have been created by the module install.
you can re-enter it on https://localhost:10000/sysstats/edit_module.cgi?idx=mysql interface. The cnf file will be created.

[Anonymous]

OK, Thanks. Editing and saving the configuration finally created the file with the right pwd. I can anyway confirm you it has been not created by the installation, in both the VM affected by the issue.

[eric gerbier]

Yes, you are right, I have a bug in postinstall. It will be fixed in release 2.16.