<!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>The error means that t_newtran has been run while an
existing transaction is still in the workings. Have you tried moving
your save() to *before* the t_replicate()?</DIV>
<DIV>g-)</DIV>
<DIV> </DIV>
<DIV>---- 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>>>> I see it via usrloc, but there is no record in
"location" 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 more.</DIV></BODY></HTML>