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

Fri Apr 13 00:29:50 MSD 2012

also you can just delete it and it will auto-generate a new one.

On Wed, Apr 11, 2012 at 7:05 AM, Yuriy Nasida <nasida at live.ru> wrote:
> 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
>
> _________________________________________________________________________
> 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