Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Trouble updating from 724 to 735
#1
Hello,

I have some issues with updating to latest build 735...

What I did:
  1.     # systemctl stop httpd
  2.     # /etc/init.d/pandora_server stop
  3.     # /etc/init.d/tentacle_serverd stop
  4.     # rpm -qf /etc/yum.repos.d/epel.repo
  5.     # yum remove epel-release
  6.     # yum clean all 
  7.     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
  8.     # yum -y install epel-release
  9.     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
  10.     # yum -y install yum-utils
  11.     # yum update
  12.     # yum-config-manager --enable remi-php70
  13.     # yum remove php-common
  14.     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
  15.     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
  16.     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
  17.     # systemctl start httpd
  18.     # /etc/init.d/pandora_server start
  19.     # /etc/init.d/tentacle_serverd start
  20.     Executed all .sql-Files at ..../extras/mr/

But pandora_server fails to start!

ran these commanders in 1sec interval:

Code:
[[email protected] updated]# /etc/init.d/pandora_server start

Pandora FMS Server 7.0NG.735 Build 190530 Copyright (c) 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 18171
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is running with PID 18171.
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is not running.
[*]


Error log:


Code:
[[email protected] updated]# tail -f /var/log/pandora/pandora_server.error
2019-06-11 15:00:17 - vnms01muc.junese.de Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 5064.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.
Perl exited with active threads:
       57 running and unjoined
       0 finished and unjoined
       0 running and detached


[*]



I really hope someone can help me with this, thanks in advance!

nmsadmin
 Reply
#2
(06-11-2019, 01:07 PM)nmsadmin Wrote: Hello,

I have some issues with updating to latest build 735...

What I did:
  1.     # systemctl stop httpd
  2.     # /etc/init.d/pandora_server stop
  3.     # /etc/init.d/tentacle_serverd stop
  4.     # rpm -qf /etc/yum.repos.d/epel.repo
  5.     # yum remove epel-release
  6.     # yum clean all 
  7.     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
  8.     # yum -y install epel-release
  9.     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
  10.     # yum -y install yum-utils
  11.     # yum update
  12.     # yum-config-manager --enable remi-php70
  13.     # yum remove php-common
  14.     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
  15.     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
  16.     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
  17.     # systemctl start httpd
  18.     # /etc/init.d/pandora_server start
  19.     # /etc/init.d/tentacle_serverd start
  20.     Executed all .sql-Files at ..../extras/mr/

But pandora_server fails to start!

ran these commanders in 1sec interval:

Code:
[[email protected] updated]# /etc/init.d/pandora_server start

Pandora FMS Server 7.0NG.735 Build 190530 Copyright (c) 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 18171
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is running with PID 18171.
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is not running.
[*]


Error log:


Code:
[[email protected] updated]# tail -f /var/log/pandora/pandora_server.error
2019-06-11 15:00:17 - vnms01muc.junese.de Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 5064.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.
Perl exited with active threads:
       57 running and unjoined
       0 finished and unjoined
       0 running and detached




[*]



I really hope someone can help me with this, thanks in advance!

nmsadmin
[*]

Greetings, nmsadmin

Can you tell us which version of MySQL are you running and check the status of MySQL? It would be extremely useful too to know the exact version of php that you have installed. 

One last request. Can you send us, please, your pandora_server.log?

Kind regards, 

Eduardo.
 Reply
#3
(06-12-2019, 09:31 AM)eduardo.corral Wrote:
(06-11-2019, 01:07 PM)nmsadmin Wrote: Hello,

I have some issues with updating to latest build 735...

