[Freeswitch-users] lua freeswitch.Dbh sqlite error

Wed Feb 6 17:28:38 MSK 2013

That is a browsable interface to the repository that coincidentally runs on
the same domain name.

The git checkouts are done via the git protocol not http:
http://wiki.freeswitch.org/wiki/Download_%26_Installation_Guide#Recommended:_Git

The advice if the git port is blocked by your firewall/proxy is to checkout
from the github mirror over https:
http://wiki.freeswitch.org/wiki/Git_Tips#Git_https_via_github_and_behind_proxy

-Steve

On 6 February 2013 14:01, Carlo Dimaggio <jaasmailing at gmail.com> wrote:

>  No, if you go to http://git.freeswitch.org/git/freeswitch/, you can
> verify it is possible to connect through http.
>
> I think there is a problem in the server...
>
> Carlo
>
> p.s. I have no outside access to git port.
>
>
> Il 06/02/13 14.40, Steven Ayre ha scritto:
>
> It's git:// not http://
>
>  -Steve
>
>
> On 6 February 2013 13:09, Carlo Dimaggio <jaasmailing at gmail.com> wrote:
>
>>  I'm triying to download the latest git (as I usually do) but I have
>> this error... do you know what could be the problem?
>>
>>
>> <14>:git clone http://git.freeswitch.org/freeswitch.git
>> Initialized empty Git repository in /usr/src/freeswitch/.git/
>> error: The requested URL returned error: 500 while accessing
>> http://git.freeswitch.org/freeswitch.git/info/refs
>>
>> fatal: HTTP request failed
>>
>>
>>
>>
>>
>> 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> 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> 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> 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
>>>> >
>>>> >
>>>> _________________________________________________________________________
>>>> > 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.orghttp://www.freeswitchsolutions.com
>>>
>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>>>
>>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
>>>
>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://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.orghttp://www.freeswitchsolutions.com
>>
>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>>
>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
>>
>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://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.orghttp://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://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/75371fc2/attachment-0001.html 