Password generator(Postgres and MySQL)

Please watch video https://www.youtube.com/watch?v=ZDD_DjkbVcQ or follow below instructions

You can use this feature to generate random passwords - Next time when you create a new postgres role try this feature to generate complex password

Please select option 6 followed by option 2 as illustrated below

You need to select length , special chars etc.. or leave the defaults - Default is length of 20 , 2 digits , 2 special chars , 2 uppercase chars

It produces plaintext password and encrypted password (scram-sha-256 format)

NOTE : When creating a new user in Postgres, please use encrypted passwords only. This will prevent password leakage in logs

Example (Please see below screenshot)

You can also set custom profiles in config file to use the same pattern repeatedly

Add below section to your config file located at /etc/klouddbshield/kshieldconfig.toml

[generatePassword]
length=9
numberCount=1
numUppercase=2
specialCharCount=5