MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: zokkie on 2017-04-14, 10:55:39

Title: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-04-14, 10:55:39
Hi Mustafa,

After the update I get the following error message:

--> Running transaction check
---> Package kernel.x86_64 0:2.6.32-642.11.1.el6 will be erased
---> Package kernel-devel.x86_64 0:2.6.32-642.11.1.el6 will be erased
---> Package mysql55-libs.x86_64 0:5.5.54-1.ius.el6 will be updated
---> Package mysql55-libs.x86_64 0:5.5.54-1.ius.el6 will be updated
--> Processing Conflict: mysql55-libs-5.5.54-2.ius.centos6.x86_64 conflicts mysql-libs < 5.5
--> Finished Dependency Resolution
Error: mysql55-libs conflicts with MariaDB-compat-10.0.30-1.el6.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest


My sysinfo:
 A. Kloxo-MR: 6.5.0.f-2016111301

B. OS: CentOS release 6.9 (Final) x86_64

C. Apps:
   1. MySQL: mysql55-5.5.54-1.ius.el6.x86_64
   2. PHP: php56u-5.6.30-2.ius.centos6.x86_64
   3. Httpd: httpd-2.2.31-1.mr.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: --uninstalled--
   6. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
   7. Dns: bind-9.10.0-P2.3.mr.el6.x86_64

D. Php-type (for Httpd/proxy): php-fpm_event
What is wisdom to find solution.

Thank you in advance.
zokkie
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: fossxplorer on 2017-04-14, 14:20:20
You might have mysql55-libs from earlier (before MariaDB time).

Run the following and see how it goes:
yum remove mysql55-libs -y && yum clean all && yum update
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-04-14, 14:42:36
Add 'exclude=MariaDB* mariadb*' (without quote) in '/etc/yum.conf'.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-04-14, 15:24:12
MariaDB error is no more, but now I have error of gmail-toaster:

---> Package qmail-toaster.x86_64 0:1.03-1.3.56.mr.el6 will be an update
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: qmail-toaster-1.03-1.3.56.mr.el6.x86_64
--> Finished Dependency Resolution
Error: Package: qmail-toaster-1.03-1.3.56.mr.el6.x86_64 (mratwork-release-version-arch)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-04-14, 15:44:31
Try 'yum update --skip-broken -y'.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: lenawaii on 2017-04-16, 23:30:10
Hi,

Well what is the real solution to solve this please:

Error: Package: qmail-toaster-1.03-1.3.56.mr.el6.x86_64 (mratwork-release-version-arch)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)

I can use '--skip broken' but I will get the same error at next update, is there a better way to make it clean?

Thanks
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-04-17, 01:57:44
Remove  'exclude=MariaDB* mariadb*' from '/etc/yum.conf' and then 'yum clean all; yum replace mysql55 --replace-with=MariaDB-server'.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 14:13:00
Hi Mustafa,

After update 'yum replace mysql55 --replace-with=MariaDB-server'  error was not solved, after all I tried:  YUM REMOVE MYSQL55-LIBS  (fossxplorer) and then Kloxo-MR reports: error 503 found and all websites are offline (mysql error).

After  SH /SCRIPT/CLEANUP websites are online again but not kloxo-MR (still error 503).
Please look at attachment.

How can I get kloxo-mr online again?

Thanks.
Kind Regards.
zokkie

Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 15:42:52
Kloxo-MR 6.5 design for MySQL55 (especially because panel still using php 5.2). It's make impossible install Kloxo-MR 6.5 on CentOS 7.

Different with Kloxo-MR 7.0 where already using MariaDB because panel using php 5.4/5.6. And it's make possible install on CentOS 7.

For Kloxo-MR 6.5, to prevent conflict with MariaDB we need exclude MariaDB in yum. That it.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 15:57:07
Inform here 'yum list MariaDB*'.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 15:59:39
[root@ciosarnhem ~]# yum list MariaDB
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.nforce.com
 * extras: centos.ams.host-engine.com
 * mratwork-epel: mirror.nl.leaseweb.net
 * mratwork-ius-archive: mirror.amsiohosting.net
 * mratwork-ius-stable: mirror.amsiohosting.net
 * mratwork-release-neutral-noarch: rpms.mratwork.com
 * mratwork-release-version-arch: rpms.mratwork.com
 * mratwork-webtatic: uk.repo.webtatic.com
 * updates: mirrors.supportex.net
0 packages excluded due to repository protections
Error: No matching Packages to list
[root@ciosarnhem ~]#
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 16:08:56
You forgot * after MariaDB.

Again:
Code: [Select]
yum list MariaDB*
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 16:53:58
[root@ciosarnhem ~]# yum list MariaDB*
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.nforce.com
 * extras: centos.mirror.triple-it.nl
 * mratwork-epel: mirror.nl.leaseweb.net
 * mratwork-ius-archive: mirror.amsiohosting.net
 * mratwork-ius-stable: mirror.amsiohosting.net
 * mratwork-release-neutral-noarch: rpms.mratwork.com
 * mratwork-release-version-arch: rpms.mratwork.com
 * mratwork-webtatic: uk.repo.webtatic.com
 * updates: mirrors.supportex.net
0 packages excluded due to repository protections
Installed Packages
MariaDB-client.x86_64                   10.0.30-1.el6          @mratwork-mariadb
MariaDB-common.x86_64                   10.0.30-1.el6          @mratwork-mariadb
MariaDB-compat.x86_64                   10.0.30-1.el6          @mratwork-mariadb
MariaDB-devel.x86_64                    10.0.30-1.el6          @mratwork-mariadb
MariaDB-server.x86_64                   10.0.30-1.el6          @mratwork-mariadb
Available Packages
MariaDB-Galera-server.x86_64            10.0.30-1.el6          mratwork-mariadb
MariaDB-Galera-test.x86_64              10.0.30-1.el6          mratwork-mariadb
MariaDB-cassandra-engine.x86_64         10.0.30-1.el6          mratwork-mariadb
MariaDB-connect-engine.x86_64           10.0.30-1.el6          mratwork-mariadb
MariaDB-oqgraph-engine.x86_64           10.0.30-1.el6          mratwork-mariadb
MariaDB-shared.x86_64                   10.0.30-1.el6          mratwork-mariadb
MariaDB-test.x86_64                     10.0.30-1.el6          mratwork-mariadb
[root@ciosarnhem ~]#
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 17:00:55
Try 'yum install MariaDB-shared -y'.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 17:31:26
Done
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 17:46:36
And then try 'sh /script/restart' and try login to panel.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 17:51:04
[root@ciosarnhem ~]# sh /script/restart
/etc/init.d/kloxo: line 43: lxphp.exe: command not found
Stopping kloxo-phpcgi:                                     [FAILED]
Starting kloxo-phpcgi:                                     [FAILED]
Stopping kloxo-hiawatha:                                   [  OK  ]
Starting kloxo-hiawatha:                                   [  OK  ]
[root@ciosarnhem ~]#

Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 17:55:41
Try 'sh /script/phpm-installer php56s; sh /script/fixlxphpexe php56s; sh /script/restart'.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 17:58:13
My kloxo-mr is 6.5. Can I install php56s on kloxo-mr 6.5.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 18:44:10
My kloxo-mr is 6.5. Can I install php56s on kloxo-mr 6.5.
No. Only work for php52s.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 18:46:28
Can I install 'sh /script/phpm-installer php52s; sh /script/fixlxphpexe php52s; sh /script/restart'
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 18:58:52
Can I install 'sh /script/phpm-installer php52s; sh /script/fixlxphpexe php52s; sh /script/restart'

Sadly, phpm-installer only exists in Kloxo-MR 7.0.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 19:04:38
What can I do to get my panel kloxo-mr 6.5 online? I think php 5.2 has been uninstalled with YUM REMOVE MYSQL55-LIBS. Please look attachment MR-kloxo.pdf.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-05, 19:23:02
Try:
Code: [Select]
cd /tmp
yumdownloader php52s*
rpm -ivh php52s*.rpm --nodeps
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 19:44:00
[root@ciosarnhem tmp]# yumdownloader php52s*
Loaded plugins: fastestmirror, priorities, protectbase
Loading mirror speeds from cached hostfile
 * base: mirror.nforce.com
 * extras: centos.mirror.triple-it.nl
 * mratwork-epel: mirror.nl.leaseweb.net
 * mratwork-ius-archive: mirror.amsiohosting.net
 * mratwork-ius-stable: mirror.amsiohosting.net
 * mratwork-release-neutral-noarch: rpms.mratwork.com
 * mratwork-release-version-arch: rpms.mratwork.com
 * mratwork-webtatic: uk.repo.webtatic.com
 * updates: mirrors.supportex.net
0 packages excluded due to repository protections
No Match for argument php52s-module
Nothing to download
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-05, 22:42:15
PHP52s now turns but I get white screen in panel. Please look php52 error log.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: fossxplorer on 2017-05-05, 23:33:05
Based on the log, it's obvious that there is a mismatch between PHP and the modules it's trying to load.
I'm not familar with Kloxo-MR 6.5 at all, but what does lxphp -v now show you? And how did you install php52?




PHP52s now turns but I get white screen in panel. Please look php52 error log.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-06, 05:57:34
My advice update your Kloxo-MR 6.5 to 7.0 and follow step B.2 in https://github.com/mustafaramadhan/kloxo/blob/dev/how-to-install.txt
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-06, 10:54:51
Mustafa, all my data, settings, websites, dns settings, domains and clients of kloko-mr 6.5 are back in new kloxo-mr 7 ?
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: MRatWork on 2017-05-06, 11:58:01
Mustafa, all my data, settings, websites, dns settings, domains and clients of kloko-mr 6.5 are back in new kloxo-mr 7 ?
Yes, but you need adjustment for new environtment, like 'appeareace'.
Title: Re: Error: mysql55-libs conflicts with MariaDB-compat
Post by: zokkie on 2017-05-25, 19:37:33
Done, without error messages. Thanks Mustafa.