[SR-Users] driver error: Can't connect to MySQL server with kamailio 5.3.x and mysql-config-groups
Karsten Horsmann
khorsmann at gmail.com
Tue Oct 29 14:29:36 CET 2019
Hello Sergey,
thanks for the hints. Will be sure next time to honor your request.
Hope that the bugfix is backported from Daniel to 5.3, so i can also
migrate to 5.3 with the official rpms.
Cheers
Am Mo., 28. Okt. 2019 um 18:12 Uhr schrieb Sergey Safarov <
s.safarov at gmail.com>:
> Please check RPM packaged rpm OBS service. Link provides above.
> As you can used python2 deps.
> Need troubleshoot on your environment why generated so strange deps.
>
> I recommend start troubleshoot from build master branch with out any your
> modification
> Then add one by one your change commit (like "git bisect").
> And located what change introduce such behavior.
>
>
> On Mon, Oct 28, 2019 at 7:42 PM Karsten Horsmann <khorsmann at gmail.com>
> wrote:
>
>> Hi Sergey,
>>
>>
>> That string I forgot to remove. I add the company name to self build RPMS
>> to see what's from kamailio and what's build by myself. You can ignore
>> that.
>>
>> The strange python23 dependency comes as result of building the RPMS with
>> the shipped spec file. I only changed the version and build string (as
>> described above).
>>
>> And with branch 5.2 I don't have that behaviors.
>>
>> Anyway. I try to use the Kamailio builded versions if it's possible, in
>> this testing case I used the build process by myself.
>>
>> Cheers
>> Karsten
>>
>> Sergey Safarov <s.safarov at gmail.com> schrieb am Mo., 28. Okt. 2019,
>> 16:30:
>>
>>> please look install rpm content for "python23" string.
>>> Looks as this string introduced on your local PC.
>>>
>>> I have checked kamailio-5.3.0-14.1.x86_64.rpm
>>> <https://api.opensuse.org/build/home:kamailio:v5.3.x-rpms/CentOS_7/x86_64/kamailio53/kamailio-5.3.0-14.1.x86_64.rpm> in
>>> kamailio and found deps
>>>
>>> /bin/sh
>>> /bin/sh
>>> /bin/sh
>>> /bin/sh
>>> /usr/bin/python2
>>> config(kamailio) = 5.3.0-14.1
>>> libc.so.6()(64bit)
>>> libc.so.6(GLIBC_2.14)(64bit)
>>> libc.so.6(GLIBC_2.2.5)(64bit)
>>> libc.so.6(GLIBC_2.3)(64bit)
>>> libc.so.6(GLIBC_2.3.2)(64bit)
>>> libc.so.6(GLIBC_2.3.4)(64bit)
>>> libc.so.6(GLIBC_2.7)(64bit)
>>> libdl.so.2()(64bit)
>>> libdl.so.2(GLIBC_2.2.5)(64bit)
>>> libm.so.6()(64bit)
>>> libm.so.6(GLIBC_2.2.5)(64bit)
>>> libprint.so.1()(64bit)
>>> libresolv.so.2()(64bit)
>>> libresolv.so.2(GLIBC_2.2.5)(64bit)
>>> libsrdb1.so.1()(64bit)
>>> libsrdb2.so.1()(64bit)
>>> libsrutils.so.1()(64bit)
>>> libtrie.so.1()(64bit)
>>> rpmlib(CompressedFileNames) <= 3.0.4-1
>>> rpmlib(FileDigests) <= 4.6.0-1
>>> rpmlib(PartialHardlinkSets) <= 4.0.4-1
>>> rpmlib(PayloadFilesHavePrefix) <= 4.0-1
>>> rtld(GNU_HASH)
>>> rpmlib(PayloadIsXz) <= 5.2-1
>>>
>>> Also you reps have other strange string "config(kamailio) = 5.3.0-14.el7.
>>> centos.4com"
>>>
>>> Please read
>>> https://github.com/kamailio/kamailio/blob/master/pkg/kamailio/README.md
>>> RPM section
>>>
>>>
>>> On Mon, Oct 28, 2019 at 5:02 PM Karsten Horsmann <khorsmann at gmail.com>
>>> wrote:
>>>
>>>> Hello Daniel,
>>>>
>>>> i have a good news and bad news.
>>>>
>>>> First the good one:
>>>>
>>>> I tried the master and it works for me now with DBURL.
>>>>
>>>> kamailio -v
>>>> version: kamailio 5.4.0-dev1 (x86_64/linux)
>>>> flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS,
>>>> DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC,
>>>> F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT,
>>>> USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST,
>>>> HAVE_RESOLV_RES
>>>> ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE
>>>> 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
>>>> poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
>>>> id: unknown
>>>> compiled on 13:04:06 Oct 28 2019 with gcc 4.8.5
>>>> [root at sipedge1 ~]# grep DBURL /etc/kamailio/kamailio-local.cfg
>>>> #!define DBURL "mysql://[kamailio]/kamailio"
>>>>
>>>> [root at sipedge1 ~]# grep '\[' /etc/kamailio/modules.cfg
>>>> modparam("sqlops", "sqlcon", "cb=>mysql://[kamailio]/kamailio")
>>>>
>>>> The bad news: SPEC File seems broken for the dependency on CENTOS 7.7
>>>> Self generated RPMS got /usr/bin/python23 as dependecy. This file not
>>>> exits.
>>>>
>>>>
>>>> rpm -qp kamailio-5.3.0-14.el7.centos.x86_64.rpm --requires
>>>> /bin/sh
>>>> /bin/sh
>>>> /bin/sh
>>>> /bin/sh
>>>> /usr/bin/python23
>>>> config(kamailio) = 5.3.0-14.el7.centos.4com
>>>> libc.so.6()(64bit)
>>>> libc.so.6(GLIBC_2.14)(64bit)
>>>> libc.so.6(GLIBC_2.2.5)(64bit)
>>>> libc.so.6(GLIBC_2.3)(64bit)
>>>> libc.so.6(GLIBC_2.3.2)(64bit)
>>>> libc.so.6(GLIBC_2.3.4)(64bit)
>>>> libc.so.6(GLIBC_2.7)(64bit)
>>>> libdl.so.2()(64bit)
>>>> libdl.so.2(GLIBC_2.2.5)(64bit)
>>>> libm.so.6()(64bit)
>>>> libm.so.6(GLIBC_2.2.5)(64bit)
>>>> libprint.so.1()(64bit)
>>>> libresolv.so.2()(64bit)
>>>> libresolv.so.2(GLIBC_2.2.5)(64bit)
>>>> libsrdb1.so.1()(64bit)
>>>> libsrdb2.so.1()(64bit)
>>>> libsrutils.so.1()(64bit)
>>>> libtrie.so.1()(64bit)
>>>> rpmlib(CompressedFileNames) <= 3.0.4-1
>>>> rpmlib(FileDigests) <= 4.6.0-1
>>>> rpmlib(PartialHardlinkSets) <= 4.0.4-1
>>>> rpmlib(PayloadFilesHavePrefix) <= 4.0-1
>>>> rtld(GNU_HASH)
>>>> rpmlib(PayloadIsXz) <= 5.2-1
>>>>
>>>> Am Fr., 25. Okt. 2019 um 12:58 Uhr schrieb Daniel-Constantin Mierla <
>>>> miconda at gmail.com>:
>>>>
>>>>> Hello,
>>>>>
>>>>> can you try with the patch from next commit:
>>>>>
>>>>> -
>>>>> https://github.com/kamailio/kamailio/commit/2aa614d49f4917faec62534a51fcf8ddfc5fb870
>>>>>
>>>>> If all ok, then I will backport.
>>>>>
>>>>> Cheers,
>>>>> Daniel
>>>>> On 25.10.19 12:50, Karsten Horsmann wrote:
>>>>>
>>>>> Hi Henning,
>>>>>
>>>>> changing a parser without understanding the parser is dangerous. IMHO
>>>>> the [groupname] will be given to the mysql-libs.
>>>>> I am not so deep inside kamailio c-code to full understand that case.
>>>>>
>>>>> Am Mi., 23. Okt. 2019 um 18:29 Uhr schrieb Henning Westerholt <
>>>>> hw at skalatan.de>:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>>
>>>>>>
>>>>>> just an idea – maybe the easiest way would be to introduce another
>>>>>> character for the groups, e.g. ‘{ }’ or similar. The overlapping between
>>>>>> IPv6 and groups was not intended, the group support is probably older as
>>>>>> IPv6 in Kamailio. 😉
>>>>>>
>>>>>>
>>>>>>
>>>>>> Cheers,
>>>>>>
>>>>>>
>>>>>>
>>>>>> Henning
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> Henning Westerholt - https://skalatan.de/blog/
>>>>>>
>>>>>> Kamailio services - https://skalatan.de/services
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* sr-users <sr-users-bounces at lists.kamailio.org> *On Behalf Of
>>>>>> *Karsten Horsmann
>>>>>> *Sent:* Wednesday, October 23, 2019 6:17 PM
>>>>>> *To:* Daniel-Constantin Mierla <miconda at gmail.com>
>>>>>> *Cc:* Kamailio (SER) - Users Mailing List <
>>>>>> sr-users at lists.kamailio.org>
>>>>>> *Subject:* Re: [SR-Users] driver error: Can't connect to MySQL
>>>>>> server with kamailio 5.3.x and mysql-config-groups
>>>>>>
>>>>>>
>>>>>>
>>>>>> Hi Daniel,
>>>>>>
>>>>>>
>>>>>>
>>>>>> you mean this commit (see below). Maybe Alexey Vasilyev can told us
>>>>>> something to that change?
>>>>>>
>>>>>>
>>>>>>
>>>>>> How can i use mysql-groups in the [] notation? Like:
>>>>>>
>>>>>> #!define DBURL "mysql://[kamailio]/kamailio"
>>>>>>
>>>>>> https://kamailio.org/docs/modules/5.3.x/modules/db_mysql.html#idm140
>>>>>>
>>>>>>
>>>>>>
>>>>>> AFAIK this change splits [ and ] to ipv6 Host and sets ST_HOST6 and
>>>>>>
>>>>>>
>>>>>>
>>>>>> commit a7588f382605991bef4499de8c89b10a9468c8cf
>>>>>> Author: Alexey Vasilyev <alexei.vasilyev at gmail.com>
>>>>>> Date: Wed Sep 4 13:47:23 2019 +0300
>>>>>>
>>>>>> db_mysql: database URL supports IPv6 address as hostname
>>>>>>
>>>>>> - changed parsing of db_url to accept IPv6 address for hostname
>>>>>>
>>>>>>
>>>>>>
>>>>>> Any help would be appreciated.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Cheers Karsten
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Am Mi., 23. Okt. 2019 um 08:10 Uhr schrieb Daniel-Constantin Mierla <
>>>>>> miconda at gmail.com>:
>>>>>>
>>>>>> 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>:
>>>>>>
>>>>>> 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 List
>>>>>>
>>>>>> sr-users at lists.kamailio.org
>>>>>>
>>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>>>>>
>>>>>> --
>>>>>>
>>>>>> 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
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> 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
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> Mit freundlichen Grüßen
>>>>>> *Karsten Horsmann*
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Mit freundlichen Grüßen
>>>>> *Karsten Horsmann*
>>>>>
>>>>> --
>>>>> 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
>>>
>> _______________________________________________
>> 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/20191029/d1080911/attachment.html>
More information about the sr-users
mailing list