[Freeswitch-users] incorrect reg rows in sqlite database sofia_reg_internal.db

Wed Apr 11 16:05:09 MSD 2012

Thank again. 
I have fixed this issue.I just have replaced sqlite db file sofia_reg_internal.db by same file from other FS and have done flush all regs.(usual flushing didn't help)
It Looks like this db file was damaged not sure how exactly but replacement fixed this issue. 

> Date: Wed, 4 Apr 2012 13:51:02 -0500
> From: anthony.minessale at gmail.com
> To: freeswitch-users at lists.freeswitch.org
> Subject: Re: [Freeswitch-users] incorrect reg rows in sqlite database	sofia_reg_internal.db
> 
> I already advised.
> 
> You did the first one and checked your settings.
> Next capture sip traffic
> 
> sofia global siptrace on
> 
> and look at all the registers for anything anomalous
> 
> On Wed, Apr 4, 2012 at 1:26 PM, Yuriy Nasida <nasida at live.ru> wrote:
> > Anthony, thank you for your answer but I think it is not issue with settings
> > of sip devices. Incorrect additional row may be any of my customers. I mean
> > that the additional row do change after   ./fs_cli -x "sofia profile
> > internal flush_inbound_reg"
> >
> > Also I have this problem after moving to : FreeSWITCH Version 1.0.head
> > (git-2ec02e5 2012-03-01 13-22-52 -0600)  + Centos 6.
> >
> > I really don't understand why i have it just after cleaning of all rows...
> >
> > sqlite> select * from sip_registrations where sip_user=' user2 ';
> > | user2 ||||||||||||||||||||
> >
> > Please advice.
> >
> > Thanks.
> >
> > ________________________________
> > From: nasida at live.ru
> > To: freeswitch-users at lists.freeswitch.org
> > Date: Wed, 4 Apr 2012 21:55:56 +0400
> > Subject: Re: [Freeswitch-users] incorrect reg rows in sqlite database
> > sofia_reg_internal.db
> >
> >
> > Update.
> >
> > after ./fs_cli -x "sofia profile internal flush_inbound_reg"  I have
> >
> > sqlite> select * from sip_registrations where sip_user=' user2 ';
> > | user2 ||||||||||||||||||||
> >
> > Why?? I must have clear rows!!
> >
> > Next, I will have 2 rows again but with user3 instead of user1...
> >
> > Thanks.
> >
> > ________________________________
> > From: nasida at live.ru
> > To: freeswitch-users at lists.freeswitch.org
> > Date: Wed, 4 Apr 2012 21:20:51 +0400
> > Subject: [Freeswitch-users] incorrect reg rows in sqlite database
> > sofia_reg_internal.db
> >
> > Hello guys.
> >
> > I have issue with incorrect reg rows in sqlite database
> > sofia_reg_internal.db. it looks like that one registrations are crossed with
> > others. so sometimes i have 2 inbound call for 2 different users instead of
> > one. What it can be ? probably it is some bug of new FS version ? Can you
> > give me some advise ?
> >
> > sqlite> select * from sip_registrations where sip_user='user2';
> >
> > 3c73a57f-34be3361 at 10.0.0.140|user2|69.XX.XX.101||  user1 <sip:user1 at 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
> >
> > 3bb28227-edc8becf at 80.XX.XX.131|user2|69.XX.XX.101||user2
> > <sip:user2 at 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
> >
> >
> > Why I have first row here?  When I call for user2 I have two call (for user1
> > an user2) instead of one (for user2).
> > I have separate row for user1...
> >
> > Thanks.
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services: consulting at freeswitch.org
> > http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel
> > Communication Server  Official FreeSWITCH Sites
> > http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
> > FreeSWITCH-users mailing list FreeSWITCH-users at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services: consulting at freeswitch.org
> > http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel
> > Communication Server  Official FreeSWITCH Sites
> > http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
> > FreeSWITCH-users mailing list FreeSWITCH-users at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services:
> > consulting at freeswitch.org
> > http://www.freeswitchsolutions.com
> >
> > 
> > 
> >
> > Official FreeSWITCH Sites
> > http://www.freeswitch.org
> > http://wiki.freeswitch.org
> > http://www.cluecon.com
> >
> > FreeSWITCH-users mailing list
> > FreeSWITCH-users at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
> 
> 
> 
> -- 
> Anthony Minessale II
> 
> FreeSWITCH http://www.freeswitch.org/
> ClueCon http://www.cluecon.com/
> Twitter: http://twitter.com/FreeSWITCH_wire
> 
> AIM: anthm
> MSN:anthony_minessale at hotmail.com
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> IRC: irc.freenode.net #freeswitch
> 
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org
> googletalk:conf+888 at conference.freeswitch.org
> pstn:+19193869900
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120411/b71a5374/attachment-0001.html 