What I did:
  1.     # systemctl stop httpd
  2.     # /etc/init.d/pandora_server stop
  3.     # /etc/init.d/tentacle_serverd stop
  4.     # rpm -qf /etc/yum.repos.d/epel.repo
  5.     # yum remove epel-release
  6.     # yum clean all 
  7.     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
  8.     # yum -y install epel-release
  9.     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
  10.     # yum -y install yum-utils
  11.     # yum update
  12.     # yum-config-manager --enable remi-php70
  13.     # yum remove php-common
  14.     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
  15.     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
  16.     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
  17.     # systemctl start httpd
  18.     # /etc/init.d/pandora_server start
  19.     # /etc/init.d/tentacle_serverd start
  20.     Executed all .sql-Files at ..../extras/mr/

But pandora_server fails to start!

ran these commanders in 1sec interval:

Code:
[[email protected] updated]# /etc/init.d/pandora_server start

Pandora FMS Server 7.0NG.735 Build 190530 Copyright (c) 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 18171
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is running with PID 18171.
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is not running.
[*]


Error log:


Code:
[[email protected] updated]# tail -f /var/log/pandora/pandora_server.error
2019-06-11 15:00:17 - vnms01muc.junese.de Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 5064.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.
Perl exited with active threads:
       57 running and unjoined
       0 finished and unjoined
       0 running and detached












[*]



I really hope someone can help me with this, thanks in advance!

nmsadmin
[*]

Greetings, nmsadmin

Can you tell us which version of MySQL are you running and check the status of MySQL? It would be extremely useful too to know the exact version of php that you have installed. 

One last request. Can you send us, please, your pandora_server.log?

Kind regards, 

Eduardo.
[*]

Hi Eduardo,

thank you for the reply!

1. 

mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

2. 

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Di 2019-06-11 16:43:19 CEST; 1 day 20h ago
  Process: 5426 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 5193 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 5424 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─5424 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─5874 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql...

Jun 11 16:43:08 vnms01muc.junese.de systemd[1]: Starting MariaDB database se....
Jun 11 16:43:10 vnms01muc.junese.de mariadb-prepare-db-dir[5193]: Database Ma...
Jun 11 16:43:10 vnms01muc.junese.de mariadb-prepare-db-dir[5193]: If this is ...
Jun 11 16:43:11 vnms01muc.junese.de mysqld_safe[5424]: 190611 16:43:11 mysqld...
Jun 11 16:43:12 vnms01muc.junese.de mysqld_safe[5424]: 190611 16:43:12 mysqld...
Jun 11 16:43:19 vnms01muc.junese.de systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.

3.

PHP 7.0.33 (cli) (built: May 28 2019 09:26:45) ( NTS )
Copyright © 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright © 1998-2017 Zend Technologies
    with Zend OPcache v7.0.33, Copyright © 1999-2017, by Zend Technologies


4. i attached a zip containing pandora_server.error and pandora_server.log

.log-files were not allowed as attachement in this reply...


Best regards!

- Tim


Attached Files


.zip   pandora.zip (Size: 1.68 KB / Downloads: 3)
 Reply
#4
(06-13-2019, 11:36 AM)nmsadmin Wrote:
(06-12-2019, 09:31 AM)eduardo.corral Wrote:
(06-11-2019, 01:07 PM)nmsadmin Wrote: Hello,

I have some issues with updating to latest build 735...

What I did:
  1.     # systemctl stop httpd
  2.     # /etc/init.d/pandora_server stop
  3.     # /etc/init.d/tentacle_serverd stop
  4.     # rpm -qf /etc/yum.repos.d/epel.repo
  5.     # yum remove epel-release
  6.     # yum clean all 
  7.     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
  8.     # yum -y install epel-release
  9.     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
  10.     # yum -y install yum-utils
  11.     # yum update
  12.     # yum-config-manager --enable remi-php70
  13.     # yum remove php-common
  14.     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
  15.     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
  16.     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
  17.     # systemctl start httpd
  18.     # /etc/init.d/pandora_server start
  19.     # /etc/init.d/tentacle_serverd start
  20.     Executed all .sql-Files at ..../extras/mr/

But pandora_server fails to start!

ran these commanders in 1sec interval:

