Thread: 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@hoho2 pgadmin3-1.8.0-beta5]# cat /proc/version
Linux version 2.6.22.9-91.fc7
(kojibuilder@xenbuilder1.fedora.redhat.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@hoho2 pgadmin3-1.8.0-beta5]# rpm -q postgresql
   postgresql-8.2.4-1.fc7

I have downloaded the Fedora packages:

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

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

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

   [root@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@hoho2 ~]$ pgadmin3

(pgadmin3:18566): Gtk-CRITICAL **: gtk_window_realize_icon: assertion
`info->icon_pixmap == NULL' failed
[user1@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@postgresql.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@hoho2 ~]$ pgadmin3
> >
> > (pgadmin3:18566): Gtk-CRITICAL **: gtk_window_realize_icon: assertion
> > `info->icon_pixmap == NULL' failed
> > [user1@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.