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...<div>
<a href="http://wiki.freeswitch.org/wiki/Release_Notes#odbc-dsn">http://wiki.freeswitch.org/wiki/Release_Notes#odbc-dsn</a></div><div><div><br></div><div>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).</div>
<div><br></div><div>-Steve</div><div><br></div><div><br><br><div class="gmail_quote">On 5 February 2013 11:03, François Delawarde <span dir="ltr"><<a href="mailto:fdelawarde@wirelessmundi.com" target="_blank">fdelawarde@wirelessmundi.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">The behavior recently changed from "core:<path>" to "sqlite://<path>".<br>
<br>
Update: I just tested and it seems that "sqlite://<path>" doesn't work,<br>
but as sqlite is the default, you can just omit the prefix and use<br>
"<path>" to make it work.<br>
<span class="HOEnZb"><font color="#888888"><br>
François.<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
On Tue, 2013-02-05 at 10:37 +0000, Steven Ayre wrote:<br>
> 'Failure to connect to PGSQL core' happens on ODBC connections, that<br>
> seems to be a minor bug in the error message.<br>
><br>
><br>
> From the unixODBC error it's interpreting this as a ODBC DSN. The<br>
> reason is the sqlite prefix is sqlite:// not core://<br>
> (see <a href="http://wiki.freeswitch.org/wiki/DSN" target="_blank">http://wiki.freeswitch.org/wiki/DSN</a>). You also don't have enough<br>
> slashes.<br>
><br>
><br>
> Try:<br>
> local dbh = freeswitch.Dbh("sqlite:///usr/local/temp/database.db");<br>
><br>
><br>
><br>
> (note the 3 slashes - :// is standard URI format, the 3rd indicates an<br>
> absolute path).<br>
><br>
><br>
> -Steve<br>
><br>
><br>
><br>
><br>
> On 5 February 2013 08:56, Carlo Dimaggio <<a href="mailto:jaasmailing@gmail.com">jaasmailing@gmail.com</a>><br>
> wrote:<br>
> Hi all!<br>
><br>
> I have a lua script in which i have a statement that connects<br>
> to a sqlite db:<br>
><br>
> local dbh =<br>
> freeswitch.Dbh("core:/usr/local/temp/database.db");<br>
><br>
> but i receve in FS CLI this error that refers to a Pgsql<br>
> instead of sqlite:<br>
><br>
> 2013-02-05 09:40:10.379612 [ERR] switch_odbc.c:365 STATE:<br>
> IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name<br>
> not found, and no default driver specified<br>
> 2013-02-05 09:40:10.379612 [CRIT] switch_core_sqldb.c:504<br>
> Failure to connect to PGSQL core!<br>
> 2013-02-05 09:40:10.379612 [ERR] freeswitch_lua.cpp:354<br>
> Connection failed. DBH NOT Connected.<br>
> 2013-02-05 09:40:10.379612 [ERR] freeswitch_lua.cpp:435 DBH<br>
> NOT Connected.<br>
><br>
><br>
> Can you help me?<br>
><br>
> Best regards,<br>
><br>
><br>
> _________________________________________________________________________<br>
> Professional FreeSWITCH Consulting Services:<br>
> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
><br>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
><br>
> Official FreeSWITCH Sites<br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
><br>
> _________________________________________________________________________<br>
> Professional FreeSWITCH Consulting Services:<br>
> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
><br>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
><br>
> Official FreeSWITCH Sites<br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br>
<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br></div></div>