Open rhaamo opened 5 years ago
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) ^
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.
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.
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:Are thoses errors blocking ?
Also is doing
php install_db.php
thenphp populate_all.php
sufficient for CLI install ?