Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem Registering Instance In Update Manager
#1
Details:
OS = RHEL 7.5
mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1


Hello,

I recently performed a fresh install of Pandora FMS v7.0NG.730. I was having problems registering the instance so I thought I might fix it by manually upgrading to version v7.0NG.731.  

However, I still see the warnings along with MR's available - 

.png   20190213_Pandora_Warnings.PNG (Size: 27.3 KB / Downloads: 9)


I've searched this forum up and down, but I didn't find a solution. 

I have confirmed that this directory is owned by apache:
Code:
# pwd
/var/www/html
# ll
drwxr-xr-x 14 apache apache 4096 Jan 18 01:25 pandora_console


I also tried to apply the MR's, but I am getting errors as seen here:

Code:
[[email protected] mr]# cat 1.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
[[email protected] mr]# cat 2.sql | mysql -uroot -p pandora
1
1
1
1
[[email protected] mr]# cat 3.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_password_type'
[[email protected] mr]# cat 4.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'autorefresh_white_list'
[[email protected] mr]# cat 5.sql | mysql -uroot -p pandora
1
1
[[email protected] mr]# cat 6.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 13: Duplicate column name 'exec_proxy'
[[email protected] mr]# cat 7.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'show_statistics'
[[email protected] mr]# cat 8.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 2: Duplicate column name 'time_autorefresh'
[[email protected] mr]# cat 9.sql | mysql -uroot -p pandora
1
1
ERROR 1060 (42S21) at line 13: Duplicate column name 'safe_mode_module'
[[email protected] mr]# cat 10.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'unified_filters_id'
[[email protected] mr]# cat 11.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# cat 12.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'type_graph'
[[email protected] mr]# cat 13.sql | mysql -uroot -p pandora
ERROR 1062 (23000) at line 13: Duplicate entry '100' for key 'PRIMARY'
[[email protected] mr]# cat 14.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 40: Duplicate column name 'update_secondary_groups'
[[email protected] mr]# cat 15.sql | mysql -uroot -p pandora
ERROR 1025 (HY000) at line 3: Error on rename of './pandora/tcluster' to './pandora/#sql2-1808-131' (errno: 152)
[[email protected] mr]# cat 16.sql | mysql -uroot -p pandora
[[email protected] mr]# cat 17.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 15: Duplicate column name 'custom_fields'
[[email protected] mr]# cat 18.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'quiet'
[[email protected] mr]# cat 19.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 59: Duplicate column name 'no_hierarchy'
[[email protected] mr]# cat 20.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'recursion'
[[email protected] mr]# cat 21.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# cat 22.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'id_group'
[[email protected] mr]# cat 23.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'group_search'



Any thoughts on how I can proceed to troubleshoot this?

Thanks for the help!
 Reply
#2
(02-13-2019, 11:01 PM)Justin Wrote: Details:
OS = RHEL 7.5
mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1


Hello,

I recently performed a fresh install of Pandora FMS v7.0NG.730. I was having problems registering the instance so I thought I might fix it by manually upgrading to version v7.0NG.731.  

However, I still see the warnings along with MR's available - 



I've searched this forum up and down, but I didn't find a solution. 

I have confirmed that this directory is owned by apache:
Code:
# pwd
/var/www/html
# ll
drwxr-xr-x 14 apache apache 4096 Jan 18 01:25 pandora_console


I also tried to apply the MR's, but I am getting errors as seen here:

