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-
mysql stats 2.0 php script not running?
Moderators: Developers, Moderators
-
- Posts: 12
- Joined: Mon Sep 20, 2004 3:52 pm
Who is online
Users browsing this forum: No registered users and 0 guests