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@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users