provision a docker container about mysql HOT 5 CLOSED

I have the same issue trying to install mysql-server in ubuntu12.04 docker container. Upstart isn't available so mysql service refuse to start.
Something like this will be perfect but it seems isn't available yet.
Meanwhile I was trying to monkey patch a Chef::Provider::Service to use supervisor/runit to start mysql in container, using #197 PR. I don't know if there is a better solution.

from mysql.

@alambike Thanks for the links! a friend did a fork of the mysql cookbook http://bit.ly/1l8vb7u to allow the provisioning with chef-solo and we use supervisor to start mysql.

from mysql.

I can at least confirm that this is indeed still an issue, I've tried both the 5.5.4 from this repo here (opscode-cookbooks/mysql) and the one mentioned by @thpham https://github.com/haad/mysql/ and I still get the same error:

[2014-10-21T20:15:49+00:00] ERROR: Running exception handlers
[2014-10-21T20:15:49+00:00] ERROR: Exception handlers complete
[2014-10-21T20:15:49+00:00] FATAL: Stacktrace dumped to /var/chef/chef-stacktrace.out
[2014-10-21T20:15:49+00:00] ERROR: mysql_service[default] (mysql::server line 20) had an error: Mixlib::ShellOut::ShellCommandFailed: execute[install-grants] (/var/chef/cookbooks/mysql/libraries/provider_mysql_service_ubuntu.rb line 82) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of /usr/bin/mysql -u root -proot < /etc/mysql_grants.sql ----
STDOUT: 
STDERR: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
---- End output of /usr/bin/mysql -u root -proot < /etc/mysql_grants.sql ----
Ran /usr/bin/mysql -u root -proot < /etc/mysql_grants.sql returned 1
[2014-10-21T20:15:49+00:00] FATAL: Chef::Exceptions::ChildConvergeError: Chef run process exited unsuccessfully (exit code 1)
2014/10/21 15:15:49 The command [/bin/sh -c chef-solo -c /var/chef/solo.rb -j /var/chef/solo.json] returned a non-zero code: 1

anyone out there successfully using docker, chef-solo, and mysql?

from mysql.

Hi there. The MySQL 6.0.0 release has separated the :create and :start actions. You should now be able to use a mysql_service resource in a recipe with the :create action, and it will not attempt to start the service with any init system, allowing you to start it externally from your Dockerfile.

from mysql.

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.

from mysql.