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
> >>>
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.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