Well bless the use of chatGPT o1-preview for helping me fix it. Took about 2 hours:
Find an admin user, get their id and set it as a user var:
user = User.find_by(id: 22)
Use the Setting interface to set the value
irb(main):064:0> Setting[:host_owner] = "#{user.id}-Users"
Verify all settings are set to the new id:
irb(main):068:1* Setting.all.each do |setting|
irb(main):069:1* value = setting.read_attribute(:value).to_s
irb(main):070:2* if value.include?('15')
irb(main):071:2* puts "Setting '#{setting.name}' references user ID 15."
irb(main):072:2* # Optionally update the setting
irb(main):073:2* # For example, if it's 'some_setting', you can update it accordingly
irb(main):074:1* end
irb(main):075:0> end
Clear cache and restart foreman:
sudo foreman-rake tmp:cache:clear sudo systemctl restart foreman
more sets:
irb(main):012:0> admin_user = User.find_by(id: 22)
=>
# puts "Admin User ID: #{admin_user.id}, Login: #{admin_user.login}"
Admin User ID: 22, Login: saltforeman
=> nil
irb(main):014:1* if admin_user
irb(main):015:1* puts "Admin User ID: #{admin_user.id}, Login: #{admin_user.login}"
irb(main):016:1*
irb(main):017:1* # Update the 'host_owner' setting
irb(main):018:1* host_owner_setting = Setting.find_by(name: 'host_owner')
irb(main):019:1*
irb(main):020:2* if host_owner_setting
irb(main):021:2* # Update the setting to use the valid user ID
irb(main):022:2* new_value = "22"
irb(main):023:2* host_owner_setting.update(value: new_value)
irb(main):024:2* puts "Updated 'host_owner' setting to reference user ID #{admin_user.id}."
irb(main):025:2* else
irb(main):026:2* puts "'host_owner' setting not found."
irb(main):027:1* end
irb(main):028:1* else
irb(main):029:1* put