The puppet install works great! Looking forward to v2 ;) Best Regards Steve James
On 15 Feb 2012, at 12:12, "Glenn Kelley" <[email protected]> wrote: > that makes a lot of sense. > > the SpamSnake setup is GREAT but a bit dated. > I have been in contact w/ the author -and he is working to update the > directions. > > I have found some issues w/ that myself. > Might try to setup from scratch using the puppet install. > > 1&1 might be able to push that for you themselves - might be worth asking > > On Feb 15, 2012, at 7:05 AM, ManicD wrote: > >> This is the /etc/mysql/my.cnf file...i assume thats what you want there is >> not a my.cnf in etc >> >> >> Might i note to everyone at this point that the setup was a Spamsnake setup >> http://www.howtoforge.com/the-perfect-spamsnake-ubuntu-jeos-10.10-maverick-meerkat >> >> >> Ash >> >> >> >> # The MySQL database server configuration file. >> # >> # You can copy this to one of: >> # - "/etc/mysql/my.cnf" to set global options, >> # - "~/.my.cnf" to set user-specific options. >> # >> # One can use all long options that the program supports. >> # Run program with --help to get a list of available options and with >> # --print-defaults to see which it would actually understand and use. >> # >> # For explanations see >> # http://dev.mysql.com/doc/mysql/en/server-system-variables.html >> >> # This will be passed to all mysql clients >> # It has been reported that passwords should be enclosed with ticks/quotes >> # escpecially if they contain "#" chars... >> # Remember to edit /etc/mysql/debian.cnf when changing the socket location. >> [client] >> port = 3306 >> socket = /var/run/mysqld/mysqld.sock >> >> # Here is entries for some specific programs >> # The following values assume you have at least 32M ram >> >> # This was formally known as [safe_mysqld]. Both versions are currently >> parsed. >> [mysqld_safe] >> socket = /var/run/mysqld/mysqld.sock >> nice = 0 >> >> >> >> [mysqld] >> # >> # * Basic Settings >> # >> >> # >> # * IMPORTANT >> # If you make changes to these settings and your system uses apparmor, you >> may >> # also need to also adjust /etc/apparmor.d/usr.sbin.mysqld. >> # >> >> user = mysql >> socket = /var/run/mysqld/mysqld.sock >> port = 3306 >> basedir = /usr >> datadir = /var/lib/mysql >> tmpdir = /tmp >> skip-external-locking >> # >> # Instead of skip-networking the default is now to listen only on >> # localhost which is more compatible and is not less secure. >> bind-address = 127.0.0.1 >> # >> # * Fine Tuning >> # >> key_buffer = 16M >> max_allowed_packet = 16M >> thread_stack = 192K >> thread_cache_size = 8 >> >> >> >> # the first time they are touched >> myisam-recover = BACKUP >> #max_connections = 100 >> #table_cache = 64 >> #thread_concurrency = 10 >> # >> # * Query Cache Configuration >> # >> query_cache_limit = 1M >> query_cache_size = 16M >> # >> # * Logging and Replication >> # >> # Both location gets rotated by the cronjob. >> # Be aware that this log type is a performance killer. >> # As of 5.1 you can enable the log at runtime! >> #general_log_file = /var/log/mysql/mysql.log >> #general_log = 1 >> >> log_error = /var/log/mysql/error.log >> >> # Here you can see queries with especially long duration >> #log_slow_queries = /var/log/mysql/mysql-slow.log >> #long_query_time = 2 >> #log-queries-not-using-indexes >> # >> # The following can be used as easy to replay backup logs or for >> replication. >> # note: if you are setting up a replication slave, see README.Debian about >> # other settings you may need to change. >> >> >> #log_bin = /var/log/mysql/mysql-bin.log >> expire_logs_days = 10 >> max_binlog_size = 100M >> #binlog_do_db = include_database_name >> #binlog_ignore_db = include_database_name >> # >> # * InnoDB >> # >> # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. >> # Read the manual for more InnoDB related options. There are many! >> # >> # * Security Features >> # >> # Read the manual, too, if you want chroot! >> # chroot = /var/lib/mysql/ >> # >> # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". >> # >> # ssl-ca=/etc/mysql/cacert.pem >> # ssl-cert=/etc/mysql/server-cert.pem >> # ssl-key=/etc/mysql/server-key.pem >> >> >> >> [mysqldump] >> quick >> quote-names >> max_allowed_packet = 16M >> >> [mysql] >> #no-auto-rehash # faster start of mysql but no tab completition >> >> [isamchk] >> key_buffer = 16M >> >> # >> # * IMPORTANT: Additional settings that can override those from this file! >> # The files must end with '.cnf', otherwise they'll be ignored. >> # >> !includedir /etc/mysql/conf.d/ >> >> >> -- >> View this message in context: >> http://baruwa-users-list.963389.n3.nabble.com/Baruwa-VERY-slow-tp3746553p3746726.html >> Sent from the Baruwa users list mailing list archive at Nabble.com. >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > -- > This message has been scanned for viruses and dangerous content by > Swanseahost.co.uk, and is believed to be clean. > -- This message has been scanned for viruses and dangerous content by Swanseahost.co.uk, and is believed to be clean. _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
