UpdateÑ The MySQL Graph Collection - Version 2.5.0!

[scottevil]

Just updated the code to include the query cache hits template!!! Thanks Kyle and

All, Otto is no longer has time to support this template, so I inherited it! Let me know of any changes that might need done. I fixed a few problems with the graphs and now everything works again on 0.8.7g. I also plan to add a port option and some documentation on how to use this template with the cacit CLI.

The code is now here if anybody wants to help with it:
http://code.google.com/p/crunchtools/so ... ysql_stats

Best Regards
Scott M

[tosage]

Thanks for the share and to continue the work in this template
These files have been exported to a recent version of cacti, more recent than 0.8.7e

Can you convert it ?

[scottevil]

Oh, that is a problem now. Do you know if there is any easier way to convert them, than to install an older version of cacti and export them from that? I think I could take the originals, patch them and export them in an older version, but not sure if that is the only path.

Best Regards
Scott M

[noname]

Original templates seemed to be exported from Cacti 0.8.7g.
Let's try replacing hash code to your version,
e.g. "hash_xx0021" -> "hash_xx0019".

See also: http://docs.cacti.net/howto:determine_cacti_template_version

For example, converting for 0.8.7e by traditional(?) sed method:

% sed -i.bak -e 's/\([<\/*|>|\|]\)hash_\(..\)0021/\1hash_\20019/g' graph_mysql_stats/*.xml

or, more simply:

% sed -i.bak -e 's/hash_\(..\)0021/hash_\10019/g' graph_mysql_stats/*.xml

Import results:
(when imported modified 'cacti_graph_template_mysql_command_statistics.xml')


But I'm not sure whether if this converted templates will work (or not) at older version of Cacti.

[tosage]

Whaou great, thanks for the tips
I test it !

[Kedare]

Hello,

I tried to create the graphs for my MySQL Server, but only the Query Cache is shown correctly, all the other graphs are not displayed (the image is missing).

I tried to run the script by hand, and it works fine :

Code: Select all

/usr/bin/php -q /var/www/cacti/scripts/mysql_stats.php cache XxX.com cacti_stats XxXx
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20060613+lfs/mhash.so' - /usr/lib/php5/20060613+lfs/mhash.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  Cannot load module 'pdo_sqlite' because required module 'pdo' is not loaded in Unknown on line 0
used:17728 available:67091136

/usr/bin/php -q /var/www/cacti/scripts/mysql_stats.php traffic XxX cacti_stats XxXx
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20060613+lfs/mhash.so' - /usr/lib/php5/20060613+lfs/mhash.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  Cannot load module 'pdo_sqlite' because required module 'pdo' is not loaded in Unknown on line 0
in:85 out:73

But, only the Query Cache graph is shown... Do you have an idea of what can be the problem ?

Thank you

[scottevil]

What version are you running? Do you know if you are getting data in the RRD files?

Best Regards

Hello,

I tried to create the graphs for my MySQL Server, but only the Query Cache is shown correctly, all the other graphs are not displayed (the image is missing).

I tried to run the script by hand, and it works fine :

Code: Select all

/usr/bin/php -q /var/www/cacti/scripts/mysql_stats.php cache XxX.com cacti_stats XxXx
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20060613+lfs/mhash.so' - /usr/lib/php5/20060613+lfs/mhash.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  Cannot load module 'pdo_sqlite' because required module 'pdo' is not loaded in Unknown on line 0
used:17728 available:67091136

/usr/bin/php -q /var/www/cacti/scripts/mysql_stats.php traffic XxX cacti_stats XxXx
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20060613+lfs/mhash.so' - /usr/lib/php5/20060613+lfs/mhash.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  Cannot load module 'pdo_sqlite' because required module 'pdo' is not loaded in Unknown on line 0
in:85 out:73

But, only the Query Cache graph is shown... Do you have an idea of what can be the problem ?

Thank you

[Kedare]

I'm running Version 0.8.7e. (I can't upgrade for now)

How can I know if the RDD files are getting data ?

[scottevil]

That is probably your problem, let me try and install 0.8.7e first and translate this thing, so that it will work with older versions. I will let you know when I am done.

I'm running Version 0.8.7e. (I can't upgrade for now)

How can I know if the RDD files are getting data ?

[jt555]

This works fine on my local server but fails when connecting to a remote server.

I can connect to the remote via cli:
mysql -h remoteip -user=dbuser --password=dbpw
and run the same commands the script runs:
SHOW STATUS; and SHOW VARIABLES;.

But I cannot connect the remote host using the php script:
$ /usr/bin/php /var/www/html/scripts/mysql_stats.php status remoteip dbuser dbpw Connections
Error: MySQL connect failed. Check MySQL parameters (host/login/password)

I know that my parameters are correct.

select version(); returns:
local MySQL version: 5.0.77
remote MySQL version: 5.0.54a-enterprise-log

Anybody have any idea how to get this to work?

[noname]

When performed this command, what do you see?

Code: Select all

$ /usr/bin/php -r 'mysql_connect("remoteip", "dbuser", "dbpw");'

If nothing returned (and nothing recorded in your php error log), perhaps it succeeded.
If not so, hmm..

[jt555]

When performed this command, what do you see?

Code: Select all

$ /usr/bin/php -r 'mysql_connect("remoteip", "dbuser", "dbpw");'

If nothing returned (and nothing recorded in your php error log), perhaps it succeeded.
If not so, hmm..

This is what was returned:
PHP Warning: Module 'mysql' already loaded in Unknown on line 0


I can't find the php error log.
'find / -name php.errors' returned nothing.

[noname]

PHP Warning: Module 'mysql' already loaded in Unknown on line 0

If the following line exists in your php.ini, then comment out.

Code: Select all

extension=mysql.so --> ;extension=mysql.so

After that, restart Apache (and Mysql).

Probably your PHP binary have already linked MySQL library.

Code: Select all

% ldd /usr/bin/php | grep mysql
        libmysqlclient.so.15 =>  /usr/lib/libmysqlclient.so.15

[jt555]

PHP Warning: Module 'mysql' already loaded in Unknown on line 0

If the following line exists in your php.ini, then comment out.

Code: Select all

extension=mysql.so --> ;extension=mysql.so

After that, restart Apache (and Mysql).

Probably your PHP binary have already linked MySQL library.

Code: Select all

% ldd /usr/bin/php | grep mysql
        libmysqlclient.so.15 =>  /usr/lib/libmysqlclient.so.15

extension=mysql.so is not in my php.ini.
ldd /usr/bin/php | grep mysql returned nothing.

[jt555]

extension=mysql.so is not in my php.ini.
ldd /usr/bin/php | grep mysql returned nothing.

It works now without making any changes other than a MySQL restart. I think it was a problem with our MySQL server all along.
Thanks for your help.