# mysqli extension missing

**URL:** <https://forums.suse.com/t/mysqli-extension-missing/23931>\
**Category:** SLES Updates\
**Created:** [May 3, 2013, 11:55pm UTC](https://forums.suse.com/t/mysqli-extension-missing/23931 "2013-05-03T23:55:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![System1](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@System1](https://forums.suse.com/u/System1)\
**Post date:** [May 3, 2013, 11:55pm UTC](https://forums.suse.com/t/mysqli-extension-missing/23931/1 "2013-05-03T23:55:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![smflood](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/smflood/32/10576_2.png) [@smflood](https://forums.suse.com/u/smflood)\
**Post date:** [May 4, 2013, 12:44am UTC](https://forums.suse.com/t/mysqli-extension-missing/23931/2 "2013-05-04T00:44:59Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![summitflier](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@summitflier](https://forums.suse.com/u/summitflier)\
**Post date:** [May 4, 2013, 1:34am UTC](https://forums.suse.com/t/mysqli-extension-missing/23931/3 "2013-05-04T01:34:41Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![smflood](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/smflood/32/10576_2.png) [@smflood](https://forums.suse.com/u/smflood)\
**Post date:** [May 4, 2013, 12:11pm UTC](https://forums.suse.com/t/mysqli-extension-missing/23931/4 "2013-05-04T12:11:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\
**Post date:** [May 6, 2013, 5:48pm UTC](https://forums.suse.com/t/mysqli-extension-missing/23931/5 "2013-05-06T17:48:51Z")

</div>

On Sat, 04 May 2013 09:11:01 GMT, Simon Flood  
[smflood@no-mx.forums.suse.com](mailto: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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\
**Post date:** [May 6, 2013, 5:53pm UTC](https://forums.suse.com/t/mysqli-extension-missing/23931/6 "2013-05-06T17:53:07Z")

</div>

On Mon, 06 May 2013 14:48:51 GMT, KeN Etter  
[ketter@no-mx.forums.novell.com](mailto: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

---

<div class="post-metadata">

**Author:** ![it\_james](https://avatars.discourse-cdn.com/v4/letter/i/edb3f5/32.png) [@it\_james](https://forums.suse.com/u/it_james)\
**Post date:** [July 12, 2013, 9:40pm UTC](https://forums.suse.com/t/mysqli-extension-missing/23931/7 "2013-07-12T21:40:31Z")

</div>

[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.
