[Users] avp_db_store can't write into database

chungyu chungyu at ms11.voip.edu.tw
Mon Apr 9 12:52:11 CEST 2007


  On 4/9/07, chungyu <chungyu at 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 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20070409/e3c05ccc/attachment.htm 


More information about the Users mailing list