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
• Status: Duplicate
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.0.27-max
• OS: Linux (CentOS 4.4 (i386))
• 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.