Skip to content

Instantly share code, notes, and snippets.

@jjasghar

jjasghar/gist.sh Secret

Created March 17, 2015 17:04
Show Gist options
  • Save jjasghar/f5be418c04a80da0f6af to your computer and use it in GitHub Desktop.
Save jjasghar/f5be418c04a80da0f6af to your computer and use it in GitHub Desktop.
- change mode from '' to '0750'
- change owner from '' to 'mysql'
- change group from '' to 'mysql'
* directory[default :create /var/lib/mysql-default] action create[2015-03-17T16:29:00+00:00] INFO: Processing directory[default :create /var/lib/mysql-default] action create (/var/chef/cache/cookbooks/mysql/libraries/provider_mysql_service.rb line 113)
[2015-03-17T16:29:00+00:00] INFO: directory[default :create /var/lib/mysql-default] created directory /var/lib/mysql-default
- create new directory /var/lib/mysql-default[2015-03-17T16:29:00+00:00] INFO: directory[default :create /var/lib/mysql-default] owner changed to 105
[2015-03-17T16:29:00+00:00] INFO: directory[default :create /var/lib/mysql-default] group changed to 111
[2015-03-17T16:29:00+00:00] INFO: directory[default :create /var/lib/mysql-default] mode changed to 750
- change mode from '' to '0750'
- change owner from '' to 'mysql'
- change group from '' to 'mysql'
* template[default :create /etc/mysql-default/my.cnf] action create[2015-03-17T16:29:00+00:00] INFO: Processing template[default :create /etc/mysql-default/my.cnf] action create (/var/chef/cache/cookbooks/mysql/libraries/provider_mysql_service.rb line 123)
[2015-03-17T16:29:00+00:00] INFO: template[default :create /etc/mysql-default/my.cnf] created file /etc/mysql-default/my.cnf
- create new file /etc/mysql-default/my.cnf[2015-03-17T16:29:00+00:00] INFO: template[default :create /etc/mysql-default/my.cnf] updated file contents /etc/mysql-default/my.cnf
- update content in file /etc/mysql-default/my.cnf from none to 3f3a01
--- /etc/mysql-default/my.cnf 2015-03-17 16:29:00.760452435 +0000
+++ /tmp/chef-rendered-template20150317-5385-pxzwlw 2015-03-17 16:29:00.760452435 +0000
@@ -1 +1,24 @@
+# Chef generated my.cnf for instance mysql-default
+
+[client]
+default-character-set = utf8
+port = 3306
+socket = /run/mysql-default/mysqld.sock
+
+[mysql]
+default-character-set = utf8
+
+[mysqld]
+user = mysql
+pid-file = /run/mysql-default/mysqld.pid
+socket = /run/mysql-default/mysqld.sock
+bind-address = 172.16.100.60
+port = 3306
+datadir = /var/lib/mysql-default
+tmpdir = /tmp
+log-error = /var/log/mysql-default/error.log
+!includedir /etc/mysql-default/conf.d
+
+[mysqld_safe]
+socket = /run/mysql-default/mysqld.sock[2015-03-17T16:29:00+00:00] INFO: template[default :create /etc/mysql-default/my.cnf] owner changed to 105
[2015-03-17T16:29:00+00:00] INFO: template[default :create /etc/mysql-default/my.cnf] group changed to 111
[2015-03-17T16:29:00+00:00] INFO: template[default :create /etc/mysql-default/my.cnf] mode changed to 600
- change mode from '' to '0600'
- change owner from '' to 'mysql'
- change group from '' to 'mysql'
* bash[default :create initialize mysql database] action run[2015-03-17T16:29:00+00:00] INFO: Processing bash[default :create initialize mysql database] action run (/var/chef/cache/cookbooks/mysql/libraries/provider_mysql_service.rb line 144)
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h controller password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl
Please report any problems at http://bugs.mysql.com/
[2015-03-17T16:29:01+00:00] INFO: bash[default :create initialize mysql database] ran successfully
- execute "bash" "/tmp/chef-script20150317-5385-w5nyei"
* bash[default :create initial records] action nothing[2015-03-17T16:29:01+00:00] INFO: Processing bash[default :create initial records] action nothing (/var/chef/cache/cookbooks/mysql/libraries/provider_mysql_service.rb line 153)
(skipped due to action :nothing)
[2015-03-17T16:29:01+00:00] INFO: bash[default :create initialize mysql database] sending run action to bash[default :create initial records] (delayed)
* bash[default :create initial records] action run[2015-03-17T16:29:01+00:00] INFO: Processing bash[default :create initial records] action run (/var/chef/cache/cookbooks/mysql/libraries/provider_mysql_service.rb line 153)
150317 16:29:01 mysqld_safe Logging to '/var/log/mysql-default/error.log'.
150317 16:29:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql-default
150317 16:29:03 mysqld_safe mysqld from pid file /run/mysql-default/mysqld.pid ended
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment