Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Windows database maintenance fail in PandoraFMS Community
#1
Pandora FMS Database Maintenance show fail.


New install in:

Pandora FMS is installed on Windows Server 2016 Standard and Windows Server 2019 Standard 
Version of Pandor FMS: 7.0NG.743_(PC200129) MR35

Manual run:

D:\PandoraFMS\Pandora_Server\bin>pandora_db.exe \PandoraFMS\Pandora_Server\pandora_server.conf
Semicolon seems to be missing at pandora_db.perlapp line 2.
syntax error at pandora_db.perlapp line 2, near "Version:"
Unknown regexp modifier "/k" at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/r" at pandora_db.perlapp line 3, at end of line
Regexp modifiers "/l" and "/a" are mutually exclusive at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 4, at end of line
Regexp modifiers "/a" and "/d" are mutually exclusive at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/r" at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/_" at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 4, at end of line
pandora_db.perlapp has too many errors.

D:\PandoraFMS\Pandora_Server\bin>

OR


D:\PandoraFMS\Pandora_Server>scripts\pandoratool.bat
Semicolon seems to be missing at pandora_db.perlapp line 2.
syntax error at pandora_db.perlapp line 2, near "Version:"
Unknown regexp modifier "/k" at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/r" at pandora_db.perlapp line 3, at end of line
Regexp modifiers "/l" and "/a" are mutually exclusive at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 4, at end of line
Regexp modifiers "/a" and "/d" are mutually exclusive at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/r" at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/_" at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 4, at end of line
pandora_db.perlapp has too many errors.

D:\PandoraFMS\Pandora_Server>


Is there a fix or some manual process or task on the database until the final solution is found?


Thank you
 Reply
#2
Hello rrusterholtz,

I've checked that both executions are working properly. Could you execute the pandora_server.exe located in PandoraFMS\Pandora_Server ? Send us the output of the executable.

Could you also send us your pandora_server.conf?
Greetings
Diego
 Reply
#3
(02-28-2020, 09:17 AM)Diego.M Wrote: Hello rrusterholtz,

I've checked that both executions are working properly. Could you execute the pandora_server.exe located in PandoraFMS\Pandora_Server ? Send us the output of the executable.

Could you also send us your pandora_server.conf?
Greetings
Diego

Hello Diego
When I run pandora_server.exe it generates a popup with the message:
pandora_server.exe has stopped working

A problem cuased the program to stop working correctly.

and the next output:

D:\PandoraFMS\Pandora_Server>pandora_server.exe

Pandora FMS Server 7.0NG.743 Build 200129 Copyright © 2004-2020 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.

I need at least one parameter: Complete path to Pandora FMS Server configuration file

Syntax:

 pandora_server [ options ] < fullpathname to configuration file >

Following options are optional :
        -v        :  Verbose mode activated. Writes more information in the logfile
        -d        :  Debug mode activated. Writes extensive information in the logfile
        -D        :  Daemon mode (runs in background)
        -P <file> :  Store PID to file.
        -q        :  Quiet startup
        -S <install|uninstall|run>:  Manage the win32 service.
        -h        :  This screen. Shows a little help screen

Use of uninitialized value $Config{"servername"} in concatenation (.) or string at pandora_server line 196, <DATA> line 717 during global destruction.
Use of uninitialized value in concatenation (.) or string at pandora_server line 215, <DATA> line 717 during global destruction.
Use of uninitialized value $Config{"servername"} in concatenation (.) or string at pandora_server line 220, <DATA> line 717 during global destruction.
Use of uninitialized value in numeric ge (>=) at /<D:\PandoraFMS\Pandora_Server\pandora_server.exe>PandoraFMS/Tools.pm line 849, <DATA> line 717 during global destruction.
 [E] Unhandled error in "". See more information in logfiles at '/var/log/pandora'

Use of uninitialized value in numeric ge (>=) at /<D:\PandoraFMS\Pandora_Server\pandora_server.exe>PandoraFMS/Tools.pm line 849, <DATA> line 717 during global destruction.
 Error description:

