Bug#663000: [debian-mysql] Bug#663000: mysql-server: MySQL fails to start after 5.1.61 upgrade, incorrect permissions
Hey Clint, Unfortunately there are no symlinks regarding those. Just to note that it wasn't all /var/lib/mysql/mysql-bin.* files that had incorrect permissions, only a few (the latest that it would have generated). Maybe there is some kind of race condition between MySQL stopping and the postinst file running? I can't replicate it any more, because I worked around it by running while true; do chown mysql:mysql /var/lib/mysql/mysql-bin.*; sleep 0.1; done in another shell whilst I was doing apt-get upgrade. Would it also not be best to change chown -R mysql $mysql_statedir to include setting the group to mysql too? It's an odd one that's for sure, but easily workaround-able. Thanks On 9 March 2012 07:51, Clint Byrum cl...@ubuntu.com wrote: Excerpts from Alex Cartwright's message of Thu Mar 08 13:00:23 -0800 2012: Is there any more information that I can provide to help debug this? I was talking with someone in #debian irc.freenode.net earlier on today and they had the same problem. They resolved it by managing to chown said files just before it tried to start MySQL again. Right now I'm not sure what extra info I can get for you. Alex, I'm kind of at a loss for how this is happening. The postinst directly calls this code on configuring mysql-server-5.1: mysql_statedir=/var/lib/mysql ... chown -R mysql $mysql_statedir So you can see where the fact that the binlogs are being chown'ed to root is rather confusing! There is one chown that might lead to this: mysql_datadir=/usr/share/mysql chown -R 0:0 $mysql_datadir Perhaps there are links in /usr/share/mysql to your binlogs? Also is it possible /var/lib/mysql is a symlink? Regards On 7 March 2012 23:44, Clint Byrum cl...@ubuntu.com wrote: Excerpts from Alex Cartwright's message of Wed Mar 07 13:32:44 -0800 2012: Package: mysql-server Version: 5.1.61-0+squeeze1 Severity: important After the recent security upgrade to MySQL 5.1.61, MySQL failed to start during the apt-get update apt-get upgrade process due to incorrect permissions being set on the /var/lib/mysql/mysql-bin.* files. Instead of being mysql:mysql they were set to root:root, causing MySQL to fail starting with errors such as: Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Failed to open log (file './mysql-bin.000397', errno 13) Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Could not open log file Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Can't init tc log Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Aborting Changing the owner/group to mysql:mysql manually and starting the mysql service got things working, however running update upgrade again causes the issue again. Hi Alex, sorry this is causing you trouble. I was not able to reproduce this in a clean squeeze chroot: (squeeze-amd64)root@clint-MacBookPro:/home/clint# ls -l /var/lib/mysql total 20532 -rw-r--r-- 1 root root 0 Mar 7 15:36 debian-5.1.flag -rw-rw 1 mysql mysql 5242880 Mar 7 15:37 ib_logfile0 -rw-rw 1 mysql mysql 5242880 Mar 7 15:36 ib_logfile1 -rw-rw 1 mysql mysql 10485760 Mar 7 15:37 ibdata1 drwx-- 2 mysql root 4096 Mar 7 15:37 mysql -rw--- 1 root root 6 Mar 7 15:37 mysql_upgrade_info -rw-rw 1 mysql mysql 37810 Mar 7 15:37 mysqld-bin.01 -rw-rw 1 mysql mysql 20 Mar 7 15:37 mysqld-bin.index (squeeze-amd64)root@clint-MacBookPro:/home/clint# apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be upgraded: libmysqlclient16 mysql-client-5.1 mysql-common mysql-server-5.1 mysql-server-core-5.1 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 22.8 MB of archives. After this operation, 307 kB disk space will be freed. Do you want to continue [Y/n]? Get:1 http://security.debian.org/ squeeze/updates/main mysql-common all 5.1.61-0+squeeze1 [69.6 kB] Get:2 http://security.debian.org/ squeeze/updates/main libmysqlclient16 amd64 5.1.61-0+squeeze1 [1976 kB] Get:3 http://security.debian.org/ squeeze/updates/main mysql-client-5.1 amd64 5.1.61-0+squeeze1 [10.0 MB] Get:4 http://security.debian.org/ squeeze/updates/main mysql-server-5.1 amd64 5.1.61-0+squeeze1 [6587 kB] Get:5 http://security.debian.org/ squeeze/updates/main mysql-server-core-5.1 amd64 5.1.61-0+squeeze1 [4130 kB] Fetched 22.8 MB in 15s (1432 kB/s) Preconfiguring packages ... (Reading database ... 12360 files and directories currently installed.) Preparing to replace mysql-common 5.1.49-3 (using .../mysql-common_5.1.61-0+squeeze1_all.deb) ... Unpacking replacement mysql-common ... Preparing to replace libmysqlclient16 5.1.49-3 (using .../libmysqlclient16_5.1.61-0+squeeze1_amd64.deb) ... Unpacking replacement libmysqlclient16 ... Preparing
Bug#663000: [debian-mysql] Bug#663000: mysql-server: MySQL fails to start after 5.1.61 upgrade, incorrect permissions
Is there any more information that I can provide to help debug this? I was talking with someone in #debian irc.freenode.net earlier on today and they had the same problem. They resolved it by managing to chown said files just before it tried to start MySQL again. Right now I'm not sure what extra info I can get for you. Regards On 7 March 2012 23:44, Clint Byrum cl...@ubuntu.com wrote: Excerpts from Alex Cartwright's message of Wed Mar 07 13:32:44 -0800 2012: Package: mysql-server Version: 5.1.61-0+squeeze1 Severity: important After the recent security upgrade to MySQL 5.1.61, MySQL failed to start during the apt-get update apt-get upgrade process due to incorrect permissions being set on the /var/lib/mysql/mysql-bin.* files. Instead of being mysql:mysql they were set to root:root, causing MySQL to fail starting with errors such as: Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Failed to open log (file './mysql-bin.000397', errno 13) Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Could not open log file Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Can't init tc log Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Aborting Changing the owner/group to mysql:mysql manually and starting the mysql service got things working, however running update upgrade again causes the issue again. Hi Alex, sorry this is causing you trouble. I was not able to reproduce this in a clean squeeze chroot: (squeeze-amd64)root@clint-MacBookPro:/home/clint# ls -l /var/lib/mysql total 20532 -rw-r--r-- 1 root root 0 Mar 7 15:36 debian-5.1.flag -rw-rw 1 mysql mysql 5242880 Mar 7 15:37 ib_logfile0 -rw-rw 1 mysql mysql 5242880 Mar 7 15:36 ib_logfile1 -rw-rw 1 mysql mysql 10485760 Mar 7 15:37 ibdata1 drwx-- 2 mysql root 4096 Mar 7 15:37 mysql -rw--- 1 root root 6 Mar 7 15:37 mysql_upgrade_info -rw-rw 1 mysql mysql 37810 Mar 7 15:37 mysqld-bin.01 -rw-rw 1 mysql mysql 20 Mar 7 15:37 mysqld-bin.index (squeeze-amd64)root@clint-MacBookPro:/home/clint# apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be upgraded: libmysqlclient16 mysql-client-5.1 mysql-common mysql-server-5.1 mysql-server-core-5.1 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 22.8 MB of archives. After this operation, 307 kB disk space will be freed. Do you want to continue [Y/n]? Get:1 http://security.debian.org/ squeeze/updates/main mysql-common all 5.1.61-0+squeeze1 [69.6 kB] Get:2 http://security.debian.org/ squeeze/updates/main libmysqlclient16 amd64 5.1.61-0+squeeze1 [1976 kB] Get:3 http://security.debian.org/ squeeze/updates/main mysql-client-5.1 amd64 5.1.61-0+squeeze1 [10.0 MB] Get:4 http://security.debian.org/ squeeze/updates/main mysql-server-5.1 amd64 5.1.61-0+squeeze1 [6587 kB] Get:5 http://security.debian.org/ squeeze/updates/main mysql-server-core-5.1 amd64 5.1.61-0+squeeze1 [4130 kB] Fetched 22.8 MB in 15s (1432 kB/s) Preconfiguring packages ... (Reading database ... 12360 files and directories currently installed.) Preparing to replace mysql-common 5.1.49-3 (using .../mysql-common_5.1.61-0+squeeze1_all.deb) ... Unpacking replacement mysql-common ... Preparing to replace libmysqlclient16 5.1.49-3 (using .../libmysqlclient16_5.1.61-0+squeeze1_amd64.deb) ... Unpacking replacement libmysqlclient16 ... Preparing to replace mysql-client-5.1 5.1.49-3 (using .../mysql-client-5.1_5.1.61-0+squeeze1_amd64.deb) ... Unpacking replacement mysql-client-5.1 ... Setting up mysql-common (5.1.61-0+squeeze1) ... (Reading database ... 12361 files and directories currently installed.) Preparing to replace mysql-server-5.1 5.1.49-3 (using .../mysql-server-5.1_5.1.61-0+squeeze1_amd64.deb) ... invoke-rc.d: policy-rc.d denied execution of stop. invoke-rc.d: policy-rc.d denied execution of stop. df: Warning: cannot read table of mounted file systems: No such file or directory Unpacking replacement mysql-server-5.1 ... Preparing to replace mysql-server-core-5.1 5.1.49-3 (using .../mysql-server-core-5.1_5.1.61-0+squeeze1_amd64.deb) ... Unpacking replacement mysql-server-core-5.1 ... Setting up libmysqlclient16 (5.1.61-0+squeeze1) ... Setting up mysql-client-5.1 (5.1.61-0+squeeze1) ... Setting up mysql-server-core-5.1 (5.1.61-0+squeeze1) ... Setting up mysql-server-5.1 (5.1.61-0+squeeze1) ... invoke-rc.d: policy-rc.d denied execution of stop. invoke-rc.d: policy-rc.d denied execution of start. (squeeze-amd64)root@clint-MacBookPro:/home/clint# ls -l /var/lib/mysql total 21288 -rw-r--r-- 1 mysql mysql 0 Mar 7 15:38 debian-5.1.flag -rw-rw 1 mysql mysql 5242880 Mar 7 15:39 ib_logfile0 -rw-rw 1 mysql mysql 5242880 Mar 7 15:36 ib_logfile1 -rw-rw 1 mysql mysql 10485760 Mar 7 15:39 ibdata1 drwx-- 2
Bug#663000: mysql-server: MySQL fails to start after 5.1.61 upgrade, incorrect permissions
Package: mysql-server Version: 5.1.61-0+squeeze1 Severity: important After the recent security upgrade to MySQL 5.1.61, MySQL failed to start during the apt-get update apt-get upgrade process due to incorrect permissions being set on the /var/lib/mysql/mysql-bin.* files. Instead of being mysql:mysql they were set to root:root, causing MySQL to fail starting with errors such as: Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Failed to open log (file './mysql-bin.000397', errno 13) Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Could not open log file Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Can't init tc log Mar 7 20:52:37 lon1 mysqld_safe[16756]: 120307 20:52:37 [ERROR] Aborting Changing the owner/group to mysql:mysql manually and starting the mysql service got things working, however running update upgrade again causes the issue again. -- System Information: Debian Release: 6.0.4 APT prefers stable APT policy: (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 3.0.18-x86_64-linode24 (SMP w/4 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages mysql-server depends on: pn mysql-server-5.1 none (no description available) mysql-server recommends no packages. mysql-server suggests no packages. -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#612920: chpasswd fails for LDAP users
On Friday 11 February 2011 16:19:03 you wrote: On Fri, 2011-02-11 at 15:04 +, Alex Cartwright wrote: When trying to change a user account password using chpasswd that is stored in LDAP it fails, where as changing it with passwd works just fine. $ echo foobar:qwerty | sudo chpasswd chpasswd: (user foobar) pam_chauthtok() failed, error: Authentication token manipulation error chpasswd: (line 1, user foobar) password not changed Could you include the information from the PAM module (from /var/log/auth.log) and nslcd (/var/log/syslog)? For libpam-ldapd there are basically two different modes for changing a password: - by the user: for this you need the old and the new password - by the system administrator: for this you need the administrator password that matches the rootpwmoddn option (and the new password) With nss-pam-ldapd 0.8 and there is also a rootpwmodpw option to allow changing a password by the administrator without prompting for the administrator password. /var/log/auth.log: Feb 12 11:04:47 s0 chpasswd[2680]: pam_unix(chpasswd:chauthtok): user foobar does not exist in /etc/passwd /var/log/syslog: Feb 12 11:04:47 s0 nslcd[1205]: [fff902] : invalid user name I take it then for Squeeze, which has 0.7.13 there is no chance of this being fixed? -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#612920: chpasswd fails for LDAP users
Subject: libpam-ldapd: chpasswd fails with LDAP accounts Package: libpam-ldapd Version: 0.7.13 Severity: normal *** Please type your report below this line *** When trying to change a user account password using chpasswd that is stored in LDAP it fails, where as changing it with passwd works just fine. $ echo foobar:qwerty | sudo chpasswd chpasswd: (user foobar) pam_chauthtok() failed, error: Authentication token manipulation error chpasswd: (line 1, user foobar) password not changed -- System Information: Debian Release: 6.0 APT prefers stable APT policy: (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 2.6.32-5-amd64 (SMP w/4 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages libpam-ldapd depends on: ii debconf [debconf-2.0] 1.5.36.1 Debian configuration management sy ii libc6 2.11.2-10 Embedded GNU C Library: Shared lib ii libpam-runtime1.1.1-6.1 Runtime support for the PAM librar ii libpam0g 1.1.1-6.1 Pluggable Authentication Modules l ii nslcd 0.7.13 Daemon for NSS and PAM lookups usi libpam-ldapd recommends no packages. libpam-ldapd suggests no packages. -- debconf information: libpam-ldapd/enable_shadow: true -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#610971: ldapscripts states it will use /etc/pam_ldap.conf, does not exist
Package: ldapscripts Version: 1.9.0-2 Severity: important I have installed libpam-ldapd and ldapscripts, and in the configuration file for ldapscripts (/etc/ldascripts/ldascripts.conf) it states that it will use the values in /etc/pam_ldap.conf. The trouble is this file does not exist, and I can't use the LDAP scripts without manually configuring it. -- System Information: Debian Release: 6.0 APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.32-5-686 (SMP w/1 CPU core) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages ldapscripts depends on: ii ldap-utils2.4.23-7 OpenLDAP utilities Versions of packages ldapscripts recommends: ii sharutils 1:4.9-1shar, unshar, uuencode, uudecode Versions of packages ldapscripts suggests: pn libpam-ldap none (no description available) -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#605708: mc: SFTP on non-standard SSH port freezes
Package: mc Version: 2:4.6.2~git20080311-4 Severity: normal When trying to create a new 'Shell Link' to an SFTP host on a non-standard SSH port (read, other than port 22) MC freezes while connecting. The string I am entering in when prompted for the host is 'u...@host:port'. Once I hit enter the expected behaviour is to connect and then prompt for the password (this is what it does on my Arch Linux install). However, looking at the SFTP hosts /var/log/auth.log there is no even an attempted connection. -- System Information: Debian Release: 5.0.7 APT prefers stable APT policy: (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 2.6.26-2-amd64 (SMP w/2 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages mc depends on: ii libc6 2.7-18lenny6 GNU C Library: Shared libraries ii libglib2.0-02.16.6-3 The GLib library of C routines ii libgpm2 1.20.4-3.1 General Purpose Mouse - shared lib ii libslang2 2.1.3-3 The S-Lang programming library - r mc recommends no packages. Versions of packages mc suggests: pn arj none (no description available) ii bzip21.0.5-1+lenny1 high-quality block-sorting file co pn dbview none (no description available) ii file 4.26-1 Determines file type using magic ii lynx 2.8.7dev9-2.1 Text-mode WWW Browser (transitiona ii mime-support 3.44-1 MIME files 'mime.types' 'mailcap pn odt2txt none (no description available) ii perl 5.10.0-19lenny2 Larry Wall's Practical Extraction ii unzip5.52-12 De-archiver for .zip files ii w3m 0.5.2-2+lenny1 WWW browsable pager with excellent pn xpdf none (no description available) ii zip 2.32-1 Archiver for .zip files -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org