[SR-Users] URL problems connecting to external (Azure) MySQL database

[Floimair Florian]

Thanks!

I have created a patch and submitted a pull request: https://github.com/kamailio/kamailio/pull/1346

This patch will allow '@' in usernames and/or passwords as well and only treat the last occurrence of '@'
as a separator between the username:password and the host:port/db parts.



With best regards

Florian Floimair

COMMEND INTERNATIONAL GMBH
A-5020 Salzburg, Saalachstraße 51
http://www.commend.com<http://www.commend.com/>

Security and Communication by Commend

FN 178618z | LG Salzburg

Von: sr-users [mailto:sr-users-bounces at lists.kamailio.org] Im Auftrag von Samuel F.
Gesendet: Montag, 27. November 2017 22:19
An: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
Betreff: Re: [SR-Users] URL problems connecting to external (Azure) MySQL database


Hi again,



Reviewing the source for the parsing function it looks like it won't be possible.



https://github.com/kamailio/kamailio/blob/5295a4f5eac08c1bb100bf554a995833c434c4dc/src/modules/db_mysql/my_uri.c#L147

We see that once it hits the @, if it hasn't hit a : or / before it will assume everything to the left of the @ is the username and then it will start to parse everything to the right of the @ as the hostname.

In your case the host will be: clouddb and the port will be: password at clouddb.mysql.database.azure.com<mailto:password at clouddb.mysql.database.azure.com>

Have you checked the docs under section 6?:

6. Reading configuration from my.cnf



Not sure how that is implemented to fetch the data but that might perhaps be a way to get around the parsing structure in the mysql module.



Also, feel free to submit a patch for the above parsing function if possible.


// Samuel



________________________________
From: sr-users <sr-users-bounces at lists.kamailio.org<mailto:sr-users-bounces at lists.kamailio.org>> on behalf of Floimair Florian <f.floimair at commend.com<mailto:f.floimair at commend.com>>
Sent: Monday, November 27, 2017 4:47:52 PM
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] URL problems connecting to external (Azure) MySQL database


Thanks for your quick reply!



Unfortunately the result is exactly the same error.







With best regards

Florian Floimair



Von: sr-users [mailto:sr-users-bounces at lists.kamailio.org] Im Auftrag von Samuel F.
Gesendet: Montag, 27. November 2017 16:04
An: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org<mailto:sr-users at lists.kamailio.org>>
Betreff: Re: [SR-Users] URL problems connecting to external (Azure) MySQL database



Hey,



Could you try replacing the @-sign in the username with: %40  (percent-forty)?



// Samuel

________________________________

From: sr-users <sr-users-bounces at lists.kamailio.org<mailto:sr-users-bounces at lists.kamailio.org>> on behalf of Floimair Florian <f.floimair at commend.com<mailto:f.floimair at commend.com>>
Sent: Monday, November 27, 2017 3:33:21 PM
To: Kamailio (SER) - Users Mailing List
Subject: [SR-Users] URL problems connecting to external (Azure) MySQL database



Hi!



I'm having troubles connecting Kamailio to an external MySQL database (on Microsoft Azure Cloud).

Initially creating the database with kamctl worked fine, but accessing it at runtime via db_url fails.



A somewhat unusual thing about the connection to a MySQL database on Azure is that the username contains an '@' character.

This leads me to believe that this case is somewhat unhandled when parsing the database URI.



Trying to connect to something like



modparam("sipcapture", "db_url", "mysql://user@clouddb:password@clouddb.mysql.database.azure.com/db")



Results in errors starting Kamailio



ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection(): driver error: Unknown MySQL server host 'clouddb' (-2)

ERROR: <core> [db.c:318]: db_do_init2(): could not add connection to the pool

ERROR: sipcapture [sipcapture.c:1146]: child_init(): unable to connect to database [mysql://user@clouddb:password@clouddb.mysql.database.azure.com/db] from capture_mode param.

Is there a trick on how to achieve a connection in this case like some sort of escape character probably?





Mit freundlichen Grüßen

Florian Floimair (IMS) 1568




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171129/ea5afcf9/attachment.html>