Code:
[[email protected] updated]# /etc/init.d/pandora_server start

Pandora FMS Server 7.0NG.735 Build 190530 Copyright (c) 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 18171
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is running with PID 18171.
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is not running.
[*]


Error log:


Code:
[[email protected] updated]# tail -f /var/log/pandora/pandora_server.error
2019-06-11 15:00:17 - vnms01muc.junese.de Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 5064.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.
Perl exited with active threads:
       57 running and unjoined
       0 finished and unjoined
       0 running and detached














[*]



I really hope someone can help me with this, thanks in advance!

nmsadmin
[*]

Greetings, nmsadmin

Can you tell us which version of MySQL are you running and check the status of MySQL? It would be extremely useful too to know the exact version of php that you have installed. 

One last request. Can you send us, please, your pandora_server.log?

Kind regards, 

Eduardo.
[*]

Hi Eduardo,

thank you for the reply!

1. 

mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

2. 

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Di 2019-06-11 16:43:19 CEST; 1 day 20h ago
  Process: 5426 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 5193 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 5424 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─5424 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─5874 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql...

Jun 11 16:43:08 vnms01muc.junese.de systemd[1]: Starting MariaDB database se....
Jun 11 16:43:10 vnms01muc.junese.de mariadb-prepare-db-dir[5193]: Database Ma...
Jun 11 16:43:10 vnms01muc.junese.de mariadb-prepare-db-dir[5193]: If this is ...
Jun 11 16:43:11 vnms01muc.junese.de mysqld_safe[5424]: 190611 16:43:11 mysqld...
Jun 11 16:43:12 vnms01muc.junese.de mysqld_safe[5424]: 190611 16:43:12 mysqld...
Jun 11 16:43:19 vnms01muc.junese.de systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.

3.

PHP 7.0.33 (cli) (built: May 28 2019 09:26:45) ( NTS )
Copyright © 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright © 1998-2017 Zend Technologies
    with Zend OPcache v7.0.33, Copyright © 1999-2017, by Zend Technologies


4. i attached a zip containing pandora_server.error and pandora_server.log

.log-files were not allowed as attachement in this reply...


Best regards!

- Tim
[*]

Greetings, nmsadmin

As I can see, your php version is outdated. You need to update it to version 7.2. 

Can you tell us please which is the last MR found in /extras/mr/ ?

Kind regards, 

Eduardo.
 Reply
#5
(06-14-2019, 11:31 AM)eduardo.corral Wrote:
(06-13-2019, 11:36 AM)nmsadmin Wrote:
(06-12-2019, 09:31 AM)eduardo.corral Wrote:
(06-11-2019, 01:07 PM)nmsadmin Wrote: Hello,

I have some issues with updating to latest build 735...

What I did:
  1.     # systemctl stop httpd
  2.     # /etc/init.d/pandora_server stop
  3.     # /etc/init.d/tentacle_serverd stop
  4.     # rpm -qf /etc/yum.repos.d/epel.repo
  5.     # yum remove epel-release
  6.     # yum clean all 
  7.     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
  8.     # yum -y install epel-release
  9.     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
  10.     # yum -y install yum-utils
  11.     # yum update
  12.     # yum-config-manager --enable remi-php70
  13.     # yum remove php-common
  14.     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
  15.     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
  16.     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
  17.     # systemctl start httpd
  18.     # /etc/init.d/pandora_server start
  19.     # /etc/init.d/tentacle_serverd start
  20.     Executed all .sql-Files at ..../extras/mr/

But pandora_server fails to start!

ran these commanders in 1sec interval:

Code:
[[email protected] updated]# /etc/init.d/pandora_server start

Pandora FMS Server 7.0NG.735 Build 190530 Copyright (c) 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 18171
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is running with PID 18171.
[[email protected] updated]# /etc/init.d/pandora_server status
Pandora FMS Server is not running.
[*]


Error log:


