<div dir="ltr">Hi Daniel,<div><br></div><div>you mean this commit (see below). Maybe 

Alexey Vasilyev can told us something to that change?</div><div><br></div><div>How can i use mysql-groups in the [] notation? Like:</div><div>#!define DBURL "mysql://[kamailio]/kamailio"<br></div><div><a href="https://kamailio.org/docs/modules/5.3.x/modules/db_mysql.html#idm140">https://kamailio.org/docs/modules/5.3.x/modules/db_mysql.html#idm140</a> </div><div> <br></div><div>AFAIK this change splits [ and ] to ipv6 Host and sets ST_HOST6 and </div><div><br></div><div>commit a7588f382605991bef4499de8c89b10a9468c8cf<br>Author: Alexey Vasilyev <<a href="mailto:alexei.vasilyev@gmail.com">alexei.vasilyev@gmail.com</a>><br>Date:   Wed Sep 4 13:47:23 2019 +0300<br><br>    db_mysql: database URL supports IPv6 address as hostname<br><br>    - changed parsing of db_url to accept IPv6 address for hostname<br></div><div><br></div><div>Any help would be appreciated.</div><div><br></div><div>Cheers Karsten</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Am Mi., 23. Okt. 2019 um 08:10 Uhr schrieb Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com">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>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.</p>
    <p>Cheers,<br>
      Daniel<br>
    </p>
    <div>On 22.10.19 16:38, Karsten Horsmann
      wrote:<br>
    </div>
    <blockquote type="cite">
      
      <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>
    </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" class="gmail_signature">Mit freundlichen Grüßen<br>*Karsten Horsmann*<br></div>