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
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
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
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.orghttp://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ 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