Problem with Win32 install

clydew4 · Post by **clydew4** » Tue Oct 19, 2004 2:21 pm

I have setup cacti according to the directions on a WinXP machine. When I try to access cacti I get the following 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

Wimmo · Post by **Wimmo** » Wed Oct 20, 2004 7:12 am

clydew4,

first search the board, there you will find some tips, second, it looks like a problem with php. change php to php-win in the php path.

I had the same problem.

Regards Wimmo

Guest · Post by **Guest** » Wed Oct 20, 2004 3:13 pm

If you are using php 5 then check that you have the variables all set. Was one missing that caused this error - cant find the message but was a month maybe two ago. Its listed in the current Manual.

Guest · Post by **Guest** » Thu Oct 21, 2004 3:33 pm

clydew4

Have you resolved this yet? I have the same error trying to get Cacti working on Win2k.

I've checked all the variables and config entries. All look ok to me.

Any other help appreciated

Post by **TheWitness** » Thu Oct 21, 2004 8:34 pm

Please insure the following:

1) Environment variable PHPRC is set to c:\php
2) Extension php_mysql.dll is NOT commented out in php.ini
3) There is no php.ini in C:\WINDOWS ? C:\WINNT

Should solve your problem.

TheWitness

Guest · Post by **Guest** » Sat Oct 23, 2004 7:08 am

Sorry, tried that. Didn't make any difference. Same error.

tman

Post by **TheWitness** » Mon Oct 25, 2004 7:58 pm

Run "c:\php\php.exe -m" and post the results.

TheWitness

Guest · Post by **Guest** » Tue Oct 26, 2004 9:25 am

Thanks for the help.

Output of php.exe -m is as follows; I can't imaging the net-snmp warnings would cause the problem. All the folders exist anyway.

C:/net-snmp/etc/snmp/snmp.conf: line 2: Warning: Unknown token: persistentDir.
C:/net-snmp/etc/snmp/snmp.conf: line 3: Warning: Unknown token: tempFilePattern.

[PHP Modules]
bcmath
calendar
com_dotnet
ctype
dom
ftp
iconv
libxml
mysql
odbc
pcre
session
SimpleXML
snmp
sockets
SPL
SQLite
standard
tokenizer
wddx
xml
zlib

[Zend Modules]

Post by **TheWitness** » Tue Oct 26, 2004 6:03 pm

You need to either reinstall net-snmp without the agent or fix it's configuration via the modification of the snmp.conf file. That is what is causing the problem with the net-snmp. This is also likely causing your Cacti problem, but we can't be certain until you remove the other error message.

TheWitness

Guest · Post by **Guest** » Sun Oct 31, 2004 8:13 am

Getting the same error as the above ppl.

Managed to solve the snmp error which appears with php -m, just comment off lines 2 n 3 in the snmp.conf

As for the mysql error everyone above's facing, think its due to using mysql newer than 4.1.1 ? Which has a new method for password hashing...

Can anyone help on this?

A simple google on the above mysql error points to this url http://dev.mysql.com/doc/mysql/en/Old_client.html

Think i resolved it by updating the cacti user id/pass on the mysqld with the OLD_PASSWORD() function.

Then i managed to setup the path for all the programs needed eg php etc.

But i'm now stuck with the initial login whereby you're suppose to login with user id admin/admin...

Tried setting the admin password to clear admin, OLD_PASSWORD('admin') or the default hash from cacti.sql, but none would work...

Any ideas?

btw mysql is 4.1.7, cacti is 0.8.6b, php is 5.0.2.

TIA.

Mad Clicker · Post by **Mad Clicker** » Sun Oct 31, 2004 9:47 am

I went down the same rabbit hole. I think the trick to fixing mySQL is to do the following:

c:\mysql\bin\mysql --user=root --password mysql

update user set Password = OLD_PASSWORD('cactiuser') where User='cactiuser';

There are other ways to reset the cactiuser to the older format, but this worked for me.

Post by **TheWitness** » Sun Oct 31, 2004 12:33 pm

Ok all. I had the same issue. There is a file called snmp.conf in the c:\net-snmp folder sub-tree that you need to remove the two lines intended for the agent. If you have not installed the agent, simply remove the two lines and the error messages will go away.

TheWitness

JohnG · Post by **JohnG** » Sun Oct 31, 2004 12:58 pm

Hi I'm getting the same issue here, I have checked php.ini for issues an php_mysql.dll is not commented out, fixed the snmp.conf file so php -m doesn't report any errors and I also tried the suggested pword fix for mySQL but I still get:

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 323 .....When I browse to the web site

I'm running W2K svr SP4 with Apache2, PHP5 and mySQL 4.1.7 is there anything else I can try??

Thanks 4 ur help, Cheers J

Post by **TheWitness** » Sun Oct 31, 2004 1:10 pm

Alright,

Now I know what your problem is. Only thing is I don't know quite how to fix it yet. In MySql 4.1.x, the MySql guys changed the way that authentication works which breaks the php_mysql module. What you need to do is enable legacy authentication in MySQL.

Search through their knowledge base for an answer. There is a setting in MySQL Administrator for it, but for some reason it did not work for me. I ended up reverting back to 4.0.20d. There is another user tapufd@hotmail.com who seems to have it working in MySQL 4.1.7 though. I will send this post to him for comment.

TheWitness

JohnG · Post by **JohnG** » Sun Oct 31, 2004 2:01 pm

Hi Witness, thanx 4 the quick reply, going to try 4.0.22 having tried starting mysqld-nt with the --old-passwords option (no joy) I couldn't find anything in mysqladmin, I will be interested to here if tapufd@hotmail.com has it working... cheers J

Cacti

Problem with Win32 install

Problem with Win32 install

php

MySQL solution

Same issue

downgrading..

Who is online