mysqli extension missing

SUSE Product Topics SLES Updates
1

SLES 11 SP2. Apache, PHP, and MySQL are installed. Installed
phpMyAdmin, but when it starts it says mysqli extension is missing.
How do I add that extension? I’ve searched the docs and the KB and
still can’t find an answer.

Ken

2

KeN Etter wrote:
[color=blue]

SLES 11 SP2. Apache, PHP, and MySQL are installed. Installed
phpMyAdmin, but when it starts it says mysqli extension is missing.
How do I add that extension? I’ve searched the docs and the KB and
still can’t find an answer.[/color]

Install the php5-MySQL package - it contains both the MySQL and MySQLi
extensions.

HTH.

Simon
SUSE Knowledge Partner

3

Also in php53

/etc/php5/conf.d/mysql.ini
/etc/php5/conf.d/mysqli.ini
/etc/php5/conf.d/pdo_mysql.ini
/usr/lib64/php5/extensions/mysql.so
/usr/lib64/php5/extensions/mysqli.so
/usr/lib64/php5/extensions/pdo_mysql.so

4

summitflier wrote:
[color=blue]

Also in php53[/color]

More specifically the php53-mysql package which provides the MySQL & MySQLi
extensions for PHP 5.3 (as installed with php53 package itself).

HTH.

Simon
SUSE Knowledge Partner

5

On Sat, 04 May 2013 09:11:01 GMT, Simon Flood
smflood@no-mx.forums.suse.com wrote:
[color=blue]

summitflier wrote:
[color=green]

Also in php53[/color]

More specifically the php53-mysql package which provides the MySQL & MySQLi
extensions for PHP 5.3 (as installed with php53 package itself).[/color]

So i install php53 and php53-mysql
yast2 -i php53
yast2 -i php53-mysql

Everything looks good but now my php files are downloaded instead of
executed. Why would a simple php upgrade break this? And where would
I fix it? I never ran into these problems on Netware

6

On Mon, 06 May 2013 14:48:51 GMT, KeN Etter
ketter@no-mx.forums.novell.com wrote:
[color=blue]

So i install php53 and php53-mysql
yast2 -i php53
yast2 -i php53-mysql

Everything looks good but now my php files are downloaded instead of
executed. Why would a simple php upgrade break this? And where would
I fix it? I never ran into these problems on Netware [/color]

Nevermind. I had missed apache2-mod_php53. That solved it.

Ken

7

[QUOTE=KeN Etter;13449]SLES 11 SP2. Apache, PHP, and MySQL are installed. Installed
phpMyAdmin, but when it starts it says mysqli extension is missing.
How do I add that extension? I’ve searched the docs and the KB and
still can’t find an answer.

Ken[/QUOTE]

I am having this same issue. I have SLES 11 SP 2 with php53 installed. Everything works fine until I try and add php53-mysql. Then php breaks because of mysqlnd missing.

PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/lib64/php5/extensions/pdo_mysql.so’ - /usr/lib64/php5/extensions/pdo_mysql.so: undefined symbol: mysqlnd_allocator in Unknown on line 0
PHP Warning: Cannot load module ‘mysql’ because required module ‘mysqlnd’ is not loaded in Unknown on line 0
symbol lookup error: /usr/lib64/php5/extensions/mysqli.so: undefined symbol: mysqlnd_get_client_info

Everything I have read about this error states php has to be built with an environment variable set.

PHP_MYSQLND_ENABLED=yes

Unfortunately, since this is installed through zypper, I don’t think I can reconfigure php to enable mysqlnd.

Please help.