Re: pgadmin3 on Fedora7 - can't run standard binary, can't compile from source..

I am running Fedora7

I cannot run the stock binary installation of pgAdmin3,
see:

https://bugzilla.redhat.com/show_bug.cgi?id=319851
pgAdmin3 unable to run. Has relocation error - bad library

----------------------------------------------------------
In an effort to get around this problem, I tried to compile my own
version of pgadmin3 - but ran into problems:

[root(at)hoho2 pgadmin3-1.8.0-beta5]# cat /proc/version
Linux version 2.6.22.9-91.fc7
(kojibuilder(at)xenbuilder1(dot)fedora(dot)redhat(dot)com) (gcc version 4.1.2 20070502
(Red Hat 4.1.2-12)) #1 SMP Thu Sep 27 23:10:59 EDT 2007

In addition to the Postgresql binaries that I have been using
successfully on this machine,

[root(at)hoho2 pgadmin3-1.8.0-beta5]# rpm -q postgresql
postgresql-8.2.4-1.fc7

I have downloaded the Fedora packages:

[root(at)hoho2 pgadmin3-1.8.0-beta5]# rpm -q postgresql-devel
postgresql-devel-8.2.4-1.fc7

[root(at)hoho2 pgadmin3-1.8.0-beta5]# rpm -q wxGTK
wxGTK-2.8.4-3.fc7

[root(at)hoho2 pgadmin3-1.8.0-beta5]# rpm -q wxGTK-devel
wxGTK-devel-2.8.4-3.fc7

[root(at)hoho2 pgadmin3-1.8.0-beta5]# rpm -q wxGTK-gl
wxGTK-gl-2.8.4-3.fc7

With pgadmin3-1.8.0-beta5, I went through the steps:
./configure
make

And encountered the error:

if g++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include -DSSL
-I/usr/lib/wx/include/gtk2-unicode-release-2.8 -I/usr/include/wx-2.8
-D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D__WXGTK__ -O2 -DEMBED_XRC
-I/usr/include/libxml2 -I/usr/include/libxml2 -DDATA_DIR=
\"/usr/local/pgadmin3/share/pgadmin3/\" -Wall -Wno-non-virtual-dtor
-fno-strict-aliasing -I../pgadmin/include -MT dlgProperty.o -MD -MP
-MF ".deps/dlgProperty.Tpo" -c -o dlgProperty.o `test -f
'./dlg/dlgProperty.cpp' || echo './'`./dlg/dlgProperty.cpp; \
then mv -f ".deps/dlgProperty.Tpo" ".deps/dlgProperty.Po"; else
rm -f ".deps/dlgProperty.Tpo"; exit 1; fi
./dlg/dlgProperty.cpp: In constructor
‘dlgProperty::dlgProperty(pgaFactory*, frmMain*, const wxString&)’:
./dlg/dlgProperty.cpp:97: error: conversion from ‘int’ to ‘const
wxTreeItemId’ is ambiguous
/usr/include/wx-2.8/wx/treebase.h:75: note: candidates are:
wxTreeItemId::wxTreeItemId(long int)
/usr/include/wx-2.8/wx/treebase.h:59: note:
wxTreeItemId::wxTreeItemId(void*)
./dlg/dlgProperty.cpp:98: error: conversion from ‘int’ to ‘const
wxTreeItemId’ is ambiguous
/usr/include/wx-2.8/wx/treebase.h:75: note: candidates are:
wxTreeItemId::wxTreeItemId(long int)
/usr/include/wx-2.8/wx/treebase.h:59: note:
wxTreeItemId::wxTreeItemId(void*)
make[2]: *** [dlgProperty.o] Error 1
make[2]: Leaving directory
`/usr/local/src/pgadmin/pgadmin3-1.8.0-beta5/pgadmin'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/pgadmin/pgadmin3-1.8.0-beta5'
make: *** [all] Error 2

-------

What should I do next?

Hi,

On Sun, 2007-10-07 at 14:24 -0500, Bob Gustafson wrote:
> And encountered the error:
<snip>

Dave, it looks like the error I reported to pgadmin-hackers list...

Cheers,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

Maybe so, But, I fixed it.

See - https://bugzilla.redhat.com/show_bug.cgi?id=319851

Bob G

On Sun, 2007-10-07 at 13:29 -0700, Devrim GÜNDÜZ wrote:
> Hi,
>
> On Sun, 2007-10-07 at 14:24 -0500, Bob Gustafson wrote:
> > And encountered the error:
> <snip>
>
> Dave, it looks like the error I reported to pgadmin-hackers list...
>
> Cheers,

Hi,

On Sun, 2007-10-07 at 16:11 -0500, Bob Gustafson wrote:
> Maybe so, But, I fixed it.
>
> See - https://bugzilla.redhat.com/show_bug.cgi?id=319851

Cool. I cannot test this patch now -- Dave, maybe you'd like to apply it
to 1.8 tree?

Cheers,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

Some more bugs:

1) The pgAdmin window can be changed in size (mouse drag), but none of
the interior panes have that property.

I have (2) big screens, it would be helpful to be able to see (all of)
each pane.

2) When I chose 'exit' from the pgAdmin3 menu, I get the following:

[user1(at)hoho2 ~]$ pgadmin3

(pgadmin3:18566): Gtk-CRITICAL **: gtk_window_realize_icon: assertion
`info->icon_pixmap == NULL' failed
[user1(at)hoho2 ~]$

