popularity question answers views user  
0
Configure SQL master/slave

Hi,

Is that possible with chef cookbooks to make a mysql cluster [master/slave] ? does it provide any special attribute to mention the master node ?

Thanks for any response

more →
0 21  
0
ArgumentError: invalid byte sequence in US-ASCII

When I ran “chef-client” on nodes(windows 2008, windows 7) with mysql::server, I got the following error:

[2012-08-08T09:55:04+08:00] INFO: Chef 10.12.0 [2012-08-08T09:55:22+08:00] INFO: Run List is [recipe[mysql::server]] [2012-08-08T09:55:22+08:00] INFO: Run List expands to [mysql::server] [2012-08-08T09:55:22+08:00] INFO: Starting Chef Run for node08a.gdeii.com.cn [2012-08-08T09:55:22+08:00] INFO: Running start handlers [2012-08-08T09:55:22+08:00] INFO: Start handlers complete. [2012-08-08T09:55:22+08:00] INFO: Loading cookbooks [chef_handler, mysql, openss l, windows] [2012-08-08T09:55:22+08:00] INFO: Storing updated cookbooks/mysql/recipes/server .rb in the cache. [2012-08-08T09:55:23+08:00] INFO: Could not find previously defined grants.sql r esource [2012-08-08T09:55:23+08:00] INFO: Processing remote_file[c:/chef/cache/mysql-con nector-c-6.0.2-win32.msi] action create (mysql::client line /chef/cache/cookbook s/mysql/recipes/client.rb) [2012-08-08T09:55:23+08:00] INFO: Processing windows_package[MySQL Connector C 6 .0.2] action nothing (mysql::client line /chef/cache/cookbooks/mysql/recipes/cli ent.rb) [2012-08-08T09:55:23+08:00] INFO: Processing windows_path[C:\Program Files (x86) \MySQL\MySQL Connector C 6.0.2\bin] action add (mysql::client line /chef/cache/c ookbooks/mysql/recipes/client.rb) [2012-08-08T09:55:23+08:00] INFO: Processing env[PATH] action modify (c line /ch ef/cache/cookbooks/windows/providers/path.rb) [2012-08-08T09:55:23+08:00] INFO: Processing windows_package[MySQL Connector C 6 .0.2] action nothing (mysql::client line /chef/cache/cookbooks/mysql/recipes/cli ent.rb) [2012-08-08T09:55:23+08:00] INFO: Processing windows_path[C:\Program Files (x86) \MySQL\MySQL Connector C 6.0.2\bin] action add (mysql::client line /chef/cache/c ookbooks/mysql/recipes/client.rb) [2012-08-08T09:55:23+08:00] INFO: Processing env[PATH] action modify (c line /ch ef/cache/cookbooks/windows/providers/path.rb) [2012-08-08T09:55:23+08:00] INFO: Processing windows_package[MySQL Connector C 6 .0.2] action install (mysql::client line /chef/cache/cookbooks/mysql/recipes/cli ent.rb) [2012-08-08T09:55:23+08:00] INFO: Processing gem_package[mysql] action install ( mysql::client line /chef/cache/cookbooks/mysql/recipes/client.rb) NOTE: Gem::SourceIndex.from_gems_in is deprecated with no replacement. It will b e removed on or after 2011-10-01. Gem::SourceIndex.from_gems_in called from C:/opscode/chef/embedded/lib/ruby/gems /1.9.1/gems/chef-10.12.0/lib/chef/provider/package/rubygems.rb:265 . [2012-08-08T09:55:24+08:00] INFO: Processing ruby_block[copy libmysql.dll into r uby path] action create (mysql::client line /chef/cache/cookbooks/mysql/recipes/ client.rb) [2012-08-08T09:55:24+08:00] INFO: Processing remote_file[c:/chef/cache/mysql-5.5 .21-win32.msi] action create (mysql::server line /chef/cache/cookbooks/mysql/rec ipes/server.rb) [2012-08-08T09:55:24+08:00] INFO: Processing windows_package[MySQL Server 5.5] a ction nothing (mysql::server line /chef/cache/cookbooks/mysql/recipes/server.rb) [2012-08-08T09:55:24+08:00] INFO: Processing windows_package[MySQL Server 5.5] a ction install (mysql::server line /chef/cache/cookbooks/mysql/recipes/server.rb)

