Script que executa checagem dos bancos de dados de Docker Mysql e Postgres e envia e-mail com status para Infraestrutura.

check_db.sh

#!/bin/bash
# script01: check_db.sh - Este script executa o script status_db.sh, fazendo alguns filtros para eliminar informacoes desnecessarias
# usa o comando dos2unix para converter o arquivo depois coloca data no arquivo executado e manda e-mail com o resultado dos backups
# dos bancos de dados mariadb e postgres do Ambiente do Rancher.
# Apaga arquivos anteriores ha 7 dias e é rodado todos os dias as 08h da manha
# script02: status_db.sh - Este script acessa os servidores aonde possuem os containers de backuo e mostra os logs com informacoes
# dizendo se o backup foi executado com sucesso ou nao.
# Programador: Renato Diniz Marigo
# Mantenedor:  Renato Diniz Marigo e Equipe de Infra SciELO
# Criado em: 09/02/2018
# Versão: 1.0
LANG="en_US.UTF8" ; export LANG
./status_db.sh | grep -v Linux | grep -v login > backupsDB.log
dos2unix backupsDB.log
mv backupsDB.log $(date '+%Y%m%d')backupsDB.log
mail -s "Log do Status dos backups Mysql e Postgresql do Rancher" "infra@scielo.org" < $(date '+%Y%m%d')backupsDB.log
find /home/renato.diniz/*.log -mtime +5 -exec rm {} \;

status_db.sh

#!/bin/bash
# script01: check_db.sh - Este script executa o script status_db.sh, fazendo alguns filtros para eliminar informacoes desnecessarias
# usa o comando dos2unix para converter o arquivo depois coloca data no arquivo executado e manda e-mail com o resultado dos backups
# dos bancos de dados mariadb e postgres do Ambiente do Rancher.
# Apaga arquivos anteriores ha 7 dias e é rodado todos os dias as 08h da manha
# script02: status_db.sh - Este script acessa os servidores aonde possuem os containers de backuo e mostra os logs com informacoes
# dizendo se o backup foi executado com sucesso ou nao.
# Programador: Renato Diniz Marigo
# Mantenedor:  Renato Diniz Marigo e Equipe de Infra SciELO
# Criado em: 09/02/2018
# Versão: 1.0
LANG="en_US.UTF8" ; export LANG
echo "######################"
echo "# Ambiente Wordpress #"
echo "######################"
echo " "
ssh renato.diniz@coreos-node11.scielo.org << LOGS
echo "#####################################"
echo "# Status do Backup do PressReleases #"
echo "#####################################"
docker logs --tail 2 ce6965b095b668ffd18e3f692f666b4f6a72a51bb6ace338ec49f864b244c30f
LOGS
echo " "

ssh renato.diniz@coreos-node11.scielo.org << LOGS
echo "#####################################"
echo "# Status do Backup do Blog Revenf   #"
echo "#####################################"
docker logs --tail 2 3dcfd2d6de5d4ead4f5a557abf0dada6044c907ad8d630a196d228ab67c466aa
LOGS
echo " "

ssh renato.diniz@coreos-node13.scielo.org << LOGS
echo "#####################################"
echo "# Status do Backup do Books         #"
echo "#####################################"
docker logs --tail 2 534c5ed652cb2c1f9cf39b739320f07fff86f4d361bb7e26d47415eeab716221
LOGS
echo " "


ssh renato.diniz@coreos-node12.scielo.org << LOGS
echo "#####################################"
echo "# Status do Backup do SciELO 20 anos#"
echo "#####################################"
docker logs --tail 2 fe024d1c4dca874ce9a50077b901355c699997f84d933938488901a3e3596710
LOGS
echo " "

echo "######################"
echo "# Ambiente OPAC-QA   #"
echo "######################"

ssh renato.diniz@coreos-node17.scielo.org << LOGS
echo "##########################################"
echo "# Status do Backup do OPAC-SSM Postgresql#"
echo "##########################################"
docker logs --tail 4 b63f7ad4b6899f4b760375eb331e250d96132ed7ad516e69c863dea949faa97b
LOGS
echo " "


echo "###############################"
echo "# Ambiente SCIELO-PROCESSING  #"
echo "###############################"

ssh renato.diniz@coreos-node26.scielo.org << LOGS
echo "######################################"
echo "# Status do Backup do DOIManager-BRA #"
echo "######################################"
docker logs --tail 4 66c1731bc1ba9fb4143a00d3ba1dd4f83a7a699a1c2b79db917dcebb09ad01b2
LOGS
echo " "

ssh renato.diniz@coreos-node9.scielo.org << LOGS
echo "######################################"
echo "# Status do Backup do DOIManager-CIC #"
echo "######################################"
docker logs --tail 4 9b485e9d6034ee0ef22a3229c1ec2a525f7f535a9630ff3777a0cdcc3e33ba6f
LOGS
echo " "

ssh renato.diniz@coreos-node9.scielo.org << LOGS
echo "######################################"
echo "# Status do Backup do DOIManager-CIC #"
echo "######################################"
docker logs --tail 4 9b485e9d6034ee0ef22a3229c1ec2a525f7f535a9630ff3777a0cdcc3e33ba6f
LOGS
echo " "

echo "#########################"
echo "# Ambiente SCIELO-PROD  #"
echo "#########################"

ssh renato.diniz@coreos-node33.scielo.org << LOGS
echo "##################################"
echo "# Status do Backup do Backoffice #"
echo "##################################"
docker logs --tail 4 c0d9c3d51947d58369fd8d3465a6dd4009f99ddcda9c0ad102e0295e62ff11ed
LOGS
echo " "

ssh renato.diniz@coreos-node31.scielo.org << LOGS
echo "#############################"
echo "# Status do Backup do MACAW #"
echo "#############################"
docker logs --tail 4 0596aa93de46376438c25df78d443d63ff877705c171e750df1f48b674dbe96e
LOGS
echo " "

ssh renato.diniz@coreos-node32.scielo.org << LOGS
echo "################################"
echo "# Status do Backup do OPAC-SSM #"
echo "################################"
docker logs --tail 4 62087e9a7faa116ce8d4742d7277c33737d101b66d01785131d70ce29f754e56
LOGS
echo " "