Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
fallo al actualizar Pandora 7.0 NG
#11
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote:
(05-17-2019, 09:22 AM)Jramongv Wrote:
(05-17-2019, 08:07 AM)eduardo.corral Wrote:
(05-17-2019, 07:40 AM)Jramongv Wrote: Hola de nuevo, he actualizado hasta el 7.0 NG 734 y he aplicado los XX.sql de forma consecutiva hasta el 27.sql

Lo estoy hacieendo con cat 27.sql | mysql -u root -p pandora

En el 27.sql me da el error:
ERROR 1146 (42S02) at line 14: Table 'pandora.tuser_task' doesn't exist

Buenos días, Jramongv

Es importante tener en cuenta que el mejor proceso es instalar los MR con "source" y no con "cat". Ejecutando "cat" existe el problema de que si se encuentra un fallo en un punto intermedio de la aplicación de los MR, habría que borrar todos hasta ese punto para corregir el error, así es muy peligroso arrastrar fallos con ese comando. 

Respecto al php, basta con hacer una instalación normal. Tendrá en cuenta que tienes una versión anterior y actualizará a la 7.2 sin problema ninguno. Pero es vital actualizar el php antes de seguir con el resto de cambios. 

Un cordial saludo, 

Eduardo.
Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

(05-17-2019, 09:22 AM)Jramongv Wrote:
(05-17-2019, 08:07 AM)eduardo.corral Wrote: Buenos días, Jramongv

Es importante tener en cuenta que el mejor proceso es instalar los MR con "source" y no con "cat". Ejecutando "cat" existe el problema de que si se encuentra un fallo en un punto intermedio de la aplicación de los MR, habría que borrar todos hasta ese punto para corregir el error, así es muy peligroso arrastrar fallos con ese comando. 

Respecto al php, basta con hacer una instalación normal. Tendrá en cuenta que tienes una versión anterior y actualizará a la 7.2 sin problema ninguno. Pero es vital actualizar el php antes de seguir con el resto de cambios. 

Un cordial saludo, 

Eduardo.
Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

Desde el 6.sql hasta el 27.sql los he hecho todos con el cat XX.sql | mysql -u root -p pandora,

pero en ninguno me ha dado error excepto en el 27.sql, ahora haciendo el 27 con source me da lo de antes.

Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

(05-22-2019, 06:55 AM)Jramongv Wrote:
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote:
(05-17-2019, 09:22 AM)Jramongv Wrote:
(05-17-2019, 08:07 AM)eduardo.corral Wrote: Buenos días, Jramongv

Es importante tener en cuenta que el mejor proceso es instalar los MR con "source" y no con "cat". Ejecutando "cat" existe el problema de que si se encuentra un fallo en un punto intermedio de la aplicación de los MR, habría que borrar todos hasta ese punto para corregir el error, así es muy peligroso arrastrar fallos con ese comando. 

Respecto al php, basta con hacer una instalación normal. Tendrá en cuenta que tienes una versión anterior y actualizará a la 7.2 sin problema ninguno. Pero es vital actualizar el php antes de seguir con el resto de cambios. 

Un cordial saludo, 

Eduardo.
Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

(05-17-2019, 09:22 AM)Jramongv Wrote: Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

Desde el 6.sql hasta el 27.sql los he hecho todos con el cat XX.sql | mysql -u root -p pandora,

pero en ninguno me ha dado error excepto en el 27.sql, ahora haciendo el 27 con source me da lo de antes.

Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
¿Alguna sugerencia al respecto?. No sé si está todo OK, no creo por los errores que aparecen, ¿debería reinstalar otra vez?
 Reply
#12
(05-22-2019, 06:55 AM)Jramongv Wrote:
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote:
(05-17-2019, 09:22 AM)Jramongv Wrote:
(05-17-2019, 08:07 AM)eduardo.corral Wrote: Buenos días, Jramongv

Es importante tener en cuenta que el mejor proceso es instalar los MR con "source" y no con "cat". Ejecutando "cat" existe el problema de que si se encuentra un fallo en un punto intermedio de la aplicación de los MR, habría que borrar todos hasta ese punto para corregir el error, así es muy peligroso arrastrar fallos con ese comando. 

Respecto al php, basta con hacer una instalación normal. Tendrá en cuenta que tienes una versión anterior y actualizará a la 7.2 sin problema ninguno. Pero es vital actualizar el php antes de seguir con el resto de cambios. 

Un cordial saludo, 

Eduardo.
Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

(05-17-2019, 09:22 AM)Jramongv Wrote: Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?

Desde el 6.sql hasta el 27.sql los he hecho todos con el cat XX.sql | mysql -u root -p pandora,

pero en ninguno me ha dado error excepto en el 27.sql, ahora haciendo el 27 con source me da lo de antes.

Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

(05-22-2019, 06:55 AM)Jramongv Wrote:
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote:
(05-17-2019, 09:22 AM)Jramongv Wrote: Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?


Desde el 6.sql hasta el 27.sql los he hecho todos con el cat XX.sql | mysql -u root -p pandora,

pero en ninguno me ha dado error excepto en el 27.sql, ahora haciendo el 27 con source me da lo de antes.

Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
¿Alguna sugerencia al respecto?. No sé si está todo OK, no creo por los errores que aparecen, ¿debería reinstalar otra vez?

Buenos días, Jramongv

Por lo que nos comentas, parece estar todo bien. Es relativamente frecuente que al aplicar los MR se produzca errores de duplicado, pero mientras el resultado de la query sea OK todo está en orden. 

No obstante, vamos a asegurarnos de que el último error que figura no sea nada extraño. 

¿Podrías, por favor, enviarnos el resultado de la siguiente consulta en tu base de datos?


Code:
use pandora;
show tables;


Vamos a comprobar que exista la tabla tuser_task. 

Un cordial saludo, 

Eduardo.
 Reply
#13
(05-22-2019, 07:39 AM)eduardo.corral Wrote:
(05-22-2019, 06:55 AM)Jramongv Wrote:
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote:
(05-17-2019, 09:22 AM)Jramongv Wrote: Hola Eduardo,

