[debian-mysql] Bug#687315: /usr/sbin/mysqld: Upgrade to SQUEEZE results in wrong gid for mysql user

[Ronny Adsetts]

Package: mysql-server-core-5.1
Version: 5.1.63-0+squeeze1
Severity: normal
File: /usr/sbin/mysqld


Hi,

Just debugging why creation of temporary tables fails following an upgrade to
SQUEEZE. Turns out that the mysql user record is wrong

Running SQL like "CREATE TABLE blah SELECT * FROM fred" results in an error
similar to:
Can't create file './chill at 002dtmp/contact.frm' (errno: 9)

Checking the ownership of the temp file showed:

drwx------   2 mysql crontab     4096 Sep 11 17:04 chill at 002dtmp

Checking the user shows the problem:

# id mysql
uid=106(mysql) gid=101(crontab) groups=101(crontab)

Fixing the gid field in /etc/passwd fixes the problem.

Google shows other people having a similar problem (though possibly unrelated) 
so hopefully this helps document the issue. I suspect the problem has been
fixed long ago.

Thanks.

Ronny

-- System Information:
Debian Release: 6.0.5
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable'), (1, 'experimental')
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 mysql-server-core-5.1 depends on:
ii  libc6                   2.11.3-3         Embedded GNU C Library: Shared lib
ii  libgcc1                 1:4.4.5-8        GCC support library
ii  libstdc++6              4.4.5-8          The GNU Standard C++ Library v3
ii  libwrap0                7.6.q-19         Wietse Venema's TCP wrappers libra
ii  zlib1g                  1:1.2.3.4.dfsg-3 compression library - runtime

mysql-server-core-5.1 recommends no packages.

mysql-server-core-5.1 suggests no packages.

-- no debconf information