Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can't start docker image #180

Open
esanchezm opened this issue Jun 15, 2021 · 1 comment
Open

Can't start docker image #180

esanchezm opened this issue Jun 15, 2021 · 1 comment

Comments

@esanchezm
Copy link
Contributor

What's up Sancho and company? 馃槃 Hope you don't mind I'm writing in English 馃槤 I hope you and your family is good after all this strange year with COVID 馃檹

First of all, a friend just sent me some news about you winning a public contract, so congratulations 馃コ 馃嵕

Then, I found some video explaining how to run Pandora with Docker so I said "why not?". I'm really curious about how the product has evolved in these years. I have to be honest that the experience is not the best and I'm having issues. I already have a MySQL container (actualy a MariaDB), so I decided to reuse it. I created the pandora user and database and run the pandorafms-open-stack-el8. I see it start installing pandora and the database but I'm getting these logs:

DBD::mysql::db do failed: Incorrect integer value: '' for column `pandora`.`tevento`.`module_status` at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 1071.

 [E] Unhandled error in "pandora01". See more information in logfiles at '/var/log/pandora' 

 Error description:

DBI::db=HASH(0x5578d62a98b8), id_evento, INSERT INTO tevento (id_agente, id_grupo, evento, timestamp, estado, utimestamp, event_type, id_agentmodule, id_alert_am, criticity, user_comment, tags, source, id_extra, id_usuario, critical_instructions, warning_instructions, unknown_instructions, ack_utimestamp, custom_data, data, module_status)
                VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), 0, 0, Warmup mode for unknown modules started., 2021-06-15 19:24:38, 0, 1623777878.5649, system, 0, 0, 0, , , monitoring_server, , , , , , 0, , ,  at /usr/lib/perl5/PandoraFMS/Core.pm line 3654.

I don't know how to move on, I guess the issue is that I'm using MariaDB and not MySQL or your suggested percona image, but who know 馃槃

Full logs here:

