Call to undefined function: mysql_connect()

[tkouan]

Much like everyone else I too get the error below when I php poller.php:

PHP Fatal error: Call to undefined function: mysql_connect() in /home/apoc/public_html/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 338



[Php Info]
>>php -i |grep mysql

Configure Command => './configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-gd' '--with-xml' '--with-bcmath' '--enable-calendar' '--enable-ftp' '--enable-magic-quotes' '--with-mysql' '--enable-discard-path' '--with-pear' '--enable-sockets' '--enable-track-vars' '--enable-versioning' '--with-zlib' '--with-jpeg-dir=/usr/lib'
mysql

...

More configs for mysql

>>php -m

[PHP Modules]
calendar
ctype
ftp
gd
mysql
overload
pcre
posix
session
sockets
standard
tokenizer
xml
zlib

[Zend Modules]

Apache version 1.3.33 (Unix)
PHP version 4.3.10
MySQL version 4.0.25-standard


I currently use:
mysql_connect(localhost,$username,$password);

In many parts of my server at it works fine. All the rest of Cacti works fine. Even have blank graphs.


Any help?

[stickboy2642]

You have to build in mysql support in PHP. Add --with-mysql=/usr/local/mysql when you build PHP, and it will build in the mysql support.

[tkouan]

Stickyboy -


As you can see in the config line that I included in my original post, php was built with the tag that you suggested.

[bulek]

Maybe you have two php binaries in your system and Cacti is configured to use the second one and it does not have mysql build-in?

- Piotr