Code:
[[email protected] mr]# cat 1.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
[[email protected] mr]# cat 2.sql | mysql -uroot -p pandora
1
1
1
1
[[email protected] mr]# cat 3.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_password_type'
[[email protected] mr]# cat 4.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'autorefresh_white_list'
[[email protected] mr]# cat 5.sql | mysql -uroot -p pandora
1
1
[[email protected] mr]# cat 6.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 13: Duplicate column name 'exec_proxy'
[[email protected] mr]# cat 7.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'show_statistics'
[[email protected] mr]# cat 8.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 2: Duplicate column name 'time_autorefresh'
[[email protected] mr]# cat 9.sql | mysql -uroot -p pandora
1
1
ERROR 1060 (42S21) at line 13: Duplicate column name 'safe_mode_module'
[[email protected] mr]# cat 10.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'unified_filters_id'
[[email protected] mr]# cat 11.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# cat 12.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'type_graph'
[[email protected] mr]# cat 13.sql | mysql -uroot -p pandora
ERROR 1062 (23000) at line 13: Duplicate entry '100' for key 'PRIMARY'
[[email protected] mr]# cat 14.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 40: Duplicate column name 'update_secondary_groups'
[[email protected] mr]# cat 15.sql | mysql -uroot -p pandora
ERROR 1025 (HY000) at line 3: Error on rename of './pandora/tcluster' to './pandora/#sql2-1808-131' (errno: 152)
[[email protected] mr]# cat 16.sql | mysql -uroot -p pandora
[[email protected] mr]# cat 17.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 15: Duplicate column name 'custom_fields'
[[email protected] mr]# cat 18.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'quiet'
[[email protected] mr]# cat 19.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 59: Duplicate column name 'no_hierarchy'
[[email protected] mr]# cat 20.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'recursion'
[[email protected] mr]# cat 21.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# cat 22.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'id_group'
[[email protected] mr]# cat 23.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'group_search'



Any thoughts on how I can proceed to troubleshoot this?

Thanks for the help!

Good morning Justin,

Try to update the MR on this way:

mysql> use pandora;
mysql> source /var/www/html/pandora_console/extras/mr/X.sql
where X is the MR number.

The error of duplicate column name usually means the MR is already installed.

Anyway, try to configure the update manager to update the console online.

Regards
 Reply
#3
(02-14-2019, 12:15 PM)jose.almendros Wrote:
(02-13-2019, 11:01 PM)Justin Wrote: Details:
OS = RHEL 7.5
mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1


Hello,

I recently performed a fresh install of Pandora FMS v7.0NG.730. I was having problems registering the instance so I thought I might fix it by manually upgrading to version v7.0NG.731.  

However, I still see the warnings along with MR's available - 



I've searched this forum up and down, but I didn't find a solution. 

I have confirmed that this directory is owned by apache:
Code:
# pwd
/var/www/html
# ll
drwxr-xr-x 14 apache apache 4096 Jan 18 01:25 pandora_console


I also tried to apply the MR's, but I am getting errors as seen here:

Code:
[[email protected] mr]# cat 1.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
[[email protected] mr]# cat 2.sql | mysql -uroot -p pandora
1
1
1
1
[[email protected] mr]# cat 3.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_password_type'
[[email protected] mr]# cat 4.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'autorefresh_white_list'
[[email protected] mr]# cat 5.sql | mysql -uroot -p pandora
1
1
[[email protected] mr]# cat 6.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 13: Duplicate column name 'exec_proxy'
[[email protected] mr]# cat 7.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'show_statistics'
[[email protected] mr]# cat 8.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 2: Duplicate column name 'time_autorefresh'
[[email protected] mr]# cat 9.sql | mysql -uroot -p pandora
1
1
ERROR 1060 (42S21) at line 13: Duplicate column name 'safe_mode_module'
[[email protected] mr]# cat 10.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'unified_filters_id'
[[email protected] mr]# cat 11.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# cat 12.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'type_graph'
[[email protected] mr]# cat 13.sql | mysql -uroot -p pandora
ERROR 1062 (23000) at line 13: Duplicate entry '100' for key 'PRIMARY'
[[email protected] mr]# cat 14.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 40: Duplicate column name 'update_secondary_groups'
[[email protected] mr]# cat 15.sql | mysql -uroot -p pandora
ERROR 1025 (HY000) at line 3: Error on rename of './pandora/tcluster' to './pandora/#sql2-1808-131' (errno: 152)
[[email protected] mr]# cat 16.sql | mysql -uroot -p pandora
[[email protected] mr]# cat 17.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 15: Duplicate column name 'custom_fields'
[[email protected] mr]# cat 18.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'quiet'
[[email protected] mr]# cat 19.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 59: Duplicate column name 'no_hierarchy'
[[email protected] mr]# cat 20.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'recursion'
[[email protected] mr]# cat 21.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# cat 22.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'id_group'
[[email protected] mr]# cat 23.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'group_search'