Ejecutando con source me pasa esto:

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)


Ahora no sé si tendría que repetir todos los sql de nuevo con source..... ¿me podrías indicar?


Desde el 6.sql hasta el 27.sql los he hecho todos con el cat XX.sql | mysql -u root -p pandora,

pero en ninguno me ha dado error excepto en el 27.sql, ahora haciendo el 27 con source me da lo de antes.

Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

(05-22-2019, 06:55 AM)Jramongv Wrote:
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote: Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
¿Alguna sugerencia al respecto?. No sé si está todo OK, no creo por los errores que aparecen, ¿debería reinstalar otra vez?

Buenos días, Jramongv

Por lo que nos comentas, parece estar todo bien. Es relativamente frecuente que al aplicar los MR se produzca errores de duplicado, pero mientras el resultado de la query sea OK todo está en orden. 

No obstante, vamos a asegurarnos de que el último error que figura no sea nada extraño. 

¿Podrías, por favor, enviarnos el resultado de la siguiente consulta en tu base de datos?


Code:
use pandora;
show tables;


Vamos a comprobar que exista la tabla tuser_task. 

Un cordial saludo, 

Eduardo.
Hola Eduardo, ahí tienes la salida, parece que la tabla no está

mysql> show tables;
+------------------------------------+
| Tables_in_pandora                  |
+------------------------------------+
| taddress                           |
| taddress_agent                     |
| tagent_access                      |
| tagent_custom_data                 |
| tagent_custom_fields               |
| tagent_custom_fields_filter        |
| tagent_module_inventory            |
| tagent_module_log                  |
| tagent_secondary_group             |
| tagente                            |
| tagente_datos                      |
| tagente_datos_inc                  |
| tagente_datos_inventory            |
| tagente_datos_log4x                |
| tagente_datos_string               |
| tagente_estado                     |
| tagente_modulo                     |
| talert_actions                     |
| talert_commands                    |
| talert_snmp                        |
| talert_snmp_action                 |
| talert_special_days                |
| talert_template_module_actions     |
| talert_template_modules            |
| talert_templates                   |
| tattachment                        |
| tautoconfig                        |
| tautoconfig_actions                |
| tautoconfig_rules                  |
| tcategory                          |
| tcluster                           |
| tcluster_agent                     |
| tcluster_item                      |
| tcollection                        |
| tconfig                            |
| tconfig_os                         |
| tcontainer                         |
| tcontainer_item                    |
| tdashboard                         |
| tdatabase                          |
| tevent_alert                       |
| tevent_alert_action                |
| tevent_custom_field                |
| tevent_extended                    |
| tevent_filter                      |
| tevent_response                    |
| tevent_rule                        |
| tevento                            |
| textension_translate_string        |
| tfiles_repo                        |
| tfiles_repo_group                  |
| tgis_data_history                  |
| tgis_data_status                   |
| tgis_map                           |
| tgis_map_connection                |
| tgis_map_has_tgis_map_con          |
| tgis_map_layer                     |
| tgis_map_layer_groups              |
| tgis_map_layer_has_tagente         |
| tgraph                             |
| tgraph_source                      |
| tgraph_source_template             |
| tgraph_template                    |
| tgroup_stat                        |
| tgrupo                             |
| tincidencia                        |
| titem                              |
| tlanguage                          |
| tlayout                            |
| tlayout_data                       |
| tlayout_template                   |
| tlayout_template_data              |
| tlink                              |
| tlocal_component                   |
| tlog_graph_models                  |
| tmap                               |
| tmensajes                          |
| tmetaconsole_agent                 |
| tmetaconsole_agent_secondary_group |
| tmetaconsole_event                 |
| tmetaconsole_event_history         |
| tmetaconsole_setup                 |
| tmigration_module_queue            |
| tmigration_queue                   |
| tmodule                            |
| tmodule_group                      |
| tmodule_inventory                  |
| tmodule_relationship               |
| tmodule_synth                      |
| tnetflow_filter                    |
| tnetflow_report                    |
| tnetflow_report_content            |
| tnetwork_component                 |
| tnetwork_component_group           |
| tnetwork_map                       |
| tnetwork_matrix                    |
| tnetwork_profile                   |
| tnetwork_profile_component         |
| tnetworkmap_ent_rel_nodes          |
| tnetworkmap_enterprise             |
| tnetworkmap_enterprise_nodes       |
| tnews                              |
| tnota                              |
| tnotification_group                |
| tnotification_source               |
| tnotification_source_group         |
| tnotification_source_group_user    |
| tnotification_source_user          |
| tnotification_user                 |
| torigen                            |
| tpassword_history                  |
| tperfil                            |
| tphase                             |
| tplanned_downtime                  |
| tplanned_downtime_agents           |
| tplanned_downtime_modules          |
| tplugin                            |
| tpolicies                          |
| tpolicy_agents                     |
| tpolicy_alerts                     |
| tpolicy_alerts_actions             |
| tpolicy_collections                |
| tpolicy_groups                     |
| tpolicy_modules                    |
| tpolicy_modules_inventory          |
| tpolicy_plugins                    |
| tpolicy_queue                      |
| tprofile_view                      |
| tprovisioning                      |
| tprovisioning_rules                |
| trecon_script                      |
| trecon_task                        |
| trel_item                          |
| treport                            |
| treport_content                    |
| treport_content_item               |
| treport_content_item_temp          |
| treport_content_sla_com_temp       |
| treport_content_sla_combined       |
| treport_content_template           |
| treport_custom_sql                 |
| treport_template                   |
| treset_pass                        |
| treset_pass_history                |
| tserver                            |
| tserver_export                     |
| tserver_export_data                |
| tservice                           |
| tservice_element                   |
| tsesion                            |
| tsesion_extended                   |
| tsessions_php                      |
| tskin                              |
| tsnmp_filter                       |
| ttag                               |
| ttag_module                        |
| ttag_policy_module                 |
| ttipo_modulo                       |
| ttransaction                       |
| ttrap                              |
| ttrap_custom_values                |
| tupdate                            |
| tupdate_journal                    |
| tupdate_package                    |
| tupdate_settings                   |
| tuser_double_auth                  |
| tusuario                           |
| tusuario_perfil                    |
| twidget                            |
| twidget_dashboard                  |
+------------------------------------+
170 rows in set (0.00 sec)

