Problem with php-5.2-mysql-zend-server on Ubuntu 9.10

[aron]

Hello!

I have been using Roundcube happily over several years on Ubuntu 9.10.

Recently I replaced the default php5-mysql with those including the Zend-server:
-  php-5.2-common-extensions-zend-server-ce
-  php-5.2-mysql-zend-server
-  php-5.2-mysqli-zend-server
which are required for KnownledgeTree.

Since then Roundcube stopped working. I get the error: DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database!

/var/log/roundcube/errors shows:

Code Select Expand

[17-Feb-2011 13:54:05] MDB2 Error: not found (-4): [Error message: extension mysql is not compiled into PHP]
[17-Feb-2011 13:54:05 +0100] DB Error: [Error message: extension mysql is not compiled into PHP]
 ** mysql(mysql)://roundcube:xxx@localhost/roundcube in /usr/share/roundcube/program/include/rcube_mdb2.php on line 100 (GET /)
/var/log/apache2/error.log  shows:

Code Select Expand

[Thu Feb 17 13:53:59 2011] [warn] RSA server certificate CommonName (CN) `mail.orbspace.com' does NOT match server name!?
PHP Warning:  PHP Startup: Unable to load dynamic library '.:/usr/local/zend/lib/php_extensions/gd.so' - .:/usr/local/zend/lib/php_extensions/gd.so: cannot open shared object file: No such file or directory in Unknown on line 0
...
PHP Warning:  PHP Startup: Unable to load dynamic library '.:/usr/local/zend/lib/php_extensions/mysql.so' - .:/usr/local/zend/lib/php_extensions/mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '.:/usr/local/zend/lib/php_extensions/mysqli.so' - .:/usr/local/zend/lib/php_extensions/mysqli.so: cannot open shared object file: No such file or directory in Unknown on line 0
...

The files such as "/usr/local/zend/lib/php_extensions/mysql.so" do however exist and are world-readable, so I do not understand where this error comes from.

The modules are also shown with "php -m" which gives the following output:

[PHP Modules]
bcmath
bz2
calendar
ctype
date
dba
dom
exif
filter
ftp
gd
gettext
hash
iconv
json
ldap
libxml
mbstring
mcrypt
mime_magic
mysql
mysqli
ncurses
openssl
pcntl
pcre
PDO
pdo_mysql
posix
readline
Reflection
session
shmop
SimpleXML
soap
sockets
SPL
SQLite
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
zip
zlib

"pear list" gives the following output:

Installed packages, channel pear.php.net:
=========================================
Package            Version State
Archive_Tar        1.3.3   stable
Auth               1.6.1   stable
Console_Getopt     1.2.3   stable
MDB2               2.5.0b2 beta
MDB2_Driver_mysql  1.4.1   stable
MDB2_Driver_sqlite 1.5.0b2 beta
Mail_mimeDecode    1.5.0   stable
Net_SMTP           1.3.1   stable
Net_Socket         1.0.9   stable
PEAR               1.9.0   stable
Structures_Graph   1.0.2   stable
XML_Util           1.2.1   stable


Since the change of the Zend-server PHP5 packages the location of the PHP-extensions is different. But after following the instructions given in Zend Forums - Zend Server Apache ALL PHP MODULES MISSING all PHP-modules from the zend-package (except pdo_sqlite.ini) are now found and are listed in php -m

But Roundcube still reports the above error. I am really stuck! Does anyone have a clue what is going wrong and how I could identify the problem?

I would very much appreciate any help or hints!
--Aron

[gochinese.org]

I got the error message in the step of installation.

MDB2 Error: connect failed

I do configure to use mysql, but the error message is from "MDB2". Weird!

[gochinese.org]

I look deep down into the dicussion and find somebody solved the problem. Simply replace localhost with 127.0.0.1 in conn string in db.inc.php file, the error has gone.