SQL Errors on install from CLI install_db.php

[rhaamo]

Hello,

I'm trying to install on postgresql (11)+nginx+php (7.2-fpm) and I got lot of timeout issues and give up installing from web, my config was updated from web, and I kept it, I just setted $globalInstalled = FALSE; and installed from CLI, but I'm getting errors:

# on postgresql server: dropdb flightairmap && createdb -O flightairmap flightairmap
root@patate:/var/www/flightairmap/install# php install_db.php
Create and import all tables...Done !
Populate all tables...
Routes from FlightAirMap website : Download...Gunzip...Add to DB...error : SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "routes" does not exist
LINE 1: DELETE FROM routes WHERE Source = '' OR Source = 'website_fa...
                    ^Translation from FlightAirMap website : Download...Gunzip...Add to DB...error : SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "translation" does not exist
LINE 1: DELETE FROM translation WHERE Source = '' OR Source = 'websi...
                    ^ModeS from FlightAirMap website : Download...Gunzip...Add to DB...error : SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "aircraft_modes" does not exist
LINE 1: DELETE FROM aircraft_modes WHERE Source = '' OR Source = 'we...
                    ^Modes OGN: Download...Add to DB...error : SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "aircraft_modes" does not exist
LINE 1: DELETE FROM aircraft_modes WHERE Source = '' OR Source IS NU...
                    ^Banned airlines in Europe from FlightAirMap website : Download...Add to DB...error : SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "airlines" does not exist
LINE 1: UPDATE airlines SET ban_eu = 0
               ^Blocked aircraft from FlightAirMap website : Download...Gunzip...Add to DB...error : SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "aircraft_block" does not exist
LINE 1: DELETE FROM aircraft_block WHERE Source = '' OR Source = 'we...
                    ^
Install waypoints...(VERY slow!)Done !
Install airspace...PHP Notice:  Undefined variable: _SESSION in /var/www/flightairmap/install/class.update_db.php on line 2031
PHP Notice:  Undefined variable: _SESSION in /var/www/flightairmap/install/class.update_db.php on line 2031
Done !
All is now installed ! Thanks
You need to run cron-sbs.php as a daemon. You can use init script in the install/init directory.
root@patate:/var/www/flightairmap/install# 

Are thoses errors blocking ?

Also is doing php install_db.php then php populate_all.php sufficient for CLI install ?

[rhaamo]

flightairmap=# \dt
Did not find any relations.

Mhhhh, looks like install_db.php haven't done anything and silently fails.

EDIT: ended up using 36000s as timeouts and everything went mostly fine, but EXTREMELY SLOWLY. checked settings and I have transaction at true. the create-import and each populate took between 3 and 10 minutes each.

Then countries failed: Error : error (import /var/www/flightairmap/install/tmp/countries.sql) : SQLSTATE[42704]: Undefined object: 7 ERROR: type "geometry" does not exist LINE 13: ogc_geom geometry(MultiPolygon,4326) ^

[rhaamo]

About the geometry error, the postgis extension wasn't created by the web setup.. created manually in the postgres shell and it seems to work.

I think it might have been a right issue (my flightairmap pgsql user isn't super-user, so indeed it can't CREATE EXTENSION by itself), and again silent error without notifying it.

[Ysurac]

Install can only be done via web interface (at least install via script is not supported). If you have PHP timeout you should increase max_execution_time in php.ini config file.