Can't connect to mysql

[palb]

If the info.php states what MySQL client API version is, does it mean PHP is correctly configured for Litespeed and MySQL?

I can't connect to mysql, so I figured if above is true then it must be something within Litespeed settings, right? Any clues?

[mistwang]

If the info.php states what MySQL client API version is, does it mean PHP is correctly configured for Litespeed and MySQL?
Yes.

I can't connect to mysql, so I figured if above is true then it must be something within Litespeed settings, right? Any clues?
No, LiteSpeed will not affect the PHP, it is completely a PHP issue.
Please double check the MySQL socket configuration in the info page.
Also, you can check lsws/logs/error.log and stderr.log see if PHP dump any error message.

[brrr]

I had the same problem: MySQL 5 and LiteSpeed do not work together out-of-the-box, at least on a default, vanilla CentOS 5 install.

The default LiteSpeed (compiled) PHP config is telling PHP that MySQL's UNIX socket is at:
/tmp/mysql.sock

When in fact it should be (the default on my CentOS 5 server):
/var/lib/mysql/mysql.sock

To change it: edit: /opt/lsws/php/php.ini

and under the [MySQL] section, change it as follows:

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =/var/lib/mysql/mysql.sock


It worked for me.

It was a bit confusing though to track this down - there are at least *3* php.ini files floating around under the /opt/lsws directory.

Figuring out which one was active was only revealed (of course) by looking at the phpinfo output.