[2012-08-08T09:55:24+08:00] INFO: Processing directory[C:\Program Files (x86)\My SQL\MySQL Server 5.5] action create (mysql::server line /chef/cache/cookbooks/my sql/recipes/server.rb) [2012-08-08T09:55:24+08:00] INFO: Processing windows_path[C:\Program Files (x86) \MySQL\MySQL Server 5.5\bin] action add (mysql::server line /chef/cache/cookbook s/mysql/recipes/server.rb) [2012-08-08T09:55:24+08:00] INFO: Processing env[PATH] action modify (c line /ch ef/cache/cookbooks/windows/providers/path.rb) [2012-08-08T09:55:24+08:00] INFO: Processing windows_batch[install mysql service ] action run (mysql::server line /chef/cache/cookbooks/mysql/recipes/server.rb) [2012-08-08T09:55:24+08:00] INFO: Processing execute[install mysql service] acti on run (dynamically defined) [2012-08-08T09:55:24+08:00] INFO: execute[install mysql service] ran successfull y [2012-08-08T09:55:24+08:00] INFO: Processing service[mysql] action nothing (mysq l::server line /chef/cache/cookbooks/mysql/recipes/server.rb) [2012-08-08T09:55:24+08:00] ERROR: service[mysql] (mysql::server line /chef/cach e/cookbooks/mysql/recipes/server.rb) has had an error [2012-08-08T09:55:24+08:00] ERROR: service[mysql] (c:/chef/cache/cookbooks/mysql /recipes/server.rb:101:in from_file') had an error: service[mysql] (mysql::server line /chef/cache/cookbooks/mysql/recipes/server.rb ) had an error: ArgumentError: invalid byte sequence in US-ASCII C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/windows-pr-1.2.1/lib/windows/e rror.rb:435:instrip' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/windows-pr-1.2.1/lib/windows/e rror.rb:435:in get_last_error' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/win32-service-0.7.2/lib/win32/ service.rb:962:instatus' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/provider /service/windows.rb:137:in current_state' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/provider /service/windows.rb:39:inload_current_resource' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/resource .rb:453:in run_action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/runner.r b:49:inrun_action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/runner.r b:85:in block (2 levels) in converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/runner.r b:85:ineach' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/runner.r b:85:in each' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/runner.r b:85:inblock in converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/resource collection.rb:94:in block in execute_each_resource' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/resource _collection/stepable_iterator.rb:116:incall' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/resource collection/stepable_iterator.rb:116:in call_iterator_block' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/resource _collection/stepable_iterator.rb:85:instep' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/resource collection/stepable_iterator.rb:104:in iterate' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/resource _collection/stepable_iterator.rb:55:ineach_with_index' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/resource collection.rb:92:in execute_each_resource' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/runner.r b:80:inconverge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/client.r b:330:in converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/client.r b:163:inrun' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/applicat ion/client.rb:254:in block in run_application' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/applicat ion/client.rb:241:inloop' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/applicat ion/client.rb:241:in run_application' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/lib/chef/applicat ion.rb:70:inrun' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-10.12.0/bin/chef-client:2 6:in <top (required)>' C:/opscode/chef/bin/chef-client:19:inload' C:/opscode/chef/bin/chef-client:19:in `<main>‘ [2012-08-08T09:55:24+08:00] ERROR: Running exception handlers [2012-08-08T09:55:24+08:00] FATAL: Saving node information to c:/chef/cache/fail ed-run-data.json [2012-08-08T09:55:24+08:00] ERROR: Exception handlers complete [2012-08-08T09:55:24+08:00] FATAL: Stacktrace dumped to c:/chef/cache/chef-stack trace.out [2012-08-08T09:55:24+08:00] FATAL: ArgumentError: service[mysql] (mysql::server line /chef/cache/cookbooks/mysql/recipes/server.rb) had an error: ArgumentError: invalid byte sequence in US-ASCII

Do anyone know how to solve it ???? Many thanks

more →
0 166  
0
recipe for mysql 5.5

I am just wondering is there are recipe for mysql 5.5 for chef?

more →
1 622
com