importing into an external postgres database - calculate postcodes error

[welshstew]

Hello folks 👋 ,

I'm trying to import data into an external postgres database, it progresses to a point but fails on calculate postcodes. Is there something I am missing here? Any help gratefully received.

(very new to Nominatim, so have been following the docs, but stuck on this now :( )

psql (PostgreSQL) 12.7
nominatim 3.7

The .env file in my project directory is:

# .env
# Default configuration settings for Nominatim.
# This file uses the dotenv format.
NOMINATIM_DATABASE_DSN="pgsql:dbname=monaco;user=postgres;password=rootyroot;host=localhost;port=15432"
NOMINATIM_DATABASE_MODULE_PATH="/opt/app-root/src/build/module/"

and I am getting the error:

...
2021-06-29 16:07:25: Load data into placex table
 count 
-------
  1795
(1 row)

 count 
-------
    66
(1 row)

...

2021-06-29 16:07:30: Calculate postcodes
2021-06-29 15:07:30 == Calculate Postcodes
ERROR: pgsql returned with error code (1)
string(34) "pgsql returned with error code (1)"
Traceback (most recent call last):
  File "/usr/local/bin/nominatim", line 17, in <module>
    phpcgi_path='/usr/bin/php-cgi'))
  File "/usr/local/lib64/nominatim/lib-python/nominatim/cli.py", line 288, in nominatim
    return parser.run(**kwargs)
  File "/usr/local/lib64/nominatim/lib-python/nominatim/cli.py", line 92, in run
    return args.command.run(args)
  File "/usr/local/lib64/nominatim/lib-python/nominatim/clicmd/setup.py", line 120, in run
    nominatim_env=args, throw_on_fail=not args.ignore_errors)
  File "/usr/local/lib64/nominatim/lib-python/nominatim/tools/exec_utils.py", line 33, in run_legacy_script
    check=throw_on_fail)
  File "/usr/lib64/python3.6/subprocess.py", line 438, in run
    output=stdout, stderr=stderr)
subprocess.CalledProcessError: Command '['/usr/bin/env', 'php', '-Cq', '/usr/local/lib64/nominatim/lib-php/admin/setup.php', '--calculate-postcodes']' returned non-zero exit status 255.

[lonvia]

This very much looks like a bug where the credentials are not properly transferred from Python to PHP tp pgsql.

I move this to issues and will confirm later.

[lonvia]

Quick workaround for this issue is to change your /etc/php.ini:

- variables_order = "GPCS"
+ variables_order = "EGPCS"

For details see #2380.

[welshstew]

I confirm this worked! Thank you!