From 8bea60fb10b63d310720d6f5b1566156412242fc Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Wed, 15 Aug 2012 18:20:53 -0300
Subject: Fixing Out of Resource Problem with MySQL (Errcode: 24)

---
 manifests/subsystems/database.pp | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'manifests')

diff --git a/manifests/subsystems/database.pp b/manifests/subsystems/database.pp
index 87e5162..deb905c 100644
--- a/manifests/subsystems/database.pp
+++ b/manifests/subsystems/database.pp
@@ -1,6 +1,15 @@
 class database {
   include mysql::server
 
+  # See http://www.smilecouple.org/2011/03/01/fix-out-of-resource-problem-with-mysql
+  file { '/etc/security/limits.d/mysql.conf':
+    ensure  => present,
+    owner   => root,
+    group   => root,
+    mode    => 0644,
+    content => "mysql soft nofile 24000\nmysql hard nofile 32000\n",
+  }
+
   # Database definitions
   define instance($password, $ensure = 'present', $privileges = 'all') {
     mysql_database { "$name":
-- 
cgit v1.2.3