mysql> ç
 Reply
#14
(05-22-2019, 10:01 AM)Jramongv Wrote:
(05-22-2019, 07:39 AM)eduardo.corral Wrote:
(05-22-2019, 06:55 AM)Jramongv Wrote:
(05-17-2019, 11:48 AM)Jramongv Wrote:
(05-17-2019, 11:37 AM)eduardo.corral Wrote: Buenos días, Jramongv

Mientras la ejecución devuelva el valor "Query OK" todo está correcto. ¿Aplicando el 27 con "source" qué es lo que te da exactamente? ¿El valor "Query OK" o el fallo del post previo?

Un saludo, 

Eduardo.

Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

(05-22-2019, 06:55 AM)Jramongv Wrote:
(05-17-2019, 11:48 AM)Jramongv Wrote: Hola Eduardo, la salida es esta:  (primero da un OK, después error y después OK)

mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.54 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.21 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.16 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.18 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.19 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.17 sec)
Records: 16  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.17 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.13 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 5 rows affected (0.16 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.15 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
¿Alguna sugerencia al respecto?. No sé si está todo OK, no creo por los errores que aparecen, ¿debería reinstalar otra vez?

Buenos días, Jramongv

Por lo que nos comentas, parece estar todo bien. Es relativamente frecuente que al aplicar los MR se produzca errores de duplicado, pero mientras el resultado de la query sea OK todo está en orden. 

No obstante, vamos a asegurarnos de que el último error que figura no sea nada extraño. 

¿Podrías, por favor, enviarnos el resultado de la siguiente consulta en tu base de datos?


Code:
use pandora;
show tables;


Vamos a comprobar que exista la tabla tuser_task. 

Un cordial saludo, 

Eduardo.
Hola Eduardo, ahí tienes la salida, parece que la tabla no está

mysql> show tables;
+------------------------------------+
| Tables_in_pandora                  |
+------------------------------------+
| taddress                           |
| taddress_agent                     |
| tagent_access                      |
| tagent_custom_data                 |
| tagent_custom_fields               |
| tagent_custom_fields_filter        |
| tagent_module_inventory            |
| tagent_module_log                  |
| tagent_secondary_group             |
| tagente                            |
| tagente_datos                      |
| tagente_datos_inc                  |
| tagente_datos_inventory            |
| tagente_datos_log4x                |
| tagente_datos_string               |
| tagente_estado                     |
| tagente_modulo                     |
| talert_actions                     |
| talert_commands                    |
| talert_snmp                        |
| talert_snmp_action                 |
| talert_special_days                |
| talert_template_module_actions     |
| talert_template_modules            |
| talert_templates                   |
| tattachment                        |
| tautoconfig                        |
| tautoconfig_actions                |
| tautoconfig_rules                  |
| tcategory                          |
| tcluster                           |
| tcluster_agent                     |
| tcluster_item                      |
| tcollection                        |
| tconfig                            |
| tconfig_os                         |
| tcontainer                         |
| tcontainer_item                    |
| tdashboard                         |
| tdatabase                          |
| tevent_alert                       |
| tevent_alert_action                |
| tevent_custom_field                |
| tevent_extended                    |
| tevent_filter                      |
| tevent_response                    |
| tevent_rule                        |
| tevento                            |
| textension_translate_string        |
| tfiles_repo                        |
| tfiles_repo_group                  |
| tgis_data_history                  |
| tgis_data_status                   |
| tgis_map                           |
| tgis_map_connection                |
| tgis_map_has_tgis_map_con          |
| tgis_map_layer                     |
| tgis_map_layer_groups              |
| tgis_map_layer_has_tagente         |
| tgraph                             |
| tgraph_source                      |
| tgraph_source_template             |
| tgraph_template                    |
| tgroup_stat                        |
| tgrupo                             |
| tincidencia                        |
| titem                              |
| tlanguage                          |
| tlayout                            |
| tlayout_data                       |
| tlayout_template                   |
| tlayout_template_data              |
| tlink                              |
| tlocal_component                   |
| tlog_graph_models                  |
| tmap                               |
| tmensajes                          |
| tmetaconsole_agent                 |
| tmetaconsole_agent_secondary_group |
| tmetaconsole_event                 |
| tmetaconsole_event_history         |
| tmetaconsole_setup                 |
| tmigration_module_queue            |
| tmigration_queue                   |
| tmodule                            |
| tmodule_group                      |
| tmodule_inventory                  |
| tmodule_relationship               |
| tmodule_synth                      |
| tnetflow_filter                    |
| tnetflow_report                    |
| tnetflow_report_content            |
| tnetwork_component                 |
| tnetwork_component_group           |
| tnetwork_map                       |
| tnetwork_matrix                    |
| tnetwork_profile                   |
| tnetwork_profile_component         |
| tnetworkmap_ent_rel_nodes          |
| tnetworkmap_enterprise             |
| tnetworkmap_enterprise_nodes       |
| tnews                              |
| tnota                              |
| tnotification_group                |
| tnotification_source               |
| tnotification_source_group         |
| tnotification_source_group_user    |
| tnotification_source_user          |
| tnotification_user                 |
| torigen                            |
| tpassword_history                  |
| tperfil                            |
| tphase                             |
| tplanned_downtime                  |
| tplanned_downtime_agents           |
| tplanned_downtime_modules          |
| tplugin                            |
| tpolicies                          |
| tpolicy_agents                     |
| tpolicy_alerts                     |
| tpolicy_alerts_actions             |
| tpolicy_collections                |
| tpolicy_groups                     |
| tpolicy_modules                    |
| tpolicy_modules_inventory          |
| tpolicy_plugins                    |
| tpolicy_queue                      |
| tprofile_view                      |
| tprovisioning                      |
| tprovisioning_rules                |
| trecon_script                      |
| trecon_task                        |
| trel_item                          |
| treport                            |
| treport_content                    |
| treport_content_item               |
| treport_content_item_temp          |
| treport_content_sla_com_temp       |
| treport_content_sla_combined       |
| treport_content_template           |
| treport_custom_sql                 |
| treport_template                   |
| treset_pass                        |
| treset_pass_history                |
| tserver                            |
| tserver_export                     |
| tserver_export_data                |
| tservice                           |
| tservice_element                   |
| tsesion                            |
| tsesion_extended                   |
| tsessions_php                      |
| tskin                              |
| tsnmp_filter                       |
| ttag                               |
| ttag_module                        |
| ttag_policy_module                 |
| ttipo_modulo                       |
| ttransaction                       |
| ttrap                              |
| ttrap_custom_values                |
| tupdate                            |
| tupdate_journal                    |
| tupdate_package                    |
| tupdate_settings                   |
| tuser_double_auth                  |
| tusuario                           |
| tusuario_perfil                    |
| twidget                            |
| twidget_dashboard                  |
+------------------------------------+
170 rows in set (0.00 sec)

mysql> ç

Buenos días, Jramongv

Comprobando que la tabla no existe queda todo correcto. No debería generar ningún problema ya que es una tabla perteneciente a versiones anteriores de Pandora FMS y actualmente está en desuso.

Aún así, y para evitar futuros problemas, vamos a crear la tabla de forma manual. Para ello accede a la base de datos y ejecuta los siguientes comandos: 

Code:
use pandora;
create table tuser_task;

Una vez hecho esto, ejecuta de nuevo el MR 27.sql. Se generarán bastantes entradas de "Duplicate column" porque ya lo aplicamos anteriormente, pero no debería generar ningún otro error. 

Un cordial saludo, 

Eduardo.
 Reply
#15
Eduardo,
Al intentar crear la tabla desde mysql da el error:
mysql> create table tuser_task;
ERROR 1113 (42000): A table must have at least 1 column

Está bastante claro, si se crea la tabla se debería crear con las columnas adecuadas, he visto que el 27.sql tiene el siguiente update:

UPDATE tuser_task SET parameters = 'a:5:{i:0;a:6:{s:11:\"description\";s:28:\"Report pending to be created\";s:5:\"table\";s:7:\"treport\";s:8:\"field_id\";s:9:\"id_report\";s:10:\"field_name
\";s:4:\"name\";s:4:\"type\";s:3:\"int\";s:9:\"acl_group\";s:8:\"id_group\";}i:1;a:2:{s:11:\"description\";s:46:\"Send to email addresses (separated by a comma)\";s:4:\"type\";s:4:\"text\";}i
:2;a:2:{s:11:\"description\";s:7:\"Subject\";s:8:\"optional\";i:1;}i:3;a:3:{s:11:\"description\";s:7:\"Message\";s:4:\"type\";s:4:\"text\";s:8:\"optional\";i:1;}i:4;a:2:{s:11:\"description\";
s:11:\"Report Type\";s:4:\"type\";s:11:\"report_type\";}}' where function_name = "cron_task_generate_report";

No sé si es mejor comentar el 27.sql o que se cree la tabla con todas las columnas adecuadamente.
 Reply
#16
(05-23-2019, 11:32 AM)Jramongv Wrote: Eduardo,
Al intentar crear la tabla desde mysql da el error:
mysql> create table tuser_task;
ERROR 1113 (42000): A table must have at least 1 column

Está bastante claro, si se crea la tabla se debería crear con las columnas adecuadas, he visto que el 27.sql tiene el siguiente update:

UPDATE tuser_task SET parameters = 'a:5:{i:0;a:6:{s:11:\"description\";s:28:\"Report pending to be created\";s:5:\"table\";s:7:\"treport\";s:8:\"field_id\";s:9:\"id_report\";s:10:\"field_name
\";s:4:\"name\";s:4:\"type\";s:3:\"int\";s:9:\"acl_group\";s:8:\"id_group\";}i:1;a:2:{s:11:\"description\";s:46:\"Send to email addresses (separated by a comma)\";s:4:\"type\";s:4:\"text\";}i
:2;a:2:{s:11:\"description\";s:7:\"Subject\";s:8:\"optional\";i:1;}i:3;a:3:{s:11:\"description\";s:7:\"Message\";s:4:\"type\";s:4:\"text\";s:8:\"optional\";i:1;}i:4;a:2:{s:11:\"description\";
s:11:\"Report Type\";s:4:\"type\";s:11:\"report_type\";}}' where function_name = "cron_task_generate_report";

No sé si es mejor comentar el 27.sql o que se cree la tabla con todas las columnas adecuadamente.

Buenos días, Jramongv


Como el fallo que estas teniendo es en la estructura de la base de datos lo mejor sera aplicar el siguiente comando que es un  script integrado en Pandora que contiene estos cambios.


Code:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -ppandora -D pandora


Al ser una version Opensource se puede dar el caso de que te aparezca el error "ERROR 1060(42S21) at line 1256: Duplicate column name 'dynamic_next'"

En ese caso y SOLO EN ESE CASO, será necesario que accedas a la base de datos y ejecutes las siguientes consultas para que este error se resuelva:

Code:
ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';

UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;

ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";

ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';

UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');

DELETE FROM twidget WHERE unique_name = 'graph_availability';

ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";

Esto debería solucionar tu problema desapareciendo así el error de la tabla al ejecutar el MR 27.sql 

Un cordial saludo, 

Eduardo. 

Un saludo
 Reply
#17
(05-24-2019, 11:13 AM)eduardo.corral Wrote:
(05-23-2019, 11:32 AM)Jramongv Wrote: Eduardo,
Al intentar crear la tabla desde mysql da el error:
mysql> create table tuser_task;
ERROR 1113 (42000): A table must have at least 1 column

Está bastante claro, si se crea la tabla se debería crear con las columnas adecuadas, he visto que el 27.sql tiene el siguiente update:

UPDATE tuser_task SET parameters = 'a:5:{i:0;a:6:{s:11:\"description\";s:28:\"Report pending to be created\";s:5:\"table\";s:7:\"treport\";s:8:\"field_id\";s:9:\"id_report\";s:10:\"field_name
\";s:4:\"name\";s:4:\"type\";s:3:\"int\";s:9:\"acl_group\";s:8:\"id_group\";}i:1;a:2:{s:11:\"description\";s:46:\"Send to email addresses (separated by a comma)\";s:4:\"type\";s:4:\"text\";}i
:2;a:2:{s:11:\"description\";s:7:\"Subject\";s:8:\"optional\";i:1;}i:3;a:3:{s:11:\"description\";s:7:\"Message\";s:4:\"type\";s:4:\"text\";s:8:\"optional\";i:1;}i:4;a:2:{s:11:\"description\";
s:11:\"Report Type\";s:4:\"type\";s:11:\"report_type\";}}' where function_name = "cron_task_generate_report";

No sé si es mejor comentar el 27.sql o que se cree la tabla con todas las columnas adecuadamente.

Buenos días, Jramongv


Como el fallo que estas teniendo es en la estructura de la base de datos lo mejor sera aplicar el siguiente comando que es un  script integrado en Pandora que contiene estos cambios.


Code:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -ppandora -D pandora


Al ser una version Opensource se puede dar el caso de que te aparezca el error "ERROR 1060(42S21) at line 1256: Duplicate column name 'dynamic_next'"

En ese caso y SOLO EN ESE CASO, será necesario que accedas a la base de datos y ejecutes las siguientes consultas para que este error se resuelva:

Code:
ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';

UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;

ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";

ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';

UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');

DELETE FROM twidget WHERE unique_name = 'graph_availability';

ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";

Esto debería solucionar tu problema desapareciendo así el error de la tabla al ejecutar el MR 27.sql 

Un cordial saludo, 

Eduardo. 

Un saludo
Eduardo,

Pues no estoy muy seguro que se haya solucionado el problema, mira he hecho lo siguiente:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -p  -D pandora
Enter password:

y me ha dado el error
ERROR 1060 (42S21) at line 59: Duplicate column name 'dynamic_next'
Entonces siguiendo las instrucciones he entrado en mysql y ejecutado los comandos:

mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9647
Server version: 5.5.40-36.1 Percona Server (GPL), Release 36.1, Revision 707

Copyright © 2009-2014 Percona LLC and/or its affiliates
Copyright © 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use pandora
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ERROR 1060 (42S21): Duplicate column name 'cascade_protection_module'
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null default;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null default '0';
ERROR 1060 (42S21): Duplicate column name 'alias'
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'alias_as_name'
mysql> UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";
Query OK, 0 rows affected, 1 warning (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 1

mysql> ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'alias_as_name'
mysql> ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'snmp_enabled'
mysql> ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'vlan_enabled'
mysql> UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> DELETE FROM twidget WHERE unique_name = 'graph_availability';
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";
ERROR 1146 (42S02): Table 'pandora.tbackup' doesn't exist

Y después he pasado a ejecutar el 27.sql, pero los errores siguen:
mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
ERROR 1060 (42S21): Duplicate column name 'total_time'
ERROR 1060 (42S21): Duplicate column name 'time_failed'
ERROR 1060 (42S21): Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21): Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21): Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21): Duplicate column name 'total_checks'
ERROR 1060 (42S21): Duplicate column name 'checks_failed'
ERROR 1060 (42S21): Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'unknown_checks'
ERROR 1060 (42S21): Duplicate column name 'agent_max_value'
ERROR 1060 (42S21): Duplicate column name 'agent_min_value'
ERROR 1060 (42S21): Duplicate column name 'total_time'
ERROR 1060 (42S21): Duplicate column name 'time_failed'
ERROR 1060 (42S21): Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21): Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21): Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21): Duplicate column name 'total_checks'
ERROR 1060 (42S21): Duplicate column name 'checks_failed'
ERROR 1060 (42S21): Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'unknown_checks'
ERROR 1060 (42S21): Duplicate column name 'agent_max_value'
ERROR 1060 (42S21): Duplicate column name 'agent_min_value'
ERROR 1060 (42S21): Duplicate column name 'type'
ERROR 1060 (42S21): Duplicate column name 'type'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
 Reply
