Annotation of /alx-src/tags/alx-web-0_6_0/generate-and-import-server-key.sh
Parent Directory | Revision Log
Revision 2805 -
(hide annotations)
(download)
(as text)
Mon Aug 29 20:27:48 2011 UTC (13 years, 1 month ago) by niro
File MIME type: application/x-sh
File size: 1034 byte(s)
Mon Aug 29 20:27:48 2011 UTC (13 years, 1 month ago) by niro
File MIME type: application/x-sh
File size: 1034 byte(s)
tagged 'alx-web-0_6_0'
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 | 1611 | ENCRYPTION="dsa" |
13 | |||
14 | for i in id_${ENCRYPTION} id_${ENCRYPTION}.pub | ||
15 | niro | 1605 | do |
16 | [[ -e ${WEBSERVER_USER_HOME}/.ssh/${i} ]] && rm ${WEBSERVER_USER_HOME}/.ssh/${i} | ||
17 | done | ||
18 | niro | 1604 | |
19 | niro | 1611 | echo "Generating ${ENCRYPTION} key ..." |
20 | install -o ${WEBSERVER_USER} -g ${WEBSERVER_GROUP} -d ${WEBSERVER_USER_HOME}/.ssh | ||
21 | # run ssh keygen as target user | ||
22 | su - ${WEBSERVER_USER} -c "ssh-keygen -t ${ENCRYPTION} -q -f ${WEBSERVER_USER_HOME}/.ssh/id_${ENCRYPTION} -P ''" | ||
23 | niro | 1604 | |
24 | niro | 1611 | public_key="$(< ${WEBSERVER_USER_HOME}/.ssh/id_${ENCRYPTION}.pub)" |
25 | niro | 1604 | |
26 | SQL_COMMAND="insert into ssh_auth_server(id,public_key) values('1','${public_key}') on duplicate key update public_key='${public_key}'" | ||
27 | |||
28 | echo "Importing public key to database ..." | ||
29 | mysql \ | ||
30 | --user="${SQL_USER}" \ | ||
31 | --password="${SQL_PASS}" \ | ||
32 | --host="${SQL_HOST}" \ | ||
33 | --database="${SQL_DB}" \ | ||
34 | --batch \ | ||
35 | --skip-column-names \ | ||
36 | --execute="${SQL_COMMAND}" |