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