---- 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.