Problem by switching from CMD.php to CACTID

[bachlechnerm]

Using cmd.php as poller-task is working fine, if I try to switch over to use cactid (because I have to poll 100+ hosts with a lot of interfaces) cactid is not return any values.

Starting cactid from the command line causes the following Error Message:

CACTID: MYSQL: Connection failed after 10 attemts : Access denied for user 'cactiuser@MY_HOSTNAME' (Using password: YES)

The Cacti-Log-File is showing the following Error:

01/20/2005 07:36:57 AM - POLLER: Poller[0] Maximum runtime of 296 seconds exceeded. Exiting.

I checked the cactid.conf:
DB_HOST 10.0.0.100
DB_DATABASE cacti
DB_USER cactiuser
DB_PASS MY_PASSWORD

I checked the PATH-setting to cactid:
c:\cactid\cactid.exe

I created following users für accessing the cacti-db:

cactiuser@localhost
cactiuser@MY_HOSTNAME
cactiuser@10.0.0.100
cactiuser@'%'

None of these steps was abele to get cactid as poller working.
Do you have any suggestions?

Markus

PS: Using PHP 5.0.3, Apache 2.0.52, rrdtool 1.0.48, mysql 4.0.23, netsnmp 5.2.1, cactid 0.8.6d, cacti 0.8.6c

[TheWitness]

Markus,

I had the same problem. You need to follow the procedure for each of those users per the manual. I think the command went something like the following:

"GRANT ALL ..."

Once I did this all went well. For some reason, just simply adding the ID's in both MySQL Admin and MySQL CC did not work.

TheWitness

[bachlechnerm]

Hmmm, that was exactly what I did....
I created the Users by using the following commands:

mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'my_password';
mysql> flush privileges;
mysql> GRANT ALL ON cacti.* TO cactiuser@10.0.0.100 IDENTIFIED BY 'my_password';
mysql> flush privileges;
mysql> GRANT ALL ON cacti.* TO cactiuser@MY_HOSTNAME IDENTIFIED BY 'my_password';
mysql> flush privileges;
mysql> GRANT ALL ON cacti.* TO cactiuser@'%' IDENTIFIED BY 'my_password';
mysql> flush privileges;

I rebootet the workstation as well.
But these actions did not resolve the Problem....

Markus

[TheWitness]

What version of Mysql are you running?

TheWitness

[bachlechnerm]

I am using....

PHP 5.0.3, Apache 2.0.52, rrdtool 1.0.48, mysql 4.0.23, netsnmp 5.2.1, cactid 0.8.6d, cacti 0.8.6c

Plattform: XP SP1

Markus

[cpt_ahab]

try 127.0.0.1 in the cactid config instead of the private ip 10.0.0.100

# +-------------------------------------------------------------------------+
# | DB_Host 'localhost' for unix, IP Address for Windows

He means the ip for local host not the real ip.

[bachlechnerm]

thanks for the replys.
I deleted and recreated the cactiuser in the sql-server-db and "juhu" - cactid was working....

now I am monitoring 59 devices with over 290 graphs...still configuring ;-)

Markus

[rony]

Awesome