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