Thanks Tom that is super helpful.
I did have the role in my database and in the config in the same case.
Your logging snippets should greatly help determine what is going on.
Close this case for the time being and I will post later if I find an issue or get stuck.
You should consider upgrading your encryption method if possible as
Sha1 is deprecated.