Any thoughts on how I can proceed to troubleshoot this?

Thanks for the help!

Good morning Justin,

Try to update the MR on this way:

mysql> use pandora;
mysql> source /var/www/html/pandora_console/extras/mr/X.sql
where X is the MR number.

The error of duplicate column name usually means the MR is already installed.

Anyway, try to configure the update manager to update the console online.

Regards


Thanks for the suggestion Jose, but I don't think it worked... 

I still have the same registration warning and I get this error when registering - 

.png   20190213_Pandora_Reg_fail.PNG (Size: 18.82 KB / Downloads: 7)

It would appear that I got the same results while trying to apply the MR's using your method - 
Code:
[[email protected] mr]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 383
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> 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
MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/1.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/1.sql': Duplicate column name 'default_event_filter'
Query OK, 0 rows affected, 1 warning (0.00 sec)

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

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

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 1 row affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/2.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/3.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/3.sql': Duplicate column name 'is_password_type'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/4.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/4.sql': Duplicate column name 'autorefresh_white_list'
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/5.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

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

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/6.sql
Query OK, 0 rows affected (0.00 sec)

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

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/6.sql': Duplicate column name 'exec_proxy'
ERROR 1060 (42S21) at line 15 in file: '/var/www/html/pandora_console/extras/mr/6.sql': Duplicate column name 'server_to_exec'
ERROR 1062 (23000) at line 17 in file: '/var/www/html/pandora_console/extras/mr/6.sql': Duplicate entry '8' for key 'PRIMARY'
ERROR 1062 (23000) at line 19 in file: '/var/www/html/pandora_console/extras/mr/6.sql': Duplicate entry '25' for key 'PRIMARY'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/7.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/7.sql': Duplicate column name 'show_statistics'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/8.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 2 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'time_autorefresh'
ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'lapse_calc'
ERROR 1060 (42S21) at line 4 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'lapse'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'visual_format'
ERROR 1060 (42S21) at line 6 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'lapse_calc'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'lapse'
ERROR 1060 (42S21) at line 8 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'visual_format'
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)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/9.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'safe_mode_module'
ERROR 1060 (42S21) at line 14 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'safe_mode_module'
ERROR 1060 (42S21) at line 16 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'element_group'
ERROR 1060 (42S21) at line 18 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'id_layout_linked_weight'
ERROR 1060 (42S21) at line 20 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'show_on_top'
ERROR 1060 (42S21) at line 22 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'cells_slideshow'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/10.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'unified_filters_id'
ERROR 1060 (42S21) at line 4 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'hide_no_data'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'field_order'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

ERROR 1060 (42S21) at line 8 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'summatory_series'
ERROR 1060 (42S21) at line 9 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'average_series'
ERROR 1060 (42S21) at line 10 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'modules_series'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/11.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'is_favourite'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)

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

ERROR 1060 (42S21) at line 10 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'fullscale'
ERROR 1060 (42S21) at line 12 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'fullscale'
ERROR 1060 (42S21) at line 14 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'hide_no_data'
ERROR 1060 (42S21) at line 16 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'last_unknown_update'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/12.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/12.sql': Duplicate column name 'type_graph'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/12.sql': Duplicate column name 'clock_animation'
ERROR 1060 (42S21) at line 6 in file: '/var/www/html/pandora_console/extras/mr/12.sql': Duplicate column name 'time_format'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/12.sql': Duplicate column name 'timezone'
Query OK, 0 rows affected, 3 warnings (0.00 sec)

