barracuda_log.txt

Wed Feb 16 23:10:17 UTC 2011 / Ubuntu.lucid i686 / Aegir 0.4-boa-C / Barracuda 0.4-boa-C / Nginx 0.9.3 / PHP 5.2.17
Mon Mar 14 14:02:07 UTC 2011 / Ubuntu.lucid i686 / Aegir 1.0-boa-T / Barracuda 1.0-boa-T / Nginx 0.9.5 / PHP 5.2.17
Fri Apr  8 18:57:20 UTC 2011 / Ubuntu.lucid i686 / Aegir 1.0-boa-T-5 / Barracuda 1.0-boa-T-5 / Nginx 0.9.5 / PHP 5.2.17
Thu Apr 28 18:37:39 UTC 2011 / Ubuntu.lucid i686 / Aegir 1.0-boa-T-8.2 / Barracuda 1.0-boa-T-8.2 / Nginx 1.0.0 / PHP 5.2.17
Mon Jun 13 17:11:05 UTC 2011 / Ubuntu.lucid i686 / Aegir 1.0-boa-T-8.7 / Barracuda 1.0-boa-T-8.7 / Nginx 1.0.2 / PHP 5.2.17

install.log

==> MySQL is listening on ***.***.***.***.
==> This script makes the following assumptions:
 * you have read INSTALL.txt and prepared the platform accordingly
 * you are running as your "aegir" user
==> Aegir will now generate a mysql super user password for you:
  Username : aegir_root
  Password : *******
  Hostname : ***.*****.com (***.***.***.***)
==> Installing drush in /var/aegir
==> Drush seems to be functioning properly
==> Installing provision backend in /var/aegir/.drush
==> Installing the frontend
Aegir 0.4-boa-C automated install script
==============================================================================
Some settings have not been provided and will now be prompted.
Don't worry: you will get to review those settings after the final install

This script will operate the following changes in your system:

1. Create server-level configuration directories
2. Download drush_make
3. Create the Hostmaster frontend platform
4. Install the frontend site
5. Setup the dispatcher (a user cron job)

We are making the following assumptions:
 * you have read INSTALL.txt and prepared the platform accordingly
 * the FQDN of this machine is valid and resolves
 * you are executing this script as your "aegir" user

The following settings will be used:
 Aegir frontend URL: ***.***.com
 Master server FQDN: ***.***.com
 Aegir root: /var/aegir
 Aegir user: aegir
 Web group: www-data
 Web server: nginx
 Aegir DB host: ***.***.com
 Aegir DB user: aegir_root
 Aegir DB password: <previously set>
 Drush make version: 6.x-2.0-beta11
 Aegir version: 0.4-boa-C
 Aegir platform path: /var/aegir/hostmaster-0.4-boa-C
 Aegir makefile: /var/aegir/.drush/provision/aegir.make
 Client email: ***@***.com

