Hi,
I'm using ejabberd 16.03 with mysql
I changed the mysql scheme with
ALTER TABLE users ADD COLUMN serverkey varchar(64) NOT NULL DEFAULT '';
ALTER TABLE users ADD COLUMN salt varchar(64) NOT NULL DEFAULT '';
ALTER TABLE users ADD COLUMN iterationcount integer NOT NULL DEFAULT 0;
to support scram passwords. After that I converted the passwords with
./ejabberdctl convert_to_scram myhost
Then I added
auth_password_format: scram
to host_config in my configuration file and restarted ejabberd.
The server has ~600 registered users and ~100 online users.
After I changed to scram the load went up to 5-7, the memory usage was (according to top) at 14gig virt and 7gig res. Also the cpu% was up to 30%. I couldn't connect to ejabberd rpc any more and the apache on the same host wasn't responding any more.
When I restore the database to plaintext passwords and remove auth_password_format: scram, everything works like a charme.
Did I do something wrong or is scram passwords using an insane amount of memory/ressouces?
