Bug 291187 – x11-libs/qt-sql-4.5.3 greedily wants both sqlite and mysql

• Product: Gentoo Linux
• Status: RESOLVED INVALID

[Description Paul Gover 2009-10-30 16:30:15 UTC]

Thanks for unmasking KDE 4.3.1!
Full of enthusiasm, I pretended to upgrade my world (with kdepim-meta 3.10 or so).  First attempt barfed because it wanted USE="sql", so I added that globally.  Now it barfs because qt-sql wants mysql, even though I already have sqlite.

I suspect the DEPENDS string "[sqlite,mysql]" was expected to mean one or t'other, but the ebuild docs says it means both, which looks overkill :-)


Reproducible: Always

Steps to Reproduce:
1.see above
2.
3.

Actual Results:  
Calculating dependencies ... done!

emerge: there are no ebuilds built with USE flags to satisfy ">=x11-libs/qt-sql-4.5.0:4[sqlite,mysql]".
!!! One of the following packages is required to complete your request:
- x11-libs/qt-sql-4.5.3 (Change USE: +mysql)
(dependency required by "app-office/akonadi-server-1.2.1" [ebuild])
(dependency required by "kde-base/kdepimlibs-4.3.1" [ebuild])
(dependency required by "kde-base/knotes-4.3.1" [ebuild])
(dependency required by "kde-base/kdepim-meta-4.3.1" [ebuild])
(dependency required by "world" [argument])


Expected Results:  
kdepim installed using sqlite

emerge --info

Portage 2.1.6.13 (default/linux/x86/10.0/desktop, gcc-4.3.4, glibc-2.9_p20081201-r2, 2.6.30-gentoo-r6 i686)
=================================================================
System uname: Linux-2.6.30-gentoo-r6-i686-Intel-R-_Atom-TM-_CPU_N280_@_1.66GHz-with-gentoo-1.12.11.1
Timestamp of tree: Fri, 30 Oct 2009 07:45:02 +0000
app-shells/bash:     4.0_p28
dev-java/java-config: 2.1.8-r1
dev-lang/python:     2.6.2-r1
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.6-r2
sys-devel/autoconf:  2.63-r1
sys-devel/automake:  1.7.9-r1, 1.9.6-r2, 1.10.2
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6a
virtual/os-headers:  2.6.27-r2
ACCEPT_KEYWORDS="x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O3 -march=core2 -mtune=generic -msse3 -mfpmath=sse -fomit-frame-pointer -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/config"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/udev/rules.d"
CXXFLAGS="-O3 -march=core2 -mtune=generic -msse3 -mfpmath=sse -fomit-frame-pointer -pipe"
DISTDIR="/var/tmp/distfiles"
FEATURES="distlocks fixpackages parallel-fetch protect-owned sandbox sfperms strict unmerge-orphans userfetch userpriv"
GENTOO_MIRRORS="http://www.mirrorservice.org/sites/www.ibiblio.org/gentoo/ "
LANG="en_GB.UTF-8"
LDFLAGS="-Wl,-O1"
LINGUAS="en_GB en en_US"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
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"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="X a52 aac acpi alsa berkdb bluetooth branding bzip2 cairo cdr clamav cleartype cli consolekit corefonts cracklib crypt cups dbus dialup dri dts dvb dvd dvdr eds emboss encode evo fam firefox flac fortran gdbm gif gpm gstreamer hal handbook iconv ipv6 isdnlog java jpeg kde kontact laptop libnotify mad mikmod mmx modules mp3 mp4 mpeg mudflap nano-syntax ncurses nls nptl nptlonly ogg opengl openmp pam pcre pdf perl png ppds pppd python qt3 qt3support qt4 quicktime readline reflection sdl session spell spl sql sqlite sse sse2 ssl ssse3 startup-notification svg sysfs tcpd threads thunar tiff truetype udev unicode usb vorbis webkit win32codecs x264 x86 xine xml xorg xulrunner xv xvid 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" DVB_CARDS="usb-wt220u" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en_GB en en_US" USERLAND="GNU" VIDEO_CARDS="intel"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

[Comment 1 Tomáš Chvátal (RETIRED) 2009-10-31 11:33:40 UTC]

Well pick one of those. in akonadi-server you have to pick implementation for backend.

Mysql one can be relyable, sqlite is experimental.

Just add to your /etc/portage/package.use line saying something like this:
app-office/akonadi-server -mysql sqlite

if you really really want sqlite.

Reopen with "emerge -pvDt world" as attachment if it still wants to pull in mysql.

[Comment 2 Miguel Ramos 2010-02-24 14:37:12 UTC]

Created attachment 220987 [details]
Output of emerge -pvDt world

After putting app-office/akonadi-server -mysql sqlite and re-emerging akonadi-server, qt-sql still pulls in mysql.

[Comment 3 Samuli Suominen (RETIRED) 2010-02-24 14:40:29 UTC]

(In reply to comment #2)
> Created an attachment (id=220987) [details]
> Output of emerge -pvDt world
> 
> After putting app-office/akonadi-server -mysql sqlite and re-emerging
> akonadi-server, qt-sql still pulls in mysql.
> 

Sure, because you have USE="mysql" enabled for x11-libs/qt-sql.

[nomerge      ]   x11-libs/qt-sql-4.5.3  USE="iconv mysql qt3support sqlite (-aqua) -debug (-firebird) -odbc -pch -postgres"  [0]