[Freeswitch-users] lua freeswitch.Dbh sqlite error
Carlo Dimaggio
jaasmailing at gmail.com
Wed Feb 6 11:47:32 MSK 2013
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 at wirelessmundi.com <mailto:fdelawarde at 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 at wirelessmundi.com
> <mailto:fdelawarde at 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 at wirelessmundi.com
> <mailto:fdelawarde at 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 at gmail.com <mailto:jaasmailing at 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 at freeswitch.org <mailto: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
> <mailto: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 <mailto: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
> <mailto: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 <mailto: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
> <mailto: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 <mailto: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
> <mailto: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 <mailto: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
> <mailto: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 <mailto: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
> <mailto: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 <mailto: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
> <mailto: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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130206/c6a7058c/attachment-0001.html
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users
mailing list