sql_server: Comments

  • onlinehood

    Over 2 years ago

    I run chef-solo in windows 2008 32bit platform. I met the following error [Thu, 01 Dec 2011 17:22:46 +0900] INFO: *** Chef 0.10.4 *** [Thu, 01 Dec 2011 17:22:50 +0900] INFO: Setting the run_list to ["recipe[sql_ser ver]"] from JSON [Thu, 01 Dec 2011 17:22:50 +0900] INFO: Run List is [recipe[sql_server]] [Thu, 01 Dec 2011 17:22:50 +0900] INFO: Run List expands to [sql_server] [Thu, 01 Dec 2011 17:22:50 +0900] INFO: Starting Chef Run for RNDRND-FGV66EVH [Thu, 01 Dec 2011 17:22:50 +0900] ERROR: Running exception handlers [Thu, 01 Dec 2011 17:22:50 +0900] ERROR: Exception handlers complete [Thu, 01 Dec 2011 17:22:50 +0900] FATAL: Stacktrace dumped to c:/chef/cache/chef -stacktrace.out [Thu, 01 Dec 2011 17:22:50 +0900] FATAL: IOError: closed stream what's the problem?

  • vickikozelwin

    About 1 year ago

    Hello! The recipe almost worked for me! I got the SQL Express service installed and it appears to be running in the services. But the recipe exited with the following error stack: Generated at 2013-02-07 15:30:00 -0500 Mixlib::ShellOut::CommandTimeout: windows_package[Microsoft SQL Server 2008 R2 (64-bit)] (sql_server::server line 36) had an error: Mixlib::ShellOut::CommandTimeout: command timed out: ---- Begin output of start "" /wait C:\chef\cache\SQLEXPR_x64_ENU.exe /q /ConfigurationFile=C:\chef\cache\ConfigurationFile.ini ---- STDOUT: STDERR: ---- End output of start "" /wait C:\chef\cache\SQLEXPR_x64_ENU.exe /q /ConfigurationFile=C:\chef\cache\ConfigurationFile.ini ---- C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/mixlib-shellout-1.1.0-x86-mingw32/lib/mixlib/shellout/windows.rb:101:in `run_command' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/mixlib-shellout-1.1.0-x86-mingw32/lib/mixlib/shellout.rb:222:in `run_command' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/mixin/shell_out.rb:30:in `shell_out' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/mixin/shell_out.rb:35:in `shell_out!' C:/chef/cache/cookbooks/windows/providers/package.rb:124:in `install_package' C:/chef/cache/cookbooks/windows/providers/package.rb:46:in `block in class_from_file' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/provider/lwrp_base.rb:138:in `instance_eval' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/provider/lwrp_base.rb:138:in `block in action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/provider.rb:118:in `run_action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/resource.rb:586:in `run_action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/runner.rb:50:in `run_action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/runner.rb:82:in `block (2 levels) in converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/runner.rb:82:in `each' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/runner.rb:82:in `block in converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.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-11.0.0/lib/chef/resource_collection/stepable_iterator.rb:116:in `call' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.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-11.0.0/lib/chef/resource_collection/stepable_iterator.rb:85:in `step' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/resource_collection/stepable_iterator.rb:104:in `iterate' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/resource_collection/stepable_iterator.rb:55:in `each_with_index' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/resource_collection.rb:92:in `execute_each_resource' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/runner.rb:81:in `converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/client.rb:404:in `converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/client.rb:469:in `do_run' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/client.rb:200:in `run' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/application.rb:190:in `run_chef_client' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/application/client.rb:297:in `block in run_application' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/application/client.rb:290:in `loop' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/application/client.rb:290:in `run_application' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/lib/chef/application.rb:73:in `run' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.0.0/bin/chef-client:26:in `<top (required)>' C:/opscode/chef/bin/chef-client:23:in `load' C:/opscode/chef/bin/chef-client:23:in `<main>'

  • matthewting

    About 1 year ago

    Does this cookbook ever works for anyone using 11.2? I tried to debug it but it just keep giving me error... anyone can share me your exp and hints/fixes for this cookbook?

  • chewbone

    8 months ago

    I think this cookbook is broken. I'm using Chef 11.6, and still very new, so I won't rule out that I'm doing something wrong. First, the built in links to download SQL Express are wrong since Microsoft changed them. I used the example code for creating a basic role, and added the correct url and checksum. Running the client will now download the installer. My problem comes soon after where there is an error updating the registry. I'm getting errors: Win32::Registry::Error: windows_registry[set-static-tcp-port] (sql_server::server line 52) had an error: Win32::Registry::Error: The system cannot find the file specified. C:/opscode/chef/embedded/lib/ruby/1.9.1/win32/registry.rb:385:in `open' C:/opscode/chef/embedded/lib/ruby/1.9.1/win32/registry.rb:496:in `open' c:/chef/cache/cookbooks/windows/libraries/registry_helper.rb:139:in `get_value' c:/chef/cache/cookbooks/windows/providers/registry.rb:42:in `block (3 levels) in class_from_file' c:/chef/cache/cookbooks/windows/providers/registry.rb:38:in `each' c:/chef/cache/cookbooks/windows/providers/registry.rb:38:in `block (2 levels) in class_from_file' C:/opscode/chef/embedded/lib/ruby/1.9.1/timeout.rb:69:in `timeout' c:/chef/cache/cookbooks/windows/providers/registry.rb:37:in `block in class_from_file' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/provider/lwrp_base.rb:138:in `instance_eval' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/provider/lwrp_base.rb:138:in `block in action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/provider.rb:118:in `run_action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/resource.rb:625:in `run_action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/runner.rb:49:in `run_action' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/runner.rb:81:in `block (2 levels) in converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/runner.rb:81:in `each' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/runner.rb:81:in `block in converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/resource_collection.rb:98:in `block in execute_each_resource' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/resource_collection/stepable_iterator.rb:116:in `call' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.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-11.6.0/lib/chef/resource_collection/stepable_iterator.rb:85:in `step' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/resource_collection/stepable_iterator.rb:104:in `iterate' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/resource_collection/stepable_iterator.rb:55:in `each_with_index' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/resource_collection.rb:96:in `execute_each_resource' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/runner.rb:80:in `converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/client.rb:429:in `converge' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/client.rb:494:in `do_run' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/client.rb:212:in `run' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/application.rb:183:in `run_chef_client' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/application/client.rb:302:in `block in run_application' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/application/client.rb:294:in `loop' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/application/client.rb:294:in `run_application' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/lib/chef/application.rb:66:in `run' C:/opscode/chef/embedded/lib/ruby/gems/1.9.1/gems/chef-11.6.0/bin/chef-client:26:in `<top (required)>' C:/opscode/chef/bin/chef-client:23:in `load' C:/opscode/chef/bin/chef-client:23:in `<main>' Maybe the installer failed to run or complete? Maybe the registry key path is wrong? I'm not really sure what is going on. This is my first time trying to get Chef to do more than what the overly simple quickstart guide shows.

    • scarolan

      8 months ago

      This cookbook appears to be broken. I may attempt a re-write. Issues I've identified so far: * Microsoft changed the download link location * Setting the TCP port via the registry no longer works * The syntax of the template file is no longer valid * SQL server is unable to render the xml config file, not sure why yet

  • yvan

    7 months ago

    when using the TOOLS feature alone (default['sql_server']['feature_list'] = 'TOOLS'), the server.rb (47) recipe should avoid attempting to restart the db engine service!

  • yvan

    7 months ago

    In the client recipe, gem_package is used to dl and install tiny_tds I have an issue with this in regards with proxy settings. Why does gem_package doesn't use the chef-client proxy settings. I am forced to set an http_proxy with credentials as an environment variable before running chef-client. PLEASE HELP!

  • jonathons

    3 months ago

    I've had to make a change to version 1.3.0 for a SqlExpress server install on Windows 2008R2 64bit This is because the installer creates a registry key without the 'MSSQL$' prefix as assumed by the recipe. The top of my modified server.rb recipe reads: ::Chef::Recipe.send(:include, Opscode::OpenSSL::Password) service_name = "MSSQL$#{node['sql_server']['instance_name']}" static_tcp_reg_key = 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.' + node['sql_server']['instance_name'] + '\MSSQLServer\SuperSocketNetLib\Tcp\IPAll' I don't know whether the problem is due to some aspect of the system or a change in the installer, but my change almost certainly break for other scenarios.

  • polfilm

    3 months ago

    Anyone interested in working out MSSQL Server 2012 on Windows 2012 AWS AMI: https://www.freelancer.com/projects/Linux-Python/Update-Chef-Cookbook-AWS-AMI.html