On 4/9/07, chungyu chungyu@ms11.voip.edu.tw wrote: Hi Raviprakash sunkara: Thank for the reply. I am trying use the solution.
modparam("avpops","avp_alias","store=s:domain")
avp_write("$ruri/domain/username","$avp(store)");
remove the either username or domain , or simle give the $ruri, Below one also same , but is there contact table is exists or not if not exists , it stores in usr_preference table ( default)
contact table is exists and not save into usr_preference
This is my confgure modparam("avpops", "avp_table", "conatct") modparam("avpops", "domain_column", "domain") modparam("avpops", "username_column", "username") modparam("avpops", "avp_aliases", "store=s:friend") if (method=="INVITE"){ avp_write("$ruri/username", "$store"); avp_db_store("$store", "s:/contact") }
if call bob then bob'name save into contact table
username | domain ------------------------ bob | null -----------------------
Thanks a lot in advance Chungyu
avp_db_store("$ruri/domain/username", "$avp(store)/contact")
system reply ERROR:avpops:fixup_write_avp: flag "domain/username" unknown!
I only want uri of callee save into contact(table name) Try most the param for avo_db_store(),but reply submit_query(): unknow column 'attribute' in 'field list' db_insert: Error while submitting query ERROR:avpops:db_store: insert failed
Thanks a lot in advance Chungyu
On 4/9/07, chungyu chungyu@ms11.voip.edu.tw wrote: Hi all, I am trying to use avp_db_store() stores my table "contact" with caller uri
ex: table name: contact ----------------------------- | username | domain | | ----------------------------- | | | | ----------------------------- | | | | -----------------------------
If (method=="INVITE"){ avp_write("$ruri/username", "s:name");
in Loading paramater of avp module Did U use this . modparam("avpops","avp_alias","store=s:domain") modparam(avpops","use_domain",1)
avp_write("$ruri/domain", "s:domain");
use this avp_write("$ruri/domain/username","$avp(store)");
avo_db_store("s:name", "s:username/contact")
avp_db_store("$ruri/domain/username","$avp(store)/contat_table_name");
I hopes this will helps U.... Let me know,
avp_db_store("s:domain", "s:domain/contact"); };
if the call bob then save username and domain of callee in contact callee: bob at iptel.org => ----------------------------- | username | domain | | ----------------------------- | bob | iptel.org | | ----------------------------- | | | | ----------------------------- but not success, system reply ERROR:avpops:db_store: insert faild
Am I setting wrong param for avo_db_store()? Thanks a lot in advance
chungyu