[Freeswitch-users] lua freeswitch.Dbh sqlite error
Carlo Dimaggio
jaasmailing at gmail.com
Wed Feb 6 17:01:23 MSK 2013
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
> <mailto: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
>> <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
>>> > >>>
>>> > >>> 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
>>> > >>
>>> > >> 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
>>> > >>
>>> > >> 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
>>> > >
>>> > > 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
>>> >
>>> > 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
> 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/b3a672b1/attachment-0001.html
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users
mailing list