<!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.2604" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>Have you tried to forward_tcp("address","port"); example in the other
thread going on?</DIV>
<DIV>g-)</DIV>
<DIV>---- Original Message ----<BR>From: Tina<BR>To: Greger V. Teigre ; Matt
Schulte<BR>Cc: serusers@lists.iptel.org<BR>Sent: Wednesday, April 06, 2005 09:24
PM<BR>Subject: Re: [Serusers] still no help - usrloc synchronization<BR><BR>>
Yep, it didn't help<BR>> <BR>> REGISTER++++fixing contact and port<BR>>
Fix contact: Insert buf - sip:tuka@192.168.25.113:5060<BR>> 6(1305)
ERROR: t_newtran: transaction already in process 0x28361068<BR>> <BR>>
"Greger V. Teigre" <greger@teigre.com> wrote:<BR>> The error means that
t_newtran has been run while an existing<BR>> transaction is still in the
workings. Have you tried moving your<BR>> save() to *before* the
t_replicate()? <BR>> g-)<BR>> <BR>> ---- Original Message
----<BR>> From: Tina<BR>> To: Matt Schulte<BR>> Cc: serusers@lists.iptel.org
; greger@teigre.com<BR>> Sent: Tuesday, April 05, 2005 05:00 PM<BR>>
Subject: RE: [Serusers] still no help - usrloc synchronization<BR>>
<BR>>> Thanks a lot, gentelmens!<BR>>> <BR>>> I have
jumped to the same conclusion. The only thing I am worried -<BR>>>
t_replicate() creates aditional SIP traffic between sers. And I
also<BR>>> get some strange error with each REGISTER:<BR>>>
<BR>>> 1(712) ERROR: t_newtran: transaction already in process
0x28336768<BR>>> <BR>>> Don't have any idea what I am doing
wrong....<BR>>> <BR>>> Below is my ser.cfg snippet.<BR>>> As
far as you see I am using mediaproxy package to solve NAT issues.<BR>>> I
always force relay, cause I had nathelper problems with<BR>>>
UAC1->ser->NAT->UAC2 configuration.<BR>>> I am going to test new
mediaproxy release.<BR>>> BRs,<BR>>> Tina<BR>>> <BR>>>
<BR>>> !<BR>>> ============================<BR>>> <BR>>>
. . .<BR>>> # ------------------------- request routing
logic<BR>>> ------------------- # main routing logic<BR>>>
route{<BR>>>
#-------------------------------------------------------<BR>>> if
(!method=="REGISTER") record_route();<BR>>>
#-------------------------------------------------------????????????????????<BR>>>
# loose-route processing<BR>>> if (loose_route())
{<BR>>> route(8); #--go to mediaproxy
processing<BR>>> break;<BR>>> };<BR>>>
...<BR>>> if (method=="REGISTER") {<BR>>> #------Replicate to
the peers<BR>>> <BR>>> #---Ser 1<BR>>> if
(!src_ip==192.168.25.103)<BR>>>
t_replicate("192.168.25.103","5060");<BR>>> #---Ser
2<BR>>> if
(!src_ip==192.168.25.115)<BR>>>
t_replicate("192.168.25.115","5060");<BR>>> <BR>>> save
("location");<BR>>> break;<BR>>> };<BR>>>
#-----------------------------------------------INVITE<BR>>> if
(method=="INVITE") {<BR>>> log (1, "INVITE: Radius
Accounting\n");<BR>>> t_on_failure("4"); #---voice
mail<BR>>>
use_media_proxy();<BR>>> t_on_reply("5");
#--mediaproxy<BR>>> };<BR>>>
#--------------------------------------------------BYE<BR>>> if
(method=="BYE" || method=="CANCEL") {<BR>>> log (1, "BYE or
CANCEL: Radius Accounting\n");<BR>>> };<BR>>>
#---------------------------------------------------<BR>>> if
(!lookup("location") && !lookup("aliases"))
{<BR>>> sl_send_reply("404", "Not
Found");<BR>>> break;<BR>>>
};<BR>>> if (!t_relay()) {<BR>>>
sl_reply_error();<BR>>> };<BR>>> }<BR>>> <BR>>>
#-------------------------------------------------------<BR>>>
failure_route[4]{<BR>>> if
(t_check_status("408|486")){<BR>>>
append_hf("P-hint: Rewrited to VM");<BR>>>
rewritehostport("192.168.25.116:5060");<BR>>>
append_branch();<BR>>> t_relay();<BR>>>
break;<BR>>> };<BR>>> }<BR>>>
#---------------------------------------------------------<BR>>>
onreply_route[5]{<BR>>> if (status =~
"(183)|2[0-9][0-9]" && !search("^Content-Length:\<BR>>> 0"))
{<BR>>> if (
(!(src_ip=="SERVER1"))<BR>>> &&
(!(src_ip=="SERVER2"))<BR>>> &&
(!(src_ip=="SERVER3")) ){<BR>>> if (
search("c=IN IP4 192.168.*")||search("c=IN IP4<BR>>> 10.*")||search("c=IN
IP4 172.16.*") ) {<BR>>>
fix_contact();<BR>>> };<BR>>> };<BR>>>
use_media_proxy();<BR>>> }<BR>>> }<BR>>> <BR>>>
===================================================<BR>>> <BR>>>
Matt Schulte <mschulte@netlogic.net> wrote:<BR>>> I'm starting to
lean this direction, using t_replicate and all. I<BR>>> could<BR>>>
never get usrloc (db mode) to function properly.. t_replicate is a<BR>>>
dirty<BR>>> but very effective workaround.<BR>>> <BR>>>
-----Original Message-----<BR>>> From: Greger V. Teigre
[mailto:greger@teigre.com]<BR>>> Sent: Saturday, April 02, 2005 1:33
AM<BR>>> To: kramarv@yahoo.com<BR>>> Cc:
serusers@lists.iptel.org<BR>>> Subject: Re: [Serusers] still no help - usrloc
synchronization<BR>>> <BR>>> <BR>>> Have a look at this
thread:<BR>>>
http://lists.iptel.org/pipermail/serusers/2005-January/014669.html<BR>>>
g-)<BR>>> <BR>>> Java Rockx wrote:<BR>>>> Tina,<BR>>>
! ><BR>>>> I thought I saw you post the other day that you did not
want to use<BR>>>> t_replicate(), however, this is probably your best
bet to getting<BR>>>> this<BR>>> <BR>>>> to work,
IMHO.<BR>>>> <BR>>>> Regards,<BR>>>>
Paul<BR>>>> <BR>>>> On Apr 1, 2005 4:08 PM, Tina
wrote:>><BR>>>>> Hi, please help me, I'm stuck with
it!!!!!<BR>>>>> I am trying to set up several sers with a shared
MySQL database for<BR>>>>> location service.<BR>>>>>
<BR>>>>> I set in each ser.cfg:<BR>>>>>
<BR>>>>> modparam("usrloc", "db_mode", 2)<BR>>>>>
modparam("usrloc",<BR>>>>>
"db_url","sql://ser:heslo@192.168.25.163/ser")<BR>>>>>
<BR>>>>> and the servers are not synchronized.<BR>>>>>
The I set<BR>>>>> modparam("usrloc", "db_mode",
2)<BR>>>>> <BR>>>>> <BR>>>>> made UAC
(Xlite) register to one of the servers.<BR>>>> &g! t; I see it via
usrloc, but there is no record in "location"<BR>>>> mySQL
<BR>>>>> table....So others do not see the client and I'm unable to
make<BR>>>>> calls....<BR>>>>> <BR>>>>>
<BR>>>>> Please help how to work with usrloc and
mySQL...<BR>>>>> <BR>>>>> Tina,<BR>>>>>
software engineer<BR>>>>> <BR>>>>>
________________________________<BR>>>>> Do you
Yahoo!?<BR>>>>> Better first dates. More second dates. Yahoo!
Personals<BR>>>>> <BR>>>>> <BR>>>>>
_______________________________________________<BR>>>>> Serusers
mailing list<BR>>>>> serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers<BR>>>>>
<BR>>>>> <BR>>>>> <BR>>>> <BR>>>>
_______________________________________________<BR>>>> Serusers mailing
list<BR>>>> serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers<BR>>> <BR>>>
_______________________________________________<BR>>> Serusers mailing
list<BR>>> serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers<BR>>> <BR>>>
<BR>>> <BR>>> Do you Yahoo!?<BR>>> Yahoo! Mail - Find what you
need with new enhanced search. Learn<BR>>> more. <BR>>
__________________________________________________<BR>> Do You
Yahoo!?<BR>> Tired of spam? Yahoo! Mail has the best spam protection
around<BR>> http://mail.yahoo.com</DIV></BODY></HTML>