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)"); 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 ----- Original Message ----- From: raviprakash sunkara To: chungyu Cc: users openser.org Sent: Monday, April 09, 2007 1:57 PM Subject: Re: [Users] avp_db_store can't write into database On 4/9/07, chungyu <chungyu(a)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 _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users -- Thanks and Regards Ravi Prakash Sunkara ravi.sunkara(a)hyperion-tech.com M:+91 9985077535 www.hyperion-tech.com Client and Parent company :- www.august-networks.com

On 4/9/07, chungyu <chungyu(a)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(a)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