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:PandoraFMSPandora_Serverbin>pandora_db.exe PandoraFMSPandora_Serverpandora_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:PandoraFMSPandora_Serverbin> OR D:PandoraFMSPandora_Server>scriptspandoratool.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:PandoraFMSPandora_Server> Is there a fix or some manual process or task on the database until the final solution is found? Thank you
Windows database maintenance fail in PandoraFMS Community
rrusterholz · 26 feb 2020, 18:00 · 5 mensajes · 96 visitas
- Inicio del debate
Hello rrusterholtz, I've checked that both executions are working properly. Could you execute the pandora_server.exe located in PandoraFMSPandora_Server ? Send us the output of the executable. Could you also send us your pandora_server.conf? Greetings Diego
Hello rrusterholtz, I've checked that both executions are working properly. Could you execute the pandora_server.exe located in PandoraFMSPandora_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:PandoraFMSPandora_Server>pandora_server.exe Pandora FMS Server 7.0NG.743 Build 200129 Copyright (c) 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 ] 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 : Store PID to file. -q : Quiet startup -S : 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, line 717 during global destruction. Use of uninitialized value in concatenation (.) or string at pandora_server line 215, line 717 during global destruction. Use of uninitialized value $Config{"servername"} in concatenation (.) or string at pandora_server line 220, line 717 during global destruction. Use of uninitialized value in numeric ge (>=) at /PandoraFMS/Tools.pm line 849, 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 /PandoraFMS/Tools.pm line 849, line 717 during global destruction. Error description: Use of uninitialized value in numeric ge (>=) at /PandoraFMS/Tools.pm line 849, line 717 during global destruction. Can't call method "FETCH" on an undefined value at /Win32/TieRegistry.pm line 1488, line 717 during global destruction. Use of uninitialized value $Config{"servername"} in concatenation (.) or string at pandora_server line 196, line 717 during global destruction. D:PandoraFMSPandora_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, # (c) 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 pandora@localhost # probably you need to change it to avoid problems with your antispam mta_from Pandora FMS # 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:PandoraFMSPandora_Serverdata_in # Temporary directory temporal D:PandoraFMSPandora_Serverdata_out # log_file: Main logfile for pandora_server You could set file relative to base path or absolute, starting with / log_file D:PandoraFMSPandora_Serverlogspandora_server.log # Log file for Pandora FMS SNMP console. Its generated by NetSNMP Trap daemon snmp_logfile D:PandoraFMSPandora_Serverlogspandora_snmptrap.log # Error logfile: aux logfile for pandora_server errors (in Daemon mode) errorlog_file D:PandoraFMSPandora_Serverlogspandora_server.error # nmap: If provided, is used to detect OS type with recon server using# advanded OS fingerprint technique. nmap D:PandoraFMSPandora_Serverbinnmap.exe # snmpget: Needed to do SNMP checks. snmpget C:Windowssnmpget.exe # fping: Needed to do ICMP Enterprise checks. fping D:PandoraFMSPandora_Serverbinfping.exe # fping: Needed to do ICMP Enterprise checks. fping D:PandoraFMSPandora_Serverbinfping.exe # Location of the braa binary needed by the Enterprise SNMP Server (/usr/bin/braa by default) (PANDORA FMS ENTERPRISE ONLY). braa D:PandoraFMSPandora_Serverbinbraa.exe wmi_client "D:PandoraFMSPandora_Serverbinwmic.exe" # Pandora FMS Plugin exec tool filepath plugin_exec D:PandoraFMSPandora_Serverbinpandora_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 '?op=get&op2=test&apipass=&user=&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
Hello Roberto, Try to execute in powershell the following command (place first in C:PandoraFMSPandora_Serverbin).
.pandora_db.exe C:PandoraFMSPandora_Serverpandora_server.confI 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 Roberto, Try to execute in powershell the following command (place first in C:PandoraFMSPandora_Serverbin).
.pandora_db.exe C:PandoraFMSPandora_Serverpandora_server.confI 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:PandoraFMSPandora_Serverbin> .pandora_db.exe D:PandoraFMSPandora_Serverpandora_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:PandoraFMSPandora_Serverpandora_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:PandoraFMSPandora_Serverbin> The task of maintenance in Task Scheduler in windows - PandoraTool show (0x11) in Last Run Result every time. Thank you Roberto
Entra en tu cuenta para publicar.
