Enable NOMINATIM_LOG_DB

[RailsGuy]

Hi I'm trying to capture query logging in table new_query_log by setting set NOMINATIM_LOG_DB=yes on Nominatim 4.5.0 but hav not been successful. Have I missed something?

I have tried the following

created a .env file

/srv/nominatim$ cat .env 
NOMINATIM_LOG_DB=yes

Edited the defaults file

/srv/nominatim$ cat Nominatim-4.5.0/settings/env.defaults|grep NOMINATIM_LOG_DB
NOMINATIM_LOG_DB=yes

I also ran this as the docs say. It created a new dir "/srv/nominatim/website"

nominatim refresh --website
2025-01-13 16:30:37: Using project directory: /srv/nominatim
2025-01-13 16:30:37: Setting up website directory at /srv/nominatim/website

but nothing is being logged

nominatim=# select count(*) from new_query_log;
 count 
-------
     0
(1 row)

There is some activity

grep '/nominatim/search.php?format=jsonv2' /var/log/apache2/access.log | wc -l
192302

[lonvia]

That's an oversight of the Python port. I completely forgot to reimplement the database logging.

All our servers have long switched to file based logging as it tends to be faster. Any particular reason you prefer database logging?

[RailsGuy]

Ahh OK. I've also tried file logging but also unable to get it to work

workbooks@map02b:/srv/nominatim$ cat .env
NOMINATIM_LOG_FILE=/tmp/nominatim_query.log

[lonvia]

That is supposed to work. Make sure that Nominatim really picks up that .env file and that your process has the appropriate rights to write to the file.

[RailsGuy]

File permissions should be fine. I've also tried a relative file name.

I'm not sure how to make sure Nominatim picks up .env. I have run "sudo systemctl restart nominatim" and "nominatim refresh --website" as suggested here https://nominatim.org/release-docs/latest/customize/Settings/#nominatim_log_file

xxxxxx/srv/nominatim$ cat .env
NOMINATIM_LOG_FILE=nominatim_query.log

sudo systemctl status nominatim
● nominatim.service - Nominatim running as a gunicorn application
     Loaded: loaded (/etc/systemd/system/nominatim.service; enabled; vendor preset: enabled)
     Active: active (running) since Tue 2025-01-14 14:28:30 UTC; 4min 9s ago
TriggeredBy: ● nominatim.socket
   Main PID: 2947741 (gunicorn)
      Tasks: 5 (limit: 115731)
     Memory: 538.1M
        CPU: 1min 26.716s
     CGroup: /system.slice/nominatim.service
             ├─2947741 /srv/nominatim/nominatim-venv/bin/python /srv/nominatim/nominatim-venv/bin/gunicorn -b unix:/run/nominatim.sock -w 4 -k uvicorn.workers.UvicornWorker nominatim_api.server.falcon.serv>
             ├─2947743 /srv/nominatim/nominatim-venv/bin/python /srv/nominatim/nominatim-venv/bin/gunicorn -b unix:/run/nominatim.sock -w 4 -k uvicorn.workers.UvicornWorker nominatim_api.server.falcon.serv>
             ├─2947744 /srv/nominatim/nominatim-venv/bin/python /srv/nominatim/nominatim-venv/bin/gunicorn -b unix:/run/nominatim.sock -w 4 -k uvicorn.workers.UvicornWorker nominatim_api.server.falcon.serv>
             ├─2947745 /srv/nominatim/nominatim-venv/bin/python /srv/nominatim/nominatim-venv/bin/gunicorn -b unix:/run/nominatim.sock -w 4 -k uvicorn.workers.UvicornWorker nominatim_api.server.falcon.serv>
             └─2947746 /srv/nominatim/nominatim-venv/bin/python /srv/nominatim/nominatim-venv/bin/gunicorn -b unix:/run/nominatim.sock -w 4 -k uvicorn.workers.UvicornWorker nominatim_api.server.falcon.serv>

Jan 14 14:28:30 xxxxxx systemd[1]: Started Nominatim running as a gunicorn application.

[lonvia]

Nominatim looks for the env file in the project directory. Make sure the current working directory of your systemd process is set to whereever you store the env file.