#18
(05-29-2019, 06:50 AM)Jramongv Wrote:
(05-24-2019, 11:13 AM)eduardo.corral Wrote:
(05-23-2019, 11:32 AM)Jramongv Wrote: Eduardo,
Al intentar crear la tabla desde mysql da el error:
mysql> create table tuser_task;
ERROR 1113 (42000): A table must have at least 1 column

Está bastante claro, si se crea la tabla se debería crear con las columnas adecuadas, he visto que el 27.sql tiene el siguiente update:

UPDATE tuser_task SET parameters = 'a:5:{i:0;a:6:{s:11:\"description\";s:28:\"Report pending to be created\";s:5:\"table\";s:7:\"treport\";s:8:\"field_id\";s:9:\"id_report\";s:10:\"field_name
\";s:4:\"name\";s:4:\"type\";s:3:\"int\";s:9:\"acl_group\";s:8:\"id_group\";}i:1;a:2:{s:11:\"description\";s:46:\"Send to email addresses (separated by a comma)\";s:4:\"type\";s:4:\"text\";}i
:2;a:2:{s:11:\"description\";s:7:\"Subject\";s:8:\"optional\";i:1;}i:3;a:3:{s:11:\"description\";s:7:\"Message\";s:4:\"type\";s:4:\"text\";s:8:\"optional\";i:1;}i:4;a:2:{s:11:\"description\";
s:11:\"Report Type\";s:4:\"type\";s:11:\"report_type\";}}' where function_name = "cron_task_generate_report";

No sé si es mejor comentar el 27.sql o que se cree la tabla con todas las columnas adecuadamente.

Buenos días, Jramongv


Como el fallo que estas teniendo es en la estructura de la base de datos lo mejor sera aplicar el siguiente comando que es un  script integrado en Pandora que contiene estos cambios.


Code:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -ppandora -D pandora


Al ser una version Opensource se puede dar el caso de que te aparezca el error "ERROR 1060(42S21) at line 1256: Duplicate column name 'dynamic_next'"

En ese caso y SOLO EN ESE CASO, será necesario que accedas a la base de datos y ejecutes las siguientes consultas para que este error se resuelva:

Code:
ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';

UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;

ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";

ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';

UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');

DELETE FROM twidget WHERE unique_name = 'graph_availability';

ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";

Esto debería solucionar tu problema desapareciendo así el error de la tabla al ejecutar el MR 27.sql 

Un cordial saludo, 

Eduardo. 

Un saludo
Eduardo,

Pues no estoy muy seguro que se haya solucionado el problema, mira he hecho lo siguiente:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -p  -D pandora
Enter password:

y me ha dado el error
ERROR 1060 (42S21) at line 59: Duplicate column name 'dynamic_next'
Entonces siguiendo las instrucciones he entrado en mysql y ejecutado los comandos:

mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9647
Server version: 5.5.40-36.1 Percona Server (GPL), Release 36.1, Revision 707

Copyright © 2009-2014 Percona LLC and/or its affiliates
Copyright © 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use pandora
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ERROR 1060 (42S21): Duplicate column name 'cascade_protection_module'
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null default;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null default '0';
ERROR 1060 (42S21): Duplicate column name 'alias'
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'alias_as_name'
mysql> UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";
Query OK, 0 rows affected, 1 warning (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 1

mysql> ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'alias_as_name'
mysql> ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'snmp_enabled'
mysql> ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'vlan_enabled'
mysql> UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> DELETE FROM twidget WHERE unique_name = 'graph_availability';
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";
ERROR 1146 (42S02): Table 'pandora.tbackup' doesn't exist

Y después he pasado a ejecutar el 27.sql, pero los errores siguen:
mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
ERROR 1060 (42S21): Duplicate column name 'total_time'
ERROR 1060 (42S21): Duplicate column name 'time_failed'
ERROR 1060 (42S21): Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21): Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21): Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21): Duplicate column name 'total_checks'
ERROR 1060 (42S21): Duplicate column name 'checks_failed'
ERROR 1060 (42S21): Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'unknown_checks'
ERROR 1060 (42S21): Duplicate column name 'agent_max_value'
ERROR 1060 (42S21): Duplicate column name 'agent_min_value'
ERROR 1060 (42S21): Duplicate column name 'total_time'
ERROR 1060 (42S21): Duplicate column name 'time_failed'
ERROR 1060 (42S21): Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21): Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21): Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21): Duplicate column name 'total_checks'
ERROR 1060 (42S21): Duplicate column name 'checks_failed'
ERROR 1060 (42S21): Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'unknown_checks'
ERROR 1060 (42S21): Duplicate column name 'agent_max_value'
ERROR 1060 (42S21): Duplicate column name 'agent_min_value'
ERROR 1060 (42S21): Duplicate column name 'type'
ERROR 1060 (42S21): Duplicate column name 'type'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Buenos días Jramongv,

