[SR-Users] Unable to install kamailio-mysql on CentOS 9

[Henning Westerholt]

Hi Sergey,

for debian we are using some virtual packages (e.g. default-mysql-client) which then depends on the actual DB, usually MariaDB.
https://packages.debian.org/bullseye/default-mysql-client

Not sure if there is a similar way in CentOS. If MariaDB is default now in CentOS 9 for example and MySQL is only provided from another external repository, it certainly make sense to use the default MariaDB.

Cheers,

Henning

--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com<https://gilawa.com/>

From: sr-users <sr-users-bounces at lists.kamailio.org> On Behalf Of Sergey Safarov
Sent: Thursday, December 1, 2022 11:03 AM
To: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
Subject: Re: [SR-Users] Unable to install kamailio-mysql on CentOS 9

bash-5.1# dnf whatprovides mysql-libs
Last metadata expiration check: 0:03:01 ago on Thu Dec  1 09:56:43 2022.
mysql-libs-8.0.22-7.el9.x86_64 : The shared libraries required for MySQL clients
Repo        : crb
Matched from:
Provide    : mysql-libs = 8.0.22-7.el9

mysql-libs-8.0.27-1.el9.x86_64 : The shared libraries required for MySQL clients
Repo        : crb
Matched from:
Provide    : mysql-libs = 8.0.27-1.el9

mysql-libs-8.0.28-1.el9.x86_64 : The shared libraries required for MySQL clients
Repo        : crb
Matched from:
Provide    : mysql-libs = 8.0.28-1.el9

mysql-libs-8.0.30-1.el9.x86_64 : The shared libraries required for MySQL clients
Repo        : @System
Matched from:
Provide    : mysql-libs = 8.0.30-1.el9

mysql-libs-8.0.30-1.el9.x86_64 : The shared libraries required for MySQL clients
Repo        : crb
Matched from:
Provide    : mysql-libs = 8.0.30-1.el9

mysql-libs-8.0.30-3.el9.x86_64 : The shared libraries required for MySQL clients
Repo        : crb
Matched from:
Provide    : mysql-libs = 8.0.30-3.el9
"crb" defined in the "/etc/yum.repos.d/centos.repo" file.
This file part of

bash-5.1# rpm -qf /etc/yum.repos.d/centos.repo
centos-stream-repos-9.0-12.el9.noarch

If this does not work for your, please let me know.

Question for the community.
Should we switch from MySQL lib usage to MariaDB lib usage?

On Thu, Dec 1, 2022 at 12:04 PM Shailendra Paliwal <beingshailendra at gmail.com<mailto:beingshailendra at gmail.com>> wrote:
Hello,

I'm trying to set up kamailio on a Cent OS 9 server but I'm unable to install the kamailio-mysql module. Can someone suggest any possible solutions here,

Tried to setup kamdbctl after changing the configuration to use mysql,
➜  ~ kamdbctl create
ERROR: could not load the script in /usr/lib64/kamailio//kamctl/kamdbctl.mysql for database engine MYSQL
ERROR: database engine not loaded - tried 'MYSQL'

Contents of /usr/lib64/kamailio/kamctl/, I'm not sure why there's a double slash in the message above
➜  ~ ls /usr/lib64/kamailio/kamctl/
dbtextdb  kamctl.base  kamctl.ctlbase  kamctl.dbtext  kamctl.rpcfifo  kamctl.ser  kamctl.sqlbase  kamdbctl.base  kamdbctl.dbtext

I'm unable to install kamailio-mysql
➜  ~ dnf install kamailio-mysql
Last metadata expiration check: 0:00:23 ago on Thursday 01 December 2022 03:53:45 AM.
Error:
 Problem: conflicting requests
  - nothing provides libmysqlclient.so.21()(64bit) needed by kamailio-mysql-5.6.2-0.el9.centos.x86_64
  - nothing provides libmysqlclient.so.21(libmysqlclient_21.0)(64bit) needed by kamailio-mysql-5.6.2-0.el9.centos.x86_64
  - nothing provides mysql-libs needed by kamailio-mysql-5.6.2-0.el9.centos.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

I've checked that I do have the following repolists,
➜  kamctl dnf repolist
repo id                                                  repo name
appstream                                                CentOS Stream 9 - AppStream
baseos                                                   CentOS Stream 9 - BaseOS
epel                                                     Extra Packages for Enterprise Linux 9 - x86_64
epel-next                                                Extra Packages for Enterprise Linux 9 - Next - x86_64
extras-common                                            CentOS Stream 9 - Extras packages
kamailio                                                 Kamailio - latest - Packages for the Kamailio latest release
mariadb-main                                             MariaDB Server
mariadb-maxscale                                         MariaDB MaxScale
mariadb-tools                                            MariaDB Tools
tailscale-stable                                         Tailscale stable

This is after a fresh installation of CentOS 9. I believe that I might have a missing repolist or probably have something incorrect in the configuration.
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
sr-users at lists.kamailio.org<mailto:sr-users at lists.kamailio.org>
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20221201/2006582e/attachment.htm>