Cactid Woes

jengstro · Post by **jengstro** » Wed Nov 16, 2005 1:17 pm

After following what I thought was the simple configuration instructions provided by BSOD2600... I cannot get cactid to auth to MySQL...

I tried by IP... hostname... added another user with full rights to the cacti DB... used the root user... none of which worked.

Any ideas?

BSOD2600 · Post by **BSOD2600** » Wed Nov 16, 2005 2:37 pm

Did you apply the old password trick, as outlined in step #6 under MySQL in my guide?

jengstro · Post by **jengstro** » Wed Nov 16, 2005 6:06 pm

Yeah... would cacti work if I had not ran through that step?

Post by **TheWitness** » Wed Nov 16, 2005 7:20 pm

Depends on versions. If it was compiled using an older API on a newer database then it's nogo. Please state more about your environment and what version of Cactid you are running and where you got it from.

TheWitness

jengstro · Post by **jengstro** » Thu Nov 17, 2005 11:25 am

Not sure what else you need? Here is the version information on the two apps involved...

Catid - 0.8.6f (Downloaded from http://www.cacti.net/downloads/cactid/p ... 8.6f-1.zip)
MySQL - 4.1.15

Please let me know if you need more and thanks for the help.

Post by **TheWitness** » Thu Nov 17, 2005 2:27 pm

That version works perfectly fine with MySQL 4.1.x. The "old password's" trick should do the trick for you. Please follow BSOD's instructions.

TheWitness

jengstro · Post by **jengstro** » Thu Nov 17, 2005 2:47 pm

Just to make sure... I applied the OLD_PASSWORD change again but cactid still is unable to connect to the server...

c:\cactid\cactid

c:\cactid\cactid
CACTID: Using cactid config file [cactid.conf]
CACTID: MYSQL: Connection Failed: Can't connect to local MySQL server socket '/tmp/mysql.sock' (2)

Any other ideas?

Cacti itself is able to access the database no problem (using the same mysql account)...

Post by **TheWitness** » Thu Nov 17, 2005 3:56 pm

Yes, in your cactid.conf file, please change "localhost" to "127.0.0.1".

TheWitness

jengstro · Post by **jengstro** » Thu Nov 17, 2005 4:40 pm

Now I have this message...

c:\cactid\cactid

c:\cactid\cactid
CACTID: Using cactid config file [cactid.conf]
CACTID: MYSQL: Connection Failed: Access denied for user 'cactiuser'@'localhost' (using password: YES)

I know that user data works... because it is what Cacti is sucessfully using at the moment...

Post by **TheWitness** » Thu Nov 17, 2005 5:10 pm

This is definately the "old password" issue. Look very carefully at BSOD's install guide. The "GRANT ALL..." is very important. Remember to enclose the user_id and password in single quotes. Then, from MySQL Administrator, make sure you have old password support enabled.

TheWitness

jengstro · Post by **jengstro** » Tue Nov 22, 2005 4:04 pm

Could this have been a PATH issue? It appears that I did not have php in the system PATH...

BSOD2600 · Post by **BSOD2600** » Tue Nov 22, 2005 5:30 pm

Not likely since mysql is explicitly denying cactid from connecting. Double check you properly did step 5 & 6 in the MySQL section in my guide.
Could also look in MySQL Administrator at your cactiuser to make sure it's properly set up right (and post a screenshot).

jengstro · Post by **jengstro** » Tue Nov 22, 2005 6:22 pm

Once I removed mysql/php and re-installed the login error went away. I did notice something odd after using the GRANT statement. Even though it said it ran the change with success... the GRANT option was not flagged. So I installed phpmyadmin and made the change with it to see if it was a typo or something.

Either way I was just wondering where my mistake was.

Thanks for the help btw.

Cactid Woes

Cactid Woes

Who is online