gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Thomas Løcke]

I've run into a bit of an odd issue: gnatcoll_db2ada wont connect
to my PostgreSQL database. All I get are these three files:

http://pastebin.com/JHP2cL8Y

Now the funny thing is that I get the above output no matter what
options I use to invoke gnatcoll_db2ada, and I'm not seeing a single
error in my PostgreSQL log. Also the gnatcoll_db2ada tool does not
throw any errors, even if I feed it bad host/username/password
combinations. It simply runs and creates the three pastebinned files
linked above.

Connecting to the database using psql works without issue, so it's not
a matter of permissions or network connectivity.

I've compiled gnatcoll-gpl-2010 with these settings:

./configure --prefix=/usr/gnat \
             --disable-gtk \
             --disable-pygtk \
             --without-python \
             --with-postgresql \
             --without-sqlite \
             --disable-syslog

PROCESSORS=8 make
make install

The entire compile/make/make install process finished without errors.

ldd'ing the gnatcoll_db2ada executable returns this:

http://pastebin.com/CUiPB2yV

It all appears to be fine, and when doing a strace, I can see that all
files are available on the system.

No matter what I do, I simply cannot make it work, so if somebody out
there is using gnatcoll-gpl-2010 to connect to PostgreSQL, please let
me know what magic you've used to make gnatcoll_db2ada work. Hopefully
this is a simple matter of me missing some minor detail.

-- 
Regards,
Thomas L�cke

Email: tl at ada-dk.org
Web: http:ada-dk.org
IRC nick: ThomasLocke

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Emmanuel Briot]

On Dec 1, 6:14 pm, Thomas Løcke <t...@ada-dk.org> wrote:
> I've run into a bit of an odd issue: gnatcoll_db2ada wont connect
> to my PostgreSQL database. All I get are these three files:

Without looking in details at your code, I will guess your server does
not accept SSL connections.
The version of GNATCOLL you are using forces that (looking for
requiressl=...) in the sources.
More recent development versions give you control over this.

regards
Emmanuel

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Thomas Løcke]

On 2010-12-01 21:51, Emmanuel Briot wrote:
> Without looking in details at your code, I will guess your server does
> not accept SSL connections.
> The version of GNATCOLL you are using forces that (looking for
> requiressl=...) in the sources.
> More recent development versions give you control over this.


Hello Emmanuel,

You are right: The server does not accept SSL connections.

Is there a way to disable this behavior in gnatcoll-gpl-2010?

And I wonder why this is not documented anywhere. It sure would've
saved me a great deal of pain. I've recompiled gnatcoll-gpl-2010
so many times it's almost scary.  :o)

-- 
Regards,
Thomas L�cke

Email: tl at ada-dk.org
Web: http:ada-dk.org
IRC nick: ThomasLocke

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Emmanuel Briot]

> Is there a way to disable this behavior in gnatcoll-gpl-2010?

Sure, I pointed to "requiressl=..." in the sources. Just grep for this
and remove.

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Thomas Løcke]

On 2010-12-02 10:09, Emmanuel Briot wrote:
> Sure, I pointed to "requiressl=..." in the sources. Just grep for this
> and remove.
>

Success! My gnatcoll_db2ada tool can once again connect to my PostgreSQL
server.

Thanks.

Are you aware of any plans to "fix" this in the latest official package
or perhaps add it to the documentation?

-- 
Regards,
Thomas L�cke

Email: tl at ada-dk.org
Web: http:ada-dk.org
IRC nick: ThomasLocke

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Emmanuel Briot]

> Are you aware of any plans to "fix" this in the latest official package
> or perhaps add it to the documentation?

As I mentioned in my initial reply, this has been enhanced in the
development version already.

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Thomas Løcke]

On 2010-12-02 13:46, Emmanuel Briot wrote:
>> Are you aware of any plans to "fix" this in the latest official package
>> or perhaps add it to the documentation?
>
> As I mentioned in my initial reply, this has been enhanced in the
> development version already.


I understood what you said Emmanuel, but what I wanted to know was
whether the latest _official_ GNATcoll package, that can be downloaded
from http://libre.adacore.com/libre/download2# would have this minor
annoyance fixed, or perhaps at least have the solution added to the
README file.

As it stands now, you go download it, compile it, and watch it fail at
connecting to your PostgreSQL database, for no apparent reason. Hardly
an optimal situation for what is a publically available official version
of a software.

The development version is not for the faint of heart. I grabbed it from
svn yesterday, and it wouldn't even compile.

-- 
Regards,
Thomas L�cke

Email: tl at ada-dk.org
Web: http:ada-dk.org
IRC nick: ThomasLocke

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Emmanuel Briot]

We do not give estimates for the dates of public releases (and I do
not work on those releases anyway, so wouldn't know the date anyway).

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Stephen Leake]

Emmanuel Briot <briot.emmanuel@gmail.com> writes:

> We do not give estimates for the dates of public releases (and I do
> not work on those releases anyway, so wouldn't know the date anyway).\

He's asking if there will be an update to the current release. For
example, Debian periodically releases updates to Debian 5.0.

The answer is "no" - AdaCore doesn't do that.

-- 
-- Stephe

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Thomas Løcke]

On 2010-12-03 09:22, Stephen Leake wrote:
> He's asking if there will be an update to the current release. For
> example, Debian periodically releases updates to Debian 5.0.


Exactly!


> The answer is "no" - AdaCore doesn't do that.


How odd and sad.

But at least I now know what to expect. Thanks.  :o)


-- 
Regards,
Thomas L�cke

Email: tl at ada-dk.org
Web: http:ada-dk.org
IRC nick: ThomasLocke

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Ludovic Brenta]

Thomas Løcke wrote:
> On 2010-12-03 09:22, Stephen Leake wrote:
>
>> He's asking if there will be an update to the current release. For
>> example, Debian periodically releases updates to Debian 5.0.
>
> Exactly!
>
> > The answer is "no" - AdaCore doesn't do that.
>
> How odd and sad.
>
> But at least I now know what to expect. Thanks.  :o)

You can still backport the fix from Subversion to the GNAT GPL 2010
sources.  This might prove easier than rebuilding the new version from
sratch.

--
Ludovic Brenta.

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Ludovic Brenta]

Ludovic Brenta wrote on comp.lang.ada:
> You can still backport the fix from Subversion to the GNAT GPL 2010
> sources.  This might prove easier than rebuilding the new version from
> sratch.

Here is the patch, see if it applies cleanly to your copy of gnatcoll:

http://green.ada-france.org:8081/revision/diff/802c06af2009cae943bdfe454a3880943cc44a23/with/1fcff7daad1d1cbe240da1d8dd1d18e28559f1a9

--
Ludovic Brenta.

Re: gnatcoll-gpl-2010: Problem with gnatcoll_db2ada

[Thomas Løcke]

On 2010-12-06 11:55, Ludovic Brenta wrote:
> Ludovic Brenta wrote on comp.lang.ada:
>> You can still backport the fix from Subversion to the GNAT GPL 2010
>> sources.  This might prove easier than rebuilding the new version from
>> sratch.
>
> Here is the patch, see if it applies cleanly to your copy of gnatcoll:
>
> http://green.ada-france.org:8081/revision/diff/802c06af2009cae943bdfe454a3880943cc44a23/with/1fcff7daad1d1cbe240da1d8dd1d18e28559f1a9


I'm a bit late on this one, but thanks Ludovic. The changes aren't very
substantial, so I'm sure the patch will work.

-- 
Regards,
Thomas L�cke

Email: tl at ada-dk.org
Web: http:ada-dk.org
IRC nick: ThomasLocke