Once again.... the adodb-mysql.inc.php problem

[Herman]

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

Although I have found this topic already many times on the forum and reviewed the correction steps, I cannot get this resolved. All info on used software versions on Windows XP and config-files is in attached info.txt.

Please Help, as this has cost me already a few days to try getting it all to work..

Thanks

[BSOD2600]

1) Are you able to manually connect to your mysql database via the mysql cli?
2) Did you add the cacti username/password to your config.ph for cacti?

[Herman]

The entries I made in the \cacti\include\config.php:

$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "sbews00671";
$database_username = "cacti";
$database_password = "cacti";

As for the hostname, I tried localhost, I tried the IP-address...

Connecting to Mysql via CLI is no problem:

C:\mysql\bin>mysql --user cacti --password=cacti cacti
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 40 to server version: 4.1.14-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

When I run the poller as a scheduled job, I get:

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.
There are no items in your poller cache or polling is disabled. Make sure you have at least one data source created. If you do, go to 'Utilities', and select 'Clear Poller Cache'.[/b]

[BSOD2600]

I thought PHP 5.x had support for the new MySQL passwords, but give the old client trick a shot.

[Herman]

I tried first with the actual hostname, but that seems to be a problem. When I used 'localhost', it worked.


mysql> set password for
-> 'cacti'@'sbews00671' = OLD_PASSWORD('cacti');
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> set password for
-> 'cacti'@'localhost' = OLD_PASSWORD('cacti');
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;µ
Query OK, 0 rows affected (0.01 sec)

the problem still remains however.

[Herman]

As there are obviously so many issues with PHP5, I replaced it for PHP4 and this time the installation completed succesfully.

Now I need to get the poller going ...

Thanks for your comments

H.

[TheWitness]

I use php 5.0.4 in production and have for several months with no issues.

TheWitness