[Freeswitch-users] lua freeswitch.Dbh sqlite error

[Steven Ayre]

'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
>
> 
> 
>
> 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/20130205/4e538c99/attachment-0001.html