<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">I have the same behaviour.<br>
Without prefix it works, while with sqlite:///<file> the
error is: <br>
<br>
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<br>
<br>
2013-02-06 09:46:29.169603 [CRIT] switch_core_sqldb.c:504 Failure
to connect to PGSQL sqlite!<br>
2013-02-06 09:46:29.169603 [ERR] freeswitch_lua.cpp:354 Connection
failed. DBH NOT Connected.<br>
<br>
<br>
Regards,<br>
<br>
Il 05/02/13 17.42, Steven Ayre ha scritto:<br>
</div>
<blockquote
cite="mid:CAFiqYuknaky1PwiQ4d1cENijO1x+j1ww-xTO8a6bWM-8F3-5Yw@mail.gmail.com"
type="cite">
<div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">FAIL
=> "sqlite:///tmp/test.db" (this one should work)</span></blockquote>
<div><br>
</div>
What error does this give?</div>
<div><br>
</div>
<div><br>
<div class="gmail_quote">On 5 February 2013 16:31, François
Delawarde <span dir="ltr"><<a moz-do-not-send="true"
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">I'm on
HEAD, but I must be doing something wrong, there is no
apparent<br>
reason from the code.<br>
<div class="HOEnZb">
<div class="h5"><br>
On Tue, 2013-02-05 at 16:05 +0000, Steven Ayre wrote:<br>
> Honestly, I only use ODBC... Maybe someone else can
shed some light?<br>
><br>
> What version are you using?<br>
><br>
> Steve<br>
><br>
><br>
><br>
> On 5 Feb 2013, at 15:42, François Delawarde <<a
moz-do-not-send="true"
href="mailto:fdelawarde@wirelessmundi.com">fdelawarde@wirelessmundi.com</a>>
wrote:<br>
><br>
> > Steven, does "sqlite://" prefix work for you?
Not sure if it's a bug or<br>
> > I'm doing something wrong. I tried the
following from lua dbh:<br>
> ><br>
> > FAIL => "sqlite:///tmp/test.db" (this one
should work)<br>
> > FAIL => "sqlite://tmp/test.db" (shouldn't
work, but just in case...)<br>
> > OK => "/tmp/test.db" (no prefix)<br>
> ><br>
> > François.<br>
> ><br>
> ><br>
> > On Tue, 2013-02-05 at 12:55 +0000, Steven Ayre
wrote:<br>
> >> core: was an old prefix? I knew that
change broke some ODBC DSNs<br>
> >> (names without username+password, eg when
they're specified in<br>
> >> odbc.ini) but hadn't realised that had
been broken too - that needs<br>
> >> documenting as well on the Wiki I guess...<br>
> >> <a moz-do-not-send="true"
href="http://wiki.freeswitch.org/wiki/Release_Notes#odbc-dsn"
target="_blank">http://wiki.freeswitch.org/wiki/Release_Notes#odbc-dsn</a><br>
> >><br>
> >><br>
> >> Just a thought for the developers, but
perhaps modules with odbc-dsn<br>
> >> parameters should have this renamed to dsn
or something now since it's<br>
> >> not odbc-specific at all any longer. Easy
enough to recognise both<br>
> >> 'dsn' and 'odbc-dsn' names to remain
backwards compatible (which I've<br>
> >> seen done with typos in config setting
names in the past<br>
> >> as precedent).<br>
> >><br>
> >><br>
> >> -Steve<br>
> >><br>
> >><br>
> >><br>
> >><br>
> >> On 5 February 2013 11:03, François
Delawarde<br>
> >> <<a moz-do-not-send="true"
href="mailto:fdelawarde@wirelessmundi.com">fdelawarde@wirelessmundi.com</a>>
wrote:<br>
> >> The behavior recently changed from
"core:<path>" to<br>
> >> "sqlite://<path>".<br>
> >><br>
> >> Update: I just tested and it seems
that "sqlite://<path>"<br>
> >> doesn't work,<br>
> >> but as sqlite is the default, you
can just omit the prefix and<br>
> >> use<br>
> >> "<path>" to make it work.<br>
> >><br>
> >> François.<br>
> >><br>
> >><br>
> >> On Tue, 2013-02-05 at 10:37 +0000,
Steven Ayre wrote:<br>
> >>> 'Failure to connect to PGSQL core'
happens on ODBC<br>
> >> 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<br>
> >> DSN. The<br>
> >>> reason is the sqlite prefix is
sqlite:// not core://<br>
> >>> (see <a moz-do-not-send="true"
href="http://wiki.freeswitch.org/wiki/DSN"
target="_blank">http://wiki.freeswitch.org/wiki/DSN</a>).
You also don't<br>
> >> have enough<br>
> >>> slashes.<br>
> >>><br>
> >>><br>
> >>> Try:<br>
> >>> local dbh =<br>
> >>
freeswitch.Dbh("sqlite:///usr/local/temp/database.db");<br>
> >>><br>
> >>><br>
> >>><br>
> >>> (note the 3 slashes - :// is standard
URI format, the 3rd<br>
> >> indicates an<br>
> >>> absolute path).<br>
> >>><br>
> >>><br>
> >>> -Steve<br>
> >>><br>
> >>><br>
> >>><br>
> >>><br>
> >>> On 5 February 2013 08:56, Carlo
Dimaggio<br>
> >> <<a moz-do-not-send="true"
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<br>
> >> 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<br>
> >> Pgsql<br>
> >>> instead of sqlite:<br>
> >>><br>
> >>> 2013-02-05 09:40:10.379612
[ERR] switch_odbc.c:365<br>
> >> STATE:<br>
> >>> IM002 CODE 0 ERROR:
[unixODBC][Driver Manager]Data<br>
> >> source name<br>
> >>> not found, and no default
driver specified<br>
> >>> 2013-02-05 09:40:10.379612
[CRIT]<br>
> >> switch_core_sqldb.c:504<br>
> >>> Failure to connect to PGSQL
core!<br>
> >>> 2013-02-05 09:40:10.379612
[ERR]<br>
> >> freeswitch_lua.cpp:354<br>
> >>> Connection failed. DBH NOT
Connected.<br>
> >>> 2013-02-05 09:40:10.379612
[ERR]<br>
> >> freeswitch_lua.cpp:435 DBH<br>
> >>> NOT Connected.<br>
> >>><br>
> >>><br>
> >>> Can you help me?<br>
> >>><br>
> >>> Best regards,<br>
> >>
_________________________________________________________________________<br>
> >>> Professional FreeSWITCH
Consulting Services:<br>
> >>> <a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> >>> <a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
> >>><br>
> >>> FreeSWITCH-powered IP PBX: The
CudaTel Communication<br>
> >> Server<br>
> >>> <a moz-do-not-send="true"
href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
> >>><br>
> >>> Official FreeSWITCH Sites<br>
> >>> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> >>> <a moz-do-not-send="true"
href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> >>> <a moz-do-not-send="true"
href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
> >>><br>
> >>> FreeSWITCH-users mailing list<br>
> >>> <a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> >> UNSUBSCRIBE:<a
moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> >>> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> >>
_________________________________________________________________________<br>
> >>> Professional FreeSWITCH Consulting
Services:<br>
> >>> <a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> >>> <a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
> >>><br>
> >>> FreeSWITCH-powered IP PBX: The CudaTel
Communication Server<br>
> >>> <a moz-do-not-send="true"
href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
> >>><br>
> >>> Official FreeSWITCH Sites<br>
> >>> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> >>> <a moz-do-not-send="true"
href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> >>> <a moz-do-not-send="true"
href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
> >>><br>
> >>> FreeSWITCH-users mailing list<br>
> >>> <a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> >> UNSUBSCRIBE:<a
moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> >>> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> >><br>
> >><br>
> >><br>
> >>
_________________________________________________________________________<br>
> >> Professional FreeSWITCH Consulting
Services:<br>
> >> <a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
> >><br>
> >> FreeSWITCH-powered IP PBX: The
CudaTel Communication Server<br>
> >> <a moz-do-not-send="true"
href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
> >><br>
> >> Official FreeSWITCH Sites<br>
> >> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
> >><br>
> >> FreeSWITCH-users mailing list<br>
> >> <a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> >> UNSUBSCRIBE:<a
moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> >> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> >><br>
> >><br>
> >><br>
> >>
_________________________________________________________________________<br>
> >> Professional FreeSWITCH Consulting
Services:<br>
> >> <a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
> >><br>
> >> FreeSWITCH-powered IP PBX: The CudaTel
Communication Server<br>
> >> <a moz-do-not-send="true"
href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
> >><br>
> >> Official FreeSWITCH Sites<br>
> >> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
> >><br>
> >> FreeSWITCH-users mailing list<br>
> >> <a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> >> <a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> >> UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> >> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> ><br>
> ><br>
> ><br>
> >
_________________________________________________________________________<br>
> > Professional FreeSWITCH Consulting Services:<br>
> > <a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> > <a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
> ><br>
> > FreeSWITCH-powered IP PBX: The CudaTel
Communication Server<br>
> > <a moz-do-not-send="true"
href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
> ><br>
> > Official FreeSWITCH Sites<br>
> > <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> > <a moz-do-not-send="true"
href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> > <a moz-do-not-send="true"
href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
> ><br>
> > FreeSWITCH-users mailing list<br>
> > <a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> > <a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> > UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> > <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
>
_________________________________________________________________________<br>
> Professional FreeSWITCH Consulting Services:<br>
> <a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> <a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
><br>
> FreeSWITCH-powered IP PBX: The CudaTel
Communication Server<br>
> <a moz-do-not-send="true"
href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
><br>
> Official FreeSWITCH Sites<br>
> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> <a moz-do-not-send="true"
href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> <a moz-do-not-send="true"
href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
><br>
> FreeSWITCH-users mailing list<br>
> <a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br>
<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication
Server<br>
<a moz-do-not-send="true" href="http://www.cudatel.com"
target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a moz-do-not-send="true" href="http://www.cluecon.com"
target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a class="moz-txt-link-freetext" href="http://www.cudatel.com">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
</body>
</html>