Bug 767391

Summary: Incorrect MySQL Server start/stop commands
Product: [Fedora] Fedora Reporter: Rares Vernica <rvernica>
Component: mysql-workbenchAssignee: Remi Collet <fedora>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 16CC: fedora
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: mysql-workbench-5.2.36-4.fc16 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-12-27 22:56:34 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Rares Vernica 2011-12-13 23:03:06 UTC
Description of problem:

The package contains incorrect start/stop commands for the MySQL server. The package commands are:

    Start MySQL:  /etc/init.d/mysqld start
    Stop MySQL:   /etc/init.d/mysqld stop

The correct commands are:

    Start MySQL:  systemctl start mysqld.service
    Stop MySQL:   systemctl stop  mysqld.service

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

Name        : mysql-workbench
Arch        : x86_64
Version     : 5.2.35
Release     : 1.fc16

How reproducible:

All the time.

Steps to Reproduce:

0. Assuming you have the MySQL server running on the local host. 

1. From the Home tab, click on "New Server Instance". 

2. Click Next, Next, Next (accepting the default suggested settings), until the "Management and OS" page (fourth page).

3. Select "Fedora Linux (MySQL Package)" (BTW, this should probably be the default) for the "MySQL Installation Type" field. Click Next.

4. On the next page, "Test Settings", you will get an error:

  X Check location of start/stop commands
  X Check MySQL configuration file

  Error: std::exception

  What check_admin_commands/local
  Operation failed: std::exception

(BTW, the error message is not very informative.) Click Next.

5. On the next page, "Review Settings", you can see the wrong values for the start/stop commands used by the package:

    Start MySQL:  /etc/init.d/mysqld start
    Stop MySQL:   /etc/init.d/mysqld stop

To fix it, do the following:

Check "Change Parameters" and click Next twice.

6. On the next page, "Specify Commands", enter:

  Command to start the MySQL server: systemctl start mysqld.service
  Command to stop  the MySQL server: systemctl stop  mysqld.service
               Status check command: ps -C mysqld -o pid=

Check "Check this box if you want or need the above commands to be executed with elevated Operating System Privileges." Click Next. Click Finish.
  
Actual results:

    Start MySQL:  /etc/init.d/mysqld start
    Stop MySQL:   /etc/init.d/mysqld stop

Expected results:

    Start MySQL:  systemctl start mysqld.service
    Stop MySQL:   systemctl stop  mysqld.service

Comment 1 Fedora Update System 2011-12-16 20:17:51 UTC
mysql-workbench-5.2.36-4.fc16 has been submitted as an update for Fedora 16.
https://admin.fedoraproject.org/updates/FEDORA-2011-16985/mysql-workbench-5.2.36-4.fc16

Comment 2 Fedora Update System 2011-12-17 20:53:01 UTC
Package mysql-workbench-5.2.36-4.fc16:
* should fix your issue,
* was pushed to the Fedora 16 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing mysql-workbench-5.2.36-4.fc16'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2011-16985/mysql-workbench-5.2.36-4.fc16
then log in and leave karma (feedback).

Comment 3 Fedora Update System 2011-12-27 22:56:34 UTC
mysql-workbench-5.2.36-4.fc16 has been pushed to the Fedora 16 stable repository.  If problems still persist, please make note of it in this bug report.