[Freeswitch-users] sofia_reg_internal.db and odbc mysql.

[Anthony Minessale]

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 at 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 at gmail.com
> To: freeswitch-users at 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 at 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 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 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