# This is data only part of buildout for mysql with senna # made by Leonardo Rochael Almeida <leorochael@gmail.com> (thanks!) # Original place: https://svn.erp5.org/repos/public/experimental/mysqlsenna.buildout/ [buildout] parts = mysql-instance [configuration] mysql_port = 10002 mysql_host = 127.0.0.1 mysql_datadir = ${buildout:var-directory}/mysql mysql_pid = ${:mysql_datadir}/mysql.pid mysql_sock = ${:mysql_datadir}/mysql.sock mysql_error_log = ${buildout:log-directory}/mysql.err.log mysql_cnf_file = ${buildout:etc-directory}/my.cnf [mysql-bin] recipe = collective.recipe.template input = ${buildout:directory}/templates/mysql.in output = ${buildout:data-bin-directory}/mysql [mysqldump] recipe = collective.recipe.template input = ${buildout:directory}/templates/mysqldump.in output = ${buildout:data-bin-directory}/mysqldump [mysql-admin] recipe = collective.recipe.template input = ${buildout:directory}/templates/mysqladmin.in output = ${buildout:data-bin-directory}/mysqladmin [mysqld_safe-bin] recipe = collective.recipe.template input = ${buildout:directory}/templates/mysqld_safe.in output = ${buildout:data-bin-directory}/mysqld_safe [mysql-cnf] recipe = collective.recipe.template input = ${buildout:directory}/templates/my.cnf.in output = ${configuration:mysql_cnf_file} [mysql-instance] depends = ${create-directories:command} ${mysql-admin:output} ${mysql-bin:output} ${mysql-cnf:output} ${mysqld_safe-bin:output} ${mysqldump:output} recipe = plone.recipe.command command = mkdir -p ${configuration:mysql_datadir} [ -f ${configuration:mysql_datadir}/ibdata1 ] || ${software_definition:mysql_software}/bin/mysql_install_db --datadir=${configuration:mysql_datadir} update-command = ${:command} [mysql-server-template] <= mysql-instance [mysql-database-template] recipe = plone.recipe.command command = echo 'CREATE DATABASE ${:mysql_database_name} DEFAULT CHARACTER SET "utf8"' var/bin/mysql -u root echo 'GRANT ALL PRIVILEGES ON ${:mysql_database_name}.* TO ${:mysql_user}@"%" IDENTIFIED BY "${:mysql_password}"' update-command = ${:command}