Getting Database Errors on litespeed

#1
We are testing an enterprise litespeed out for a month, and we have changed all our sites over to litespeed. 99% of them are working, however a small number are having problems accessing the databases.

All of the sites in question are in the External Application, using the LSAPI, so I assume it's a problem with that.
Most sites are just giving general errors, but a few have specific errors, such as :

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Most of the sites using the LSAPI are working ok, but a few are just erroring due to the database. This all works fine in Apache, and I've done quite a lot of searching and not found any answers.

Thanks

LiteSpeed API App Definition Edit Delete Back
Name phpLsapi
Address uds://tmp/lshttpd/lsphp.sock
Notes Not Set
Max Connections 20
Environment PHP_LSAPI_MAX_REQUESTS=500
Initial Request Timeout (secs) 60
Retry Timeout (secs) 0
Persistent Connection Not Set
Connection Keepalive Timeout Not Set
Response Bufferring No
Auto Start Yes
Command $SERVER_ROOT/fcgi-bin/lsphp
Back Log 100
Instances 20
Run On Start Up Not Set
Max Idle Time Not Set
Priority 0
Memory Soft Limit (bytes) 80M
Memory Hard Limit (bytes) 100M
Process Soft Limit 200
Process Hard Limit 200
 

mistwang

LiteSpeed Staff
#2
You need to build your own lsphp binary with MySQL client library matching MySQL server used. Our pre-built lsphp binary uses a earlier version of MySQL client library bundled with PHP 4.x, this client library does not compatible with MySQL 4.1 and above.
 
Top