David,
The documentation and examples included with opensips are excellent for this
type of operation. The first place I use it in my opensips.cfg is to load a
trunk flag variable, using the To user of the registration as the key. This
key matches the UUID in my "trunk" table.
if (is_method("REGISTER")) {
if (is_avp_set("$avp(s:t_flags)"))
avp_delete("$avp(s:t_flags)/g");
avp_db_load("$tU", "$avp(s:t_flags)");
In this case, I load an avp called $avp(s:t_flags) based on the To user of the
REGISTER packet (pseudo-variable $tU), clearing it out just in case it was
already there. Which is unlikely on a REGISTER.
Hopefully that's helpful. Good luck. I've found the best way to learn this is
to make heavy use of xlog to look at what the inputs and outputs of the
functions. That way, you know what's going in, you can determine what the
function is doing (with help from the docs!), and you see what comes out of it.
- Jeff
On Aug 13, 2010, at 10:30 AM, David J. wrote:
Thanks, Pasan, Jeff,
Jeff, when you query by uuid, can you show me a sample how to do it that way?
On 8/13/10 9:15 AM, Jeff Pyle wrote:
David,
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...
There are several ways in the AVP environment to key values. I use uuid rather
than username or username/domain.
- Jeff
On Aug 13, 2010, at 8:08 AM, David J. wrote:
Thx...
Any idea what the purpose of the field is?
On 8/13/10 6:39 AM, Pasan Meemaduma wrote:
Hi David,
UUID field is not mandatory. you can just insert other fields without UUID.
It could use as a reference key if you want.
+-------+------+------------+-----------+-----------+------+-------+---------------------+
| id | uuid | username | domain | attribute | type | value |
last_modified |
+-------+------+------------+-----------+-----------+------+-------+---------------------+
| 14497 | | xxx | xxxx | timeout | 0 | 50 | 2000-03-02 16:21:59 |
________________________________
From: David J. <[email protected]><mailto:[email protected]>
To: OpenSIPS users mailling list
<[email protected]><mailto:[email protected]>
Sent: Friday, August 13, 2010 15:57:28
Subject: [OpenSIPS-Users] UUID value in usr_preferences
List,
what value should I be using in the UUID field in the usr_preferences table?
I was trying to manually insert into the table, and got stumbled by this
field, the rest seem to make sense.
Thx.
_______________________________________________
Users mailing list
[email protected]<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]<mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
