Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Trouble updating from 724 to 735
#11
(07-02-2019, 02:54 PM)eduardo.corral Wrote:
(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.

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


Attached Files


.pdf   forum.pdf (Size: 252.34 KB / Downloads: 1)
 Reply
#12
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
Code:
# 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
Code:
#/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

Code:
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
 Reply
#13
Any ideas?
 Reply
#14
(07-18-2019, 09:43 AM)nmsadmin Wrote: 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.
 Reply
#15
(07-19-2019, 12:36 PM)eduardo.corral Wrote:
(07-18-2019, 09:43 AM)nmsadmin Wrote: 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


Code:
[[email protected] ~]# systemctl restart pandora_server.service
[[email protected] ~]# 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.












Code:
[[email protected] ~]# systemctl restart tentacle_serverd.service
[[email protected] ~]# 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.












Code:
[[email protected] ~]# systemctl restart mariadb.service
[[email protected] ~]# 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.


Attached Files


.txt   pandora_agent.conf.txt (Size: 4.63 KB / Downloads: 0)
.txt   pandora_server.conf.txt (Size: 12.82 KB / Downloads: 0)
 Reply


Users browsing this thread: 2 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