2 Aug
2007
2 Aug
'07
6:03 p.m.
I want OpenSer to dinamically look for alias in a table for each domain, so
I've in my database tables with name as:
dbaliases_sip1_domain_org
dbaliases_sip2_domain_com
dbaliases_sip3_domain_net
And I do (thanks to Andreas Granig):
$avp(s:dom) = $rd;
avp_subst("$avp(s:dom)", "/\./_/g");
alias_db_lookup("dbaliases_" + $avp(s:dominio));
but it fails because the SQL query is literally:
select username,domain from dbaliases_$avp(s:dominio) where ...
I've tryed putting variables and more things into the function parameter, but
it's never processed and the SQL query is always done literally. I use
OpenSer 1.2.1.
What can I do for solving this? Thanks.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
2 Aug
2 Aug
6:07 p.m.
New subject: [OpenSER-Users] Not possible variables or AVP's in alias_db_lookup() ?
Hello,
if the alias translates in a single SIP user, it is easy to do it with
avp_db_query() of avpops module. You load the result in avps and then
push it to R-URI.
Cheers,
Daniel
On 08/02/07 19:03, Iñaki Baz Castillo wrote:
I want OpenSer to dinamically look for alias in a
table for each domain, so
I've in my database tables with name as:
dbaliases_sip1_domain_org
dbaliases_sip2_domain_com
dbaliases_sip3_domain_net
And I do (thanks to Andreas Granig):
$avp(s:dom) = $rd;
avp_subst("$avp(s:dom)", "/\./_/g");
alias_db_lookup("dbaliases_" + $avp(s:dominio));
but it fails because the SQL query is literally:
select username,domain from dbaliases_$avp(s:dominio) where ...
I've tryed putting variables and more things into the function parameter, but
it's never processed and the SQL query is always done literally. I use
OpenSer 1.2.1.
What can I do for solving this? Thanks.
6:15 p.m.
El Thursday 02 August 2007 18:07:32 Daniel-Constantin Mierla escribió:
Hello,
if the alias translates in a single SIP user, it is easy to do it with
avp_db_query() of avpops module. You load the result in avps and then
push it to R-URI.
Ok, I'll try that.
Anyway I would like to do a suggestion: functions documentation could tell if
they allow variable processing into their parameters. Some allow it and some
others not, but there is not a way to know that.
Regards and thanks.
Cheers,
Daniel
On 08/02/07 19:03, Iñaki Baz Castillo wrote:
> I want OpenSer to dinamically look for alias in a table for each domain,
> so I've in my database tables with name as:
>
> dbaliases_sip1_domain_org
> dbaliases_sip2_domain_com
> dbaliases_sip3_domain_net
>
>
> And I do (thanks to Andreas Granig):
>
>
> $avp(s:dom) = $rd;
> avp_subst("$avp(s:dom)", "/\./_/g");
> alias_db_lookup("dbaliases_" + $avp(s:dominio));
>
>
> but it fails because the SQL query is literally:
>
> select username,domain from dbaliases_$avp(s:dominio) where ...
>
>
> I've tryed putting variables and more things into the function parameter,
> but it's never processed and the SQL query is always done literally. I
> use OpenSer 1.2.1.
>
> What can I do for solving this? Thanks.
--
ilimit...
*Iñaki Baz Castillo*
ibc(a)in.ilimit.es
ÀREA SISTEMES
0034 937 333 375
VOLTA 1, PIS 5
08224 TERRASSA.BCN
Aquest enviament és confidencial i està destinat únicament a la persona a qui
s'ha enviat.
Pot contenir informació privada sotmesa al secret professional, la distribució
de la qual està prohibida per la legislació vigent.
6:32 p.m.
New subject: [OpenSER-Users] Not possible variables or AVP's in alias_db_lookup() ?
On 08/02/07 19:15, Iñaki Baz Castillo wrote:
El Thursday 02 August 2007 18:07:32 Daniel-Constantin
Mierla escribió:
those that support pseudo-variables, are explicitly saying it, as far as
I know. The others, dont. PV came later, and when support for them was
added, the docs were updated. But for the other functions, nobody
updated to say that they do not support PV.
Daniel
Hello,
if the alias translates in a single SIP user, it is easy to do it with
avp_db_query() of avpops module. You load the result in avps and then
push it to R-URI.
Ok, I'll try that.
Anyway I would like to do a suggestion: functions documentation could tell if
they allow variable processing into their parameters. Some allow it and some
others not, but there is not a way to know that.
Regards and thanks.
Cheers,
Daniel
On 08/02/07 19:03, Iñaki Baz Castillo wrote:
> I want OpenSer to dinamically look for alias in a table for each domain,
> so I've in my database tables with name as:
>
> dbaliases_sip1_domain_org
> dbaliases_sip2_domain_com
> dbaliases_sip3_domain_net
>
>
> And I do (thanks to Andreas Granig):
>
>
> $avp(s:dom) = $rd;
> avp_subst("$avp(s:dom)", "/\./_/g");
> alias_db_lookup("dbaliases_" + $avp(s:dominio));
>
>
> but it fails because the SQL query is literally:
>
> select username,domain from dbaliases_$avp(s:dominio) where ...
>
>
> I've tryed putting variables and more things into the function parameter,
> but it's never processed and the SQL query is always done literally. I
> use OpenSer 1.2.1.
>
> What can I do for solving this? Thanks.
>
6:34 p.m.
El Thursday 02 August 2007 18:15:58 Iñaki Baz Castillo escribió:
El Thursday 02 August 2007 18:07:32 Daniel-Constantin
Mierla escribió:
Thanks, it works perfectly and I tell how it's finally:
$avp(s:dominio) = $rd;
avp_subst("$avp(s:dominio)", "/\./_/g");
avp_db_query("select username,domain from dbaliases_$avp(s:dominio) where
alias_username='$rU' AND alias_domain='$rd'",
"$avp(s:alias_username);
$avp(s:alias_domain)");
avp_pushto("$ru/username","$avp(s:alias_username)");
avp_pushto("$ru/domain","$avp(s:alias_domain)");
:)
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
Hello,
if the alias translates in a single SIP user, it is easy to do it with
avp_db_query() of avpops module. You load the result in avps and then
push it to R-URI.
Ok, I'll try that.
6:44 p.m.
New subject: [OpenSER-Users] Not possible variables or AVP's in alias_db_lookup() ?
On 08/02/07 19:34, Iñaki Baz Castillo wrote:
El Thursday 02 August 2007 18:15:58 Iñaki Baz Castillo
escribió:
great, next is a beautification for 1.2.x:
El Thursday 02 August 2007 18:07:32
Daniel-Constantin Mierla escribió:
Thanks, it works perfectly and I tell how it's finally:
Hello,
if the alias translates in a single SIP user, it is easy to do it with
avp_db_query() of avpops module. You load the result in avps and then
push it to R-URI.
Ok, I'll try that.
$avp(s:dominio) = $rd;
avp_subst("$avp(s:dominio)", "/\./_/g");
avp_db_query("select username,domain from dbaliases_$avp(s:dominio) where
alias_username='$rU' AND alias_domain='$rd'",
"$avp(s:alias_username);
$avp(s:alias_domain)");
$ru = "sip:"+$avp(s:alias_username)+"@"+$avp(s:alias_domain);
and remove next two.
Daniel
avp_pushto("$ru/username","$avp(s:alias_username)");
avp_pushto("$ru/domain","$avp(s:alias_domain)");
:)
3 Aug
3 Aug
9:41 a.m.
El Thursday 02 August 2007 18:44:01 Daniel-Constantin Mierla escribió:
On 08/02/07 19:34, Iñaki Baz Castillo wrote:
Ok, I was already thinking about it, but what about if the protocolo is sips ?
Note that you are forcing "sip", couldn't it cause problems using sips?
Thanks for all.
--
ilimit...
*Iñaki Baz Castillo*
ibc(a)in.ilimit.es
ÀREA SISTEMES
0034 937 333 375
VOLTA 1, PIS 5
08224 TERRASSA.BCN
Aquest enviament és confidencial i està destinat únicament a la persona a qui
s'ha enviat.
Pot contenir informació privada sotmesa al secret professional, la distribució
de la qual està prohibida per la legislació vigent.
El Thursday 02 August 2007 18:15:58 Iñaki Baz
Castillo escribió:
great, next is a beautification for 1.2.x:
El Thursday 02 August 2007 18:07:32
Daniel-Constantin Mierla escribió:
Thanks, it works perfectly and I tell how it's finally: Hello,
if the alias translates in a single SIP user, it is easy to do it with
avp_db_query() of avpops module. You load the result in avps and then
push it to R-URI.
Ok, I'll try that. $avp(s:dominio) = $rd;
avp_subst("$avp(s:dominio)", "/\./_/g");
avp_db_query("select username,domain from dbaliases_$avp(s:dominio) where
alias_username='$rU' AND alias_domain='$rd'",
"$avp(s:alias_username);
$avp(s:alias_domain)");
$ru = "sip:"+$avp(s:alias_username)+"@"+$avp(s:alias_domain);
and remove next two.
12:14 p.m.
New subject: [OpenSER-Users] Not possible variables or AVP's in alias_db_lookup() ?
On 08/03/07 10:41, Iñaki Baz Castillo wrote:
El Thursday 02 August 2007 18:44:01 Daniel-Constantin
Mierla escribió:
$rU = $avp(s:alias_username);
$rd = $avp(s:alias_domain);
Daniel
On 08/02/07 19:34, Iñaki Baz Castillo wrote:
Ok, I was already thinking about it, but what about if the protocolo is sips ?
Note that you are forcing "sip", couldn't it cause problems using sips?
El Thursday 02 August 2007 18:15:58 Iñaki Baz
Castillo escribió:
great, next is a beautification for 1.2.x:
El Thursday 02 August 2007 18:07:32
Daniel-Constantin Mierla escribió:
> Hello,
>
> if the alias translates in a single SIP user, it is easy to do it with
> avp_db_query() of avpops module. You load the result in avps and then
> push it to R-URI.
>
Ok, I'll try that.
Thanks, it works perfectly and I tell how it's finally:
$avp(s:dominio) = $rd;
avp_subst("$avp(s:dominio)", "/\./_/g");
avp_db_query("select username,domain from dbaliases_$avp(s:dominio) where
alias_username='$rU' AND alias_domain='$rd'",
"$avp(s:alias_username);
$avp(s:alias_domain)");
$ru =
"sip:"+$avp(s:alias_username)+"@"+$avp(s:alias_domain);
and remove next two.
Thanks for all.
6134
days inactive
6135
days old
8 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Iñaki Baz Castillo