On 08/02/07 19:15, Iñaki Baz Castillo wrote:
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.
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

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.




_______________________________________________
Users mailing list
Users@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users

Reply via email to