Hi,
I was trying to load user attributes form the database (which where previously defined and set through serweb) and after I tried to load them with load_attrs("$tu","@ruri") no attributes appeared for the user identified by ruri. When I loaded attributes using load_attrs("$tr","@ruri") from the uri_attrs table then everything was ok and attributes were loaded.
Please point me what do I missed so the attributes are not loaded?
Below is my ser.cfg code and database contents: if (lookup_user("$tu.uid", "@ruri")) { xlog("L_INFO", " route[INBOUND]: load_attrs($tu,@ruri) <%rm> <%ru> \n"); load_attrs("$tu", "@ruri"); dump_attrs(); xlog("L_INFO", " route[INBOUND]: load_attrs($tr,@ruri) <%rm> <%ru> \n"); load_attrs("$tr", "@ruri"); dump_attrs(); .... }
database: ser@sen:~/ser/ser-2.0/serctl$ ./ser_db show user_attrs | grep testser 32 2 testser@voip.rd.touk.pl testser first_name 32 2 testser@voip.rd.touk.pl last_name 33 2 testser@voip.rd.touk.pl tzl@touk.pl email 32 2 testser@voip.rd.touk.pl phone 32 2 testser@voip.rd.touk.pl Europe/Warsaw timezone 33 2 testser@voip.rd.touk.pl 2007-02-26 13:50:18 datetime_created 32 0 testser@voip.rd.touk.pl 0 sw_allow_find 32 0 testser@voip.rd.touk.pl 0 sw_send_missed 33 2 testser@voip.rd.touk.pl sip:touk2@voip.touk.pl forward_blind 33 2 testser fd for
and output in the log file: Apr 30 11:11:40 sen ser[29958]: route[INBOUND]: load_attrs($tu,@ruri) <INVITE> sip:testser@voip.rd.touk.pl Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:540: class=GLOBAL Apr 30 11:11:40 sen ser[29958]: AVP["lang"]="en" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:550: track=FROM class=DOMAIN Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:560: track=TO class=DOMAIN Apr 30 11:11:40 sen ser[29958]: AVP["did"]="voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: AVP["digest_realm"]="voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:570: track=FROM class=USER Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:580: track=TO class=USER Apr 30 11:11:40 sen ser[29958]: AVP["uid"]="testser@voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:590: track=FROM class=URI Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:600: track=TO class=URI Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: route[INBOUND]: load_attrs($tr,@ruri) <INVITE> sip:testser@voip.rd.touk.pl Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:540: class=GLOBAL Apr 30 11:11:40 sen ser[29958]: AVP["lang"]="en" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:550: track=FROM class=DOMAIN Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:560: track=TO class=DOMAIN Apr 30 11:11:40 sen ser[29958]: AVP["did"]="voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: AVP["digest_realm"]="voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:570: track=FROM class=USER Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:580: track=TO class=USER Apr 30 11:11:40 sen ser[29958]: AVP["uid"]="testser@voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:590: track=FROM class=URI Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:600: track=TO class=URI Apr 30 11:11:40 sen ser[29958]: AVP["forward_blindd"]="sip:hellboy@voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: AVP["forward_voicemaill"]="sip:hellboy@voip.rd.touk.pl"
Cheers Tomasz
Hi Tomasz,
the user attrs are identified by the UID not the uri, so you should call load_attrs("$tu","$tu.uid").
The uid generated by serweb is in the form user@domain, so you could use smtgh like: xlset_attr("$myid","%@ruri.user@%@ruri.host"); load_attrs("$tu","$myid"); but it's meaningless, as the uid attr is already set by the lookup_user call anyway.
Michal
On Mon, 2007-04-30 at 11:12 +0200, tzieleniewski wrote:
Hi,
I was trying to load user attributes form the database (which where previously defined and set through serweb) and after I tried to load them with load_attrs("$tu","@ruri") no attributes appeared for the user identified by ruri. When I loaded attributes using load_attrs("$tr","@ruri") from the uri_attrs table then everything was ok and attributes were loaded.
Please point me what do I missed so the attributes are not loaded?
Below is my ser.cfg code and database contents: if (lookup_user("$tu.uid", "@ruri")) { xlog("L_INFO", " route[INBOUND]: load_attrs($tu,@ruri) <%rm> <%ru> \n"); load_attrs("$tu", "@ruri"); dump_attrs(); xlog("L_INFO", " route[INBOUND]: load_attrs($tr,@ruri) <%rm> <%ru> \n"); load_attrs("$tr", "@ruri"); dump_attrs(); .... }
database: ser@sen:~/ser/ser-2.0/serctl$ ./ser_db show user_attrs | grep testser 32 2 testser@voip.rd.touk.pl testser first_name 32 2 testser@voip.rd.touk.pl last_name 33 2 testser@voip.rd.touk.pl tzl@touk.pl email 32 2 testser@voip.rd.touk.pl phone 32 2 testser@voip.rd.touk.pl Europe/Warsaw timezone 33 2 testser@voip.rd.touk.pl 2007-02-26 13:50:18 datetime_created 32 0 testser@voip.rd.touk.pl 0 sw_allow_find 32 0 testser@voip.rd.touk.pl 0 sw_send_missed 33 2 testser@voip.rd.touk.pl sip:touk2@voip.touk.pl forward_blind 33 2 testser fd for
and output in the log file: Apr 30 11:11:40 sen ser[29958]: route[INBOUND]: load_attrs($tu,@ruri) <INVITE> sip:testser@voip.rd.touk.pl Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:540: class=GLOBAL Apr 30 11:11:40 sen ser[29958]: AVP["lang"]="en" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:550: track=FROM class=DOMAIN Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:560: track=TO class=DOMAIN Apr 30 11:11:40 sen ser[29958]: AVP["did"]="voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: AVP["digest_realm"]="voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:570: track=FROM class=USER Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:580: track=TO class=USER Apr 30 11:11:40 sen ser[29958]: AVP["uid"]="testser@voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:590: track=FROM class=URI Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:600: track=TO class=URI Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: route[INBOUND]: load_attrs($tr,@ruri) <INVITE> sip:testser@voip.rd.touk.pl Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:540: class=GLOBAL Apr 30 11:11:40 sen ser[29958]: AVP["lang"]="en" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:550: track=FROM class=DOMAIN Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:560: track=TO class=DOMAIN Apr 30 11:11:40 sen ser[29958]: AVP["did"]="voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: AVP["digest_realm"]="voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:570: track=FROM class=USER Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:580: track=TO class=USER Apr 30 11:11:40 sen ser[29958]: AVP["uid"]="testser@voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:590: track=FROM class=URI Apr 30 11:11:40 sen ser[29958]: INFO: No AVP present Apr 30 11:11:40 sen ser[29958]: INFO: avp.c:600: track=TO class=URI Apr 30 11:11:40 sen ser[29958]: AVP["forward_blindd"]="sip:hellboy@voip.rd.touk.pl" Apr 30 11:11:40 sen ser[29958]: AVP["forward_voicemaill"]="sip:hellboy@voip.rd.touk.pl"
Cheers Tomasz _______________________________________________ Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Michal Matyska -
tzieleniewski