[Linux-HA] Odd MySQL Issue

[Eddie C]

 I would be very careful about the default SE linux policy for mysql. I
never confirmed this but one of our c Applications uses a mysql lib to run.
I compiled mysql from source placing it in its own directory
/usr/local/mysql. Even though the system was targeted, and targeted is only
supposed to affect the RPM mysql it was stopping something in the program.

Edward

On 11/3/06, CA Lists <lists at creativeanvil.com> wrote:
>
> I've identified my problem - it's SELinux. I assumed doing a restorecon -R
> -v /data/db/mysql would do the trick, but it still does not work. If I
> disable SELinux, everything starts up just fine. MySQL will run fine under
> SELinux if the datadir is in its original place (/var/lib/mysql). Is there
> anything else I need to do to allow it to run with datadir /data/db/mysql?
> I
> really don't want to have to build my own policy just for this issue...
>
> Thanks,
>
> Rob
>
>
>
>
> > Yes, all works as long as I leave the datadir variable alone. If I put
> it
> > back to /var/lib/mysql, ha+drbd+mysql works just fine. As for versions:
> >
> > HA - 2.0.7
> > DRBD - 0.7.21
> > MySQL - MySQL-server-standard-5.0.24a-0.rhel4
> >
> > I did have to modify the LSB init script to create the proper output for
> the
> > 'status' command, but, again, when the datadir is in /var/lib/mysql, all
> is
> > well. When I move it to /data/db/mysql, it doesn't work. Apache's
> > DocumentRoot is in /data/web, which is also on the DRBD disk, and it
> starts
> > fine (before MySQL), furthering my belief that the filesystem is mounted
> > before MySQL starts up.
> >
> > Any thoughts? Thanks,
> >
> > Joe
> >
> >
> >
> >
> >> hi,
> >>
> >> did everything, as in HA + DRBD + mysql worked before u shifted the
> working
> >> directory ?
> >> what version of DRBD, HA and mysql are u using ?
> >>
> >> On Tuesday 31 October 2006 13:21, CA Lists wrote:
> >>> I have an odd issue where MySQL will not start when heartbeat tries to
> >>> start it (via LSB script) ONLY when I change the datadir in the
> >>> /etc/my.cnf. If I execute the script manually, it starts just fine. If
> I
> >>> comment out the datadir variable, heartbeat is able to start it just
> fine.
> >>> Where I am trying to move mysql data to is a DRBD disk
> (/data/db/mysql). I
> >>> checked
> >>> permissions, made sure the filesystem is mounted before MySQL starts.
> I
> >>> checked the mysql logs, which just say "mysql started" next line
> "mysql
> >>> ended". In the ha-debug log, I just get:
> >>>
> >>> Starting MySQL...................[FAILED]
> >>>
> >>> No additional info. Anyone have any thoughts on why this works
> manually,
> >>> but not when heartbeat tries to start it? I tried setting basedir
> also, but
> >>> no luck there. Thanks,
> >>>
> >>> Rob
> >>>
> >>>
> >>> _______________________________________________
> >>> Linux-HA mailing list
> >>> Linux-HA at lists.linux-ha.org
> >>> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> >>> See also: http://linux-ha.org/ReportingProblems
> >> _______________________________________________
> >> Linux-HA mailing list
> >> Linux-HA at lists.linux-ha.org
> >> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> >> See also: http://linux-ha.org/ReportingProblems
> >>
> >
> >
> > _______________________________________________
> > Linux-HA mailing list
> > Linux-HA at lists.linux-ha.org
> > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > See also: http://linux-ha.org/ReportingProblems
> >
>
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA at lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>