sofia_reg_internal.db and odbc mysql.
Hello guys! I have set odbc mysql for internal profile. Can I remove sofia_reg_internal.db? I try to delete it but have lost my reg. After restart, FS creates this file again. What is core odbc support? FS just copy the data from file sofia_reg_internal.db to mysql via odbc ? Thanks.
You also must seperately enable odbc in the mod Sofia cfg. Look for dsn in all the configs. On Apr 6, 2012 1:48 PM, "Yuriy Nasida" <nasida@live.ru> wrote:
Hello guys!
I have set odbc mysql for internal profile. Can I remove sofia_reg_internal.db? I try to delete it but have lost my reg. After restart, FS creates this file again. What is core odbc support? FS just copy the data from file sofia_reg_internal.db to mysql via odbc ?
Thanks.
_________________________________________________________________________ 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
Thanks Anthony but It looks like I have explained not absolutely accurately. I have set dsn odbc for switch.xml ; sofia.conf (I am not sure that it is necessary) ; internal and external sip profiles. All works fine. I see in mysql my registered devices. My question is : Does FS use mysql directly in this case? or FS still use sqlite but FS does copying from sqlite to mysql ? For check it I try to delete sqlite db file sofia_reg_internal.db . I have lost my registrations after deleting this file. After restarting, FS has created this file again. FS still use sqlite ? Please correct me if I am mistaken. Thanks. Date: Fri, 6 Apr 2012 21:22:39 -0500 From: anthony.minessale@gmail.com To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] sofia_reg_internal.db and odbc mysql. You also must seperately enable odbc in the mod Sofia cfg. Look for dsn in all the configs. On Apr 6, 2012 1:48 PM, "Yuriy Nasida" <nasida@live.ru> wrote: Hello guys! I have set odbc mysql for internal profile. Can I remove sofia_reg_internal.db? I try to delete it but have lost my reg. After restart, FS creates this file again. What is core odbc support? FS just copy the data from file sofia_reg_internal.db to mysql via odbc ? Thanks. _________________________________________________________________________ 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
if you internal profile xml has this line it will not use sqlite <param name="odbc-dsn" value="your:dsn"/> I tried this and then deleted the sqlite file. The file remained gone and the registrations persisted. I restarted FS and the file was still not there. I removed the config option and restarted and the file returned. Clearly you have some sort of misconfiguration? Which version of FS are you using? On Wed, Apr 11, 2012 at 6:58 AM, Yuriy Nasida <nasida@live.ru> wrote:
Thanks Anthony but It looks like I have explained not absolutely accurately. I have set dsn odbc for switch.xml ; sofia.conf (I am not sure that it is necessary) ; internal and external sip profiles. All works fine. I see in mysql my registered devices. My question is :
Does FS use mysql directly in this case? or FS still use sqlite but FS does copying from sqlite to mysql ? For check it I try to delete sqlite db file sofia_reg_internal.db . I have lost my registrations after deleting this file. After restarting, FS has created this file again. FS still use sqlite ? Please correct me if I am mistaken.
Thanks.
________________________________ Date: Fri, 6 Apr 2012 21:22:39 -0500 From: anthony.minessale@gmail.com To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] sofia_reg_internal.db and odbc mysql.
You also must seperately enable odbc in the mod Sofia cfg. Look for dsn in all the configs. On Apr 6, 2012 1:48 PM, "Yuriy Nasida" <nasida@live.ru> wrote:
Hello guys!
I have set odbc mysql for internal profile. Can I remove sofia_reg_internal.db? I try to delete it but have lost my reg. After restart, FS creates this file again. What is core odbc support? FS just copy the data from file sofia_reg_internal.db to mysql via odbc ?
Thanks.
_________________________________________________________________________ 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
_________________________________________________________________________ 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
Anthony, my internal profile really has this line and I see registrations in mysql.Probably I have something wrong but I have not idea what exactly. freeswitch@internal> version FreeSWITCH Version 1.0.head (git-2ec02e5 2012-03-01 13-22-52 -0600) Thanks.
Date: Wed, 11 Apr 2012 13:16:53 -0500 From: anthony.minessale@gmail.com To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] sofia_reg_internal.db and odbc mysql.
if you internal profile xml has this line it will not use sqlite
<param name="odbc-dsn" value="your:dsn"/>
I tried this and then deleted the sqlite file. The file remained gone and the registrations persisted. I restarted FS and the file was still not there. I removed the config option and restarted and the file returned.
Clearly you have some sort of misconfiguration? Which version of FS are you using?
On Wed, Apr 11, 2012 at 6:58 AM, Yuriy Nasida <nasida@live.ru> wrote:
Thanks Anthony but It looks like I have explained not absolutely accurately. I have set dsn odbc for switch.xml ; sofia.conf (I am not sure that it is necessary) ; internal and external sip profiles. All works fine. I see in mysql my registered devices. My question is :
Does FS use mysql directly in this case? or FS still use sqlite but FS does copying from sqlite to mysql ? For check it I try to delete sqlite db file sofia_reg_internal.db . I have lost my registrations after deleting this file. After restarting, FS has created this file again. FS still use sqlite ? Please correct me if I am mistaken.
Thanks.
________________________________ Date: Fri, 6 Apr 2012 21:22:39 -0500 From: anthony.minessale@gmail.com To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] sofia_reg_internal.db and odbc mysql.
You also must seperately enable odbc in the mod Sofia cfg. Look for dsn in all the configs. On Apr 6, 2012 1:48 PM, "Yuriy Nasida" <nasida@live.ru> wrote:
Hello guys!
I have set odbc mysql for internal profile. Can I remove sofia_reg_internal.db? I try to delete it but have lost my reg. After restart, FS creates this file again. What is core odbc support? FS just copy the data from file sofia_reg_internal.db to mysql via odbc ?
Thanks.
_________________________________________________________________________ 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
_________________________________________________________________________ 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
participants (2)
-
Anthony Minessale
-
Yuriy Nasida