2018-02-27 13:40:29 -07:00
|
|
|
#!/bin/bash
|
2018-03-11 19:03:17 -06:00
|
|
|
VERSION=36
|
2018-02-27 13:40:29 -07:00
|
|
|
TAR=`which tar`
|
|
|
|
|
MYSQL=`which mysql`
|
|
|
|
|
EPOCH=`date +%s`
|
|
|
|
|
TARBALL="${VERSION}.tar.gz"
|
|
|
|
|
SHA1SUM=`which sha1sum`
|
|
|
|
|
DNSUSER="brielle"
|
|
|
|
|
DNSDOMAIN="*.3.sa.sosdg.org"
|
|
|
|
|
DNSDB="ns1-powerdns"
|
|
|
|
|
DNSTABLE="records"
|
|
|
|
|
|
|
|
|
|
${TAR} zvcf ../../${TARBALL} --exclude-vcs --exclude='*.sh' * ;\
|
2018-03-11 19:03:17 -06:00
|
|
|
cd ../../
|
|
|
|
|
${SHA1SUM} ${TARBALL} > ${TARBALL}.sha1
|
2018-02-27 13:40:29 -07:00
|
|
|
|
|
|
|
|
#echo -n "Mysql password: "
|
|
|
|
|
#stty -echo
|
|
|
|
|
#read password
|
|
|
|
|
#stty echo
|
|
|
|
|
|
|
|
|
|
#DNSSOA=`echo "SELECT content FROM ${DNSTABLE} WHERE domain_id='4'
|
|
|
|
|
# AND name='sosdg.org' AND type='SOA'" |\
|
|
|
|
|
# ${MYSQL} --user=${DNSUSER} --password=$password ${DNSDB}`
|
|
|
|
|
|
|
|
|
|
#DNSSOA2=( ${DNSSOA// / } )
|
|
|
|
|
#NEW_SOA="${DNSSOA2[1]} ${DNSSOA2[2]} $((${DNSSOA2[3]}+1)) ${DNSSOA2[4]} ${DNSSOA2[5]} ${DNSSOA2[6]} ${DNSSOA2[7]}"
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#echo "UPDATE ${DNSTABLE} SET content='${VERSION}', change_date='${EPOCH}'
|
|
|
|
|
# WHERE name='${DNSDOMAIN}' AND type='TXT'" |\
|
|
|
|
|
# ${MYSQL} --user=${DNSUSER} --password=$password ${DNSDB}
|
|
|
|
|
#
|
|
|
|
|
#echo "UPDATE ${DNSTABLE} SET content='${NEW_SOA}', change_date='${EPOCH}'
|
|
|
|
|
# WHERE domain_id='4' AND name='sosdg.org' AND type='SOA'" |\
|
|
|
|
|
# ${MYSQL} --user=${DNSUSER} --password=$password ${DNSDB}
|
|
|
|
|
|
|
|
|
|
#unset password
|
