[Users] avp_db_store can't write into database

chungyu chungyu at ms11.voip.edu.tw
Mon Apr 9 10:44:02 CEST 2007


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





  -- 
  Thanks and Regards
  Ravi Prakash Sunkara 
  ravi.sunkara at hyperion-tech.com 
  M:+91 9985077535
  www.hyperion-tech.com
  Client and Parent company :- www.august-networks.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20070409/05e20606/attachment.htm 


More information about the Users mailing list