Re: [SR-Users] driver error: Can't connect to MySQL server with kamailio 5.3.x and mysql-config-groups

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 &lt;khorsmann(a)gmail.com <mailto:khorsmann@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@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(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users