4 Jan
2006
4 Jan
'06
11:38 a.m.
You have to use avp db schema to load values from tables that have other
structure than usr_preferences table. See:
http://voice-system.ro/docs/avpops/ar01s05.html#db_scheme
http://voice-system.ro/docs/avpops/ar01s06.html#avp_db_load
Cheers,
Daniel
On 01/04/06 06:25, unplug wrote:
I have an alias in the aliases table that mapped with
an account. I
have tried avp_db_load("$from/uri","s:/aliases") but the following
error displayed.
Jan 4 12:17:14 zzzsipx /usr/local/sbin/openser[2792]: submit_query:
Unknown column 'value' in 'field list'
Jan 4 12:17:14 zzzsipx /usr/local/sbin/openser[2792]: db_query: Error
while submitting query
Jan 4 12:17:14 zzzsipx /usr/local/sbin/openser[2792]:
ERROR:avpops:load_avps: db_load failed
In the aliases table, there is no value field. AVP uses to search the
value field for the value. Am I right?
For my case, I want to get the alias of an account in the aliases
table according to the From header. Can I still use avp_db_load?
How?
Thanks!
On 1/4/06, Daniel-Constantin Mierla <daniel(a)voice-system.ro> wrote:
You can load the alias value form any table in an
AVP using avpops
module. See:
http://voice-system.ro/docs/avpops/ar01s06.html#avp_db_load
The you can use uac_replace_from(display,uri) with pseudo-variables in
parameters.
Cheers,
Daniel
On 01/03/06 10:27, unplug wrote:
> As I know, we can use lookup function for lookup an alias of an RURI.
> It is for inbound call. How about the outbound call? Say, I have an
> account (881234) with an alias (24568849). Someone can call the alias
> to reach the account (881234) by using lookup function. How can I
> make outbound call such that the caller number will be replaced by the
> alias? As I know we can use uac_replace_from(display,uri) to replace
> the from URI. But I have no idea how to retrieve an alias from the
> >From URI. Any clue?
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
>