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

[Floimair Florian]

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>
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/20171127/34f22d9b/attachment.html>