restore of a local database in a cloud acceptance environment failed
I created a backup of my local PostgreSQL database and like to restore it in my cloud acceptance environment. The restore is successfull but when i restart the application i get the error: Core: Using password '1' for a user with administrator user roles is not allowed. The following admin users have password 1: [MxAdmin] So i changed my MxAdmin password in my local system and deployed that version, but still the same error. Any suggestions.
Jan de Lange
Did you try setting the Admin password with the button highlighted below?
Just an option: restore other backups to accp. An prod-backup, an older accp-backup. See if it makes a difference. Quite similar to your second attempt, but opssibly worth a try.
𝕿𝖎𝖒 𝖛𝖆𝖓 𝕾𝖙𝖊𝖊𝖓𝖇𝖊𝖗𝖌𝖊𝖓
Just change the password in the modeler;
run it local on your local Postgres
Backup → Restore your local into ACCP
Whole issue is related to the fact that the MxAdmin PW is only set to the modeler default when running locally.
Since you restore the local database in an environment which has PW control, you bump into this issue.