Mysql: Encryption of passwords in tig_users table

Pratap Patil
Added over 4 years ago

How to ensure that the tig_users table in tigasedb (MySQL) the passwords are hashed and not the direct strings? Is there some setting or flag that goes in the file to achieve this?

Replies (1)

Added by Wojciech Kapcia TigaseTeam over 4 years ago

One option, that would require using SASL-PLAIN would be enabling MD5 password hashing in the database:

call TigPutDBProperty('password-encoding', <hashing>);

where <hashing> can be one of the following: @'MD5-PASSWORD'@, @'MD5-USERID-PASSWORD'@, @'MD5-USERNAME-PASSWORD'@.

An alternative would be using SCRAM.