<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<div>Thank again. </div><div><br></div><div>I have fixed this issue.</div><div>I just have replaced sqlite db file sofia_reg_internal.db by same file from other FS and have done flush all regs.</div><div>(usual flushing didn't help)</div><div><br></div><div>It Looks like this db file was damaged not sure how exactly but replacement fixed this issue. </div><div><br></div><br><div><div id="SkyDrivePlaceholder"></div>> Date: Wed, 4 Apr 2012 13:51:02 -0500<br>> From: anthony.minessale@gmail.com<br>> To: freeswitch-users@lists.freeswitch.org<br>> Subject: Re: [Freeswitch-users] incorrect reg rows in sqlite database sofia_reg_internal.db<br>> <br>> I already advised.<br>> <br>> You did the first one and checked your settings.<br>> Next capture sip traffic<br>> <br>> sofia global siptrace on<br>> <br>> and look at all the registers for anything anomalous<br>> <br>> On Wed, Apr 4, 2012 at 1:26 PM, Yuriy Nasida <nasida@live.ru> wrote:<br>> > Anthony, thank you for your answer but I think it is not issue with settings<br>> > of sip devices. Incorrect additional row may be any of my customers. I mean<br>> > that the additional row do change after ./fs_cli -x "sofia profile<br>> > internal flush_inbound_reg"<br>> ><br>> > Also I have this problem after moving to : FreeSWITCH Version 1.0.head<br>> > (git-2ec02e5 2012-03-01 13-22-52 -0600) + Centos 6.<br>> ><br>> > I really don't understand why i have it just after cleaning of all rows...<br>> ><br>> > sqlite> select * from sip_registrations where sip_user=' user2 ';<br>> > | user2 ||||||||||||||||||||<br>> ><br>> > Please advice.<br>> ><br>> > Thanks.<br>> ><br>> > ________________________________<br>> > From: nasida@live.ru<br>> > To: freeswitch-users@lists.freeswitch.org<br>> > Date: Wed, 4 Apr 2012 21:55:56 +0400<br>> > Subject: Re: [Freeswitch-users] incorrect reg rows in sqlite database<br>> > sofia_reg_internal.db<br>> ><br>> ><br>> > Update.<br>> ><br>> > after ./fs_cli -x "sofia profile internal flush_inbound_reg" I have<br>> ><br>> > sqlite> select * from sip_registrations where sip_user=' user2 ';<br>> > | user2 ||||||||||||||||||||<br>> ><br>> > Why?? I must have clear rows!!<br>> ><br>> > Next, I will have 2 rows again but with user3 instead of user1...<br>> ><br>> > Thanks.<br>> ><br>> > ________________________________<br>> > From: nasida@live.ru<br>> > To: freeswitch-users@lists.freeswitch.org<br>> > Date: Wed, 4 Apr 2012 21:20:51 +0400<br>> > Subject: [Freeswitch-users] incorrect reg rows in sqlite database<br>> > sofia_reg_internal.db<br>> ><br>> > Hello guys.<br>> ><br>> > I have issue with incorrect reg rows in sqlite database<br>> > sofia_reg_internal.db. it looks like that one registrations are crossed with<br>> > others. so sometimes i have 2 inbound call for 2 different users instead of<br>> > one. What it can be ? probably it is some bug of new FS version ? Can you<br>> > give me some advise ?<br>> ><br>> > sqlite> select * from sip_registrations where sip_user='user2';<br>> ><br>> > 3c73a57f-34be3361@10.0.0.140|user2|69.XX.XX.101|| user1 <sip:user1@10.0.0.140:5060;fs_nat=yes;fs_path=sip%3Auser1%4079.XX.XX.13%3A5060>|Registered(UDP-NAT)|unknown|1377757948|Linksys/SPA2102-5.2.10;000e081d81c1|user1|69.XX.XX.101|internal|sipproviderdedi1.domain.com|79.XX.XX.13|5060|user1|sip2.sipprovider.com|user1|69.XX.XX.101|69.XX.XX.101|sipproviderdedi1.domain.com|69.XX.XX.101<br>> ><br>> > 3bb28227-edc8becf@80.XX.XX.131|user2|69.XX.XX.101||user2<br>> > <sip:user2@80.XX.XX.131:5060>|Registered(UDP)|unknown|1333557925|Linksys/SPA2102-5.2.10;000e081ac13e|user2|69.XX.XX.101|internal|sipproviderdedi1.domain.com|80.XX.XX.131|5060|user2|sip2.sipprovider.com|user2|69.XX.XX.101|69.XX.XX.101|sipproviderdedi1.domain.com|69.XX.XX.101<br>> ><br>> ><br>> > Why I have first row here? When I call for user2 I have two call (for user1<br>> > an user2) instead of one (for user2).<br>> > I have separate row for user1...<br>> ><br>> > Thanks.<br>> ><br>> > _________________________________________________________________________<br>> > Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<br>> > http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel<br>> > Communication Server http://www.cudatel.com Official FreeSWITCH Sites<br>> > http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com<br>> > FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<br>> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>> > http://www.freeswitch.org<br>> ><br>> > _________________________________________________________________________<br>> > Professional FreeSWITCH Consulting Services: consulting@freeswitch.org<br>> > http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel<br>> > Communication Server http://www.cudatel.com Official FreeSWITCH Sites<br>> > http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com<br>> > FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<br>> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>> > http://www.freeswitch.org<br>> ><br>> > _________________________________________________________________________<br>> > Professional FreeSWITCH Consulting Services:<br>> > consulting@freeswitch.org<br>> > http://www.freeswitchsolutions.com<br>> ><br>> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>> > http://www.cudatel.com<br>> ><br>> > Official FreeSWITCH Sites<br>> > http://www.freeswitch.org<br>> > http://wiki.freeswitch.org<br>> > http://www.cluecon.com<br>> ><br>> > FreeSWITCH-users mailing list<br>> > FreeSWITCH-users@lists.freeswitch.org<br>> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>> > http://www.freeswitch.org<br>> ><br>> <br>> <br>> <br>> -- <br>> Anthony Minessale II<br>> <br>> FreeSWITCH http://www.freeswitch.org/<br>> ClueCon http://www.cluecon.com/<br>> Twitter: http://twitter.com/FreeSWITCH_wire<br>> <br>> AIM: anthm<br>> MSN:anthony_minessale@hotmail.com<br>> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<br>> IRC: irc.freenode.net #freeswitch<br>> <br>> FreeSWITCH Developer Conference<br>> sip:888@conference.freeswitch.org<br>> googletalk:conf+888@conference.freeswitch.org<br>> pstn:+19193869900<br>> <br>> _________________________________________________________________________<br>> Professional FreeSWITCH Consulting Services:<br>> consulting@freeswitch.org<br>> http://www.freeswitchsolutions.com<br>> <br>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>> http://www.cudatel.com<br>> <br>> Official FreeSWITCH Sites<br>> http://www.freeswitch.org<br>> http://wiki.freeswitch.org<br>> http://www.cluecon.com<br>> <br>> FreeSWITCH-users mailing list<br>> FreeSWITCH-users@lists.freeswitch.org<br>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>> http://www.freeswitch.org<br></div> </div></body>
</html>