[cobalt-users] mysql_connect() problem on Raq550

["Brendan" <brendan@xxxxxxxxxxxxx>]

I know there are several postings for the mysql_connect() issue but none of 
the resolutions seem to work for me.

I cannot query any of my databases using mysql_connect(), I've followed all 
procedures found in other postings in detail to resolve the problem -but none 
work (I can connect from command line no problem). I recently updated my 
Raq550 to all the latest patches - I'm not sure if mysql_connect() was 
working prior to the upgrades as this is a new machine and I didn't bother to 
try.

Here's some info:

1. I can connect to a database no problem using php, I just can't query it... 
The mysql_connect() dies, it doesn't display anything like 'invalid command' 
etc. -it just doesn't execute.

2. phpinfo() - indicates:

'./configure' '--prefix=/usr' '--with-apxs=/usr/sbin/apxs' '--enable-safe-
mode' '--with-config-file-path=/etc/httpd' '--with-exec-dir=/usr/bin' '--with-
zlib' '--enable-magic-quotes' '--with-regex=system' '--enable-track-vars' '--
with-iconv' '--enable-xml' '--disable-debug' '--with-gd' '--enable-
mbstring' '--enable-mbstr-enc-trans' '--with-interbase=shared' '--with-
mysql=shared' '--with-pgsql=shared' '--with-ldap' '--with-imap' '--with-
openssl=/usr' '--with-jpeg-dir=/usr' '--with-png-dir=/usr'


3. I have performed the following steps repeatedly but it just still doesn't 
resolve the problem:

Enable the php scripting for the vsite under the following menu
"Site Management -> Site -> Services -> Web -> Enable PHP scripting"
Edit the /etc/httpd/php.ini to add the following line
extension=mysql.so
Restart the httpd by typing
/etc/init.d/httpd restart
Start the mysql daemons by typing
/etc/init.d/mysql start
Create a symlink /tmp/mysql.sock to /var/lib/mysql/mysql.sock using
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

** I have seen somewhere that said to recompile php without '--with-
mysql=shared' but I don't know how to recompile... 

Has anyone seen this problem before? I was going to upgrade to php 4.3.2 but 
I see that some people have seen the same problem and since the above 
procedure doesn't work now I don't want to upgrade 4.3.2 and leave my entire 
system in disarray.

Thanks in advance.

--
BuildaCOM Online Inc.
http://buildacom.com