Bug 249697

Summary:	=dev-db/libpq-7.4 doesn't install pg_config binary
Product:	Gentoo Linux	Reporter:	MAL <mal>
Component:	Current packages	Assignee:	PgSQL Bugs <pgsql-bugs>
Status:	RESOLVED FIXED
Severity:	normal	CC:	net-mail+disabled
Priority:	High
Version:	2006.1
Hardware:	x86
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---
Attachments:	cyrus-sasl-2.1.22-r2 build log

Description MAL 2008-12-03 11:33:26 UTC

emerging dev-libs/cyrus-sasl-2.1.22-r2 gives:

---
sql.c:192:22: error: libpq-fe.h: No such file or directory
sql.c: In function '_pgsql_open':
sql.c:198: error: 'PGconn' undeclared (first use in this function)
sql.c:198: error: (Each undeclared identifier is reported only once
sql.c:198: error: for each function it appears in.)
sql.c:198: error: 'conn' undeclared (first use in this function)
sql.c:256: warning: implicit declaration of function 'PQconnectdb'
sql.c:259: warning: implicit declaration of function 'PQstatus'
sql.c:259: error: 'CONNECTION_OK' undeclared (first use in this function)
sql.c:260: warning: implicit declaration of function 'PQerrorMessage'
sql.c: In function '_pgsql_escape_str':
sql.c:269: warning: implicit declaration of function 'PQescapeString'
sql.c: In function '_pgsql_exec':
sql.c:275: error: 'PGresult' undeclared (first use in this function)
sql.c:275: error: 'result' undeclared (first use in this function)
sql.c:277: error: 'ExecStatusType' undeclared (first use in this function)
sql.c:277: error: expected ';' before 'status'
sql.c:280: warning: implicit declaration of function 'PQexec'
sql.c:283: error: 'status' undeclared (first use in this function)
sql.c:283: warning: implicit declaration of function 'PQresultStatus'
sql.c:284: error: 'PGRES_COMMAND_OK' undeclared (first use in this function)
sql.c:286: warning: implicit declaration of function 'PQclear'
sql.c:289: error: 'PGRES_TUPLES_OK' undeclared (first use in this function)
sql.c:292: warning: implicit declaration of function 'PQresStatus'
sql.c:298: warning: implicit declaration of function 'PQntuples'
sql.c:313: warning: implicit declaration of function 'PQgetvalue'
sql.c:313: warning: passing argument 2 of '__builtin_strncpy' makes pointer from integer without a cast
sql.c: In function '_pgsql_close':
sql.c:340: warning: implicit declaration of function 'PQfinish'
sql.c: In function 'sql_auxprop_plug_init':
sql.c:1077: warning: unused parameter 'plugname'
make[2]: *** [sql.lo] Error 1
make[2]: Leaving directory `/var/tmp/portage/dev-libs/cyrus-sasl-2.1.22-r2/work/cyrus-sasl-2.1.22/plugins'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/var/tmp/portage/dev-libs/cyrus-sasl-2.1.22-r2/work/cyrus-sasl-2.1.22'
make: *** [all] Error 2
---
(full log attached)


libpq-fe.h exists:

$ ls /usr/include/postgresql/libpq-fe.h
lrwxrwxrwx 1 root root 42 Dec  3 11:22 /usr/include/postgresql/libpq-fe.h -> /usr/include/postgresql/libpq-3/libpq-fe.h

$ ls /usr/include/postgresql/libpq-3/libpq-fe.h
-rw-r--r-- 1 root root 15724 Dec  3 11:21 /usr/include/postgresql/libpq-3/libpq-fe.h

Which leads me to think it's not getting the include path it needs...

# pg_config
bash: pg_config: command not found

# equery b pg_config
[ Searching for file(s) pg_config in *... ]
<no results>

# equery f libpq | grep pg_config
/usr/include/postgresql/libpq-3/pg_config.h
/usr/include/postgresql/libpq-3/pg_config_manual.h
/usr/include/postgresql/libpq-3/pg_config_os.h
/usr/include/postgresql/pg_config.h
/usr/include/postgresql/pg_config_manual.h
/usr/include/postgresql/pg_config_os.h

Why does libpq not produce pg_config ?

Reproducible: Always

Steps to Reproduce:




# emerge --info
Portage 2.1.4.5 (default-linux/x86/2007.0, gcc-4.1.2, glibc-2.6.1-r0, 2.6.20-gentoo-r8 i686)
=================================================================
System uname: 2.6.20-gentoo-r8 i686 Pentium III (Coppermine)
Timestamp of tree: Mon, 01 Dec 2008 14:31:01 +0000
app-shells/bash:     3.2_p33
dev-lang/python:     2.4.4-r13, 2.5.2-r7
dev-python/pycrypto: 2.0.1-r6
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.2.18.1-r2
sys-devel/autoconf:  2.13, 2.61-r2
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.1-r1
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.23-r3
ACCEPT_KEYWORDS="x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-mtune=pentium3 -O2 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php4/ext-active/ /etc/php/cgi-php4/ext-active/ /etc/php/cli-php4/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/udev/rules.d"
CXXFLAGS="-mtune=pentium3 -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer notitles parallel-fetch sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://ftp.belnet.be/mirror/rsync.gentoo.org/gentoo/ http://gentoo.blueyonder.co.uk http://mirror.datapipe.net/gentoo http://mirror.uni-c.dk/gentoo/ http://ftp.ntua.gr/pub/linux/gentoo/"
MAKEOPTS="-j1"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_EXTRA_OPTS="--bwlimit=100"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage /usr/portage/local/layman/webapps-experimental"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="acl acpi apache2 berkdb bzip2 calendar caps cdb cgi chroot cli courier cracklib crypt ctype curl dri evms2 exif expat fam freetype gd gdbm gif gmp hardenedphp hpn iconv imagemagick imap ipv6 isdnlog javascript jbig jpeg jpeg2k maildir memlimit mhash midi mmx mng mudflap mysql ncurses nls no-htdocs nptl old-linux openmp pam pcre perl pic png posix postgres pppd python readline reflection rpc rrdcgi sasl sensord session sftplogging slang sockets spell spf spl sse ssl suhosin tcpd tiff tokenizer tools truetype unicode urandom vhosts virtual-users virus-scan wmf x86 xattr xml xorg xsl zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="apm ark chips cirrus cyrix dummy fbdev glint i128 i740 i810 imstt intel mach64 mga neomagic nsc nv r128 radeon rendition s3 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l vesa vga via vmware voodoo"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS

Comment 1 MAL 2008-12-03 11:34:38 UTC

Created attachment 174151 [details]
cyrus-sasl-2.1.22-r2 build log

Comment 2 MAL 2008-12-03 11:35:51 UTC

For info:

# emerge -pC postgresql libpq cyrus-sasl

>>> These are the packages that would be unmerged:

--- Couldn't find 'cyrus-sasl' to unmerge.

 dev-db/postgresql
    selected: 7.4.19 
   protected: none 
     omitted: none 

 dev-db/libpq
    selected: 7.4.19 
   protected: none 
     omitted: none

Comment 3 Rafał Mużyło 2008-12-03 16:44:58 UTC

Well, dev-db/libpq-8.3.1 does have pg_config.
However, ebuilds differ significantly and there was
a slot change between libpq 7.4 and 8.

See, if reemerging libpq helps, if not try updating it.

Comment 4 MAL 2008-12-31 17:31:21 UTC

(In reply to comment #3)
> See, if reemerging libpq helps, if not try updating it.

Re-emerging libpq does not help, and I need postgresql 7.

If this doesn't work with postgresql <8.0 then the dependency needs updating.

Comment 5 Michał Kudła 2009-01-21 11:47:40 UTC

I have postgresql 8

m1k0 ~ # qlist -Iv postgresql
app-admin/eselect-postgresql-0.3
dev-db/postgresql-base-8.3.5
dev-db/postgresql-server-8.3.5
dev-java/jdbc-postgresql-8.3_p603-r1
virtual/postgresql-base-8.3
virtual/postgresql-server-8.3

And cyrus-sasl don't compile too

sql.c: In function 'sqlite_my_callback':                                                                                                                                                                     
sql.c:391: warning: unused parameter 'argc'                                                                                                                                                                  
sql.c:393: warning: unused parameter 'columnNames'                                                                                                                                                           
sql.c: In function 'sql_auxprop_plug_init':                                                                                                                                                                  
sql.c:1077: warning: unused parameter 'plugname'                                                                                                                                                             
make[2]: *** [sql.lo] Error 1                                                                                                                                                                                
make[2]: Leaving directory `/var/tmp/portage/dev-libs/cyrus-sasl-2.1.22-r2/work/cyrus-sasl-2.1.22/plugins'                                                                                                   
make[1]: *** [all-recursive] Error 1                                                                                                                                                                         
make[1]: Leaving directory `/var/tmp/portage/dev-libs/cyrus-sasl-2.1.22-r2/work/cyrus-sasl-2.1.22'                                                                                                           
make: *** [all] Error 2                                                                                                                                                                                      
 *                                                                                                                                                                                                           
 * ERROR: dev-libs/cyrus-sasl-2.1.22-r2 failed.

Comment 6 Tobias Scherbaum (RETIRED) gentoo-dev

2009-06-06 18:51:18 UTC

Ok, I did reproduce this. dev-db/postgresql-base worked, while libpq doesn't because of a missing pg_config binary (header files are installed, though). Both using 7.4.

Re-assigning to pgsql-bugs@g.o therefore.

(and wrt #5: please file a new bug for each bug you've found and don't (ab)use existing bugreports.)

Comment 7 Patrick Lauer gentoo-dev

2010-07-11 22:34:32 UTC

Package is gone.