I imported planet data onto my CentOS machine, and when trying to use the Nominatim installation using curl:

curl 'http://localhost/nominatim/reverse?format=xml&lat=-33.859728&lon=151.227569&zoom=18&addressdetails=1&debug=1'

I get a long debug message with the reoccuring:

ERROR:  permission denied for relation placex

During the installation process, I tried to alter role, and got a message saying that role "www-data_ does not exist:

bash-4.1$ psql -d nominatim -c 'ALTER USER "www-data" RENAME TO "apache"'
ERROR:  role "www-data" does not exist

Could they be related? How do I solve the issue of permission for placex relation?

asked 24 Mar '15, 18:53

baekacaek's gravatar image

baekacaek
176121317
accept rate: 0%


Did you follow the instructions on http://wiki.openstreetmap.org/wiki/Nominatim/Installation, namely where it says:

createuser -SDR www-data

?

permanent link

answered 24 Mar '15, 23:46

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
70.6k826391105
accept rate: 24%

Yes I made sure to run that command (because I forgot to at first).

(24 Mar '15, 23:59) baekacaek

Because the user didn't exist when the database was created all the grant commands will have failed. You will need to go through and run them manually. You can find them in tables.sql, an example would be:

GRANT SELECT ON import_status TO "www-data" ;

(25 Mar '15, 13:37) twain

That could be the reason why. Could you guide me on how I could run it manually? I found the tables.sql file, but I'm not quite sure what I am supposed to do with it. Thanks

(06 Apr '15, 20:32) baekacaek
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×550
×189
×8

question asked: 24 Mar '15, 18:53

question was seen: 3,528 times

last updated: 06 Apr '15, 20:32

powered by OSQA