Use of uninitialized value in numeric ge (>=) at /<D:\PandoraFMS\Pandora_Server\pandora_server.exe>PandoraFMS/Tools.pm line 849, <DATA> line 717 during global destruction.
Can't call method "FETCH" on an undefined value at /<D:\PandoraFMS\Pandora_Server\pandora_server.exe>Win32/TieRegistry.pm line 1488, <DATA> line 717 during global destruction.

Use of uninitialized value $Config{"servername"} in concatenation (.) or string at pandora_server line 196, <DATA> line 717 during global destruction.

D:\PandoraFMS\Pandora_Server>

This is the pandora_server.conf:

#############################################################################
# Pandora FMS Server Parameters
# Pandora FMS, the Flexible Monitoring System.
# Version 5.1dev
# Licensed under GPL license v2,
# © 2003-2013 Artica Soluciones Tecnologicas
# http://www.pandorafms.com
# Please change it for your setup needs
#############################################################################

# Servername: Name of this server
# if not given, it takes hostname. It's preferable to setup one
# because machine name could change by some reason.

#servername adama

# daemon: Runs in daemon mode (background) if 1, if 0 runs in foreground 
# this could be also configured on commandline with -D option

# daemon 1

# dbengine: mysql, postgresql or oracle (mysql by default)

dbengine mysql

# Database credentials. A VERY important configuration.
# This must be the same credentials used by your Pandora FMS Console
# but could be different if your console is not running in the same
# host than the server. Check your console setup in /include/config.php

# dbname: Database name (pandora by default)

dbname pandora

# dbuser:  Database user name (pandora by default)

dbuser pandora

# dbpass: Database password

dbpass pandora

# dbhost: Database hostname or IP address

dbhost 127.0.0.1

# dbport: Database port number
# Default value depends on the dbengine (mysql: 3306, postgresql: 5432, oracle: 1521)

#dbport 3306
# By default, parent agent will not update

#update_parent 0

# verbosity: level of detail on errors/messages (0 default, 1 verbose, 2 debug.... 10 noisy)
# -v in command line (verbose) or -d (debug). Set this to 10 when try to locate problems and
# set to 0 or 1 on production enviroments.

verbosity 1

# Master Server, 1 if master server (normal mode), 0 for slave mode (slave in multi-server setup)

master 1

# Activate Pandora SNMP console (depending on snmptrapd)

snmpconsole 0
snmp_trapd manual

# snmptrapd will ignore authenticationFailure traps if set to 1.

snmp_ignore_authfailure 1

# snmptrapd will read the PDU source address instead of the agent-addr field is set to 1.

snmp_pdu_address 0

# Activate (1) Pandora Network Server 

networkserver 1

# Activate (1) Pandora Data Server

dataserver 1

# Activate (1) Pandora FMS Discovery server

discoveryserver 1

# pluginserver : 1 or 0. Set to 1 to activate plugin server with this setup

pluginserver 1

# predictionserver : 1 or 0. Set to 1 to activate prediction server with this setup
# DISABLED BY DEFAULT 

predictionserver 0

# wmiserver : 1 or 0. Set to 1 to activate WMI server with this setup
# DISABLED BY DEFAULT

wmiserver 0

# Network timeout (in seconds) for timeout in network connections for Network agents

network_timeout 5

# Server keepalive (in seconds)

server_keepalive 45

# Server Threshold: defines number of seconds of main loop (in sec)

server_threshold 5

# Network threads: Do not set too high (~40). Each threads make a network module check.

network_threads 3

# icmp_checks x : defines number of pings for each icmp_proc module type. at least one of 
# that ping should be 1 to report 1

icmp_checks 1

# tcp specific options :
# tcp_checks: number of tcp retries if first attempt fails.
# tcp_timeout: specific timeout for tcp connections
# tcp_checks: number of tcp retries if first attempt fails.
# tcp_timeout: specific timeout for tcp connections

tcp_checks 1
tcp_timeout 30

# snmp specific options :
# snmp_checks: number of snmp request retries if first attempt fails.
# snmp_timeout: specific timeout for snmp request.

snmp_checks 1
snmp_timeout 5

# snmp_proc_deadresponse 1 (default): Return DOWN if cannot contact 
# or receive NULL from a SNMP PROC module.

snmp_proc_deadresponse 1

