Bug #24189 MySQL-Max packaging of generic RPM breaks install when ndb is configured

Submitted: 10 Nov 2006 13:52 Modified: 7 Dec 2006 21:39
Reporter: Alexander List Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.27-max OS:Linux (CentOS 4.4 (i386))
Assigned to: CPU Architecture:Any
Tags: mysql_install_db, packaging

[10 Nov 2006 13:52] Alexander List
Description:
I have ndbcluster configured in my /etc/my.cnf

When trying to set up the initial privilege tables, I get the following error:

# /usr/bin/mysql_install_db 
Installing all prepared tables
061110 14:39:17 [ERROR] /usr/sbin/mysqld: unknown variable 'ndb-connectstring=nodeid=NN,a.b.c.d,a.b.c.e'

Installation of system tables failed!

How to repeat:
- install CentOS 4.4 (i386)
- yum install perl-DBI
- download

http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-server-5.0.27-0.glibc23.i386.rpm
http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-Max-5.0.27-0.glibc23.i386.rpm
http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-bench-5.0.27-0.glibc23.i386.rpm
http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-devel-5.0.27-0.glibc23.i386.rpm
http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-compat-5.0.27-0.glibc23.i386.rpm
http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-debuginfo-5.0.27-0.glibc23.i386.rpm

- rpm -i MySQL-*5.0.27-0*.rpm

have ndbcluster configured in /etc/my.cnf:

---8<---
[mysqld]
##### CLUSTER #####
ndbcluster
ndb-connectstring="nodeid=NN,a.b.c.d,a.b.c.e"
engine-condition-pushdown=1
ndb_force_send=0
ndb_use_exact_count=0 
---8<---

Try to start mysql:

/etc/init.d/mysql/start

Suggested fix:
After renaming /usr/sbin/mysqld to /usr/sbin/mysqld.off and creating a symlink from /usr/sbin/mysqld-max to /usr/sbin/mysqld, everything worked fine.

The package MySQL-Max should add a diversion from mysqld to mysqld-max.
[7 Dec 2006 21:39] Sveta Smirnova
Thank you for the report.

I'll mark it as duplicate of bug #23669, because cause of these two bugs is same: mysql_install_db reads unneded settings from default configuration file.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.