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

-- Thanks and Regards Ravi Prakash Sunkara ravi.sunkara@hyperion-tech.com M:+91 9985077535 www.hyperion-tech.com Client and Parent company :- www.august-networks.com

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