very brief question: cactid conf file

[mrh]

Hi all,
please, I would need to know if I can user the root user and password for cactid. I'm actually using them for cacti but I cannot get cactid working. If I run cactid.exe it says:

CACTID: MYSQL: Connection failed after 10 attempts : Host 'myhostname' is not al
lowed to connect to this MySQL server

I've put the IP address instead of localhost, as the instructions says.

Any comments would be very appreciated!
mrh

[TheWitness]

mrh,

What version of Cactid and MySQL are you using? For MySQL 4.1.x use Cactid 0.8.6c. If you are using MySQL 4.0.x, you can use either.

Then, you specify the IP address of the host and not "localhost". Then, review the installation documentation and make sure you add permissions using the following, or close to it, command "grant all on cacti.* for root@a.b.c.d identified by 'somepassword';"

Then, you can test on the command line by simply running cactid to verify your changes are working. You don't have to wait on the poller.

TheWitness

[mrh]

Hi Witness, this is what I obtain from doing that:
-----
mysql> GRANT ALL ON cacti.* TO root@localhost IDENTIFIED BY 'somepassword';
Query OK, 0 rows affected (0.16 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.18 sec)

mysql> quit
Bye

C:\mysql\bin>cd\cactid

C:\cactid>cactid
CACTID: Using cactid config file [cactid.conf]
CACTID: MYSQL: Connection failed after 10 attempts : Host 'esmdrsrv03' is not allowed to connect to this MySQL server
-----
I'm using MySQL 4.0 and cactid 086d, I've another cacti in other PC running MySQL 4.1 and cactid 086c and I've different error mssg:
-----
D:\cactid>cactid
CACTID: Using cactid config file [cactid.conf]
CACTID: MYSQL: Connection failed after 10 attempts : Client does not support authentication protocol requested by server; consider upgrading MySQL client
-----
Thanks for all,
mrh

[mrh]

I forgot attach my cactid.conf file:
-----
DB_Host a.b.c.d
DB_Database cacti
DB_User root
DB_Pass cacti
-----

[TheWitness]

You should enter the following:

mysql> GRANT ALL ON cacti.* TO root@esmdrsrv03 IDENTIFIED BY 'somepassword';

TheWitness