Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 519570 - app-emulation/libvirt-1.2.6 - libvirtd: SQL engine 'mysql' not supported // auxpropfunc error no mechanism available
Summary: app-emulation/libvirt-1.2.6 - libvirtd: SQL engine 'mysql' not supported // a...
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Doug Goldstein (RETIRED)
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-10 11:19 UTC by Juergen Rose
Modified: 2014-11-06 23:00 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Juergen Rose 2014-08-10 11:19:28 UTC
libvirtd complains after start:

root@lynx:/root(72)# systemctl start libvirtd
root@lynx:/root(73)# echo $?
0
root@lynx:/root(74)# systemctl status libvirtd
● libvirtd.service - Virtualization daemon
   Loaded: loaded (/usr/lib64/systemd/system/libvirtd.service; disabled)
   Active: active (running) since Sun 2014-08-10 13:17:55 CEST; 11s ago
     Docs: man:libvirtd(8)
           http://libvirt.org
 Main PID: 16407 (libvirtd)
   CGroup: /system.slice/libvirtd.service
           ├─16399 /usr/sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --dhcp-script=/usr/libexec/libvirt_leaseshelper
           ├─16400 /usr/sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --dhcp-script=/usr/libexec/libvirt_leaseshelper
           └─16407 /usr/sbin/libvirtd

Aug 10 13:17:55 lynx libvirtd[16407]: SQL engine 'mysql' not supported
Aug 10 13:17:55 lynx libvirtd[16407]: auxpropfunc error no mechanism available
Aug 10 13:17:55 lynx libvirtd[16407]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Aug 10 13:17:55 lynx systemd[1]: Started Virtualization daemon.
Aug 10 13:17:55 lynx libvirtd[16407]: libvirt version: 1.2.6




root@lynx:/root(75)# emerge --info libvirt
Portage 2.2.11-r1 (python 2.7.8-final-0, default/linux/amd64/13.0/desktop, gcc-4.8.3, glibc-2.19-r1, 3.16.0-gentoo x86_64)
=================================================================
                        System Settings
