FAIL => "sqlite:///tmp/test.db" (this one should work)

What error does this give?


On 5 February 2013 16:31, François Delawarde <fdelawarde@wirelessmundi.com> wrote:
I'm on HEAD, but I must be doing something wrong, there is no apparent
reason from the code.

On Tue, 2013-02-05 at 16:05 +0000, Steven Ayre wrote:
> Honestly, I only use ODBC... Maybe someone else can shed some light?
>
> What version are you using?
>
> Steve
>
>
>
> On 5 Feb 2013, at 15:42, François Delawarde <fdelawarde@wirelessmundi.com> wrote:
>
> > Steven, does "sqlite://" prefix work for you? Not sure if it's a bug or
> > I'm doing something wrong. I tried the following from lua dbh:
> >
> > FAIL => "sqlite:///tmp/test.db" (this one should work)
> > FAIL => "sqlite://tmp/test.db" (shouldn't work, but just in case...)
> > OK   => "/tmp/test.db" (no prefix)
> >
> > François.
> >
> >
> > On Tue, 2013-02-05 at 12:55 +0000, Steven Ayre wrote:
> >> core: was an old prefix? I knew that change broke some ODBC DSNs
> >> (names without username+password, eg when they're specified in
> >> odbc.ini) but hadn't realised that had been broken too - that needs
> >> documenting as well on the Wiki I guess...
> >> http://wiki.freeswitch.org/wiki/Release_Notes#odbc-dsn
> >>
> >>
> >> Just a thought for the developers, but perhaps modules with odbc-dsn
> >> parameters should have this renamed to dsn or something now since it's
> >> not odbc-specific at all any longer. Easy enough to recognise both
> >> 'dsn' and 'odbc-dsn' names to remain backwards compatible (which I've
> >> seen done with typos in config setting names in the past
> >> as precedent).
> >>
> >>
> >> -Steve
> >>
> >>
> >>
> >>
> >> On 5 February 2013 11:03, François Delawarde
> >> <fdelawarde@wirelessmundi.com> wrote:
> >>        The behavior recently changed from "core:<path>" to
> >>        "sqlite://<path>".
> >>
> >>        Update: I just tested and it seems that "sqlite://<path>"
> >>        doesn't work,
> >>        but as sqlite is the default, you can just omit the prefix and
> >>        use
> >>        "<path>" to make it work.
> >>
> >>        François.
> >>
> >>
> >>        On Tue, 2013-02-05 at 10:37 +0000, Steven Ayre wrote:
> >>> 'Failure to connect to PGSQL core' happens on ODBC
> >>        connections, that
> >>> seems to be a minor bug in the error message.
> >>>
> >>>
> >>> From the unixODBC error it's interpreting this as a ODBC
> >>        DSN. The
> >>> reason is the sqlite prefix is sqlite:// not core://
> >>> (see http://wiki.freeswitch.org/wiki/DSN). You also don't
> >>        have enough
> >>> slashes.
> >>>
> >>>
> >>> Try:
> >>> local dbh =
> >>        freeswitch.Dbh("sqlite:///usr/local/temp/database.db");
> >>>
> >>>
> >>>
> >>> (note the 3 slashes - :// is standard URI format, the 3rd
> >>        indicates an
> >>> absolute path).
> >>>
> >>>
> >>> -Steve
> >>>
> >>>
> >>>
> >>>
> >>> On 5 February 2013 08:56, Carlo Dimaggio
> >>        <jaasmailing@gmail.com>
> >>> wrote:
> >>>        Hi all!
> >>>
> >>>        I have a lua script in which i have a statement that
> >>        connects
> >>>        to a sqlite db:
> >>>
> >>>        local dbh =
> >>>        freeswitch.Dbh("core:/usr/local/temp/database.db");
> >>>
> >>>        but i receve in FS CLI this error that refers to a
> >>        Pgsql
> >>>        instead of sqlite:
> >>>
> >>>        2013-02-05 09:40:10.379612 [ERR] switch_odbc.c:365
> >>        STATE:
> >>>        IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data
> >>        source name
> >>>        not found, and no default driver specified
> >>>        2013-02-05 09:40:10.379612 [CRIT]
> >>        switch_core_sqldb.c:504
> >>>        Failure to connect to PGSQL core!
> >>>        2013-02-05 09:40:10.379612 [ERR]
> >>        freeswitch_lua.cpp:354
> >>>        Connection failed.  DBH NOT Connected.
> >>>        2013-02-05 09:40:10.379612 [ERR]
> >>        freeswitch_lua.cpp:435 DBH
> >>>        NOT Connected.
> >>>
> >>>
> >>>        Can you help me?
> >>>
> >>>        Best regards,
> >>        _________________________________________________________________________
> >>>        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
> >>
> >>
> >>
> >> _________________________________________________________________________
> >> 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



_________________________________________________________________________
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