Cacti w/server 2003

[yiuwing625]

I am new to cacti. I am sure that it is much easier to do with Linux, but I want to drive myself crazy so I am trying to get it to run on Windows.

I have run into some problems trying to install Cacti with Windows. So far I have installed:

php 5.0.5
Apache/2.0.55 (Win32)
MySQL Administrator 1.1
MySQL Server 5.0
net-snmp version 5.1.3
cacti-0.8.6g
cactid-0.8.6f
ActivePerl-5.8.7.815
----------------------------------------------
My cactid.conf file
DB_Host 127.0.0.1
DB_Database cacti
DB_User root
DB_Pass cactiuser

My problem is running cactid from command line.
This is the output I get.

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


I am stuck, can anyone point me in the right direction?

[BSOD2600]

1) Read the guide in my signature
2) MySQL 5 is not supported (yet). Go back to 4.1 or use SVN code (at your own risk).
3) In my guide under the MySQL section, read step #6.

[yiuwing625]

I took some time off to work on some other projects but I am back and ready to finish this windows install of Cacti. I know it can be done, its just a bit frustrating when I cant get something to work. I have read your signature on the windows install. I have installed 4.1 like you said and i am not sure if i am following step 6 correctly.


I stopped the MYSQL service, and entered the following in the my.ini file

#Use old password encryption method (needed for 4.0 and older clients).
old-passwords

My question is, does it matter where in the file I place it?


And the second part of step 6

UPDATE mysql.user SET Password = OLD_PASSWORD('cactipw') WHERE Host = 'localhost' AND User = 'cactiuser';
mysql> FLUSH PRIVILEGES;

Do I do this while mysql service is stopped or after I turn it back on?

I used MYSQL Administrator to create cactiuser and the db cacti since I was not able to do so in the command prompt.

Once I complete the old password trick, I tried it again and I still cannot import the cacti.sql file. I have checked for the correct path of it. I dont know what I am doing wrong.

[BSOD2600]

Welcome back.

Cacti 0.8.6h has been released, and it now has support for MySQL 5 (install the patches though!).

1) No, the place in the file really shouldnt matter... the MySQL Admin tool placed it at the end of my file, during testing.
2) You must do the UPDATE mysql.user while MySQL is running and AFTER you've enabled old-passwords.

[yiuwing625]

I took your advice. I switched to Cacti 0.86h, and MySQL 4.1 and I was able to complete the install. Now I am working on the configuration and create a few graphs. Thank you for all your help. It took some time, but I am glad I stuck with it.