=================================================================
System uname: Linux-3.16.0-gentoo-x86_64-Intel-R-_Core-TM-2_Duo_CPU_T9500_@_2.60GHz-with-gentoo-2.2
KiB Mem:     3986612 total,     45604 free
KiB Swap:   12582908 total,  12268688 free
Timestamp of tree: Sun, 10 Aug 2014 08:00:01 +0000
ld GNU ld (GNU Binutils) 2.24
distcc 3.1 x86_64-pc-linux-gnu [disabled]
app-shells/bash:          4.2_p47
dev-java/java-config:     2.2.0
dev-lang/python:          2.7.8, 3.3.5-r1, 3.4.1
dev-util/cmake:           2.8.12.2-r1
dev-util/pkgconfig:       0.28-r2
sys-apps/baselayout:      2.2
sys-apps/openrc:          0.12.4
sys-apps/sandbox:         2.6-r1
sys-devel/autoconf:       2.13, 2.69
sys-devel/automake:       1.9.6-r3, 1.10.3, 1.11.6, 1.12.6, 1.14.1
sys-devel/binutils:       2.24-r3
sys-devel/gcc:            4.8.3
sys-devel/gcc-config:     1.8
sys-devel/libtool:        2.4.2-r1
sys-devel/make:           4.0-r1
sys-kernel/linux-headers: 3.16 (virtual/os-headers)
sys-libs/glibc:           2.19-r1
Repositories: gentoo sage-on-gentoo science sunrise x11 ago local g-cpan g-octave
Installed sets: @system
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="* -@EULA PUEL Intel-SDP dlj-1.1 skype-eula skype-4.0.0.7-copyright googleearth AdobeFlash-11.x cadsoft Oracle-BCLA-JavaSE MakeMKV-EULA NVIDIA-CUDA Nero-AAC-EULA GIMPS"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=native -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/config /usr/share/gnupg/qualified.txt /var/lib/hsqldb"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5.5/ext-active/ /etc/php/cgi-php5.5/ext-active/ /etc/php/cli-php5.5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c"
CXXFLAGS="-march=native -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FCFLAGS="-O2 -pipe"
FEATURES="assume-digests binpkg-logs config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync news parallel-fetch preserve-libs protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync xattr"
FFLAGS="-march=native -O2 -pipe"
GENTOO_MIRRORS="http://linux.rz.ruhr-uni-bochum.de/download/gentoo-mirror http://ftp-stud.fht-esslingen.de/pub/Mirrors/gentoo/ ftp://ftp.wh2.tu-dresden.de/pub/mirrors/gentoo ftp://sunsite.informatik.rwth-aachen.de/pub/Linux/gentoo ftp://ftp.tu-clausthal.de/pub/linux/gentoo ftp://ftp.easynet.nl/mirror/gentoo/ "
LANG="en_US.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --omit-dir-times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage_lynx"
PORTDIR_OVERLAY="/var/lib/layman/sage-on-gentoo /var/lib/layman/science /var/lib/layman/sunrise /var/lib/layman/x11 /var/lib/layman/ago /usr/local/portage /var/lib/cpan /var/lib/g-octave"
USE="64bit R X Xaw3d a52 aac acl acpi admin afs alsa amd64 ao apache2 apng applet archive armadillo arpack asf aspell atlas audacious audiofile automap automount bash-completion berkdb blas blast bluetooth bluray boost branding bzip2 cairo cdda cddb cdf cdio cdparanoia cdr cg cgi chm cli cmake consolekit cracklib crypt css cups curl cxx daap db dbi dbm dbus declarative designer devhelp device-mapper dga dia dirac djvu doc dot dri ds2490 ds9097 ds9097u dts dv dvb dvd dvdr dvi dynamicplugin eds egl elf emacs emboss emf encode epiphany evo examples exif expat extensions extra extras faac faad fam ffmpeg fftw firefox fits flac fltk fontconfig foomaticdb fortran fortran95 fpm fpx fuse g3dvl garmin gcj gd gdal gdbm gdu gedit geoip geolocation geos gfortran gif gimp git glade glib glpk gml gmp gnome gnome-keyring gnome-print gnuplot gnutls gold gphoto2 gpm grammar graphics graphtft graphviz grass gsl gsm gstreamer gtk gtk3 gudev guile hddtemp hdf hdf5 hdri html http httpd hvm hwdb iconv icq icu id3tag ide imagemagick imap inotify introspection ipod ipv6 irda ithreads jabber jadetex java java6 jbig jit john jpeg jpeg2k kate kdepim kdrive kerberos keymap kpathsea kvm ladspa lame lapack laptop latex lcms ldap lensfun libffi libkms libnotify libsamplerate lirc live lua lzma lzo mad mail maildir mapnik math matroska media-library mercurial mikmod mkl mmx mmxext mng mod modules mono motif mozilla mp3 mp4 mpeg mpi mplayer mtp multilib multimedia musepack musicbrainz mysql mysqli nautilus ncurses neXt netcdf netpbm network networking nfs nls nntp nptl nsplugin ntfs ntp numpy obex objc ocaml ocr octave odbc ofa ogdi ogg openexr opengl openmp openvg pam pango pcre pda pdf pdl2 perl plasma plotutils plugins png podcast policykit portaudio posix postgres postscript ppds preview-latex proj projectm pstricks pulseaudio python python-bindings q16 q32 qemu qhull qt3support qt4 quicktime raw readline reiserfs reports rle romio rpc rrdcgi rrdtool sage samba sasl schroedinger science sdk sdl secure-delete semantic-desktop server session shout sip slang slp smart smbclient smp sms sndfile snmp soap sockets sound soup sox speex spell sql sqlite sse sse2 sse4 ssl ssse3 startup-notification stlport subtitles subversion sudo suexec svg svm swig systemd szip t1lib tcl tcpd tex tex4ht texmacs theora thesaurus thinkpad threads thunderbird tidy tiff tk tools truetype udev udisks unicode upower usb utempter v4l vaapi vala valgrind vdpau video virt-network virtualbox visio vorbis vpx vtk wav webdav webdav-serf webkit wifi wmf wxwidgets x264 xa xattr xcb xetex xext xft xine xml xmlreader xmlrpc xpm xv xvid xvmc yaml youtube zlib zvbi" ABI_X86="64" ALSA_CARDS="intel8x0" APACHE2_MODULES="actions alias auth_basic auth_digest authn_anon authn_dbd authn_core authn_dbm authn_default authn_file authz_core authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgid dav dav_fs dav_lock dbd deflate dir disk_cache env expires ext_filter file_cache filter headers ident imagemap include info lbmethod_byrequests log_config logio mem_cache mime mime_magic negotiation proxy proxy_ajp proxy_balancer proxy_connect proxy_http rewrite setenvif slotmem_shm so socache_shmcb speling status unique_id unixd userdir usertrack vhost_alias" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump author" CAMERAS="canon fuji ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" CURL_SSL="nss" DRACUT_MODULES="caps lvm syslog" DVB_CARDS="usb-wt220u" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ublox ubx" INPUT_DEVICES="keyboard mouse evdev synaptics void" KERNEL="linux" LCD_DEVICES="cfontz hd44780 mtxorb ncurses X lcd2usb lcdlinux png usblcd" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LINGUAS="de fr ru" NETBEANS_MODULES="apisupport cnd dlight enterprise ergonomics groovy gsf harness ide identity j2ee java mobility nb php profiler websvccommon xml" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php5-3" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7 python3_3" QEMU_SOFTMMU_TARGETS="arm i386 x86_64" QEMU_USER_TARGETS="arm i386 x86_64" RUBY_TARGETS="ruby19 ruby20" USERLAND="GNU" VIDEO_CARDS="nouveau displaylink" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, SYNC, USE_PYTHON

