Your message dated Tue, 27 Nov 2012 11:39:13 -0800 with message-id <1354044559-sup-6...@fewbar.com> and subject line Re: [debian-mysql] Bug#694390: mysql-server-5.1: failure to install w/ apt-get has caused the Debian Bug report #694390, regarding mysql-server-5.1: failure to install w/ apt-get to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 694390: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=694390 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---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:
--- End Message ---
--- Begin Message ---Excerpts from hesco's message of 2012-11-27 09:20:46 -0800: > My apologies about that. > I punted with a source install and ran into similar issues. > > To get the source install going, I did this: > > sudo apt-get install libaio1 > > but that still did not permit an apt-get install of the db server. > > I finally got a reminder of netstat > > $ sudo netstat -a -n -p | grep 3306 > tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 2088/stunnel4 > Ok so the original fail is invalid, this was a local config issue. Will close this bug report. > a new /etc/mysql/ exists, but this time with no my.cnf file. > > Should that shared object required by the source package also be > a dependency for the debian package? Why is the Debian package > not installing a new my.cnf when it creates its parent directory? > Not sure about the dependency question. However, the reaosn the package is not reinstalling the config file after you removed it is that this is considered an intentional action by the administrator, and so dpkg will not reverse it. To get around it, you need to purge the original mysql-common package dpkg --purge mysql-common > It appears that the disabled Plugin 'FEDERATED' which had been an issue > before, and remained an issue when shutting down the server running > from the source install did not raise its head when attempting to start > the new server. > This is a red herring. > Were my two mv commands sufficient to provide a clean place for the new > apt-get install? > No, you should purge mysql-common, and then install again. That should restore the default my.cnf to /etc/mysql.
--- End Message ---
