Contents of /alx-src/branches/alx-web-060/generate-and-import-server-key.sh
Parent Directory | Revision Log
Revision 1605 -
(show annotations)
(download)
(as text)
Thu Dec 2 21:16:58 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: 853 byte(s)
Thu Dec 2 21:16:58 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: 853 byte(s)
fixed several issues
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 | 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 | |
17 | echo "Generating dsa key ..." |
18 | install -d ${WEBSERVER_USER_HOME}/.ssh |
19 | 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}" |