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