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

[Daniel-Constantin Mierla]

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 at gmail.com <mailto:khorsmann at 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 at 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 at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20191022/a84380ae/attachment.html>