pgadmin3 on Fedora7 - can't run standard binary, can't compile from source..
Bob Gustafson
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
(kojib...@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?
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Devrim GÜNDÜZ
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/
Bob Gustafson
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,
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Devrim GÜNDÜZ
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?
Bob Gustafson
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,
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
Bob Gustafson
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...@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.