Do you really want to proceed with the install (y/n): y
Project drush_make (6.x-2.0-beta11) downloaded to /var/aegir/.drush/drush_make.         ^[[0;33;40m^[[1m[success]^[[0m
pressflow downloaded from lp:pressflow/6.x.                                             ^[[0;33;40m^[[1m[ok]^[[0m
hostmaster downloaded from http://files.aegir.cc/versions/hostmaster-0.4-boa-C.tar.gz.  ^[[0;33;40m^[[1m[ok]^[[0m
Found makefile: hostmaster.make                                                         ^[[0;33;40m^[[1m[ok]^[[0m
Project information for admin_menu retrieved.                                           ^[[0;33;40m^[[1m[ok]^[[0m
Project information for openidadmin retrieved.                                          ^[[0;33;40m^[[1m[ok]^[[0m
Project information for install_profile_api retrieved.                                  ^[[0;33;40m^[[1m[ok]^[[0m
Project information for jquery_ui retrieved.                                            ^[[0;33;40m^[[1m[ok]^[[0m
Project information for modalframe retrieved.                                           ^[[0;33;40m^[[1m[ok]^[[0m
admin_menu downloaded from                                                              ^[[0;33;40m^[[1m[ok]^[[0m
http://ftp.drupal.org/files/projects/admin_menu-6.x-1.6.tar.gz.
openidadmin downloaded from                                                             ^[[0;33;40m^[[1m[ok]^[[0m
http://ftp.drupal.org/files/projects/openidadmin-6.x-1.2.tar.gz.
install_profile_api downloaded from                                                     ^[[0;33;40m^[[1m[ok]^[[0m
http://ftp.drupal.org/files/projects/install_profile_api-6.x-2.1.tar.gz.
jquery_ui downloaded from http://ftp.drupal.org/files/projects/jquery_ui-6.x-1.3.tar.gz.^[[0;33;40m^[[1m[ok]^[[0m
modalframe downloaded from                                                              ^[[0;33;40m^[[1m[ok]^[[0m
http://ftp.drupal.org/files/projects/modalframe-6.x-1.6.tar.gz.
jquery_ui downloaded from http://omega8.cc/dev/jquery.ui-1.6.zip.                       ^[[0;33;40m^[[1m[ok]^[[0m
Created ******* database                                                                ^[[0;33;40m^[[1m[success]^[[0m
Initializing the hosting system
Dispatch command was run successfully                                                   ^[[0;33;40m^[[1m[success]^[[0m
This command will replace your crontab for this user. continue? (y/n): y
/var/aegir/drush/drush.php '@hostmaster' hosting-dispatch
Aegir is now installed. You can visit it at http://***.***.com/user/reset/1/....

my.cnf

--- /etc/mysql/my.cnf   2011-06-13 17:11:52.000000000 +0000
+++ /etc/mysql/my.cnf.dpkg-new  2011-12-03 22:57:57.000000000 +0000
@@ -1,103 +1,195 @@
+# MariaDB database server configuration file.
+#
+# =================================================================
+# Base configuration courtesy of Open Query (http://openquery.com/)
+# For production use, case-specific preparation is still required.
+# 2009-10-07
+#
+# This is *not* an optimised config, merely a more sane baseline:
+# - InnoDB default (e.g., ACID out-of-the-box, same as on Windows)
+# - strict mode (for proper input checks, same as on Windows)
+# - various other useful settings
+# - make use of MariaDB/Percona/OurDelta enhancements/extensions
+#
+# For tuning assistance, please see http://openquery.com/services
+# =================================================================
+#
+# You can copy this file 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
-default-character-set   = utf8
+port           = 3306
+socket         = /var/run/mysqld/mysqld.sock
+# Default is Latin1, if you need UTF-8 set this (also in server section)
+#default-character-set  = utf8 
+
+# 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]
-user                    = mysql
-pid-file                = /var/run/mysqld/mysqld.pid
-socket                  = /var/run/mysqld/mysqld.sock
-port                    = 3306
-basedir                 = /usr
-datadir                 = /var/lib/mysql
-tmpdir                  = /tmp
-language                = /usr/share/mysql/english
-character_set_server    = utf8
-collation_server        = utf8_general_ci
+#
+# * Basic Settings
+#
+user           = mysql
+pid-file       = /var/run/mysqld/mysqld.pid
+socket         = /var/run/mysqld/mysqld.sock
+port           = 3306
+basedir                = /usr
+datadir                = /var/lib/mysql
+tmpdir         = /tmp
+language       = /usr/share/mysql/english
 skip-external-locking
-connect_timeout         = 300
-join_buffer_size        = 1M
-key_buffer              = 1M
-key_buffer_size         = 32M
-log_warnings            = 2
-max_allowed_packet      = 32M
-max_connect_errors      = 30
-max_connections         = 30
-max_user_connections    = 30
-myisam_sort_buffer_size = 64K
-query_cache_limit       = 128K
-query_cache_size        = 32M
-query_cache_type        = 1
-read_buffer_size        = 8M
-read_rnd_buffer_size    = 4M
-sort_buffer_size        = 64K
-bulk_insert_buffer_size = 64K
-table_open_cache        = 64
-table_definition_cache  = 512
-thread_stack            = 256K
+#
+# * Character sets
+# 
+# Default is Latin1, if you need UTF-8 set all this (also in client section)
+#
+#default-character-set  = utf8 
+#default-collation      = utf8_general_ci 
+#character_set_server   = utf8 
+#collation_server       = utf8_general_ci 
+#
+# 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
+#
+max_connections                = 100
+connect_timeout                = 5
+wait_timeout           = 600
+max_allowed_packet     = 16M
 thread_cache_size       = 128
-thread_concurrency      = 8
-wait_timeout            = 300
-tmp_table_size          = 32M
-max_heap_table_size     = 128M
-low_priority_updates    = 1
-concurrent_insert       = 2
-max_tmp_tables          = 16384
-server-id               = 8
-myisam-recover          = BACKUP
-log_bin                 = /var/log/mysql/mariadb-bin
-log_bin_index           = /var/log/mysql/mariadb-bin.index
-expire_logs_days        = 1
-max_binlog_size         = 100M
-open_files_limit        = 196608
+sort_buffer_size       = 4M
+bulk_insert_buffer_size        = 16M
+tmp_table_size         = 32M
+max_heap_table_size    = 32M
+#
+# * MyISAM
+#
+# This replaces the startup script and checks MyISAM tables if needed
+# the first time they are touched. On error, make copy and try a repair.
+myisam_recover          = BACKUP
+key_buffer_size                = 128M
+#open-files-limit      = 2000
+table_cache             = 400
+myisam_sort_buffer_size        = 512M
+concurrent_insert      = 2
+read_buffer_size       = 2M
+read_rnd_buffer_size   = 1M
+#
+# * Query Cache Configuration
+#
+# Cache only tiny result sets, so we can fit more in the query cache.
+query_cache_limit              = 128K
+query_cache_size               = 64M
+# for more write intensive setups, set to DEMAND or OFF
+#query_cache_type              = DEMAND
+#
+# * 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
+#
+# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
+#
+# we do want to know about network errors and such
+log_warnings           = 2
+#
+# Enable the slow query log to see queries with especially long duration
+#slow_query_log[={0|1}]
+slow_query_log_file    = /var/log/mysql/mariadb-slow.log
+long_query_time = 10
+#log_slow_rate_limit   = 1000
+log_slow_verbosity     = query_plan
 
+#log-queries-not-using-indexes
+#log_slow_admin_statements
+#
+# 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.
+#server-id             = 1
+#report_host           = master1
+#auto_increment_increment = 2
+#auto_increment_offset = 1
+log_bin                        = /var/log/mysql/mariadb-bin
+log_bin_index          = /var/log/mysql/mariadb-bin.index
+# not fab for performance, but safer
+#sync_binlog           = 1
+expire_logs_days       = 10
+max_binlog_size         = 100M
+# slaves
+#relay_log             = /var/log/mysql/relay-bin
+#relay_log_index       = /var/log/mysql/relay-bin.index
+#relay_log_info_file   = /var/log/mysql/relay-bin.info
+#log_slave_updates
+#read_only
+#
+# If applications support it, this stricter sql_mode prevents some
+# mistakes like inserting invalid dates etc.
+#sql_mode              = NO_ENGINE_SUBSTITUTION,TRADITIONAL
+#
 # * 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!
-default_storage_engine  = InnoDB
-sql_mode                = NO_ENGINE_SUBSTITUTION
+default_storage_engine = InnoDB
 # you can't just change log file size, requires special procedure
-#innodb_log_file_size   = 50M
-innodb_buffer_pool_size = 326M
-innodb_log_buffer_size  = 4M
-innodb_file_per_table   = 1
-innodb_open_files       = 256
-innodb_io_capacity      = 512
-innodb_flush_method     = O_DIRECT
-# MariaDB only, breaks Percona
-default-table-type      = innodb
-innodb_flush_log_at_trx_commit = 2
-innodb_thread_concurrency = 8
+#innodb_log_file_size  = 50M
+innodb_buffer_pool_size        = 256M
+innodb_log_buffer_size = 8M
+innodb_file_per_table  = 1
+innodb_open_files      = 400
+innodb_io_capacity     = 400
+innodb_flush_method    = O_DIRECT
+#
+# * 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
 
 
-[mysqld_safe]
-socket                  = /var/run/mysqld/mysqld.sock
-nice                    = 0
-open_files_limit        = 196608
-syslog
 
 [mysqldump]
 quick
-max_allowed_packet      = 32M
 quote-names
+max_allowed_packet     = 16M
 
 [mysql]
-no-auto-rehash
-
-[myisamchk]
-key_buffer              = 1M
-sort_buffer_size        = 64K
-read_buffer             = 4M
-write_buffer            = 4M
+#no-auto-rehash        # faster start of mysql but no tab completition
 
 [isamchk]
-key_buffer              = 1M
-sort_buffer_size        = 64K
-read_buffer             = 4M
-write_buffer            = 4M
-
-[mysqlhotcopy]
-interactive-timeout
+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/