Problem with Win32 install

[tapufd]

Hello,

About the error :
Fatal error: Call to undefined function mysql_connect() in C:\apache2\Apache2\htdocs\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 323
I also had this problem with mysql 4.0.22. After searching a bit, I found that the php.ini file HAS TO BE in your Windows folder. I had the registry-key and Environmental Variable set to another directory than C:\Windows, where the php.ini was located, but php couldn't find it there!
PS : if changing something to php.ini, you need to restart your IIS.

About the new authentication protocol in mysql 4.1.7 :
When I upgraded from mysql 4.0.22 to 4.1.7, I had the error : Client does not support authentication protocol. To solve this you need to do the following :
* c:\mysql\bin\mysql --user=root --password mysql
* mysql> SET PASSWORD FOR
* -> 'cactiuser'@'localhost' = OLD_PASSWORD('cacti');
(http://dev.mysql.com/doc/mysql/en/Old_client.html)

/Tap

[JohnG]

Thanks php/mysql now sorted with php.ini in c:\winnt

But I'm now getting a problem with the poller (no graphs being generated)
CACTID log file is empty and when I run CACTID from command I get the error below.

Question is; Is this because I'm not passing any parameters to CACTID or an issue with CYGWIN1.dll?

Cheers Johng

C:\cactid>cactid
CACTID: Using cactid config file [cactid.conf]
WARNING: Unrecongized directive: LogFile=c:\cactid\cactid.log in cactid.conf
CACTID: Windows Environment, root permissions not required for ICMP Ping
CACTID: Version 0.8.6b starting
34 [unknown (0xA3C)] cactid 2664 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION
5407 [unknown (0xA3C)] cactid 2664 open_stackdumpfile: Dumping stack trace to cactid.exe.stackdum
p

C:\cactid>type cactid.exe.stackdump
Exception: STATUS_ACCESS_VIOLATION at eip=610B4625
eax=0000004B ebx=00302E30 ecx=004046A6 edx=00302E31 esi=004046AE edi=007074D6
ebp=01C6DE78 esp=01C6DE60 program=C:\cactid\cactid.exe, pid 2664, thread unknown (0xA3C)
cs=001B ds=0023 es=0023 fs=003B gs=0000 ss=0023
Stack trace:
Frame Function Args
01C6DE78 610B4625 (00000000, 00000013, 610D6FB0, 00000000)
01C6DEA8 6105C355 (004046AE, 0040411B, 00000032, 00000003)
01C6DEF8 6108DF2F (0A0548D8, 0A054B18, 00000032, 610CF581)
01C6DF28 004045F9 (0A0548D8, 0A054B18, 00407050, 0A091AAF)
01C6EE28 00407BB5 (00000001, 00000000, 00000000, 00000000)
01C6F058 00406D7B (0A054490, FFFFFFFF, 00000000, 00000000)
01C6F098 610A949A (0A054850, 01C6F0D0, 610A9420, 00000000)
01C6F0C8 61003E84 (00000000, 77F82121, 000003DC, 01C6F118)
01C6FF98 61003E3A (00000000, 00000000, 00000000, 00000000)
End of stack trace

[TheWitness]

JohnG,

I have made several changes to Cactid since the 0.8.6b release. Are you using the current CVS version? Please let me know. Then, if you are not, and have the capabilities, download the current CVS version and recompile. If not, I can send you an executable via e-mail.

TheWitness

[JohnG]

Hi Witness

No I'm not using the CVS version if you could send the newest .exe to john_b_gillam@hotmail.com thay would be great.. cheers J

[dev2dev]

Fatal error: Call to undefined function mysql_connect() in C:\apache\Apache2\htdocs\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 323

looks like every one is stuck at the same place.
I am desparatly want to know from you experienced once wether you find solution?

My environment (same as the few other members)

Windows 2000 Advanced Server
Cactid 0.8.6c, Cacti 0.8.6b (note the b and c, hope that isnt a big problem)
MySQL 4.1
PHP 5.0.2
Apache2
Net-SNMP 5.1.2

One thing i noticed is the documentation is not so well, the author has not stick with one standard procedure of naming instal directories and configuration files (see next 2nd para)

Few things which I didnt understand is cygwin
what to do with that , I installed that in my pc but seems I have not used any thing, is cacti using it internally?

Comming to installation documentation
while installing cacti author said in step 3e

When entering a username and password make sure the user has read and write access to the following directories:

c:\apache2\htdocs\cacti\rra (is it apche-instal-dir\htdocs.... ?, i assumed same thing)
c:\apache2\htdocs\cacti\log ( - do - , my folders already have full control permission to EVERYONE)

Make sure the user has read, write, and execute access to the following directories:

c:\php
c:\php\sapi

what is the 'sapi' folder? its not created by default, do i have to create it and set permission (done the same thing)?

In the Run textbox enter the following text making sure to use the appropriate paths.

c:\php\php.exe c:\mycacti\website\cacti\poller.php

The start in box should say c:\mycacti\website\cacti.

is it php.exe irrespective of all versions?
what is c:\mycacti\website\cacti\poller.php is it c:\apache-instal-dir\htdocs\cacti\poller.php (same i used)?


It was great help from the experts discussion which raised hopes but at the end couldnt find the final solution.


This is a bad habit people has who keep posting questions till they solve and forget to post how they solved.

Thank you

[TheWitness]

JohnG, MSM->Larry, AIM->PhyntmVygr, YIM->PhyntmVygr. Call me, let's get this solved.

TheWitness

[dev2dev]

hi guys, this is the new error message showing up

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'cactiuser'@'gautam.silicon.com' (using password: YES) in C:\apache\Apache2\htdocs\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 324

Cannot connect to MySQL server on '192.168.1.21'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

looking for help

[TheWitness]

This is much more promising. You now have to create an entry for your ID@HOST combination in the MySQL database and you will be functional. Please refer to the installation documentation. Look for the workds "GRANT ALL ON..." within the manual and you will be in the right place.

TheWitness

[dev2dev]

my problem solved immediatly after posting my previous mail

I have done 2 extra steps which is not said in the installation guide ,
But found in two of this topic threads. Thanks to "apufd"& "mad cliker" (for hint of set password to ....
and also to "the witness" for the snmp.conf correction.

step 1

removed 2nd and 3rd lines from snmp.conf file of my net-snmp-dir\etc\snmp\snmp.conf

i.e., removed persistentdir and tempfilepatter entries
actually experts suggest to comment it out but dont know what char. to use to comment (not sure it may be # or ; or /* */ or // , hope we will find in next post)

step 2a
SET PASSWORD FOR 'cactiuser'@'localhost' = OLD_PASSWORD('cacti');

and also

2b
SET PASSWORD FOR 'cactiuser'@'192.168.1.21' = OLD_PASSWORD('cacti');

192.168.1.21 is my sys ip

I used both localhost and ip address because I dont know which one cacti uses ,coz in document says type hostname or ip address not localhost (in cacti.conf)

but when i see in the users of mysql it using localhost, then i granted permission to cactiuser@192.168.1.21 also for safety, i dont know how much it helped to solve the problem

Thank you very much to you all

But waite, i just configures the welcome screen , i am going to enter cacti using cacti user name and password which leads to lot of new questions.

Till I get aquinte with this stuff i will keep bugging you all

Thank you very much again

[dev2dev]

problem at localhost/cacti/index.php

Please enter your Cacti user name and password below:

i am using( used as is (case sensitive))

User=Debug
Password=marzipan

not working

is it same or changed?

[dev2dev]

am i adicted to this forum???

i was stuck in the configuration itself so couldnt see the installation guide completely step 4 of cacti install

username = admin password = admin

[TheWitness]

Glad to see I'm not the only one.

TheWitness