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