FreeSWITCH HA Database changes in 1.2
Hello, I noticed recently on FS 1.2 that the table "sip_recovery" wasn't being created automatically by FreeSWITCH. If I specify: <param name="core-recovery-db-dsn" value="maxpowersoft_odbc:freeswitch:blahblah"/> In switch.conf.xml, FreeSWITCH will create a table called "recovery". So my questions are: 1. Have you renamed the sip_recovery table to recovery? 2. Is "core-recovery-db-dsn" a required parameter for HA FreeSWITCH to function? Thanks, Colin
On Fri, Sep 21, 2012 at 6:33 PM, Colin Mason <cmason@frontiernetworks.ca>wrote:
Hello,****
** **
I noticed recently on FS 1.2 that the table “sip_recovery” wasn’t being created automatically by FreeSWITCH. If I specify:****
** **
<param name="core-recovery-db-dsn" value="maxpowersoft_odbc:freeswitch:blahblah"/>****
** **
In switch.conf.xml, FreeSWITCH will create a table called “recovery”.****
** **
** **
** **
So my questions are:****
** **
**1. **Have you renamed the sip_recovery table to recovery?****
**
Yes its been centralized to the core and abstracted so other endpoints can use it.
2. **Is “core-recovery-db-dsn” a required parameter for HA FreeSWITCH to function?****
**
Its required if you choose to use odbc for your recovery table instead of sqlite. Basically set it to the same value as odbc-dsn if that is what you were using with sofia, or give it a dedicated database.
**
Thanks,****
Colin****
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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 FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
Does this now mean that we dint have to use a shared db for recovery ?? I thought that was a requirement , however maybe I missed something . On Sep 24, 2012 10:49 AM, "Anthony Minessale" <anthony.minessale@gmail.com> wrote:
On Fri, Sep 21, 2012 at 6:33 PM, Colin Mason <cmason@frontiernetworks.ca>wrote:
Hello,****
** **
I noticed recently on FS 1.2 that the table “sip_recovery” wasn’t being created automatically by FreeSWITCH. If I specify:****
** **
<param name="core-recovery-db-dsn" value="maxpowersoft_odbc:freeswitch:blahblah"/>****
** **
In switch.conf.xml, FreeSWITCH will create a table called “recovery”.****
** **
** **
** **
So my questions are:****
** **
**1. **Have you renamed the sip_recovery table to recovery?****
**
Yes its been centralized to the core and abstracted so other endpoints can use it.
2. **Is “core-recovery-db-dsn” a required parameter for HA FreeSWITCH to function?****
**
Its required if you choose to use odbc for your recovery table instead of sqlite. Basically set it to the same value as odbc-dsn if that is what you were using with sofia, or give it a dedicated database.
**
Thanks,****
Colin****
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
If you want to recover calls on FS crash, on the same machine, you recover from the DB either in sqlite, whatever. If you want to recover from a different FS instance, then of course you need to have access to it's recovery table. Just now you can use master-master odbc for the recovery table.. and leave the core in sqlite or put it in a ram disk... they are separate now. -Avi On Mon, Sep 24, 2012 at 12:41 PM, jay binks <jaybinks@gmail.com> wrote:
Does this now mean that we dint have to use a shared db for recovery ??
I thought that was a requirement , however maybe I missed something . On Sep 24, 2012 10:49 AM, "Anthony Minessale" <anthony.minessale@gmail.com> wrote:
On Fri, Sep 21, 2012 at 6:33 PM, Colin Mason <cmason@frontiernetworks.ca>wrote:
Hello,****
** **
I noticed recently on FS 1.2 that the table “sip_recovery” wasn’t being created automatically by FreeSWITCH. If I specify:****
** **
<param name="core-recovery-db-dsn" value="maxpowersoft_odbc:freeswitch:blahblah"/>****
** **
In switch.conf.xml, FreeSWITCH will create a table called “recovery”.*** *
** **
** **
** **
So my questions are:****
** **
**1. **Have you renamed the sip_recovery table to recovery?****
**
Yes its been centralized to the core and abstracted so other endpoints can use it.
2. **Is “core-recovery-db-dsn” a required parameter for HA FreeSWITCH to function?****
**
Its required if you choose to use odbc for your recovery table instead of sqlite. Basically set it to the same value as odbc-dsn if that is what you were using with sofia, or give it a dedicated database.
**
Thanks,****
Colin****
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
participants (4)
-
Anthony Minessale
-
Avi Marcus
-
Colin Mason
-
jay binks