pgadmin3 does not start on Maverick Meerkat

[Chiel]

Binary package hint: pgadmin3

When starting from the terminal i get the following error:
pgadmin3: relocation error: pgadmin3: symbol _ZN21wxMemoryFSHandlerBase19AddFileWithMimeTypeERK8wxStringPKvjS2_, version WXU_2.8 not defined in file libwx_baseu-2.8.so.0 with link time reference

Google finds: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=544620
which seems to be about a year old.

[Kai Mast (kai-mast)]

pgadmin3 needs a rebuild with the new wxWidgets packages (2.8.11 i think) that came into maverick.

[David Sugar (dyfet-deactivatedaccount)]

When you have a strange or "mangled" symbol name like _ZN21..., you can (assuming c++) use c++filt to convert it back to something more human parsable:

c++filt
relocation error: pgadmin3: symbol _ZN21wxMemoryFSHandlerBase19AddFileWithMimeTypeERK8wxStringPKvjS2_, version WXU_2.8 not defined in file libwx_baseu-2.8.so.0 with link time reference
relocation error: pgadmin3: symbol wxMemoryFSHandlerBase::AddFileWithMimeType(wxString const&, void const*, unsigned int, wxString const&), version WXU_2.8 not defined in file libwx_baseu-2.8.so.0 with link time referenc

[meux (reinhard-moser)]

Hi there,

  i get this error on ubuntu lucid since today. Till now pgadmin3 worked like a charme. I'm not sure i changed something since yesterday.

pgadmin3: relocation error: pgadmin3: symbol _ZN21wxMemoryFSHandlerBase19AddFileWithMimeTypeERK8wxStringPKvjS2_, version WXU_2.8 not defined in file libwx_baseu-2.8.so.0 with link time reference

ii libwxbase2.8-0 2.8.10.1-0ubuntu1.1 wxBase library (runtime) - non-GUI support c
ii libwxgtk2.8-0 2.8.10.1-0ubuntu1.1 wxWidgets Cross-platform C++ GUI toolkit (GT
ii pgadmin3 1.10.2-1 graphical administration tool for PostgreSQL
ii pgadmin3-data 1.10.2-1 graphical administration tool for PostgreSQL

[meux (reinhard-moser)]

A recompile and install solved problem for me:

apt-get source pgadmin3
dpkg-buildpackage
sudo dpkg -i pgadmin3_1.10.2-1_i386.deb

and pgadmin3 works again.

Cheers

[Abel.Bolanos (abel-bolanos)]

But it still has the same problem and it doesn't start.

[Garrett Blits (garrett)]

Having the same issue:

pgadmin3: relocation error: pgadmin3: symbol _ZN21wxMemoryFSHandlerBase19AddFileWithMimeTypeERK8wxStringPKvjS2_, version WXU_2.8 not defined in file libwx_baseu-2.8.so.0 with link time reference

...fix suggested by meux did not work for me.

[Garrett Blits (garrett)]

After my initial post I found a solution that worked for me and appears to be working for others as well. Look at comments #9 and #11

https://bugs.launchpad.net/ubuntu/+source/pgadmin3/+bug/610975

[Evgeniy Kirov (evg.kirov)]

Same bug in Lucid.

[Yuval (yuvilio)]

The dpkg-buildpackage instructions worked for me as well. Two additional things to note for us non-build-masters in training:

- To make sure I had all the packages to build pgadmin per the dpkg-buildpackage instructions above i ran this command which should be more catchall than guessing which packages are needed to build it:

sudo apt-get build-dep pgadmin3

-your resulting pgadmin package(s) may be different. Simply list them first and then run the dpkg -i command:

ls ../pgadmin*deb

[Kai Mast (kai-mast)]

Importing the Packages form debian-sid would be the best. They include the new upstream release (1.10.5) and work fine on maverick for me.

http://packages.debian.org/sid/pgadmin3

[Christoph Seitz (seitz-christoph)]

When will someone compile the package again and link it against the correct libwx?
This Bug also affected me on lucid.

[Bastiaan Wakkie (bwakkie)]

#4 worked for me (lucid) too! It can be slightly shorter though with the --compile option of apt-get:

sudo apt-get --compile source pgadmin3
sudo dpkg -i pgadmin3_1.10.2-1_i386.deb

after this got my favorite db GUI back ;-)

[deric (barton-tomas)]

after installing version from debian: pgadmin3-data (1.10.5-1) and pgadmin3 (1.10.5-1) everything works fine

[kongo09 (kongo09)]

I have the same problem on AMD Lucid Lynx. As described across the posts above, I did:

sudo apt-get remove pgadmin3
sudo apt-get build-dep pgadmin3
sudo apt-get --compile source pgadmin3
ls pgadmin*deb
sudo dpkg -i pgadmin3_1.10.2_1_i386.deb

That brought it back, including old server settings.

[merlin (vitaliic)]

Thanks kongo09 !!! It's work for me.

[Victor Pelagatti (vpelagatti)]

Thanks kongo09, works for me too on Ubuntu Lucid!

[mguerra (mguerra13)]

Another solution is to downgrade libwxbase.

- Go to Synaptic
- Search and select (click) on package libwxbase2.8-0
- Go to "Packages", "Force Version", and choose 2.8.10.1-0ubuntu1

It worked in Ubuntu 10.04.
This solution is easy and doesn't touch pgAdmin.
This solution is temporary until and upgrade of pgAdmin appears in the official repositories.