Package: mysql-server Version: 4.0.23-4 Severity: normal If you try to start/restart mysql-server as root, and root has TMPDIR set to something not writable by the mysql user (eg if you are using libpam-tmpdir, so TMPDIR is typically /tmp/user/0 during a login session), then it fails to restart - you get errors like this:
Feb 9 09:56:00 pc14 mysqld[1673]: ^G/usr/sbin/mysqld: Can't create/write to file '/tmp/user/0/ibEfgTKh' (Errcode: 13) Feb 9 09:56:00 pc14 mysqld[1673]: 050209 9:56:00 InnoDB: Error: unable to create temporary file; errno: 13 Feb 9 09:56:00 pc14 mysqld[1673]: 050209 9:56:00 Can't init databases Feb 9 09:56:00 pc14 mysqld[1673]: 050209 9:56:00 Aborting Feb 9 09:56:00 pc14 mysqld[1673]: -- System Information: Debian Release: 3.1 APT prefers testing APT policy: (777, 'testing'), (33, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.10-ac12.piv Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Versions of packages mysql-server depends on: ii adduser 3.59 Add and remove users and groups ii debconf 1.4.30.11 Debian configuration management sy ii libc6 2.3.2.ds1-20 GNU C Library: Shared libraries an ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu ii libmysqlclient12 4.0.23-4 mysql database client library ii libstdc++5 1:3.3.5-5 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-6 Wietse Venema's TCP wrappers libra ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent ii mysql-client 4.0.23-4 mysql database client binaries ii mysql-common 4.0.23-4 mysql database common files (e.g. ii passwd 1:4.0.3-30.8 Change and administer password and ii perl 5.8.4-6 Larry Wall's Practical Extraction ii psmisc 21.5-1 Utilities that use the proc filesy ii zlib1g 1:1.2.2-3 compression library - runtime -- debconf information: mysql-server/skip_networking: false mysql-server/really_downgrade_from_41: false mysql-server/want_chroot: false * mysql-server/start_on_boot: true mysql-server/postrm_remove_databases: false * mysql-server/mysql_install_db_notes: mysql-server/nis_warning: mysql-server/mysql_update_hints1: * mysql-server/postrm_remove_database: false mysql-server/fix_privileges_warning: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
