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}"

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

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