New subject: [Serusers] still no help - usrloc synchronization

5 Apr 2005

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
 >
 >
 > < BR>> ============================
 >
 > . . .
 > # -------------------------  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,
 >& gt;
 >> 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.