Bug#466886: [debian-mysql] Bug#466886: Bug#466886: mysql-server-5.0: Faulty default config causes abort in init script

2008-02-23 Thread Marc Langer
On Do, Feb 21, 2008 at 19:34:21 +0100, Norbert Tretkowski wrote:
 Am Donnerstag, den 21.02.2008, 19:15 +0100 schrieb Marc Langer:
  The line from the my.cnf that was installed during upgrade
  #log_bin= /var/log/mysql/mysql-bin.log
  so it is not enabled in the default configuration, I think.
 
 This line is not commented out in the my.cnf file which is shipped in
 mysql-common 5.0.32-7etch5.

OK, I found the problem:

I currently have installed mysql-common from unstable, but mysql-server
from stable.

I think a suitable Depends or Conflicts could prevent other 
people from falling in this trap.

Thanks,
Marc



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#466886: mysql-server-5.0: Faulty default config causes abort in init script

2008-02-21 Thread Marc Langer
Package: mysql-server-5.0
Version: 5.0.32-7etch5
Severity: important

When installing the last security update in etch I chose to install
the default my.cnf from the package, as it seemed also suitable for
my installation.

So I let overwrite the my.cnf with the package version and get the
following error on startup:

/etc/init.d/mysql: ERROR: Using expire_logs_days without log_bin crashes
the server. See README.Debian.gz
invoke-rc.d: initscript mysql, action start failed.

After commenting out expire_logs_days in my.cnf it worked again.

The distributed default my.cnf seems to be broken in stable!


-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (990, 'stable'), (500, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-1-686
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-1) (ignored: 
LC_ALL set to de_DE)

Versions of packages mysql-server-5.0 depends on:
ii  adduser3.102 Add and remove users and groups
ii  debconf [debconf-2.0]  1.5.11etch1   Debian configuration management sy
ii  libc6  2.7-8 GNU C Library: Shared libraries
ii  libdbi-perl1.53-1etch1   Perl5 database interface by Tim Bu
ii  libgcc11:4.3-20080202-1  GCC support library
ii  libmysqlclient15off5.0.51a-3 MySQL database client library
ii  libncurses55.6+20080203-1Shared libraries for terminal hand
ii  libreadline5   5.2-2 GNU readline and history libraries
ii  libstdc++6 4.3-20080202-1The GNU Standard C++ Library v3
ii  libwrap0   7.6.dbs-13Wietse Venema's TCP wrappers libra
ii  lsb-base   3.1-23.2etch1 Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0   5.0.32-7etch5 mysql database client binaries
ii  mysql-common   5.0.51a-3 MySQL database common files
ii  passwd 1:4.0.18.1-7  change and administer password and
ii  perl   5.8.8-12  Larry Wall's Practical Extraction 
ii  psmisc 22.3-1Utilities that use the proc filesy
ii  zlib1g 1:1.2.3.3.dfsg-11 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  mailx1:8.1.2-0.20050715cvs-1 A simple mail user agent

-- 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/no_upgrade_with_isam_tables:
* mysql-server-5.0/mysql_install_db_notes:
* mysql-server-5.0/need_sarge_compat: false
  mysql-server/error_setting_password:
  mysql-server-5.0/need_sarge_compat_done: true



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#466886: [debian-mysql] Bug#466886: mysql-server-5.0: Faulty default config causes abort in init script

2008-02-21 Thread Norbert Tretkowski
Am Donnerstag, den 21.02.2008, 18:36 +0100 schrieb Marc Langer:
 So I let overwrite the my.cnf with the package version and get the
 following error on startup:
 
 /etc/init.d/mysql: ERROR: Using expire_logs_days without log_bin crashes
 the server. See README.Debian.gz
 invoke-rc.d: initscript mysql, action start failed.
 
 After commenting out expire_logs_days in my.cnf it worked again.

The default configuration in etch has log_bin enabled, so using
expire_logs_days should work.

Do you have some custom configuration files in /etc/mysql/conf.d?

Norbert




-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#466886: [debian-mysql] Bug#466886: mysql-server-5.0: Faulty default config causes abort in init script

2008-02-21 Thread Marc Langer
On Do, Feb 21, 2008 at 18:48:46 +0100, Norbert Tretkowski wrote:
 The default configuration in etch has log_bin enabled, so using
 expire_logs_days should work.
 
 Do you have some custom configuration files in /etc/mysql/conf.d?

no, there is no file in this directory.
The line from the my.cnf that was installed during upgrade
#log_bin= /var/log/mysql/mysql-bin.log
so it is not enabled in the default configuration, I think.

Marc



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]



Bug#466886: [debian-mysql] Bug#466886: Bug#466886: mysql-server-5.0: Faulty default config causes abort in init script

2008-02-21 Thread Norbert Tretkowski
Am Donnerstag, den 21.02.2008, 19:15 +0100 schrieb Marc Langer:
 The line from the my.cnf that was installed during upgrade
 #log_bin= /var/log/mysql/mysql-bin.log
 so it is not enabled in the default configuration, I think.

This line is not commented out in the my.cnf file which is shipped in
mysql-common 5.0.32-7etch5.

Norbert




-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]