=================================================================
                        Package Settings
=================================================================

app-emulation/libvirt-1.2.6 was built with the following:
USE="caps fuse libvirtd macvtap nfs nls policykit qemu sasl systemd udev vepa virt-network virtualbox -audit -avahi -firewalld -iscsi -lvm -lxc -numa -openvz -parted -pcap -phyp -rbd (-selinux) -uml -xen" ABI_X86="64"



Reproducible: Always
Comment 1 Matthias Maier gentoo-dev 2014-11-03 17:35:52 UTC
This looks like a misconfiguration in the SASL layer:

Aug 10 13:17:55 lynx libvirtd[16407]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql

If you do not use SASL for libvirtd, please build libvirt with USE="-sasl",
alternatively if you do not use dev-libs/cyrus-sasl, please build it with USE="-mysql" to get rid of the error message. Alternatively, configure sasl correctly.

If I'm mistaken, please reopen.
Comment 2 Juergen Rose 2014-11-03 18:59:52 UTC
cyrus-sasl is installed as dependency of
  app-admin/sudo-1.8.11_p2 (ldap ? dev-libs/cyrus-sasl)
  app-emulation/libvirt-1.2.9-r1 (sasl ? dev-libs/cyrus-sasl)
  app-emulation/qemu-2.1.2-r1 (sasl ? dev-libs/cyrus-sasl)
                              (sasl ? dev-libs/cyrus-sasl[static-libs(+)])
  dev-db/mongodb-2.6.4 (kerberos ? dev-libs/cyrus-sasl[kerberos])
  dev-lang/php-5.6.2 (ldap-sasl ? dev-libs/cyrus-sasl)
  dev-vcs/subversion-1.8.10-r1 (sasl ? dev-libs/cyrus-sasl)
  kde-base/kdepimlibs-4.14.2 (dev-libs/cyrus-sasl)
  mail-client/mutt-1.5.23-r4 (sasl ? >=dev-libs/cyrus-sasl-2)
  mail-mta/sendmail-8.14.9 (sasl ? >=dev-libs/cyrus-sasl-2.1.10)
  net-fs/autofs-5.1.0 (sasl ? dev-libs/cyrus-sasl)
  net-im/pidgin-2.10.10 (sasl ? dev-libs/cyrus-sasl:2)
  net-libs/gtk-vnc-0.5.3 (sasl ? dev-libs/cyrus-sasl)
  net-libs/ptlib-2.10.11 (sasl ? dev-libs/cyrus-sasl:2)
  net-misc/spice-gtk-0.25-r1 (sasl ? dev-libs/cyrus-sasl)
  net-nds/openldap-2.4.40-r2 (sasl ? dev-libs/cyrus-sasl)
                             (cxx ? dev-libs/cyrus-sasl)
  net-voip/ekiga-4.0.1 (ldap ? dev-libs/cyrus-sasl:2)


