[SR-Users] driver error: Can't connect to MySQL server with kamailio 5.3.x and mysql-config-groups

Wed Oct 23 08:10:54 CEST 2019

Hello,

it could be that a patch to support ipv6 in the db url is conflicting
with the syntax for the group name, because both seem to use [ ] . Iirc,
such a commit was not long time ago. I will have to look at the code for
mysql conf group to see what exactly it expects, not sure I got time for
it today, though, maybe others can check quicker.

Cheers,
Daniel

On 22.10.19 16:38, Karsten Horsmann wrote:
> Hi Daniel,
>
> i create an Logfile with debug=3 on startup
> here: https://gist.github.com/khorsmann/91642daaa3715c59624cd5272bc3398a#file-logfile-txt-L4345  
>
>  0(29174) DEBUG: db_mysql [km_my_con.c:108]:
> db_mysql_new_connection(): opening connection:
> mysql://xxxx:xxxx@kamailio/kamailio
> I dont know where kamailio though that there is an "hostname" kamailio
> that holds the mysqldb/kamailio.
>
> I want to use groups in the future - cos i auto-generate
> mysql-passwords with / for example and that is possible in groups, but
> i dunno how in normal defines.
>
> Cheers
> Karsten
>
> Am Di., 22. Okt. 2019 um 15:40 Uhr schrieb Daniel-Constantin Mierla
> <miconda at gmail.com <mailto:miconda at gmail.com>>:
>
>     Hello,
>
>     if you set debug=3, do you see any other log message that can give
>     hints about the error?
>
>     I do not recall any change in using mysql conf groups, but there
>     were some changes in supporting usernames with domains and few
>     other updates that could have affected indirectly this part.
>
>     Cheers,
>     Daniel
>
>     On 22.10.19 15:20, Karsten Horsmann wrote:
>>     Hi List,
>>
>>     me again - i also updated the test-system to latest CentOS
>>     7.7.1908 to be sure that the rpm building source and my target
>>     system are on the same versions.
>>
>>      lsb_release -a
>>     LSB Version:    :core-4.1-amd64:core-4.1-noarch
>>     Distributor ID: CentOS
>>     Description:    CentOS Linux release 7.7.1908 (Core)
>>     Release:        7.7.1908
>>     Codename:       Core
>>
>>     Am Di., 22. Okt. 2019 um 14:58 Uhr schrieb Karsten Horsmann
>>     <khorsmann at gmail.com <mailto:khorsmann at gmail.com>>:
>>
>>         Hi List,
>>
>>         i updated one of my testing kamailios from 5.2.x to latest 5.3.x.
>>         After restarting the process, i got an mysql error that the
>>         server "kamailio" is not found.
>>
>>         I use the config-feature of my.cnf config-group names within
>>         the kamailio.cfg
>>         I can start my kamailio 5.3.x installation with "normal
>>         username:password at host" definitions for DBURL.
>>
>>         Did anyone have the same issue?
>>
>>
>>          0(19625) ERROR: db_mysql [km_my_con.c:139]:
>>         db_mysql_new_connection(): driver error: Can't connect to
>>         MySQL server on 'kamailio' (4)
>>          0(19625) ERROR: <core> [db.c:319]: db_do_init2(): could not
>>         add connection to the pool
>>          0(19625) ERROR: dialplan [dp_db.c:179]: dp_connect_db():
>>         unable to connect to the database
>>          0(19625) ERROR: dialplan [dialplan.c:191]: mod_init(): could
>>         not initialize data
>>          0(19625) ERROR: <core> [core/sr_module.c:850]: init_mod():
>>         Error while initializing module dialplan
>>         (/usr/lib64/kamailio/modules/dialplan.so)
>>         ERROR: error while initializing modules
>>
>>
>>         from my kamailio.cfg i defined the DBURL like this:
>>
>>         # Use /etc/my.cnf.d/kamailio.cnf to store credentials
>>         # within a mysql-db-group
>>         #!define DBURL "mysql://[kamailio]/kamailio"
>>
>>         and special modules can use it like this (or via DBURL)
>>         modparam("sqlops", "sqlcon", "cb=>mysql://[kamailio]/kamailio")
>>
>>         cat /etc/my.cnf.d/kamailio.cnf
>>
>>         # MySQL configuration group for kamailio
>>         [kamailio]
>>         user=kamailio
>>         password="kamailiorw"
>>         host=172.20.100.22
>>
>>
>>         rpm -qa | grep kam
>>         kamailio-dialplan-5.3.0-13.1.x86_64
>>         kamailio-websocket-5.3.0-13.1.x86_64
>>         kamailio-jansson-5.3.0-13.1.x86_64
>>         kamailio-mysql-5.3.0-13.1.x86_64
>>         kamailio-tls-5.3.0-13.1.x86_64
>>         kamailio-ims-5.3.0-13.1.x86_64
>>         kamailio-statsd-5.3.0-13.1.x86_64
>>         kamailio-5.3.0-13.1.x86_64
>>         kamailio-redis-5.3.0-13.1.x86_64
>>
>>          cat /etc/redhat-release
>>         CentOS Linux release 7.6.1810 (Core)
>>
>>         -- 
>>         Cheers
>>         *Karsten Horsmann*
>>
>>
>>
>>     -- 
>>     Mit freundlichen Grüßen
>>     *Karsten Horsmann*
>>
>>     _______________________________________________
>>     Kamailio (SER) - Users Mailing List
>>     sr-users at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>
>>     https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
>     -- 
>     Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
>     www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
>     Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat
>
>
>
> -- 
> Mit freundlichen Grüßen
> *Karsten Horsmann*

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat

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