Package: mysql-server-5.0
Version: 5.0.18-1
Severity: important
I don't know much about mysql, so I'm writing this from a naive user's
perspective. This may or may not be similar to what's described in
#330624 "Why does install not configure passwords?" -- I haven't yet
determined what the problem is.
I had mysql 4.1 installed and working, only because some stupid perl
script (not from a debian package) would only log to a mysql table;
everything was working fine, and I don't remember what I had to do
(if anything) after installing 4.1 to get it working, but that was
quite some time ago.
Tonight I upgraded from:
libmysqlclient14_4.1.15-1_i386.deb
libmysqlclient15_5.0.16-1_i386.deb
mysql-client-4.1_4.1.15-1_i386.deb
mysql-common_5.0.16-1_i386.deb
mysql-server-4.1_4.1.15-1_i386.deb
to:
ii libmysqlclient15 5.0.18-1 mysql database client library
ii mysql-client-4.1 5.0.18-1 empty transitional package
ii mysql-client-5.0 5.0.18-1 mysql database client binaries
ii mysql-common 5.0.18-1 mysql database common files (e.g.
/etc/mysql
ii mysql-server-4.1 5.0.18-1 empty transitional package
ii mysql-server-5.0 5.0.18-1 mysql database server binaries
In case it matters, I also have these installed (not changed tonight):
ii libdbd-mysql-perl 3.0002-2 A Perl5 database interface to the
MySQL data
ii libmysqlclient12 4.0.24-10sarge1 mysql database client library
During the postinst, and manually afterwards, mysql start fails as follows:
# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed or took more than 6s.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock'
exists!
syslog:
Jan 3 20:22:35 zona mysqld_safe[7369]: started
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 InnoDB: Started; log
sequence number 0 51804
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 [Note] Recovering after a
crash using /var/log/mysql/mysql-bin
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 [Note] Starting crash
recovery...
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 [Note] Crash recovery
finished.
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 [ERROR] Fatal error: Can't
open and lock privilege tables: Can't find file: 'host' (errno: 2)
Jan 3 20:22:36 zona mysqld_safe[7383]: ended
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]: ^G/usr/bin/mysqladmin: connect to
server at 'localhost' failed
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]: error: 'Can't connect to local
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]: Check that mysqld is running and
that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]:
During the upgrade, I had received the following "Install Hints"
warnings, and acted afterwards as described here:
On upgrades from MySQL 3.23, as shipped with Debian Woody, symlinks in
place of /var/lib/mysql or /var/log/mysql gets accidently removed and
have manually be restored.
Probably does not apply -- they're not symlinks and are valid directories:
# ls -lad /var/lib/mysql /var/log/mysql
drwxr-xr-x 5 mysql mysql 1024 Jan 3 22:44 /var/lib/mysql
drwxr-s--- 2 mysql adm 6144 Jan 3 22:44 /var/log/mysql
MySQL will only install if you have a non-numeric hostname that is
resolvable via the /etc/hosts file. E.g. if the "hostname" command returns
"myhostname" then there must be a line like "10.0.0.1 myhostname".
I didn't have such a line in my hosts file, but added one:
# hostname
zona
I tried adding '10.9.8.3 zona' (a valid ip address) and then changed
it to '127.0.0.1 zona', but in both cases mysql start still fails with
the same messages in the syslog. Because the above paragraph says
"MySQL will only install if..." I did 'apt-get install --reinstall
mysql-server-5.0', just to be sure, but it still fails in the same
way. (see "syslog from reinstall" below.)
A new mysql user "debian-sys-maint" will be created. This mysql account is
used in the start/stop and cron scripts. Don't delete.
# grep mysql /etc/passwd
mysql:x:100:104:MySQL Server:/var/lib/mysql:/bin/false
Please remember to set a PASSWORD for the MySQL root user! If you use a
/root/.my.cnf, always write the "user" and the "password" lines in there,
never only the password!
I have no /root/.my.cnf
See /usr/share/doc/mysql-server-5.0/README.Debian for more information.
syslog from reinstall:
Jan 3 23:18:40 zona mysqld_safe[11697]: PLEASE REMEMBER TO SET A PASSWORD FOR
THE MySQL root USER !
Jan 3 23:18:40 zona mysqld_safe[11697]: To do so, start the server, then issue
the following commands:
Jan 3 23:18:40 zona mysqld_safe[11697]: /usr/bin/mysqladmin -u root password
'new-password'
Jan 3 23:18:40 zona mysqld_safe[11697]: /usr/bin/mysqladmin -u root -h zona
password 'new-password'
Jan 3 23:18:40 zona mysqld_safe[11697]: See the manual for more instructions.
Jan 3 23:18:40 zona mysqld_safe[11697]:
Jan 3 23:18:40 zona mysqld_safe[11697]: NOTE: If you are upgrading from a
MySQL <= 3.22.10 you should run
Jan 3 23:18:40 zona mysqld_safe[11697]: the
/usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
Jan 3 23:18:40 zona mysqld_safe[11697]: able to use the new GRANT command!
Jan 3 23:18:40 zona mysqld_safe[11697]:
Jan 3 23:18:40 zona mysqld_safe[11697]: Please report any problems with the
/usr/bin/mysqlbug script!
Jan 3 23:18:40 zona mysqld_safe[11697]:
Jan 3 23:18:40 zona mysqld_safe[11697]: The latest information about MySQL is
available on the web at
Jan 3 23:18:40 zona mysqld_safe[11697]: http://www.mysql.com
Jan 3 23:18:40 zona mysqld_safe[11697]: Support MySQL by buying
support/licenses at https://order.mysql.com
Jan 3 23:18:41 zona mysqld_safe[11838]: started
Jan 3 23:18:42 zona mysqld[11841]: 060103 23:18:42 InnoDB: Started; log
sequence number 0 51804
Jan 3 23:18:42 zona mysqld[11841]: 060103 23:18:42 [ERROR] Fatal error: Can't
open and lock privilege tables: Can't find file: 'host' (errno: 2)
Jan 3 23:18:42 zona mysqld_safe[11861]: ended
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]: ^G/usr/bin/mysqladmin: connect
to server at 'localhost' failed
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]: error: 'Can't connect to local
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]: Check that mysqld is running and
that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]:
I tried a google search on that "Fatal error: Can't open and lock
privilege tables: Can't find file: 'host'" message, and got lots of
hits on "Can't find file: 'mysql.host'" -- is that the same file? --
but only a few on "host," none of which were helpful to me.
The things suggested in README.Debian (change the password? how?
where? what's the "correct" password?), run
mysql_fix_privilege_tables (fails with the same errors as described
above), don't help, or maybe I'm just too clueless to understand what
it wants me to do (particularly the change or set the password
instructions) -- does that even apply to the 4.1 - 5.0 upgrade?
(Most of the README.Debian seems to be talking about the 4.1 release,
not the 5.0 release; e.g. it warns against downgrading to 4.0. Can I
downgrade to 4.1? I didn't try, but will if you think I should.)
Please let me know what I should do or try, or what else you want to
know; I apologize for being so mysql-ignorant, but I'm sure I'm not
the only one ;)
Thanks.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable'), (400, 'testing'), (300, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14zona-06033se
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Versions of packages mysql-server-5.0 depends on:
ii adduser 3.80 Add and remove users and groups
ii debconf [debconf-2.0] 1.4.67 Debian configuration management sy
ii libc6 2.3.5-11 GNU C Library: Shared libraries an
ii libdbi-perl 1.48-2 Perl5 database interface by Tim Bu
ii libgcc1 1:4.0.2-5 GCC support library
ii libmysqlclient15 5.0.18-1 mysql database client library
ii libncurses5 5.5-1 Shared libraries for terminal hand
ii libreadline5 5.1-5 GNU readline and history libraries
ii libstdc++6 4.0.2-5 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra
ii mailutils [mailx] 1:0.6.90-3 GNU mailutils utilities for handli
ii mysql-client-5.0 5.0.18-1 mysql database client binaries
ii mysql-common 5.0.18-1 mysql database common files (e.g.
ii passwd 1:4.0.13-7 change and administer password and
ii perl 5.8.7-10 Larry Wall's Practical Extraction
ii psmisc 21.8-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.3-9 compression library - runtime
mysql-server-5.0 recommends no packages.
-- debconf information:
mysql-server-5.0/really_downgrade: false
mysql-server-5.0/start_on_boot: true
mysql-server-5.0/nis_warning:
mysql-server-5.0/postrm_remove_databases: false
* mysql-server-5.0/mysql_install_db_notes:
mysql-server-5.0/mysql_update_hints1:
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
