[OpenSIPS-Users] Username in DB URL

[Bogdan-Andrei Iancu]

Hi Olle,

Could you give a try to this fix:
https://github.com/OpenSIPS/opensips/commit/5b0bc1e30ebfc1e67f4967c3e66cfa7577ee5b58

Currently this is available only on trunk version (still you can use the 
nightly builds from the official repos). If your tests are positive, I 
will do a backport ;)

Best regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   http://www.opensips-solutions.com
OpenSIPS Summit 2018
   http://www.opensips.org/events/Summit-2018Amsterdam

On 02/13/2018 04:11 PM, Olle Frimanson wrote:
>
> Hi, thanks for the reply. We try to avoid installing from source and 
> rather use RPM’s. We are also looking into using a SQL proxy and have 
> that locally on the opensips server. But the very best solution would 
> be to escape somehow.
>
> I think there was a similar problem with the TLS crypto suite that was 
> fixed in a nice way.
>
> And I don’t think we can get Microsoft to change the usernames for MySQL J
>
> BR / Olle
>
> *Från:*Bogdan-Andrei Iancu [mailto:bogdan at opensips.org]
> *Skickat:* den 6 februari 2018 18:20
> *Till:* OpenSIPS users mailling list <users at lists.opensips.org>; Olle 
> Frimanson <olle at zaark.com>
> *Ämne:* Re: [OpenSIPS-Users] Username in DB URL
>
> Hi Olle,
>
> As Alex said there is no work around for this for now. Still the 
> problem can be addressed by coding and it is not so hard to do. The 
> question is what is the best/proper type of escaping to be supported 
> into the URL - I guess the %xy is the proper one for an URL, as per 
> RFC 1738 ).
>
> Have you installed opensips form sources ?
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
>    http://www.opensips-solutions.com
> OpenSIPS Summit 2018
>    http://www.opensips.org/events/Summit-2018Amsterdam
>
> On 02/05/2018 08:08 PM, Olle Frimanson wrote:
>
>     Hi, we are experiencing an issue with a roleout in Microsoft
>     Azure, where the DB  username contains a ”@” sign. This seems to
>     be the default in MySQL in Azure.  Is there anyway to escape this
>     the URL for the clusterer module?
>
>     If you use mysql client it’s typical something like
>
>     Mysql -h host.mysql.azure.com -u opensips at host -popensips
>     opensips, which works fine
>
>     In clustererar where we use this this translates to:
>
>     modparam("clusterer",
>     "db_url","mysql://opensips@host:opensips@host.mysql.azure.com/opensips"
>     <mailto:mysql://opensips@host:opensips@host.mysql.azure.com/opensips>)
>
>     which fails
>
>     Any ideas on a workaround on this?
>
>     BR / Olle
>
>
>
>
>     _______________________________________________
>
>     Users mailing list
>
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20180302/61d6ebff/attachment.html>