is there a client install for MySql so PHP can connect to MySQL Server?

alar · 01-27-2007, 05:54 PM

I have MySQL on another machine (same network). When I try to connect with PHP there is a

Code:

Call to undefined function mysql_connect()

No php isn't built with mySQL in phpinfo()

I tried GRANT access on the MySQL box to a user on the primary box.
I tried looking for a source version of php5-mysql - but I'm not sure that is what I want...

I'm using FC4 on both machines.
PHP 5.0.4 (here) and MySQL 5.027-standard (there).

Doesn't make sense to try and re-build PHP 'til unless I know how to point it to MySQL.

Do I have to install another complete version of MySQL so I can rebuild PHP?

Can somebody help me point my thoughts in the right direction on what is required for this connection?

Thanks!

trickykid · 01-27-2007, 06:39 PM

What distro? Did you install using RPM? I believe most RPM based packages have a PHP-MySQL package for the connection functionality and compatibility for MySQL databases.

alar · 01-27-2007, 07:12 PM

Both distro's are FC4.

No. I don't use RPM's. I did see a bit where you could just install
a php5-mysql package if you used packages.

Maybe I could just install a new PHP and then the php5-mysql package?

My current PHP is compiled for Oracle (on the same box as MySQL is installed).

Code:

./configure' \
  --with-oci8-instant-client=/home/oinstall/instantclient_10_2' \
  --prefix=/usr/local/php' \
  --with-apxs=/usr/local/apache1.3.31/sbin/apxs' \
  --enable-sigchild' \
  --with-config-file-path=/usr/local/apache1.3.31/etc' \

I think I'm stuck in an Oracle head-space ;-)
But that's how I got to wondering, how to rebuild PHP if there isn't a local MySQL install?

This should be basic. Shouldn't it?
BTW: Maybe I should add, it's been a few years since I used MySQL.
I have an old application that I'm trying to revive for connection testing.

the db_connect.inc

Code:

<?php
$dbhost = 'mach4.mynet.com';
$dbuser = 'mysql';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die  
                    ('Error connecting to mysql');

$dbname = 'test';
mysql_select_db($dbname); 
?>

trickykid · 01-27-2007, 09:46 PM

You need to compile PHP with MySQL support then.. usually looks like this in your configure command:

-with-mysql=/usr/local/mysql

trickykid · 01-27-2007, 09:47 PM

You can always test by creating a php info page to see what's enabled, etc:

<HTML><\n>
<HEAD><TITLE>PHP Test</TITLE></HEAD>
<BODY>
<?phpinfo() ?>
</BODY>
</HTML>

alar · 01-27-2007, 09:59 PM

Quote:

You need to compile PHP with MySQL support then.. usually looks like this in your configure command:

-with-mysql=/usr/local/mysql

This is the dilemma, I don't have a /usr/local/mysql on this machine.
Well, I guess I do

Quote:

[root@bilbo php-5.1.1]# which mysql
/usr/bin/mysql

Came with the distro? I guess?

But:

Code:

[root@bilbo php-5.1.1]# mysql -v
mysql: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory
[root@bilbo php-5.1.1]# mysql -version
mysql: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory

I'm sorry. I really don't know much about mysql....

Bottom line, guess I have to install mysql locally then?

trickykid · 01-28-2007, 02:37 AM

Missing the libmysqlclient.so.14 usually means you just need to download and install the mysql-compat package for that version to use mysql as a client to another remote machine.

wildar · 01-28-2007, 02:57 AM

If it was installed via RPM, libmysqlclient.so.14 should have gone to /usr/lib. But if you installed by another means, perhaps its there but in a different directory. If there is a libmysqlclient.so.14, try doing a symbolic link from /usr/bin to where ever it currently resides.

elfgirl · 07-03-2007, 07:42 PM

Hi -

Just wondering if anyone had figured out a fix for this yet. I'm having the exact same issue, except that my server doesn't have mysql installed on it locally anymore. The local mysql program was recently removed since we have a new standalone mysql server, and I now can't upgrade PHP.

Before mysql was taken off, my working ./configure options were:
cd /opt/app/app_src/php-5.1.6
./configure --with-openssl-dir=/opt/app/openssl --enable-sigchild --prefix=/opt/app/php --with-mime-magic --without-pic --enable-memory-limit --enable-force-cgi-redirect --with-apxs2=/opt/app/apache/bin/apxs --with-mysql --with-mysqli

Any help appreciated.

Thanks,
-R