<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
loadmodule "avpops.so"<br>
modparam("avpops", "uuid_column", "uuid")<br>
<br>
########################################################################<br>
# Request route 'usr-preferences-callee'<br>
########################################################################<br>
route[4] {<br>
xlog("L_INFO", "[04] -----> Request route
'usr-preferences-callee' - M=$rm RURI=$ru F=$fu T=$tu IP=$si
ID=$ci\n");<br>
xlog("L_INFO", "[04] Load callee preferences for uuid
'$avp(s:callee_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si
ID=$ci\n");<br>
avp_db_load("$avp(s:callee_uuid)", "*"); # load callee avps<br>
if(is_avp_set("$avp(s:cfu)/s")) {<br>
xlog("L_INFO", "[04] Call-forward-unconditional to
'$avp(s:cfu)' found - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n");<br>
route(8); # Request route 'cfu-acc'<br>
avp_delete("$avp(s:caller_uuid)/g");<br>
avp_copy("$avp(s:callee_uuid)", "$avp(s:caller_uuid)/d");<br>
avp_pushto("$ru", "$avp(s:cfu)");<br>
route(3); # Request route 'usr-preferences-caller'<br>
route(14); # Request route 'invite-find-callee'<br>
exit;<br>
}<br>
if(is_avp_set("$avp(s:ringtimeout)/n")) {<br>
xlog("L_INFO", "[04] Setting ring timeout to
$avp(s:ringtimeout) secs - M=$rm RURI=$ru F=$fu T=$tu IP=$si
ID=$ci\n");<br>
avp_copy("$avp(s:ringtimeout)",
"$avp(s:callee_fr_inv_timer)/d");<br>
}<br>
}<br>
<br>
<br>
########################################################################<br>
# Request route 'usr-preferences-caller'<br>
########################################################################<br>
route[3] {<br>
xlog("L_INFO", "[03] -----> Request route
'usr-preferences-caller' - M=$rm RURI=$ru F=$fu T=$tu IP=$si
ID=$ci\n");<br>
route(1); # Request route 'clear-usr-preferences-caller'<br>
xlog("L_INFO", "[03] Load caller preferences for uuid
'$avp(s:caller_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si
ID=$ci\n");<br>
avp_db_load("$avp(s:caller_uuid)", "*"); # load caller avps<br>
avp_copy("$avp(s:cli)", "$avp(s:caller_cli)/d");<br>
if(is_avp_set("$avp(s:clir)/n") &&
avp_check("$avp(s:clir)", "eq/i:1")) {<br>
setflag(28); # mark for anonymization<br>
}<br>
}<br>
<br>
<br>
On 13.08.2010 18:30, David J. wrote:
<blockquote cite="mid:4C655713.9090109@styleflare.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Thanks, Pasan, Jeff,<br>
<br>
Jeff, when you query by uuid, can you show me a sample how to do
it that way?<br>
<br>
<br>
<br>
On 8/13/10 9:15 AM, Jeff Pyle wrote:
<blockquote
cite="mid:A5ACA0B4-2501-4804-82E9-F4B462398BE3@fidelityvoice.com"
type="cite">David,
<div><br>
</div>
<div>As Pasan mentioned, it can be used for the query key for
whatever value you're pulling. In my network, the uuid could
be a trunk name if I'm storing trunk attributes, a trunk group
number if I'm storing data about that group, or a phone number
to hold call forwarding or other information about that phone
number...</div>
<div><br>
</div>
<div>There are several ways in the AVP environment to key
values. I use uuid rather than username or username/domain.</div>
<div><br>
</div>
<div><br>
</div>
<div>- Jeff</div>
<div><br>
<div>
<div>On Aug 13, 2010, at 8:08 AM, David J. wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div text="#000000" bgcolor="#ffffff"> Thx...<br>
<br>
Any idea what the purpose of the field is?<br>
<br>
<br>
<br>
On 8/13/10 6:39 AM, Pasan Meemaduma wrote:
<blockquote
cite="mid:662878.11553.qm@web45202.mail.sp1.yahoo.com"
type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div style="font-family: times new roman,new
york,times,serif; font-size: 12pt;">
<div>Hi David,<br>
<br>
UUID field is not mandatory. you can just insert
other fields without UUID.<br>
<br>
It could use as a reference key if you want.<br>
<br>
+-------+------+------------+-----------+-----------+------+-------+---------------------+<br>
| id | uuid | username | domain |
attribute | type | value | last_modified |<br>
+-------+------+------------+-----------+-----------+------+-------+---------------------+<br>
| 14497 | | xxx | xxxx | timeout | 0 |
50 | 2000-03-02 16:21:59 | <br>
<br>
</div>
<div style="font-family: times new roman,new
york,times,serif; font-size: 12pt;"><br>
<div style="font-family:
arial,helvetica,sans-serif; font-size: 13px;"><font
size="2" face="Tahoma">
<hr size="1"><b><span style="font-weight:
bold;">From:</span></b> David J. <a
moz-do-not-send="true"
class="moz-txt-link-rfc2396E"
href="mailto:david@styleflare.com"><david@styleflare.com></a><br>
<b><span style="font-weight: bold;">To:</span></b>
OpenSIPS users mailling list <a
moz-do-not-send="true"
class="moz-txt-link-rfc2396E"
href="mailto:users@lists.opensips.org"><users@lists.opensips.org></a><br>
<b><span style="font-weight: bold;">Sent:</span></b>
Friday, August 13, 2010 15:57:28<br>
<b><span style="font-weight: bold;">Subject:</span></b>
[OpenSIPS-Users] UUID value in usr_preferences<br>
</font><br>
List,<br>
<br>
what value should I be using in the UUID field
in the usr_preferences table?<br>
<br>
I was trying to manually insert into the table,
and got stumbled by this <br>
field, the rest seem to make sense.<br>
<br>
Thx.<br>
<br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
ymailto="mailto:Users@lists.opensips.org"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div>
</div>
</div>
<br>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote>
</div>
<br>
</div>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>