Todos los servidores hojaruta y rhojaruta / Migración de hojaruta y rhojaruta a postgres
Thursday, 20 July 2023, 10:05:04 am
rhr01 rhr02 rhr03 y rhr-este : arreglar el .known_hosts de oracle@servvent y oracle@servsic
El problema es que
oracle@servvent:/home/oracle/ControlPresencia/scripts/recolectadatoshojaruta.sh oracle@servvent:/home/oracle/ControlPresencia/scripts/recolectaestadoshojaruta.sh
No estaban cogiendo datos de rhr01-03 y -este para subirlos a la BBDD.
Para ver qué estaba mal, se ha ha hecho osiguiente; en servvent como oracle:
[oracle@servvent ControlPresencia]$ cd /home/oracle/ControlPresencia [oracle@servvent ControlPresencia]$ for i in `cat scripts/recolectadatoshojaruta.sh | grep LinFis | grep -v '^#' | sed "s/^equipos..//g" | cut -d '_' -f 1-2` ; do echo [$i] ; ssh siv@$(echo $i | cut -d _ -f 2) hostname ; done [hojaruta01_16.0.77.61] hojaruta01 [rhojaruta01_16.2.77.11] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Please contact your system administrator. Add correct host key in /home/oracle/.ssh/known_hosts to get rid of this message. Offending key in /home/oracle/.ssh/known_hosts:7 RSA host key for 16.2.77.11 has changed and you have requested strict checking. Host key verification failed. [hojaruta02_16.0.77.62] hojaruta02 [rhojaruta02_16.2.77.12] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Please contact your system administrator. Add correct host key in /home/oracle/.ssh/known_hosts to get rid of this message. Offending key in /home/oracle/.ssh/known_hosts:11 RSA host key for 16.2.77.12 has changed and you have requested strict checking. Host key verification failed. [hojaruta03_16.0.77.76] hojaruta03 [rhojaruta03_16.2.77.13] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Please contact your system administrator. Add correct host key in /home/oracle/.ssh/known_hosts to get rid of this message. Offending key in /home/oracle/.ssh/known_hosts:13 RSA host key for 16.2.77.13 has changed and you have requested strict checking. Host key verification failed. [hojaruta04_16.0.77.64] hojaruta04 [rhojaruta04_16.2.77.14] rhojaruta04 [hojaruta05_16.0.77.65] hojaruta05 [rhojaruta05_16.2.77.15] rhojaruta05 [hojaruta06_16.0.77.66] hojaruta06 [rhojaruta06_16.2.77.16] rhojaruta06 [hojaruta07_16.0.77.77] hojaruta07 [rhojaruta07_16.2.77.17] rhojaruta07 [hojaruta08_16.0.77.78] hojaruta08 [rhojaruta08_16.2.77.19] rhojaruta08 [hojaruta09_16.0.77.79] hojaruta09 [rhojaruta09_16.2.77.20] rhojaruta09 [hojaruta10_16.0.77.80] hojaruta10 [rhojaruta10_16.2.77.22] rhojaruta10 [hojaruta11_16.0.77.71] hojaruta11 [rhojaruta11_16.2.77.24] rhojaruta11 [hojaruta12_16.0.77.81] hojaruta12 [rhojaruta12_16.2.77.25] rhojaruta12 [hojaruta-norte_16.0.77.70] hojaruta-norte [rhojaruta-norte_16.2.77.23] rhojaruta-norte [hojaruta-este_16.0.77.67] hojaruta-este [rhojaruta-este_16.2.77.18] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Please contact your system administrator. Add correct host key in /home/oracle/.ssh/known_hosts to get rid of this message. Offending key in /home/oracle/.ssh/known_hosts:31 RSA host key for 16.2.77.18 has changed and you have requested strict checking. Host key verification failed. [hojarutatfm_16.0.77.69] hojarutaTFM [rhojarutatfm_16.2.77.21] rhojarutaTFM
Y para arreglarlo, se ha hecho:
[oracle@servvent ControlPresencia]$ sed -i 31d /home/oracle/.ssh/known_hosts [oracle@servvent ControlPresencia]$ sed -i 13d /home/oracle/.ssh/known_hosts [oracle@servvent ControlPresencia]$ sed -i 11d /home/oracle/.ssh/known_hosts [oracle@servvent ControlPresencia]$ sed -i 7d /home/oracle/.ssh/known_hosts
Para comprobar si todo estaba bien, se ha hecho:
[oracle@servvent ControlPresencia]$ for i in rhojaruta01_16.2.77.11 rhojaruta02_16.2.77.12 rhojaruta03_16.2.77.13 rhojaruta-este_16.2.77.18 ; do echo [$i] ; ssh siv@$(echo $i | cut -d _ -f 2) hostname ; done [rhojaruta01_16.2.77.11] rhojaruta01 [rhojaruta02_16.2.77.12] rhojaruta02 [rhojaruta03_16.2.77.13] rhojaruta03 [rhojaruta-este_16.2.77.18] rhojaruta-este
Y lo mismo en servsic, como oracle:
[oracle@ServSIC ~]$ for i in rhojaruta01_16.2.77.11 rhojaruta02_16.2.77.12 rhojaruta03_16.2.77.13 rhojaruta-este_16.2.77.18 ; do echo [$i] ; ssh siv@$(echo $i | cut -d _ -f 2) hostname ; done [rhojaruta01_16.2.77.11] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Please contact your system administrator. Add correct host key in /home/oracle/.ssh/known_hosts to get rid of this message. Offending key in /home/oracle/.ssh/known_hosts:13 RSA host key for 16.2.77.11 has changed and you have requested strict checking. Host key verification failed. [rhojaruta02_16.2.77.12] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Please contact your system administrator. Add correct host key in /home/oracle/.ssh/known_hosts to get rid of this message. Offending key in /home/oracle/.ssh/known_hosts:15 RSA host key for 16.2.77.12 has changed and you have requested strict checking. Host key verification failed. [rhojaruta03_16.2.77.13] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Please contact your system administrator. Add correct host key in /home/oracle/.ssh/known_hosts to get rid of this message. Offending key in /home/oracle/.ssh/known_hosts:17 RSA host key for 16.2.77.13 has changed and you have requested strict checking. Host key verification failed. [rhojaruta-este_16.2.77.18] @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that the RSA host key has just been changed. The fingerprint for the RSA key sent by the remote host is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Please contact your system administrator. Add correct host key in /home/oracle/.ssh/known_hosts to get rid of this message. Offending key in /home/oracle/.ssh/known_hosts:39 RSA host key for 16.2.77.18 has changed and you have requested strict checking. Host key verification failed. [oracle@ServSIC ~]$ sed -i 39d /home/oracle/.ssh/known_hosts sed: -e expression #1, char 1: unknown command: `�' [oracle@ServSIC ~]$ sed -i 39d /home/oracle/.ssh/known_hosts [oracle@ServSIC ~]$ sed -i 17d /home/oracle/.ssh/known_hosts [oracle@ServSIC ~]$ sed -i 15d /home/oracle/.ssh/known_hosts [oracle@ServSIC ~]$ sed -i 13d /home/oracle/.ssh/known_hosts [oracle@ServSIC ~]$ for i in rhojaruta01_16.2.77.11 rhojaruta02_16.2.77.12 rhojaruta03_16.2.77.13 rhojaruta-este_16.2.77.18 ; do echo [$i] ; ssh siv@$(echo $i | cut -d _ -f 2) hostname ; done [rhojaruta01_16.2.77.11] The authenticity of host '16.2.77.11 (16.2.77.11)' can't be established. RSA key fingerprint is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '16.2.77.11' (RSA) to the list of known hosts. rhojaruta01 [rhojaruta02_16.2.77.12] The authenticity of host '16.2.77.12 (16.2.77.12)' can't be established. RSA key fingerprint is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '16.2.77.12' (RSA) to the list of known hosts. rhojaruta02 [rhojaruta03_16.2.77.13] The authenticity of host '16.2.77.13 (16.2.77.13)' can't be established. RSA key fingerprint is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '16.2.77.13' (RSA) to the list of known hosts. rhojaruta03 [rhojaruta-este_16.2.77.18] The authenticity of host '16.2.77.18 (16.2.77.18)' can't be established. RSA key fingerprint is 31:3c:15:16:cd:2a:f8:55:e3:69:06:07:f8:23:6a:22. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '16.2.77.18' (RSA) to the list of known hosts. rhojaruta-este [oracle@ServSIC ~]$ for i in rhojaruta01_16.2.77.11 rhojaruta02_16.2.77.12 rhojaruta03_16.2.77.13 rhojaruta-este_16.2.77.18 ; do echo [$i] ; ssh siv@$(echo $i | cut -d _ -f 2) hostname ; done [rhojaruta01_16.2.77.11] rhojaruta01 [rhojaruta02_16.2.77.12] rhojaruta02 [rhojaruta03_16.2.77.13] rhojaruta03 [rhojaruta-este_16.2.77.18] rhojaruta-este
Descripción del proyecto
Notas sobre la migración de los hojaruta/rhojaruta
IMPORTANTE: Cuando se migra un hojaruta hay que actualizar el .known_hosts de oracle@servvent y oracle@servsic
Datos antiguos:
Cambios realizados sobre los hojaruta y rhojaruta. En estos momentos (20091027) son los siguientes equipos:
hojaruta03
hojaruta07
hojaruta08
hojaruta09
hojaruta10
hojaruta12
rhojaruta01
rhojaruta02
rhojaruta03
rhojaruta04
rhojaruta05
rhojaruta06
rhojaruta07
rhojaruta-este
rhojaruta08
rhojaruta09
rhojarutaTFM
rhojaruta10
rhojaruta-norte
rhojaruta11
rhojaruta12
rhojaruta-backup