How to update Map Data of Nominatim 2.5 on Red Hat Linux 7? #3314

dev1ninja · 2024-01-24T03:33:29Z

dev1ninja
Jan 24, 2024

I hosted Nominatim 2.5.0 Geocoding Server to Red Hat Linux 7.

My Nominatim server is running successfully now.

Now I want to update Map Data to the latest version.
I use us-latest.osm.pbf.
How can I do it myself?
Please let me know.
Thanks

mtmail · 2024-01-24T10:55:19Z

mtmail
Jan 24, 2024
Maintainer

Not possible for the following reasons

Nominatim 2.5 is from 2016 and too outdated to offer support
That version can't handle some OSM data issue we found later which broke updates. So even if I give you instructions it will fail for some 2021 data.
Running the daily updates would take several weeks
The server to fetch updates for the us-latest file from only stores data for last 4 months http://download.geofabrik.de/north-america/us-updates/000/001/

You're better off reinstalling Nominatim

19 replies

mtmail Feb 5, 2024
Maintainer

"-bash: GRANT: command not found" means that you typed the command into the bash shell, not in the postgresql shell (psql). Mistakes like this happen but can be researched with a Google search.

dev1ninja Feb 5, 2024
Author

I created user named "apache" on postgresql, and I granted to "apache".
But I still have DB Error: insufficient permissions

mtmail Feb 6, 2024
Maintainer

Hmm, maybe there's another webserver running?

Does curl --head http://172.71.201.180:80 show server: apache? I'm guessing the domain from one of the screenshots. curl --head https://nominatim.openstreetmap.org

Does apache listen on port 80 (again I'm guessing the port)? sudo netstat -tulnp | grep ':80' shows processing and what the listen on.

Since it's Redhat, is SELinux enabled? sestatus would print something like -enabled- or -active-. If the tool is not installed that's a sign it's not enabled. SELinux adds a extra security who is allows to access files, ports and some rules might need to be enabled again if files got recreated. Does the SELinux logfile (I think that's /var/log/audit/audit.log) show any relevant warnings?