# plugin_threads: Specify number of plugin server threads for processing plugin calls

plugin_threads 1

# plugin_timeout: Specify number of seconds calling plugin exec waiting for response
# after this time, call is aborted and result is "unknown".

plugin_timeout 15

# wmi_timeout : specific timeout for wmi request.

wmi_timeout 10

# wmi_threads: Specify number of WMI server threads for processing WMI remote calls

wmi_threads 1

# discovery_threads. Each thread will scan a different scantask.
discovery_threads 1

# dataserver_threads: Number of threads for data server (XML processing threads)
dataserver_threads 1

# mta_address: External Mailer (MTA) IP Address to be used by Pandora FMS internal email capabilities

mta_address localhost

# mta_port, this is the mail server port (default 25)

mta_port 25

# mta_user MTA User (if needed for auth, FQD or simple user, depending on your server)

#mta_user [email protected]

# mta_pass MTA Pass (if needed for auth)

#mta_pass mypassword

# mta_auth MTA Auth system (if needed, it supports LOGIN, PLAIN, CRAM-MD5, DIGEST-MD)

#mta_auth LOGIN

# mta_from Email address that sends the mail, by default is [email protected] 
#           probably you need to change it to avoid problems with your antispam

mta_from Pandora FMS <[email protected]>

# Set 1 if want eMail deliver alert in separate mail  (default). 
# Set 0 if want eMail deliver shared mail by all destination.
mail_in_separate 1

braa_retries 3

# Default group id for new agents created with Pandora FMS Data Server

autocreate_group 2

# Set to 1 if want to autocreate agents with Pandora FMS Data Server, 
# set to 0 to disable

autocreate 1

# max_log_size: Specify max size of Pandora FMS server log file (1MB by default). If
# log file grows above this limit, is renamed to "pandora_server.log.old".

max_log_size 65536

# max_queue_files (500 by default)
# When server have more than max_queue_files in incoming directory, skips the read   
# the directory to avoid filesystem overhead.

max_queue_files 500

# Use the XML file last modification time as timestamp.

# use_xml_timestamp 1

# Pandora FMS will autorestart itself each XXX seconds, use this if you experience problems with 
# shutting down threads, or other stability problems.

# auto_restart 86400

# Pandora FMS will restart after restart_delay seconds on critical errors.

restart 1
restart_delay 60

# More information about GIS Setup in /usr/share/pandora_server/util/gis.README
# Flag to activate GIS (positional information for agents and maps) 
# by default it is desactivated

#activate_gis 0

# Radius of error in meters to consider two gis locations as the same location.

#location_error 50

# Recon reverse geolocation file. This is the database with the reverse 
# geolocation information using MaxMind GPL GeoLiteCity.dat format).
# Comment it to disable the IP geolocation on agent creation.

#recon_reverse_geolocation_file /usr/local/share/GeoIP/GeoIPCity.dat

# Radius (in meters) of the circle in where the agents will be place randomly 
# when finded by a recon task. Center of the circle is guessed 
# by geolocating the IP.

#recon_location_scatter_radius 1000

# Pandora Server self-monitoring (embedded agent) (by default enabled)

self_monitoring 1

# Pandora Sample Agent. If enabled, every 10 minutes, this embedded agent 
# will make sample data. Disabled by default.

sample_agent 0

# Pandora Sample Agent interval (in seconds).

sample_agent_interval 600

# Update parent from the agent xml

#update_parent 1
#
#
# This enable realtime reverse geocoding using Google Maps public api.
# This requires internet access, and could have performance penalties processing GIS
# information due the connetion needed to resolve all GIS input.
# NOTE: If you dont pay the service to google, they will ban your IP in a few days.

# google_maps_description 1

# This enable realtime reverse geocoding using Openstreet Maps public api.
# This requires internet access, and could have performance penalties processing GIS
# information due the connetion needed to resolve all GIS input.
# This requires internet access, and could have performance penalties processing GIS
# information due the connetion needed to resolve all GIS input.
# You can alter the code to use a local (your own) openstreet maps server.

# openstreetmaps_description 1

# If set to 1, process XML data files in a stack instead of a queue. 0 by default.
# WARNING: Incremental modules will not work properly if dataserver_lifo is set to 1!!!

dataserver_lifo 0

# If set to 1, new events validate older event for the same module. This will

# affect the performance of the server. This was the "normal behaviour" on previous (4.x) versions.
# disable only if you really know what you are doing !!.

event_auto_validation 1

# If defined, events generated by Pandora FMS will be written to the specified text file.
#event_file /var/log/pandora/pandora_events.txt

# Set the maximum number of traps that will be processed from a single source in a
# configured time interval.
#snmp_storm_protection 10

# Time interval for snmp_storm protection (in seconds).
#snmp_storm_timeout 600

# Default texts for some events. The macros _module_ and _data_ are supported.
#text_going_down_normal Module '_module_' is going to NORMAL (_data_)
#text_going_up_critical Module '_module_' is going to CRITICAL (_data_)
#text_going_up_warning Module '_module_' is going to WARNING (_data_)
#text_going_down_warning Module '_module_' is going to WARNING (_data_)
#text_going_unknown Module '_module_' is going to UNKNOWN

# Events older that the specified time (in seconds) will be auto-validated. Set to 0 to disable this feature.
event_expiry_time 0

# Only events more recent than the specified time window (in seconds) will be auto-validated. This value must
# be greater than event_expiry_time.
#event_expiry_window 86400

# Maximum executing time of an alert (in  seconds)
global_alert_timeout 15

# If set to 1 allows PandoraFMS Server to be configured via the web console (Only Enterprise version) 
remote_config 0

# incomingdir:  Defines directory where incoming data packets are stored
# You could set directory relative to base path or absolute, starting with /
incomingdir D:\PandoraFMS\Pandora_Server\data_in

# Temporary directory
temporal D:\PandoraFMS\Pandora_Server\data_out

# log_file: Main logfile for pandora_server You could set file relative to base path or absolute, starting with /
log_file D:\PandoraFMS\Pandora_Server\logs\pandora_server.log

# Log file for Pandora FMS SNMP console. Its generated by NetSNMP Trap daemon
snmp_logfile D:\PandoraFMS\Pandora_Server\logs\pandora_snmptrap.log

# Error logfile: aux logfile for pandora_server errors (in Daemon mode)
errorlog_file D:\PandoraFMS\Pandora_Server\logs\pandora_server.error

# nmap: If provided, is used to detect OS type with recon server using# advanded OS fingerprint technique.
nmap D:\PandoraFMS\Pandora_Server\bin\nmap.exe

# snmpget: Needed to do SNMP checks.
snmpget C:\Windows\snmpget.exe
# fping: Needed to do ICMP Enterprise checks.

fping D:\PandoraFMS\Pandora_Server\bin\fping.exe

# fping: Needed to do ICMP Enterprise checks.
fping D:\PandoraFMS\Pandora_Server\bin\fping.exe

# Location of the braa binary needed by the Enterprise SNMP Server (/usr/bin/braa by default) (PANDORA FMS ENTERPRISE ONLY).

braa D:\PandoraFMS\Pandora_Server\bin\braa.exe
wmi_client "D:\PandoraFMS\Pandora_Server\bin\wmic.exe"

# Pandora FMS Plugin exec tool filepath
plugin_exec D:\PandoraFMS\Pandora_Server\bin\pandora_exec.exe

# Number of retries before braa hands a module over to the Network Server (PANDORA FMS ENTERPRISE ONLY).

braa_retries 3
# Enable (1) or disable (0) Pandora FMS Event Web Server (PANDORA FMS ENTERPRISE ONLY).

webserver 0

# Number of threads for the Web Server (PANDORA FMS ENTERPRISE ONLY).

web_threads 1

# Uncomment to perform web checks with CURL instead of LWP.
#web_engine curl

# Enable (1) or disable (0) Pandora FMS Inventory Server (PANDORA FMS ENTERPRISE ONLY).

inventoryserver 1

# Number of threads for the Web Server (PANDORA FMS ENTERPRISE ONLY).

inventory_threads 1

# Enable (1) or disable (0) Pandora FMS Export Server (PANDORA FMS ENTERPRISE ONLY).

exportserver 0

# Number of threads for the Export Server (PANDORA FMS ENTERPRISE ONLY).

export_threads 1

# Enable (1) or disable (0) Pandora FMS Event Server (PANDORA FMS ENTERPRISE ONLY).

eventserver 0

# Event Server event window in seconds (3600 by default) (PANDORA FMS ENTERPRISE ONLY).

event_window 3600

# Enable (1) or disable (0) Pandora FMS Enterprise ICMP Server (PANDORA FMS ENTERPRISE ONLY).
# You need nmap 5.20 or higher in order to use this !

icmpserver 1

# Number of threads for the Enterprise ICMP Server (PANDORA FMS ENTERPRISE ONLY).

icmp_threads 2

# Enable (1) or disable (0) Pandora FMS Enterprise SNMP Server (PANDORA FMS ENTERPRISE ONLY).
# Check braa tool is running and operative.

snmpserver 1

# Number of threads for the Enterprise SNMP Server (PANDORA FMS ENTERPRISE ONLY).

snmp_threads 2

# Block size for block producer/consumer servers, that is, the number of modules
# per block (15 by default) (PANDORA FMS ENTERPRISE ONLY).

block_size 15

# If set to 1, the policy manager is enabled and the server is listening the policy queue.
# 0 by default (PANDORA FMS ENTERPRISE ONLY)

policy_manager 1

# If set to 1, the event replicate process is enabled. 0 by default. (PANDORA FMS ENTERPRISE ONLY)
# WARNING: This process doesnt do anything if is not properly configured from the console setup

event_replication 0

# console_api_pass: Console password
console_api_pass 1234

# console_pass: Console password
# To make sure console_api_url, console_api_pass, console_user and console_pass are properly configured run:
#   curl '<console_api_url>?op=get&op2=test&apipass=<console_api_pass>&user=<console_user>&pass=<console_pass>'
# It should return a string similar to:
# OK,{VERSION},{BUILD}
console_pass y9DftyFa

# Console User (created for API use)
console_user internal_API

Thanks 

Roberto
 Reply
#4
Hello Roberto,

Try to execute in powershell the following command (place first in C:\PandoraFMS\Pandora_Server\bin).


Code:
.\pandora_db.exe C:\PandoraFMS\Pandora_Server\pandora_server.conf 


I have checked that with that command the pandora_db works correctly. I haven't been able to replicate the exact problem you had, if the problem persists let us know and we will continue investigating

Thank you
Diego
 Reply
#5
(03-02-2020, 10:13 AM)Diego.M Wrote: Hello Roberto,

Try to execute in powershell the following command (place first in C:\PandoraFMS\Pandora_Server\bin).


Code:
.\pandora_db.exe C:\PandoraFMS\Pandora_Server\pandora_server.conf 


I have checked that with that command the pandora_db works correctly. I haven't been able to replicate the exact problem you had, if the problem persists let us know and we will continue investigating

Thank you
Diego

Hello Diego

This is the output :

PS D:\PandoraFMS\Pandora_Server\bin> .\pandora_db.exe D:\PandoraFMS\Pandora_Server\pandora_server.conf
.\pandora_db.exe : Semicolon seems to be missing at pandora_db.perlapp line 2.
At line:1 char:1
+ .\pandora_db.exe D:\PandoraFMS\Pandora_Server\pandora_server.conf
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (Semicolon seems...perlapp line 2.:String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError
 
syntax error at pandora_db.perlapp line 2, near "Version:"
Unknown regexp modifier "/k" at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/r" at pandora_db.perlapp line 3, at end of line
Regexp modifiers "/l" and "/a" are mutually exclusive at pandora_db.perlapp line 3, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 4, at end of line
Regexp modifiers "/a" and "/d" are mutually exclusive at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/r" at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/_" at pandora_db.perlapp line 4, at end of line
Unknown regexp modifier "/e" at pandora_db.perlapp line 4, at end of line
pandora_db.perlapp has too many errors.

PS D:\PandoraFMS\Pandora_Server\bin> 

The task of maintenance in Task Scheduler in windows - PandoraTool show (0x11) in Last Run Result every time.

Thank you

Roberto
 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