[Users] avp_db_store can't write into database

raviprakash sunkara sunkara.raviprakash.feb14 at gmail.com
Mon Apr 9 11:25:33 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)

 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 <sunkara.raviprakash.feb14 at gmail.com>
> *To:* chungyu <chungyu at ms11.voip.edu.tw>
> *Cc:* users openser.org <Users at 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
>
>


-- 
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/200a548f/attachment.htm 


More information about the Users mailing list