Does the Postgresql server logfile show permissions warnings? On Ubuntu the file is in /var/log/postgresql/*.log and warning might look like FATAL: no pg_hba.conf entry for host "12.4.56.78", user "root", database "root". If there's warnings we can inspect the _hba config files for any rules that might prevent the webserver user from accessing the database.

dev1ninja Feb 6, 2024
Author

@mtmail This is what I can see.

FYI: I installed Nominatim 2.5.0 on 2018. And I used this server for a long time and it worked well. And I drop nominatim database. And I updated osm map data to the us-latest. I am not sure why my server does not work after I updated map data.
I use Linux Red Hat 7. I am not able to find postgresql log files.

< 2024-02-05 00:18:47.609 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 00:18:47.609 EST >STATEMENT:  insert into query_log values ('2024-02-05 05:18:47.6085','','205.210.31.143')
< 2024-02-05 00:18:47.609 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 00:18:47.609 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 05:18:47.6085','','205.210.31.143','Expanse, a Palo Alto Networks company, searches across the global IPv4 space multiple times per day to identify customers&#39; presences on the Internet. If you would like to be excluded from our scans, please send IP addresses/domains to: [email protected]','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 00:18:47.610 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 00:18:47.610 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 00:18:47.611 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 00:18:47.611 EST >STATEMENT:  update query_log set endtime = '2024-02-05 05:18:47.6108', results = 0 where starttime = '2024-02-05 05:18:47.6085' and ipaddress = '205.210.31.143' and query = ''
< 2024-02-05 00:18:47.611 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 00:18:47.611 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 05:18:47.6108', results = 0 where starttime = '2024-02-05 05:18:47.6085' and ipaddress = '205.210.31.143' and query = ''
< 2024-02-05 00:24:41.859 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 00:24:41.859 EST >STATEMENT:  insert into query_log values ('2024-02-05 05:24:41.8591','','135.125.218.67')
< 2024-02-05 00:24:41.860 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 00:24:41.860 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 05:24:41.8591','','135.125.218.67','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 00:24:41.861 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 00:24:41.861 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 00:24:41.861 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 00:24:41.861 EST >STATEMENT:  update query_log set endtime = '2024-02-05 05:24:41.8613', results = 0 where starttime = '2024-02-05 05:24:41.8591' and ipaddress = '135.125.218.67' and query = ''
< 2024-02-05 00:24:41.862 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 00:24:41.862 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 05:24:41.8613', results = 0 where starttime = '2024-02-05 05:24:41.8591' and ipaddress = '135.125.218.67' and query = ''
< 2024-02-05 00:45:02.879 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 00:45:02.879 EST >STATEMENT:  insert into query_log values ('2024-02-05 05:45:02.8783','','185.254.196.173')
< 2024-02-05 00:45:02.879 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 00:45:02.879 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 05:45:02.8783','','185.254.196.173','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 00:45:02.880 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 00:45:02.880 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 00:45:02.881 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 00:45:02.881 EST >STATEMENT:  update query_log set endtime = '2024-02-05 05:45:02.8806', results = 0 where starttime = '2024-02-05 05:45:02.8783' and ipaddress = '185.254.196.173' and query = ''
< 2024-02-05 00:45:02.881 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 00:45:02.881 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 05:45:02.8806', results = 0 where starttime = '2024-02-05 05:45:02.8783' and ipaddress = '185.254.196.173' and query = ''
< 2024-02-05 01:17:21.402 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 01:17:21.402 EST >STATEMENT:  insert into query_log values ('2024-02-05 06:17:21.4015','','71.6.232.26')
< 2024-02-05 01:17:21.402 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 01:17:21.402 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 06:17:21.4015','','71.6.232.26','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 01:17:21.403 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 01:17:21.403 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 01:17:21.404 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 01:17:21.404 EST >STATEMENT:  update query_log set endtime = '2024-02-05 06:17:21.4037', results = 0 where starttime = '2024-02-05 06:17:21.4015' and ipaddress = '71.6.232.26' and query = ''
< 2024-02-05 01:17:21.404 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 01:17:21.404 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 06:17:21.4037', results = 0 where starttime = '2024-02-05 06:17:21.4015' and ipaddress = '71.6.232.26' and query = ''
< 2024-02-05 01:37:53.898 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 01:37:53.898 EST >STATEMENT:  insert into query_log values ('2024-02-05 06:37:53.8982','','64.62.197.115')
< 2024-02-05 01:37:53.899 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 01:37:53.899 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 06:37:53.8982','','64.62.197.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 01:37:53.900 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 01:37:53.900 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 01:37:53.900 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 01:37:53.900 EST >STATEMENT:  update query_log set endtime = '2024-02-05 06:37:53.9003', results = 0 where starttime = '2024-02-05 06:37:53.8982' and ipaddress = '64.62.197.115' and query = ''
< 2024-02-05 01:37:53.901 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 01:37:53.901 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 06:37:53.9003', results = 0 where starttime = '2024-02-05 06:37:53.8982' and ipaddress = '64.62.197.115' and query = ''
< 2024-02-05 02:04:54.268 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 02:04:54.269 EST >STATEMENT:  insert into query_log values ('2024-02-05 07:04:54.2684','','176.97.210.229')
< 2024-02-05 02:04:54.269 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 02:04:54.269 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 07:04:54.2684','','176.97.210.229','','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 02:04:54.270 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 02:04:54.270 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 02:04:54.271 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 02:04:54.271 EST >STATEMENT:  update query_log set endtime = '2024-02-05 07:04:54.2706', results = 0 where starttime = '2024-02-05 07:04:54.2684' and ipaddress = '176.97.210.229' and query = ''
< 2024-02-05 02:04:54.271 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 02:04:54.271 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 07:04:54.2706', results = 0 where starttime = '2024-02-05 07:04:54.2684' and ipaddress = '176.97.210.229' and query = ''
< 2024-02-05 02:14:47.774 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 02:14:47.774 EST >STATEMENT:  insert into query_log values ('2024-02-05 07:14:47.7736','','185.254.196.173')
< 2024-02-05 02:14:47.774 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 02:14:47.774 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 07:14:47.7736','','185.254.196.173','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 02:14:47.775 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 02:14:47.775 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 02:14:47.776 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 02:14:47.776 EST >STATEMENT:  update query_log set endtime = '2024-02-05 07:14:47.7756', results = 0 where starttime = '2024-02-05 07:14:47.7736' and ipaddress = '185.254.196.173' and query = ''
< 2024-02-05 02:14:47.776 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 02:14:47.776 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 07:14:47.7756', results = 0 where starttime = '2024-02-05 07:14:47.7736' and ipaddress = '185.254.196.173' and query = ''
< 2024-02-05 02:46:08.802 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 02:46:08.802 EST >STATEMENT:  insert into query_log values ('2024-02-05 07:46:08.8021','','135.125.218.67')
< 2024-02-05 02:46:08.803 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 02:46:08.803 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 07:46:08.8021','','135.125.218.67','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 02:46:08.804 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 02:46:08.804 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 02:46:08.805 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 02:46:08.805 EST >STATEMENT:  update query_log set endtime = '2024-02-05 07:46:08.8044', results = 0 where starttime = '2024-02-05 07:46:08.8021' and ipaddress = '135.125.218.67' and query = ''
< 2024-02-05 02:46:08.805 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 02:46:08.805 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 07:46:08.8044', results = 0 where starttime = '2024-02-05 07:46:08.8021' and ipaddress = '135.125.218.67' and query = ''
< 2024-02-05 02:53:48.136 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 02:53:48.136 EST >STATEMENT:  insert into query_log values ('2024-02-05 07:53:48.1357','','135.125.246.189')
< 2024-02-05 02:53:48.136 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 02:53:48.136 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 07:53:48.1357','','135.125.246.189','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36','short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 02:53:48.137 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 02:53:48.137 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 02:53:48.138 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 02:53:48.138 EST >STATEMENT:  update query_log set endtime = '2024-02-05 07:53:48.1379', results = 0 where starttime = '2024-02-05 07:53:48.1357' and ipaddress = '135.125.246.189' and query = ''
< 2024-02-05 02:53:48.138 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 02:53:48.138 EST >STATEMENT:  update new_query_log set endtime = '2024-02-05 07:53:48.1379', results = 0 where starttime = '2024-02-05 07:53:48.1357' and ipaddress = '135.125.246.189' and query = ''
< 2024-02-05 03:07:36.959 EST >ERROR:  permission denied for relation query_log
< 2024-02-05 03:07:36.959 EST >STATEMENT:  insert into query_log values ('2024-02-05 08:07:36.9592','','20.199.91.244')
< 2024-02-05 03:07:36.960 EST >ERROR:  permission denied for relation new_query_log
< 2024-02-05 03:07:36.960 EST >STATEMENT:  insert into new_query_log (type,starttime,query,ipaddress,useragent,language,format) values ('search','2024-02-05 08:07:36.9592','','20.199.91.244','Mozlila/5.0 (Linux; Android 7.0; SM-G892A Bulid/NRD90M; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/60.0.3112.107 Moblie Safari/537.36','short_name:en-US,short_name:en,short_name:fr,name:en-US,name:en,name:fr,place_name:en-US,place_name:en,place_name:fr,official_name:en-US,official_name:en,official_name:fr,short_name,name,place_name,official_name,ref,type','')
< 2024-02-05 03:07:36.961 EST >ERROR:  permission denied for relation import_status
< 2024-02-05 03:07:36.961 EST >STATEMENT:  select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1
< 2024-02-05 03:07:36.962 EST >ERROR:  permission denied for relation query_log

Could you pls help me via remote tool like anydesk?

dev1ninja Feb 6, 2024
Author

@mtmail
I think I solved issue.
I needed to grant to nginx.

Thank you very much.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

How to update Map Data of Nominatim 2.5 on Red Hat Linux 7? #3314

{{title}}

Replies: 1 comment 19 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

How to update Map Data of Nominatim 2.5 on Red Hat Linux 7? #3314

dev1ninja Jan 24, 2024

I hosted Nominatim 2.5.0 Geocoding Server to Red Hat Linux 7.

Replies: 1 comment · 19 replies

mtmail Jan 24, 2024 Maintainer

mtmail Feb 5, 2024 Maintainer

dev1ninja Feb 5, 2024 Author

mtmail Feb 6, 2024 Maintainer

dev1ninja Feb 6, 2024 Author

dev1ninja Feb 6, 2024 Author

dev1ninja
Jan 24, 2024

Replies: 1 comment 19 replies

mtmail
Jan 24, 2024
Maintainer

mtmail Feb 5, 2024
Maintainer

dev1ninja Feb 5, 2024
Author

mtmail Feb 6, 2024
Maintainer

dev1ninja Feb 6, 2024
Author

dev1ninja Feb 6, 2024
Author