Windows reload Enviroment Variables on the fly

pkleanthous · March 29, 2017, 10:10am

Hi community,

On Windows, I'm installing SQL Server. With SQL Server they distribute some binaries, I'm using sqlcmd to create users and databases.

The initial OS PATH has the following entries:

C:/opscode/chef/embedded/bin;
C:/opscode/chef/embedded/bin;
C:\opscode\chef\bin;
C:\Windows;
C:\Windows\system32;
C:\Windows\System32\Wbem;
C:\Windows\System32\WindowsPowerShell\v1.0;

After installing SQL Server the OS has the following entries:

C:/opscode/chef/embedded/bin;
C:/opscode/chef/embedded/bin;
C:\opscode\chef\bin;
C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn;
C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn;
C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio;
C:\Program Files\Microsoft SQL Server\120\DTS\Binn;
C:\Program Files\Microsoft SQL Server\120\Tools\Binn;
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn;
C:\Windows;
C:\Windows\system32;
C:\Windows\System32\Wbem;
C:\Windows\System32\WindowsPowerShell\v1.0;

The sqlcmd binary is inside C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;

How can I reload the ENV['PATH'] on chef side so the next resources can find the sqlcmd binary?

pkleanthous · March 29, 2017, 10:25am

From the Windows community cookbook. Can we use the following code block to update the path?

github.com

chef-cookbooks/windows/blob/a9ae52c0aee98d0cb3a41a32721b551e53e6bba5/resources/path.rb#L40-L45


ruby_block "fix ruby ENV['PATH']" do
  block do
    ENV['PATH'] = expand_env_vars(ENV['PATH'])
  end
  action :nothing
end

github.com

chef-cookbooks/windows/blob/bae551985ee9cd3fe5431f283ee7487a522dfc65/libraries/windows_helper.rb#L73-L82


# Expands the environment variables
def expand_env_vars(path)
  # We pick 32k because that is the largest it could be:
  # http://msdn.microsoft.com/en-us/library/windows/desktop/ms724265%28v=vs.85%29.aspx
  buf = 0.chr * 32 * 1024 # 32k
  if ExpandEnvironmentStrings.call(path.dup, buf, buf.length) == 0
    raise Chef::Exceptions::Win32APIError, 'Failed calling ExpandEnvironmentStrings (received 0)'
  end
  buf.strip
end

Topic		Replies	Views
Updating PATH on windows for use in subsequent recipes Chef Infra (archive)	3	860	May 20, 2014
Invoke-sqlcmd not running on chef powershell prompt Chef Infra (archive)	4	1038	March 26, 2018
Questions on executing *.sql files in Windows Chef Infra (archive)	2	712	July 15, 2015
How to fix Enviornment path variable because it need restart? Chef Infra (archive)	2	656	September 21, 2017
SQL SERVER ISSUE on WINDOWS Chef Infra (archive)	3	475	September 21, 2017

Windows reload Enviroment Variables on the fly

Related Topics