Problam regarding adodb-mysql.inc.php

[sharpknifeedge]

Hi,

I just finished cacti installation, followed the docs, but whenever I point my browser to the cacti machine I got the following message:

######################################
Fatal error: Call to undefined function: mysql_connect() in /usr/local/share/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 338
######################################

Also followed other people's problems here about this message but didn't find anything !

Can anybody help me, please?

[TheWitness]

"php -m" should return a number of lines including one like this "mysql". If not you need to include the mysql.so file in your php.ini file.

TheWitness

[sharpknifeedge]

I type "php -m" and it returns:

######################################
PHP Warning: Unknown(): Unable to load dynamic library '/usr/local/lib/php/20020429/mysql.so' - Shared object "libmysqlclient.so.10" not found in Unknown on line 0
[PHP Modules]
pcre
session
standard
xml

[Zend Modules]
#######################################

I found the path of mysql.so and tried to locate php.ini but I found 4 referers to php.ini and unfortunately I don't know in which of them I should put the path to that mysql.so!

What should I do then "The Witness"?

[TheWitness]

Create a small file in the root of Cacti called "php_info.php". In that file, place the following line:

<?php phpinfo(); ?>

From your web browser, point to that file. Your PHP.INI file path will be specified. After you have finished debugging, remove that file as it presents too much of your system information to others.

TheWitness

[sharpknifeedge]

Thank you for your help! The problem is solved!

[routermech]

I have this same problem, the web pages gives;

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


But php lists mysql...

I type "php -m" and it returns:

[root@hoth root]# php -m
[PHP Modules]
bcmath
bz2
calendar
ctype
curl
dba
dbx
dio
domxml
exif
ftp
gd
gettext
gmp
iconv
imap
ldap
mbstring
mysql
ncurses
odbc
openssl
overload
pcntl
pcre
posix
pspell
session
shmop
sockets
standard
sysvsem
sysvshm
tokenizer
wddx
xml
yp
zlib

[Zend Modules]

Thanks Mike

[kookedgoose]

I am getting a similar error when running poller.php

Fatal error: Call to undefined function: mysql_connect() in /usr/share/cacti/site/lib/adodb/drivers/adodb-mysql.inc.php on line 339

am pretty sure the lack of mysql when i do php -m is the problem, however mysql.so appears on the bottom of php.ini (and yes i checked the correct file and restarted apache).

any ideas.

[elnino]

Check the first topic in this forum on SELinux because I was getting the same adodb-mysql.inc.php error on my CentOS box before I disabled SELinux.