Vesta Control Panel - Forum

I upgraded mysql to mariadb, after the upgrade i checked my phpmyadmin and everything seems to be fine, including the webpages it loads ok. But after i rebooted my server, this i what i get.

Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

I checked my php version i think you will find the info here what's causing the error.

[root@panda ~]# php -v
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysql.so' - libmysqlclient.so.18: 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/lib64/php/modules/mysqli.so' - libmysqlclient.so.18: 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/lib64/php/modules/pdo_mysql.so' - libmysqlclient.so.18: cannot open shared object file: No such file or directory in Unknown on line 0
PHP 5.4.44 (cli) (built: Aug 6 2015 07:41:49)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies


Then i tried checking for file it they exist. (see my screenshot)
http://share.pho.to/9ey14/yh/original also permission is set to 755.

I also tried
find / -name libmysqlclient_r.so.18 (but no result, missing?)

I checked my folder /usr/lib64/mysql
It does contain libmysqlclient_r.so.16 (BUT NOT 18.)
see screenshot - http://share.pho.to/9eyPD/h9/original



ldconfig -v | more
ldconfig: /etc/ld.so.conf.d/kernel-2.6.32-431.el6.x86_64.conf:6: duplicate hwcap 1 nosegneg
ldconfig: /etc/ld.so.conf.d/kernel-2.6.32-573.1.1.el6.x86_64.conf:6: duplicate hwcap 1 nosegneg
ldconfig: /etc/ld.so.conf.d/kernel-2.6.32-573.3.1.el6.x86_64.conf:6: duplicate hwcap 1 nosegneg
/usr/lib64/mysql:
libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0


rpm -qa | grep -i mysql
perl-DBD-MySQL-4.013-3.el6.x86_64
compat-mysql51-5.1.54-1.el6.remi.x86_64
php-mysql-5.4.44-1.el6.remi.x86_64



Thanks!

Hello,

Do this:

yum remove php-mysql

Then do this:

yum --enablerepo=remi,remi-php54 install php-mysqlnd

Restart httpd

Wow thanks that was a quick fix.

and boy i can feel the difference, before when i click a link it takes like 2 sec before it will open, now it instantly open!


i think i lost phpmyadmin, whats the command to install it back. ?

Something like this:

pandabb wrote: and boy i can feel the difference, before when i click a link it takes like 2 sec before it will open, now it instantly open!
?

Mmm... only tests will show, how much faster your script is. Feeling in this case - euphoria, joy, happyness, and the browser cache ;-)

Thanks for the help again.

now its phpmyadmin giving me error, it shows 403. I dont have any htaccess, the settings i havent touched it using default setting and also default mariadb settings. T_T

Go here: /etc/httpd/conf.d/

You have now a phpmyadmin.conf and phpmyadmin.conf.rpmsave
Delete the first one, and rename the second.

Then go here: /etc/phpMyAdmin/

Do the same with the file config.inc.php and config.inc.php.rpmsave

Thanks a lot sir! It works.

Does this look ok ? MY Database client version looks jumbled.

Database server

Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 10.0.21-MariaDB - MariaDB Server
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
Web server

Apache/2.2.15 (CentOS)
Database client version: libmysql - mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
PHP extension: mysqli Documentation
PHP version: 5.4.44