Skip to content
No description, website, or topics provided.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.

chef-alfresco-db cookbook

Build Status Cookbook Version Coverage Status

This cookbook will install the DBMS part of the Alfresco stack. The default choice is Mysql, but it can be expanded to use your own db.



The following cookbooks are direct dependencies because they're used for common "default" functionality.

  • mysql for MySql installation
  • poise-derived for defining lazily evaluated node attributes
  • mysql2_chef_gem library cookbook that provides a resource for installing the mysql2 gem against either mysql or mariadb depending on usage
  • selinux_policy to manage SELinux policies and components
  • alfresco-utils Chef utilities used by Chef-Alfresco


The following platforms are supported and tested with Test Kitchen:

  • CentOS 7+


  • Chef 12.1+


Key Type Description Default
default['db']['name'] String DB name alfresco
default['db']['host'] String DB host
default['db']['port'] String DB port 3306
default['db']['username'] String DB username alfresco
default['db']['password'] String DB password alfresco
default['db']['root_user'] String DB root user false
default['db']['allowed_host'] String Allowed host
default['db']['server_root_password'] String DB Root Password true
default['db']['engine'] String Engine of choice mysql

other specific MySql Attributes

Key Type Description Default
default['mysql_local']['version'] String Mysql Version '5.6'
default['mysql_local']['bind_address'] String bind_address nil
default['mysql_local']['service_name'] String Mysql service name default'
default['mysql_local']['collation'] String collation utf8_general_ci
default['mysql_local']['encoding'] String encoding utf8
default['mysql_local']['datadir'] String datadir /media/mysql-default/
default['mysql_local']['my_cnf']['mysqld']['local-infile'] Int local-infile 0
default['mysql_local']['my_cnf']['mysqld']['skip-grant-tables'] String skip-grant-tables FALSE
default['mysql_local']['my_cnf']['mysqld']['skip_symbolic_links'] String skip_symbolic_links 'YES'
default['mysql_local']['my_cnf']['mysqld']['sql_mode'] String sql_mode 'STRICT_ALL_TABLES'
default['mysql_local']['my_cnf']['mysqld']['log-bin'] String log-bin 'log-bin/mysql-bin'
default['mysql_local']['my_cnf']['mysqld']['slow_query_log'] Int slow_query_log 1
default['mysql_local']['my_cnf']['mysqld']['slow_query_log_file'] String slow_query_log_file /var/log/mysql-default/slow.log
default['mysql_local']['my_cnf']['mysqld']['long_query_time'] Int long_query_time 30
default['mysql_local']['my_cnf']['mysqld']['log_queries_not_using_indexes'] Int log_queries_not_using_indexes 1
default['mysql_local']['my_cnf']['mysqld']['log-warnings'] Int log-warnings 2
default['mysql_local']['my_cnf']['mysqld']['log-raw'] String log-raw 'OFF'
default['mysql_local']['my_cnf']['mysqld']['general_log_file'] String general_log_file /var/log/mysql-default/query.log
default['mysql_local']['my_cnf']['mysqld']['general_log'] Int general_log 1
default['mysql_local']['my_cnf']['cookbook'] String cookbook for my.cnf.erb template 'alfresco-db'


Just add the reference of this cookbook inside your metadata.rb file:

depends 'alfresco-db', '~> v0.1'

Main recipe is:

  • alfresco-db::default will install the Application Server of your choice ( specified under the default['db']['engine'] attribute)

Include alfresco-db in your node run_list:

  "run_list": [


Refer to: Testing

License and Authors

Copyright 2017, Alfresco

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
You can’t perform that action at this time.