Bug 82152

Summary:	/etc/rc.d/init.d/mysqld with custom my.cnf error
Product:	[Retired] Red Hat Linux	Reporter:	Diederick van Dijk <diedvdyk>
Component:	mysql	Assignee:	Patrick Macdonald <patrickm>
Status:	CLOSED DUPLICATE	QA Contact:	David Lawrence <dkl>
Severity:	high	Docs Contact:
Priority:	high
Version:	7.1	CC:	pwrob
Target Milestone:	---
Target Release:	---
Hardware:	i386
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2006-02-21 18:51:14 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Diederick van Dijk 2003-01-18 12:22:20 UTC

Description of problem: 
 
I have a custom my.cnf where I relocate the datadir to /mysql/databases 
When starting the mysql server it says that I need to create the mysql 
database. But it's there and has been there for ages. It isn't in the default 
location /var/lib/mysql. Although it gives this warning the mysql starts up. 
But when I wan't to restart it it doesn't. I suspect it searches its pid file in 
the wrong place. 
 
Version-Release number of selected component (if applicable): 
 
mysql-server-3.23.54a-3.71

Comment 1 Peter Wroblewski 2003-02-28 19:09:46 UTC

Note: I use mysql-server-3.23.54a-4 on RH 8.0 and mysql-server-3.23.54a-3.72 on
RH 7.2.

I also have a custom my.cnf file, where I specify a different datadir.
The problem is that the init script for mysql has datadir hard-coded into it, so
at the point where it checks for the existence of the 'mysql' subdirectory, it
hasn't read the my.cnf file yet. Naturally, I have the option of *modifying* the
init script, but since the file is not marked as a %config file, it will be
ruthlessly overwritten next time I upgrade the package.

Would it be possible to do one of the following:
1) make the init script take /etc/my.cnf into consideration for variable definitions
2) create a separate config file (such as /etc/sysconfig/mysqld) that would
duplicate some of the data stored in /etc/my.cnf (like the datadir location) and
one that would be taken into consideration for variable definitions
3) make /etc/rc.d/init.d/mysqld a config file

I think option 1) would be most desirable here -- it would require more work
than 3), but be as complete as 2) without duplication of configuration data

Comment 2 Patrick Macdonald 2003-03-12 16:45:42 UTC

Diederick/Peter,

This is a duplicate of 76051.  In that bug report Henning provides
a solution to the problem.  I've marked 76051 as an enhancement as
there is a work around available.  As soon as we finish clearing
the backlog and shipping associated errata, we'll investigate 
further.

Both Peter and Henning make a good point about not wanting to
alter the mysqld script as it's not marked as %config. 




*** This bug has been marked as a duplicate of 76051 ***

Comment 3 Red Hat Bugzilla 2006-02-21 18:51:14 UTC

Changed to 'CLOSED' state since 'RESOLVED' has been deprecated.