Code:
[[email protected] updated]# tail -f /var/log/pandora/pandora_server.error
2019-06-11 15:00:17 - vnms01muc.junese.de Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 5064.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.
Perl exited with active threads:
       57 running and unjoined
       0 finished and unjoined
       0 running and detached
















[*]



I really hope someone can help me with this, thanks in advance!

nmsadmin
[*]

Greetings, nmsadmin

Can you tell us which version of MySQL are you running and check the status of MySQL? It would be extremely useful too to know the exact version of php that you have installed. 

One last request. Can you send us, please, your pandora_server.log?

Kind regards, 

Eduardo.
[*]

Hi Eduardo,

thank you for the reply!

1. 

mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

2. 

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Di 2019-06-11 16:43:19 CEST; 1 day 20h ago
  Process: 5426 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 5193 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 5424 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─5424 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─5874 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql...

Jun 11 16:43:08 vnms01muc.junese.de systemd[1]: Starting MariaDB database se....
Jun 11 16:43:10 vnms01muc.junese.de mariadb-prepare-db-dir[5193]: Database Ma...
Jun 11 16:43:10 vnms01muc.junese.de mariadb-prepare-db-dir[5193]: If this is ...
Jun 11 16:43:11 vnms01muc.junese.de mysqld_safe[5424]: 190611 16:43:11 mysqld...
Jun 11 16:43:12 vnms01muc.junese.de mysqld_safe[5424]: 190611 16:43:12 mysqld...
Jun 11 16:43:19 vnms01muc.junese.de systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.

3.

PHP 7.0.33 (cli) (built: May 28 2019 09:26:45) ( NTS )
Copyright © 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright © 1998-2017 Zend Technologies
    with Zend OPcache v7.0.33, Copyright © 1999-2017, by Zend Technologies


4. i attached a zip containing pandora_server.error and pandora_server.log

.log-files were not allowed as attachement in this reply...


Best regards!

- Tim
[*]

Greetings, nmsadmin

As I can see, your php version is outdated. You need to update it to version 7.2. 

Can you tell us please which is the last MR found in /extras/mr/ ?

Kind regards, 

Eduardo.
[*]

The sql files are 1.sql - 28.sql. The subfolder "updated" contains only 1.sql.

Upgrading to PHP 7.2 didn't help, same error.

I resored a snapshot, installed php 7.2, applied .rpms and did all the sqls, here the output:

Code:
ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
[[email protected] mr]# mysql -u root -p pandora < 1.sql
Enter password:
ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
[[email protected] mr]# mysql -u root -p pandora < 2.sql
Enter password:
1
1
1
1
[[email protected] mr]# mysql -u root -p pandora < 3.sql
Enter password:
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_password_type'
[[email protected] mr]# mysql -u root -p pandora < 4.sql
Enter password:
ERROR 1060 (42S21) at line 3: Duplicate column name 'autorefresh_white_list'
[[email protected] mr]# mysql -u root -p pandora < 5.sql
Enter password:
1
1
[[email protected] mr]# mysql -u root -p pandora < 6.sql
Enter password:
ERROR 1060 (42S21) at line 13: Duplicate column name 'exec_proxy'
[[email protected] mr]# mysql -u root -p pandora < 7.sql
Enter password:
ERROR 1060 (42S21) at line 3: Duplicate column name 'show_statistics'
[[email protected] mr]# mysql -u root -p pandora < 8.sql
Enter password:
ERROR 1060 (42S21) at line 2: Duplicate column name 'time_autorefresh'
[[email protected] mr]# mysql -u root -p pandora < 9.sql
Enter password:
1
1
ERROR 1060 (42S21) at line 13: Duplicate column name 'safe_mode_module'
[[email protected] mr]# mysql -u root -p pandora < 10.sql
Enter password:
ERROR 1060 (42S21) at line 5: Duplicate column name 'field_order'
[[email protected] mr]# mysql -u root -p pandora < 11.sql
Enter password:
ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
[[email protected] mr]# mysql -u root -p pandora < 12.sql
Enter password:
ERROR 1060 (42S21) at line 5: Duplicate column name 'clock_animation'
[[email protected] mr]# mysql -u root -p pandora < 13.sql
Enter password:
ERROR 1062 (23000) at line 13: Duplicate entry '100' for key 'PRIMARY'
[[email protected] mr]# mysql -u root -p pandora < 14.sql
Enter password:
ERROR 1060 (42S21) at line 40: Duplicate column name 'update_secondary_groups'
[[email protected] mr]# mysql -u root -p pandora < 15.sql
Enter password:
ERROR 1025 (HY000) at line 3: Error on rename of './pandora/tcluster' to './pandora/#sql2-1604-139' (errno: 152)
[[email protected] mr]# mysql -u root -p pandora < 16.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 17.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 18.sql
Enter password:
ERROR 1060 (42S21) at line 3: Duplicate column name 'quiet'
[[email protected] mr]# mysql -u root -p pandora < 19.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 20.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 21.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 22.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 23.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 24.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 25.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 26.sql
Enter password:
[[email protected] mr]# mysql -u root -p pandora < 27.sql
Enter password:
ERROR 1146 (42S02) at line 14: Table 'pandora.tuser_task' doesn't exist
[[email protected] mr]# mysql -u root -p pandora < 28.sql
Enter password:
[[email protected] mr]#
[*]

