Differential D1522 Diff 3997 docker/kolab/utils/04-reset-mysql-kolab-password.sh

Changeset View

Standalone View

	#!/bin/bash			#!/bin/bash

	sqlpw=$(grep ^sql_uri /etc/kolab/kolab.conf \| awk -F':' '{print $3}' \| awk -F'@' '{print $1}')			sqlpw=$(grep ^sql_uri /etc/kolab/kolab.conf \| awk -F':' '{print $3}' \| awk -F'@' '{print $1}')

	mysql -h 127.0.0.1 -u root --password=Welcome2KolabSystems \			mysql -h ${DB_HOST} -u root --password=${DB_ROOT_PASSWORD} \
	-e "SET PASSWORD FOR 'kolab'@'localhost' = PASSWORD('${sqlpw}');"			-e "SET PASSWORD FOR '${DB_HKCCP_USERNAME:-kolabdev}'@'%' = PASSWORD('${DB_HKCCP_PASSWORD:-Welcome2KolabSystems}');"

				mysql -h ${DB_HOST} -u root --password=${DB_ROOT_PASSWORD} \
				-e "SET PASSWORD FOR '${DB_KOLAB_USERNAME:-kolab}'@'%' = PASSWORD('${DB_KOLAB_PASSWORD:=$sqlpw}');"

				mysql -h ${DB_HOST} -u root --password=${DB_ROOT_PASSWORD} \
				-e "SET PASSWORD FOR '${DB_RC_USERNAME:-roundcube}'@'%' = PASSWORD('${DB_RC_PASSWORD:-Welcome2KolabSystems}');"