Task #5353
closed
Task #5358: Portlet resources
Database + endpoint needed
100%
Description
We need a postgress database. The database will not host large volume of data, a starting point of 10G should be sufficient. Just numbers and text, no images or blobs.
We need a Database endpoint named SimulFishGrowth that points to this database.
We also need the credentials and privileges in order to handle tables and views and insert/update/delete data.
Related issues
Updated by Andrea Dell'Amico over 8 years ago
We already have a dedicated postgresql with a database that has the same name: https://support.d4science.org/issues/3893
Is it a different instance? Has the name to be the same?
Updated by Denis Pyriochos over 8 years ago
The previous database is for development, this is for preproduction. We may need one more for production.
The database name is not important. You can name it as you please as we are querying the endpoint and get connection info from there.
The connection point should have the same name, SimulFishGrowth.
Updated by Denis Pyriochos over 8 years ago
- Related to Task #5384: Endpoint access - SimulFishGrowth added
Updated by Denis Pyriochos over 8 years ago
- Related to Task #5386: Endpoint access - SimulFishGrowth added
Updated by Denis Pyriochos over 8 years ago
- Related to Task #5385: Endpoint access - SimulFishGrowth added
Updated by Massimiliano Assante over 8 years ago
Denis, before proceeding I would like to ask if your query to the IS for the endpoint (SimulFishGrowth DB) uses the current VRE scope (as it should)
Updated by Massimiliano Assante over 8 years ago
- Assignee changed from _InfraScience Systems Engineer to Roberto Cirillo
Updated by Denis Pyriochos over 8 years ago
As far as I know and based on your suggestions, we are setting the current scope and then query the IS for SimulFishGrowth.
I am a bit alarmed with your question, though. How else could we access the endpoint? Is there a pitfall you see?
Updated by Massimiliano Assante over 8 years ago
Denis Pyriochos wrote:
As far as I know and based on your suggestions, we are setting the current scope and then query the IS for SimulFishGrowth.
I am a bit alarmed with your question, though. How else could we access the endpoint? Is there a pitfall you see?
I wanted make sure you were not hardcoding the scope, sorry.
Updated by Tommaso Piccioli over 8 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 50
New empty DB created ( SimulFishGrowth_pre ) , is available at the server db-sfg-pre.d4science.org with the same login (user: sfguser) of the dev database.
Updated by Denis Pyriochos over 8 years ago
Is there a way to give the password as I should run the setup scripts?
Updated by Denis Pyriochos over 8 years ago
Dear @tommaso.piccioli@isti.cnr.it could you please send me the password as I should run the init scripts for the database?
Updated by Tommaso Piccioli over 8 years ago
Denis, user and password are the same of the dev database, I'm sending the password to you via email.
Updated by Denis Pyriochos over 8 years ago
- Infrastructure Production added
We need the same for Production as well.
Updated by Andrea Dell'Amico over 8 years ago
- Status changed from In Progress to Feedback
- % Done changed from 50 to 100
I've just created the db named SimulFishGrowth_prod. You can access it with the same user and password of the other two databases.
Updated by Denis Pyriochos over 8 years ago
- Status changed from Feedback to In Progress
we also need an database endpoint named SimulFishGrowth, pointing to this database and accessible from the scopes:
- /d4science.research-infrastructures.eu/gCubeApps/EllinikaPsariaVRE
- /d4science.research-infrastructures.eu/gCubeApps/AlieiaVRE
- /d4science.research-infrastructures.eu/gCubeApps/ForkysVRE
Updated by Denis Pyriochos over 8 years ago
Also, I get the error
10:11:43 PM: Error: FATAL: no pg_hba.conf entry for host "193.92.78.53", user "sfguser", database "SimulFishGrowth_prod", SSL on FATAL: no pg_hba.conf entry for host "193.92.78.53", user "sfguser", database "SimulFishGrowth_prod", SSL off
I guess you should whitelist our ip address. Thx.
Updated by Andrea Dell'Amico over 8 years ago
- Status changed from In Progress to Feedback
Denis Pyriochos wrote:
Also, I get the error
10:11:43 PM: Error: FATAL: no pg_hba.conf entry for host "193.92.78.53", user "sfguser", database "SimulFishGrowth_prod", SSL on FATAL: no pg_hba.conf entry for host "193.92.78.53", user "sfguser", database "SimulFishGrowth_prod", SSL offI guess you should whitelist our ip address. Thx.
Yes, I forgot to reload the service.
Do you have a fixed IP (or a list of them, or a network) from where you access the db? right now the ACLs are very permissive.
Updated by
Updated by Denis Pyriochos over 8 years ago
- Status changed from Feedback to Closed
@andrea.dellamico@isti.cnr.it this is the only static ip accessing the database.
Updated by Andrea Dell'Amico over 8 years ago
Denis Pyriochos wrote:
this is the only static ip accessing the database.
Is this valid for the dev and preprod instances too?
Updated by Denis Pyriochos over 8 years ago
Yes. I just checked and it has access to all three databases: SimulFishGrowth, SimulFishGrowth_pre, SimulFishGrowth_prod
Updated by Andrea Dell'Amico over 8 years ago
I've also seen accesses coming from 88.197.53.20. I added both the IPs to the postgresql ACLs.
Updated by Denis Pyriochos over 8 years ago
This one should be the actual java service, managed by @k.kakaletris@cite.gr
Updated by Kostas Kakaletris over 8 years ago
- 88.197.53.20 is the ip of the VM that is hosting the pre-production gcube service
- 88.197.53.37 is the ip of the VM that is hosting the production gcube servicc
Updated by Andrea Dell'Amico over 8 years ago
- Related to Incident #5687: SimulFishGrowthData cannot contact postgres user added
Updated by Pasquale Pagano over 8 years ago
- Target version deleted (
gCube related support)
