<div dir="ltr">Hello Daniel,<div><br></div><div>i have a good news and bad news.</div><div><br></div><div>First the good one:</div><div><br></div><div>I tried the master and it works for me now with DBURL.</div><div><br></div><div>kamailio -v<br>version: kamailio 5.4.0-dev1 (x86_64/linux)<br>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<br>ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB<br>poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.<br>id: unknown<br>compiled on 13:04:06 Oct 28 2019 with gcc 4.8.5<br>[root@sipedge1 ~]# grep DBURL /etc/kamailio/kamailio-local.cfg<br>#!define DBURL "mysql://[kamailio]/kamailio"<br><br>[root@sipedge1 ~]# grep '\[' /etc/kamailio/modules.cfg<br>modparam("sqlops", "sqlcon", "cb=>mysql://[kamailio]/kamailio")<br></div><div><br></div><div>The bad news: SPEC File seems broken for the dependency on CENTOS 7.7</div><div>Self generated RPMS got
/usr/bin/python23 as dependecy. This file not exits.</div><div><br></div><div><br></div><div> rpm -qp kamailio-5.3.0-14.el7.centos.x86_64.rpm --requires<br>/bin/sh<br>/bin/sh<br>/bin/sh<br>/bin/sh<br>/usr/bin/python23<br>config(kamailio) = 5.3.0-14.el7.centos.4com<br>libc.so.6()(64bit)<br>libc.so.6(GLIBC_2.14)(64bit)<br>libc.so.6(GLIBC_2.2.5)(64bit)<br>libc.so.6(GLIBC_2.3)(64bit)<br>libc.so.6(GLIBC_2.3.2)(64bit)<br>libc.so.6(GLIBC_2.3.4)(64bit)<br>libc.so.6(GLIBC_2.7)(64bit)<br>libdl.so.2()(64bit)<br>libdl.so.2(GLIBC_2.2.5)(64bit)<br>libm.so.6()(64bit)<br>libm.so.6(GLIBC_2.2.5)(64bit)<br>libprint.so.1()(64bit)<br>libresolv.so.2()(64bit)<br>libresolv.so.2(GLIBC_2.2.5)(64bit)<br>libsrdb1.so.1()(64bit)<br>libsrdb2.so.1()(64bit)<br>libsrutils.so.1()(64bit)<br>libtrie.so.1()(64bit)<br>rpmlib(CompressedFileNames) <= 3.0.4-1<br>rpmlib(FileDigests) <= 4.6.0-1<br>rpmlib(PartialHardlinkSets) <= 4.0.4-1<br>rpmlib(PayloadFilesHavePrefix) <= 4.0-1<br>rtld(GNU_HASH)<br>rpmlib(PayloadIsXz) <= 5.2-1<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Am Fr., 25. Okt. 2019 um 12:58 Uhr schrieb Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<p>Hello,</p>
<p>can you try with the patch from next commit:</p>
<p> - <a href="https://github.com/kamailio/kamailio/commit/2aa614d49f4917faec62534a51fcf8ddfc5fb870" target="_blank">https://github.com/kamailio/kamailio/commit/2aa614d49f4917faec62534a51fcf8ddfc5fb870</a></p>
<p>If all ok, then I will backport.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div>On 25.10.19 12:50, Karsten Horsmann
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi Henning,
<div><br>
</div>
<div>changing a parser without understanding the parser is
dangerous. IMHO the [groupname] will be given to the
mysql-libs. </div>
<div>I am not so deep inside kamailio c-code to full understand
that case.</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Am Mi., 23. Okt. 2019 um
18:29 Uhr schrieb Henning Westerholt <<a href="mailto:hw@skalatan.de" target="_blank">hw@skalatan.de</a>>:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="DE">
<div>
<p class="MsoNormal"><span>Hello,</span></p>
<p class="MsoNormal"><span> </span></p>
<p class="MsoNormal"><span lang="EN-GB">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. </span><span lang="EN-GB">😉</span><span lang="EN-GB"></span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal"><span lang="EN-GB">Cheers,</span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal"><span lang="EN-GB">Henning</span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal"><span lang="EN-GB">-- </span></p>
<p class="MsoNormal"><span lang="EN-GB">Henning Westerholt
-
</span><span><a href="https://skalatan.de/blog/" target="_blank"><span style="color:rgb(5,99,193)" lang="EN-GB">https://skalatan.de/blog/</span></a></span><span lang="EN-GB"></span></p>
<p class="MsoNormal"><span lang="EN-GB">Kamailio services
-
</span><span><a href="https://skalatan.de/services" target="_blank"><span style="color:rgb(5,99,193)" lang="EN-GB">https://skalatan.de/services</span></a></span><span lang="EN-GB"></span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><b>From:</b>
sr-users <<a href="mailto:sr-users-bounces@lists.kamailio.org" target="_blank">sr-users-bounces@lists.kamailio.org</a>>
<b>On Behalf Of </b>Karsten Horsmann<br>
<b>Sent:</b> Wednesday, October 23, 2019 6:17 PM<br>
<b>To:</b> Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>><br>
<b>Cc:</b> Kamailio (SER) - Users Mailing List <<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>><br>
<b>Subject:</b> Re: [SR-Users] driver error: Can't
connect to MySQL server with kamailio 5.3.x and
mysql-config-groups</p>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Hi
Daniel,</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">you
mean this commit (see below). Maybe Alexey Vasilyev
can told us something to that change?</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">How
can i use mysql-groups in the [] notation? Like:</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">#!define
DBURL "mysql://[kamailio]/kamailio"</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><a href="https://kamailio.org/docs/modules/5.3.x/modules/db_mysql.html#idm140" target="_blank">https://kamailio.org/docs/modules/5.3.x/modules/db_mysql.html#idm140</a> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">AFAIK
this change splits [ and ] to ipv6 Host and sets
ST_HOST6 and </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">commit
a7588f382605991bef4499de8c89b10a9468c8cf<br>
Author: Alexey Vasilyev <<a href="mailto:alexei.vasilyev@gmail.com" target="_blank">alexei.vasilyev@gmail.com</a>><br>
Date: Wed Sep 4 13:47:23 2019 +0300<br>
<br>
db_mysql: database URL supports IPv6 address as
hostname<br>
<br>
- changed parsing of db_url to accept IPv6
address for hostname</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Any
help would be appreciated.</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Cheers
Karsten</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Am
Mi., 23. Okt. 2019 um 08:10 Uhr schrieb
Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>:</p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p style="margin-left:35.4pt">Hello,</p>
<p style="margin-left:35.4pt">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.</p>
<p style="margin-left:35.4pt">Cheers,<br>
Daniel</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">On
22.10.19 16:38, Karsten Horsmann wrote:</p>
</div>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Hi
Daniel, </p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">i create an
Logfile with debug=3 on startup here: <a href="https://gist.github.com/khorsmann/91642daaa3715c59624cd5272bc3398a#file-logfile-txt-L4345" target="_blank">https://gist.github.com/khorsmann/91642daaa3715c59624cd5272bc3398a#file-logfile-txt-L4345</a> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> 0(29174) DEBUG:
db_mysql [km_my_con.c:108]:
db_mysql_new_connection(): opening
connection:
mysql://xxxx:xxxx@kamailio/kamailio</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">I dont know where
kamailio though that there is an "hostname"
kamailio that holds the mysqldb/kamailio.</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">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.</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Cheers</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Karsten</p>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Am Di., 22. Okt.
2019 um 15:40 Uhr schrieb Daniel-Constantin
Mierla <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>:</p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p style="margin-left:35.4pt">Hello,</p>
<p style="margin-left:35.4pt">if you set
debug=3, do you see any other log message
that can give hints about the error?</p>
<p style="margin-left:35.4pt">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.</p>
<p style="margin-left:35.4pt">Cheers,<br>
Daniel</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">On 22.10.19
15:20, Karsten Horsmann wrote:</p>
</div>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Hi List, </p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">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.</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> lsb_release
-a<br>
LSB Version:
:core-4.1-amd64:core-4.1-noarch<br>
Distributor ID: CentOS<br>
Description: CentOS Linux release
7.7.1908 (Core)<br>
Release: 7.7.1908<br>
Codename: Core</p>
</div>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Am Di.,
22. Okt. 2019 um 14:58 Uhr schrieb
Karsten Horsmann <<a href="mailto:khorsmann@gmail.com" target="_blank">khorsmann@gmail.com</a>>:</p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Hi
List, </p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">i
updated one of my testing
kamailios from 5.2.x to latest
5.3.x.</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">After
restarting the process, i got an
mysql error that the server
"kamailio" is not found.</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">I use
the config-feature of my.cnf
config-group names within the
kamailio.cfg<br>
I can start my kamailio 5.3.x
installation with "normal
username:password@host"
definitions for DBURL.</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-right:0cm;margin-bottom:12pt;margin-left:35.4pt">
Did anyone have the same issue?<br>
<br>
</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> 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)<br>
0(19625) ERROR: <core>
[db.c:319]: db_do_init2():
could not add connection to
the pool<br>
0(19625) ERROR: dialplan
[dp_db.c:179]:
dp_connect_db(): unable to
connect to the database<br>
0(19625) ERROR: dialplan
[dialplan.c:191]: mod_init():
could not initialize data<br>
0(19625) ERROR: <core>
[core/sr_module.c:850]:
init_mod(): Error while
initializing module dialplan
(/usr/lib64/kamailio/modules/dialplan.so)<br>
ERROR: error while
initializing modules<br>
<br>
<br>
from my kamailio.cfg i defined
the DBURL like this:</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><br>
# Use
/etc/my.cnf.d/kamailio.cnf to
store credentials<br>
# within a mysql-db-group<br>
#!define DBURL
"mysql://[kamailio]/kamailio"<br>
<br>
and special modules can use it
like this (or via DBURL)<br>
modparam("sqlops", "sqlcon",
"cb=>mysql://[kamailio]/kamailio")<br>
<br>
cat /etc/my.cnf.d/kamailio.cnf</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><br>
# MySQL configuration group
for kamailio<br>
[kamailio]<br>
user=kamailio<br>
password="kamailiorw"<br>
host=172.20.100.22<br>
<br>
<br>
rpm -qa | grep kam<br>
kamailio-dialplan-5.3.0-13.1.x86_64<br>
kamailio-websocket-5.3.0-13.1.x86_64<br>
kamailio-jansson-5.3.0-13.1.x86_64<br>
kamailio-mysql-5.3.0-13.1.x86_64<br>
kamailio-tls-5.3.0-13.1.x86_64<br>
kamailio-ims-5.3.0-13.1.x86_64<br>
kamailio-statsd-5.3.0-13.1.x86_64<br>
kamailio-5.3.0-13.1.x86_64<br>
kamailio-redis-5.3.0-13.1.x86_64</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> cat
/etc/redhat-release<br>
CentOS Linux release
7.6.1810 (Core)</p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt">--
</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Cheers<br>
*Karsten Horsmann*</p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><br clear="all">
</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt">-- </p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Mit
freundlichen Grüßen<br>
*Karsten Horsmann*</p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
<pre style="margin-left:35.4pt">_______________________________________________</pre>
<pre style="margin-left:35.4pt">Kamailio (SER) - Users Mailing List</pre>
<pre style="margin-left:35.4pt"><a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a></pre>
<pre style="margin-left:35.4pt"><a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a></pre>
</blockquote>
<pre style="margin-left:35.4pt">-- </pre>
<pre style="margin-left:35.4pt">Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank">www.asipto.com</a></pre>
<pre style="margin-left:35.4pt"><a href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a></pre>
<pre style="margin-left:35.4pt">Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- <a href="https://asipto.com/u/kat" target="_blank">https://asipto.com/u/kat</a></pre>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><br clear="all">
</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt">--
</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Mit
freundlichen Grüßen<br>
*Karsten Horsmann*</p>
</div>
</blockquote>
<pre style="margin-left:35.4pt">-- </pre>
<pre style="margin-left:35.4pt">Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank">www.asipto.com</a></pre>
<pre style="margin-left:35.4pt"><a href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a></pre>
<pre style="margin-left:35.4pt">Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- <a href="https://asipto.com/u/kat" target="_blank">https://asipto.com/u/kat</a></pre>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:35.4pt"><br clear="all">
</p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> </p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt">-- </p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">Mit
freundlichen Grüßen<br>
*Karsten Horsmann*</p>
</div>
</div>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">Mit freundlichen Grüßen<br>
*Karsten Horsmann*<br>
</div>
</blockquote>
<pre cols="72">--
Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank">www.asipto.com</a>
<a href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- <a href="https://asipto.com/u/kat" target="_blank">https://asipto.com/u/kat</a></pre>
</div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">Mit freundlichen Grüßen<br>*Karsten Horsmann*<br></div>