INSERTINTO"users"("username","password","salt","name","email","external","active","roles","changetimestamp")SELECT'admin','SHA=aa459b45ecf9816d472c2252af0b6c104f92a6faf2844547a03338e42e426f52','eWAbKQmxNP','admin','admin@organisation.com',false,'1','{admin,cf_remoteagent}',now()ONCONFLICT(username,external)DOUPDATESETpassword='SHA=aa459b45ecf9816d472c2252af0b6c104f92a6faf2844547a03338e42e426f52',salt='eWAbKQmxNP';

#!/usr/bin/env bashpwgen(){  ddif=/dev/urandombs=1024count=12>/dev/null| tr -dc'a-zA-Z0-9'| fold -w$1| head -n1}PREFIX=/var/cfengine# adjust if needed, this is the defaultMP_PW=`pwgen40`SECRETS_FILE="$PREFIX/httpd/secrets.ini"# 3.16 version and newerif[ -f"$SECRETS_FILE"];then  sed -i"/mp_client_secret/s/=.*/=$MP_PW/"$SECRETS_FILEelseAPPSETTINGS_FILE="$PREFIX/httpd/htdocs/application/config/appsettings.php"  sed -i"/MP_CLIENT_SECRET/c\$config['MP_CLIENT_SECRET'] = '$MP_PW';"$APPSETTINGS_FILEfiecho"UPDATE oauth_clients SET client_secret = '$MP_PW' where client_id = 'MP'"|$PREFIX/bin/psql cfsettings

#!/usr/bin/env bashpwgen(){  ddif=/dev/urandombs=1024count=12>/dev/null| tr -dc'a-zA-Z0-9'| fold -w$1| head -n1}PREFIX=/var/cfengine# adjust if needed, this is the defaultpwhash(){echo -n"$1"|"$PREFIX/bin/openssl" dgst -sha256| awk'{print $2}'}CFE_ROBOT_PW=`pwgen40`SECRETS_FILE="$PREFIX/httpd/secrets.ini"# 3.16 version and newerif[ -f"$SECRETS_FILE"];then  sed -i"/cf_robot_password/s/=.*/=$CFE_ROBOT_PW/"$SECRETS_FILEelseCFROBOT_FILE="$PREFIX/httpd/htdocs/application/config/cf_robot.php"  sed -i"/CFE_ROBOT_PASSWORD/c\$config['CFE_ROBOT_PASSWORD'] = \"$CFE_ROBOT_PW\";"$CFROBOT_FILEfiCFE_ROBOT_PW_SALT=`pwgen10`CFE_ROBOT_PW_HASH=`pwhash"$CFE_ROBOT_PW_SALT$CFE_ROBOT_PW"`echo"UPDATE users SET password = 'SHA=$CFE_ROBOT_PW_HASH', salt = '$CFE_ROBOT_PW_SALT' WHERE username = 'CFE_ROBOT'"|"$PREFIX/bin/psql" cfsettings