#!/bin/bash

SQL_DB='alx_web'
SQL_HOST='localhost'
SQL_USER='alx_install'
SQL_PASS='@lx'

WEBSERVER_USER="apache"
WEBSERVER_GROUP="apache"
WEBSERVER_USER_HOME="/var/lib/${WEBSERVER_USER}"

ENCRYPTION="dsa"

for i in id_${ENCRYPTION} id_${ENCRYPTION}.pub
do
	[[ -e ${WEBSERVER_USER_HOME}/.ssh/${i} ]] && rm ${WEBSERVER_USER_HOME}/.ssh/${i}
done

echo "Generating ${ENCRYPTION} key ..."
install -o ${WEBSERVER_USER} -g ${WEBSERVER_GROUP} -d ${WEBSERVER_USER_HOME}/.ssh
# run ssh keygen as target user
su - ${WEBSERVER_USER} -c "ssh-keygen -t ${ENCRYPTION} -q -f ${WEBSERVER_USER_HOME}/.ssh/id_${ENCRYPTION} -P ''"

public_key="$(< ${WEBSERVER_USER_HOME}/.ssh/id_${ENCRYPTION}.pub)"

SQL_COMMAND="insert into ssh_auth_server(id,public_key) values('1','${public_key}') on duplicate key update public_key='${public_key}'"

echo "Importing public key to database ..."
mysql \
	--user="${SQL_USER}" \
	--password="${SQL_PASS}" \
	--host="${SQL_HOST}" \
	--database="${SQL_DB}" \
	--batch \
	--skip-column-names \
	--execute="${SQL_COMMAND}"