[Freeswitch-users] lua freeswitch.Dbh sqlite error

Carlo Dimaggio jaasmailing at gmail.com
Wed Feb 6 18:20:27 MSK 2013


Hi Steve,

now the sqlite:/// works:

freeswitch at internal> lua test.lua
-ERR no reply

2013-02-06 16:19:02.169603 [DEBUG] freeswitch_lua.cpp:352 DBH handle 
0x7f1a7406c240 Connected.
2013-02-06 16:19:02.169603 [DEBUG] freeswitch_lua.cpp:370 DBH handle 
(nil) released.


Should you merge into v1.2.stable branch?
I have other production systems in v.1.2 with sqlite.

Best regards


Il 06/02/13 10.40, Steven Ayre ha scritto:
> Hi Carlo,
>
> It was a bug in FS which has been fixed in the master branch (1.3). 
> Try upgrading to verify that fixes your error. At some point that'll 
> trickle down into the v1.2.stable branch too.
>
> -Steve
>
>
>
> On 6 February 2013 08:47, Carlo Dimaggio <jaasmailing at gmail.com 
> <mailto:jaasmailing at gmail.com>> wrote:
>
>     I have the same behaviour.
>     Without prefix it works, while with sqlite:///<file> the error is:
>
>     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
>
>     2013-02-06 09:46:29.169603 [CRIT] switch_core_sqldb.c:504 Failure
>     to connect to PGSQL sqlite!
>     2013-02-06 09:46:29.169603 [ERR] freeswitch_lua.cpp:354 Connection
>     failed.  DBH NOT Connected.
>
>
>     Regards,
>
>     Il 05/02/13 17.42, Steven Ayre ha scritto:
>>
>>         FAIL => "sqlite:///tmp/test.db" (this one should work)
>>
>>
>>     What error does this give?
>>
>>
>>     On 5 February 2013 16:31, François Delawarde
>>     <fdelawarde at wirelessmundi.com
>>     <mailto:fdelawarde at wirelessmundi.com>> wrote:
>>
>>         I'm on HEAD, but I must be doing something wrong, there is no
>>         apparent
>>         reason from the code.
>>
>>         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 at wirelessmundi.com
>>         <mailto:fdelawarde at 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 at wirelessmundi.com
>>         <mailto:fdelawarde at 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 at gmail.com
>>         <mailto:jaasmailing at 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 at freeswitch.org
>>         <mailto:consulting at freeswitch.org>
>>         > >>> http://www.freeswitchsolutions.com
>>         > >>>
>>         > >>>  FreeSWITCH-powered IP PBX: The CudaTel Communication
>>         > >>        Server
>>         > >>> 
>>         > >>>
>>         > >>>        Official FreeSWITCH Sites
>>         > >>> http://www.freeswitch.org
>>         > >>> http://wiki.freeswitch.org
>>         > >>> http://www.cluecon.com
>>         > >>>
>>         > >>>        FreeSWITCH-users mailing list
>>         > >>> FreeSWITCH-users at lists.freeswitch.org
>>         <mailto:FreeSWITCH-users at 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 at freeswitch.org
>>         <mailto:consulting at freeswitch.org>
>>         > >>> http://www.freeswitchsolutions.com
>>         > >>>
>>         > >>> 
>>         > >>> 
>>         > >>>
>>         > >>> Official FreeSWITCH Sites
>>         > >>> http://www.freeswitch.org
>>         > >>> http://wiki.freeswitch.org
>>         > >>> http://www.cluecon.com
>>         > >>>
>>         > >>> FreeSWITCH-users mailing list
>>         > >>> FreeSWITCH-users at lists.freeswitch.org
>>         <mailto:FreeSWITCH-users at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>>         > >> http://www.freeswitchsolutions.com
>>         > >>
>>         > >>        FreeSWITCH-powered IP PBX: The CudaTel
>>         Communication Server
>>         > >> 
>>         > >>
>>         > >>        Official FreeSWITCH Sites
>>         > >> http://www.freeswitch.org
>>         > >> http://wiki.freeswitch.org
>>         > >> http://www.cluecon.com
>>         > >>
>>         > >>        FreeSWITCH-users mailing list
>>         > >> FreeSWITCH-users at lists.freeswitch.org
>>         <mailto:FreeSWITCH-users at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>>         > >> http://www.freeswitchsolutions.com
>>         > >>
>>         > >> 
>>         > >> 
>>         > >>
>>         > >> Official FreeSWITCH Sites
>>         > >> http://www.freeswitch.org
>>         > >> http://wiki.freeswitch.org
>>         > >> http://www.cluecon.com
>>         > >>
>>         > >> FreeSWITCH-users mailing list
>>         > >> FreeSWITCH-users at lists.freeswitch.org
>>         <mailto:FreeSWITCH-users at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>>         > > http://www.freeswitchsolutions.com
>>         > >
>>         > > 
>>         > > 
>>         > >
>>         > > Official FreeSWITCH Sites
>>         > > http://www.freeswitch.org
>>         > > http://wiki.freeswitch.org
>>         > > http://www.cluecon.com
>>         > >
>>         > > FreeSWITCH-users mailing list
>>         > > FreeSWITCH-users at lists.freeswitch.org
>>         <mailto:FreeSWITCH-users at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>>         > http://www.freeswitchsolutions.com
>>         >
>>         > 
>>         > 
>>         >
>>         > Official FreeSWITCH Sites
>>         > http://www.freeswitch.org
>>         > http://wiki.freeswitch.org
>>         > http://www.cluecon.com
>>         >
>>         > FreeSWITCH-users mailing list
>>         > FreeSWITCH-users at lists.freeswitch.org
>>         <mailto:FreeSWITCH-users at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>>         http://www.freeswitchsolutions.com
>>
>>         
>>         
>>
>>         Official FreeSWITCH Sites
>>         http://www.freeswitch.org
>>         http://wiki.freeswitch.org
>>         http://www.cluecon.com
>>
>>         FreeSWITCH-users mailing list
>>         FreeSWITCH-users at lists.freeswitch.org
>>         <mailto:FreeSWITCH-users at 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 at freeswitch.org  <mailto:consulting at freeswitch.org>
>>     http://www.freeswitchsolutions.com
>>
>>     
>>     
>>
>>     Official FreeSWITCH Sites
>>     http://www.freeswitch.org
>>     http://wiki.freeswitch.org
>>     http://www.cluecon.com
>>
>>     FreeSWITCH-users mailing list
>>     FreeSWITCH-users at lists.freeswitch.org  <mailto:FreeSWITCH-users at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>     http://www.freeswitchsolutions.com
>
>     
>     
>
>     Official FreeSWITCH Sites
>     http://www.freeswitch.org
>     http://wiki.freeswitch.org
>     http://www.cluecon.com
>
>     FreeSWITCH-users mailing list
>     FreeSWITCH-users at lists.freeswitch.org
>     <mailto:FreeSWITCH-users at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130206/5650bed9/attachment-0001.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list