Annotation of /alx-src/trunk/alx-web/generate-and-import-server-key.sh
Parent Directory | Revision Log
Revision 1604 -
(hide annotations)
(download)
(as text)
Thu Dec 2 21:12:20 2010 UTC (13 years, 9 months ago) by niro
Original Path: alx-src/branches/alx-web-050/generate-and-import-server-key.sh
File MIME type: application/x-sh
File size: 802 byte(s)
Thu Dec 2 21:12:20 2010 UTC (13 years, 9 months ago) by niro
Original Path: alx-src/branches/alx-web-050/generate-and-import-server-key.sh
File MIME type: application/x-sh
File size: 802 byte(s)
-added ssh-key generation script
1 | niro | 1604 | #!/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}" |