[SR-Users] driver error: Can't connect to MySQL server with kamailio 5.3.x and mysql-config-groups
Daniel-Constantin Mierla
miconda at gmail.com
Fri Oct 25 12:58:16 CEST 2019
Hello,
can you try with the patch from next commit:
-
https://github.com/kamailio/kamailio/commit/2aa614d49f4917faec62534a51fcf8ddfc5fb870
If all ok, then I will backport.
Cheers,
Daniel
On 25.10.19 12:50, Karsten Horsmann wrote:
> Hi Henning,
>
> changing a parser without understanding the parser is dangerous. IMHO
> the [groupname] will be given to the mysql-libs.
> I am not so deep inside kamailio c-code to full understand that case.
>
> Am Mi., 23. Okt. 2019 um 18:29 Uhr schrieb Henning Westerholt
> <hw at skalatan.de <mailto:hw at skalatan.de>>:
>
> Hello,
>
>
>
> 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. 😉
>
>
>
> Cheers,
>
>
>
> Henning
>
>
>
> --
>
> Henning Westerholt - https://skalatan.de/blog/
>
> Kamailio services - https://skalatan.de/services
>
>
>
> *From:* sr-users <sr-users-bounces at lists.kamailio.org
> <mailto:sr-users-bounces at lists.kamailio.org>> *On Behalf Of
> *Karsten Horsmann
> *Sent:* Wednesday, October 23, 2019 6:17 PM
> *To:* Daniel-Constantin Mierla <miconda at gmail.com
> <mailto:miconda at gmail.com>>
> *Cc:* Kamailio (SER) - Users Mailing List
> <sr-users at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>>
> *Subject:* Re: [SR-Users] driver error: Can't connect to MySQL
> server with kamailio 5.3.x and mysql-config-groups
>
>
>
> Hi Daniel,
>
>
>
> you mean this commit (see below). Maybe Alexey Vasilyev can told
> us something to that change?
>
>
>
> How can i use mysql-groups in the [] notation? Like:
>
> #!define DBURL "mysql://[kamailio]/kamailio"
>
> https://kamailio.org/docs/modules/5.3.x/modules/db_mysql.html#idm140
>
>
>
> AFAIK this change splits [ and ] to ipv6 Host and sets ST_HOST6 and
>
>
>
> commit a7588f382605991bef4499de8c89b10a9468c8cf
> Author: Alexey Vasilyev <alexei.vasilyev at gmail.com
> <mailto:alexei.vasilyev at gmail.com>>
> Date: Wed Sep 4 13:47:23 2019 +0300
>
> db_mysql: database URL supports IPv6 address as hostname
>
> - changed parsing of db_url to accept IPv6 address for hostname
>
>
>
> Any help would be appreciated.
>
>
>
> Cheers Karsten
>
>
>
>
>
> Am Mi., 23. Okt. 2019 um 08:10 Uhr schrieb Daniel-Constantin
> Mierla <miconda at gmail.com <mailto:miconda at gmail.com>>:
>
> Hello,
>
> 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.
>
> Cheers,
> Daniel
>
> On 22.10.19 16:38, Karsten Horsmann wrote:
>
> Hi Daniel,
>
>
>
> i create an Logfile with debug=3 on startup
> here: https://gist.github.com/khorsmann/91642daaa3715c59624cd5272bc3398a#file-logfile-txt-L4345
>
>
>
> 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 at gmail.com
> <mailto:miconda at gmail.com>>:
>
> 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 <mailto:sr-users at lists.kamailio.org>
>
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
> --
>
> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
>
> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
>
> Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat
>
>
>
>
> --
>
> Mit freundlichen Grüßen
> *Karsten Horsmann*
>
> --
>
> Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>
>
> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
>
> Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat
>
>
>
>
> --
>
> Mit freundlichen Grüßen
> *Karsten Horsmann*
>
>
>
> --
> Mit freundlichen Grüßen
> *Karsten Horsmann*
--
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/20191025/bd6c7f60/attachment.html>
More information about the sr-users
mailing list