Annotation of /alx-src/branches/alx-web-070/generate-and-import-server-key.sh
Parent Directory
| 
Revision Log
Revision 7070 -
(hide annotations)
(download)
(as text)
Mon Sep 7 10:50:48 2015 UTC (8 years, 8 months ago) by niro
File MIME type: application/x-sh
File size: 1034 byte(s)
Mon Sep 7 10:50:48 2015 UTC (8 years, 8 months ago) by niro
File MIME type: application/x-sh
File size: 1034 byte(s)
created branch 'alx-web-070'
| 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}" |