{"id":47,"date":"2006-12-30T16:58:22","date_gmt":"2006-12-30T15:58:22","guid":{"rendered":"http:\/\/blog.blackdown.de\/2006\/12\/30\/47\/"},"modified":"2016-10-29T03:51:01","modified_gmt":"2016-10-29T01:51:01","slug":"chrooting-recent-mysql-versions-on-debian-and-ubuntu","status":"publish","type":"post","link":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/","title":{"rendered":"Chrooting Recent MySQL Versions on Debian and Ubuntu"},"content":{"rendered":"<p>I&#8217;ve posted a <a href=\"\/2005\/03\/04\/chrooting-mysql-on-debian\/\">recipe<\/a> for chrooting MySQL on Debian sarge a while ago. These instructions no longer work out of the box for newer MySQL packages from Debian and Ubuntu. The main problem is that the startup script added a few extra checks and script invocations that don&#8217;t understand the chroot environment. So here&#8217;s an updated plan:<\/p>\n<ul>\n<li>Prepare the chroot directory. It&#8217;s recommended to use an extra partition\/filesystem for it. I will use <code>\/srv\/mysql<\/code> (which is an <a href =\"http:\/\/sourceware.org\/lvm2\/\">LVM2<\/a> partition with an ext3 filesystem on my system) for the rest of the text.<\/li>\n<li>Stop MySQL:\n<pre>\/etc\/init.d\/mysql stop<\/pre>\n<\/li>\n<li>Copy the databases to new location:\n<pre>mkdir -p \/srv\/mysql\/var\/lib\r\ncp -a \/var\/lib\/mysql \/srv\/mysql\/var\/lib<\/pre>\n<\/li>\n<li>Copy <a href=\"\/static\/mysql-chroot\">this script<\/a> to <code>\/etc\/default\/mysql-chroot<\/code><\/li>\n<li>Edit <code>\/etc\/init.d\/mysql<\/code>:\n<ul>\n<li>Source the <code><a href=\"\/static\/mysql-chroot\">mysql-chroot<\/a><\/code> script somewhere at the top:\n<pre>&hellip;\r\ntest -x \/usr\/sbin\/mysqld || exit 0\r\n\r\n<strong>. \/etc\/default\/mysql-chroot<\/strong>\r\n\r\nSELF=$(cd $(dirname $0); pwd -P)\/$(basename $0)\r\n&hellip;<\/pre>\n<\/li>\n<li>Fix the disk space check:\n<pre style=\"overflow:scroll;width:93%;\">\r\n&hellip;\r\n# check for diskspace shortage\r\ndatadir=`mysqld_get_param datadir`\r\nif LC_ALL=C BLOCKSIZE= df --portability <strong>$CHROOT_DIR<\/strong>$datadir\/. | tail -n 1 | awk &apos;{ exit ($4&gt;4096) }&apos;; then\r\n  log_failure_msg &quot;$0: ERROR: The partition with $datadir is too full!&quot;\r\n&hellip;<\/pre>\n<\/li>\n<li>Run <code>setup_chroot<\/code> right in the start section:\n<pre>&hellip;\r\nif mysqld_status check_alive nowarn; then\r\n  echo &quot;...already running.&quot;\r\nelse\r\n<strong>  setup_chroot<\/strong>\r\n  \/usr\/bin\/mysqld_safe &gt; \/dev\/null 2&gt;&amp;1 &amp;\r\n&hellip;<\/pre>\n<\/li>\n<li>Somehow <code>\/var\/run\/mysqld\/mysqld.pid<\/code> disappears after each start.  We have to create it each time, otherwise the <code>stop<\/code> command won&#8217;t work properly:\n<pre>&hellip;\r\nif mysqld_status check_alive warn; then\r\n  log_end_msg 0\r\n<strong>  ln -sf $CHROOT_DIR\/var\/run\/mysqld\/mysqld.pid \\\r\n                 \/var\/run\/mysqld<\/strong>\r\n  # Now start mysqlcheck or whatever the admin wants.\r\n  output=$(\/etc\/mysql\/debian-start)\r\n&hellip;<\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<li>In <code>\/etc\/mysql\/debian.cnf<\/code>, change the two <code>socket<\/code> lines to:\n<pre>socket = \/srv\/mysql\/var\/run\/mysqld\/mysqld.sock<\/pre>\n<\/li>\n<li>In <code>\/etc\/mysql\/my.cnf<\/code>:\n<ul>\n<li>Change the <code>socket<\/code> line in the <code>[client]<\/code> section to:\n<pre>socket = \/srv\/mysql\/var\/run\/mysqld\/mysqld.sock<\/pre>\n<p>Don&#8217;t change the <code>socket<\/code> lines in the other sections!<\/p>\n<\/li>\n<li>Add\n<pre>chroot = \/srv\/mysql<\/pre>\n<p> to the <code>[mysqld]<\/code> section.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>Prepend <code>\/srv\/mysql<\/code> to the log files listed in <code>\/etc\/logrotate.d\/mysql-server<\/code><\/li>\n<li>Make <code>\/usr\/bin\/mysql_upgrade_shell<\/code> use the chrooted socket. <strong>Note: Currently these changes must be made each time mysql gets upgraded because upgrades override this file!<\/strong>\n<pre style=\"overflow:scroll;width:93%;\">&hellip;\r\n&#45;&#45;password=*) password=`echo &quot;$arg&quot; | sed -e &apos;s\/^[^=]*=\/\/&apos;` ;;\r\n<strong>&#45;&#45;socket=*) socket=`echo &quot;$arg&quot; | sed -e &apos;s\/^[^=]*=\/\/&apos;` ;;<\/strong>\r\n&#45;&#45;ldata=*|&#45;&#45;data=*|&#45;&#45;datadir=*) DATADIR=`echo &quot;$arg&quot; | sed -e &apos;s\/^[^=]*=\/\/&apos;` ;;\r\n&hellip;\r\nfi\r\n$bindir\/mysql_fix_privilege_tables &#45;&#45;silent &#45;&#45;user=$user &#45;&#45;password=$password <strong>&#45;&#45;socket=$socket<\/strong> $args\r\nexit 0\r\n&hellip;\r\ncheck_args=&quot;&#45;&#45;check-upgrade &#45;&#45;all-databases &#45;&#45;auto-repair &#45;&#45;user=$user &#45;&#45;password=$password <strong>&#45;&#45;socket=$socket<\/strong>&quot;\r\n&hellip;\r\n$bindir\/mysql_fix_privilege_tables &#45;&#45;silent &#45;&#45;user=$user &#45;&#45;password=$password <strong>&#45;&#45;socket=$socket<\/strong> $args\r\n&hellip;<\/pre>\n<\/li>\n<li>Start MySQL:\n<pre>\/etc\/init.d\/mysql start<\/pre>\n<\/li>\n<li>Check <code>\/var\/log\/syslog<\/code> for errors ;-)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve posted a recipe for chrooting MySQL on Debian sarge a while ago. These instructions no longer work out of the box for newer MySQL packages from Debian and Ubuntu. The main problem is that the startup script added a few extra checks and script invocations that don&#8217;t understand the chroot environment. So here&#8217;s an<br \/>[&rarr; <a href=\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/\" class=\"more-link\">Read the rest of this entry<\/a>]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[3,2,8,16],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"I&#039;ve posted a recipe for chrooting MySQL on Debian sarge a while ago. These instructions no longer work out of the box for newer MySQL packages from\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Chrooting Recent MySQL Versions on Debian and Ubuntu \u2014 J\u00fcrgen Kreileder\" \/>\n<meta property=\"og:description\" content=\"I&#039;ve posted a recipe for chrooting MySQL on Debian sarge a while ago. These instructions no longer work out of the box for newer MySQL packages from\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/\" \/>\n<meta property=\"og:site_name\" content=\"J\u00fcrgen Kreileder\" \/>\n<meta property=\"article:published_time\" content=\"2006-12-30T15:58:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-10-29T01:51:01+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00fcrgen Kreileder\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blackdown.de\/#website\",\"url\":\"https:\/\/blackdown.de\/\",\"name\":\"J\u00fcrgen Kreileder\",\"description\":\"Software Engineer and Consultant\",\"publisher\":{\"@id\":\"https:\/\/blackdown.de\/#\/schema\/person\/d169d9b7b1b84446d5bea93795076ec0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blackdown.de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#webpage\",\"url\":\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/\",\"name\":\"Chrooting Recent MySQL Versions on Debian and Ubuntu \u2014 J\u00fcrgen Kreileder\",\"isPartOf\":{\"@id\":\"https:\/\/blackdown.de\/#website\"},\"datePublished\":\"2006-12-30T15:58:22+00:00\",\"dateModified\":\"2016-10-29T01:51:01+00:00\",\"description\":\"I've posted a recipe for chrooting MySQL on Debian sarge a while ago. These instructions no longer work out of the box for newer MySQL packages from\",\"breadcrumb\":{\"@id\":\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Chrooting Recent MySQL Versions on Debian and Ubuntu\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#webpage\"},\"author\":{\"@id\":\"https:\/\/blackdown.de\/#\/schema\/person\/d169d9b7b1b84446d5bea93795076ec0\"},\"headline\":\"Chrooting Recent MySQL Versions on Debian and Ubuntu\",\"datePublished\":\"2006-12-30T15:58:22+00:00\",\"dateModified\":\"2016-10-29T01:51:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#webpage\"},\"wordCount\":210,\"publisher\":{\"@id\":\"https:\/\/blackdown.de\/#\/schema\/person\/d169d9b7b1b84446d5bea93795076ec0\"},\"articleSection\":[\"Debian\",\"Linux\",\"Security\",\"Ubuntu\"],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/blackdown.de\/#\/schema\/person\/d169d9b7b1b84446d5bea93795076ec0\",\"name\":\"J\u00fcrgen Kreileder\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/blackdown.de\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ceaab9fc1ba3f50f30f855e2b924aca5?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ceaab9fc1ba3f50f30f855e2b924aca5?s=96&d=identicon&r=g\",\"caption\":\"J\u00fcrgen Kreileder\"},\"logo\":{\"@id\":\"https:\/\/blackdown.de\/#personlogo\"},\"sameAs\":[\"https:\/\/blackdown.de\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"description":"I've posted a recipe for chrooting MySQL on Debian sarge a while ago. These instructions no longer work out of the box for newer MySQL packages from","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/","og_locale":"en_US","og_type":"article","og_title":"Chrooting Recent MySQL Versions on Debian and Ubuntu \u2014 J\u00fcrgen Kreileder","og_description":"I've posted a recipe for chrooting MySQL on Debian sarge a while ago. These instructions no longer work out of the box for newer MySQL packages from","og_url":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/","og_site_name":"J\u00fcrgen Kreileder","article_published_time":"2006-12-30T15:58:22+00:00","article_modified_time":"2016-10-29T01:51:01+00:00","twitter_misc":{"Written by":"J\u00fcrgen Kreileder","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/blackdown.de\/#website","url":"https:\/\/blackdown.de\/","name":"J\u00fcrgen Kreileder","description":"Software Engineer and Consultant","publisher":{"@id":"https:\/\/blackdown.de\/#\/schema\/person\/d169d9b7b1b84446d5bea93795076ec0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blackdown.de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#webpage","url":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/","name":"Chrooting Recent MySQL Versions on Debian and Ubuntu \u2014 J\u00fcrgen Kreileder","isPartOf":{"@id":"https:\/\/blackdown.de\/#website"},"datePublished":"2006-12-30T15:58:22+00:00","dateModified":"2016-10-29T01:51:01+00:00","description":"I've posted a recipe for chrooting MySQL on Debian sarge a while ago. These instructions no longer work out of the box for newer MySQL packages from","breadcrumb":{"@id":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Chrooting Recent MySQL Versions on Debian and Ubuntu"}]},{"@type":"Article","@id":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#article","isPartOf":{"@id":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#webpage"},"author":{"@id":"https:\/\/blackdown.de\/#\/schema\/person\/d169d9b7b1b84446d5bea93795076ec0"},"headline":"Chrooting Recent MySQL Versions on Debian and Ubuntu","datePublished":"2006-12-30T15:58:22+00:00","dateModified":"2016-10-29T01:51:01+00:00","mainEntityOfPage":{"@id":"https:\/\/blackdown.de\/articles\/chrooting-recent-mysql-versions-on-debian-and-ubuntu\/#webpage"},"wordCount":210,"publisher":{"@id":"https:\/\/blackdown.de\/#\/schema\/person\/d169d9b7b1b84446d5bea93795076ec0"},"articleSection":["Debian","Linux","Security","Ubuntu"],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/blackdown.de\/#\/schema\/person\/d169d9b7b1b84446d5bea93795076ec0","name":"J\u00fcrgen Kreileder","image":{"@type":"ImageObject","@id":"https:\/\/blackdown.de\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/ceaab9fc1ba3f50f30f855e2b924aca5?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ceaab9fc1ba3f50f30f855e2b924aca5?s=96&d=identicon&r=g","caption":"J\u00fcrgen Kreileder"},"logo":{"@id":"https:\/\/blackdown.de\/#personlogo"},"sameAs":["https:\/\/blackdown.de\/"]}]}},"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/pmfBQ-L","_links":{"self":[{"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/posts\/47"}],"collection":[{"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/comments?post=47"}],"version-history":[{"count":1,"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":755,"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/posts\/47\/revisions\/755"}],"wp:attachment":[{"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/media?parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/categories?post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blackdown.de\/wp-json\/wp\/v2\/tags?post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}