El script de migración de versiones sql que has pasado reconstruye parte de la base de datos en caso de que te falten tablas, como parece que era tu caso. Después de pasar el script es aconsejable pasar todos los MR pero no debería ser tampoco necesario.

Los errores de tablas duplicadas al pasar un MR son comunes si ese MR se había pasado previamente, intenta crear tablas que ya existen y devuelve ese error.

¿Puedes iniciar el servicio de pandora_server sin problema? ¿ves algún error al intentar acceder a la consola? ¿Qué versión de Pandora dice que tienes instalada si ejecutas "pandora_server -v" (sin comillas) en el servidor?

Un saludo
 Reply
#19
(05-30-2019, 10:29 AM)jose.almendros Wrote:
(05-29-2019, 06:50 AM)Jramongv Wrote:
(05-24-2019, 11:13 AM)eduardo.corral Wrote:
(05-23-2019, 11:32 AM)Jramongv Wrote: Eduardo,
Al intentar crear la tabla desde mysql da el error:
mysql> create table tuser_task;
ERROR 1113 (42000): A table must have at least 1 column

Está bastante claro, si se crea la tabla se debería crear con las columnas adecuadas, he visto que el 27.sql tiene el siguiente update:

UPDATE tuser_task SET parameters = 'a:5:{i:0;a:6:{s:11:\"description\";s:28:\"Report pending to be created\";s:5:\"table\";s:7:\"treport\";s:8:\"field_id\";s:9:\"id_report\";s:10:\"field_name
\";s:4:\"name\";s:4:\"type\";s:3:\"int\";s:9:\"acl_group\";s:8:\"id_group\";}i:1;a:2:{s:11:\"description\";s:46:\"Send to email addresses (separated by a comma)\";s:4:\"type\";s:4:\"text\";}i
:2;a:2:{s:11:\"description\";s:7:\"Subject\";s:8:\"optional\";i:1;}i:3;a:3:{s:11:\"description\";s:7:\"Message\";s:4:\"type\";s:4:\"text\";s:8:\"optional\";i:1;}i:4;a:2:{s:11:\"description\";
s:11:\"Report Type\";s:4:\"type\";s:11:\"report_type\";}}' where function_name = "cron_task_generate_report";

No sé si es mejor comentar el 27.sql o que se cree la tabla con todas las columnas adecuadamente.

Buenos días, Jramongv


Como el fallo que estas teniendo es en la estructura de la base de datos lo mejor sera aplicar el siguiente comando que es un  script integrado en Pandora que contiene estos cambios.


Code:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -ppandora -D pandora


Al ser una version Opensource se puede dar el caso de que te aparezca el error "ERROR 1060(42S21) at line 1256: Duplicate column name 'dynamic_next'"

En ese caso y SOLO EN ESE CASO, será necesario que accedas a la base de datos y ejecutes las siguientes consultas para que este error se resuelva:

Code:
ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';

UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;

ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";

ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';

UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');

DELETE FROM twidget WHERE unique_name = 'graph_availability';

ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";

Esto debería solucionar tu problema desapareciendo así el error de la tabla al ejecutar el MR 27.sql 

Un cordial saludo, 

Eduardo. 

Un saludo
Eduardo,

Pues no estoy muy seguro que se haya solucionado el problema, mira he hecho lo siguiente:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -p  -D pandora
Enter password:

y me ha dado el error
ERROR 1060 (42S21) at line 59: Duplicate column name 'dynamic_next'
Entonces siguiendo las instrucciones he entrado en mysql y ejecutado los comandos:

mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9647
Server version: 5.5.40-36.1 Percona Server (GPL), Release 36.1, Revision 707

Copyright © 2009-2014 Percona LLC and/or its affiliates
Copyright © 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use pandora
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ERROR 1060 (42S21): Duplicate column name 'cascade_protection_module'
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null default;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null default '0';
ERROR 1060 (42S21): Duplicate column name 'alias'
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'alias_as_name'
mysql> UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";
Query OK, 0 rows affected, 1 warning (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 1

mysql> ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'alias_as_name'
mysql> ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'snmp_enabled'
mysql> ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'vlan_enabled'
mysql> UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> DELETE FROM twidget WHERE unique_name = 'graph_availability';
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";
ERROR 1146 (42S02): Table 'pandora.tbackup' doesn't exist

Y después he pasado a ejecutar el 27.sql, pero los errores siguen:
mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
ERROR 1060 (42S21): Duplicate column name 'total_time'
ERROR 1060 (42S21): Duplicate column name 'time_failed'
ERROR 1060 (42S21): Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21): Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21): Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21): Duplicate column name 'total_checks'
ERROR 1060 (42S21): Duplicate column name 'checks_failed'
ERROR 1060 (42S21): Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'unknown_checks'
ERROR 1060 (42S21): Duplicate column name 'agent_max_value'
ERROR 1060 (42S21): Duplicate column name 'agent_min_value'
ERROR 1060 (42S21): Duplicate column name 'total_time'
ERROR 1060 (42S21): Duplicate column name 'time_failed'
ERROR 1060 (42S21): Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21): Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21): Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21): Duplicate column name 'total_checks'
ERROR 1060 (42S21): Duplicate column name 'checks_failed'
ERROR 1060 (42S21): Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'unknown_checks'
ERROR 1060 (42S21): Duplicate column name 'agent_max_value'
ERROR 1060 (42S21): Duplicate column name 'agent_min_value'
ERROR 1060 (42S21): Duplicate column name 'type'
ERROR 1060 (42S21): Duplicate column name 'type'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Buenos días Jramongv,

