Bug 675870 - Cannot enable mysql service because it needs $network in run level 2
Summary: Cannot enable mysql service because it needs $network in run level 2
Status: RESOLVED FIXED
Alias: None
Product: openSUSE 11.4
Classification: openSUSE
Component: Other (show other bugs)
Version: Final
Hardware: x86-64 Other
: P5 - None : Major with 8 votes (vote)
Target Milestone: ---
Assignee: Michal Hrusecky
QA Contact: E-mail List
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-01 10:16 UTC by Silviu Marin-Caea
Modified: 2013-11-06 08:31 UTC (History)
7 users (show)

See Also:
Found By: ---
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Silviu Marin-Caea 2011-03-01 10:16:17 UTC
User-Agent:       Mozilla/5.0 (X11; Linux x86_64; rv:2.0b12) Gecko/20110222 Firefox/4.0b12

chkconfig --add mysql
insserv: FATAL: service network is missed in the runlevels 2 to use service mysql
insserv: exiting now!
/sbin/insserv failed, exit code 1
mysql                     0:off  1:off  2:off  3:off  4:off  5:off  6:off

Reproducible: Always

Steps to Reproduce:
1. chkconfig --add mysql
2. error
3. edit /etc/init.d/mysql
4. remove run level 2 from "Default-Start:"
5. chkconfig --add mysql
6. ok
Actual Results:  
In default configuration, mysql cannot be enabled as a service to start at boot

Expected Results:  
Should be able to enable mysql service
Comment 1 Milan Zimmermann 2011-03-15 03:16:18 UTC
I am getting a similar (interestingly not exactly the same) error:

 chkconfig --add mysql
insserv: FATAL: service xdm is missed in the runlevels 3 to use service atieventsd
insserv: FATAL: service network is missed in the runlevels 2 to use service mysql
insserv: exiting now!
/sbin/insserv failed, exit code 1
mysql                     0:off  1:off  2:off  3:off  4:off  5:off  6:off
Comment 2 Silviu Marin-Caea 2011-03-15 10:17:03 UTC
The xdm error is unrelated to mysql.  That has something to do with "atieventsd".
Comment 3 Petr Matula 2011-03-16 17:44:07 UTC
/etc/init.d/mysql (on 11.3 and 11.4)

### BEGIN INIT INFO
# Provides:       mysql
# Required-Start: $network $remote_fs
# Required-Stop: $network $remote_fs
# Default-Start:  2 3 5
# Default-Stop:
# Short-Description: Start the MySQL database server
# Description:    Start the MySQL database server
### END INIT INFO



However (11.3) :
# lsb_release -r && grep 'Default-Start' /etc/init.d/network
Release:        11.3
# Default-Start:        2 3 5


but (11.4) :
# lsb_release -r && grep 'Default-Start' /etc/init.d/network
Release:        11.4
# Default-Start:        3 5
Comment 4 Norman Mackey 2011-03-20 22:22:37 UTC
11.4, not 11.3.  New install.  

test1:~ # chkconfig open-iscsi
open-iscsi  off
test1:~ # chkconfig open-iscsi on
insserv: FATAL: service network is missed in the runlevels 2 4 to use service ha_logd
insserv: FATAL: service syslog is missed in the runlevels 4 to use service ha_logd
insserv: exiting now!
/sbin/insserv failed, exit code 1
test1:~ # uname -a
Linux test1 2.6.37.1-1.2-xen #1 SMP 2011-02-21 10:34:10 +0100 x86_64 x86_64 x86_64 GNU/Linux
Comment 5 Norman Mackey 2011-03-22 16:55:49 UTC
This appears to be the same as Bug 681340 in my case:

test1:~ # chkconfig open-iscsi on
insserv: FATAL: service network is missed in the runlevels 2 4 to use service ha_logd
insserv: FATAL: service syslog is missed in the runlevels 4 to use service ha_logd
insserv: exiting now!
/sbin/insserv failed, exit code 1
test1:~ # chkconfig logd off
test1:~ # chkconfig open-iscsi on
test1:~ # chkconfig logd on
insserv: FATAL: service network is missed in the runlevels 2 4 to use service ha_logd
insserv: FATAL: service syslog is missed in the runlevels 4 to use service ha_logd
insserv: exiting now!
/sbin/insserv failed, exit code 1
Comment 6 Dr. Werner Fink 2011-08-09 08:43:08 UTC
I'm not maintainer of mariadb nor mysql-cluster nor mysql-community-server
even if insserv tells that there are misconfigurations the packages mariadb
and mysql-cluster them self should be fixed (mysql-community-server does it
correct).
Comment 7 Forgotten User dr8e_4-OWI 2011-08-27 01:06:00 UTC
Another related

entered:
chkconfig mysql on

insserv: Service network is missed in the runlevels 2 to use mysql

rcmysql start

works but requires manual intervention after every power loss or restart.
Comment 8 Gerard Weatherby 2012-03-24 02:26:02 UTC
To fix, edit /etc/init.d/mysql

Remove "2" from line 19 -- that is:

Change
 # Default-Start:  2 3 5
To
# Default-Start:  3 5
Comment 9 Swamp Workflow Management 2012-05-14 14:08:38 UTC
openSUSE-SU-2012:0617-1: An update that fixes 7 vulnerabilities is now available.

Category: security (moderate)
Bug References: 675870,734436,742272,758460
CVE References: CVE-2009-5026,CVE-2012-0583,CVE-2012-1688,CVE-2012-1690,CVE-2012-1696,CVE-2012-1697,CVE-2012-1703
Sources used:
openSUSE 12.1 (src):    mysql-cluster-7.1.21-2.4.1
openSUSE 11.4 (src):    mysql-cluster-7.1.21-52.1
Comment 10 Swamp Workflow Management 2012-05-14 14:10:16 UTC
openSUSE-SU-2012:0618-1: An update that fixes 21 vulnerabilities is now available.

Category: security (moderate)
Bug References: 675870,734436,742272,758460
CVE References: CVE-2011-2262,CVE-2012-0075,CVE-2012-0087,CVE-2012-0101,CVE-2012-0102,CVE-2012-0112,CVE-2012-0113,CVE-2012-0114,CVE-2012-0115,CVE-2012-0116,CVE-2012-0118,CVE-2012-0119,CVE-2012-0120,CVE-2012-0484,CVE-2012-0485,CVE-2012-0490,CVE-2012-0492,CVE-2012-0583,CVE-2012-1688,CVE-2012-1690,CVE-2012-1703
Sources used:
openSUSE 11.4 (src):    mysql-community-server-5.1.62-52.1
Comment 11 Swamp Workflow Management 2012-05-14 14:11:07 UTC
openSUSE-SU-2012:0619-1: An update that fixes 21 vulnerabilities is now available.

Category: security (moderate)
Bug References: 675870,734436,742272,758460
CVE References: CVE-2011-2262,CVE-2012-0075,CVE-2012-0087,CVE-2012-0101,CVE-2012-0102,CVE-2012-0112,CVE-2012-0113,CVE-2012-0114,CVE-2012-0115,CVE-2012-0116,CVE-2012-0118,CVE-2012-0119,CVE-2012-0120,CVE-2012-0484,CVE-2012-0485,CVE-2012-0490,CVE-2012-0492,CVE-2012-0583,CVE-2012-1688,CVE-2012-1690,CVE-2012-1703
Sources used:
openSUSE 11.4 (src):    mariadb-5.1.62-39.1
Comment 12 Bernhard Wiedemann 2012-05-21 07:00:19 UTC
This is an autogenerated message for OBS integration:
This bug (675870) was mentioned in
https://build.opensuse.org/request/show/121573 Evergreen:11.2 / mysql
Comment 13 Bernhard Wiedemann 2012-05-24 22:00:16 UTC
This is an autogenerated message for OBS integration:
This bug (675870) was mentioned in
https://build.opensuse.org/request/show/122094 Evergreen:11.2 / mysql
Comment 14 Michal Hrusecky 2013-11-06 08:31:23 UTC
Somebody fixed it in evergreen, rest of distributions should have been fixed with some of the past updates.