Seems like the Gtk memory allocation and deallocation needs another
look.

Best regards

Bob G

On Sun, 2007-10-07 at 14:49 -0700, Devrim GÜNDÜZ wrote:
> Hi,
>
> On Sun, 2007-10-07 at 16:11 -0500, Bob Gustafson wrote:
> > Maybe so, But, I fixed it.
> >
> > See - https://bugzilla.redhat.com/show_bug.cgi?id=319851
>
> Cool. I cannot test this patch now -- Dave, maybe you'd like to apply it
> to 1.8 tree?
>
> Cheers,

Strange, grabbing the spacer bar definitely does not work for me. The
cursor remains looking like an arrow as I pass over the spacer bars,
with the exception that it changes to an I beam in the SQL pane.

-------

The compile bug I fixed was probably due to differences in gcc compiler
versions. I am running: gcc (GCC) 4.1.2 20070925 (Red Hat 4.1.2-27)

--------

But the incompatible library bug (finessed by downloading and building
from new source), is just a lack of testing by someone in the pgadmin ->
Fedora chain.

Bob G

On Mon, 2007-10-08 at 10:55 +0100, Dave Page wrote:
> [Bob - please report any pgAdmin issues to
> pgadmin-support(at)postgresql(dot)org in future. pgsql-ports is essentially
> dead as far as I'm aware (and is for PostgreSQL, not pgAdmin), and I
> certainly don't follow the downstream bug trackers]
>
> Bob Gustafson wrote:
> > Some more bugs:
> >
> > 1) The pgAdmin window can be changed in size (mouse drag), but none of
> > the interior panes have that property.
> >
> > I have (2) big screens, it would be helpful to be able to see (all of)
> > each pane.
>
> You can grab the spacer bar between the panes to resize them. That's
> been the case since the first release of pgAdmin II 6 or 7 years ago,
> and still works fine as far as I can see (it certainly does on F7 on
> which I just tested it).
>
> > 2) When I chose 'exit' from the pgAdmin3 menu, I get the following:
> >
> > [user1(at)hoho2 ~]$ pgadmin3
> >
> > (pgadmin3:18566): Gtk-CRITICAL **: gtk_window_realize_icon: assertion
> > `info->icon_pixmap == NULL' failed
> > [user1(at)hoho2 ~]$
> >
> > Seems like the Gtk memory allocation and deallocation needs another
> > look.
>
> Yeah, they are wxWidgets/GTK buglets. pgAdmin doesn't touch GTK directly.
>
> Regards, Dave.

Bob Gustafson wrote:
> Strange, grabbing the spacer bar definitely does not work for me. The
> cursor remains looking like an arrow as I pass over the spacer bars,
> with the exception that it changes to an I beam in the SQL pane.

Perhaps something in your chosen theme? The window layout is handled (in
1.6 and above) by the wxAUI library, whose whole entire purpose in life
is to give a flexible interface.

>
> The compile bug I fixed was probably due to differences in gcc compiler
> versions. I am running: gcc (GCC) 4.1.2 20070925 (Red Hat 4.1.2-27)

Ah, sounds reasonable.

> But the incompatible library bug (finessed by downloading and building
> from new source), is just a lack of testing by someone in the pgadmin ->
> Fedora chain.

Yeah - I'm not sure who is doing that these days. Devrim had said that
he wasn't doing them for Fedora any more as someone else had taken over
iirc.

Regards, Dave