Todd, this person found what may have been causing the problem originally.
You might want to fix the LSB comments part of the init script for MySQL
and have it fixed for future releases.
Now, on to replying to Martin....
Martin Fahrendorf grabbed a keyboard and wrote:
>
> Am Samstag, 19. Oktober 2002 21:51 schrieb David Guntner:
> > This question was asked by someone else earlier, but I never saw a
> > response. Sorry if one was given and I was just being blind... :-)
> >
> > I've done "chkconfig --add mysql" so I know it should be starting. When
> > checking the comments at the beginning of the /etc/rc.d/init.d/mysql
> > script, I see:
> >
> > # Comments to support chkconfig on RedHat Linux
> > # chkconfig: 2345 90 90
> > # description: A very fast and reliable SQL database engine.
> >
> > Which says that it should be getting started in run levels 2 through 5.
> > And yet, upoon booting, there's no mysql daemon running. I have to
> > manually do a "/etc/init.d/mysql start" to bring it up. Checking the
> > startup configuration, I find:
> >
> > # chkconfig --list mysql
> > mysql 0:off 1:off 2:on 3:off 4:on 5:off 6:off
> >
> > Ok, so how come mysql is only set to come in in run levels 2 and 4, when
> > the comments at the beginning of the script say 2 through 5?
>
> Hey,
>
> a little late, but I found the sollution.
Better late than never, I guess. :-)
> The 'off' in runlevel 3 and 5 is caused by the lsb stuff. somewhere in
> the mysql file in /etc/init.d there are the lines
>
> # Default-Start: 3 5
> # Default-Stop: 3 5
>
> but they should be
>
> # Default-Start: 2 3 4 5
> # Default-Stop: 1 6
>
> I is obvious, now, why runlevel 3 and 5 does not start mysql. Its a Bug in
> the mysql init-script.
That's certainly good to know about. I hope Mandrake takes note and fixes
this in a future release. I've checked my /etc/rc.d/init.d/mysql script,
and those lines were sure there in the LSB section. Someone provided me
with another solution way back when this was first brought up, which was to
basically brute-force chkconfig by doing a "chkconfig -level 2345 mysql on"
so that it wouldn't bother checking the run levels in the script, but would
instead use what was provided on the command line.
Thanks for pointing this out!
--Dave
--
David Guntner GEnie: Just say NO!
http://www.akaMail.com/pgpkey/davidg or key server
for PGP Public key
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com