[OpenSIPS-Users] Username in DB URL

[Bogdan-Andrei Iancu]

Just as an update, the fix was confirmed and backported on 2.2 and 2.3 also.

Thanks Olle!

Regards,

Bogdan-Andrei Iancu

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

On 03/02/2018 07:32 PM, Bogdan-Andrei Iancu wrote:
> 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
>>
>
>
>
> _______________________________________________
> Users mailing list
> 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/20180306/8cbf0ea0/attachment.html>