Re: [OpenSIPS-Users] Username in DB URL
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:bog...@opensips.org]
*Skickat:* den 6 februari 2018 18:20
*Till:* OpenSIPS users mailling list <users@lists.opensips.org>; Olle
Frimanson <o...@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@host -popensips
opensips, which works fine
In clustererar where we use this this translates to:
modparam("clusterer",
"db_url","mysql://opensips@host:opens...@host.mysql.azure.com/opensips"
<mailto:mysql://opensips@host:opens...@host.mysql.azure.com/opensips>)
which fails
Any ideas on a workaround on this?
BR / Olle
___
Users mailing list
Users@lists.opensips.org <mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Username in DB URL
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:bog...@opensips.org]
*Skickat:* den 6 februari 2018 18:20
*Till:* OpenSIPS users mailling list <users@lists.opensips.org>; Olle
Frimanson <o...@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@host -popensips
opensips, which works fine
In clustererar where we use this this translates to:
modparam("clusterer",
"db_url","mysql://opensips@host:opens...@host.mysql.azure.com/opensips"
<mailto:mysql://opensips@host:opens...@host.mysql.azure.com/opensips>)
which fails
Any ideas on a workaround on this?
BR / Olle
___
Users mailing list
Users@lists.opensips.org <mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
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@host -popensips opensips,
which works fine
In clustererar where we use this this translates to:
modparam("clusterer",
"db_url","mysql://opensips@host:opens...@host.mysql.azure.com/opensips")
which fails
Any ideas on a workaround on this?
BR / Olle
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Username in DB URL
Hah! Yeah, it's a well-known proble, same if '@' appears in the
password. I'd love to know if there's a solution too, as there appears
to be no means of escaping these.
On Mon, Feb 05, 2018 at 07:08:58PM +0100, 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@host -popensips opensips, which
> works fine
>
>
>
> In clustererar where we use this this translates to:
>
>
>
> modparam("clusterer",
> "db_url","mysql://opensips@host:opens...@host.mysql.azure.com/opensips")
>
>
>
> which fails
>
>
>
> Any ideas on a workaround on this?
>
>
>
> BR / Olle
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] Username in DB URL
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@host -popensips opensips, which
works fine
In clustererar where we use this this translates to:
modparam("clusterer",
"db_url","mysql://opensips@host:opens...@host.mysql.azure.com/opensips")
which fails
Any ideas on a workaround on this?
BR / Olle
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
