[Freeswitch-users] lua freeswitch.Dbh sqlite error

[Steven Ayre]

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