[OpenSER-Users] Not possible variables or AVP's in alias_db_lookup() ?

[Iñaki Baz Castillo]

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 at 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.