Bugzilla Bug 108387

kpogre 1.3.5 fails to compile. 

Reproducible: Always
Steps to Reproduce:
1. emerge kpogre 
2. 
3. 
 
Actual Results:  
/bin/sh ../libtool --silent --mode=link --tag=CXX i686-pc-linux-gnu-g++  
-Wnon-virtual-dtor -Wno-long-long -Wundef -ansi -D_XOPEN_SOURCE=500 
-D_BSD_SOURCE -Wcast-align -Wconversion -Wchar-subscripts -Wall -W 
-Wpointer-arith -Wwrite-strings -DNDEBUG -DNO_DEBUG -O2 -O3 -march=i686 -msse 
-mmmx -mfpmath=sse -fomit-frame-pointer -funroll-loops -pipe -Wformat-security 
-Wmissing-format-attribute -fno-exceptions -fno-check-new -fno-common 
-fexceptions -I/usr/include -I/usr/include    -o kpogre -L/usr/kde/3.4/lib 
-L/usr/qt/3/lib -L/usr/lib -Wl,--as-needed -Wl,--enable-new-dtags 
-R /usr/kde/3.4/lib -R /usr/qt/3/lib -R /usr/lib kpgbookmarksbutton.o 
kpgbookmarkhandler.o kpgconfiguration.o kpgsqleditorsettings.o kpgsettings.o 
kpgsqlquerresultwindow.o kpgsyntaxhighlighter.o kpgconnectdialog.o 
kpogreview.o kpogredoc.o kpogre.o main.o kpgbookmarkmenu.o kpgsqldialog.o 
kpgsearchdialog.o kpglinklabel.o kpogrecomboaction.o kpgdcoptalkthread.o 
kpgconnectioninthread.o kpgaclitem.o kpggeneralsettings.o 
kpgsqleditorsettingspage.o kpgconnectdialogbase.o kpgsqldialogbase.o 
kpgsqlqueryresultwindowbase.o kpgsearchdialogbase.o kpggeneralsettingspage.o 
kpogredoc.moc.o kpgsqlquerresultwindow.moc.o kpogreview.moc.o 
kpgbookmarkhandler.moc.o kpgsettings.moc.o kpgconnectdialog.moc.o 
kpgbookmarksbutton.moc.o kpgconfiguration.moc.o 
kpogre.moc.o  ./DbObjects/libDbObjects.la ./PropertyPages/libPropertyPages.la ./Wizards/libWizards.la 
-L/usr/lib -lpqxx -L/usr/lib -lpq -lkio -lkdeui -lkdecore -lqt-mt  -lz -lpng 
-lz -lm -lXext -lX11  -lSM -lICE -lpthread 
./DbObjects/.libs/libDbObjects.a(kpgconnection.o): In function 
`pqxx::connection::startconnect()': 
kpgconnection.cpp:(.gnu.linkonce.t._ZN4pqxx10connection12startconnectEv+0x17): 
undefined reference to `pqxx::connection::do_startconnect()' 
collect2: ld returned 1 exit status 

Expected Results:

Please post your 'emerge info'. 
 

I get the same error. emerge info output is: 
 
Portage 2.0.53_rc4 (default-linux/x86/2005.1, gcc-3.4.4, glibc-2.3.5-r2, 
2.6.13.2 i686) 
================================================================= 
System uname: 2.6.13.2 i686 Intel(R) Pentium(R) M processor 1500MHz 
Gentoo Base System version 1.12.0_pre8 
distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632) 
[disabled] 
dev-lang/python:     2.3.5, 2.4.2 
sys-apps/sandbox:    1.2.13 
sys-devel/autoconf:  2.13, 2.59-r7 
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1 
sys-devel/binutils:  2.16.1 
sys-devel/libtool:   1.5.20 
virtual/os-headers:  2.6.11-r2 
ACCEPT_KEYWORDS="x86 ~x86" 
AUTOCLEAN="yes" 
CBUILD="i686-pc-linux-gnu" 
CFLAGS="-O3 -march=pentium4 -fomit-frame-pointer -pipe" 
CHOST="i686-pc-linux-gnu" 
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3/share/config /usr/lib/X11/xkb /usr/share/config /var/qmail/control" 
CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/texmf/web2c /etc/env.d" 
CXXFLAGS="-O3 -march=pentium4 -fomit-frame-pointer -pipe" 
DISTDIR="/gentoo/distfiles" 
FEATURES="autoconfig distlocks sandbox sfperms strict" 
GENTOO_MIRRORS="http://mirrors.sec.informatik.tu-darmstadt.de/gentoo/ 
http://ftp.easynet.nl/mirror/gentoo/ 
http://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/ 
ftp://mirror.switch.ch/mirror/gentoo/ 
ftp://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/ 
ftp://mirrors.sec.informatik.tu-darmstadt.de/gentoo/ 
http://ftp.easynet.nl/mirror/gentoo/ 
http://ftp.snt.utwente.nl/pub/os/linux/gentoo 
http://ftp.uni-erlangen.de/pub/mirrors/gentoo http://gentoo.osuosl.org" 
LINGUAS="de" 
PKGDIR="/usr/portage/packages" 
PORTAGE_TMPDIR="/gentoo/build" 
PORTDIR="/gentoo/portage" 
PORTDIR_OVERLAY="/gentoo/build/overlay" 
SYNC="rsync://rsync.gentoo.org/gentoo-portage" 
USE="x86 X Xaw3d a52 aac aalib acl acpi activefilter afs alsa aotuv arts 
audiofile avi bash-completion berkdb bitmap-fonts bluetooth bzip2 caps cdda 
cddb cdio cdparanoia cdr chipcard client-only cpudetection crypt cups dlloader 
doc dtaus dv dvd dvdread edl eds emacs emboss encode exif expat fam flac 
font-server foomaticdb ftp gd-external gdbm geldkarte gif gnokii gnutls gphoto2 
gpm gtk2 hardened hbci httpd icq imagemagick imap imlib ipppd irda irmc isdnlog 
jpeg jpeg2k kcal kde kdexdeltas kerberos koffice-plugin latex lcms ldap libg++ 
libwww lm_sensors lzo mad madwifi maildir mbox mime mjpeg motif mozsvg mp3 mpeg 
mule musicbrainz nas ncurses nls no-old-linux noantlr nobcel nobeanutils nobsh 
nocommonslogging nocommonsnet nojdepend nojsch nojython nolog4j nooro noregexp 
norhino noxalan noxerces nptl nptlonly objc ofx ogg oggvorbis openexr opengl 
pam pam_console pcre pdflib perl perlsuid pg-intdatetime pic png postgres ppds 
pppd pwdb python qt quicktime rdesktop readline real rtc savedconfig slang slp 
sms sockets socks5 speex spell sql sse ssl stream subversion svg svga symlink 
sysfs tcltk tcpd tetex theora threads tiff toolbar truetype truetype-fonts 
type1-fonts unicode usb vcd vim-with-x vlm vorbis wifi win32codecs wxwindows 
xine xml2 xmms xosd xprint xscreensaver xv xvid xvmc zeroconf zlib linguas_de 
userland_GNU kernel_linux elibc_glibc" 
Unset:  ASFLAGS, CTARGET, LANG, LC_ALL, LDFLAGS, MAKEOPTS 
 

Is this the classic "I did upgrade my compiler, but did not read anything about
the ABI changes and did not rebuild all C++ libraries" problem?

This is a problem related to changes in libpqxx, I don't know anything else :
kpogre compiles with libpqxx-2.5.1, but not with libpqxx-2.5.5. Why ? I don't
know... Anyway, the compiler has nothing to do with it in my opinion.

Fiddling with nm, I saw that libpqxx-2.5.5.so doesn't export the symbol
do_startconnect, while libpqxx.a does. This is, therefore, a bug in libpqxx
rather than in kpogre. I have the same problem on my AMD64 machine.

I found that this "bug" is because kpogre uses deprecated/internal libpqxx
functions. Please see this:
http://gborg.postgresql.org/project/libpqxx/bugs/bugupdate.php?1478

and lets whine/complain to the kpogre maintainers.

You can try KPoGre version 1.3.7 released 2006/03/12
(http://kpogre.sourceforge.net)

(In reply to comment #7)
> You can try KPoGre version 1.3.7 released 2006/03/12
> (http://kpogre.sourceforge.net)
> 
I would love to. I am a KPoGre fan. Any chance of someone doing an ebuild for
this update? (other than me... shameful, I know. If nobody tackles it soon I'll
do it myself, just not so confident - it will be my first.)

(In reply to comment #8)
> (In reply to comment #7)
> > You can try KPoGre version 1.3.7 released 2006/03/12
> > (http://kpogre.sourceforge.net)
> > 
> I would love to. I am a KPoGre fan. Any chance of someone doing an ebuild for
> this update? (other than me... shameful, I know. If nobody tackles it soon I'll
> do it myself, just not so confident - it will be my first.)

Just renamed the 1.3.5 ebuild to 1.3.7. Compiles and works fine for me. Please
upgrade in portage.

(In reply to comment #9)

Renamed kpogre-1.3.5 to kpogre-1.3.7. It works for me too.

Renaming ebuild and emerging also fixed the issue here.

Portage 2.1.1_pre1-r1 (default-linux/x86/2006.0, gcc-3.4.6/vanilla,
glibc-2.3.3.20040420-r2, 2.6.16-gentoo-r8 i686)
=================================================================
System uname: 2.6.16-gentoo-r8 i686 Intel(R) Xeon(TM) CPU 3.20GHz
Gentoo Base System version 1.12.1
distcc 2.18.3 i686-pc-linux-gnu (protocols 1 and 2) (default port 3632)
[disabled]
dev-lang/python:     2.3.5-r2, 2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r2
sys-devel/gcc-config: 2.0.0_rc1
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r5
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=i686 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/eselect/compiler /etc/gconf
/etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-O2 -march=i686 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org
http://distro.ibiblio.org/pub/linux/distributions/gentoo"
MAKEOPTS="-j5"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress
--force --whole-file --delete --delete-after --stats --timeout=180 --excl
ude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://192.168.0.160/gentoo-portage"
USE="x86 3dnow X a52 aac acl acpi afs alsa apm avi berkdb bitmap-fonts cairo
cdr cli crypt cups daap dbus dri dts dv dvd dvdr dvdread emboss encode esd e
xif ffmpeg foomaticdb fortran gdbm gif gstreamer gtk gtk2 ieee1394 imagemagick
imlib ipod ipv6 isdnlog jpeg kerberos ldap libg++ libwww mad matroska mikm
od mime mmx mono motif mp3 mpeg musicbrainz ncurses nls nvidia ogg opengl oss
pam pcre pdf pdflib perl png pppd python qt quicktime readline real reflect
ion sasl sdl session spell spl sse sse2 ssl tcpd tetex theora threads transcode
truetype truetype-fonts type1-fonts udev unicode usb v4l vorbis win32code
cs xine xml xmms xorg xosd xv xvid xvmc zlib elibc_glibc input_devices_keyboard
input_devices_mouse kernel_linux userland_GNU video_cards_nvidia"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS

I ran into the same problem, but don't know what exactly I have to change to
get kpogre running 

my emerge --info is:
Portage 2.1.1_pre4-r2 (default-linux/x86/no-nptl, gcc-3.4.6/vanilla,
glibc-2.3.6-r4, 2.6.17-gentoo-r4 i686)
=================================================================
System uname: 2.6.17-gentoo-r4 i686 AMD Athlon(TM) XP 2100+
Gentoo Base System version 1.12.4
ccache version 2.3 [disabled]
app-admin/eselect-compiler: 2.0.0_rc2-r1
dev-lang/python:     2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.3
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.18.1
sys-devel/autoconf:  2.13, 2.60
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.17
sys-devel/gcc-config: 2.0.0_rc1
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r5
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i386-pc-linux-gnu"
CFLAGS="-march=athlon-xp -O2 -pipe"
CHOST="i386-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.4/env /usr/kde/3.4/share/config
/usr/kde/3.4/shutdown /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/eselect/compiler
/etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-O2 -mtune=i686 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org
http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LINGUAS="de en ru"
MAKEOPTS=""
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress
--force --whole-file --delete --delete-after --stats --timeout=180
--exclude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X alsa apache2 apm arts audiofile avi berkdb bitmap-fonts bzip2 cdr cli
crypt ctype cups dba dlloader dri eds elibc_glibc emboss encode esd ethereal
exif expat fam fastbuild foomaticdb force-cgi-redirect fortran ftp gd gdbm gif
glut gmp gnome gpm gstreamer gtk gtk2 gtkhtml guile idn imlib ipv6 isdnlog jpeg
kde kernel_linux lcms libg++ libwww mad memlimit mikmod mng motif mozilla mp3
mpeg mysql ncurses nls nsplugin ogg opengl oss pam pcre pdflib perl png posix
postgres pppd python qt qt3 qt4 quicktime readline reflection samba sdl session
simplexml slang soap sockets spell spl ssl symlink tcltk tcpd tiff tokenizer
truetype truetype-fonts type1-fonts udev unicode userland_GNU vorbis x86 xml
xml2 xmms xorg xsl xv zlib input_devices_mouse input_devices_keyboard
linguas_de linguas_en linguas_ru video_cards_nvidia video_cards_vesa
video_cards_fbdev"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

(In reply to comment #12)
> I ran into the same problem, but don't know what exactly I have to change to
> get kpogre running 

See comments 9-11. In more detail:

1) Copy 1.3.5 ebuild into your portage overlay and rename it to 1.3.7
2) run ebuild /path/to/new/ebuild digest
3) emerge kpogre

Thanks - 
- cd /usr/portage/dev-db/kpogre/
- cp kpogre-1.3.5.ebuild kpogre-1.3.7.ebuild
- ebuild kpogre-1.3.7.ebuild digest
- emerge kpogre

Pls close the bug.

(In reply to comment #14)

> Pls close the bug.

NO!!! Not unless there's an official, working ebuild for kpogre.

Meanwhile kpogre-1.4.0 has been released. It depends on libpqxx-2.5.5 or newer.
Just tested a modified 1.3.5 ebuild with gcc-4.1.1. This results in the same
problem as in older versions (see first comment). 

Created an attachment (id=96329) [edit]
Ebuild for kpogre-1.4.0

Tested on x86. @Maintainers: consider replacing DEPEND libpqxx-2.5.5 by
libpqxx-2.6.8 (bug #108387 and bug #138470) as it is the current version of
libpqxx and solves compiling issues with gcc-4.1.1 (bug #146453). This ebuild
was tested against libpqxx-2.6.8 which is not in portage yet (visit bugs
above).

Version 1.5.1 is finally in portage, together with libpqxx-2.6.8... and it
compiles fine here. Enjoy! :)