MySQL on Ubuntu Woes

[Chris O'Connell]

Hi Derek,

Thanks for the tips.  I'll update the script and test.

Chris

On Thu, Jun 3, 2010 at 3:20 PM, Derek Martin <invalid-yPs96gJSFQo51KKgMmcfiw at public.gmane.org> wrote:

> On Thu, Jun 03, 2010 at 02:56:02PM -0400, Chris O'Connell wrote:
> > root at SJ-MA-LX-Nagios:~# cat /etc/init.d/mysqld
> > sudo mkdir /var/run/mysqld
> > sudo chmod 777 /var/run/mysqld
> > sudo /usr/sbin/mysqld &
>
> Using sudo is not required here.  Things started by init run as root.
> You probably also don't want it to be 777, as that means anyone can
> write and delete files in that directory.  I don't believe you need to
> start it in the background either; most system daemons background
> themselves.  I'm not 100% sure mysqld does, but I'd be more than a
> little surprised if it didn't.
>
> > when I manually evoke the script all works without a problem.  Without
> the
> > script things don't work too well.
>
> I take it you installed mysql from source?  The deb package does all
> this for you, of course...
>
> > How can I get the script to run at boot?  I've created a symbolic link in
> > rc3-rc5.d.
>
> The symlink need to be named in a specific way.  Specifically, it
> needs to start with the letter 'S' (it must be capital) and a 2-digit
> number that indicates the order you want it to start relative to the
> other services.  Usually services which are not required to support
> the proper running of the OS itself are given a relatively high
> number, say in the 80's or 90's.  So, for example, you might create it
> as S90mysqld in /etc/rcX.d, where X={1,2,3}.
>
> --
> Derek D. Martin    http://www.pizzashack.org/   GPG Key ID: 0xDFBEAD02
> -=-=-=-=-
> This message is posted from an invalid address.  Replying to it will result
> in
> undeliverable mail due to spam prevention.  Sorry for the inconvenience.
>
>