<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=新細明體>Hi Raviprakash sunkara:</FONT></DIV>
<DIV><FONT face=新細明體> Thank for the reply.
I am trying use the solution.</FONT></DIV>
<DIV><FONT face=新細明體></FONT> </DIV>
<DIV><FONT face=新細明體 size=2> <FONT
size=3>modparam("avpops","avp_alias","store=s:domain") </FONT><BR> <FONT
size=3>avp_write("$ruri/domain/username","$avp(store)");
<BR> avp_db_store("$ruri/domain/username",
"$avp(store)/contact")</FONT></FONT></DIV>
<DIV><FONT face=新細明體></FONT> </DIV>
<DIV><FONT face=新細明體>system reply</FONT></DIV>
<DIV><FONT face=新細明體> ERROR:avpops:fixup_write_avp: flag "domain/username"
unknown!</FONT></DIV>
<DIV><FONT face=新細明體></FONT> </DIV>
<DIV><FONT face=新細明體>I only want uri of callee save into contact(table
name)</FONT></DIV>
<DIV><FONT face=新細明體>Try most the param for avo_db_store(),but reply
</FONT></DIV>
<DIV><FONT face=新細明體>submit_query(): unknow column 'attribute' in 'field
list'</FONT></DIV>
<DIV><FONT face=新細明體>db_insert: Error while submitting query</FONT></DIV>
<DIV><FONT face=新細明體>ERROR:avpops:db_store: insert failed</FONT></DIV>
<DIV><FONT face=新細明體></FONT> </DIV>
<DIV><FONT face=新細明體 size=2>Thanks a lot in advance</FONT></DIV>
<DIV><FONT face=新細明體>Chungyu</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt 新細明體">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt 新細明體; font-color: black"><B>From:</B>
<A title=sunkara.raviprakash.feb14@gmail.com
href="mailto:sunkara.raviprakash.feb14@gmail.com">raviprakash sunkara</A>
</DIV>
<DIV style="FONT: 10pt 新細明體"><B>To:</B> <A title=chungyu@ms11.voip.edu.tw
href="mailto:chungyu@ms11.voip.edu.tw">chungyu</A> </DIV>
<DIV style="FONT: 10pt 新細明體"><B>Cc:</B> <A title=Users@openser.org
href="mailto:Users@openser.org">users openser.org</A> </DIV>
<DIV style="FONT: 10pt 新細明體"><B>Sent:</B> Monday, April 09, 2007 1:57 PM</DIV>
<DIV style="FONT: 10pt 新細明體"><B>Subject:</B> Re: [Users] avp_db_store can't
write into database</DIV>
<DIV><BR></DIV><BR><BR>
<DIV><SPAN class=gmail_quote>On 4/9/07, <B class=gmail_sendername>chungyu</B>
<<A href="mailto:chungyu@ms11.voip.edu.tw">chungyu@ms11.voip.edu.tw</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV bgcolor="#ffffff">
<DIV><FONT size=2>Hi all,<BR>I am trying to use avp_db_store() stores my
table "contact" with caller uri</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>ex:<BR> table name:
contact<BR> -----------------------------<BR> |
username | domain |
|<BR> -----------------------------<BR>
|
|
| |<BR>
----------------------------- <BR>
|
|
| |<BR>
-----------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2> If (method=="INVITE"){<BR>
avp_write("$ruri/username", "s:name");</FONT></DIV></DIV></BLOCKQUOTE>
<DIV><BR><BR>in Loading paramater of avp module <BR>Did U use this
. <BR>modparam("avpops","avp_alias","store=s:domain")
<BR>modparam(avpops","use_domain",1)<BR><BR></DIV><BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV bgcolor="#ffffff">
<DIV><FONT size=2> avp_write("$ruri/domain",
"s:domain"); </FONT></DIV></DIV></BLOCKQUOTE>
<DIV><BR>use this <BR>avp_write("$ruri/domain/username","$avp(store)");
<BR></DIV><BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV bgcolor="#ffffff">
<DIV><FONT size=2> avo_db_store("s:name",
"s:username/contact")</FONT></DIV></DIV></BLOCKQUOTE>
<DIV><BR>avp_db_store("$ruri/domain/username","$avp(store)/contat_table_name");
<BR></DIV><BR><BR>I hopes this will helps U.... <BR>Let me know, <BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV bgcolor="#ffffff">
<DIV><FONT size=2> avp_db_store("s:domain",
"s:domain/contact");<BR> };</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>if the call bob then save username and domain of callee in
contact<BR>callee: bob at <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://iptel.org" target=_blank>iptel.org</A>
<BR>=><BR> -----------------------------<BR> |
username | domain | |<BR>
-----------------------------<BR> |
bob | <A onclick="return top.js.OpenExtLink(window,event,this)"
href="http://iptel.org" target=_blank>iptel.org</A> |
|<BR> ----------------------------- <BR>
|
|
| |<BR> -----------------------------<BR> but
not success, system reply <BR>ERROR:avpops:db_store: insert
faild</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Am I setting wrong param for avo_db_store()?<BR>Thanks a
lot in advance</FONT></DIV>
<DIV> </DIV>
<DIV><FONT
size=2>chungyu<BR></FONT></DIV></DIV><BR>_______________________________________________<BR>Users
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:Users@openser.org">Users@openser.org</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://openser.org/cgi-bin/mailman/listinfo/users"
target=_blank>http://openser.org/cgi-bin/mailman/listinfo/users</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>Thanks and Regards<BR>Ravi Prakash Sunkara <BR><A
href="mailto:ravi.sunkara@hyperion-tech.com">ravi.sunkara@hyperion-tech.com
</A><BR>M:+91 9985077535<BR><A
href="http://www.hyperion-tech.com">www.hyperion-tech.com</A><BR>Client and
Parent company :- <A
href="http://www.august-networks.com">www.august-networks.com</A>
</BLOCKQUOTE></BODY></HTML>