2 Aug
2007
2 Aug
'07
6:32 p.m.
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.
>