23 Oct
2019
23 Oct
'19
6:52 p.m.
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(a)gmail.com>gt;:
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(a)gmail.com>
wrote:
--
Mit freundlichen Grüßen
*Karsten Horsmann*
Hi Daniel,
i create an Logfile with debug=3 on startup here:
https://gist.github.com/khorsmann/91642daaa3715c59624cd5272bc3398a#file-log…
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(a)gmail.com>gt;:
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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(a)gmail.com>gt;:
--
Mit freundlichen Grüßen
*Karsten Horsmann*
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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@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@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