<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Hello Karsten,</p>
<p>thanks for the test, I've backported the fix to stable branches.</p>
<p>Cheers,</p>
<p>Henning<br>
</p>
<div class="moz-cite-prefix">Am 29.10.19 um 14:29 schrieb Karsten Horsmann:<br>
</div>
<blockquote type="cite" cite="mid:CAFArqsYrCJ=iYdBS3a57AJ3ScaiKRfGnh5wUjLhpo7Xkt6dE_w@mail.gmail.com">
<div dir="ltr">Hello Sergey,
<div><br>
</div>
<div>thanks for the hints. Will be sure next time to honor your request.</div>
<div>Hope that the bugfix is backported from Daniel to 5.3, so i can also migrate to 5.3 with the official rpms.<br>
</div>
<div><br>
</div>
<div>Cheers</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Am Mo., 28. Okt. 2019 um 18:12 Uhr schrieb Sergey Safarov <<a href="mailto:s.safarov@gmail.com" moz-do-not-send="true">s.safarov@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 dir="ltr">Please check RPM packaged rpm OBS service. Link provides above.
<div>As you can used python2 deps.</div>
<div>Need troubleshoot on your environment why generated so strange deps.<br>
<br>
I recommend start troubleshoot from build master branch with out any your modification</div>
<div>Then add one by one your change commit (like "git bisect").<br>
And located what change introduce such behavior.</div>
<div> </div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, Oct 28, 2019 at 7:42 PM Karsten Horsmann <<a href="mailto:khorsmann@gmail.com" target="_blank" moz-do-not-send="true">khorsmann@gmail.com</a>> wrote:<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 dir="auto">
<div>Hi Sergey, </div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div dir="auto">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. </div>
<div dir="auto"><br>
</div>
<div dir="auto">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). </div>
<div dir="auto"><br>
</div>
<div dir="auto">And with branch 5.2 I don't have that behaviors. </div>
<div dir="auto"><br>
</div>
<div dir="auto">Anyway. I try to use the Kamailio builded versions if it's possible, in this testing case I used the build process by myself. </div>
<div dir="auto"><br>
</div>
<div dir="auto">Cheers </div>
<div dir="auto">Karsten </div>
<div dir="auto"><br>
<div class="gmail_quote" dir="auto">
<div dir="ltr" class="gmail_attr">Sergey Safarov <<a href="mailto:s.safarov@gmail.com" target="_blank" moz-do-not-send="true">s.safarov@gmail.com</a>> schrieb am Mo., 28. Okt. 2019, 16:30:<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 dir="ltr">please look install rpm content for "python23" string.<br>
Looks as this string introduced on your local PC.<br>
<br>
I have checked <a href="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" rel="noreferrer" target="_blank" moz-do-not-send="true">kamailio-5.3.0-14.1.x86_64.rpm</a> in kamailio and found deps<br>
<br>
/bin/sh<br>
/bin/sh<br>
/bin/sh<br>
/bin/sh<br>
/usr/bin/python2<br>
config(kamailio) = 5.3.0-14.1<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><br>
Also you reps have other strange string "config(kamailio) = 5.3.0-14.el7.<font color="#ff0000">centos.4com</font>"<br>
</div>
<div><br>
</div>
<div>Please read  <a href="https://github.com/kamailio/kamailio/blob/master/pkg/kamailio/README.md" rel="noreferrer" target="_blank" moz-do-not-send="true">https://github.com/kamailio/kamailio/blob/master/pkg/kamailio/README.md</a></div>
<div>RPM section</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, Oct 28, 2019 at 5:02 PM Karsten Horsmann <<a href="mailto:khorsmann@gmail.com" rel="noreferrer" target="_blank" moz-do-not-send="true">khorsmann@gmail.com</a>> wrote:<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 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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">
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" rel="noreferrer" target="_blank" moz-do-not-send="true">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/" rel="noreferrer" target="_blank" moz-do-not-send="true"><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" rel="noreferrer" target="_blank" moz-do-not-send="true"><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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">miconda@gmail.com</a>><br>
<b>Cc:</b> Kamailio (SER) - Users Mailing List <<a href="mailto:sr-users@lists.kamailio.org" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">www.asipto.com</a></pre>
<pre style="margin-left:35.4pt"><a href="http://www.twitter.com/miconda" rel="noreferrer" target="_blank" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">www.asipto.com</a></pre>
<pre style="margin-left:35.4pt"><a href="http://www.twitter.com/miconda" rel="noreferrer" target="_blank" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">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" rel="noreferrer" target="_blank" moz-do-not-send="true">www.asipto.com</a>
<a href="http://www.twitter.com/miconda" rel="noreferrer" target="_blank" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda" rel="noreferrer" target="_blank" moz-do-not-send="true">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- <a href="https://asipto.com/u/kat" rel="noreferrer" target="_blank" moz-do-not-send="true">https://asipto.com/u/kat</a></pre>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">Mit freundlichen Grüßen<br>
*Karsten Horsmann*<br>
</div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" rel="noreferrer" target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer noreferrer" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote>
</div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" rel="noreferrer" target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer noreferrer" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote>
</div>
</div>
</div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote>
</div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">Mit freundlichen Grüßen<br>
*Karsten Horsmann*<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">-- 
Kamailio Merchandising - <a class="moz-txt-link-freetext" href="https://skalatan.de/merchandising/">https://skalatan.de/merchandising/</a>
Kamailio services - <a class="moz-txt-link-freetext" href="https://skalatan.de/services">https://skalatan.de/services</a>
Henning Westerholt - <a class="moz-txt-link-freetext" href="https://skalatan.de/blog/">https://skalatan.de/blog/</a></pre>
</body>
</html>