24 hours ago the default socket config was reverted back to /var/run/mysqld/mysqld.sock. But this is not the path the perltools use and `eselect mysql set x` doesn't symlink the socket yet. # mysql_setpermission Password for user to connect to MySQL: Can't make a connection to the mysql server. The error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld-401.sock' (2) at /usr/bin/mysql_setpermission line 70, <STDIN> line 1. # snippet /etc/mysql-401/my.cnf [client] #password = your_password port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] character-set-server = utf8 default-character-set = utf8 user = mysql port = 3306 socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld-401.pid log-error = /var/log/mysql-401/mysqld.err basedir = /usr datadir = /var/lib/mysql-401 # emerge info Gentoo Base System version 1.12.0_pre15 Portage 2.1_pre4-r1 (default-linux/x86/2005.1, gcc-3.4.5, glibc-2.3.6-r2, 2.6.15-gentoo-r1 i686) ================================================================= System uname: 2.6.15-gentoo-r1 i686 Pentium III (Coppermine) dev-lang/python: 2.4.2 sys-apps/sandbox: 1.2.17 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-r1 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r3 ACCEPT_KEYWORDS="x86 ~x86" ACCEPT_LICENSE="" ARCH="x86" AUTOCLEAN="yes" BASH_ENV="/etc/spork/is/not/valid/profile.env" CBUILD="i686-pc-linux-gnu" CFLAGS="-march=pentium3 -Os -pipe" CHOST="i686-pc-linux-gnu" CLEAN_DELAY="5" CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/kde/3/share/config /usr/share/X11/xkb /usr/share/config /var/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/splash /etc/terminfo /etc/env.d" CVS_RSH="ssh" CXXFLAGS="-march=pentium3 -Os -pipe" DCCC_PATH="/usr/lib/distcc/bin" DISTCC_LOG="" DISTCC_VERBOSE="0" DISTDIR="/usr/portage/distfiles" EDITOR="/bin/nano" ELIBC="glibc" EMERGE_WARNING_DELAY="10" FEATURES="autoconfig distlocks sandbox sfperms strict" FETCHCOMMAND="/usr/bin/wget -t 5 --passive-ftp -P ${DISTDIR} ${URI}" GCC_SPECS="" GDK_USE_XFT="1" GENTOO_MIRRORS="ftp://ftp.snt.utwente.nl/pub/os/linux/gentoo ftp://vlaai.snt.ipv6.utwente.nl/pub/os/linux/gentoo/ ftp://mirror.scarlet-internet.nl/pub/gentoo" G_BROKEN_FILENAMES="1" HOME="/root" HOSTNAME="freevo" INFOPATH="/usr/share/info:/usr/share/binutils-data/i686-pc-linux-gnu/2.16.1/info:/usr/share/gcc-data/i686-pc-linux-gnu/3.4.5/info" INPUT_DEVICES="keyboard mouse" KDEDIRS="/usr" KERNEL="linux" LANG="en_US.utf8" LC_ADDRESS="nl_NL.utf8" LC_COLLATE="nl_NL.utf8" LC_CTYPE="nl_NL.utf8" LC_IDENTIFICATION="nl_NL.utf8" LC_MEASUREMENT="nl_NL.utf8" LC_MESSAGES="en_US.utf8" LC_MONETARY="nl_NL.utf8" LC_NAME="nl_NL.utf8" LC_NUMERIC="nl_NL.utf8" LC_PAPER="nl_NL.utf8" LC_TELEPHONE="nl_NL.utf8" LC_TIME="nl_NL.utf8" LESS="-R -M --shift 5" LESSOPEN="|lesspipe.sh %s" LIRC_OPTS="--with-driver=serial" LOGNAME="root" LS_COLORS="no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:su=37;41:sg=30;43:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.qt=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.pdf=00;32:*.ps=00;32:*.txt=00;32:*.patch=00;32:*.diff=00;32:*.log=00;32:*.tex=00;32:*.doc=00;32:*.flac=01;35:*.mp3=01;35:*.mpc=00;36:*.ogg=00;36:*.wav=00;36:*.mid=00;36:*.midi=00;36:*.au=00;36:*.flac=00;36:*.aac=00;36:" MAKEOPTS="-j2" MANPATH="/usr/local/share/man:/usr/share/man:/usr/share/binutils-data/i686-pc-linux-gnu/2.16.1/man:/usr/share/gcc-data/i686-pc-linux-gnu/3.4.5/man:/usr/qt/3/doc/man" OPENGL_PROFILE="nvidia" PAGER="/usr/bin/less" PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/opt/bin:/usr/i686-pc-linux-gnu/gcc-bin/3.4.5:/usr/kde/3.5/sbin:/usr/kde/3.5/bin:/usr/qt/3/bin" PKGDIR="/usr/portage/packages" PORTAGE_ARCHLIST="ppc s390 amd64 ppc64 m68k arm sparc sh mips ia64 alpha ppc-macos hppa x86" PORTAGE_BINHOST_CHUNKSIZE="3000" PORTAGE_CALLER="emerge" PORTAGE_GID="250" PORTAGE_MASTER_PID="6071" PORTAGE_NICENESS="15" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/etc/portage/overlay" PRELINK_PATH="" PRELINK_PATH_MASK="/usr/lib/klibc" PWD="/root" PYTHONPATH="/usr/lib/portage/pym" QMAKESPEC="linux-g++" QTDIR="/usr/qt/3" RESUMECOMMAND="/usr/bin/wget -c -t 5 --passive-ftp -P ${DISTDIR} ${URI}" RPMDIR="/usr/portage/rpm" RSYNC_RETRIES="3" RSYNC_TIMEOUT="180" SHELL="/bin/bash" SHLVL="1" SYNC="rsync://rsync.nl.gentoo.org/gentoo-portage" TERM="xterm" USE="x86 X alsa apm avi bash-completion berkdb bitmap-fonts bzip2 crypt dvd eds emboss encode foomaticdb fortran gdbm gif gpm gstreamer gtk gtk2 imlib jpeg kde kdeenablefinal libg++ libwww lirc mad mikmod mmx motif mp3 mpeg ncurses nls ogg oggvorbis opengl pam pdflib perl png python qt quicktime readline sdl sqlite sse ssl tcpd tiff truetype truetype-fonts type1-fonts unicode vorbis xml2 xv zlib elibc_glibc input_devices_keyboard input_devices_mouse kernel_linux userland_GNU video_cards_nvidia" USER="root" USERLAND="GNU" USE_EXPAND="DVB_CARDS ELIBC FCDSL_CARDS FRITZCAPI_CARDS INPUT_DEVICES KERNEL LINGUAS USERLAND VIDEO_CARDS" USE_EXPAND_HIDDEN="" USE_ORDER="env:pkg:conf:defaults" VIDEO_CARDS="nvidia" XARGS="xargs -r" _="/usr/bin/emerge"
What's perltools?
oh sorry, reading back I see my report isn't that informative. It's about mysql's tools (which are written in perl) that are included with mysql. e.g. mysql_setpermission, mysql_secure_installation etc. my.cnf for mysql-4.1 changed the socketpath back to the old value /var/run/mysqld/mysqld.sock http://www.gentoo.org/cgi-bin/viewcvs.cgi/dev-db/mysql/files/my.cnf-4.1-r1?rev=1.3&view=log This breaks the tools that come with mysql, but will also break apps that use the socket path from the lib (which is set at compile time). # strings /usr/lib/mysql-500/libmysqlclient.so | grep mysqld /var/run/mysqld/mysqld-500.sock
Oops, got the wrong server for the lib path. But the result is the same ;) # strings /usr/lib/mysql-401/libmysqlclient.so | grep mysqld /var/run/mysqld/mysqld-401.sock
This is a mysql ebuild fault, the path for the default socket written in the config files has been reverted to it's default value, the hard-coded default path has been changed in a second moment. Now it should be ok, but be aware I've still no rev-bumbed (not forced a re-emerge of mysql), because there are other change I want to discuss and do with other devs before. I suggest to close this once the rev-bump is put in place.
mysql slotted has been retired, closing as fixed.
