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

[Anthony Minessale]

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