Edit Todos los servidores hojaruta y rhojaruta / Migración de hojaruta y rhojaruta a postgres

Title:

Last edited: 10:05:47 am on 20 July 2023 by 3.0.1.3

+^_@
_
<tt>Thursday, 20 July 2023, 10:05:04 am</tt>
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:
<code>[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
</code>

Y para arreglarlo, se ha hecho:
<code>
[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
</code>

Para comprobar si todo estaba bien, se ha hecho:
<code>[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
</code>

Y lo mismo en servsic, como oracle:
<code>
[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: `&#65533;'
[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
</code>
_
! 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:
<tt>
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
</tt>

- lock this page
- enter new password
- reenter same password

Send e-mail alerts to these addresses upon next save: