Hi Carlo,

It was a bug in FS which has been fixed in the master branch (1.3). Try upgrading to verify that fixes your error. At some point that'll trickle down into the v1.2.stable branch too.

-Steve



On 6 February 2013 08:47, Carlo Dimaggio <jaasmailing@gmail.com> wrote:
I have the same behaviour.
Without prefix it works, while with sqlite:///<file> the error is:

2013-02-06 09:46:29.169603 [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-06 09:46:29.169603 [CRIT] switch_core_sqldb.c:504 Failure to connect to PGSQL sqlite!
2013-02-06 09:46:29.169603 [ERR] freeswitch_lua.cpp:354 Connection failed.  DBH NOT Connected.


Regards,

Il 05/02/13 17.42, Steven Ayre ha scritto:
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



_________________________________________________________________________
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