Use MySQL connector instead of mariadb connector - sr-users

Sergey Safarov

10 Mar 10 Mar

11:11 a.m.

Which dist are you using? On Thu, Mar 9, 2023 at 8:35 PM suchendra adiga <suchendraadigainfo(a)gmail.com> wrote:

Hi, I have been working on setting up the database with the Kamailio server. But facing a problem when my db user has configured with SSL required. But I learnt that there is no support to enable the SSL in mariadb connector. So I am thinking of using the MySQL connector instead. Is there anyway I could configure the kamailio to use MySQL instead of Mariadb? Thanks and regards, Suchendra __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:

Reply

Sergey Safarov

11 Mar 11 Mar

9:30 a.m.

technically MariaDB supports TLS on the client and server side. https://mariadb.com/kb/en/securing-connections-for-client-and-server/ Could you make sure in your dist it is also supported out of the box? On Fri, Mar 10, 2023 at 8:02 PM suchendra adiga < suchendraadigainfo(a)gmail.com> wrote:

...

It's Debian 11. On Fri, 10 Mar, 2023, 10:05 pm Sergey Safarov, <s.safarov(a)gmail.com> wrote:

Which dist are you using? On Thu, Mar 9, 2023 at 8:35 PM suchendra adiga < suchendraadigainfo(a)gmail.com> wrote:

Hi, I have been working on setting up the database with the Kamailio server. But facing a problem when my db user has configured with SSL required. But I learnt that there is no support to enable the SSL in mariadb connector. So I am thinking of using the MySQL connector instead. Is there anyway I could configure the kamailio to use MySQL instead of Mariadb? Thanks and regards, Suchendra __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:

__________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:

Reply

Sergey Safarov

5:45 p.m.

What is Kamailio output when it started? On Sat, Mar 11, 2023 at 6:42 PM suchendra adiga < suchendraadigainfo(a)gmail.com> wrote:

...

Yes, I was actually able to conenct it via the client(cli) by just providing the --ssl flag . But I couldn't connect from the connector which Kamailio uses internally. Also I see in the Kamailio code that SSL is not supported if the detected connector is Maria db in db_mysql module. Is my understanding correct? I'm using 5.6.4 kamailio. On Sat, 11 Mar, 2023, 8:39 pm Sergey Safarov, <s.safarov(a)gmail.com> wrote:

technically MariaDB supports TLS on the client and server side. https://mariadb.com/kb/en/securing-connections-for-client-and-server/ Could you make sure in your dist it is also supported out of the box? On Fri, Mar 10, 2023 at 8:02 PM suchendra adiga < suchendraadigainfo(a)gmail.com> wrote:

It's Debian 11. On Fri, 10 Mar, 2023, 10:05 pm Sergey Safarov, <s.safarov(a)gmail.com> wrote:

Which dist are you using? On Thu, Mar 9, 2023 at 8:35 PM suchendra adiga < suchendraadigainfo(a)gmail.com> wrote: > Hi, > > I have been working on setting up the database with the Kamailio > server. But facing a problem when my db user has configured with SSL > required. But I learnt that there is no support to enable the SSL in > mariadb connector. So I am thinking of using the MySQL connector instead. > Is there anyway I could configure the kamailio to use MySQL instead of > Mariadb? > > Thanks and regards, > Suchendra > __________________________________________________________ > Kamailio - Users Mailing List - Non Commercial Discussions > To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org > Important: keep the mailing list in the recipients, do not reply only > to the sender! > Edit mailing list options or unsubscribe: > __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:

__________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:

Reply

suchendra adiga

14 Mar 14 Mar

12:25 a.m.

Finally found out that debain 11 default MySQL dev library defaults to mariadb. So the SSL support has not handled in Kam. Switching to libmysqlclient solved the issue. Thanks for the support and your valuable time. On Sun, 12 Mar, 2023, 8:49 am suchendra adiga, <suchendraadigainfo(a)gmail.com> wrote:

...

Couldn't open connection Access denied. Also I tried capturing the packets it clearly showed that SSL handshake is not initiated. On Sun, 12 Mar, 2023, 4:54 am Sergey Safarov, <s.safarov(a)gmail.com> wrote:

What is Kamailio output when it started? On Sat, Mar 11, 2023 at 6:42 PM suchendra adiga < suchendraadigainfo(a)gmail.com> wrote:

Yes, I was actually able to conenct it via the client(cli) by just providing the --ssl flag . But I couldn't connect from the connector which Kamailio uses internally. Also I see in the Kamailio code that SSL is not supported if the detected connector is Maria db in db_mysql module. Is my understanding correct? I'm using 5.6.4 kamailio. On Sat, 11 Mar, 2023, 8:39 pm Sergey Safarov, <s.safarov(a)gmail.com> wrote:

technically MariaDB supports TLS on the client and server side. https://mariadb.com/kb/en/securing-connections-for-client-and-server/ Could you make sure in your dist it is also supported out of the box? On Fri, Mar 10, 2023 at 8:02 PM suchendra adiga < suchendraadigainfo(a)gmail.com> wrote: > It's Debian 11. > > On Fri, 10 Mar, 2023, 10:05 pm Sergey Safarov, <s.safarov(a)gmail.com> > wrote: > >> Which dist are you using? >> >> On Thu, Mar 9, 2023 at 8:35 PM suchendra adiga < >> suchendraadigainfo(a)gmail.com> wrote: >> >>> Hi, >>> >>> I have been working on setting up the database with the Kamailio >>> server. But facing a problem when my db user has configured with SSL >>> required. But I learnt that there is no support to enable the SSL in >>> mariadb connector. So I am thinking of using the MySQL connector instead. >>> Is there anyway I could configure the kamailio to use MySQL instead of >>> Mariadb? >>> >>> Thanks and regards, >>> Suchendra >>> __________________________________________________________ >>> Kamailio - Users Mailing List - Non Commercial Discussions >>> To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org >>> Important: keep the mailing list in the recipients, do not reply >>> only to the sender! >>> Edit mailing list options or unsubscribe: >>> >> __________________________________________________________ >> Kamailio - Users Mailing List - Non Commercial Discussions >> To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org >> Important: keep the mailing list in the recipients, do not reply only >> to the sender! >> Edit mailing list options or unsubscribe: >> > __________________________________________________________ > Kamailio - Users Mailing List - Non Commercial Discussions > To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org > Important: keep the mailing list in the recipients, do not reply only > to the sender! > Edit mailing list options or unsubscribe: > __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:

__________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-leave(a)lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:

Reply