Query OK, 0 rows affected, 2 warnings (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/13.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

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

Query OK, 0 rows affected (0.00 sec)

ERROR 1062 (23000) at line 13 in file: '/var/www/html/pandora_console/extras/mr/13.sql': Duplicate entry '100' for key 'PRIMARY'
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 3 warnings (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/14.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1060 (42S21) at line 40 in file: '/var/www/html/pandora_console/extras/mr/14.sql': Duplicate column name 'update_secondary_groups'
ERROR 1060 (42S21) at line 41 in file: '/var/www/html/pandora_console/extras/mr/14.sql': Duplicate column name 'update_secondary_groups'
Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

ERROR 1064 (42000) at line 50 in file: '/var/www/html/pandora_console/extras/mr/14.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0' at line 1
ERROR 1243 (HY000) at line 51 in file: '/var/www/html/pandora_console/extras/mr/14.sql': Unknown prepared statement handler (pr_oum721) given to EXECUTE
ERROR 1243 (HY000) at line 52 in file: '/var/www/html/pandora_console/extras/mr/14.sql': Unknown prepared statement handler (pr_oum721) given to DEALLOCATE PREPARE
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/15.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1025 (HY000) at line 3 in file: '/var/www/html/pandora_console/extras/mr/15.sql': Error on rename of './pandora/tcluster' to './pandora/#sql2-1808-17f' (errno: 152)
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1025 (HY000) at line 7 in file: '/var/www/html/pandora_console/extras/mr/15.sql': Error on rename of './pandora/tcluster_agent' to './pandora/#sql2-1808-17f' (errno: 152)
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/16.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

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

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/17.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1060 (42S21) at line 15 in file: '/var/www/html/pandora_console/extras/mr/17.sql': Duplicate column name 'custom_fields'
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/18.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'quiet'
ERROR 1060 (42S21) at line 4 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cascade_protection'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 9 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 11 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'evaluate_sla'
ERROR 1060 (42S21) at line 15 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21) at line 19 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'id_node'
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21) at line 23 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 25 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 27 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 29 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 31 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 33 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'module_status'
ERROR 1050 (42S01) at line 35 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Table 'tautoconfig' already exists
ERROR 1050 (42S01) at line 44 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Table 'tautoconfig_rules' already exists
ERROR 1050 (42S01) at line 58 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Table 'tautoconfig_actions' already exists
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/19.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1060 (42S21) at line 59 in file: '/var/www/html/pandora_console/extras/mr/19.sql': Duplicate column name 'no_hierarchy'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

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

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/20.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'recursion'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'user_comment'
ERROR 1060 (42S21) at line 6 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'source'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'id_extra'
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21) at line 12 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_type'
ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_as_service_warning'
ERROR 1060 (42S21) at line 14 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_as_service_critical'
ERROR 1060 (42S21) at line 15 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_node_id'
ERROR 1060 (42S21) at line 16 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_type'
ERROR 1060 (42S21) at line 17 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_as_service_warning'
ERROR 1060 (42S21) at line 18 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_as_service_critical'
ERROR 1060 (42S21) at line 19 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_node_id'
ERROR 1060 (42S21) at line 25 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'hidden'
ERROR 1060 (42S21) at line 27 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_version'
ERROR 1060 (42S21) at line 28 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_auth_user'
ERROR 1060 (42S21) at line 29 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_auth_pass'
ERROR 1060 (42S21) at line 30 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_auth_method'
ERROR 1060 (42S21) at line 31 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_privacy_method'
ERROR 1060 (42S21) at line 32 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_privacy_pass'
ERROR 1060 (42S21) at line 33 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_security_level'
ERROR 1060 (42S21) at line 34 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'custom_fields'
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1062 (23000) at line 45 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate entry '1' for key 'PRIMARY'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/21.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'is_favourite'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

ERROR 1060 (42S21) at line 6 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'show_last_value'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'show_last_value'
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21) at line 10 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbuser'
ERROR 1060 (42S21) at line 11 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbpass'
ERROR 1060 (42S21) at line 12 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbhost'
ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbport'
ERROR 1060 (42S21) at line 14 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbname'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/22.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/22.sql': Duplicate column name 'id_group'
ERROR 1091 (42000) at line 5 in file: '/var/www/html/pandora_console/extras/mr/22.sql': Can't DROP 'flash_chart'; check that column/key exists
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/22.sql': Duplicate column name 'default_custom_view'
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/23.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/23.sql': Duplicate column name 'group_search'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/23.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/23.sql': Duplicate column name 'recursion'
ERROR 1060 (42S21) at line 9 in file: '/var/www/html/pandora_console/extras/mr/23.sql': Duplicate column name 'group_recursion'
Query OK, 0 rows affected (0.00 sec)


Anything else I can check?  Any logs I should be tailing when I try to do this?  Would it help to put Pandora into Debug mode and attempt this?

Thanks!
Justin
 Reply
#4
(02-14-2019, 12:28 PM)Justin Wrote:
(02-14-2019, 12:15 PM)jose.almendros Wrote:
(02-13-2019, 11:01 PM)Justin Wrote: Details:
OS = RHEL 7.5
mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1


Hello,

I recently performed a fresh install of Pandora FMS v7.0NG.730. I was having problems registering the instance so I thought I might fix it by manually upgrading to version v7.0NG.731.  

However, I still see the warnings along with MR's available - 



I've searched this forum up and down, but I didn't find a solution. 

I have confirmed that this directory is owned by apache:
Code:
# pwd
/var/www/html
# ll
drwxr-xr-x 14 apache apache 4096 Jan 18 01:25 pandora_console


I also tried to apply the MR's, but I am getting errors as seen here:

Code:
[[email protected] mr]# cat 1.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
[[email protected] mr]# cat 2.sql | mysql -uroot -p pandora
1
1
1
1
[[email protected] mr]# cat 3.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_password_type'
[[email protected] mr]# cat 4.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'autorefresh_white_list'
[[email protected] mr]# cat 5.sql | mysql -uroot -p pandora
1
1
[[email protected] mr]# cat 6.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 13: Duplicate column name 'exec_proxy'
[[email protected] mr]# cat 7.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'show_statistics'
[[email protected] mr]# cat 8.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 2: Duplicate column name 'time_autorefresh'
[[email protected] mr]# cat 9.sql | mysql -uroot -p pandora
1
1
ERROR 1060 (42S21) at line 13: Duplicate column name 'safe_mode_module'
[[email protected] mr]# cat 10.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'unified_filters_id'
[[email protected] mr]# cat 11.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# cat 12.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'type_graph'
[[email protected] mr]# cat 13.sql | mysql -uroot -p pandora
ERROR 1062 (23000) at line 13: Duplicate entry '100' for key 'PRIMARY'
[[email protected] mr]# cat 14.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 40: Duplicate column name 'update_secondary_groups'
[[email protected] mr]# cat 15.sql | mysql -uroot -p pandora
ERROR 1025 (HY000) at line 3: Error on rename of './pandora/tcluster' to './pandora/#sql2-1808-131' (errno: 152)
[[email protected] mr]# cat 16.sql | mysql -uroot -p pandora
[[email protected] mr]# cat 17.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 15: Duplicate column name 'custom_fields'
[[email protected] mr]# cat 18.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'quiet'
[[email protected] mr]# cat 19.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 59: Duplicate column name 'no_hierarchy'
[[email protected] mr]# cat 20.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'recursion'
[[email protected] mr]# cat 21.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# cat 22.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'id_group'
[[email protected] mr]# cat 23.sql | mysql -uroot -p pandora
ERROR 1060 (42S21) at line 3: Duplicate column name 'group_search'



Any thoughts on how I can proceed to troubleshoot this?

Thanks for the help!

Good morning Justin,

Try to update the MR on this way:

mysql> use pandora;
mysql> source /var/www/html/pandora_console/extras/mr/X.sql
where X is the MR number.

The error of duplicate column name usually means the MR is already installed.

Anyway, try to configure the update manager to update the console online.

Regards


Thanks for the suggestion Jose, but I don't think it worked... 

I still have the same registration warning and I get this error when registering - 


It would appear that I got the same results while trying to apply the MR's using your method - 
Code:
[[email protected] mr]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 383
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> 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
MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/1.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/1.sql': Duplicate column name 'default_event_filter'
Query OK, 0 rows affected, 1 warning (0.00 sec)

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

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

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 1 row affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/2.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/3.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/3.sql': Duplicate column name 'is_password_type'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/4.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/4.sql': Duplicate column name 'autorefresh_white_list'
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/5.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

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

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/6.sql
Query OK, 0 rows affected (0.00 sec)

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

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/6.sql': Duplicate column name 'exec_proxy'
ERROR 1060 (42S21) at line 15 in file: '/var/www/html/pandora_console/extras/mr/6.sql': Duplicate column name 'server_to_exec'
ERROR 1062 (23000) at line 17 in file: '/var/www/html/pandora_console/extras/mr/6.sql': Duplicate entry '8' for key 'PRIMARY'
ERROR 1062 (23000) at line 19 in file: '/var/www/html/pandora_console/extras/mr/6.sql': Duplicate entry '25' for key 'PRIMARY'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/7.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/7.sql': Duplicate column name 'show_statistics'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/8.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 2 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'time_autorefresh'
ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'lapse_calc'
ERROR 1060 (42S21) at line 4 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'lapse'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'visual_format'
ERROR 1060 (42S21) at line 6 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'lapse_calc'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'lapse'
ERROR 1060 (42S21) at line 8 in file: '/var/www/html/pandora_console/extras/mr/8.sql': Duplicate column name 'visual_format'
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)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/9.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'safe_mode_module'
ERROR 1060 (42S21) at line 14 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'safe_mode_module'
ERROR 1060 (42S21) at line 16 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'element_group'
ERROR 1060 (42S21) at line 18 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'id_layout_linked_weight'
ERROR 1060 (42S21) at line 20 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'show_on_top'
ERROR 1060 (42S21) at line 22 in file: '/var/www/html/pandora_console/extras/mr/9.sql': Duplicate column name 'cells_slideshow'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/10.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'unified_filters_id'
ERROR 1060 (42S21) at line 4 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'hide_no_data'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'field_order'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

ERROR 1060 (42S21) at line 8 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'summatory_series'
ERROR 1060 (42S21) at line 9 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'average_series'
ERROR 1060 (42S21) at line 10 in file: '/var/www/html/pandora_console/extras/mr/10.sql': Duplicate column name 'modules_series'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/11.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'is_favourite'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

Query OK, 1 row affected (0.00 sec)

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

ERROR 1060 (42S21) at line 10 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'fullscale'
ERROR 1060 (42S21) at line 12 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'fullscale'
ERROR 1060 (42S21) at line 14 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'hide_no_data'
ERROR 1060 (42S21) at line 16 in file: '/var/www/html/pandora_console/extras/mr/11.sql': Duplicate column name 'last_unknown_update'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/12.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/12.sql': Duplicate column name 'type_graph'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/12.sql': Duplicate column name 'clock_animation'
ERROR 1060 (42S21) at line 6 in file: '/var/www/html/pandora_console/extras/mr/12.sql': Duplicate column name 'time_format'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/12.sql': Duplicate column name 'timezone'
Query OK, 0 rows affected, 3 warnings (0.00 sec)

