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

[Karsten Horsmann]

Hi Sergey,

i set in my /etc/hosts an host entry names kamailio to see more.

i tried that and i saw that the process kamailio is trying to reach "host:
kamailio" with user=kamailio schemata=kamailio and password=kamailio on the
wire.
That seems to be the "defaults" if no values is found.

I thing that the IPv6 Patch Idea from Daniel is more the root-cause [] is
essential in ipv6 and its an pointer for DBURL/mysql-groups.


Am Di., 22. Okt. 2019 um 19:35 Uhr schrieb Sergey Safarov <
s.safarov at gmail.com>:

> Could you record network traffic into PCAP like
> tcpdump -ni any host ${mysql_server_ip} -s 0 -w /tmp/mysql.pcap
>
> then sent.Will try look into network traffic.
>
> On Tue, Oct 22, 2019 at 5:39 PM Karsten Horsmann <khorsmann at gmail.com>
> 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>:
>>
>>> 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*
>> _______________________________________________
>> Kamailio (SER) - Users Mailing List
>> sr-users at lists.kamailio.org
>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>


-- 
Mit freundlichen Grüßen
*Karsten Horsmann*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20191023/54e33eab/attachment.html>