[Freeswitch-users] lua freeswitch.Dbh sqlite error

[François Delawarde]

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> 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>
>         > 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
>         >         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
>         
>         
>         
>         _________________________________________________________________________
>         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
> 
> 
> 
> 
> 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