Bug 114982

Summary: Request FC-devel mysql's init.d bugfix to be made available for FC1
Product: [Fedora] Fedora Reporter: Michel Alexandre Salim <michel.salim>
Component: mysqlAssignee: Tom Lane <tgl>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: 1CC: hhorak, mlbossi, uckelman, wilks
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2004-10-05 18:58:43 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 Michel Alexandre Salim 2004-02-05 04:30:56 UTC
Description of problem:
In mysql-server shipped with FC1 there is a bug in the
/etc/init.d/mysqld that will cause starting mysqld to result in a
timeout error, even though the service has actually been started
successfully.

This is fixed in FC-devel/rawhide but the fix was never published as
an update to FC1.

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1. Install mysql-server
2. /sbin/service mysqld start

  
Actual results:
Time-out error; starting MySQL 'failed'

Expected results:
Starting MySQL should result in a green 'PASS' report

Additional info:
mysql-server-3.23.58-4

Comment 1 Marco Colombo 2004-03-03 14:26:32 UTC
That happens to me too, after an upgrade from RHL73. The problem is
that the rc scripts tries to contact the daemon by issuing an
/usr/bin/mysqladmin ping command, (wrongly) assuming that the daemon
is not running in case of repeated failures. In my case, the failure
is due to the fact I protected the 'root' MySQL account with a
password (which seemed to me a pretty logical action to take). One way
to fix it is to add a --password='xxxxxx' option to mysqladmin in
/etc/rc.d/init.d/mysqld, but this leads to obvious security issues. A
better approach is to change the rc script not to use 'mysqladmin
ping' at all. The best approach (IMHO) involves patching mysql to
allow non authenticated pings, or using a different user (maybe a
dummy one) to perform the ping.

Comment 2 Tom Lane 2004-03-24 15:38:30 UTC
*** Bug 119042 has been marked as a duplicate of this bug. ***

Comment 3 Tom Lane 2004-04-05 20:03:52 UTC
It seems unlikely that we'd roll mysql in fc1 just for this, but I'll
keep the bug open as a reminder in case there's another reason to do
an update.

Comment 4 Tom Lane 2004-04-09 13:14:16 UTC
*** Bug 120491 has been marked as a duplicate of this bug. ***

Comment 5 Tom Lane 2004-10-05 18:58:43 UTC
Since FC1 is not being maintained anymore by Red Hat, I'm going to
close out this bug entry.