<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="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div 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"><span class="q"> <font size="3">modparam("avpops","avp_alias","store=s:domain") </font></span></font></div></div></blockquote><div> </div><br><div> </div><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div bgcolor="#ffffff"><div><font face="新細明體" size="2"><font size="3">avp_write("$ruri/domain/username","$avp(store)");
</font></font></div></div></blockquote><div><br>remove the either username or domain , or simle give the $ruri, <br>Below one also same , but is there contact table is exists or not <br>if not exists , it stores in usr_preference table ( default)
<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div bgcolor="#ffffff"><div><font face="新細明體" size="2"><font size="3"> 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><span class="q">
<div><font face="新細明體"></font> </div>
<div><font face="新細明體" size="2">Thanks a lot in advance</font></div></span><span class="sg">
<div><font face="新細明體">Chungyu</font></div></span><div><span class="e" id="q_111d58a9245dc71f_5">
<blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div>----- Original Message ----- </div>
<div style="background: rgb(228, 228, 228) none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><b>From:</b>
<a title="sunkara.raviprakash.feb14@gmail.com" href="mailto:sunkara.raviprakash.feb14@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">raviprakash sunkara</a>
</div>
<div><b>To:</b> <a title="chungyu@ms11.voip.edu.tw" href="mailto:chungyu@ms11.voip.edu.tw" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">chungyu</a> </div>
<div><b>Cc:</b> <a title="Users@openser.org" href="mailto:Users@openser.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">users openser.org</a> </div>
<div><b>Sent:</b> Monday, April 09, 2007 1:57 PM</div>
<div><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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">chungyu@ms11.voip.edu.tw</a>>
wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<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="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<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="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<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="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<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 href="http://iptel.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">iptel.org</a>
<br>=><br> -----------------------------<br> |
username | domain | |<br>
-----------------------------<br> |
bob | <a href="http://iptel.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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 href="mailto:Users@openser.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Users@openser.org</a><br><a href="http://openser.org/cgi-bin/mailman/listinfo/users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
ravi.sunkara@hyperion-tech.com
</a><br>M:+91 9985077535<br><a href="http://www.hyperion-tech.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.hyperion-tech.com</a><br>Client and
Parent company :- <a href="http://www.august-networks.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.august-networks.com</a>
</blockquote></span></div></div>
</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>