Task #10956
closed
Added by Fabio Sinibaldi over 7 years ago.
Updated over 7 years ago.
Assignee:
_InfraScience Systems Engineer
Infrastructure:
Production
Description
Please clone mentioned VM and grant the new machine access to the following databases:
timeseriesgisdb on node50.p.d4science.research-infrastructures.eu
aquamapsdb on geoserver-db.d4science.org
aquamapsgeomar on node52.p.d4science.research-infrastructures.eu
mpa on geoserver-db.d4science.org
Access to these databases needs to be read only for security reasons, so an ad-hoc user should be created and provided in this ticket.
- Priority changed from Normal to Urgent
What is the status of cloning process?
- Status changed from New to In Progress
- Assignee changed from Andrea Dell'Amico to _InfraScience Systems Engineer
- % Done changed from 0 to 50
The new VM is almost ready, accesses to the various databases must be created.
The user has the CONNECT role on all the required DBs and the SELECT role on all the DB tables. Because the databases run on postgresql < 9 the grants must be set on each table. If new tables will be added, the grants on that tables must be set again. I used commands like
CREATE USER reader WITH PASSWORD '**********';
grant CONNECT on DATABASE aquamapsgeomar to reader;
psql -At -d aquamapsgeomar -c "SELECT 'GRANT SELECT ON '|| tablename||' TO reader;' FROM pg_tables WHERE schemaname='public';" | psql -d aquamapsgeomar
psql -At -d aquamapsgeomar -c "SELECT 'GRANT SELECT ON '||c.relname||' TO reader;' FROM pg_class c JOIN pg_namespace n ON (n.oid=c.relnamespace) WHERE c.relkind='S' AND n.nspname='public';" | psql -d aquamapsgeomar
to configure the user. pg_hba.conf has been configured accordingly.
- Status changed from In Progress to Feedback
- % Done changed from 50 to 100
The geoserver cloned VM has been called geoserver5.d4science.org. @vincenzo.terrano@eng.it has access as gcube user.
I did not change the geoserver configuration to use the new user.
- Status changed from Feedback to Closed
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
