Resolved Database problem

[HeRiNo]

Plesk 12.5.30 Update #44
Linux CentOS 6.8

Hello,

I don't know how it happened but I am runnnig mysql server 5.7 on CentOS 6.8 It gives me a lot of problems. I would like to know in understandable English (I am Dutch) if it is possible to go back to mysql server 5.5 or if possible 5.6 but in a way that I keep all my current databases. So all I have running stays running. I hope someone has the answer for me. OR is it possible to make 5.7 runnig without problems?

Best Regards, Herman.

 

[krism]

What sort of problems are you having specifically? How did you upgrade to 5.7?

 

[lvalics]

What kind of problems generate the new MySQL?

 

[HeRiNo]

Hello Ivalics, This is 1: libmysqlclient.so.16: cannot open shared object file and ni way to solve it. I already had help trough this forum for that.
When I install postfix I get this:

ERROR: PleskUtilException
mailmng-server failed: Fatal error: plesk::Exc<&(plesk::ExecCmd::Failed(bool)), plesk::ExDefault>(Execution of /usr/sbin/postconf -d -h mail_version failed with return code 127.
Stderr is
/usr/sbin/postconf: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
)

And I have no more access to Plesk. When I install Qmail I cant use it. Raoundcube urls are not reachable. I also cannot make new databases or remove databases. There probably is more but last week I am only trying to get it fixed.

Regards, Herman.

 

[lvalics]

I would suggest https://kb.plesk.com/en/120923 but I see on other thread you have already tried.
Still,
cat /etc/ld.so.conf.d/mysqlclient.conf or cat /etc/ld.so.conf.d/mariadb-x86_64.conf
what is the result?

 

[HeRiNo]

[root@vmi66617 ~]# cat /etc/ld.so.conf.d/mysqlclient.conf
/usr/lib64/mysql
/usr/lib/mysql/

[root@vmi66617 ~]# cat /etc/ld.so.conf.d/mariadb-x86_64.conf
cat: /etc/ld.so.conf.d/mariadb-x86_64.conf: No such file or directory
[root@vmi66617 ~]#

Regards, Herman.

 

[lvalics]

and this libmysqlclient.so.16 exist on your server?

Check this also:
https://talk.plesk.com/threads/mailmng-server-failed-fatal-error.336023/page-2#post-791920

 

[HeRiNo]

Hello Ivalics. I did from the article above ::
rpm -Uvh atomic-release*rpm and got this:

[root@vmi66617 ~]# [root@vmi66617 ~]# rpm -Uvh atomic-release*rpm
-bash: [root@vmi66617: command not found
[root@vmi66617 ~]# error: File not found by glob: atomic-release*rpm

Do i stil do the second line of the article?
yum install mysqlclient16

Regards, Herman.

p.s.

[root@vmi66617 ~]# locate libmysqlclient.so.16
/usr/lib/mysql/libmysqlclient.so.16
/usr/lib/mysql/libmysqlclient.so.16.0.0

 

[lvalics]

Try to reinstall mysql client with yum reinstall mysql-client
But is strange that you have it in /usr/lib/mysql/
try if you did not tried already ldconfig reload.

 

[HeRiNo]

[root@vmi66617 ~]# yum reinstall mysql-client
Loaded plugins: fastestmirror, security
Setting up Reinstall Process
No Match for argument: mysql-client
Loading mirror speeds from cached hostfile
* atomic: www4.atomicorp.com
* base: ftp.plusline.de
Excluding mirror: mirror.de.leaseweb.net
Excluding mirror: mirror.nl.leaseweb.net
* epel: mirror.fraunhofer.de
* extras: ftp.plusline.de
* remi-safe: mirror.23media.de
* updates: ftp.plusline.de
Error: Nothing to do

 

[HeRiNo]

Hello Krism, some issues already mengoned in this thread. It happened when someone helped me. He said he got it using yum install.

Regards, Herman..

 

[lvalics]

http://www6.atomicorp.com/channels/...PMS/mysqlclient16-5.1.59-2.el5.art.x86_64.rpm

Could this help?

 

[HeRiNo]

Hello Ivalics, what should I do with it?

Regards, Herman.

 

[lvalics]

yum list mysql* should show if was installed or not mysqlclient, I think yes.
if exist, I think it was from ART repo and match this version. If yes, then you should install it again (update).

it is easier to me to do it, hard to presume what you have there

 

[HeRiNo]

Hello Ivalics, I dont understand this now. Do you mean that you want to take a look on my server?

Regards, Herman.

P.S. See attachements.

 

[lvalics]

Please contact me on PM. I will try to help you in private.

 

[HeRiNo]

Hello,

The issue has been solved by Ivalics. Thank you verry much.
Solution follows.

Best regards, Herman.

 

[lvalics]

The issue was that it was installed 32 and 64 bit MySQL, I made a symlink from 32 to 64 and worked ...