[HOT] Error while running script ./env/bin/initialize_osmtm_db

[Martin Dittus]

This has to do with the way permissions are set up in your PostgreSQL database: the database user you’re using to connect to the database does not have the permissions necessary to update PostGIS tables.

Try this in the PostgreSQL console:
GRANT select, insert, update, delete ON spatial_ref_sys to <your_postgres_username>;

… substituting the actual username you’re connecting with for "<your_postgres_username>”.

It’s likely that you will have to do this for the geometry_columns table as well, maybe others.

m.



> On 25 Mar 2016, at 20:15, Saikat Basu <deepbasu007 at gmail.com> wrote:
> 
> Hi everyone,
>     While trying to install the OSM Task Manager, I followed all the steps mentioned in the wiki. However, while trying to initialize the database using the script provided in the wiki,
> ./env/bin/initialize_osmtm_db
> 
> I got the error:
> 
> sqlalchemy.exc.ProgrammingError: (ProgrammingError) permission denied for relation spatial_ref_sys
> 
> CONTEXT:  SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid = 4326 LIMIT 1"
> 
> 
>  'SELECT ST_AsBinary(ST_Transform(ST_SetSRID(ST_Multi(ST_GeomFromWKB(%(ST_GeomFromWKB_1)s, %(ST_GeomFromWKB_2)s)), %(param_1)s), %(param_2)s)) AS "ST_Transform_1"' {'ST_GeomFromWKB_1': <read-only buffer for 0x2f2e690, size -1, offset 0 at 0x2f36fb0>, 'param_2': 3857, 'param_1': 4326, 'ST_GeomFromWKB_2': 4326}
> 
> Can anyone please help me figure out the problem? Thanks.
> 
> -- 
> Saikat Basu
> Department of Computer Science
> Louisiana State University
> USA
> 
> _______________________________________________
> HOT mailing list
> HOT at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/hot