Bug#614320: [debian-mysql] Bug#614320: Error when installing
I'm seeing the exact same behaviour in a brand new Xen domU installed with xen-create-image. I installed mysql with 'apt-get install mysql-server' I tried purging mysql-server* and wiping out database files with rm -rf /var/lib/mysql, but the install after that didn't do much better. syslog shows exactly the same contents as was reported by Flavio. so, there's something about a syntax error before 'ALTER TABLE ...', then IP bind problems, and then an error about a plugin table already existing, and then 'mysqladmin ... ping' fails. ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database ii libmysqlclient16 5.1.49-3 MySQL database client library ii mysql-client 5.1.49-3 MySQL database client (metapackage depending on the latest version) ii mysql-client-5.1 5.1.49-3 MySQL database client binaries ii mysql-common 5.1.49-3 MySQL database common files, e.g. /etc/mysql/my.cnf iU mysql-server 5.1.49-3 MySQL database server (metapackage depending on the latest version) iF mysql-server-5.1 5.1.49-3 MySQL database server binaries and system database setup ii mysql-server-core-5.1 5.1.49-3 MySQL database server binaries -- Gabriel Filion -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#614320: [debian-mysql] Bug#614320: Error when installing mysql-server-5.1/Error al instalar mysql-server-5.1
Hi, please always keep the Debian Bug Tracking System in the CC list. Am Montag, den 21.02, 02:29 schrieb Flavio Emmanuel Gama Contreras: of course, but what I can do that? Where do I get the syslog? forgive me but despite of i have been working with Linux for a long time, I have never used this tools MySQL logs to /var/log/daemon.log by default. Regards Norbert -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#614320: [debian-mysql] Bug#614320: Error when installing mysql-server-5.1/Error al instalar mysql-server-5.1
Hi Norbert,
I think that all the file is about the problem
but, I try to resume to only one of attemps
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: To do so, start the server, then
issue the following commands:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: /usr/bin/mysqladmin -u root
password 'new-password'
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: /usr/bin/mysqladmin -u root -h
SAPHIRA password 'new-password'
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: Alternatively you can run:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]:
/usr/bin/mysql_secure_installation
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: which will also give you the
option of removing the test
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: databases and anonymous user
created by default. This is
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: strongly recommended for
production servers.
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: See the manual for more
instructions.
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]: Please report any problems with
the /usr/scripts/mysqlbug script!
Feb 20 21:39:11 SAPHIRA mysqld_safe[12838]:
Feb 20 21:39:11 SAPHIRA mysqld_safe[12893]: 110220 21:39:11 [Note] Plugin
'FEDERATED' is disabled.
Feb 20 21:39:12 SAPHIRA mysqld_safe[12893]: 110220 21:39:12 InnoDB:
Started; log sequence number 0 44233
Feb 20 21:39:12 SAPHIRA mysqld_safe[12893]: 110220 21:39:12 InnoDB:
Starting shutdown...
Feb 20 21:39:17 SAPHIRA mysqld_safe[12893]: 110220 21:39:17 InnoDB:
Shutdown completed; log sequence number 0 44233
Feb 20 21:39:23 SAPHIRA mysqld_safe[13076]: 110220 21:39:23 [Note] Plugin
'FEDERATED' is disabled.
Feb 20 21:39:23 SAPHIRA mysqld_safe[13076]: 110220 21:39:23 InnoDB:
Started; log sequence number 0 44233
Feb 20 21:39:23 SAPHIRA mysqld_safe[13076]: 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
Feb 20 21:39:23 SAPHIRA mysqld_safe[13076]: 110220 21:39:23 [ERROR] Aborting
Feb 20 21:39:23 SAPHIRA mysqld_safe[13076]:
Feb 20 21:39:23 SAPHIRA mysqld_safe[13076]: 110220 21:39:23 InnoDB:
Starting shutdown...
Feb 20 21:39:28 SAPHIRA mysqld_safe[13076]: 110220 21:39:28 InnoDB:
Shutdown completed; log sequence number 0 44233
Feb 20 21:39:28 SAPHIRA mysqld_safe[13076]: 110220 21:39:28 [Note]
/usr/sbin/mysqld: Shutdown complete
Feb 20 21:39:28 SAPHIRA mysqld_safe[13076]:
Feb 20 21:39:28 SAPHIRA mysqld_safe[13163]: 110220 21:39:28 [Note] Plugin
'FEDERATED' is disabled.
Feb 20 21:39:28 SAPHIRA mysqld_safe[13163]: 110220 21:39:28 InnoDB:
Started; log sequence number 0 44233
Feb 20 21:39:28 SAPHIRA mysqld_safe[13163]: 110220 21:39:28 InnoDB:
Starting shutdown...
Feb 20 21:39:34 SAPHIRA mysqld_safe[13163]: 110220 21:39:34 InnoDB:
Shutdown completed; log sequence number 0 44233
Feb 20 21:39:34 SAPHIRA mysqld_safe[13242]: 110220 21:39:34 [Note] Plugin
'FEDERATED' is disabled.
Feb 20 21:39:34 SAPHIRA mysqld_safe[13242]: 110220 21:39:34 InnoDB:
Started; log sequence number 0 44233
Feb 20 21:39:34 SAPHIRA mysqld_safe[13242]: ERROR: 1050 Table 'plugin'
already exists
Feb 20 21:39:34 SAPHIRA mysqld_safe[13242]: 110220 21:39:34 [ERROR] Aborting
Feb 20 21:39:34 SAPHIRA mysqld_safe[13242]:
Feb 20 21:39:34 SAPHIRA mysqld_safe[13242]: 110220 21:39:34 InnoDB:
Starting shutdown...
Feb 20 21:39:39 SAPHIRA mysqld_safe[13242]: 110220 21:39:39 InnoDB:
Shutdown completed; log sequence number 0 44233
Feb 20 21:39:39 SAPHIRA mysqld_safe[13242]: 110220 21:39:39 [Note]
/usr/sbin/mysqld: Shutdown complete
Feb 20 21:39:39 SAPHIRA mysqld_safe[13242]:
Feb 20 21:39:40 SAPHIRA mysqld_safe: Starting mysqld daemon with databases
from /var/lib/mysql
Feb 20 21:39:40 SAPHIRA mysqld: 110220 21:39:40 [Note] Plugin 'FEDERATED' is
disabled.
Feb 20 21:39:41 SAPHIRA mysqld: 110220 21:39:41 InnoDB: Started; log
sequence number 0 44233
Feb 20 21:39:41 SAPHIRA mysqld: 110220 21:39:41 [ERROR] Can't start server:
Bind on TCP/IP port: Cannot assign requested address
Feb 20 21:39:41 SAPHIRA mysqld: 110220 21:39:41 [ERROR] Do you already have
another mysqld server running on port: 3306 ?
Feb 20 21:39:41 SAPHIRA mysqld: 110220 21:39:41 [ERROR] Aborting
Feb 20 21:39:41 SAPHIRA mysqld:
Feb 20 21:39:41 SAPHIRA mysqld: 110220 21:39:41 InnoDB: Starting
shutdown...
Feb 20 21:39:46 SAPHIRA mysqld: 110220 21:39:46 InnoDB: Shutdown completed;
log sequence number 0 44233
Feb 20 21:39:46 SAPHIRA mysqld: 110220 21:39:46 [Note] /usr/sbin/mysqld:
Shutdown complete
Feb 20 21:39:46 SAPHIRA mysqld:
Feb 20 21:39:46 SAPHIRA mysqld_safe: mysqld from
Bug#614320: [debian-mysql] Bug#614320: Error when installing mysql-server-5.1/Error al instalar mysql-server-5.1
Am Sonntag, den 20.02, 18:03 schrieb Flavio Emmanuel Gama Contreras: Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! please send us the corresponding lines from syslog. Regards Norbert -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
