{"id":54,"date":"2014-04-02T10:43:15","date_gmt":"2014-04-02T08:43:15","guid":{"rendered":"http:\/\/www.ritter.cc\/?page_id=54"},"modified":"2015-04-21T09:21:35","modified_gmt":"2015-04-21T07:21:35","slug":"mysql-datenbankdateien-an-anderer-stelle-anlegen","status":"publish","type":"page","link":"https:\/\/www.ritter.cc\/?page_id=54","title":{"rendered":"MySQL &#8211; Datenbankdateien an anderer Stelle anlegen"},"content":{"rendered":"<p>OS : RHEL6 \/ 7(clone)<br \/>\nSELinux : targeted<br \/>\nMySQL : 5.1 \/ 5.5<\/p>\n<p>Datenverzeichnis nach \/data\/mysql verschieben :<\/p>\n<p>&nbsp;<\/p>\n<p><code>SELinux Policy Anpassen :<br \/>\nVariante 1<\/code><\/p>\n<pre>vi \/etc\/selinux\/targeted\/contexts\/files\/file_contexts<\/pre>\n<pre><span style=\"line-height: 1.5em;\">Folgende Zeilen einf\u00fcgen :\r\n<\/span><span style=\"line-height: 1.5em;\">\/data(\/.*)? \u00a0 \u00a0 \u00a0       \u00a0 system_u:object_r:default_t:s0\r\n<\/span><span style=\"line-height: 1.5em;\">\/data\/mysql(\/.*)? \u00a0 \u00a0 \u00a0 \u00a0 system_u:object_r:mysqld_db_t:s0\r\n<\/span><\/pre>\n<p>Variante 2<\/p>\n<pre><strong>semanage fcontext -a -t mysqld_db_t \"\/data\/mysql(\/.*)?\"\r\n<\/strong>(Sollte semanage nicht auf dem System sein : yum install policycoreutils-python)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Danach die Verzeichnisse kontexte anhand der Policy zur\u00fcck setzen.<\/p>\n<p>restorecon -Rv \/data<\/p>\n<pre>restorecon -Rv \/data\/mysql<\/pre>\n<pre>chown mysql:mysql -R \/data\/mysql<\/pre>\n<p><span style=\"line-height: 1.5em;\">\u00a0(Referenz :\u00a0<\/span><span style=\"line-height: 1.5em;\">https:\/\/access.redhat.com\/site\/documentation\/en-US\/Red_Hat_Enterprise_Linux\/6\/html\/Security-Enhanced_Linux\/sect-Security-Enhanced_Linux-Troubleshooting-Top_Three_Causes_of_Problems.html)<\/span><\/p>\n<p><span style=\"line-height: 1.5em;\">\u00a0(Referenz :\u00a0<\/span><span style=\"line-height: 1.5em;\">https:\/\/blogs.oracle.com\/jsmyth\/entry\/selinux_and_mysql)<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>OS : RHEL6 \/ 7(clone) SELinux : targeted MySQL : 5.1 \/ 5.5 Datenverzeichnis nach \/data\/mysql verschieben : &nbsp; SELinux<\/p>\n<p><a href=\"https:\/\/www.ritter.cc\/?page_id=54\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\">MySQL &#8211; Datenbankdateien an anderer Stelle anlegen<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":52,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-54","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=54"}],"version-history":[{"count":10,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages\/54\/revisions"}],"predecessor-version":[{"id":157,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages\/54\/revisions\/157"}],"up":[{"embeddable":true,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages\/52"}],"wp:attachment":[{"href":"https:\/\/www.ritter.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}