PHP does not resolve MySQL

_Chow_

Hello, newbie am I.

Running
Redhat 2.4.21
Apache 2.0
PHP 4.2.2
SQL 4.0

Problem - PHP does not resolve MySql (I think)

phpinfo() states:

'--with-mysql=shared,/usr'
should this not be a resolved path to dir? (I've seen both)

phpinfo() also states:
DBX - supported databases - MySql

But MySql does not have it's own table listing in phpinfo()

config file <u>is</u> located in /etc/php.ini

I cannot find a mysql.so file ...
RPM'd php-mysql last night, did not resolve.

Decided to run phpMyadmin to help and to assertain connectivity - received error:
cannot load MySQL extension,
please check PHP Configuration

Likely reason was mysql.so file not found - which I cannot find.

currently at a loss of what to do - what to try next ... Help would be sooo appreciated !!!

will gladly supply more info from phpinfo

Thx /Chow

yelvington

Originally posted by Chow

I cannot find a mysql.so file ...
RPM'd php-mysql last night, did not resolve.

Ambiguous. Please clarify.

Did you install the RPM that provides PHP with MySQL capability?

Did you restart the server?

_Chow_

Hello yelvington,

yes, I installed the RPM and yes, I also restarted the server ...

after digging on problems associated with phpmyadmin not loading MySQL extension, I found a lot of entries that had to do with mysql.so files ... however I can't isolate one ... find / -name "mysql.so" -print ...

I little stuck now

_Chow_

hmm. ok, I've re-installed the rpm and I have a path to mysql.so now -
/usr/lib/php4/mysql.so

in php.ini it lists the extension_dir = /usr/lib/php4

I have uncommented and set extension=mysql.so

restarted apache ...

no go ...

Could I be missing something in Apache config ?

httpd.conf states:
LoadModule php4_module modules/libphp4.so

but makes no reference to mysql ... should it ? ...

any suggestions ? feel lika real nimrod ...

_Chow_

I get this error from the command line:

PHP Warning: Unable to load dynamic library '/usr/lib/php4/mysql.so' - libmysqlclient.so.10: cannot open shared object file: No such file or directory in Unknown on line 0

tsinka

Hi,

additionally, you need to install the mysql-client package.

Thomas

_Chow_

Thanks thomas,

the mysql-client package - I'll try to install that tonight.

here's what I did so far -
I found that I had libmysqlclient.so.12 , so I created and soft linked libmysqlclient.so.10 to libmysqlclient.so.12.

That seemed to do it. But, now that I can call php from the shell without the library complaint, I get a monsterous amount of errors - like:

bash-2.05b# php

Content-type: text/html
PHP Warning: Function registration failed - duplicate name - mysql_connect in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_pconnect in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_close in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_select_db in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_create_db in Unknown on line 0
-- and on and on and on until --
PHP Warning: mysql: Unable to register functions, unable to load in Unknown on line 0

funny thing is when I'm in sql at the prompt and select * from user, I see that I have two host names - namely localhost and ics.mysitemane.com (the server name)

should I be using localhost or my server name ? does this cause a duplicate ame problem that php is complaining about ?

also, phpmyadmin barfs all the time, unstable.

Thx,

Nick

hairydawgs

I am having same issue...did you fix it?