-
Pandora FMS console won’t load
Hello,
I suspect we have a problem with just the console portion of our system as the alert emails are still sending correctly. I believe this all started happening after we had a problem with versions a few months ago and while we got the main version up to date at the time, the console was still back at version 1. I was attempting to update the version with the command ‘cat 1.sql | mysql -u root -p pandora’ as instructed in the documentation, and then immediately had an error which I don’t have on hand anymore, and had no backup of the db at the time.What I need to figure out is 2 things, how do I get 1.sql back on my system so I can attempt to run it again to update the MySQL database and move forward all the way up to 29.sql (latest on my system) so that I can try to get Pandora updated to the newest release? Where can I start? I appreciate any help!
-
6 Replies
-
-
Good morning
The MR you have to run them one by one from 1.sql to the last one you want to update.
Could you send us a capture of the error that appears when you try to access the Pandora FMS console?
Kind regards
When we attempt to load Pandora FMS console, we just get a message saying “This site can’t be reached”. Not sure how to look further or if a log file will produce the error that is preventing the page from loading.
As far as the sql files to run them in order, that’s what I was attempting to do, but broke it in the process I think. 1.sql does not appear in the /var/www/html/pandora_console/extras/MR folder at this time, is it possible to download it again and see if I can run it to try to fix this?
-
I’m not sure if this is related, but I did just find this in /var/log/pandora/pandora_server.error:
Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/PandoraFMS/Core.pm line 5064.
Sorry to keep posting, I keep digging and think I have this narrowed to the actual issue. I don’t think pandora_server is starting correctly which is why the console webpage won’t display. This looks to be a SQL issue, but not quite sure how to fix this:
2019-10-01 13:37:47 – pandorafms.cumberland.local Starting Pandora FMS Server. Error logging activated.
Use of uninitialized value $Config{“rb_product_name”} in concatenation (.) or string at /usr/bin/pandora_server line 215.
DBI connect(‘pandora:localhost:3306′,’pandora’,…) failed: Access denied for user ‘pandora’@’localhost’ (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 128. -
Hello rbiette,
As I see in the logs, probably the passwords refearing to the database in pandora_server.conf and config.php dont matc, I suggest you to check that. If the problem persists, change from “localhost” to “127.0.0.1” and try again. In case this didnt work too contact us again.
Best regards
Diego -
I have confirmed that both config.php and pandora_server.conf had the same passwords set, and went and changed localhost to 127.0.0.1 on both to test. These changes have not allowed the console to display at all. Currently this is the error /var/log/pandora/pandora_server.log is showing:
DBI connect(‘pandora:127.0.0.1:3306′,’pandora’,…) failed: Access denied for user ‘pandora’@’localhost’ (using password: YES) at /usr/lib/perl5/PandoraFMS/DB.pm line 128.
-
