Dear All, I try to install Pandora Console and Pandora Server from the pandora.repo at my virtual RHEL6.7 server. The server is hosted on VMWare ESX. Installation from the repository goes fine, but after accessing http://,server-ip/pandora_console/install.php?step=4 things start to look as an Gordian Knot. Especially the following message: Creating database and default configuration file Connection with Database Creating database 'pandora' Opening database 'pandora' Creating schema Populating database Established privileges for user pandora. A new random password has been generated: ssuyrprf Please write it down, you will need to setup your Pandora FMS server, editing the /etc/pandora/pandora_server.conf file Write permissions to save config file in './include' Created new config file at 'include/config.php' There were some problems. Installation was not completed. Please correct failures before trying again. All database schemes created in this step have been dropped. is very mind-boggling, how can I adjust the pandora_server.conf file on forehand to avoid a database acces problem, while I do not know the generated password for pandora. Why is the script dropping the new database? I haven't be able to adjust the pandora_server.conf file yet!!! Can you give some tips or hints how to solve this installer issue. I've seen this issue with Pandora 5.1SP4 and 6.0. Thanks in advance, Robert Koote
Installation Script Problems
rkoote · 12 feb 2016, 14:52 · 17 mensajes · 98 visitas
- Inicio del debate
Hello Robert, There's no problem with the installation itself, we couldn't replicate your issue. Could you attach screenshots from your installation process? At step four you are writing down the pass from your mysql installation, don't you? Regards, Emilio.
i´m having the same issue. I followed all the steps to install pandora, but on step 5/6 all balloons get in green but drops database and returns the following message: There were some problems. Installation was not completed. Please correct failures before trying again. All database schemes created in this step have been dropped. I'm using to connect to data base a user cloned from user root and i see how DDBB is created. The MySQL server is in another machine. Thank you
I'm having a similar problem its failing on the create schema and populate database. Above it shows "Invalid default value for 'last_pass_change'. This is rather frustrating because one would think the creators of the script put in the correct default values. Please advise
I think I'm having the same problem on step 5. (Link not available anymore) I'm installing Pandora 7.0NG.712 on Unbuntu 16.04. Everything has gone well but I'm getting red on Creating schema and Populating database on step 5 in the setup. Green on the other items. The error message at the bottom says: There were some problems. Installation was not completed. Please correct failures before trying again. All database schemes created in this step have been dropped. Any idea how to fix this? Thanks, -Jared
[

](//pandorafms.com/community/media/forum/8685/21528=1115-PandoraSetupError.jpg)
Hi lubabalo, Can you show me a screenshot of the error? Best regards, vic.
Hi, I think i have the same error on OpenSuse 42.2 Itried to install pandora 7 and 7.12 but I have same result. Can you help me? Thank you.
[
](//pandorafms.com/community/media/forum/8403/21548=1117-Pandora-FMS-error.JPG)
Hi Pierre, Can you find this file "my.cnf" on the mysql folder? Edit the file and add this:
[mysqld] sql_mode=NO_ENGINE_SUBSTITUTIONThen restart the mysql service. Best regards, vic.
Hi Pierre, Can you find this file "my.cnf" on the mysql folder? Edit the file and add this:
[mysqld] sql_mode=NO_ENGINE_SUBSTITUTIONThen restart the mysql service. Best regards, vic.
[

](//pandorafms.com/community/media/forum/8695/21550=1118-Seleccion_053.png)
Hi hvargas, Can you check the permissions of these folders? /var/www/html/pandora_console/include
drwxr-xr-x. apache apache include/etc/pandora/pandora_console/
drwxr-xr-x. pandora root pandoraFile in /etc/pandora/pandora_console/pandora_server.conf
-rw-r--r-- root root pandora_server.confBest regards, vic.
Hello VIC, Thanks for your answer, I checked the permissions of the directories and they are fine, but the problem persists :( .. I attach screenshots
Hi VIC, Thanks for your answer, I checked the permissions of the directories and they are fine, but the problem persists :( ... I attach screenshots. Hi hvargas, Can you check the permissions of these folders? /var/www/html/pandora_console/include
drwxr-xr-x. apache apache include/etc/pandora/pandora_console/
drwxr-xr-x. pandora root pandoraFile in /etc/pandora/pandora_console/pandora_server.conf
-rw-r--r-- root root pandora_server.confBest regards, vic.
Hi hvargas, Can you check the permissions of these folders? /var/www/html/pandora_console/include
drwxr-xr-x. apache apache include/etc/pandora/pandora_console/
drwxr-xr-x. pandora root pandoraFile in /etc/pandora/pandora_console/pandora_server.conf
-rw-r--r-- root root pandora_server.confBest regards, vic.
[

](//pandorafms.com/community/media/forum/8695/21557=1119-Seleccion_056.png)
[

](//pandorafms.com/community/media/forum/8695/21557=1120-Seleccion_056.png)
[

](//pandorafms.com/community/media/forum/8695/21557=1121-Seleccion_057.png)
Hi hvargas, Is an error in the installation script, creates an infinite loop, every time you access the install.php the script deletes the database and creates a new one. To solve this, do the following steps: [list=1]- Access the database.
mysql -u user -p- Delete and create the Pandora database.
drop database pandora; create database pandora;- Access it.
use pandora;- Create the Pandora structure.
source /var/www/html/pandora_console/pandoradb.sql- Insert data into this structure.
source /var/www/html/pandora_console/pandoradb_data.sql- Exit the database and modify the /etc/pandora/pandora_server.conf file.
In /var/www/html/pandora/include/ you have to have the config.php file with the parameters of access to the database, modify them if is necessary. Finally, modify the name of the file install.php and access to the console with address-ip/pandora_console/ Best regards, vic.
Hi VIC with the above I was able to enter the pandora admin interface through the browser, however I can not add agents, due to the start the pandora service on my server I get the following error: (screenshot) Thanks for all the help!
Hi hvargas, Can you check the permissions of these folders? /var/www/html/pandora_console/include
drwxr-xr-x. apache apache include/etc/pandora/pandora_console/
drwxr-xr-x. pandora root pandoraFile in /etc/pandora/pandora_console/pandora_server.conf
-rw-r--r-- root root pandora_server.confBest regards, vic.
[

](//pandorafms.com/community/media/forum/8695/21574=1129-Seleccion_075.png)
Hi hvargas, Can you show me the last content of the Pandora server log? Best regards, vic.
Hi Pierre, Can you find this file "my.cnf" on the mysql folder? Edit the file and add this:
[mysqld] sql_mode=NO_ENGINE_SUBSTITUTIONThen restart the mysql service. Best regards, vic.
Hi Vic, Thank you, this method allowed me to finish the installation of pandora console. But after the installation of pandora server and since pandora_server is running, http://localhost/pandora\_cosole and http://localhost/pandora\_console/index.php are displayed as empty. Can you help me for this problem too?
Hi Pierre, Are the services up? Before of the installation, you have to put http://localhost/pandora\_console/ in the URL. If the screen is empty, delete the cache of your browser. If it doesn't work, show the contents of the registry file of the pandora console. Best regards, vic.
Hi Pierre, Are the services up? Before of the installation, you have to put http://localhost/pandora\_console/ in the URL. If the screen is empty, delete the cache of your browser. If it doesn't work, show the contents of the registry file of the pandora console. Best regards, vic.
Hi Vic, Finalement ça fonctionne, thank you for you help.
Entra en tu cuenta para publicar.






