How to delete entry from sip_regisration table?
We connect freeswitch using odbc connection for device registration on server. Now the problem occur when Freeswitch crashed,down or restart uncertainly that time the entry does not removed from sip_registration table and next time user are not able to make the call. Then we have to manually delete that entry from database to make it working. OS : Debian8 FS version : FreeSWITCH Version 1.6.6~64bit ( 64bit) can anybody help us to resolve this issue?
You shouldn’t have to manually delete them, they should expire naturally on their normal expiration, its more interesting that after restart the reg’s don’t work. In typical setups, you should be able to restart FreeSWITCH and use the regs from before restart to reach a party. Why are they not working? https://freeswitch.org/confluence/display/FREESWITCH/Sofia+SIP+Stack#SofiaSI... <https://freeswitch.org/confluence/display/FREESWITCH/Sofia+SIP+Stack#SofiaSIPStack-Flushingandrebootingregisteredendpoints>
On Sep 28, 2016, at 8:56 AM, devang nathwani <devang.nathwani31589@gmail.com> wrote:
We connect freeswitch using odbc connection for device registration on server.
Now the problem occur when Freeswitch crashed,down or restart uncertainly that time the entry does not removed from sip_registration table and next time user are not able to make the call.
Then we have to manually delete that entry from database to make it working.
OS : Debian8 FS version : FreeSWITCH Version 1.6.6~64bit ( 64bit)
can anybody help us to resolve this issue?
Same thought as Michael, in our case we are able to use the regs already presents in the db after a crash (FS is restarted thanks to its watchdog, -reincarnate option). 2016-09-28 18:13 GMT+02:00 Michael Jerris <mike@jerris.com>:
You shouldn’t have to manually delete them, they should expire naturally on their normal expiration, its more interesting that after restart the reg’s don’t work. In typical setups, you should be able to restart FreeSWITCH and use the regs from before restart to reach a party. Why are they not working?
https://freeswitch.org/confluence/display/FREESWITCH/ Sofia+SIP+Stack#SofiaSIPStack-Flushingandrebootingregisteredendpoints
On Sep 28, 2016, at 8:56 AM, devang nathwani <devang.nathwani31589@gmail. com> wrote:
We connect freeswitch using odbc connection for device registration on server.
Now the problem occur when Freeswitch crashed,down or restart uncertainly that time the entry does not removed from sip_registration table and next time user are not able to make the call.
Then we have to manually delete that entry from database to make it working.
OS : Debian8 FS version : FreeSWITCH Version 1.6.6~64bit ( 64bit)
can anybody help us to resolve this issue?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
You could add action in init script to truncate that table.... Just a thought On Sep 28, 2016 2:57 PM, "devang nathwani" <devang.nathwani31589@gmail.com> wrote:
We connect freeswitch using odbc connection for device registration on server.
Now the problem occur when Freeswitch crashed,down or restart uncertainly that time the entry does not removed from sip_registration table and next time user are not able to make the call.
Then we have to manually delete that entry from database to make it working.
OS : Debian8 FS version : FreeSWITCH Version 1.6.6~64bit ( 64bit)
can anybody help us to resolve this issue?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
It intentionally does not delete udp registrations because they are still valid after a restart. On Wed, Sep 28, 2016 at 1:04 PM, Mirko Brankovic <mirkobrankovic@gmail.com> wrote:
You could add action in init script to truncate that table.... Just a thought
On Sep 28, 2016 2:57 PM, "devang nathwani" <devang.nathwani31589@gmail.com> wrote:
We connect freeswitch using odbc connection for device registration on server.
Now the problem occur when Freeswitch crashed,down or restart uncertainly that time the entry does not removed from sip_registration table and next time user are not able to make the call.
Then we have to manually delete that entry from database to make it working.
OS : Debian8 FS version : FreeSWITCH Version 1.6.6~64bit ( 64bit)
can anybody help us to resolve this issue?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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 ♬ @anthmfs ♬ @FreeSWITCH ♬ ☞ http://freeswitch.org/ ☞ http://cluecon.com/ ☞ http://twitter.com/FreeSWITCH ☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+ <http://freeswitch.org/g+>* ClueCon Weekly Development Call ☎ sip:888@conference.freeswitch.org ☎ +19193869900 https://www.youtube.com/watch?v=9XXgW34t40s https://www.youtube.com/watch?v=NLaDpGQuZDA
participants (5)
-
Anthony Minessale
-
devang nathwani
-
Florent Krieg
-
Michael Jerris
-
Mirko Brankovic