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
Hey,
Could you try replacing the @-sign in the username with: %40 (percent-forty)?
// Samuel
________________________________ From: sr-users sr-users-bounces@lists.kamailio.org on behalf of Floimair Florian f.floimair@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
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@lists.kamailio.org] Im Auftrag von Samuel F. Gesendet: Montag, 27. November 2017 16:04 An: Kamailio (SER) - Users Mailing List sr-users@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> on behalf of Floimair Florian <f.floimair@commend.commailto:f.floimair@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
Hi again,
Reviewing the source for the parsing function it looks like it won't be possible.
https://github.com/kamailio/kamailio/blob/5295a4f5eac08c1bb100bf554a995833c4...
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@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@lists.kamailio.org on behalf of Floimair Florian f.floimair@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@lists.kamailio.org] Im Auftrag von Samuel F. Gesendet: Montag, 27. November 2017 16:04 An: Kamailio (SER) - Users Mailing List sr-users@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> on behalf of Floimair Florian <f.floimair@commend.commailto:f.floimair@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
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.comhttp://www.commend.com/
Security and Communication by Commend
FN 178618z | LG Salzburg
Von: sr-users [mailto:sr-users-bounces@lists.kamailio.org] Im Auftrag von Samuel F. Gesendet: Montag, 27. November 2017 22:19 An: Kamailio (SER) - Users Mailing List sr-users@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/5295a4f5eac08c1bb100bf554a995833c4...
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@clouddb.mysql.database.azure.commailto:password@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> on behalf of Floimair Florian <f.floimair@commend.commailto:f.floimair@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@lists.kamailio.org] Im Auftrag von Samuel F. Gesendet: Montag, 27. November 2017 16:04 An: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@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@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> on behalf of Floimair Florian <f.floimair@commend.commailto:f.floimair@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
-
Floimair Florian -
Samuel F.