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.comhttps://gilawa.com/

From: sr-users sr-users-bounces@lists.kamailio.org On Behalf Of Sergey Safarov Sent: Thursday, December 1, 2022 11:03 AM To: Kamailio (SER) - Users Mailing List sr-users@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@gmail.commailto:beingshailendra@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@lists.kamailio.orgmailto:sr-users@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

I think CentOS files located here https://centos.pkgs.org/9-stream/centos-crb-x86_64/2/

[image: image.png]

On Thu, Dec 1, 2022 at 2:53 PM Shailendra Paliwal beingshailendra@gmail.com wrote:

Hi all,

Adding the Mysql Yum Repo list helped resolve this error

https://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-r...

I am now able to install kamailio-mysql and proceed with the installation.

On Thu, 1 Dec 2022 at 15:46, Henning Westerholt hw@gilawa.com wrote:

...

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

*From:* sr-users sr-users-bounces@lists.kamailio.org *On Behalf Of *Sergey Safarov *Sent:* Thursday, December 1, 2022 11:03 AM *To:* Kamailio (SER) - Users Mailing List sr-users@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@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@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

---

Kamailio - Users Mailing List - Non Commercial Discussions sr-users@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

---

Kamailio - Users Mailing List - Non Commercial Discussions sr-users@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

Hi Sergey,

I do see "crb" defined in the centos.repo file but I do not see similar results here,

➜ yum.repos.d dnf whatprovides mysql-libs Last metadata expiration check: 0:08:39 ago on Thursday 01 December 2022 04:58:43 AM. Error: No matches found. If searching for a file, try specifying the full path or using a wildcard prefix ("*/") at the beginning.

The version of the package that owns centos.repo file is also different in my case, ➜ yum.repos.d rpm -qf /etc/yum.repos.d/centos.repo centos-stream-repos-9.0-18.el9.noarch

If my CentOS version is an issue, I can downgrade or switch to a distro with better support as well.

On Thu, 1 Dec 2022 at 15:34, Sergey Safarov s.safarov@gmail.com wrote:

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@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@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

---

Kamailio - Users Mailing List - Non Commercial Discussions sr-users@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