Project

General

Profile

Download (2.16 KB)

Feature #11176 » sanitize_foreman.json

JSON file containing SQL statements to run, in sequence, to "sanitize" foreman database - Martin Jackson, 07/21/2015 10:47 AM

 
{
"extra_queries": [
"UPDATE users SET password_hash = '', password_salt = '' WHERE login = 'admin'"
],
"queries": [
"ALTER USER foreman WITH PASSWORD 'foreman';",

"UPDATE auth_sources SET account_password = 'foreman' WHERE account_password IS NOT NULL;",

"UPDATE users SET password_hash = '2b3c7bf14ffd76db76a0c11e32a19c25df2c748d', password_salt = 'be1ce90dfae1300fdef3173c8029e5fee78a43ff' WHERE login = 'admin'",

"DELETE FROM users WHERE login NOT IN ('admin', 'foreman_admin');",
"DELETE FROM auth_sources WHERE type NOT IN ('AuthSourceInternal', 'AuthSourceHidden')",

"UPDATE parameters SET value = 'Overridden';",

"UPDATE settings SET value = default;",

"UPDATE lookup_keys SET default_value = '--- string' WHERE key_type = 'string'",
"UPDATE lookup_values SET value = '--- string' WHERE id IN (SELECT id FROM lookup_keys WHERE key_type = 'string')",

"UPDATE lookup_keys SET default_value = '--- {}' WHERE key_type = 'json'",
"UPDATE lookup_values SET value = '--- {}' WHERE id IN (SELECT id FROM lookup_keys WHERE key_type = 'json')",

"UPDATE lookup_keys SET default_value = '--- 0.0' WHERE key_type = 'real'",
"UPDATE lookup_values SET value = '--- 0.0' WHERE id IN (SELECT id FROM lookup_keys WHERE key_type = 'real')",

"UPDATE lookup_keys SET default_value = '--- {}' WHERE key_type = 'hash'",
"UPDATE lookup_values SET value = '--- {}' WHERE id IN (SELECT id FROM lookup_keys WHERE key_type = 'hash')",

"UPDATE lookup_keys SET default_value = '--- true' WHERE key_type = 'boolean'",
"UPDATE lookup_values SET value = '--- true' WHERE id IN (SELECT id FROM lookup_keys WHERE key_type = 'boolean')",

"UPDATE lookup_keys SET default_value = '--- []' WHERE key_type = 'array'",
"UPDATE lookup_values SET value = '--- []' WHERE id IN (SELECT id FROM lookup_keys WHERE key_type = 'array')",

"UPDATE lookup_keys SET default_value = '--- 0' WHERE key_type = 'integer'",
"UPDATE lookup_values SET value = '--- 0' WHERE id IN (SELECT id FROM lookup_keys WHERE key_type = 'integer')",

"DELETE FROM sessions;",
"DELETE FROM audits;"
]
}
(2-2/2)