[debian-mysql] Bug#694390: mysql-server-5.1: failure to install w/ apt-get
Hugh Esco
hesco at campaignfoundations.com
Mon Nov 26 00:01:29 UTC 2012
Package: mysql-server-5.1
Version: 5.1.49-3
Severity: normal
Tags: d-i
$ sudo apt-get install mysql-server-5.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
Suggested packages:
tinyca
The following NEW packages will be installed:
mysql-server-5.1
0 upgraded, 1 newly installed, 0 to remove and 45 not upgraded.
Need to get 0 B/6,528 kB of archives.
After this operation, 14.3 MB of additional disk space will be used.
Preconfiguring packages ...
Selecting previously deselected package mysql-server-5.1.
(Reading database ... 196158 files and directories currently installed.)
Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.49-3_i386.deb) ...
Processing triggers for man-db ...
Setting up mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
121125 18:47:38 [Note] Plugin 'FEDERATED' is disabled.
121125 18:47:38 InnoDB: Started; log sequence number 0 44233
121125 18:47:38 InnoDB: Starting shutdown...
121125 18:47:44 InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
configured to not write apport reports
Errors were encountered while processing:
mysql-server-5.1
E: Sub-process /usr/bin/dpkg returned an error code (1)
----------------------------------------
/var/log/syslog --
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL r
oot USER !
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: To do so, start the server,
then issue the follow
ing commands:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: /usr/bin/mysqladmin -u root
password 'new-passwor
d'
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: /usr/bin/mysqladmin -u root
-h debianmarcus9 pass
word 'new-password'
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: Alternatively you can run:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
/usr/bin/mysql_secure_installation
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: which will also give you the
option of removing the test
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: databases and anonymous user
created by default. This is
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: strongly recommended for
production servers.
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: See the manual for more
instructions.
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]: Please report any problems
with the /usr/scripts/mysqlbug script!
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29460]:
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29506]: 121125 18:45:46 [Note] Plugin
'FEDERATED' is disabled.
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29506]: 121125 18:45:46 InnoDB:
Started; log sequence number 0 44233
Nov 25 18:45:46 debianmarcus9 mysqld_safe[29506]: 121125 18:45:46 InnoDB:
Starting shutdown...
Nov 25 18:45:51 debianmarcus9 mysqld_safe[29506]: 121125 18:45:51 InnoDB:
Shutdown completed; log sequence number 0 44233
Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: 121125 18:45:51 [Note] Plugin
'FEDERATED' is disabled.
Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: 121125 18:45:51 InnoDB:
Started; log sequence number 0 44233
Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: ERROR: 1064 You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'ALTER TABLE user ADD column
Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: 121125 18:45:51 [ERROR]
Aborting
Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]:
Nov 25 18:45:51 debianmarcus9 mysqld_safe[29525]: 121125 18:45:51 InnoDB:
Starting shutdown...
Nov 25 18:45:56 debianmarcus9 mysqld_safe[29525]: 121125 18:45:56 InnoDB:
Shutdown completed; log sequence number 0 44233
Nov 25 18:45:56 debianmarcus9 mysqld_safe[29525]: 121125 18:45:56 [Note]
/usr/sbin/mysqld: Shutdown complete
Nov 25 18:45:56 debianmarcus9 mysqld_safe[29525]:
Nov 25 18:45:56 debianmarcus9 mysqld_safe[29540]: 121125 18:45:56 [Note] Plugin
'FEDERATED' is disabled.
Nov 25 18:45:56 debianmarcus9 mysqld_safe[29540]: 121125 18:45:56 InnoDB:
Started; log sequence number 0 44233
Nov 25 18:45:56 debianmarcus9 mysqld_safe[29540]: 121125 18:45:56 InnoDB:
Starting shutdown...
Nov 25 18:46:02 debianmarcus9 mysqld_safe[29540]: 121125 18:46:02 InnoDB:
Shutdown completed; log sequence number 0 44233
Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: 121125 18:46:02 [Note] Plugin
'FEDERATED' is disabled.
Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: 121125 18:46:02 InnoDB:
Started; log sequence number 0 44233
Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: ERROR: 1050 Table 'plugin'
already exists
Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: 121125 18:46:02 [ERROR]
Aborting
Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]:
Nov 25 18:46:02 debianmarcus9 mysqld_safe[29555]: 121125 18:46:02 InnoDB:
Starting shutdown...
Nov 25 18:46:07 debianmarcus9 mysqld_safe[29555]: 121125 18:46:07 InnoDB:
Shutdown completed; log sequence number 0 44233
Nov 25 18:46:07 debianmarcus9 mysqld_safe[29555]: 121125 18:46:07 [Note]
/usr/sbin/mysqld: Shutdown complete
Nov 25 18:46:07 debianmarcus9 mysqld_safe[29555]:
Nov 25 18:46:07 debianmarcus9 mysqld_safe: Starting mysqld daemon with
databases from /var/lib/mysql
Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [Note] Plugin 'FEDERATED'
is disabled.
Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 InnoDB: Started; log
sequence number 0 44233
Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [ERROR] Can't start
server: Bind on TCP/IP port: Address already in use
Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [ERROR] Do you already
have another mysqld server running on port: 3306 ?
Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 [ERROR] Aborting
Nov 25 18:46:07 debianmarcus9 mysqld:
Nov 25 18:46:07 debianmarcus9 mysqld: 121125 18:46:07 InnoDB: Starting
shutdown...
Nov 25 18:46:12 debianmarcus9 mysqld: 121125 18:46:12 InnoDB: Shutdown
completed; log sequence number 0 44233
Nov 25 18:46:12 debianmarcus9 mysqld: 121125 18:46:12 [Note] /usr/sbin/mysqld:
Shutdown complete
Nov 25 18:46:12 debianmarcus9 mysqld:
Nov 25 18:46:12 debianmarcus9 mysqld_safe: mysqld from pid file
/var/run/mysqld/mysqld.pid ended
Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]:
#007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 25 18:46:21 debianmarcus9 /etc/init.d/mysql[29889]:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: To do so, start the server,
then issue the following commands:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: /usr/bin/mysqladmin -u root
password 'new-password'
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: /usr/bin/mysqladmin -u root
-h debianmarcus9 password 'new-password'
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: Alternatively you can run:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
/usr/bin/mysql_secure_installation
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: which will also give you the
option of removing the test
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: databases and anonymous user
created by default. This is
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: strongly recommended for
production servers.
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]: See the manual for more
instructions.
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30171]:
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30216]: 121125 18:47:33 [Note] Plugin
'FEDERATED' is disabled.
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30216]: 121125 18:47:33 InnoDB:
Started; log sequence number 0 44233
Nov 25 18:47:33 debianmarcus9 mysqld_safe[30216]: 121125 18:47:33 InnoDB:
Starting shutdown...
Nov 25 18:47:38 debianmarcus9 mysqld_safe[30216]: 121125 18:47:38 InnoDB:
Shutdown completed; log sequence number 0 44233
Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: 121125 18:47:44 [Note] Plugin
'FEDERATED' is disabled.
Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: 121125 18:47:44 InnoDB:
Started; log sequence number 0 44233
Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: ERROR: 1064 You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'ALTER TABLE user ADD column
Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: 121125 18:47:44 [ERROR]
Aborting
Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]:
Nov 25 18:47:44 debianmarcus9 mysqld_safe[30248]: 121125 18:47:44 InnoDB:
Starting shutdown...
Nov 25 18:47:49 debianmarcus9 mysqld_safe[30248]: 121125 18:47:49 InnoDB:
Shutdown completed; log sequence number 0 44233
Nov 25 18:47:49 debianmarcus9 mysqld_safe[30248]: 121125 18:47:49 [Note]
/usr/sbin/mysqld: Shutdown complete
Nov 25 18:47:49 debianmarcus9 mysqld_safe[30248]:
Nov 25 18:47:49 debianmarcus9 mysqld_safe[30263]: 121125 18:47:49 [Note] Plugin
'FEDERATED' is disabled.
Nov 25 18:47:49 debianmarcus9 mysqld_safe[30263]: 121125 18:47:49 InnoDB:
Started; log sequence number 0 44233
Nov 25 18:47:49 debianmarcus9 mysqld_safe[30263]: 121125 18:47:49 InnoDB:
Starting shutdown...
Nov 25 18:47:54 debianmarcus9 mysqld_safe[30263]: 121125 18:47:54 InnoDB:
Shutdown completed; log sequence number 0 44233
Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: 121125 18:47:54 [Note] Plugin
'FEDERATED' is disabled.
Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: 121125 18:47:54 InnoDB:
Started; log sequence number 0 44233
Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: ERROR: 1050 Table 'plugin'
already exists
Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: 121125 18:47:54 [ERROR]
Aborting
Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]:
Nov 25 18:47:54 debianmarcus9 mysqld_safe[30278]: 121125 18:47:54 InnoDB:
Starting shutdown...
Nov 25 18:47:59 debianmarcus9 mysqld_safe[30278]: 121125 18:47:59 InnoDB:
Shutdown completed; log sequence number 0 44233
Nov 25 18:47:59 debianmarcus9 mysqld_safe[30278]: 121125 18:47:59 [Note]
/usr/sbin/mysqld: Shutdown complete
Nov 25 18:47:59 debianmarcus9 mysqld_safe[30278]:
Nov 25 18:48:00 debianmarcus9 mysqld_safe: Starting mysqld daemon with
databases from /var/lib/mysql
Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 [Note] Plugin 'FEDERATED'
is disabled.
Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 InnoDB: Started; log
sequence number 0 44233
Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 [ERROR] Can't start
server: Bind on TCP/IP port: Address already in use
Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 [ERROR] Do you already
have another mysqld server running on port: 3306 ?
Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 [ERROR] Aborting
Nov 25 18:48:00 debianmarcus9 mysqld:
Nov 25 18:48:00 debianmarcus9 mysqld: 121125 18:48:00 InnoDB: Starting
shutdown...
Nov 25 18:48:05 debianmarcus9 mysqld: 121125 18:48:05 InnoDB: Shutdown
completed; log sequence number 0 44233
Nov 25 18:48:05 debianmarcus9 mysqld: 121125 18:48:05 [Note] /usr/sbin/mysqld:
Shutdown complete
Nov 25 18:48:05 debianmarcus9 mysqld:
Nov 25 18:48:05 debianmarcus9 mysqld_safe: mysqld from pid file
/var/run/mysqld/mysqld.pid ended
Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]:
#007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 25 18:48:14 debianmarcus9 /etc/init.d/mysql[30610]:
-- System Information:
Debian Release: 6.0.5
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages mysql-server-5.1 depends on:
ii adduser 3.112+nmu2 add and remove users and groups
ii debconf [de 1.5.36.1 Debian configuration management sy
ii libc6 2.11.3-3 Embedded GNU C Library: Shared lib
ii libdbi-perl 1.612-1 Perl Database Interface (DBI)
ii libgcc1 1:4.4.5-8 GCC support library
ii libmysqlcli 5.1.63-0+squeeze1 MySQL database client library
ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3
ii lsb-base 3.2-23.2squeeze1 Linux Standard Base 3.2 init scrip
ii mysql-clien 5.1.63-0+squeeze1 MySQL database client binaries
ii mysql-commo 5.1.63-0+squeeze1 MySQL database common files, e.g.
ii mysql-serve 5.1.49-3 MySQL database server binaries
ii passwd 1:4.1.4.2+svn3283-2+squeeze1 change and administer password and
ii perl 5.10.1-17squeeze3 Larry Wall's Practical Extraction
ii psmisc 22.11-1 utilities that use the proc file s
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
Versions of packages mysql-server-5.1 recommends:
ii bsd-mailx [mailx] 8.1.2-0.20100314cvs-1 simple mail user agent
ii libhtml-template-p 2.9-2 module for using HTML Templates wi
Versions of packages mysql-server-5.1 suggests:
pn tinyca <none> (no description available)
-- debconf information:
mysql-server/error_setting_password:
mysql-server-5.1/start_on_boot: true
mysql-server-5.1/postrm_remove_databases: false
mysql-server-5.1/nis_warning:
mysql-server-5.1/really_downgrade: false
mysql-server/password_mismatch:
mysql-server/no_upgrade_when_using_ndb:
More information about the pkg-mysql-maint
mailing list