Sunday, August 30, 2009

SELinux is preventing the mysqld from using potentially mislabeled files

"setroubleshoot: SELinux is preventing the mysqld from using potentially mislabeled files, ...., For complete SELinux messages. run sealert -l ...."

above error is appear after I manually copy Mysql data files from /var/lib/mysql directory from one server to another new server, I usually choose this direct copy path to create another identical mysql server machine for its effectiveness, its faster compare to use the regular mysql tool.

but when the linux machine has SElinux enabled on it, direct copy will resulting the file unreadable from mysql server point of view, it will showing above error, to make these data file readable on mysql simply issue this command :

chcon --reference=/var/lib/mysql new_db_directory/*

No comments:

current

last archive