<span style="color:rgb(34,34,34);font-family:Arial;background-color:rgb(255,255,255)">'Failure to connect to PGSQL core' happens</span><span style="background-color:rgb(255,255,255);color:rgb(34,34,34);font-family:Arial"> on ODBC connections, that seems to be a minor bug in the error message.</span><div>
<div><font color="#222222" face="Arial"><br></font></div><div><font color="#222222" face="Arial">From the </font><span style="font-family:Arial">unixODBC error </span><span style="font-family:Arial">it's interpreting this as a ODBC DSN. The reason is the sqlite prefix is sqlite:// not core:// (see </span><font face="Arial"><a href="http://wiki.freeswitch.org/wiki/DSN">http://wiki.freeswitch.org/wiki/DSN</a>). You also don't have enough slashes.</font></div>
<div><font face="Arial"><br></font></div><div><font face="Arial">Try:</font></div><div><span style="font-family:Arial">local dbh = freeswitch.Dbh("sqlite:///usr/</span><span style="font-family:Arial">local/temp/</span><font size="-1" style="font-family:Arial">database.db</font><span style="font-family:Arial">");</span><br style="font-family:Arial">
</div><div><br></div><div>(note the 3 slashes - :// is standard URI format, the 3rd indicates an absolute path).</div><div><br></div><div><span style="font-family:Arial">-Steve</span></div><div><font color="#222222" face="Arial"><br>
</font><div><div><font color="#222222" face="Arial"><br></font></div><div><font color="#222222" face="Arial"><br></font><div class="gmail_quote">On 5 February 2013 08:56, Carlo Dimaggio <span dir="ltr"><<a href="mailto:jaasmailing@gmail.com" target="_blank">jaasmailing@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<font size="-1"><font face="Arial">Hi all!<br>
<br>
<font size="-1"><font face="Arial">I have a lua script in which
i have a statement t<font size="-1"><font face="Arial">hat </font></font>connects
to a sqlite db<font size="-1"><font face="Arial">:<br>
<br>
<font size="-1"><font face="Arial">local dbh =
freeswitch.Dbh("core:/usr/local/temp/<font size="-1"><font face="Arial">database.db</font></font>");<br>
<br>
but i re<font size="-1"><font face="Arial">ceve in
FS CLI this error that refers to a Pgsql<font size="-1"><font face="Arial"> <font size="-1"><font face="Arial">instead of <font size="-1"><font face="Arial">sqlite:</font></font></font></font></font></font></font></font><br>
<font size="-1"><font face="Arial"><font size="-1"><font face="Arial"><font size="-1"><font face="Arial"></font></font></font></font></font></font><br>
</font></font>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<br>
2013-02-05 09:40:10.379612 [CRIT]
switch_core_sqldb.c:504 Failure to connect to PGSQL
core!<br>
2013-02-05 09:40:10.379612 [ERR] freeswitch_lua.cpp:354
Connection failed. DBH NOT Connected.<br>
2013-02-05 09:40:10.379612 [ERR] freeswitch_lua.cpp:435
DBH NOT Connected.<br>
<br>
<br>
<font size="-1"><font face="Arial">Can you h<font size="-1"><font face="Arial">elp me?</font></font></font></font><br>
<br>
<font size="-1"><font face="Arial">Best regards,</font></font><br>
</font></font></font></font></font></font>
</div>
<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></blockquote></div><br></div></div></div></div>