<div dir="ltr">Could you record network traffic into PCAP like<br>tcpdump -ni any host ${mysql_server_ip} -s 0 -w /tmp/mysql.pcap<br><br>then sent.Will try look into network traffic.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Oct 22, 2019 at 5:39 PM Karsten Horsmann <<a href="mailto:khorsmann@gmail.com">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">Hi Daniel,<div><br></div><div>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> </div><div><br></div><div> 0(29174) DEBUG: db_mysql [km_my_con.c:108]: db_mysql_new_connection(): opening connection: mysql://xxxx:xxxx@kamailio/kamailio<br></div><div>I dont know where kamailio though that there is an "hostname" kamailio that holds the mysqldb/kamailio.</div><div><br></div><div>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.</div><div><br></div><div>Cheers</div><div>Karsten</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">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>>:<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>if you set debug=3, do you see any other log message that can
give hints about the error?</p>
<p>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>Cheers,<br>
Daniel<br>
</p>
<div>On 22.10.19 15:20, Karsten Horsmann
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi List,
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div> 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<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Am Di., 22. Okt. 2019 um
14:58 Uhr schrieb Karsten Horsmann <<a href="mailto:khorsmann@gmail.com" target="_blank">khorsmann@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">Hi List,
<div><br>
</div>
<div>i updated one of my testing kamailios from 5.2.x to
latest 5.3.x.</div>
<div>After restarting the process, i got an mysql error that
the server "kamailio" is not found.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Did anyone have the same issue?<br>
<br>
<br>
<div> 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:</div>
<div><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</div>
<div><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<br>
<div><br>
</div>
<div> cat /etc/redhat-release<br>
CentOS Linux release 7.6.1810 (Core)<br>
</div>
<div><br>
</div>
-- <br>
<div dir="ltr">Cheers<br>
*Karsten Horsmann*<br>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">Mit freundlichen Grüßen<br>
*Karsten Horsmann*<br>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Kamailio (SER) - Users Mailing List
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>
<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 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">Mit freundlichen Grüßen<br>*Karsten Horsmann*<br></div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div>