El script de migración de versiones sql que has pasado reconstruye parte de la base de datos en caso de que te falten tablas, como parece que era tu caso. Después de pasar el script es aconsejable pasar todos los MR pero no debería ser tampoco necesario.

Los errores de tablas duplicadas al pasar un MR son comunes si ese MR se había pasado previamente, intenta crear tablas que ya existen y devuelve ese error.

¿Puedes iniciar el servicio de pandora_server sin problema? ¿ves algún error al intentar acceder a la consola? ¿Qué versión de Pandora dice que tienes instalada si ejecutas "pandora_server -v" (sin comillas) en el servidor?

Un saludo

Hola Eduardo,

Si, lo reinicio perfectamente sin problemas, mira:
 /etc/init.d/pandora_server restart
Stopping Pandora FMS Server

Pandora FMS Server 7.0NG.734 Build 190429 Copyright © 2004-2018 Artica ST
This program is OpenSource, licensed under the terms of GPL License version 2.
You can download latest versions and documentation at official web page.

 
[*]Backgrounding Pandora FMS Server process.

Pandora FMS Server is now running with PID 32635
You have new mail in /var/spool/mail/root
[*]La consola va bien mira el adjunto


Attached Files


.jpg   Sin título.jpg (Size: 290.92 KB / Downloads: 3)
 Reply
