[Linux-HA] Odd MySQL Issue

[CA Lists]

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
>