pandora_1               | ==> /var/log/pandora/pandora_server.log <==
pandora_1               | 2021-06-15 19:24:35 pandora01 [V1] Launching 7.0NG.754 210430
pandora_1               | 2021-06-15 19:24:35 pandora01 [V1] Config options: Logfile at /var/log/pandora/pandora_server.log, Basepath is /etc/pandora/pandora_server.conf, Checksum is 0, Master is 1, SNMP Console is 0, Server Threshold at 5 sec, verbosity at 3, Alert Threshold at 60, ServerName is 'pandora01'
pandora_1               | 2021-06-15 19:24:35 pandora01 [V1]  [*] Pandora FMS Enterprise module not available.
pandora_1               | 2021-06-15 19:24:35 pandora_server: pandora01 [V1]  [*] Netflow daemon disabled.
pandora_1               | 2021-06-15 19:24:35,636 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Starting Pandora FMS Network Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:35,872 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Starting Pandora FMS Discovery Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:35,998 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Starting Pandora FMS WMI Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:36,084 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Starting Pandora FMS Plugin Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:36,084 INFO success: pandora_server entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
pandora_1               | 2021-06-15 19:24:36,170 DEBG 'pandora_server' stdout output:
pandora_1               |  [E] Unhandled error in "pandora01". See more information in logfiles at '/var/log/pandora' 
pandora_1               | 
pandora_1               |  Error description:
pandora_1               | 
pandora_1               | DBD::mysql::db do failed: Incorrect integer value: '' for column `pandora`.`tevento`.`module_status` at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 1071.
pandora_1               | 
pandora_1               |  [E] Unhandled error in "pandora01". See more information in logfiles at '/var/log/pandora' 
pandora_1               | 
pandora_1               |  Error description:
pandora_1               | 
pandora_1               | DBI::db=HASH(0x55e5b4a5a468), id_evento, INSERT INTO tevento (id_agente, id_grupo, evento, timestamp, estado, utimestamp, event_type, id_agentmodule, id_alert_am, criticity, user_comment, tags, source, id_extra, id_usuario, critical_instructions, warning_instructions, unknown_instructions, ack_utimestamp, custom_data, data, module_status)
pandora_1               | 	              VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), 0, 0, Warmup&#x20;mode&#x20;for&#x20;unknown&#x20;modules&#x20;started., 2021-06-15 19:24:36, 0, 1623777876.1686, system, 0, 0, 0, , , monitoring_server, , , , , , 0, , ,  at /usr/lib/perl5/PandoraFMS/Core.pm line 3654.
pandora_1               | 
pandora_1               | 
pandora_1               | 2021-06-15 19:24:36,200 DEBG fd 20 closed, stopped monitoring <POutputDispatcher at 140529020188824 for <Subprocess at 140529020581256 with name pandora_server in state RUNNING> (stdout)>
pandora_1               | 2021-06-15 19:24:36,200 INFO exited: pandora_server (exit status 25; not expected)
pandora_1               | 2021-06-15 19:24:36,200 DEBG received SIGCHLD indicating a child quit
pandora_1               | 
pandora_1               | ==> /var/log/pandora/pandora_server.error <==
pandora_1               | Use of uninitialized value $is_meta in numeric eq (==) at /usr/lib/perl5/PandoraFMS/DB.pm line 243.
pandora_1               | DBD::mysql::db do failed: Incorrect integer value: '' for column `pandora`.`tevento`.`module_status` at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 1071.
pandora_1               | DBI::db=HASH(0x55e5b4a5a468), id_evento, INSERT INTO tevento (id_agente, id_grupo, evento, timestamp, estado, utimestamp, event_type, id_agentmodule, id_alert_am, criticity, user_comment, tags, source, id_extra, id_usuario, critical_instructions, warning_instructions, unknown_instructions, ack_utimestamp, custom_data, data, module_status)
pandora_1               | 	              VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), 0, 0, Warmup&#x20;mode&#x20;for&#x20;unknown&#x20;modules&#x20;started., 2021-06-15 19:24:36, 0, 1623777876.1686, system, 0, 0, 0, , , monitoring_server, , , , , , 0, , ,  at /usr/lib/perl5/PandoraFMS/Core.pm line 3654.
pandora_1               | Perl exited with active threads:
pandora_1               | 	15 running and unjoined
pandora_1               | 	0 finished and unjoined
pandora_1               | 	0 running and detached
pandora_1               | 
pandora_1               | ==> /var/log/pandora/pandora_server.log <==
pandora_1               | 2021-06-15 19:24:36 pandora01 [V3] Warmup mode for unknown modules started.
pandora_1               | 2021-06-15 19:24:36 DB: pandora01 [V1] [E] 'pandora01': DBD::mysql::db do failed: Incorrect integer value: '' for column `pandora`.`tevento`.`module_status` at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 1071.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:36 DB: pandora01 [V1] Pandora FMS Server 'pandora01' unhandled error.
pandora_1               | 2021-06-15 19:24:36 DB: pandora01 [V1] [E] 'pandora01': DBI::db=HASH(0x55e5b4a5a468), id_evento, INSERT INTO tevento (id_agente, id_grupo, evento, timestamp, estado, utimestamp, event_type, id_agentmodule, id_alert_am, criticity, user_comment, tags, source, id_extra, id_usuario, critical_instructions, warning_instructions, unknown_instructions, ack_utimestamp, custom_data, data, module_status)
pandora_1               | 	              VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), 0, 0, Warmup mode for unknown modules started., 2021-06-15 19:24:36, 0, 1623777876.1686, system, 0, 0, 0, , , monitoring_server, , , , , , 0, , ,  at /usr/lib/perl5/PandoraFMS/Core.pm line 3654.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:36 DB: pandora01 [V1] Pandora FMS Server 'pandora01' unhandled error.
pandora_1               | 2021-06-15 19:24:37,204 INFO spawned: 'pandora_server' with pid 694
pandora_1               | 2021-06-15 19:24:37,216 DEBG 'pandora_server' stderr output:
pandora_1               | perl: warning: Setting locale failed.
pandora_1               | perl: warning: Please check that your locale settings:
pandora_1               | 	LANGUAGE = (unset),
pandora_1               | 	LC_ALL = (unset),
pandora_1               | 	LC_CTYPE = "C.UTF-8",
pandora_1               | 	LANG = "en_US.UTF-8"
pandora_1               |     are supported and installed on your system.
pandora_1               | perl: warning: Falling back to the standard locale ("C").
pandora_1               | 
pandora_1               | 2021-06-15 19:24:37,349 DEBG 'pandora_server' stderr output:
pandora_1               | perl: warning: Setting locale failed.
pandora_1               | perl: warning: Please check that your locale settings:
pandora_1               | 	LANGUAGE = (unset),
pandora_1               | 	LC_ALL = (unset),
pandora_1               | 	LC_CTYPE = "C.UTF-8",
pandora_1               | 	LANG = "en_US.UTF-8"
pandora_1               |     are supported and installed on your system.
pandora_1               | perl: warning: Falling back to the standard locale ("C").
pandora_1               | 
pandora_1               | 2021-06-15 19:24:37,719 DEBG 'pandora_server' stdout output:
pandora_1               | 
pandora_1               | Pandora FMS Server 7.0NG.754 Build 210430 Copyright (c) 2004-2021 Artica ST
pandora_1               | This program is OpenSource, licensed under the terms of GPL License version 2.
pandora_1               | You can download latest versions and documentation at official web page.
pandora_1               | 
pandora_1               | 
pandora_1               | 2021-06-15 19:24:37,730 DEBG fd 24 closed, stopped monitoring <POutputDispatcher at 140529020282808 for <Subprocess at 140529020581256 with name pandora_server in state STARTING> (stderr)>
pandora_1               | 2021-06-15 19:24:37,745 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Pandora FMS Enterprise module not available.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:37,819 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Netflow daemon disabled.
pandora_1               |  [*] Starting Pandora FMS Data Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:37,931 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Starting Pandora FMS Network Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:38,211 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Starting Pandora FMS Discovery Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:38,211 INFO success: pandora_server entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
pandora_1               | 2021-06-15 19:24:38,363 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Starting Pandora FMS WMI Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:38,467 DEBG 'pandora_server' stdout output:
pandora_1               |  [*] Starting Pandora FMS Plugin Server.
pandora_1               | 
pandora_1               | 2021-06-15 19:24:38,566 DEBG 'pandora_server' stdout output:
pandora_1               |  [E] Unhandled error in "pandora01". See more information in logfiles at '/var/log/pandora' 
pandora_1               | 
pandora_1               |  Error description:
pandora_1               | 
pandora_1               | DBD::mysql::db do failed: Incorrect integer value: '' for column `pandora`.`tevento`.`module_status` at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 1071.
pandora_1               | 
pandora_1               |  [E] Unhandled error in "pandora01". See more information in logfiles at '/var/log/pandora' 
pandora_1               | 
pandora_1               |  Error description:
pandora_1               | 
pandora_1               | DBI::db=HASH(0x5578d62a98b8), id_evento, INSERT INTO tevento (id_agente, id_grupo, evento, timestamp, estado, utimestamp, event_type, id_agentmodule, id_alert_am, criticity, user_comment, tags, source, id_extra, id_usuario, critical_instructions, warning_instructions, unknown_instructions, ack_utimestamp, custom_data, data, module_status)
pandora_1               | 	              VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), 0, 0, Warmup&#x20;mode&#x20;for&#x20;unknown&#x20;modules&#x20;started., 2021-06-15 19:24:38, 0, 1623777878.5649, system, 0, 0, 0, , , monitoring_server, , , , , , 0, , ,  at /usr/lib/perl5/PandoraFMS/Core.pm line 3654.
pandora_1               | 
pandora_1               | 
pandora_1               | 2021-06-15 19:24:38,596 DEBG fd 20 closed, stopped monitoring <POutputDispatcher at 140529020188824 for <Subprocess at 140529020581256 with name pandora_server in state RUNNING> (stdout)>
pandora_1               | 2021-06-15 19:24:38,596 INFO exited: pandora_server (exit status 25; not expected)
pandora_1               | 2021-06-15 19:24:38,596 DEBG received SIGCHLD indicating a child quit
pandora_1               | 
pandora_1               | ==> /var/log/pandora/pandora_server.error <==
pandora_1               | 2021-06-15 19:24:37 - pandora01 Starting Pandora FMS Server. Error logging activated.
pandora_1               | Use of uninitialized value $is_meta in numeric eq (==) at /usr/lib/perl5/PandoraFMS/DB.pm line 243.
pandora_1               | DBD::mysql::db do failed: Incorrect integer value: '' for column `pandora`.`tevento`.`module_status` at row 1 at /usr/lib/perl5/PandoraFMS/DB.pm line 1071.
pandora_1               | DBI::db=HASH(0x5578d62a98b8), id_evento, INSERT INTO tevento (id_agente, id_grupo, evento, timestamp, estado, utimestamp, event_type, id_agentmodule, id_alert_am, criticity, user_comment, tags, source, id_extra, id_usuario, critical_instructions, warning_instructions, unknown_instructions, ack_utimestamp, custom_data, data, module_status)
pandora_1               | 	              VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), 0, 0, Warmup&#x20;mode&#x20;for&#x20;unknown&#x20;modules&#x20;started., 2021-06-15 19:24:38, 0, 1623777878.5649, system, 0, 0, 0, , , monitoring_server, , , , , , 0, , ,  at /usr/lib/perl5/PandoraFMS/Core.pm line 3654.
pandora_1               | Perl exited with active threads:
pandora_1               | 	15 running and unjoined
pandora_1               | 	0 finished and unjoined
pandora_1               | 	0 running and detached
pandora_1               | 
``
@fbsanchez
Copy link
Member

Hi Esteban, it's an honor to know about one of the very first developers of PandoraFMS!

Remember pandorafms uses sql_mode set to '' (empty)!! and by now is only compatible with MySQL 5.7, untested in 8.0

Please ensure you have all the 188 tables created after launch the image

To test this image with external db:

Launch database

docker run --rm --name pandorafms-database -ti -e MYSQL_ROOT_PASSWORD=pandora -e MYSQL_DATABASE=pandora mysql:5.7 --sql_mode=''

Launch pandorafms

docker run --rm -ti -e DBHOST=172.17.0.2 -e DBNAME=pandora -e DBUSER=root -e DBPASS=pandora -e DBPORT=3306 -e INSTANCE_NAME=example pandorafms/pandorafms-open-stack-el8

Take in mind 172.17.0.2 should be the default IP if you're running docker without any containers running, you could inspect the address of the mysql container by executing:

docker inspect pandorafms-database 2>/dev/null  | grep '"IPAddress":' | tail -n +2 | cut -d '"' -f 4

After the process is completed you should be able to access http://172.16.0.3/pandora_console/ (if using docker without any other container running :D)

image

Please let me know if it does not work as expected!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@esanchezm @fbsanchez