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

[Karsten Horsmann]

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>:

> 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>:
>
>> 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 Listsr-users at lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
> --
> Daniel-Constantin Mierla -- www.asipto.comwww.twitter.com/miconda -- 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*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20191022/1d383d78/attachment.html>