Query OK, 0 rows affected, 2 warnings (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/13.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

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

Query OK, 0 rows affected (0.00 sec)

ERROR 1062 (23000) at line 13 in file: '/var/www/html/pandora_console/extras/mr/13.sql': Duplicate entry '100' for key 'PRIMARY'
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 3 warnings (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/14.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1060 (42S21) at line 40 in file: '/var/www/html/pandora_console/extras/mr/14.sql': Duplicate column name 'update_secondary_groups'
ERROR 1060 (42S21) at line 41 in file: '/var/www/html/pandora_console/extras/mr/14.sql': Duplicate column name 'update_secondary_groups'
Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

ERROR 1064 (42000) at line 50 in file: '/var/www/html/pandora_console/extras/mr/14.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0' at line 1
ERROR 1243 (HY000) at line 51 in file: '/var/www/html/pandora_console/extras/mr/14.sql': Unknown prepared statement handler (pr_oum721) given to EXECUTE
ERROR 1243 (HY000) at line 52 in file: '/var/www/html/pandora_console/extras/mr/14.sql': Unknown prepared statement handler (pr_oum721) given to DEALLOCATE PREPARE
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/15.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1025 (HY000) at line 3 in file: '/var/www/html/pandora_console/extras/mr/15.sql': Error on rename of './pandora/tcluster' to './pandora/#sql2-1808-17f' (errno: 152)
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1025 (HY000) at line 7 in file: '/var/www/html/pandora_console/extras/mr/15.sql': Error on rename of './pandora/tcluster_agent' to './pandora/#sql2-1808-17f' (errno: 152)
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/16.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

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

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/17.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1060 (42S21) at line 15 in file: '/var/www/html/pandora_console/extras/mr/17.sql': Duplicate column name 'custom_fields'
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/18.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'quiet'
ERROR 1060 (42S21) at line 4 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cascade_protection'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 9 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 11 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'evaluate_sla'
ERROR 1060 (42S21) at line 15 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'cps'
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21) at line 19 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'id_node'
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21) at line 23 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 25 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 27 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 29 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 31 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 33 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Duplicate column name 'module_status'
ERROR 1050 (42S01) at line 35 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Table 'tautoconfig' already exists
ERROR 1050 (42S01) at line 44 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Table 'tautoconfig_rules' already exists
ERROR 1050 (42S01) at line 58 in file: '/var/www/html/pandora_console/extras/mr/18.sql': Table 'tautoconfig_actions' already exists
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/19.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1060 (42S21) at line 59 in file: '/var/www/html/pandora_console/extras/mr/19.sql': Duplicate column name 'no_hierarchy'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

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

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/20.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'recursion'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'user_comment'
ERROR 1060 (42S21) at line 6 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'source'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'id_extra'
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21) at line 12 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_type'
ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_as_service_warning'
ERROR 1060 (42S21) at line 14 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_as_service_critical'
ERROR 1060 (42S21) at line 15 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_node_id'
ERROR 1060 (42S21) at line 16 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_type'
ERROR 1060 (42S21) at line 17 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_as_service_warning'
ERROR 1060 (42S21) at line 18 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_status_as_service_critical'
ERROR 1060 (42S21) at line 19 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'linked_layout_node_id'
ERROR 1060 (42S21) at line 25 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'hidden'
ERROR 1060 (42S21) at line 27 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_version'
ERROR 1060 (42S21) at line 28 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_auth_user'
ERROR 1060 (42S21) at line 29 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_auth_pass'
ERROR 1060 (42S21) at line 30 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_auth_method'
ERROR 1060 (42S21) at line 31 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_privacy_method'
ERROR 1060 (42S21) at line 32 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_privacy_pass'
ERROR 1060 (42S21) at line 33 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'snmp_security_level'
ERROR 1060 (42S21) at line 34 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate column name 'custom_fields'
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1062 (23000) at line 45 in file: '/var/www/html/pandora_console/extras/mr/20.sql': Duplicate entry '1' for key 'PRIMARY'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/21.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'is_favourite'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

ERROR 1060 (42S21) at line 6 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'show_last_value'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'show_last_value'
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1060 (42S21) at line 10 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbuser'
ERROR 1060 (42S21) at line 11 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbpass'
ERROR 1060 (42S21) at line 12 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbhost'
ERROR 1060 (42S21) at line 13 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbport'
ERROR 1060 (42S21) at line 14 in file: '/var/www/html/pandora_console/extras/mr/21.sql': Duplicate column name 'meta_dbname'
Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/22.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/22.sql': Duplicate column name 'id_group'
ERROR 1091 (42000) at line 5 in file: '/var/www/html/pandora_console/extras/mr/22.sql': Can't DROP 'flash_chart'; check that column/key exists
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/22.sql': Duplicate column name 'default_custom_view'
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [pandora]> source /var/www/html/pandora_console/extras/mr/23.sql
Query OK, 0 rows affected (0.00 sec)

ERROR 1060 (42S21) at line 3 in file: '/var/www/html/pandora_console/extras/mr/23.sql': Duplicate column name 'group_search'
ERROR 1060 (42S21) at line 5 in file: '/var/www/html/pandora_console/extras/mr/23.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 7 in file: '/var/www/html/pandora_console/extras/mr/23.sql': Duplicate column name 'recursion'
ERROR 1060 (42S21) at line 9 in file: '/var/www/html/pandora_console/extras/mr/23.sql': Duplicate column name 'group_recursion'
Query OK, 0 rows affected (0.00 sec)


Anything else I can check?  Any logs I should be tailing when I try to do this?  Would it help to put Pandora into Debug mode and attempt this?

Thanks!
Justin


Hello Justin,

Sorry, I didn't realised the last MR you passed was 23.sql.

In v731, the last MR available is 24.sql. Try to pass that MR and tell me if the warning disappear.

Regards
 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