&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML+RDFa 1.0//EN&quot;
  &quot;http://www.w3.org/MarkUp/DTD/xhtml-rdfa-1.dtd&quot;&gt;
&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot; xml:lang=&quot;en&quot; version=&quot;XHTML+RDFa 1.0&quot; dir=&quot;ltr&quot;
  xmlns:fb=&quot;http://ogp.me/ns/fb#&quot;
  xmlns:og=&quot;http://ogp.me/ns#&quot;
  xmlns:article=&quot;http://ogp.me/ns/article#&quot;
  xmlns:book=&quot;http://ogp.me/ns/book#&quot;
  xmlns:profile=&quot;http://ogp.me/ns/profile#&quot;
  xmlns:video=&quot;http://ogp.me/ns/video#&quot;
  xmlns:product=&quot;http://ogp.me/ns/product#&quot;&gt;

&lt;head profile=&quot;http://www.w3.org/1999/xhtml/vocab&quot;&gt;
  &lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot; /&gt;
&lt;script src=&quot;https://www.google.com/recaptcha/api.js?hl=en&quot; async=&quot;async&quot; defer=&quot;defer&quot;&gt;&lt;/script&gt;
&lt;link rel=&quot;shortcut icon&quot; href=&quot;http://www.antojose.com/sites/default/files/public/anto-jose-001.jpg&quot; type=&quot;image/jpeg&quot; /&gt;
&lt;meta name=&quot;description&quot; content=&quot;This is an issue which occurs due to the maximum number of open files allowed for a process (mysql in this case) being very less that what is required - something that happens because you have lots of large tables / a large DB. To fix this, you just have to increase the limits in a few places. Here is how you do it:&quot; /&gt;
&lt;meta name=&quot;generator&quot; content=&quot;Drupal 7 (http://drupal.org)&quot; /&gt;
&lt;link rel=&quot;canonical&quot; href=&quot;http://www.antojose.com/node/50&quot; /&gt;
&lt;link rel=&quot;shortlink&quot; href=&quot;http://www.antojose.com/node/50&quot; /&gt;
&lt;meta property=&quot;og:site_name&quot; content=&quot;antojose.com&quot; /&gt;
&lt;meta property=&quot;og:type&quot; content=&quot;article&quot; /&gt;
&lt;meta property=&quot;og:url&quot; content=&quot;http://www.antojose.com/node/50&quot; /&gt;
&lt;meta property=&quot;og:title&quot; content=&quot;[SOLVED] How to Fix on Ubuntu/Debian linux - MySQL/MariaDB: Out of resources when opening file (Errcode: 24)&quot; /&gt;
&lt;meta property=&quot;og:description&quot; content=&quot;This is an issue which occurs due to the maximum number of open files allowed for a process (mysql in this case) being very less that what is required - something that happens because you have lots of large tables / a large DB. To fix this, you just have to increase the limits in a few places. Here is how you do it:&quot; /&gt;
&lt;meta property=&quot;og:updated_time&quot; content=&quot;2014-03-11T04:49:37+05:30&quot; /&gt;
&lt;meta property=&quot;article:published_time&quot; content=&quot;2014-03-11T04:25:25+05:30&quot; /&gt;
&lt;meta property=&quot;article:modified_time&quot; content=&quot;2014-03-11T04:49:37+05:30&quot; /&gt;
  &lt;title&gt;[SOLVED] How to Fix on Ubuntu/Debian linux - MySQL/MariaDB: Out of resources when opening file (Errcode: 24) | antojose.com&lt;/title&gt;
  &lt;link type=&quot;text/css&quot; rel=&quot;stylesheet&quot; href=&quot;http://www.antojose.com/sites/default/files/public//css/css_xE-rWrJf-fncB6ztZfd2huxqgxu4WO-qwma6Xer30m4.css&quot; media=&quot;all&quot; /&gt;
&lt;link type=&quot;text/css&quot; rel=&quot;stylesheet&quot; href=&quot;http://www.antojose.com/sites/default/files/public//css/css_8_QKQjo6I581bcQ12ZUCISW0l2jx1UMxP2MwerCfG4w.css&quot; media=&quot;all&quot; /&gt;
&lt;link type=&quot;text/css&quot; rel=&quot;stylesheet&quot; href=&quot;http://www.antojose.com/sites/default/files/public//css/css_ho01hPNYFPXQ7ZYc_pMiGDnJ7Jjb2by9LQGTosxHWEk.css&quot; media=&quot;all&quot; /&gt;
&lt;link type=&quot;text/css&quot; rel=&quot;stylesheet&quot; href=&quot;http://www.antojose.com/sites/default/files/public//css/css_gOaFDMFlJxy-ZR-9z1VPiCOeTzaAYB3hcpfS4X8JxZI.css&quot; media=&quot;all&quot; /&gt;
&lt;link type=&quot;text/css&quot; rel=&quot;stylesheet&quot; href=&quot;http://www.antojose.com/sites/default/files/public//css/css_2THG1eGiBIizsWFeexsNe1iDifJ00QRS9uSd03rY9co.css&quot; media=&quot;print&quot; /&gt;

&lt;!--[if lte IE 7]&gt;
&lt;link type=&quot;text/css&quot; rel=&quot;stylesheet&quot; href=&quot;http://www.antojose.com/themes/bartik/css/ie.css?ofnmmu&quot; media=&quot;all&quot; /&gt;
&lt;![endif]--&gt;

&lt;!--[if IE 6]&gt;
&lt;link type=&quot;text/css&quot; rel=&quot;stylesheet&quot; href=&quot;http://www.antojose.com/themes/bartik/css/ie6.css?ofnmmu&quot; media=&quot;all&quot; /&gt;
&lt;![endif]--&gt;
&lt;link type=&quot;text/css&quot; rel=&quot;stylesheet&quot; href=&quot;http://www.antojose.com/sites/default/files/public//css/css_zkK35Th979krbf-D_gga5cRyAkGOTB78bQSVxOwUzV8.css&quot; media=&quot;all&quot; /&gt;
  &lt;script type=&quot;text/javascript&quot; src=&quot;http://www.antojose.com/sites/default/files/public//js/js_UWQINlriydSoeSiGQxToOUdv493zEa7dpsXC1OtYlZU.js&quot;&gt;&lt;/script&gt;
&lt;script type=&quot;text/javascript&quot; src=&quot;http://www.antojose.com/sites/default/files/public//js/js_9quVfS3gZladorkV2ed-FVAfl5erRUkKd0N5N7vsDg8.js&quot;&gt;&lt;/script&gt;
&lt;script type=&quot;text/javascript&quot; src=&quot;http://www.antojose.com/sites/default/files/public//js/js_Fl8k0iuP6VEpB7300oos-fS56hei3vPA7MdTvzINA9Y.js&quot;&gt;&lt;/script&gt;
&lt;script type=&quot;text/javascript&quot;&gt;
&lt;!--//--&gt;&lt;![CDATA[//&gt;&lt;!--
(function(i,s,o,g,r,a,m){i[&quot;GoogleAnalyticsObject&quot;]=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,document,&quot;script&quot;,&quot;//www.google-analytics.com/analytics.js&quot;,&quot;ga&quot;);ga(&quot;create&quot;, &quot;UA-15575285-1&quot;, {&quot;cookieDomain&quot;:&quot;auto&quot;});ga(&quot;send&quot;, &quot;pageview&quot;);
//--&gt;&lt;!]]&gt;
&lt;/script&gt;
&lt;script type=&quot;text/javascript&quot; src=&quot;http://www.antojose.com/sites/default/files/public//js/js_U4NwpHfNvPgCwUUvLae0TEZNVZ-7I9yx6KmWZee00mM.js&quot;&gt;&lt;/script&gt;
&lt;script type=&quot;text/javascript&quot;&gt;
&lt;!--//--&gt;&lt;![CDATA[//&gt;&lt;!--
jQuery.extend(Drupal.settings, {&quot;basePath&quot;:&quot;\/&quot;,&quot;pathPrefix&quot;:&quot;&quot;,&quot;ajaxPageState&quot;:{&quot;theme&quot;:&quot;bartik&quot;,&quot;theme_token&quot;:&quot;9OtUmMjQa37uj2qonRsYW9enSy6Zz6HXCQgWiOnhTus&quot;,&quot;js&quot;:{&quot;misc\/jquery.js&quot;:1,&quot;misc\/jquery.once.js&quot;:1,&quot;misc\/drupal.js&quot;:1,&quot;sites\/all\/libraries\/prettify\/prettify.js&quot;:1,&quot;misc\/jquery.cookie.js&quot;:1,&quot;misc\/form.js&quot;:1,&quot;sites\/all\/modules\/prettify\/prettify.loader.js&quot;:1,&quot;sites\/all\/modules\/captcha\/captcha.js&quot;:1,&quot;sites\/all\/modules\/google_analytics\/googleanalytics.js&quot;:1,&quot;0&quot;:1,&quot;misc\/textarea.js&quot;:1,&quot;modules\/filter\/filter.js&quot;:1},&quot;css&quot;:{&quot;modules\/system\/system.base.css&quot;:1,&quot;modules\/system\/system.menus.css&quot;:1,&quot;modules\/system\/system.messages.css&quot;:1,&quot;modules\/system\/system.theme.css&quot;:1,&quot;modules\/book\/book.css&quot;:1,&quot;modules\/comment\/comment.css&quot;:1,&quot;modules\/field\/theme\/field.css&quot;:1,&quot;modules\/node\/node.css&quot;:1,&quot;modules\/search\/search.css&quot;:1,&quot;modules\/user\/user.css&quot;:1,&quot;sites\/all\/modules\/views\/css\/views.css&quot;:1,&quot;sites\/all\/modules\/ckeditor\/css\/ckeditor.css&quot;:1,&quot;sites\/all\/modules\/ctools\/css\/ctools.css&quot;:1,&quot;sites\/all\/modules\/facebookshare\/facebookshare.css&quot;:1,&quot;modules\/filter\/filter.css&quot;:1,&quot;sites\/default\/files\/public\/\/honeypot\/honeypot.css&quot;:1,&quot;public:\/\/spamicide\/your_site_info.css&quot;:1,&quot;themes\/bartik\/css\/layout.css&quot;:1,&quot;themes\/bartik\/css\/style.css&quot;:1,&quot;themes\/bartik\/css\/colors.css&quot;:1,&quot;themes\/bartik\/css\/print.css&quot;:1,&quot;themes\/bartik\/css\/ie.css&quot;:1,&quot;themes\/bartik\/css\/ie6.css&quot;:1,&quot;sites\/all\/modules\/prettify\/styles\/sunburst.css&quot;:1}},&quot;prettify&quot;:{&quot;linenums&quot;:false,&quot;match&quot;:&quot;.content&quot;,&quot;nocode&quot;:&quot;no-code&quot;,&quot;custom&quot;:[],&quot;markup&quot;:{&quot;code&quot;:true,&quot;pre&quot;:true,&quot;precode&quot;:false}},&quot;googleanalytics&quot;:{&quot;trackOutbound&quot;:1,&quot;trackMailto&quot;:1,&quot;trackDownload&quot;:1,&quot;trackDownloadExtensions&quot;:&quot;7z|aac|arc|arj|asf|asx|avi|bin|csv|doc(x|m)?|dot(x|m)?|exe|flv|gif|gz|gzip|hqx|jar|jpe?g|js|mp(2|3|4|e?g)|mov(ie)?|msi|msp|pdf|phps|png|ppt(x|m)?|pot(x|m)?|pps(x|m)?|ppam|sld(x|m)?|thmx|qtm?|ra(m|r)?|sea|sit|tar|tgz|torrent|txt|wav|wma|wmv|wpd|xls(x|m|b)?|xlt(x|m)|xlam|xml|z|zip&quot;},&quot;ckeditor&quot;:{&quot;input_formats&quot;:{&quot;filtered_html&quot;:{&quot;customConfig&quot;:&quot;\/sites\/all\/modules\/ckeditor\/ckeditor.config.js?&quot;,&quot;defaultLanguage&quot;:&quot;en&quot;,&quot;toolbar&quot;:&quot;\n[\n    [\u0027Source\u0027],\n    [\u0027Cut\u0027,\u0027Copy\u0027,\u0027Paste\u0027,\u0027PasteText\u0027,\u0027PasteFromWord\u0027,\u0027-\u0027,\u0027SpellChecker\u0027, \u0027Scayt\u0027],\n    [\u0027Undo\u0027,\u0027Redo\u0027,\u0027Find\u0027,\u0027Replace\u0027,\u0027-\u0027,\u0027SelectAll\u0027,\u0027RemoveFormat\u0027],\n    [\u0027Image\u0027,\u0027Media\u0027,\u0027Flash\u0027,\u0027Table\u0027,\u0027HorizontalRule\u0027,\u0027Smiley\u0027,\u0027SpecialChar\u0027],\n    [\u0027Maximize\u0027, \u0027ShowBlocks\u0027],\n    \u0027\/\u0027,\n    [\u0027Format\u0027],\n    [\u0027Bold\u0027,\u0027Italic\u0027,\u0027Underline\u0027,\u0027Strike\u0027,\u0027-\u0027,\u0027Subscript\u0027,\u0027Superscript\u0027],\n    [\u0027NumberedList\u0027,\u0027BulletedList\u0027,\u0027-\u0027,\u0027Outdent\u0027,\u0027Indent\u0027,\u0027Blockquote\u0027],\n    [\u0027JustifyLeft\u0027,\u0027JustifyCenter\u0027,\u0027JustifyRight\u0027,\u0027JustifyBlock\u0027,\u0027-\u0027,\u0027BidiLtr\u0027,\u0027BidiRtl\u0027],\n    [\u0027Link\u0027,\u0027Unlink\u0027,\u0027Anchor\u0027, \u0027Linkit\u0027]\n]\n    &quot;,&quot;enterMode&quot;:1,&quot;shiftEnterMode&quot;:2,&quot;toolbarStartupExpanded&quot;:true,&quot;width&quot;:&quot;100%&quot;,&quot;skin&quot;:&quot;moono&quot;,&quot;format_tags&quot;:&quot;p;div;pre;address;h1;h2;h3;h4;h5;h6&quot;,&quot;show_toggle&quot;:&quot;t&quot;,&quot;default&quot;:&quot;t&quot;,&quot;ss&quot;:&quot;2&quot;,&quot;loadPlugins&quot;:[],&quot;scayt_autoStartup&quot;:false,&quot;stylesCombo_stylesSet&quot;:&quot;drupal:\/sites\/all\/modules\/ckeditor\/ckeditor.styles.js&quot;,&quot;contentsCss&quot;:[&quot;\/sites\/all\/modules\/ckeditor\/css\/ckeditor.css?ofnmmu&quot;,&quot;\/\/cdn.ckeditor.com\/4.4.3\/full-all\/contents.css?ofnmmu&quot;]},&quot;full_html&quot;:{&quot;customConfig&quot;:&quot;\/sites\/all\/modules\/ckeditor\/ckeditor.config.js?&quot;,&quot;defaultLanguage&quot;:&quot;en&quot;,&quot;toolbar&quot;:&quot;\n[\n    [\u0027Source\u0027],\n    [\u0027Cut\u0027,\u0027Copy\u0027,\u0027Paste\u0027,\u0027PasteText\u0027,\u0027PasteFromWord\u0027,\u0027-\u0027,\u0027SpellChecker\u0027, \u0027Scayt\u0027],\n    [\u0027Undo\u0027,\u0027Redo\u0027,\u0027Find\u0027,\u0027Replace\u0027,\u0027-\u0027,\u0027SelectAll\u0027,\u0027RemoveFormat\u0027],\n    [\u0027Image\u0027,\u0027Media\u0027,\u0027Flash\u0027,\u0027Table\u0027,\u0027HorizontalRule\u0027,\u0027Smiley\u0027,\u0027SpecialChar\u0027],\n    \u0027\/\u0027,\n    [\u0027Bold\u0027,\u0027Italic\u0027,\u0027Underline\u0027,\u0027Strike\u0027,\u0027-\u0027,\u0027Subscript\u0027,\u0027Superscript\u0027],\n    [\u0027NumberedList\u0027,\u0027BulletedList\u0027,\u0027-\u0027,\u0027Outdent\u0027,\u0027Indent\u0027,\u0027Blockquote\u0027],\n    [\u0027JustifyLeft\u0027,\u0027JustifyCenter\u0027,\u0027JustifyRight\u0027,\u0027JustifyBlock\u0027,\u0027-\u0027,\u0027BidiLtr\u0027,\u0027BidiRtl\u0027],\n    [\u0027Link\u0027,\u0027Unlink\u0027,\u0027Anchor\u0027, \u0027Linkit\u0027],\n    [\u0027DrupalBreak\u0027],\n    \u0027\/\u0027,\n    [\u0027Format\u0027,\u0027Font\u0027,\u0027FontSize\u0027],\n    [\u0027TextColor\u0027,\u0027BGColor\u0027],\n    [\u0027Maximize\u0027, \u0027ShowBlocks\u0027]\n]\n    &quot;,&quot;enterMode&quot;:1,&quot;shiftEnterMode&quot;:2,&quot;toolbarStartupExpanded&quot;:true,&quot;width&quot;:&quot;100%&quot;,&quot;skin&quot;:&quot;moono&quot;,&quot;format_tags&quot;:&quot;p;div;pre;address;h1;h2;h3;h4;h5;h6&quot;,&quot;show_toggle&quot;:&quot;t&quot;,&quot;default&quot;:&quot;t&quot;,&quot;ss&quot;:&quot;2&quot;,&quot;loadPlugins&quot;:[],&quot;scayt_autoStartup&quot;:false,&quot;stylesCombo_stylesSet&quot;:&quot;drupal:\/sites\/all\/modules\/ckeditor\/ckeditor.styles.js&quot;,&quot;contentsCss&quot;:[&quot;\/sites\/all\/modules\/ckeditor\/css\/ckeditor.css?ofnmmu&quot;,&quot;\/\/cdn.ckeditor.com\/4.4.3\/full-all\/contents.css?ofnmmu&quot;]}},&quot;plugins&quot;:[],&quot;textarea_default_format&quot;:{&quot;edit-comment-body-und-0-value&quot;:&quot;1&quot;}},&quot;urlIsAjaxTrusted&quot;:{&quot;\/comment\/reply\/50&quot;:true}});
//--&gt;&lt;!]]&gt;
&lt;/script&gt;
&lt;/head&gt;
&lt;body class=&quot;html not-front not-logged-in one-sidebar sidebar-second page-node page-node- page-node-50 node-type-story&quot; &gt;
  &lt;div id=&quot;skip-link&quot;&gt;
    &lt;a href=&quot;#main-content&quot; class=&quot;element-invisible element-focusable&quot;&gt;Skip to main content&lt;/a&gt;
  &lt;/div&gt;
    &lt;div id=&quot;page-wrapper&quot;&gt;&lt;div id=&quot;page&quot;&gt;

  &lt;div id=&quot;header&quot; class=&quot;without-secondary-menu&quot;&gt;&lt;div class=&quot;section clearfix&quot;&gt;

          &lt;a href=&quot;/&quot; title=&quot;Home&quot; rel=&quot;home&quot; id=&quot;logo&quot;&gt;
        &lt;img src=&quot;http://www.antojose.com/sites/default/files/public/anto-jose-001.jpg&quot; alt=&quot;Home&quot; /&gt;
      &lt;/a&gt;
    
          &lt;div id=&quot;name-and-slogan&quot;&gt;

                              &lt;div id=&quot;site-name&quot;&gt;
              &lt;strong&gt;
                &lt;a href=&quot;/&quot; title=&quot;Home&quot; rel=&quot;home&quot;&gt;&lt;span&gt;antojose.com&lt;/span&gt;&lt;/a&gt;
              &lt;/strong&gt;
            &lt;/div&gt;
                  
                  &lt;div id=&quot;site-slogan&quot;&gt;
            Drupal, Python, Linux, OpenSource, Christianity, People, Beliefs, Choice, Freedom, Life and Happiness from the eyes of a seeker          &lt;/div&gt;
        
      &lt;/div&gt; &lt;!-- /#name-and-slogan --&gt;
    
    
          &lt;div id=&quot;main-menu&quot; class=&quot;navigation&quot;&gt;
        &lt;h2 class=&quot;element-invisible&quot;&gt;Main menu&lt;/h2&gt;&lt;ul id=&quot;main-menu-links&quot; class=&quot;links clearfix&quot;&gt;&lt;li class=&quot;menu-499 first&quot;&gt;&lt;a href=&quot;/services&quot; title=&quot;Services&quot;&gt;Services&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;menu-1958&quot;&gt;&lt;a href=&quot;/node/34&quot; title=&quot;A study guide to help you prepare for RedHat&amp;#039;s RHCSA (EX200) / RHCE (EX300) certification examinations.&quot;&gt;RHCE Study Guide&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;menu-464&quot;&gt;&lt;a href=&quot;/freedomx&quot; title=&quot;FreedomX.in - Home of The FreedomX Linux OS&quot;&gt;FreedomX Linux&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;menu-488&quot;&gt;&lt;a href=&quot;/content/teracom-lw272-36mbps-3g-usb-modem&quot; title=&quot;Teracom LW272 3.6Mbps 3G USB Modem&quot;&gt;LW272&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;menu-502&quot;&gt;&lt;a href=&quot;/irc&quot; title=&quot;IRC Webchat&quot;&gt;IRC WebChat&lt;/a&gt;&lt;/li&gt;
&lt;li class=&quot;menu-2230 last&quot;&gt;&lt;a href=&quot;/user/login&quot; title=&quot;&quot;&gt;Log In&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;      &lt;/div&gt; &lt;!-- /#main-menu --&gt;
    
    
  &lt;/div&gt;&lt;/div&gt; &lt;!-- /.section, /#header --&gt;

  
  
  &lt;div id=&quot;main-wrapper&quot; class=&quot;clearfix&quot;&gt;&lt;div id=&quot;main&quot; class=&quot;clearfix&quot;&gt;

          &lt;div id=&quot;breadcrumb&quot;&gt;&lt;h2 class=&quot;element-invisible&quot;&gt;You are here&lt;/h2&gt;&lt;div class=&quot;breadcrumb&quot;&gt;&lt;a href=&quot;/&quot;&gt;Home&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;
    
    
    &lt;div id=&quot;content&quot; class=&quot;column&quot;&gt;&lt;div class=&quot;section&quot;&gt;
            &lt;a id=&quot;main-content&quot;&gt;&lt;/a&gt;
                    &lt;h1 class=&quot;title&quot; id=&quot;page-title&quot;&gt;
          [SOLVED] How to Fix on Ubuntu/Debian linux - MySQL/MariaDB: Out of resources when opening file (Errcode: 24)        &lt;/h1&gt;
                          &lt;div class=&quot;tabs&quot;&gt;
                  &lt;/div&gt;
                          &lt;div class=&quot;region region-content&quot;&gt;
    &lt;div id=&quot;block-system-main&quot; class=&quot;block block-system&quot;&gt;

    
  &lt;div class=&quot;content&quot;&gt;
    &lt;div id=&quot;node-50&quot; class=&quot;node node-story node-promoted node-full clearfix&quot;&gt;

      
      &lt;div class=&quot;meta submitted&quot;&gt;
            Submitted by &lt;span class=&quot;username&quot;&gt;admin&lt;/span&gt; on Tue, 03/11/2014 - 04:25    &lt;/div&gt;
  
  &lt;div class=&quot;content clearfix&quot;&gt;
    &lt;div class=&quot;facebookshare-box&quot;&gt;&lt;a name=&quot;fb_share&quot; type=&quot;box_count&quot; share_url=&quot;http://www.antojose.com/node/50&quot;&gt;&lt;/a&gt;&lt;script src=&quot;http://static.ak.fbcdn.net/connect.php/js/FB.Share&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;&lt;/div&gt;&lt;div class=&quot;g-plusone-wrapper&quot; style=&quot;margin: 0 1em 1em 1em;float:right&quot; &gt;&lt;g:plusone href=&quot;http://www.antojose.com/node/50&quot; annotation=&quot;bubble&quot; width=&quot;250&quot; &gt;&lt;/g:plusone&gt;&lt;/div&gt;&lt;div class=&quot;field field-name-body field-type-text-with-summary field-label-hidden&quot;&gt;&lt;div class=&quot;field-items&quot;&gt;&lt;div class=&quot;field-item even&quot;&gt;&lt;p&gt;This is an issue which occurs due to the maximum number of open files allowed for a process (mysql in this case) being very less that what is required - something that happens because you have lots of large tables / a large DB. To fix this, you just have to increase the limits in a few places.&lt;/p&gt;
&lt;p&gt;Here is how you do it:&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Step 1: Identify the issue&lt;/strong&gt;&lt;br /&gt;
as limit on the max number of open files (1024) for a single process (mysql) by doing these as &lt;code&gt;root&lt;/code&gt; user:&lt;br /&gt;&lt;code&gt;ulimit -a | grep open&lt;/code&gt;&lt;/p&gt;
&lt;pre&gt;
    root@server:/home/user# ulimit -a | grep open
    open files                      (-n) 1024
&lt;/pre&gt;&lt;p&gt;and&lt;br /&gt;&lt;code&gt;SHOW VARIABLES LIKE 'open%';&lt;/code&gt; done in MySQL commandline, logged in as MySQL root user.&lt;/p&gt;
&lt;pre&gt;
  root@server:/home/user# mysql -u root -p
  MariaDB [(none)]&amp;gt; SHOW VARIABLES LIKE 'open%';
  +------------------+-------+
  | Variable_name    | Value |
  +------------------+-------+
  | open_files_limit | 1024  |
  +------------------+-------+
  1 row in set (0.00 sec)
&lt;/pre&gt;&lt;p&gt;
&lt;br /&gt;&lt;strong&gt;Step 2: Do the Fix&lt;/strong&gt;&lt;/p&gt;
&lt;ol&gt;&lt;li&gt;To the file &lt;code&gt;/etc/security/limits.conf&lt;/code&gt;, add the following lines:&lt;br /&gt;&lt;pre&gt;
      mysql             soft    nofile           24000
      mysql             hard    nofile           32000
&lt;/pre&gt;&lt;/li&gt;
&lt;li&gt;To the file &lt;code&gt;/etc/pam.d/common-session&lt;/code&gt;, towards the end of the file, add the line:&lt;br /&gt;&lt;code&gt;session required pam_limits.so&lt;/code&gt;&lt;/li&gt;
&lt;li&gt;To the file &lt;code&gt;/etc/pam.d/common-session-noninteractive&lt;/code&gt;, towards the end of the file, add the line:&lt;br /&gt;&lt;code&gt;session required pam_limits.so&lt;/code&gt;&lt;/li&gt;
&lt;li&gt;To the file &lt;code&gt;/etc/my.cnf&lt;/code&gt;, under the section &lt;code&gt;'[mysqld]'&lt;/code&gt;, add the line:&lt;br /&gt;&lt;code&gt;open_files_limit = 24000&lt;/code&gt;&lt;/li&gt;
&lt;li&gt;Restart the server.&lt;/li&gt;
&lt;/ol&gt;&lt;p&gt;&lt;strong&gt;Step 3: Verify the fix with:&lt;/strong&gt;&lt;br /&gt;&lt;code&gt;root@server:/home/user# ulimit -a | grep open&lt;/code&gt;&lt;br /&gt;
and&lt;br /&gt;&lt;code&gt;MariaDB [(none)]&amp;gt; SHOW VARIABLES LIKE 'open%';&lt;/code&gt;&lt;/p&gt;
&lt;p&gt;--&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;References:&lt;/strong&gt;&lt;/p&gt;
&lt;ol&gt;&lt;li&gt;&lt;a href=&quot;http://stackoverflow.com/questions/502545/too-many-open-files-error-on-ubuntu-8-04&quot;&gt;http://stackoverflow.com/questions/502545/too-many-open-files-error-on-u...&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://secure.hens-teeth.net/orders/knowledgebase/109/MYSQL-Out-of-resources-when-opening-file-Errcode-24.html&quot;&gt;http://secure.hens-teeth.net/orders/knowledgebase/109/MYSQL-Out-of-resou...&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;https://forums.cpanel.net/f354/upgrade-mysql-5-5-sqlstate-hy000-general-error-23-out-resources-286172.html&quot;&gt;https://forums.cpanel.net/f354/upgrade-mysql-5-5-sqlstate-hy000-general-...&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://duntuk.com/how-raise-ulimit-open-files-and-mysql-openfileslimit&quot;&gt;http://duntuk.com/how-raise-ulimit-open-files-and-mysql-openfileslimit&lt;/a&gt;&lt;/li&gt;
&lt;/ol&gt;&lt;p&gt;--&lt;/p&gt;
&lt;p&gt;Did this help you out? Please let me know using the Comments box below. &lt;/p&gt;
&lt;p&gt;Cheers!&lt;/p&gt;
&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;field field-name-taxonomy-vocabulary-2 field-type-taxonomy-term-reference field-label-above clearfix&quot;&gt;&lt;h3 class=&quot;field-label&quot;&gt;Tags: &lt;/h3&gt;&lt;ul class=&quot;links&quot;&gt;&lt;li class=&quot;taxonomy-term-reference-0&quot;&gt;&lt;a href=&quot;/category/tags/mysql&quot;&gt;MySQL&lt;/a&gt;&lt;/li&gt;&lt;li class=&quot;taxonomy-term-reference-1&quot;&gt;&lt;a href=&quot;/taxonomy/term/213&quot;&gt;MariaDB&lt;/a&gt;&lt;/li&gt;&lt;li class=&quot;taxonomy-term-reference-2&quot;&gt;&lt;a href=&quot;/category/tags/ubuntu&quot;&gt;Ubuntu&lt;/a&gt;&lt;/li&gt;&lt;li class=&quot;taxonomy-term-reference-3&quot;&gt;&lt;a href=&quot;/category/tags/lamp&quot;&gt;LAMP&lt;/a&gt;&lt;/li&gt;&lt;li class=&quot;taxonomy-term-reference-4&quot;&gt;&lt;a href=&quot;/category/tags/linux&quot;&gt;Linux&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;&lt;/div&gt;  &lt;/div&gt;

      &lt;div class=&quot;link-wrapper&quot;&gt;
      &lt;ul class=&quot;links inline&quot;&gt;&lt;li class=&quot;statistics_counter first last&quot;&gt;&lt;span&gt;25085 reads&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;    &lt;/div&gt;
  
  &lt;div id=&quot;comments&quot; class=&quot;comment-wrapper&quot;&gt;
          &lt;h2 class=&quot;title&quot;&gt;Comments&lt;/h2&gt;
      
  &lt;a id=&quot;comment-54969&quot;&gt;&lt;/a&gt;
&lt;div class=&quot;comment comment-by-anonymous clearfix&quot;&gt;

  &lt;div class=&quot;attribution&quot;&gt;

    
    &lt;div class=&quot;submitted&quot;&gt;
      &lt;p class=&quot;commenter-name&quot;&gt;
        &lt;span class=&quot;username&quot;&gt;Antonio (not verified)&lt;/span&gt;      &lt;/p&gt;
      &lt;p class=&quot;comment-time&quot;&gt;
        Tue, 05/05/2015 - 05:55      &lt;/p&gt;
      &lt;p class=&quot;comment-permalink&quot;&gt;
        &lt;a href=&quot;/comment/54969#comment-54969&quot; class=&quot;permalink&quot; rel=&quot;bookmark&quot;&gt;Permalink&lt;/a&gt;      &lt;/p&gt;
    &lt;/div&gt;
  &lt;/div&gt;

  &lt;div class=&quot;comment-text&quot;&gt;
    &lt;div class=&quot;comment-arrow&quot;&gt;&lt;/div&gt;

    
        &lt;h3&gt;&lt;a href=&quot;/comment/54969#comment-54969&quot; class=&quot;permalink&quot; rel=&quot;bookmark&quot;&gt;Thanks!!&lt;/a&gt;&lt;/h3&gt;
    
    &lt;div class=&quot;content&quot;&gt;
      &lt;div class=&quot;field field-name-comment-body field-type-text-long field-label-hidden&quot;&gt;&lt;div class=&quot;field-items&quot;&gt;&lt;div class=&quot;field-item even&quot;&gt;&lt;p&gt;Thanks!&lt;br /&gt;
This solved my problems!&lt;/p&gt;
&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;          &lt;/div&gt; &lt;!-- /.content --&gt;

    &lt;ul class=&quot;links inline&quot;&gt;&lt;li class=&quot;comment-reply first last&quot;&gt;&lt;a href=&quot;/comment/reply/50/54969&quot;&gt;reply&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;  &lt;/div&gt; &lt;!-- /.comment-text --&gt;
&lt;/div&gt;
&lt;a id=&quot;comment-54977&quot;&gt;&lt;/a&gt;
&lt;div class=&quot;comment comment-by-anonymous clearfix&quot;&gt;

  &lt;div class=&quot;attribution&quot;&gt;

    
    &lt;div class=&quot;submitted&quot;&gt;
      &lt;p class=&quot;commenter-name&quot;&gt;
        &lt;span class=&quot;username&quot;&gt;Alejandro (not verified)&lt;/span&gt;      &lt;/p&gt;
      &lt;p class=&quot;comment-time&quot;&gt;
        Thu, 06/25/2015 - 08:51      &lt;/p&gt;
      &lt;p class=&quot;comment-permalink&quot;&gt;
        &lt;a href=&quot;/comment/54977#comment-54977&quot; class=&quot;permalink&quot; rel=&quot;bookmark&quot;&gt;Permalink&lt;/a&gt;      &lt;/p&gt;
    &lt;/div&gt;
  &lt;/div&gt;

  &lt;div class=&quot;comment-text&quot;&gt;
    &lt;div class=&quot;comment-arrow&quot;&gt;&lt;/div&gt;

    
        &lt;h3&gt;&lt;a href=&quot;/comment/54977#comment-54977&quot; class=&quot;permalink&quot; rel=&quot;bookmark&quot;&gt;This solved my problem! Thanks!&lt;/a&gt;&lt;/h3&gt;
    
    &lt;div class=&quot;content&quot;&gt;
      &lt;div class=&quot;field field-name-comment-body field-type-text-long field-label-hidden&quot;&gt;&lt;div class=&quot;field-items&quot;&gt;&lt;div class=&quot;field-item even&quot;&gt;&lt;p&gt;I'm running Debian Wheezy and Mysql 5.6. My problem was that after reboot, mysql was always starting with 1024, and after a manual restart this parameter got the right value.&lt;br /&gt;
I was missing the &quot;session required pam_limits.so&quot; lines. &lt;/p&gt;
&lt;p&gt;Thanks you!&lt;/p&gt;
&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;          &lt;/div&gt; &lt;!-- /.content --&gt;

    &lt;ul class=&quot;links inline&quot;&gt;&lt;li class=&quot;comment-reply first last&quot;&gt;&lt;a href=&quot;/comment/reply/50/54977&quot;&gt;reply&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;  &lt;/div&gt; &lt;!-- /.comment-text --&gt;
&lt;/div&gt;
&lt;a id=&quot;comment-54989&quot;&gt;&lt;/a&gt;
&lt;div class=&quot;comment comment-by-anonymous clearfix&quot;&gt;

  &lt;div class=&quot;attribution&quot;&gt;

    
    &lt;div class=&quot;submitted&quot;&gt;
      &lt;p class=&quot;commenter-name&quot;&gt;
        &lt;span class=&quot;username&quot;&gt;steward (not verified)&lt;/span&gt;      &lt;/p&gt;
      &lt;p class=&quot;comment-time&quot;&gt;
        Sat, 11/07/2015 - 22:07      &lt;/p&gt;
      &lt;p class=&quot;comment-permalink&quot;&gt;
        &lt;a href=&quot;/comment/54989#comment-54989&quot; class=&quot;permalink&quot; rel=&quot;bookmark&quot;&gt;Permalink&lt;/a&gt;      &lt;/p&gt;
    &lt;/div&gt;
  &lt;/div&gt;

  &lt;div class=&quot;comment-text&quot;&gt;
    &lt;div class=&quot;comment-arrow&quot;&gt;&lt;/div&gt;

    
        &lt;h3&gt;&lt;a href=&quot;/comment/54989#comment-54989&quot; class=&quot;permalink&quot; rel=&quot;bookmark&quot;&gt;Thanks for posting.&lt;/a&gt;&lt;/h3&gt;
    
    &lt;div class=&quot;content&quot;&gt;
      &lt;div class=&quot;field field-name-comment-body field-type-text-long field-label-hidden&quot;&gt;&lt;div class=&quot;field-items&quot;&gt;&lt;div class=&quot;field-item even&quot;&gt;&lt;p&gt;Thanks for posting.&lt;/p&gt;
&lt;p&gt;ulimit- a still showed 1024 after reboot. But sql showed 24000.&lt;/p&gt;
&lt;p&gt;It fixed my issue,  was able to continue working. Great!&lt;/p&gt;
&lt;p&gt;I understand increasing the limits for sql. The pam stuff made no sense.&lt;/p&gt;
&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;          &lt;/div&gt; &lt;!-- /.content --&gt;

    &lt;ul class=&quot;links inline&quot;&gt;&lt;li class=&quot;comment-reply first last&quot;&gt;&lt;a href=&quot;/comment/reply/50/54989&quot;&gt;reply&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;  &lt;/div&gt; &lt;!-- /.comment-text --&gt;
&lt;/div&gt;

      &lt;h2 class=&quot;title comment-form&quot;&gt;Add new comment&lt;/h2&gt;
    &lt;form class=&quot;comment-form user-info-from-cookie&quot; action=&quot;/comment/reply/50&quot; method=&quot;post&quot; id=&quot;comment-form&quot; accept-charset=&quot;UTF-8&quot;&gt;&lt;div&gt;&lt;div class=&quot;form-item form-type-textfield form-item-name&quot;&gt;
  &lt;label for=&quot;edit-name&quot;&gt;Your name &lt;span class=&quot;form-required&quot; title=&quot;This field is required.&quot;&gt;*&lt;/span&gt;&lt;/label&gt;
 &lt;input type=&quot;text&quot; id=&quot;edit-name&quot; name=&quot;name&quot; value=&quot;&quot; size=&quot;30&quot; maxlength=&quot;60&quot; class=&quot;form-text required&quot; /&gt;
&lt;/div&gt;
&lt;div class=&quot;form-item form-type-textfield form-item-mail&quot;&gt;
  &lt;label for=&quot;edit-mail&quot;&gt;E-mail &lt;span class=&quot;form-required&quot; title=&quot;This field is required.&quot;&gt;*&lt;/span&gt;&lt;/label&gt;
 &lt;input type=&quot;text&quot; id=&quot;edit-mail&quot; name=&quot;mail&quot; value=&quot;&quot; size=&quot;30&quot; maxlength=&quot;64&quot; class=&quot;form-text required&quot; /&gt;
&lt;div class=&quot;description&quot;&gt;The content of this field is kept private and will not be shown publicly.&lt;/div&gt;
&lt;/div&gt;
&lt;div class=&quot;form-item form-type-textfield form-item-homepage&quot;&gt;
  &lt;label for=&quot;edit-homepage&quot;&gt;Homepage &lt;/label&gt;
 &lt;input type=&quot;text&quot; id=&quot;edit-homepage&quot; name=&quot;homepage&quot; value=&quot;&quot; size=&quot;30&quot; maxlength=&quot;255&quot; class=&quot;form-text&quot; /&gt;
&lt;/div&gt;
&lt;div class=&quot;form-item form-type-textfield form-item-subject&quot;&gt;
  &lt;label for=&quot;edit-subject&quot;&gt;Subject &lt;/label&gt;
 &lt;input type=&quot;text&quot; id=&quot;edit-subject&quot; name=&quot;subject&quot; value=&quot;&quot; size=&quot;60&quot; maxlength=&quot;64&quot; class=&quot;form-text&quot; /&gt;
&lt;/div&gt;
&lt;div class=&quot;field-type-text-long field-name-comment-body field-widget-text-textarea form-wrapper&quot; id=&quot;edit-comment-body&quot;&gt;&lt;div id=&quot;comment-body-add-more-wrapper&quot;&gt;&lt;div class=&quot;text-format-wrapper&quot;&gt;&lt;div class=&quot;form-item form-type-textarea form-item-comment-body-und-0-value&quot;&gt;
  &lt;label for=&quot;edit-comment-body-und-0-value&quot;&gt;Comment &lt;span class=&quot;form-required&quot; title=&quot;This field is required.&quot;&gt;*&lt;/span&gt;&lt;/label&gt;
 &lt;div class=&quot;form-textarea-wrapper resizable&quot;&gt;&lt;textarea class=&quot;text-full form-textarea required&quot; id=&quot;edit-comment-body-und-0-value&quot; name=&quot;comment_body[und][0][value]&quot; cols=&quot;60&quot; rows=&quot;5&quot;&gt;&lt;/textarea&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;fieldset class=&quot;filter-wrapper form-wrapper&quot; id=&quot;edit-comment-body-und-0-format&quot;&gt;&lt;div class=&quot;fieldset-wrapper&quot;&gt;&lt;div class=&quot;filter-help form-wrapper&quot; id=&quot;edit-comment-body-und-0-format-help&quot;&gt;&lt;p&gt;&lt;a href=&quot;/filter/tips&quot; target=&quot;_blank&quot;&gt;More information about text formats&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;&lt;div class=&quot;form-item form-type-select form-item-comment-body-und-0-format&quot;&gt;
  &lt;label for=&quot;edit-comment-body-und-0-format--2&quot;&gt;Text format &lt;/label&gt;
 &lt;select class=&quot;filter-list form-select&quot; id=&quot;edit-comment-body-und-0-format--2&quot; name=&quot;comment_body[und][0][format]&quot;&gt;&lt;option value=&quot;1&quot; selected=&quot;selected&quot;&gt;Filtered HTML&lt;/option&gt;&lt;option value=&quot;3&quot;&gt;Plain text&lt;/option&gt;&lt;/select&gt;
&lt;/div&gt;
&lt;div class=&quot;filter-guidelines form-wrapper&quot; id=&quot;edit-comment-body-und-0-format-guidelines&quot;&gt;&lt;div class=&quot;filter-guidelines-item filter-guidelines-1&quot;&gt;&lt;h3&gt;Filtered HTML&lt;/h3&gt;&lt;ul class=&quot;tips&quot;&gt;&lt;li&gt;Web page addresses and e-mail addresses turn into links automatically.&lt;/li&gt;&lt;li&gt;Allowed HTML tags: &amp;lt;a&amp;gt; &amp;lt;em&amp;gt; &amp;lt;strong&amp;gt; &amp;lt;cite&amp;gt; &amp;lt;blockquote&amp;gt; &amp;lt;code&amp;gt; &amp;lt;ul&amp;gt; &amp;lt;ol&amp;gt; &amp;lt;li&amp;gt; &amp;lt;dl&amp;gt; &amp;lt;dt&amp;gt; &amp;lt;dd&amp;gt;&lt;/li&gt;&lt;li&gt;Lines and paragraphs break automatically.&lt;/li&gt;&lt;/ul&gt;&lt;/div&gt;&lt;div class=&quot;filter-guidelines-item filter-guidelines-3&quot;&gt;&lt;h3&gt;Plain text&lt;/h3&gt;&lt;ul class=&quot;tips&quot;&gt;&lt;li&gt;No HTML tags allowed.&lt;/li&gt;&lt;li&gt;Web page addresses and e-mail addresses turn into links automatically.&lt;/li&gt;&lt;li&gt;Lines and paragraphs break automatically.&lt;/li&gt;&lt;/ul&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/fieldset&gt;
&lt;/div&gt;
&lt;/div&gt;&lt;/div&gt;&lt;input type=&quot;hidden&quot; name=&quot;form_build_id&quot; value=&quot;form-Ao2hPsIyqg940mB7jq5_qUgcAy6kZo9Nffq_tpZBcZE&quot; /&gt;
&lt;input type=&quot;hidden&quot; name=&quot;form_id&quot; value=&quot;comment_node_story_form&quot; /&gt;
&lt;input type=&quot;hidden&quot; name=&quot;honeypot_time&quot; value=&quot;1485915216|iy2hZ7uHNnLmDoGZWh9Q0ZxRvi8hYFOsvCzcc5p6cis&quot; /&gt;
&lt;div class=&quot;edit-your-site-info-wrapper&quot;&gt;&lt;div class=&quot;form-item form-type-textfield form-item-your-site-info&quot;&gt;
  &lt;label for=&quot;edit-your-site-info&quot;&gt;your site info &lt;/label&gt;
 &lt;input type=&quot;text&quot; id=&quot;edit-your-site-info&quot; name=&quot;your_site_info&quot; value=&quot;&quot; size=&quot;20&quot; maxlength=&quot;128&quot; class=&quot;form-text&quot; /&gt;
&lt;div class=&quot;description&quot;&gt;To prevent automated spam submissions leave this field empty.&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;&lt;fieldset class=&quot;captcha form-wrapper&quot;&gt;&lt;legend&gt;&lt;span class=&quot;fieldset-legend&quot;&gt;CAPTCHA&lt;/span&gt;&lt;/legend&gt;&lt;div class=&quot;fieldset-wrapper&quot;&gt;&lt;div class=&quot;fieldset-description&quot;&gt;This question is for testing whether you are a human visitor and to prevent automated spam submissions.&lt;/div&gt;&lt;input type=&quot;hidden&quot; name=&quot;captcha_sid&quot; value=&quot;1856863&quot; /&gt;
&lt;input type=&quot;hidden&quot; name=&quot;captcha_token&quot; value=&quot;254c81d57e8f432a0e50f2e3fb45e2be&quot; /&gt;
&lt;input type=&quot;hidden&quot; name=&quot;captcha_response&quot; value=&quot;Google no captcha&quot; /&gt;
&lt;div class=&quot;g-recaptcha&quot; data-sitekey=&quot;6Ld5bLsSAAAAANKFr9RquMuO325oHEOs4-HiqGqD&quot; data-theme=&quot;light&quot; data-type=&quot;image&quot;&gt;&lt;/div&gt;&lt;/div&gt;&lt;/fieldset&gt;
&lt;div class=&quot;your_site_url-textfield&quot;&gt;&lt;div class=&quot;form-item form-type-textfield form-item-your-site-url&quot;&gt;
  &lt;label for=&quot;edit-your-site-url&quot;&gt;Leave this field blank &lt;/label&gt;
 &lt;input autocomplete=&quot;off&quot; type=&quot;text&quot; id=&quot;edit-your-site-url&quot; name=&quot;your_site_url&quot; value=&quot;&quot; size=&quot;20&quot; maxlength=&quot;128&quot; class=&quot;form-text&quot; /&gt;
&lt;/div&gt;
&lt;/div&gt;&lt;div class=&quot;form-actions form-wrapper&quot; id=&quot;edit-actions&quot;&gt;&lt;input type=&quot;submit&quot; id=&quot;edit-preview&quot; name=&quot;op&quot; value=&quot;Preview&quot; class=&quot;form-submit&quot; /&gt;&lt;/div&gt;&lt;/div&gt;&lt;/form&gt;  &lt;/div&gt;

&lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;
  &lt;/div&gt;
      
    &lt;/div&gt;&lt;/div&gt; &lt;!-- /.section, /#content --&gt;

          &lt;div id=&quot;sidebar-second&quot; class=&quot;column sidebar&quot;&gt;&lt;div class=&quot;section&quot;&gt;
          &lt;div class=&quot;region region-sidebar-second&quot;&gt;
    &lt;div id=&quot;block-block-7&quot; class=&quot;block block-block&quot;&gt;

    
  &lt;div class=&quot;content&quot;&gt;
    &lt;p&gt;&lt;a href=&quot;https://drupal.org/user/721940&quot; target=&quot;_blank&quot;&gt;&lt;img src=&quot;https://assoc.drupal.org/files/Drupal_Association_ind_member_217.png&quot; style=&quot;height: 170px;&quot; /&gt;&lt;/a&gt;&lt;/p&gt;
  &lt;/div&gt;
&lt;/div&gt;
&lt;div id=&quot;block-system-navigation&quot; class=&quot;block block-system block-menu&quot;&gt;

    &lt;h2&gt;Navigation&lt;/h2&gt;
  
  &lt;div class=&quot;content&quot;&gt;
    &lt;ul class=&quot;menu clearfix&quot;&gt;&lt;li class=&quot;first last leaf&quot;&gt;&lt;a href=&quot;/contact&quot;&gt;Contact&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;  &lt;/div&gt;
&lt;/div&gt;
&lt;div id=&quot;block-block-8&quot; class=&quot;block block-block&quot;&gt;

    
  &lt;div class=&quot;content&quot;&gt;
    &lt;p&gt;&lt;a href=&quot;http://www.phptherightway.com&quot;&gt;&lt;br /&gt;&lt;img src=&quot;http://www.phptherightway.com/images/banners/rect-180x150.png&quot; alt=&quot;PHP: The Right Way&quot; /&gt;&lt;br /&gt;&lt;/a&gt;&lt;/p&gt;
  &lt;/div&gt;
&lt;/div&gt;
  &lt;/div&gt;
      &lt;/div&gt;&lt;/div&gt; &lt;!-- /.section, /#sidebar-second --&gt;
    
  &lt;/div&gt;&lt;/div&gt; &lt;!-- /#main, /#main-wrapper --&gt;

  
  &lt;div id=&quot;footer-wrapper&quot;&gt;&lt;div class=&quot;section&quot;&gt;

    
          &lt;div id=&quot;footer&quot; class=&quot;clearfix&quot;&gt;
          &lt;div class=&quot;region region-footer&quot;&gt;
    &lt;div id=&quot;block-block-5&quot; class=&quot;block block-block&quot;&gt;

    
  &lt;div class=&quot;content&quot;&gt;
    &lt;p&gt;&quot;Be the change you wish to see in the world!&quot; - M. K. Gandhi&lt;/p&gt;
  &lt;/div&gt;
&lt;/div&gt;
&lt;div id=&quot;block-system-powered-by&quot; class=&quot;block block-system&quot;&gt;

    
  &lt;div class=&quot;content&quot;&gt;
    &lt;span&gt;Powered by &lt;a href=&quot;https://www.drupal.org&quot;&gt;Drupal&lt;/a&gt;&lt;/span&gt;  &lt;/div&gt;
&lt;/div&gt;
  &lt;/div&gt;
      &lt;/div&gt; &lt;!-- /#footer --&gt;
    
  &lt;/div&gt;&lt;/div&gt; &lt;!-- /.section, /#footer-wrapper --&gt;

&lt;/div&gt;&lt;/div&gt; &lt;!-- /#page, /#page-wrapper --&gt;
    &lt;div class=&quot;region region-page-bottom&quot;&gt;
    &lt;div&gt;&lt;a rel=&quot;nofollow&quot; href=&quot;http://www.shadow-realm.org/testimonial.php?ad=94613&quot;&gt;&lt;!-- randomness --&gt;&lt;/a&gt;&lt;/div&gt;  &lt;/div&gt;
&lt;/body&gt;
&lt;/html&gt;