Solution if cactid isn't runnig on Win32 machines

[vishalsngh]

witness
the same error
with mysql < 4.1
access denied for user cacti@localhost. Now it remains the same whether i pt ip address, or loopback address or fqdn or anything!
with mysql 4.1
Server demands authentication thats isnt supported, think abuot upgrading the client.
When i follow the process of granting the old-password function, the error mentioned above repeats.
However, ith 0.8.6c, it works in single go!!!

[TheWitness]

Vish,

I have sent you an updated binary for our upcomming release. I believe that the 0.8.6d binary is built with the 4.0.x-- client libraries.

Larry

[vishalsngh]

Thx witness.
But the new binary requires some cygwin dlls, which wasnt the case with 0.8.6d/c. Right now i am going good with c version.

[TheWitness]

cactid has always required the cygwin dll's. We had just packaged them with the binary in the past.

TheWitness

[mrh]

hey, just a question: how to modify the mysql to allow it starting with the --old-passwords? Should I downgrade to mysql 4.0 and if so, will it keep my graphs and DBs?

Thanks!
mrh

[TheWitness]

There are a number of posts around the board with that solution. Try using google search with multiple combinations. We will update the documentation in the next release.

TheWitness

[BSOD2600]

Alright, time to dredge up an old thread....

I too am trying to get Cactid to work on my Win2K3 server and have not been having any luck.

Regardless of what I use in the config file, I always get the message saying something along the lines of: CACTID: MYSQL: Connection failed after 10 attempts : Access denied for user: 'cactiuser@ares.zeus.xxx.com' (Using password: YES) or CACTID: MYSQL: Connection failed after 10 attempts : Access denied for user: 'cactiuser@localhost' (Using password: YES)

As you can see from the phpmyadmin screenshots, I have all three cacti users. They all are set up with the same global and database rights. They all have the same password. The versions of everything are in my signature.

What the heck am I missing?

[TheWitness]

1) Did you make yourself or are you usinging binary?
2) Is Old Password Support Enabled on the Server?
3) Are you using IP Address instead of Localhost?

Post your cactid.conf (minus telling stuff)

TheWitness

[John Rather]

OK, I have read everone elses problem/solutions and still can't get it to work. I am new to CACTI; here is what I am running:

W2K Advance Server SP4
MySQL v4.1
PHP v5
Cacti 0.8.6c/d
Cactid 0.8.6d

I have a user setup for cacti@localhost, cacti@127.0.0.1, cacti@servername.domain.com, & cacti@10.100.12.100

I have tried all options in the cactid.conf

I am using the old-password option in my.ini

When I try to run the poller, I get:

Maximum runtime of 296 seconds exceeded...

If I try to run cactid.exe, I get:

Access denied for user 'cacti'@'servername.domain.com'...

What else is there to try; I already have a lot of hours into trying to get this to work with no luck...

Thanks!!

John Rather

[BSOD2600]

1) I downloaded the binary

2) I've tried to enable old password, but it will no work. When I try to add --old-passwords to the mysqld-nt service 'start parameters' section, it 'unexpectatly closes' right away. Same thing happens when I try it from the command line. I've also tried to add old_passwords to my my.ini file. Same thing, mysqld-nt crashes right away. When I do mysqld-nt --help, I do not see the old-password as an option. Seems thats only a 4.1 option...

3) I've tried both 127.0.0.1 and 192.168.1.115.

DB_Host 192.168.1.115
DB_Database cacti
DB_User cactiuser
DB_Pass xxx

[TheWitness]

How much you want to be that the 4.1.x API is not compatible with the 4.0.x database. I can't believe that this would be true. But I am beginning to think so.

TheWitness

[BSOD2600]

Well I tried upgrading to MySQL 4.1.11, but the damn service keeps crashing.

"Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x0007fa77."

Looking around on Google, it seems many others have this problem on Windows 2003.

Back to 4.0.29...

oh yea, and when making net-snmp 5.2.1 under windows xp sp2 and cgywin, it complains about winsock.h (looking around online, there is a few posts about people needing to use winsock2.h instead). Then cactid complains about it unable to find the snmp headers. *sigh* If it's not one thing it's another!

[TheWitness]

Strange thing though, that combo work just fine under XP. Here is my my.ini.

TheWitness

[BSOD2600]

I got mysql 4.1.11 install, off C:\ and it appears to work now w/o crashing. I also have it using a different port (3307).

I downloaded net-snmp 5.2.1, mysql 4.1.11, cactid 0.8.6e rc3 sources and compiled them with cygwin.

I added the old_password to my my.ini. I also did SET PASSWORD FOR 'cactiuser'@'localhost' = OLD_PASSWORD('xxx'); and to the root (for testing). I know it is using the old_password method, because before I did this I was unable to login to the database with phpMyadmin.

After getting this all set up, I still am unable to use cactid!! Unable to get it working with cactiuser or root.

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

cactid.conf
DB_Host 127.0.0.1
DB_Port 3307
DB_Database cacti
DB_User cactiuser
DB_Pass xxx


What the heck am I missing?

[TheWitness]

This is much better though. At least you are getting the "Access Denied" as opposed to "Connection Failed". Now it's just getting the rights properly established for the poller user id. Great work!

TheWitness