[Serusers] AVPOPS syntax help

[Daniel-Constantin Mierla]

On 10/19/05 22:27, Pol wrote:
> Hi SerUsers!
> I'm completly crazy tryin' to do the following:
> I just want to load from DB user alias and rewrite it into  "$to
>   
If you want to change the To header it is not possible with avpops in 
the manner you want.
> $ruri", because these calls shoud go directly to asterisk voicemail
> and they are numerical not alphanumeric.
> i tried to do the following:
>
>        if(avp_db_load($alias/$username,i:alias")
>            avp_pushto("$ruri/$to","alias")
>   
First you should know for what user you want to load the alias - the one 
from R-URI? Do you have to use aliases table or you can create and use 
other table? If you stick to aliases table then look at db_scheme:
http://www.voice-system.ro/docs/avpops/ar01s05.html#db_scheme

For ser, the avpops tutorial you can find at:
http://www.voice-system.ro/docs/avpops/0.9.0/

Daniel


> just to load from alias table username into an integer called alias
> and then pushed to new $ruri.
>
> I'm new in ser and avps module it's really usefull but a little bit
> "unreadable", plz this should work for tomorrow :$ any help plz!?
> be as much especific as can, because i don't know if i have done the
> proper modparams.
> these are:
>
> modparam("avpops", "avp_url", "mysql://ser:heslo@localhost/ser")
> modparam("avpops", "avp_table", "usr_preferences")
> #modparam("avpops", "use_domain", "1")
> modparam("avpops", "uuid_column", "uuid")
> modparam("avpops", "username_column", "username")
> modparam("avpops", "domain_column", "domain")
> modparam("avpops", "attribute_column", "attribute")
> modparam("avpops", "value_column", "value")
> modparam("avpops", "type_column", "type")
>
> THX
>
>
> On 10/13/05, Iqbal <iqbal at gigo.co.uk> wrote:
>   
>> Hi
>>
>> I think you have the source syntax written below in the avp_db_load
>> statements
>>
>> so the source will have $from or $to or $ruri optionally followed by the
>> words "username" or domain
>>
>> eg
>>
>> avp_db_load($from/username) of avp_db_load($to/domain) ---note these are
>> not completed syntax
>>
>> OR instead of the sip_uri which is $from,$to,$ruri you can have avp_alias
>>
>> which is exactly what it says, its an alias,
>>
>> Str_value this is the number directly related to the predefined alias in
>> the line above
>>
>> The name can be a string S:
>> interger i:
>>
>> or you can leave out the S: and just use the name
>>
>> or of course an alias
>>
>> I know thats probably not clear...in fact I just read it myself, the best
>> thing with avpops , is to look at the db, and create a few, and then see
>> how to pop them out and play with 'em
>>
>> Iqbal
>>
>>
>> On 10/12/2005, "Lenir" <lenirsantiago at yahoo.com> wrote:
>>
>>     
>>> Hello list,
>>>
>>> I'm reading the documentation for AVPOPS, and Im a little confused in this
>>> section:
>>>
>>> ----------------------------------------------------------------------------
>>> -----
>>> #avp_db_load(source,name)
>>> #Loads from DB into memory the AVPs corresponding to the given source.
>>>
>>> Meaning of the parameters is as follows:
>>>
>>>
>>> source - what info is used for identifying the AVPs. Parameter syntax:
>>>
>>>
>>> source = (sip_uri)['/'('username'|'domain')]) | (avp_alias) | str_value
>>>
>>> sip_uri = '$from' | '$to' | '$ruri'
>>>
>>>
>>> name - which AVPs will be loaded from DB into memory. Parameter syntax is:
>>>
>>>
>>> name = avp_spec['/'(table_name|'$'db_scheme)]
>>>
>>> avp_spec = ''|'s:'|'i:'|avp_name|avp_alias
>>>
>>>
>>> Example 1-12. avp_db_load usage
>>>
>>> ....
>>> avp_db_load("$from","i:678");
>>> avp_db_load("$ruri/domain","i:/domain_preferences");
>>> avp_db_load("$uuid","s:404fwd/fwd_table");
>>> avp_db_load("$ruri","i:123/$some_scheme");
>>> ....
>>>
>>> ----------------------------------------------------------------------------
>>> -----
>>>
>>> My question are:
>>>
>>> Can someone explain the source syntax?
>>> Can someone explain the name syntax?
>>> what are i:, s:, avp_name and avp_alias?
>>>
>>> Thanks!
>>>
>>> Lenir
>>>
>>>
>>>
>>> _______________________________________________
>>> Serusers mailing list
>>> serusers at lists.iptel.org
>>> http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>
>>>       
>> _______________________________________________
>> Serusers mailing list
>> serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>> _____________________________________________________________________
>> Mensaje analizado y protegido, tecnologia antivirus www.trendmicro.es
>>
>>     
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
>