Hi, we have completely lost (due to some ceph/openstack issue) our test appliance cluster with 2 hammer instances and there is also no available backup of our former encryption key.
Our external PostgreSQL DB survived (which hopefully contains our complete datastore and forms?), but we are not able to connect to it from our new hammer appliances.
Is there any procedure how to connect to existing region again with new encryption key?
I connected to clean appliance and run appliance_console
selected number 7 (Configure Database), than 3 (Join Region in External Database) which asked for new encryption key, so I selected “create new one”
I filled connection data and than I got:
Activating the configuration using the following settings…
this is in evm.log:
[----] I, [2019-04-16T13:41:36.008365 #16489:52af58] INFO -- : MIQ(EvmDatabase.seed) Seeding... [----] I, [2019-04-16T13:41:36.051307 #16489:52af58] INFO -- : MIQ(EvmDatabase.seed) Seeding MiqDatabase [----] E, [2019-04-16T13:41:36.093273 #16489:52af58] ERROR -- : [ManageIQ::Password::PasswordError]: can not decrypt v2_key encrypted string Method:[block (2 levels) in <class:LogProxy>] [----] E, [2019-04-16T13:41:36.093461 #16489:52af58] ERROR -- : /usr/local/lib/ruby/gems/2.4.0/gems/manageiq-password-0.3.0/lib/manageiq/password.rb:43:in `rescue in decrypt' /usr/local/lib/ruby/gems/2.4.0/gems/manageiq-password-0.3.0/lib/manageiq/password.rb:40:in `decrypt' /usr/local/lib/ruby/gems/2.4.0/gems/manageiq-password-0.3.0/lib/manageiq/password.rb:72:in `decrypt' /var/www/miq/vmdb/app/models/mixins/password_mixin.rb:24:in `block in encrypt_column'
I have also tried fix_auth.rb with no luck
Am I doing it wrong?
Thank you very much