mysql stats 2.0 php script not running?

Templates, scripts for templates, scripts and requests for templates.

Moderators: Developers, Moderators

Post Reply
phiberoptik26k
Posts: 12
Joined: Mon Sep 20, 2004 3:52 pm

mysql stats 2.0 php script not running?

Post by phiberoptik26k »

I just downloaded the addin for mysql to monitor the status of the server and it really seems cool. the problem is that ican't get it to work!

this is me trying to execute it manually...

C:\php>php.exe -q c:\inetpub\wwwroot\cacti\scripts\mysql_stats.php command local
host cactiuser cactiuser

C:\php>php.exe -q c:\inetpub\wwwroot\cacti\scripts\mysql_stats.php command local
host cactiuser cactiuser

C:\php>php.exe mysql_stats.php command cactiuser cactiuser
Error: wrong parameter count
Usage: mysql_stats.php section db_host db_user db_password [status_var]

C:\php>php.exe mysql_stats.php command localhost cactiuser cactiuser

C:\php>php.exe mysql_stats.php command 172.18.2.46 cactiuser cactiuser

C:\php>php.exe mysql_stats.php command 127.0.0.1 cactiuser cactiuser

C:\php>php.exe mysql_stats.php command 127.0.0.1 root
Error: wrong parameter count
Usage: mysql_stats.php section db_host db_user db_password [status_var]

C:\php>php.exe mysql_stats.php command 127.0.0.1 root root

C:\php>php.exe mysql_stats.php command 127.0.0.1 root rootasdfasd

C:\php>php.exe -q mysql_stats.php command 127.0.0.1 root rootasdfasd

C:\php>php.exe -q mysql_stats.php command 127.0.0.1 cactiuser cactiuser

C:\php>php-win.exe -q mysql_stats.php command 127.0.0.1 cactiuser cactiuser

C:\php>

i get no data output and here is my cacti and poller logs

Data Source: Localhost - MySQL - Connections
RRD: C:\Inetpub\wwwroot\cacti\rra\localhost_connections_33.rrd
Action: 1, Script: c:/php/php-win.exe -q C:\Inetpub\wwwroot\cacti/scripts/mysql_stats.php status Localhost cactiuser cactiuser Connections


02/09/2005 04:10:04 PM - CMDPHP: Poller[0] Time: 4.5242 s, Theads: N/A, Hosts: 2
02/09/2005 04:10:04 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
02/09/2005 04:10:04 PM - CMDPHP: Poller[0] Host[9] CMD: c:/php/php-win.exe -q C:\Inetpub\wwwroot\cacti/scripts/mysql_stats.php status Localhost cactiuser cactiuser Connections, output: U
02/09/2005 04:10:04 PM - CMDPHP: Poller[0] Host[9] WARNING: Result from CMD not valid. Partial Result:
02/09/2005 04:10:04 PM - CMDPHP: Poller[0] Host[9] SNMP: Host responded to SNMP


02/09/2005 04:09:04 PM - CMDPHP: Poller[0] Time: 4.5197 s, Theads: N/A, Hosts: 2
02/09/2005 04:09:04 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
02/09/2005 04:09:04 PM - CMDPHP: Poller[0] Host[9] CMD: c:/php/php-win.exe -q C:\Inetpub\wwwroot\cacti/scripts/mysql_stats.php status Localhost cactiuser cactiuser Connections, output: U
02/09/2005 04:09:04 PM - CMDPHP: Poller[0] Host[9] WARNING: Result from CMD not valid. Partial Result:
02/09/2005 04:09:04 PM - CMDPHP: Poller[0] Host[9] SNMP: Host responded to SNMP


does anyone have any ideas on what could be causing it not to work? i've already issused the grant process rights to my cactiuser account.

thanks-
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests