[gentoo-dev] Wrong dependencies to postgresql

[gentoo-dev] Wrong dependencies to postgresql

[Enrico Weigelt]

Hi folks,

since jakub (as always) closes all my bugs, I'll report the issue 
to this list before completely giving up and never ever waste a 
single second on reporting bugs ...

Lots of packages have an wrong/unnecessary dependency to 
postgresql. Three cases:

a) probably traditionally depended on the whole postgresql, maybe 
   since before libpq was an own package. ie. qt, dovecot, ...
   
b) many apps (ie. webapps like bugzilla) have postgresql as dep.,
   although they do not need it to be installed. (ie. bugzilla does 
   not have to do anything directly w/ postgresql, since it uses 
   perl-DBD for database access). Of course they maybe want to 
   have access to some postgres database, but this obviously does
   not need an local server.
   

cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service - http://www.metux.de/
---------------------------------------------------------------------
 Please visit the OpenSource QM Taskforce:
 	http://wiki.metux.de/public/OpenSource_QM_Taskforce
 Patches / Fixes for a lot dozens of packages in dozens of versions:
	http://patches.metux.de/
---------------------------------------------------------------------
-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Wrong dependencies to postgresql

[Doug Goldstein]

Enrico Weigelt wrote:
> Hi folks,
> 
> since jakub (as always) closes all my bugs, I'll report the issue 
> to this list before completely giving up and never ever waste a 
> single second on reporting bugs ...

Enrico, you know exactly why he does that. Review the last bug you filed 
to me if you're claiming your clueless as to why.


> 
> Lots of packages have an wrong/unnecessary dependency to 
> postgresql. Three cases:
> 
> a) probably traditionally depended on the whole postgresql, maybe 
>    since before libpq was an own package. ie. qt, dovecot, ...
>    
> b) many apps (ie. webapps like bugzilla) have postgresql as dep.,
>    although they do not need it to be installed. (ie. bugzilla does 
>    not have to do anything directly w/ postgresql, since it uses 
>    perl-DBD for database access). Of course they maybe want to 
>    have access to some postgres database, but this obviously does
>    not need an local server.
>    
> 
> cu

Without providing a specific list of packages, nothing will be done with 
this.




-- 
Doug Goldstein <cardoe@gentoo.org>
http://dev.gentoo.org/~cardoe/
-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Wrong dependencies to postgresql

[Doug Goldstein]

Doug Goldstein wrote:
> Enrico Weigelt wrote:
>> Hi folks,
>>
>> since jakub (as always) closes all my bugs, I'll report the issue to 
>> this list before completely giving up and never ever waste a single 
>> second on reporting bugs ...
> 
> Enrico, you know exactly why he does that. Review the last bug you filed 
> to me if you're claiming your clueless as to why.

http://www.google.com/search?hl=en&q=%22enrico+weigelt%22+troll&btnG=Google+Search

Two pages on the US version of Google when you search for "Enrico 
Weigelt" and troll...

http://www.google.de/search?q=%22enrico+weigelt%22+troll&ie=utf-8&oe=utf-8&rls=org.mozilla:de:official&client=firefox-a

6!!! pages on the German one..

You still wonder why some of your bugs get closed?

> 
> 
>>
>> Lots of packages have an wrong/unnecessary dependency to postgresql. 
>> Three cases:
>>
>> a) probably traditionally depended on the whole postgresql, maybe    
>> since before libpq was an own package. ie. qt, dovecot, ...
>>    b) many apps (ie. webapps like bugzilla) have postgresql as dep.,
>>    although they do not need it to be installed. (ie. bugzilla does    
>> not have to do anything directly w/ postgresql, since it uses    
>> perl-DBD for database access). Of course they maybe want to    have 
>> access to some postgres database, but this obviously does
>>    not need an local server.
>>   
>> cu
> 
> Without providing a specific list of packages, nothing will be done with 
> this.
> 
> 
> 
> 


-- 
Doug Goldstein <cardoe@gentoo.org>
http://dev.gentoo.org/~cardoe/
-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Wrong dependencies to postgresql

[Jakub Moc]

[-- Attachment #1: Type: text/plain, Size: 1190 bytes --]

Enrico Weigelt napsal(a):
> Hi folks,
> 
> since jakub (as always) closes all my bugs, I'll report the issue 
> to this list before completely giving up and never ever waste a 
> single second on reporting bugs ...

Thanks, you've wasted at least one hour of my time I spent duping those
bugs and deleting the bugspam from my mailbox.

You've already got your explanation on Bug 158950, so I don't see what's
the point of this mail. Also, I'd expect people are able to use common
sense when reporting bugs and do some research beforehand, but
apparently that's not your case. To top the bugsmash, you've filed
completely invalid Bug 158978 after all the above ~25 dupes, yet again
proving that you didn't do any research at all.

P.S. Oh, and as someone else already noted, you'd better fix your
mailserver, it still seems a bit hacked... :P

http://www.mail-archive.com/users@tomcat.apache.org/msg20585.html


-- 
Best regards,

 Jakub Moc
 mailto:jakub@gentoo.org
 GPG signature:
 http://subkeys.pgp.net:11371/pks/lookup?op=get&search=0xCEBA3D9E
 Primary key fingerprint: D2D7 933C 9BA1 C95B 2C95  B30F 8717 D5FD CEBA 3D9E

 ... still no signature   ;)


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 189 bytes --]

[gentoo-dev] Re: Wrong dependencies to postgresql

[Tiziano Mueller]

Hi Enrico

Enrico Weigelt wrote:
> Hi folks,

> since jakub (as always) closes all my bugs, I'll report the issue 
> to this list before completely giving up and never ever waste a 
> single second on reporting bugs ...
... and we're grateful to you for that.

> Lots of packages have an wrong/unnecessary dependency to 
> postgresql. Three cases:
Two. ( a) + b) '=' two cases )

> a) probably traditionally depended on the whole postgresql, maybe 
>    since before libpq was an own package. ie. qt, dovecot, ...
No. At least that's not the only reason.
Since you reported a duplicated bug-report (bug #158978) for the issue I'm talking about, I thought you would have noted.
But let's make it clear:
There is this pg_config app which can be used by other apps to get includedir/libdir/cflags/ldflags/etc for the postgresql-libraries. This app has been installed by dev-db/postgresql until the latest 
minor version bumps (7.3.16, 7.4.14, 8.0.9-r1, 8.1.5-r1) for which we have an open stabilization bug (bug #152783). Until this bug is closed, stable packages which try to depend only on libpq instead 
of postgresql will eventually get an older version (depending on the arch) and fail. Therefore those bugs are invalid.

> b) many apps (ie. webapps like bugzilla) have postgresql as dep.,
>    although they do not need it to be installed. (ie. bugzilla does 
>    not have to do anything directly w/ postgresql, since it uses 
>    perl-DBD for database access). Of course they maybe want to 
>    have access to some postgres database, but this obviously does
>    not need an local server.
Thanks a lot for pointing this out. But be assured that we already know about the issue and we will solve it as soon as the mentioned versions of postgresql are stable on all archs together with the 
other dependencies.
And we really don't need help to identify the packages in question, nor a bug-report for every single one of them, but thanks again.

Thanks for reporting the issues and the interest in our work.

-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Enrico Weigelt]

* Tiziano Mueller <dev-zero@gentoo.org> schrieb:

Hi,

> >since jakub (as always) closes all my bugs, I'll report the issue 
> >to this list before completely giving up and never ever waste a 
> >single second on reporting bugs ...
> ... and we're grateful to you for that.

For reporting this issue or for not reporting anythin in future ?

> >Lots of packages have an wrong/unnecessary dependency to 
> >postgresql. Three cases:
> Two. ( a) + b) '=' two cases )

ugh, I first wanted to write about three ones, but while writing 
this mail I've seen they're actually two, while some packages 
have both ... ;-o

> >a) probably traditionally depended on the whole postgresql, maybe 
> >   since before libpq was an own package. ie. qt, dovecot, ...
> No. At least that's not the only reason.

Which other reasons do we have ?

> Since you reported a duplicated bug-report (bug #158978) for the issue I'm 
> talking about, I thought you would have noted.

Aehm, completely different front. Right, I should have find the dup by 
myself, but I was quite in a hurry at this time. The alternative would 
have been not telling anything about any problems I've found. 

> But let's make it clear:
> There is this pg_config app which can be used by other apps to get 
> includedir/libdir/cflags/ldflags/etc for the postgresql-libraries. 
> This app has been installed by dev-db/postgresql until the latest 
> minor version bumps (7.3.16, 7.4.14, 8.0.9-r1, 8.1.5-r1) for which 
> we have an open stabilization bug (bug #152783). 

In other words: the splitoff between postgresql and libpg has been
buggy in some (older) versions, which are still in use / necessary ?
So certain packages importing libpq may require postgresql if 
libpq's version is too old.

I currently see two ways out of this:

a) Fix the older libpq versions too. If it's just the missing pg_config,
   it should be just a few lines to add. 

b) use multiple-choice-dependencies (||):
   if libpq is new enough, import it, otherwise import postgresql.
   
I'd prefer the a) and so attached an fixed ebuild for 8.0.8.
The change is quite minor, so stableizing should go quite quick here.

> Until this bug is closed, stable packages which try to depend only 
> on libpq instead of postgresql will eventually get an older version 
> (depending on the arch) and fail. Therefore those bugs are invalid.

Ah, and they become valid as soon as the pg_config issue is cleared ?

<snip>

> >b) many apps (ie. webapps like bugzilla) have postgresql as dep.,
> >   although they do not need it to be installed. (ie. bugzilla does 
> >   not have to do anything directly w/ postgresql, since it uses 
> >   perl-DBD for database access). Of course they maybe want to 
> >   have access to some postgres database, but this obviously does
> >   not need an local server.
> Thanks a lot for pointing this out. But be assured that we already 
> know about the issue and we will solve it as soon as the mentioned 
> versions of postgresql are stable on all archs together with the 
> other dependencies.

IMHO, the bugzilla bug could be fixed now, since it's dependency
is not necessary at all - or does bugzilla use pg_config ?

> And we really don't need help to identify the packages in question, 
> nor a bug-report for every single one of them, but thanks again.

Well, my intention simply was: one bug per job/issue, and each
package by it's own. Assuming packages have different maintainers
and aren't fixed all at the same time ...

> Thanks for reporting the issues and the interest in our work.

BTW: the first time I'm reading such words on this list :)


cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service - http://www.metux.de/
---------------------------------------------------------------------
 Please visit the OpenSource QM Taskforce:
 	http://wiki.metux.de/public/OpenSource_QM_Taskforce
 Patches / Fixes for a lot dozens of packages in dozens of versions:
	http://patches.metux.de/
---------------------------------------------------------------------
-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Enrico Weigelt]

[-- Attachment #1: Type: text/plain, Size: 706 bytes --]

* Enrico Weigelt <weigelt@metux.de> schrieb:

> I'd prefer the a) and so attached an fixed ebuild for 8.0.8.

Forgot the attachement. Here it is ...

This ebuild adds pg_config to libpq-8.0.8, gave it version -r1.
Tested it @ x86.


cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service - http://www.metux.de/
---------------------------------------------------------------------
 Please visit the OpenSource QM Taskforce:
 	http://wiki.metux.de/public/OpenSource_QM_Taskforce
 Patches / Fixes for a lot dozens of packages in dozens of versions:
	http://patches.metux.de/
---------------------------------------------------------------------

[-- Attachment #2: libpq-8.0.8-r1.ebuild --]
[-- Type: text/plain, Size: 3338 bytes --]

# Copyright 1999-2006 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
# $Header: /var/cvsroot/gentoo-x86/dev-db/libpq/libpq-8.0.8-r2.ebuild,v 1.12 2006/07/30 22:32:28 chtekk Exp $

inherit eutils gnuconfig flag-o-matic toolchain-funcs

DESCRIPTION="Libraries of postgresql"
HOMEPAGE="http://www.postgresql.org/"
MY_P="postgresql-${PV}"
SRC_URI="mirror://postgresql/source/v${PV}/postgresql-base-${PV}.tar.bz2"

LICENSE="POSTGRESQL"
SLOT="4"
KEYWORDS="alpha amd64 arm hppa ia64 mips ppc ppc64 s390 sh sparc x86"
IUSE="ssl nls pam readline zlib kerberos"
#pg-hier"

S=${WORKDIR}/${MY_P}
DEPEND="virtual/libc
	sys-devel/autoconf
	>=sys-libs/ncurses-5.2
	>=sys-devel/bison-1.875
	zlib? ( >=sys-libs/zlib-1.1.3 )
	pam? ( virtual/pam )
	readline? ( >=sys-libs/readline-4.1 )
	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
	nls? ( sys-devel/gettext )
	kerberos? ( virtual/krb5 )"
RDEPEND="virtual/libc
	zlib? ( >=sys-libs/zlib-1.1.3 )
	ssl? ( >=dev-libs/openssl-0.9.6-r1 )
	kerberos? ( virtual/krb5 )"

MAKEOPTS="${MAKEOPTS} -j1"

pkg_preinst() {
	# removing wrong symlink which is created by previous ebuild.
	if [ -L /usr/include/libpq ]; then
		rm /usr/include/libpq
	fi
}

src_unpack() {
	unpack ${A}
	cd "${S}"
	epatch "${FILESDIR}/${P}-gentoo.patch"
}

src_compile() {
	filter-flags -ffast-math -feliminate-dwarf2-dups

	local myconf
	use ssl && myconf="$myconf --with-openssl"
	use nls && myconf="$myconf --enable-nls"
	use pam && myconf="$myconf --with-pam"
	use readline || myconf="$myconf --without-readline"
	use zlib || myconf="$myconf --without-zlib"
	use kerberos && myconf="$myconf --with-krb5"

	# these are the only working CFLAGS I could get on ppc, so locking them
	# down, anything more aggressive fails (i.e. -mcpu or -Ox)
	# Gerk - Nov 26, 2002
	use ppc && CFLAGS="-pipe -fsigned-char"

	# Detect mips systems properly
	gnuconfig_update

	./configure --prefix=/usr \
		--include=/usr/include/postgresql/libpq-${SLOT} \
		--mandir=/usr/share/man \
		--host=${CHOST} \
		--with-docdir=/usr/share/doc/${PF} \
		--libdir=/usr/$(get_libdir) \
		--enable-depend \
		$myconf || die

	cd ${S}/src/interfaces/libpq
	emake LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die

	cd "${S}/src/bin/pg_config" || die "could not cd to pg_config"
	emake -j1 LD="$(tc-getLD) $(get_abi_LDFLAGS)" || die "emake pg_config failed"
}

src_install() {
	cd ${S}/src/interfaces/libpq
	make DESTDIR=${D} LIBDIR=${D}/usr/$(get_libdir) install || die

	cd ${S}/src/include
	make DESTDIR=${D} install || die

	cd ${S}
	dodoc README HISTORY COPYRIGHT INSTALL

	dosym libpq-${SLOT}.a /usr/$(get_libdir)/libpq.a

	for f in ${D}/usr/include/postgresql/libpq-${SLOT}/*.h
	do
		dosym postgresql/libpq-${SLOT}/$(basename $f) /usr/include/
	done

	dodir /usr/include/libpq
	for f in ${D}/usr/include/postgresql/libpq-${SLOT}/libpq/*.h
	do
		dosym ../postgresql/libpq-${SLOT}/libpq/$(basename $f) /usr/include/libpq/
	done

	cd ${D}/usr/include/postgresql/libpq-${SLOT}
	for f in $(find * -name '*.h' -print) ; do
		destdir=$(dirname $f)
		if [ ! -d "${D}/usr/include/postgresql/${destdir}" ]; then
			dodir /usr/include/postgresql/${destdir}
		fi
		dosym /usr/include/postgresql/libpq-${SLOT}/${f} /usr/include/postgresql/${destdir}/
	done

	cd "${S}/src/bin/pg_config"
	emake DESTDIR="${D}" install || die "emake install pg_config failed"
}

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Jakub Moc]

[-- Attachment #1: Type: text/plain, Size: 791 bytes --]

Enrico Weigelt napsal(a):
> * Enrico Weigelt <weigelt@metux.de> schrieb:
> 
>> I'd prefer the a) and so attached an fixed ebuild for 8.0.8.
> 
> Forgot the attachement. Here it is ...
> 
> This ebuild adds pg_config to libpq-8.0.8, gave it version -r1.
> Tested it @ x86.

Don't want to be rude, but would you damn read the bug finally? It's
already *fixed* in ~arch and waiting for stabilization (in fact, it's
already stabilized almost everywhere due to security Bug 152783). What
are you fixing here?

Merry Xmas.

-- 
Best regards,

 Jakub Moc
 mailto:jakub@gentoo.org
 GPG signature:
 http://subkeys.pgp.net:11371/pks/lookup?op=get&search=0xCEBA3D9E
 Primary key fingerprint: D2D7 933C 9BA1 C95B 2C95  B30F 8717 D5FD CEBA 3D9E

 ... still no signature   ;)


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Enrico Weigelt]

* Jakub Moc <jakub@gentoo.org> schrieb:

> Don't want to be rude, but would you damn read the bug finally? 
> It's already *fixed* in ~arch and waiting for stabilization 
> (in fact, it's already stabilized almost everywhere due to 
> security Bug 152783). 

As far as the official (not-cvs) tree concerns (my copy sync'ed
this night): 8.0.9 - yes, of course. But I wanted to go an step
back and get 8.0.8 fixed, ASAP.

My next step would be changing the libpq dependency in 
postgresql-8.0.9 to >=libpq-8.0.8-r1.

This should allow an seamless update.


cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service - http://www.metux.de/
---------------------------------------------------------------------
 Please visit the OpenSource QM Taskforce:
 	http://wiki.metux.de/public/OpenSource_QM_Taskforce
 Patches / Fixes for a lot dozens of packages in dozens of versions:
	http://patches.metux.de/
---------------------------------------------------------------------
-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Doug Goldstein]

Enrico Weigelt wrote:
> * Jakub Moc <jakub@gentoo.org> schrieb:
> 
>> Don't want to be rude, but would you damn read the bug finally? 
>> It's already *fixed* in ~arch and waiting for stabilization 
>> (in fact, it's already stabilized almost everywhere due to 
>> security Bug 152783). 
> 
> As far as the official (not-cvs) tree concerns (my copy sync'ed
> this night): 8.0.9 - yes, of course. But I wanted to go an step
> back and get 8.0.8 fixed, ASAP.
> 
> My next step would be changing the libpq dependency in 
> postgresql-8.0.9 to >=libpq-8.0.8-r1.
> 
> This should allow an seamless update.
> 
> 
> cu

Do you read ANYTHING? It's a security bug... PREVIOUS VERSIONS WILL NOT 
BE FIXED! Since they're affected by a security issue.


-- 
Doug Goldstein <cardoe@gentoo.org>
http://dev.gentoo.org/~cardoe/
-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Mike Frysinger]

[-- Attachment #1: Type: text/plain, Size: 241 bytes --]

On Sunday 24 December 2006 22:54, Doug Goldstein wrote:
> Do you read ANYTHING? It's a security bug... PREVIOUS VERSIONS WILL NOT
> BE FIXED! Since they're affected by a security issue.

i miss the happier times when we had him banned
-mike

[-- Attachment #2: Type: application/pgp-signature, Size: 827 bytes --]

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Luca Barbato]

Mike Frysinger wrote:
> 
> i miss the happier times when we had him banned

Do you think it's time for a revival?

lu

-- 

Luca Barbato

Gentoo/linux Gentoo/PPC
http://dev.gentoo.org/~lu_zero

-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Alec Warner]

Luca Barbato wrote:
> Mike Frysinger wrote:
>>
>> i miss the happier times when we had him banned
> 
> Do you think it's time for a revival?
> 
> lu
> 

We never banned him, actually.

-Alec Warner
-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Jakub Moc]

[-- Attachment #1: Type: text/plain, Size: 1230 bytes --]

Enrico Weigelt napsal(a):
> * Jakub Moc <jakub@gentoo.org> schrieb:
> 
>> Don't want to be rude, but would you damn read the bug finally? 
>> It's already *fixed* in ~arch and waiting for stabilization 
>> (in fact, it's already stabilized almost everywhere due to 
>> security Bug 152783). 
> 
> As far as the official (not-cvs) tree concerns (my copy sync'ed
> this night): 8.0.9 - yes, of course. But I wanted to go an step
> back and get 8.0.8 fixed, ASAP.
> 
> My next step would be changing the libpq dependency in 
> postgresql-8.0.9 to >=libpq-8.0.8-r1.
>
> This should allow an seamless update.

Yeah, that would ensure two things:

1/ a seamless collision (postgresql which installed pg_config depending
on libpq that now installs its own copy)

2/ a nicely borked postgresql for people who installed 8.0.9 which
allowed them to upgrade their libpq to incompatible 8.1.5; the
dependency is ~{PV} now for obvious reasons)

Well done :P

-- 
Best regards,

 Jakub Moc
 mailto:jakub@gentoo.org
 GPG signature:
 http://subkeys.pgp.net:11371/pks/lookup?op=get&search=0xCEBA3D9E
 Primary key fingerprint: D2D7 933C 9BA1 C95B 2C95  B30F 8717 D5FD CEBA 3D9E

 ... still no signature   ;)


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-dev] Re: Wrong dependencies to postgresql

[Piotr Jaroszyński]

> We never banned him, actually.
Is there something wrong with the spamfilter then?

-- 
Best Regards,
Piotr Jaroszyński

-- 
gentoo-dev@gentoo.org mailing list

Re: [gentoo-dev] Wrong dependencies to postgresql

[Simon Stelling]

Enrico Weigelt wrote:
> since jakub (as always) closes all my bugs, I'll report the issue 
> to this list before completely giving up and never ever waste a 
> single second on reporting bugs ...

Please, never ever waste a single second on reporting "bugs" anymore. 
Your time is too worthy to be spent on such things. Thank you, and have 
a merry Christmas.

-- 
Kind Regards,

Simon Stelling
Gentoo/AMD64 Developer
-- 
gentoo-dev@gentoo.org mailing list