#20
(05-30-2019, 12:35 PM)Jramongv Wrote:
(05-30-2019, 10:29 AM)jose.almendros Wrote:
(05-29-2019, 06:50 AM)Jramongv Wrote:
(05-24-2019, 11:13 AM)eduardo.corral Wrote:
(05-23-2019, 11:32 AM)Jramongv Wrote: Eduardo,
Al intentar crear la tabla desde mysql da el error:
mysql> create table tuser_task;
ERROR 1113 (42000): A table must have at least 1 column

Está bastante claro, si se crea la tabla se debería crear con las columnas adecuadas, he visto que el 27.sql tiene el siguiente update:

UPDATE tuser_task SET parameters = 'a:5:{i:0;a:6:{s:11:\"description\";s:28:\"Report pending to be created\";s:5:\"table\";s:7:\"treport\";s:8:\"field_id\";s:9:\"id_report\";s:10:\"field_name
\";s:4:\"name\";s:4:\"type\";s:3:\"int\";s:9:\"acl_group\";s:8:\"id_group\";}i:1;a:2:{s:11:\"description\";s:46:\"Send to email addresses (separated by a comma)\";s:4:\"type\";s:4:\"text\";}i
:2;a:2:{s:11:\"description\";s:7:\"Subject\";s:8:\"optional\";i:1;}i:3;a:3:{s:11:\"description\";s:7:\"Message\";s:4:\"type\";s:4:\"text\";s:8:\"optional\";i:1;}i:4;a:2:{s:11:\"description\";
s:11:\"Report Type\";s:4:\"type\";s:11:\"report_type\";}}' where function_name = "cron_task_generate_report";

No sé si es mejor comentar el 27.sql o que se cree la tabla con todas las columnas adecuadamente.

Buenos días, Jramongv


Como el fallo que estas teniendo es en la estructura de la base de datos lo mejor sera aplicar el siguiente comando que es un  script integrado en Pandora que contiene estos cambios.


Code:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -ppandora -D pandora


Al ser una version Opensource se puede dar el caso de que te aparezca el error "ERROR 1060(42S21) at line 1256: Duplicate column name 'dynamic_next'"

En ese caso y SOLO EN ESE CASO, será necesario que accedas a la base de datos y ejecutes las siguientes consultas para que este error se resuelva:

Code:
ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';

UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;

ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";

ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';

UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');

DELETE FROM twidget WHERE unique_name = 'graph_availability';

ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";

Esto debería solucionar tu problema desapareciendo así el error de la tabla al ejecutar el MR 27.sql 

Un cordial saludo, 

Eduardo. 

Un saludo
Eduardo,

Pues no estoy muy seguro que se haya solucionado el problema, mira he hecho lo siguiente:
cat /var/www/html/pandora_console/extras/pandoradb_migrate_6.0_to_7.0.mysql.sql | mysql -uroot -p  -D pandora
Enter password:

y me ha dado el error
ERROR 1060 (42S21) at line 59: Duplicate column name 'dynamic_next'
Entonces siguiendo las instrucciones he entrado en mysql y ejecutado los comandos:

mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9647
Server version: 5.5.40-36.1 Percona Server (GPL), Release 36.1, Revision 707

Copyright © 2009-2014 Percona LLC and/or its affiliates
Copyright © 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use pandora
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN cascade_protection_module int(10) default '0';
ERROR 1060 (42S21): Duplicate column name 'cascade_protection_module'
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null DEFAULT;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null default;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias varchar(600) not null default '0';
ERROR 1060 (42S21): Duplicate column name 'alias'
mysql> ALTER TABLE tmetaconsole_agent ADD COLUMN alias_as_name int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'alias_as_name'
mysql> UPDATE tmetaconsole_agent SET tmetaconsole_agent.alias = tmetaconsole_agent.nombre;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> ALTER TABLE twidget_dashboard MODIFY options LONGTEXT NOT NULL default "";
Query OK, 0 rows affected, 1 warning (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 1

mysql> ALTER TABLE trecon_task ADD alias_as_name int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'alias_as_name'
mysql> ALTER TABLE trecon_task ADD snmp_enabled int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'snmp_enabled'
mysql> ALTER TABLE trecon_task ADD vlan_enabled int(2) unsigned default '0';
ERROR 1060 (42S21): Duplicate column name 'vlan_enabled'
mysql> UPDATE twidget_dashboard SET id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_module_histogram') WHERE id_widget = (SELECT id FROM twidget WHERE unique_name = 'graph_availability');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> DELETE FROM twidget WHERE unique_name = 'graph_availability';
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER TABLE tbackup ADD COLUMN filepath varchar(512) NOT NULL DEFAULT "";
ERROR 1146 (42S02): Table 'pandora.tbackup' doesn't exist

Y después he pasado a ejecutar el 27.sql, pero los errores siguen:
mysql> source /var/www/html/pandora_console/extras/mr/27.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1091 (42000): Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_type'
ERROR 1060 (42S21): Duplicate column name 'ff_normal'
ERROR 1060 (42S21): Duplicate column name 'ff_warning'
ERROR 1060 (42S21): Duplicate column name 'ff_critical'
ERROR 1146 (42S02): Table 'pandora.tuser_task' doesn't exist
ERROR 1060 (42S21): Duplicate column name 'total_time'
ERROR 1060 (42S21): Duplicate column name 'time_failed'
ERROR 1060 (42S21): Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21): Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21): Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21): Duplicate column name 'total_checks'
ERROR 1060 (42S21): Duplicate column name 'checks_failed'
ERROR 1060 (42S21): Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'unknown_checks'
ERROR 1060 (42S21): Duplicate column name 'agent_max_value'
ERROR 1060 (42S21): Duplicate column name 'agent_min_value'
ERROR 1060 (42S21): Duplicate column name 'total_time'
ERROR 1060 (42S21): Duplicate column name 'time_failed'
ERROR 1060 (42S21): Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21): Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21): Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21): Duplicate column name 'total_checks'
ERROR 1060 (42S21): Duplicate column name 'checks_failed'
ERROR 1060 (42S21): Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21): Duplicate column name 'unknown_checks'
ERROR 1060 (42S21): Duplicate column name 'agent_max_value'
ERROR 1060 (42S21): Duplicate column name 'agent_min_value'
ERROR 1060 (42S21): Duplicate column name 'type'
ERROR 1060 (42S21): Duplicate column name 'type'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Buenos días Jramongv,

