Pandora FMS Community

Trouble updating from 724 to 735

nmsadmin · 11 jun 2019, 17:07 · 17 mensajes · 90 visitas

  1. Inicio del debate

    Hello, I have some issues with updating to latest build 735... What I did: [list=1]-     # systemctl stop httpd

    •     # /etc/init.d/pandora_server stop
    •     # /etc/init.d/tentacle_serverd stop
    •     # rpm -qf /etc/yum.repos.d/epel.repo
    •     # yum remove epel-release
    •     # yum clean all 
    •     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
    •     # yum -y install epel-release
    •     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
    •     # yum -y install yum-utils
    •     # yum update
    •     # yum-config-manager --enable remi-php70
    •     # yum remove php-common
    •     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
    •     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
    •     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
    •     # systemctl start httpd
    •     # /etc/init.d/pandora_server start
    •     # /etc/init.d/tentacle_serverd start
    •     Executed all .sql-Files at ..../extras/mr/
      But pandora_server fails to start! ran these commanders in 1sec interval:
    [root@vnms01muc 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
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is running with PID 18171.
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    

    Error log:

    [root@vnms01muc 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

  2. Hello, I have some issues with updating to latest build 735... What I did: [list=1]-     # systemctl stop httpd

    •     # /etc/init.d/pandora_server stop
    •     # /etc/init.d/tentacle_serverd stop
    •     # rpm -qf /etc/yum.repos.d/epel.repo
    •     # yum remove epel-release
    •     # yum clean all 
    •     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
    •     # yum -y install epel-release
    •     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
    •     # yum -y install yum-utils
    •     # yum update
    •     # yum-config-manager --enable remi-php70
    •     # yum remove php-common
    •     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
    •     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
    •     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
    •     # systemctl start httpd
    •     # /etc/init.d/pandora_server start
    •     # /etc/init.d/tentacle_serverd start
    •     Executed all .sql-Files at ..../extras/mr/
      But pandora_server fails to start! ran these commanders in 1sec interval:
    [root@vnms01muc 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
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is running with PID 18171.
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    

    Error log:

    [root@vnms01muc 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.

  3. Hello, I have some issues with updating to latest build 735... What I did: [list=1]-     # systemctl stop httpd

    •     # /etc/init.d/pandora_server stop
    •     # /etc/init.d/tentacle_serverd stop
    •     # rpm -qf /etc/yum.repos.d/epel.repo
    •     # yum remove epel-release
    •     # yum clean all 
    •     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
    •     # yum -y install epel-release
    •     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
    •     # yum -y install yum-utils
    •     # yum update
    •     # yum-config-manager --enable remi-php70
    •     # yum remove php-common
    •     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
    •     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
    •     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
    •     # systemctl start httpd
    •     # /etc/init.d/pandora_server start
    •     # /etc/init.d/tentacle_serverd start
    •     Executed all .sql-Files at ..../extras/mr/
      But pandora_server fails to start! ran these commanders in 1sec interval:
    [root@vnms01muc 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
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is running with PID 18171.
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    

    Error log:

    [root@vnms01muc 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 (c) 1997-2017 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies     with Zend OPcache v7.0.33, Copyright (c) 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

    pandora.zip

  4. Hello, I have some issues with updating to latest build 735... What I did: [list=1]-     # systemctl stop httpd

    •     # /etc/init.d/pandora_server stop
    •     # /etc/init.d/tentacle_serverd stop
    •     # rpm -qf /etc/yum.repos.d/epel.repo
    •     # yum remove epel-release
    •     # yum clean all 
    •     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
    •     # yum -y install epel-release
    •     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
    •     # yum -y install yum-utils
    •     # yum update
    •     # yum-config-manager --enable remi-php70
    •     # yum remove php-common
    •     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
    •     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
    •     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
    •     # systemctl start httpd
    •     # /etc/init.d/pandora_server start
    •     # /etc/init.d/tentacle_serverd start
    •     Executed all .sql-Files at ..../extras/mr/
      But pandora_server fails to start! ran these commanders in 1sec interval:
    [root@vnms01muc 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
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is running with PID 18171.
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    

    Error log:

    [root@vnms01muc 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 (c) 1997-2017 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies     with Zend OPcache v7.0.33, Copyright (c) 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.

  5. Hello, I have some issues with updating to latest build 735... What I did: [list=1]-     # systemctl stop httpd

    •     # /etc/init.d/pandora_server stop
    •     # /etc/init.d/tentacle_serverd stop
    •     # rpm -qf /etc/yum.repos.d/epel.repo
    •     # yum remove epel-release
    •     # yum clean all 
    •     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
    •     # yum -y install epel-release
    •     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
    •     # yum -y install yum-utils
    •     # yum update
    •     # yum-config-manager --enable remi-php70
    •     # yum remove php-common
    •     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
    •     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
    •     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
    •     # systemctl start httpd
    •     # /etc/init.d/pandora_server start
    •     # /etc/init.d/tentacle_serverd start
    •     Executed all .sql-Files at ..../extras/mr/
      But pandora_server fails to start! ran these commanders in 1sec interval:
    [root@vnms01muc 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
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is running with PID 18171.
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    

    Error log:

    [root@vnms01muc 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 (c) 1997-2017 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies     with Zend OPcache v7.0.33, Copyright (c) 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:

    ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
    [root@vnms01muc mr]# mysql -u root -p pandora < 1.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
    [root@vnms01muc mr]# mysql -u root -p pandora < 2.sql
    Enter password:
    1
    1
    1
    1
    [root@vnms01muc mr]# mysql -u root -p pandora < 3.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'is_password_type'
    [root@vnms01muc mr]# mysql -u root -p pandora < 4.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'autorefresh_white_list'
    [root@vnms01muc mr]# mysql -u root -p pandora < 5.sql
    Enter password:
    1
    1
    [root@vnms01muc mr]# mysql -u root -p pandora < 6.sql
    Enter password:
    ERROR 1060 (42S21) at line 13: Duplicate column name 'exec_proxy'
    [root@vnms01muc mr]# mysql -u root -p pandora < 7.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'show_statistics'
    [root@vnms01muc mr]# mysql -u root -p pandora < 8.sql
    Enter password:
    ERROR 1060 (42S21) at line 2: Duplicate column name 'time_autorefresh'
    [root@vnms01muc mr]# mysql -u root -p pandora < 9.sql
    Enter password:
    1
    1
    ERROR 1060 (42S21) at line 13: Duplicate column name 'safe_mode_module'
    [root@vnms01muc mr]# mysql -u root -p pandora < 10.sql
    Enter password:
    ERROR 1060 (42S21) at line 5: Duplicate column name 'field_order'
    [root@vnms01muc mr]# mysql -u root -p pandora < 11.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
    [root@vnms01muc mr]# mysql -u root -p pandora < 12.sql
    Enter password:
    ERROR 1060 (42S21) at line 5: Duplicate column name 'clock_animation'
    [root@vnms01muc mr]# mysql -u root -p pandora < 13.sql
    Enter password:
    ERROR 1062 (23000) at line 13: Duplicate entry '100' for key 'PRIMARY'
    [root@vnms01muc mr]# mysql -u root -p pandora < 14.sql
    Enter password:
    ERROR 1060 (42S21) at line 40: Duplicate column name 'update_secondary_groups'
    [root@vnms01muc 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)
    [root@vnms01muc mr]# mysql -u root -p pandora < 16.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 17.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 18.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'quiet'
    [root@vnms01muc mr]# mysql -u root -p pandora < 19.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 20.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 21.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 22.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 23.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 24.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 25.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 26.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 27.sql
    Enter password:
    ERROR 1146 (42S02) at line 14: Table 'pandora.tuser_task' doesn't exist
    [root@vnms01muc mr]# mysql -u root -p pandora < 28.sql
    Enter password:
    [root@vnms01muc mr]#
    

    An the errors are the same:

    [root@vnms01muc 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
    [root@vnms01muc mr]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    [root@vnms01muc 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
    [root@vnms01muc 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
  6. Hello, I have some issues with updating to latest build 735... What I did: [list=1]-     # systemctl stop httpd

    •     # /etc/init.d/pandora_server stop
    •     # /etc/init.d/tentacle_serverd stop
    •     # rpm -qf /etc/yum.repos.d/epel.repo
    •     # yum remove epel-release
    •     # yum clean all 
    •     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
    •     # yum -y install epel-release
    •     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
    •     # yum -y install yum-utils
    •     # yum update
    •     # yum-config-manager --enable remi-php70
    •     # yum remove php-common
    •     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
    •     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
    •     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
    •     # systemctl start httpd
    •     # /etc/init.d/pandora_server start
    •     # /etc/init.d/tentacle_serverd start
    •     Executed all .sql-Files at ..../extras/mr/
      But pandora_server fails to start! ran these commanders in 1sec interval:
    [root@vnms01muc 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
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is running with PID 18171.
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    

    Error log:

    [root@vnms01muc 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 (c) 1997-2017 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies     with Zend OPcache v7.0.33, Copyright (c) 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:

    ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
    [root@vnms01muc mr]# mysql -u root -p pandora < 1.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
    [root@vnms01muc mr]# mysql -u root -p pandora < 2.sql
    Enter password:
    1
    1
    1
    1
    [root@vnms01muc mr]# mysql -u root -p pandora < 3.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'is_password_type'
    [root@vnms01muc mr]# mysql -u root -p pandora < 4.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'autorefresh_white_list'
    [root@vnms01muc mr]# mysql -u root -p pandora < 5.sql
    Enter password:
    1
    1
    [root@vnms01muc mr]# mysql -u root -p pandora < 6.sql
    Enter password:
    ERROR 1060 (42S21) at line 13: Duplicate column name 'exec_proxy'
    [root@vnms01muc mr]# mysql -u root -p pandora < 7.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'show_statistics'
    [root@vnms01muc mr]# mysql -u root -p pandora < 8.sql
    Enter password:
    ERROR 1060 (42S21) at line 2: Duplicate column name 'time_autorefresh'
    [root@vnms01muc mr]# mysql -u root -p pandora < 9.sql
    Enter password:
    1
    1
    ERROR 1060 (42S21) at line 13: Duplicate column name 'safe_mode_module'
    [root@vnms01muc mr]# mysql -u root -p pandora < 10.sql
    Enter password:
    ERROR 1060 (42S21) at line 5: Duplicate column name 'field_order'
    [root@vnms01muc mr]# mysql -u root -p pandora < 11.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
    [root@vnms01muc mr]# mysql -u root -p pandora < 12.sql
    Enter password:
    ERROR 1060 (42S21) at line 5: Duplicate column name 'clock_animation'
    [root@vnms01muc mr]# mysql -u root -p pandora < 13.sql
    Enter password:
    ERROR 1062 (23000) at line 13: Duplicate entry '100' for key 'PRIMARY'
    [root@vnms01muc mr]# mysql -u root -p pandora < 14.sql
    Enter password:
    ERROR 1060 (42S21) at line 40: Duplicate column name 'update_secondary_groups'
    [root@vnms01muc 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)
    [root@vnms01muc mr]# mysql -u root -p pandora < 16.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 17.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 18.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'quiet'
    [root@vnms01muc mr]# mysql -u root -p pandora < 19.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 20.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 21.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 22.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 23.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 24.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 25.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 26.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 27.sql
    Enter password:
    ERROR 1146 (42S02) at line 14: Table 'pandora.tuser_task' doesn't exist
    [root@vnms01muc mr]# mysql -u root -p pandora < 28.sql
    Enter password:
    [root@vnms01muc mr]#
    

    An the errors are the same:

    [root@vnms01muc 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
    [root@vnms01muc mr]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    [root@vnms01muc 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
    [root@vnms01muc 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

  7. Hello, I have some issues with updating to latest build 735... What I did: [list=1]-     # systemctl stop httpd

    •     # /etc/init.d/pandora_server stop
    •     # /etc/init.d/tentacle_serverd stop
    •     # rpm -qf /etc/yum.repos.d/epel.repo
    •     # yum remove epel-release
    •     # yum clean all 
    •     # rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
    •     # yum -y install epel-release
    •     # rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
    •     # yum -y install yum-utils
    •     # yum update
    •     # yum-config-manager --enable remi-php70
    •     # yum remove php-common
    •     # yum -y install php php-opcache php-gd php-ldap php-snmp php-mysqlnd php-mbstring php-zip php-pecl-zip perl-Geo-IP
    •     # rpm -U --force pandorafms_server-7.0NG.735-1.noarch.rpm
    •     # rpm -U --force pandorafms_console-7.0NG.735-1.noarch.rpm
    •     # systemctl start httpd
    •     # /etc/init.d/pandora_server start
    •     # /etc/init.d/tentacle_serverd start
    •     Executed all .sql-Files at ..../extras/mr/
      But pandora_server fails to start! ran these commanders in 1sec interval:
    [root@vnms01muc 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
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is running with PID 18171.
    [root@vnms01muc updated]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    

    Error log:

    [root@vnms01muc 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 (c) 1997-2017 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies     with Zend OPcache v7.0.33, Copyright (c) 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:

    ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
    [root@vnms01muc mr]# mysql -u root -p pandora < 1.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'default_event_filter'
    [root@vnms01muc mr]# mysql -u root -p pandora < 2.sql
    Enter password:
    1
    1
    1
    1
    [root@vnms01muc mr]# mysql -u root -p pandora < 3.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'is_password_type'
    [root@vnms01muc mr]# mysql -u root -p pandora < 4.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'autorefresh_white_list'
    [root@vnms01muc mr]# mysql -u root -p pandora < 5.sql
    Enter password:
    1
    1
    [root@vnms01muc mr]# mysql -u root -p pandora < 6.sql
    Enter password:
    ERROR 1060 (42S21) at line 13: Duplicate column name 'exec_proxy'
    [root@vnms01muc mr]# mysql -u root -p pandora < 7.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'show_statistics'
    [root@vnms01muc mr]# mysql -u root -p pandora < 8.sql
    Enter password:
    ERROR 1060 (42S21) at line 2: Duplicate column name 'time_autorefresh'
    [root@vnms01muc mr]# mysql -u root -p pandora < 9.sql
    Enter password:
    1
    1
    ERROR 1060 (42S21) at line 13: Duplicate column name 'safe_mode_module'
    [root@vnms01muc mr]# mysql -u root -p pandora < 10.sql
    Enter password:
    ERROR 1060 (42S21) at line 5: Duplicate column name 'field_order'
    [root@vnms01muc mr]# mysql -u root -p pandora < 11.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'is_favourite'
    [root@vnms01muc mr]# mysql -u root -p pandora < 12.sql
    Enter password:
    ERROR 1060 (42S21) at line 5: Duplicate column name 'clock_animation'
    [root@vnms01muc mr]# mysql -u root -p pandora < 13.sql
    Enter password:
    ERROR 1062 (23000) at line 13: Duplicate entry '100' for key 'PRIMARY'
    [root@vnms01muc mr]# mysql -u root -p pandora < 14.sql
    Enter password:
    ERROR 1060 (42S21) at line 40: Duplicate column name 'update_secondary_groups'
    [root@vnms01muc 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)
    [root@vnms01muc mr]# mysql -u root -p pandora < 16.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 17.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 18.sql
    Enter password:
    ERROR 1060 (42S21) at line 3: Duplicate column name 'quiet'
    [root@vnms01muc mr]# mysql -u root -p pandora < 19.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 20.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 21.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 22.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 23.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 24.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 25.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 26.sql
    Enter password:
    [root@vnms01muc mr]# mysql -u root -p pandora < 27.sql
    Enter password:
    ERROR 1146 (42S02) at line 14: Table 'pandora.tuser_task' doesn't exist
    [root@vnms01muc mr]# mysql -u root -p pandora < 28.sql
    Enter password:
    [root@vnms01muc mr]#
    

    An the errors are the same:

    [root@vnms01muc 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
    [root@vnms01muc mr]# /etc/init.d/pandora_server status
    Pandora FMS Server is not running.
    [root@vnms01muc 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
    [root@vnms01muc 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

  8. Greetings Tim, Please try to update your MR following these instructions:   

    cd /var/www/html/pandora_console/extras/MR
    for i in ´ls | sort -n;´ do mysql -u  -p 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.

  9. Any news on this? Does somebody know a solution for this? Any help would be  much appreciated!

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

  11. Why are you deleting my and your own posts?!

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

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

    Hi Eduardo, Sorry for the wrong accusation... turns out there must be some bug with the forums engine! When logged in as nmsadmin, I can see posts #1 -5 on the first page and then two deleted entries, then posts #11 -12 on the second site, which are the #9 and #10 in reality (see forum.pdf attached). Tested on newest Firefox and Chrome, tried clearing cache as well. I will make a new upgrade attempt with the info you provided today and will post the results!  Best, Tim

    forum.pdf

  14. Hi, I have done a new approach from scratch, with your latest instructions: 1.# systemctl stop httpd 2.# /etc/init.d/pandora_server stop 3.# /etc/init.d/tentacle_serverd stop 4.# nano /etc/yum.repos.d/maria10-3.repo

    # MariaDB 10.3 CentOS repository list - created 2018-11-19 23:14 UTC
    # http://downloads.mariadb.org/mariadb/repositories/
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.3/centos7-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    

    5.# yum -y upgrade maria* 6.# systemctl restart mariadb 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-php72 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_console-7.0NG.736-1.noarch.rpm 16.# rpm -U --force pandorafms_server-7.0NG.736-1.noarch.rpm 17.# systemctl start httpd 18.# /etc/init.d/pandora_server start 19.# /etc/init.d/tentacle_serverd start 20.# cd /var/www/html/pandora_console/extras/mr 21.# nano run.sh

    #/bin/bash
    for i in `ls | sort -n;`
    do
    mysql -u root -pPASSWORD pandora -e "source $i"
    done
    

    22.# chmod +x run.sh 23.# ./run.sh

    WHAT FAILED:
    
    ERROR 1364 (HY000) at line 28 in file: '1.sql': Field 'description' doesn't have a default value
    
    
    
    ERROR 1406 (22001) at line 10 in file: '8.sql': Data too long for column 'description' at row 1
    
    
    
    ERROR 1064 (42000) at line 50 in file: '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: '14.sql': Unknown prepared statement handler (pr_oum721) given to EXECUTE
    ERROR 1243 (HY000) at line 52 in file: '14.sql': Unknown prepared statement handler (pr_oum721) given to DEALLOCATE PREPARE
    
    
    
    ERROR 1091 (42000) at line 3 in file: '15.sql': Can't DROP FOREIGN KEY `tcluster_ibfk_1`; check that it exists                  
    ERROR 1091 (42000) at line 7 in file: '15.sql': Can't DROP FOREIGN KEY `tcluster_agent_ibfk_2`; check that it exists
    
    
    
    ERROR 1146 (42S02) at line 14 in file: '27.sql': Table 'pandora.tuser_task' doesn't exist
    

    But now the service pandora_server starts and keeps running! However, no agents are able to connect to the server, no data is incoming. From pandora error log on startup: DBD::mysql::db do failed: Incorrect double value: '' for column `pandora`.`tevento`.`data` at row 1 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 think the perl issue is the main problem but I have no idea what's causing it. Best regards, Tim

  15. Any ideas?

  16. Any ideas?

    Greetings, nmsadmin Please check the status of MySQL to see if it's up.  Try to restart the server and send us if you can the configuration files from both the agent and the server.  Kind regards,  Eduardo.

  17. Any ideas?

    Greetings, nmsadmin Please check the status of MySQL to see if it's up.  Try to restart the server and send us if you can the configuration files from both the agent and the server.  Kind regards,  Eduardo. Hi Eduardo, here are the services and their status. conf files are attached. Thanks for your help, greetings, tim

    [root@vnms01muc ~]# systemctl restart pandora_server.service
    [root@vnms01muc ~]# systemctl status pandora_server.service
    ● pandora_server.service - LSB: Pandora FMS Server startup script
       Loaded: loaded (/etc/rc.d/init.d/pandora_server; bad; vendor preset: disabled)
       Active: active (running) since Mo 2019-07-22 16:35:01 CEST; 5s ago
         Docs: man:systemd-sysv-generator(8)
      Process: 28497 ExecStop=/etc/rc.d/init.d/pandora_server stop (code=exited, status=0/SUCCESS)
      Process: 28506 ExecStart=/etc/rc.d/init.d/pandora_server start (code=exited, status=0/SUCCESS)
       CGroup: /system.slice/pandora_server.service
               ├─28535 /usr/sbin/snmptrapd -t -On -n -a -Lf /var/log/pandora/pandora_snmptrap.log -p /var/run/pandora_snmptrapd.pid --format1=SNMPv1[**]%4y...
               └─28541 /usr/bin/nfcapd -D -T all -w -t 3600 -P /var/run/pandora_nfcapd.pid -l /var/spool/pandora/data_in/netflow
    
    Jul 22 16:34:59 vnms01muc.junese.de systemd[1]: Starting LSB: Pandora FMS Server startup script...
    Jul 22 16:35:00 vnms01muc.junese.de pandora_server[28506]: Pandora FMS Server 7.0NG.736 Build 190627 Copyright (c) 2004-2018 Artica ST
    Jul 22 16:35:00 vnms01muc.junese.de pandora_server[28506]: This program is OpenSource, licensed under the terms of GPL License version 2.
    Jul 22 16:35:00 vnms01muc.junese.de pandora_server[28506]: You can download latest versions and documentation at official web page.
    Jul 22 16:35:00 vnms01muc.junese.de pandora_server[28506]:  Backgrounding Pandora FMS Server process.
    
    Jul 22 16:35:00 vnms01muc.junese.de nfcapd[28541]: Startup.
    Jul 22 16:35:00 vnms01muc.junese.de nfcapd[28541]: Init IPFIX: Max number of IPFIX tags: 65
    Jul 22 16:35:01 vnms01muc.junese.de pandora_server[28506]: Pandora FMS Server is now running with PID 28519
    Jul 22 16:35:01 vnms01muc.junese.de systemd[1]: Started LSB: Pandora FMS Server startup script.
    
    [root@vnms01muc ~]# systemctl restart tentacle_serverd.service
    [root@vnms01muc ~]# systemctl status tentacle_serverd.service
    ● tentacle_serverd.service - LSB: Tentacle Server startup script
       Loaded: loaded (/etc/rc.d/init.d/tentacle_serverd; bad; vendor preset: disabled)
       Active: active (exited) since Mo 2019-07-22 16:35:33 CEST; 6s ago
         Docs: man:systemd-sysv-generator(8)
      Process: 28733 ExecStop=/etc/rc.d/init.d/tentacle_serverd stop (code=exited, status=0/SUCCESS)
      Process: 28753 ExecStart=/etc/rc.d/init.d/tentacle_serverd start (code=exited, status=0/SUCCESS)
    
    Jul 22 16:35:32 vnms01muc.junese.de systemd[1]: Starting LSB: Tentacle Server startup script...
    Jul 22 16:35:32 vnms01muc.junese.de sudo[28762]:     root : TTY=unknown ; PWD=/ ; USER=pandora ; COMMAND=/usr/bin/tentacle_server -F /etc/tenta...ver.conf
    Jul 22 16:35:33 vnms01muc.junese.de tentacle_serverd[28753]: Tentacle Server is now running with PID 28764
    Jul 22 16:35:33 vnms01muc.junese.de systemd[1]: Started LSB: Tentacle Server startup script.
    Hint: Some lines were ellipsized, use -l to show in full.
    
    [root@vnms01muc ~]# systemctl restart mariadb.service
    [root@vnms01muc ~]# systemctl status mariadb.service
    ● mariadb.service - MariaDB 10.3.16 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf
       Active: active (running) since Mo 2019-07-22 16:36:29 CEST; 11min ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
      Process: 28890 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
      Process: 28831 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
      Process: 28829 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
     Main PID: 28858 (mysqld)
       Status: "Taking your SQL requests now..."
       CGroup: /system.slice/mariadb.service
               └─28858 /usr/sbin/mysqld
    
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: 2019-07-22 16:36:29 0 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: 2019-07-22 16:36:29 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have typ...REATE','POST
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: 2019-07-22 16:36:29 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: 2019-07-22 16:36:29 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gti...oesn't exist
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: 2019-07-22 16:36:29 0 [Note] Reading of all Master_info entries succeeded
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: 2019-07-22 16:36:29 0 [Note] Added new Master_info '' to hash table
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: 2019-07-22 16:36:29 0 [Note] /usr/sbin/mysqld: ready for connections.
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: Version: '10.3.16-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
    Jul 22 16:36:29 vnms01muc.junese.de mysqld[28858]: 2019-07-22 16:36:29 0 [Note] InnoDB: Buffer pool(s) load completed at 190722 16:36:29
    Jul 22 16:36:29 vnms01muc.junese.de systemd[1]: Started MariaDB 10.3.16 database server.
    Hint: Some lines were ellipsized, use -l to show in full.
    

    pandora_agent.conf.txt

    pandora_server.conf.txt

Entra en tu cuenta para publicar.