libvirt is installed as dependency of
  app-emulation/libvirt-glib-0.1.8 (>=app-emulation/libvirt-0.9.10)
  app-emulation/virt-manager-1.1.0 (>=app-emulation/libvirt-0.7.0[python(-),python_targets_python2_7(-)?,python_single_target_python2_7(+)?])
  app-emulation/virt-viewer-1.0 (>=app-emulation/libvirt-0.10.0[sasl?])
  dev-python/libvirt-python-1.2.9 (>=app-emulation/libvirt-0.9.6[-python(-)])


I do not know, what is more important, the sasl flag of libvirt or the mysql flag of cyrus-sasl. What do you mean with configuration of sasl, compile time or run time configuration? I have under /etc/sasl2 three files:
root@lynx:/root(22)# ll /etc/sasl2/
total 24
-rw-r--r-- 1 root root  1279 Nov  3 10:59 libvirt.conf
-rw-r----- 1 root mail 12288 Aug  4  2008 sasldb2
-rw-r--r-- 1 root root    68 Oct  7 15:00 Sendmail.conf
-rw-r--r-- 1 root root    50 Sep 10 11:48 Sendmail.conf~

libvirt.conf and sasldb2 are the original files from the installation (/etc/sasl2/sasldb2 is not identified by 'qfile -v'). 
root@lynx:/root(39)# file /etc/sasl2/sasldb2
/etc/sasl2/sasldb2: Berkeley DB (Hash, version 9, native byte-order)

I modified Sendmail.conf sometime by adding
sql_select: dummy .

If I add also "sql_select: dummy" to libvirt.conf and restart libvird, 'systemctl status libvirtd' now complains:
root@lynx:/root(34)# systemctl status libvirtd
● libvirtd.service - Virtualization daemon
   Loaded: loaded (/usr/lib64/systemd/system/libvirtd.service; disabled)
   Active: active (running) since Mon 2014-11-03 19:48:11 CET; 2s ago
     Docs: man:libvirtd(8)
           http://libvirt.org
 Main PID: 1249 (libvirtd)
   CGroup: /system.slice/libvirtd.service
           ├─1205 /usr/sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --dhcp-script=/usr/libexec/libvirt_leaseshelper
           ├─1206 /usr/sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --dhcp-script=/usr/libexec/libvirt_leaseshelper
           └─1249 /usr/sbin/libvirtd

Nov 03 19:48:11 lynx libvirtd[1249]: sql auxprop plugin using mysql engine
Nov 03 19:48:11 lynx systemd[1]: Started Virtualization daemon.
Nov 03 19:48:11 lynx libvirtd[1249]: libvirt version: 1.2.9
Nov 03 19:48:11 lynx libvirtd[1249]: unsupported configuration: Only the first console can be a serial port
Nov 03 19:48:11 lynx libvirtd[1249]: unsupported configuration: Only the first console can be a serial port

Is this adding of "sql_select: dummy" to libvirt.conf OK? And what about "unsupported configuration: Only the first console can be a serial port"?
I don't find any tty entry in /etc/libvirt/*
root@lynx:/root(36)# ll /etc/libvirt/
total 64
-rw-r--r-- 1 root root   518 Nov  3 10:59 libvirt.conf
-rw-r--r-- 1 root root 14384 Nov  3 10:59 libvirtd.conf
-rw-r--r-- 1 root root  2050 Nov  3 10:59 libvirt-guests.conf
drwxr-xr-x 2 root root  4096 Nov  3 10:59 nwfilter/
drwxr-xr-x 3 root root  4096 Jan 10  2013 qemu/
-rw-r--r-- 1 root root 18716 Nov  3 10:59 qemu.conf
-rw-r--r-- 1 root root  2169 Nov  3 10:59 qemu-lockd.conf
drwxr-xr-x 3 root root  4096 May 22  2009 storage/
-rw-r--r-- 1 root root  2134 Nov  3 10:59 virtlockd.conf

root@lynx:/root(41)# grep -i tty /etc/libvirt/libvirtd.conf 
root@lynx:/root(42)# 

Should I remove /etc/sasl2/sasldb2?
Comment 3 Matthias Maier gentoo-dev 2014-11-06 23:00:45 UTC
If you do not use SASL authentication for libvirt, you do not USE="sasl" for libvirt, just disable it.