I successfully used prosody-migrator to convert my users to a PostgreSQL database. But now, when I insert
storage = “sql”
in prosody.conf, jvb2 fails with authentication error in jvb.err:
SEVERE:  RetryStrategy$TaskRunner.run#198: org.jivesoftware.smack.sasl.SASLErrorException: SASLError using SCRAM-SHA-1: not-authorized
In the DB I only find data for my regular users, I suspect that I still need some users/credentials for internal use that are now missing. What is the correct way to move everything from internal storage to sql?
I also note that the passwords are stored in plaintext, not as a hash. This is also the case with the passwords stored in the file system in the accounts/*.dat file.
My install uses mostly default values from the installers, I just changed the system to require authentication for creating conferences only, exactly as described in the docs. With internal storage, everything operates properly.
Thanks for any help and regards