New install of mysql-4.1.20 on a stable x86 machine does not work. # /etc/init.d/mysql start * Re-caching dependency info (mtimes differ)... * Stopping mysql ... /etc/init.d/mysql: line 332: /var/run/mysqld/mysqld.pid: No such file or directory * Stopping mysqld (0) [ ok ] * Re-caching dependency info (mtimes differ)... * Re-caching dependency info (mtimes differ)... * Re-caching dependency info (mtimes differ)... * Re-caching dependency info (mtimes differ)... * ... * Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" * it will be removed now and re-created by the MySQL server * BUT please make your checks. * Starting mysql (/etc/mysql/my.cnf) [ ok ] So mysql starts ok, but dies right after as shown by /var/log/mysql/mysqld.err: 060601 12:34:33 [ERROR] bdb: //srv/localhost/mysql/datadir: Permission denied 060601 12:34:33 [ERROR] bdb: //srv/localhost/mysql/datadir/log.0000000001: Permission denied 060601 12:34:33 [ERROR] bdb: PANIC: Permission denied 060601 12:34:33 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 060601 12:34:33 [ERROR] bdb: fatal region error detected; run recovery 060601 12:34:33 [ERROR] bdb: //srv/localhost/mysql/datadir: Permission denied 060601 12:34:34 InnoDB: Started; log sequence number 0 43634 060601 12:34:34 [ERROR] Can't init databases 060601 12:34:34 [ERROR] Aborting 060601 12:34:34 InnoDB: Starting shutdown... 060601 12:34:36 InnoDB: Shutdown completed; log sequence number 0 43634 060601 12:34:36 [Note] /usr/sbin/mysqld: Shutdown complete Same results with mysql-4.1.19. Changing database permissions to 777 and mysql:mysql didn't help.
# emerge --info Portage 2.0.54 (default-linux/x86/2005.1, gcc-3.4.5, glibc-2.3.5-r3, 2.6.14-hardened-r5 i686) ================================================================= System uname: 2.6.14-hardened-r5 i686 Intel(R) Pentium(R) 4 CPU 3.20GHz Gentoo Base System version 1.6.14 ccache version 2.3 [enabled] dev-lang/python: 2.3.5-r2, 2.4.2 dev-python/pycrypto: [Not Present] dev-util/ccache: 2.3 dev-util/confcache: [Not Present] sys-apps/sandbox: 1.2.12 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 sys-devel/libtool: 1.5.22 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-march=pentium4 -O3 -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-march=pentium4 -O3 -pipe" DISTDIR="/mnt/distfiles" FEATURES="autoconfig buildpkg ccache distlocks fixpackages sandbox sfperms strict userpriv" GENTOO_MIRRORS="http://adelie.polymtl.ca/ ftp://cs.ubishops.ca/pub/gentoo ftp://ftp.ussg.iu.edu/pub/linux/gentoo" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" SYNC="rsync://mirror.iat.sfu.ca/gentoo-portage" USE="x86 acpi apache2 berkdb bzip2 crypt dba expat gd gdbm gif imap innodb ipv6 jpeg ldap mmx mpm-worker mysql mysqli ncurses nls pam pcre perl php png python readline session slp snmp srvdir sse ssl tcpd threads truetype usb userlocales utf8 vhosts xml xml2 zlib userland_GNU kernel_linux elibc_glibc" Unset: CTARGET, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS, PORTAGE_RSYNC_OPTS, PORTDIR_OVERLAY
Closing bug. It turns out the machine did have a previous mysql-4.0 install which might possibly have an effect of killing mysql 4.1 on startup; I did try the gentoo upgrade guide from 4.0-4.1 (which didn't work) The machine has been wiped and a clean install of gentoo + mysql-4.1 works great.
