2008R2 checksum error
Closed this issue · 2 comments
Cookbook version
Latest
Chef-client version
14.13.11
Platform Details
Windows Server 2008R2
Scenario:
Installing SQL Server
Steps to Reproduce:
Install SQL Server on Windows 2008R2
Expected Result:
Install would be successful
Suggested fix - checksum in libraries/helper.rb line 93 for 2008R2 should be:
"493C8CB5D905D2438022F85EF1A7076813CA317973C4745B9A42D2E910022950"
Actual Result:
* template[C:\Users\azure\AppData\Local\Temp\kitchen\cache\ConfigurationFile.ini] action create (up to date)
* windows_package[Microsoft SQL Server 2008 R2 (64-bit)] action install
Recipe: <Dynamically Defined Resource>
* remote_file[C:\Users\azure\AppData\Local\Temp\kitchen\cache\package\SQLEXPR_x64_ENU.exe] action create
================================================================================
Error executing action `create` on resource 'remote_file[C:\Users\azure\AppData\Local\Temp\kitchen\cache\package\SQLEXPR_x64_ENU.exe]'
================================================================================
Chef::Exceptions::ChecksumMismatch
----------------------------------
Checksum on resource (8ebf6b) does not match checksum on content (493c8c)
Compiled Resource:
------------------
# Declared in
remote_file("C:\Users\azure\AppData\Local\Temp\kitchen\cache\package\SQLEXPR_x64_ENU.exe") do
action [:create]
default_guard_interpreter :default
source ["https://download.microsoft.com/download/D/1/8/D1869DEC-2638-4854-81B7-0F37455F35EA/SQLEXPR_x64_ENU.exe"]
cookbook_name "sql_server"
checksum "8ebf6bdd805f3326d5b9a35a129af276c7fe99bfca64ac0cfe0ffc66311dfe09"
path "C:\\Users\\azure\\AppData\\Local\\Temp\\kitchen\\cache\\package\\SQLEXPR_x64_ENU.exe"
rights nil
deny_rights nil
headers {}
verifications []
end
System Info:
------------
chef_version=14.13.11
platform=windows
platform_version=6.1.7601
ruby=ruby 2.5.5p157 (2019-03-15 revision 67260) [x64-mingw32]
program_name=C:/opscode/chef/bin/chef-client
executable=C:/opscode/chef/bin/chef-client
================================================================================
Error executing action `install` on resource 'windows_package[Microsoft SQL Server 2008 R2 (64-bit)]'
================================================================================
Chef::Exceptions::ChecksumMismatch
----------------------------------
remote_file[C:\Users\azure\AppData\Local\Temp\kitchen\cache\package\SQLEXPR_x64_ENU.exe] (dynamically defined) had an error: Chef::Exceptions::ChecksumMismatch: Checksum on resource (8ebf6b) does not match checksum on content (493c8c)
Resource Declaration:
---------------------
# In C:/Users/azure/AppData/Local/Temp/kitchen/cache/cookbooks/sql_server/recipes/server.rb
68: package package_name do # ~FC009
69: source package_url
70: checksum package_checksum
71: timeout node['sql_server']['server']['installer_timeout']
72: installer_type :custom
73: options "/q /ConfigurationFile=#{config_file_path} #{passwords_options}"
74: action :install
75: notifies :request_reboot, 'reboot[sql server install]'
76: returns [0, 42, 127, 3010]
77: end
78:
Compiled Resource:
------------------
# Declared in C:/Users/azure/AppData/Local/Temp/kitchen/cache/cookbooks/sql_server/recipes/server.rb:68:in `from_file'
windows_package("Microsoft SQL Server 2008 R2 (64-bit)") do
package_name "Microsoft SQL Server 2008 R2 (64-bit)"
action [:install]
default_guard_interpreter :default
declared_type :package
cookbook_name "sql_server"
recipe_name "server"
source "https://download.microsoft.com/download/D/1/8/D1869DEC-2638-4854-81B7-0F37455F35EA/SQLEXPR_x64_ENU.exe"
installer_type :custom
options "/q /ConfigurationFile=C:\\Users\\azure\\AppData\\Local\\Temp\\kitchen\\cache\\ConfigurationFile.ini "
timeout 1500
returns [0, 42, 127, 3010]
checksum "8ebf6bdd805f3326d5b9a35a129af276c7fe99bfca64ac0cfe0ffc66311dfe09"
end
System Info:
------------
chef_version=14.13.11
platform=windows
platform_version=6.1.7601
ruby=ruby 2.5.5p157 (2019-03-15 revision 67260) [x64-mingw32]
program_name=C:/opscode/chef/bin/chef-client
executable=C:/opscode/chef/bin/chef-client```
Hey There
It looks like this is the first issue you've filed against the chef-cookbooks project. I'm here to offer you a bit of extra help to make sure we can quickly get back to you.
Make sure you've filled out all the fields in our issue template. Make sure you've provided us with the version of chef-client you're running, your operating system and the version of the cookbook. If you're not using the most up to date version of the cookbook then please make sure to update first. Lots of things change between versions even if you're issue isn't listed in the changelog. Finally please give us a detailed description of the issue you're having. The more we know about what you're trying to do, what actually happens, and how you can reproduce the problem, the better.
If you're looking for more immediate troubleshooting help make sure to check out #general on the Chef Community Slack. There's plenty of folks there willing to lend a helping hand. Thanks for the first issue. We hope we can get back to you soon with a solution.
@kenlangdon SQL 2008R2 is at it's end of life and we are in the process of deprecating its use in this cookbook.