Installation Script Problems

Advanced troubleshooting

Installation Script Problems

Posted by rkoote on February 12, 2016 at 14:52

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

Pierre replied 7 years, 3 months ago 8 Members · 16 Replies
16 Replies

emilio

Member
February 16, 2016 at 16:24

0 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
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.
txipiron_

Member
June 16, 2016 at 12:09

0 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
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
lubabalo

Member
July 24, 2017 at 13:45

0 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
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
skywalk44

Member
September 22, 2017 at 02:13

0 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
I think I’m having the same problem on step 5. http://npg-pandora-c1/pandora_console/install.php?step=4

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
vic

Administrator
September 26, 2017 at 11:28

1552 Karma points

Community awards: Bright ideas

Community rank: Tentacle Master

Like it
Up
0
Down
Drop it
::
Hi lubabalo,

Can you show me a screenshot of the error?

Best regards,

vic.
Pierre

Member
September 28, 2017 at 17:01

0 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
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.
vic

Administrator
September 28, 2017 at 18:57

1552 Karma points

Community awards: Bright ideas

Community rank: Tentacle Master
Like it
Up
0
Down
Drop it
::
Hi Pierre,

Can you find this file “my.cnf” on the mysql folder?
Edit the file and add this:
```
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION
```
Then restart the mysql service.

Best regards,

vic.
hvargas

Member
September 28, 2017 at 22:20

0 Karma points

Community rank: Tentacle noob
Like it
Up
0
Down
Drop it
::
Hi Pierre,

Can you find this file “my.cnf” on the mysql folder?
Edit the file and add this:
```
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION
```
Then restart the mysql service.

Best regards,

vic.
vic

Administrator
September 29, 2017 at 12:00

1552 Karma points

Community awards: Bright ideas

Community rank: Tentacle Master
Like it
Up
0
Down
Drop it
::
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 pandora
```
File in /etc/pandora/pandora_console/pandora_server.conf
```
-rw-r--r-- root root pandora_server.conf
```
Best regards,

vic.
hvargas

Member
September 29, 2017 at 15:44

0 Karma points

Community rank: Tentacle noob
Like it
Up
0
Down
Drop it
::
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 pandora
```
File in /etc/pandora/pandora_console/pandora_server.conf
```
-rw-r--r-- root root pandora_server.conf
```
Best 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 pandora
```
File in /etc/pandora/pandora_console/pandora_server.conf
```
-rw-r--r-- root root pandora_server.conf
```
Best regards,

vic.
vic

Administrator
October 2, 2017 at 13:30

1552 Karma points

Community awards: Bright ideas

Community rank: Tentacle Master

Like it
Up
0
Down
Drop it
::
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.

hvargas

Member

October 4, 2017 at 23:30

0 Karma points

Community rank:

Tentacle noob

Like it

Down

Drop it

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 pandora
File in /etc/pandora/pandora_console/pandora_server.conf
-rw-r--r-- root root pandora_server.conf
Best regards,

vic.

vic

Administrator

October 5, 2017 at 11:51

1552 Karma points

Community awards:

Bright ideas

Community rank:

Tentacle Master

Like it

Down

Drop it

Hi hvargas,

Can you show me the last content of the Pandora server log?

Best regards,

vic.

Pierre

Member

October 9, 2017 at 13:23

0 Karma points

Community rank:

Tentacle noob

Like it

Down

Drop it

Hi Pierre,

Can you find this file “my.cnf” on the mysql folder?
Edit the file and add this:
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION
Then 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?

vic

Administrator

October 9, 2017 at 15:33

1552 Karma points

Community awards:

Bright ideas

Community rank:

Tentacle Master

Like it

Down

Drop it

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.

Pierre

Member

October 10, 2017 at 18:39

0 Karma points

Community rank:

Tentacle noob

Like it

Down

Drop it

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.

Welcome to Pandora FMS Community!