error about cacti-0.8.7e

[signmem]

hello everyone. I got problem for some help .

there is my log.

sult: Can't connect to MyS
09/12/2010 02:20:14 AM - CMDPHP: Poller[0] Host[3] DS[55] WARNING: Result from CMD not valid. Partial Result: Can't connect to MyS
09/12/2010 02:20:15 AM - CMDPHP: Poller[0] Host[3] DS[56] WARNING: Result from CMD not valid. Partial Result: Can't connect to MyS
09/12/2010 02:20:15 AM - CMDPHP: Poller[0] Host[3] DS[57] WARNING: Result from CMD not valid. Partial Result: Can't connect to MyS
09/12/2010 02:20:15 AM - CMDPHP: Poller[0] Host[3] DS[58] WARNING: Result from CMD not valid. Partial Result: Can't connect to MyS
09/12/2010 02:20:15 AM - CMDPHP: Poller[0] Host[3] DS[59] WARNING: Result from CMD not valid. Partial Result: Can't connect to MyS
09/12/2010 02:20:23 AM - SYSTEM STATS: Time:21.7419 Method:cmd.php Processes:1 Threads:N/A Hosts:8 HostsPerProcess:8 DataSources:81 RRDsProcessed:55


===================================

it showes I can connect to my mysql server.
but I confirm there is some grant for user.

mysql> show grants for tt@"localhost";


GRANT ALL PRIVILEGES ON `cacti`.* TO 'tt'@'localhost'



there is my config about /www/cacti/include/config.php

$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "tt";
$database_password = "123";
$database_port = "3306";



and I can use snmp connect to others server.

snmpwalk -c public -v 2c 10.1.1.23 | more
SNMPv2-MIB::sysDescr.0 = STRING: Linux station23.cluster.com 2.6.18-128.el5 #1 SMP Wed Dec 17 11:42:39 ES
T 2008 i686
SNMPv2-MIB::sysObjectID.0 = OID: NET-SNMP-MIB::netSnmpAgentOIDs.10
DISMAN-EVENT-MIB::sysUpTimeInstance = Timeticks: (1075968) 2:59:19.68
SNMPv2-MIB::sysContact.0 = STRING: Root <root@localhost> (configure /etc/snmp/snmp.local.conf)
SNMPv2-MIB::sysName.0 = STRING: station23.cluster.com
SNMPv2-MIB::sysLocation.0 = STRING: Unknown (edit /etc/snmp/snmpd.conf)
SNMPv2-MIB::sysORLastChange.0 = Timeticks: (1) 0:00:00.01
SNMPv2-MIB::sysORID.1 = OID: SNMPv2-MIB::snmpMIB
SNMPv2-MIB::sysORID.2 = OID: TCP-MIB::tcpMIB
SNMPv2-MIB::sysORID.3 = OID: IP-MIB::ip
SNMPv2-MIB::sysORID.4 = OID: UDP-MIB::udpMIB

--------------------------------------

[root@station22 log]# snmpwalk -v 1 -c public 10.1.1.23 IP-MIB::ipAdEntIfIndex
IP-MIB::ipAdEntIfIndex.10.1.1.23 = INTEGER: 2
IP-MIB::ipAdEntIfIndex.127.0.0.1 = INTEGER: 1
IP-MIB::ipAdEntIfIndex.172.15.1.1 = INTEGER: 1



--------------------------------------

mysql server in 10.1.1.23 got some privileges for user

grant super, process, replication client on *.* to .....


---------------------------------------


can someone tell me why I can not connect my database server ??

thank you very much ..

[gandalf]

This is a mysql authentication issue. You may want to use "127.0.0.1" instead of "localhost".
R.