<!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=新細明體 size=2></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 新細明體"><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></DIV>
<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 face="$B?7:YL@qs(B">Hi Raviprakash
sunkara:</FONT></DIV>
<DIV><FONT face="$B?7:YL@qs(B">
Thank for the reply. I am trying use the
solution.</FONT></DIV>
<DIV><FONT face="$B?7:YL@qs(B"></FONT> </DIV>
<DIV><FONT face="$B?7:YL@qs(B" size=2><SPAN
class=q> <FONT
size=3>modparam("avpops","avp_alias","store=s:domain") </FONT></SPAN></FONT></DIV></DIV></BLOCKQUOTE>
<DIV> </DIV>
<DIV><BR></DIV>
<DIV> </DIV>
<DIV><BR></DIV>
<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 face="$B?7:YL@qs(B" 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) </DIV>
<DIV> </DIV>
<DIV><FONT face=新細明體 size=2>contact table is exists and not save into
usr_preference</FONT></DIV>
<DIV><FONT face=新細明體 size=2></FONT> </DIV>
<DIV><FONT face=新細明體 size=2>This is my confgure</FONT></DIV>
<DIV><FONT face=新細明體 size=2></FONT><FONT face=新細明體 size=2>modparam("avpops",
"avp_table", "conatct")</FONT><BR><FONT face=新細明體 size=2>modparam("avpops",
"domain_column", "domain")</FONT></DIV>
<DIV><FONT face=新細明體 size=2>modparam("avpops", "username_column",
"username")</FONT></DIV>
<DIV><FONT face=新細明體 size=2>modparam("avpops", "avp_aliases",
"store=s:friend")</FONT></DIV><FONT face=新細明體 size=2></FONT></BLOCKQUOTE>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"><FONT
face=新細明體 size=2>
<DIV>if (method=="INVITE"){</DIV>
<DIV> avp_write("$ruri/username", "$store");</DIV>
<DIV> avp_db_store("$store", "s:/contact")</DIV>
<DIV> }</DIV>
<DIV> </DIV>
<DIV>if call bob then bob'name save into contact table</DIV>
<DIV> </DIV>
<DIV>username | domain<BR>------------------------</DIV>
<DIV>bob
| null</DIV>
<DIV>-----------------------</DIV>
<DIV> </DIV>
<DIV>Thanks a lot in advance</DIV>
<DIV>Chungyu</DIV>
<DIV> <BR></FONT><BR></DIV>
<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 face="$B?7:YL@qs(B" size=2><FONT
size=3> avp_db_store("$ruri/domain/username",
"$avp(store)/contact")</FONT></FONT></DIV>
<DIV><FONT face=新細明體 size=2></FONT> </DIV>
<DIV><FONT face="$B?7:YL@qs(B">system reply</FONT></DIV>
<DIV><FONT face="$B?7:YL@qs(B"> ERROR:avpops:fixup_write_avp:
flag "domain/username" unknown!</FONT></DIV>
<DIV><FONT face="$B?7:YL@qs(B"></FONT> </DIV>
<DIV><FONT face="$B?7:YL@qs(B">I only want uri of callee save into
contact(table name)</FONT></DIV>
<DIV><FONT face="$B?7:YL@qs(B">Try most the param for
avo_db_store(),but reply </FONT></DIV>
<DIV><FONT face="$B?7:YL@qs(B">submit_query(): unknow column
'attribute' in 'field list'</FONT></DIV>
<DIV><FONT face="$B?7:YL@qs(B">db_insert: Error while submitting
query</FONT></DIV>
<DIV><FONT face="$B?7:YL@qs(B">ERROR:avpops:db_store: insert
failed</FONT></DIV><SPAN class=q>
<DIV><FONT face="$B?7:YL@qs(B"></FONT> </DIV>
<DIV><FONT face="$B?7:YL@qs(B" size=2>Thanks a lot in
advance</FONT></DIV></SPAN><SPAN class=sg>
<DIV><FONT face="$B?7:YL@qs(B">Chungyu</FONT></DIV></SPAN>
<DIV><SPAN class=e id=q_111d58a9245dc71f_5>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN-RIGHT: 0px">
<DIV><FONT face=新細明體 size=2></FONT> </DIV><BR><BR>
<DIV><SPAN class=gmail_quote>On 4/9/07, <B
class=gmail_sendername>chungyu</B> <<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:chungyu@ms11.voip.edu.tw"
target=_blank>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></BLOCKQUOTE></DIV></BLOCKQUOTE></SPAN></DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>