An the errors are the same:

Code:
[[email protected] mr]# /etc/init.d/pandora_server restart
Pandora FMS Server is not running, cannot stop it.

Pandora FMS Server 7.0NG.735 Build 190530 Copyright (c) 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 29405
[[email protected] mr]# /etc/init.d/pandora_server status
Pandora FMS Server is not running.
[[email protected] mr]# /etc/init.d/pandora_server restart
Pandora FMS Server is not running, cannot stop it.

Pandora FMS Server 7.0NG.735 Build 190530 Copyright (c) 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.

tail -f /var/log/pandora/pandora_server.errorPandora FMS Server is now running with PID 29750
[[email protected] mr]# tail -f /var/log/pandora/pandora_server.error
2019-06-17 17:36:11 - vnms01muc.junese.de Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 5064.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.
Perl exited with active threads:
       57 running and unjoined
       0 finished and unjoined
       0 running and detached
2019-06-17 17:36:32 - vnms01muc.junese.de Starting Pandora FMS Server. Error logging activated.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
DBD::mysql::db do failed: Unknown column 'data' in 'field list' at /usr/lib/perl5/PandoraFMS/DB.pm line 875.
25 at /usr/lib/perl5/PandoraFMS/DB.pm line 885.
Perl exited with active threads:
[*][*]


best, Tim
 Reply
#6
Greetings Tim,

Please try to update your MR following these instructions:   

Code:
cd /var/www/html/pandora_console/extras/MR
for i in ´ls | sort -n;´ do mysql -u <usuario msql> -p<pasword mysql> pandora -e "source $i"; done

The way you were applying the MR may lead to some issues when Pandora FMS finds an error. 

Please, let us know how this works for you. 

Kind regards, 

Eduardo.
 Reply
#7
Any news on this? Does somebody know a solution for this? Any help would be  much appreciated!
 Reply
#8
(06-27-2019, 08:44 AM)nmsadmin Wrote: Any news on this? Does somebody know a solution for this? Any help would be  much appreciated!

Greetings nmsadmin

Have you tried to update the MR the way explained above? 

Kind regards, 

Eduardo.
 Reply
#9
Why are you deleting my and your own posts?!
 Reply
#10
(07-02-2019, 02:16 PM)nmsadmin Wrote: Why are you deleting my and your own posts?!


Greetings nmsadmin

There must be some kind of mistake, because I can see every post in the thread. Please try to go to the first page of the thread to see the initial messages. 

Kind regards, 

Eduardo.
 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