El script de migración de versiones sql que has pasado reconstruye parte de la base de datos en caso de que te falten tablas, como parece que era tu caso. Después de pasar el script es aconsejable pasar todos los MR pero no debería ser tampoco necesario.

Los errores de tablas duplicadas al pasar un MR son comunes si ese MR se había pasado previamente, intenta crear tablas que ya existen y devuelve ese error.

¿Puedes iniciar el servicio de pandora_server sin problema? ¿ves algún error al intentar acceder a la consola? ¿Qué versión de Pandora dice que tienes instalada si ejecutas "pandora_server -v" (sin comillas) en el servidor?

Un saludo

Hola Eduardo,

Si, lo reinicio perfectamente sin problemas, mira:
 /etc/init.d/pandora_server restart
Stopping Pandora FMS Server

Pandora FMS Server 7.0NG.734 Build 190429 Copyright © 2004-2018 Artica ST
This program is OpenSource, licensed under the terms of GPL License version 2.
You can download latest versions and documentation at official web page.

 
[*]Backgrounding Pandora FMS Server process.

Pandora FMS Server is now running with PID 32635
You have new mail in /var/spool/mail/root
[*]La consola va bien mira el adjunto
[*]

Hola Jramongv,

Parece que está todo correcto, en caso de que falten tablas o esté mal la base de datos hay problemas como que el servicio del server no inicie o que aparezcan mensajes de warning en la parte superior de la consola, y no es tu caso.

En el footer de la consola también debe indicar que estás en la versión 734 (el comando comprueba la versión del servidor), en caso de que sea así yo diría que está todo ok.

Un saludo.
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes