branches/alx-web-050/generate-and-import-server-key.sh

#!/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}"

[[ -e id_dsa ]] && rm id_dsa
[[ -e id_dsa.pub ]] && rm id_dsa.pub

echo "Generating dsa key ..."
install -d ${WEBSERVER_USER_HOME)/.ssh
ssh-keygen -t dsa -q -f ${WEBSERVER_USER_HOME}/.ssh/id_dsa -P ""

public_key="$(< ${WEBSERVER_USER_HOME}/.ssh/id_dsa.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}"
1	#!/bin/bash
2
3	SQL_DB="alx-web"
4	SQL_HOST="localhost"
5	SQL_USER="alx_install"
6	SQL_PASS="@lx"
7
8	WEBSERVER_USER="apache"
9	WEBSERVER_GROUP="apache"
10	WEBSERVER_USER_HOME="/var/lib/${WEBSERVER_USER}"
11
12	[[ -e id_dsa ]] && rm id_dsa
13	[[ -e id_dsa.pub ]] && rm id_dsa.pub
14
15	echo "Generating dsa key ..."
16	install -d ${WEBSERVER_USER_HOME)/.ssh
17	ssh-keygen -t dsa -q -f ${WEBSERVER_USER_HOME}/.ssh/id_dsa -P ""
18
19	public_key="$(< ${WEBSERVER_USER_HOME}/.ssh/id_dsa.pub)"
20
21	SQL_COMMAND="insert into ssh_auth_server(id,public_key) values('1','${public_key}') on duplicate key update public_key='${public_key}'"
22
23	echo "Importing public key to database ..."
24	mysql \
25	--user="${SQL_USER}" \
26	--password="${SQL_PASS}" \
27	--host="${SQL_HOST}" \
28	--database="${SQL_DB}" \
29	--batch \
30	--skip-column-names \
31	--execute="${SQL_COMMAND}"