Regarding External Database Setup For MOSIP

reddi3 · December 19, 2023, 6:06am

Hi Team,

We have a requirement to setup external database(Postgres) for the MOSIP K8s cluster for production environment. We could not find the db_scripts repo/folder for importing the data into the database and also creating users. Could you please share us the relevant link for the SQL scripts for proceeding with the setup?

FYI…this is the repo URL which we found in the MOSIP official collection. But we are not able to find the proper structure of SQL files for each module for the external Postgres database setup.

Repo URL: GitHub - mosip/commons: This repository contains common utilities and services used by other MOSIP modules
Branch: Master

Could you please help us with this and guide to do the same?

Thanks & Regards
Naveen

sanchi-singh24 · December 21, 2023, 9:35am

Hi @reddi3

Thank you for reaching out about the SQL scripts for setting up an external PostgreSQL database for MOSIP K8s in production.

Regarding your specific questions: - One of our team members will look into this asap and provide you the proper structure of SQL files. May I consider you are looking at all platform modules of MOSIP?

We apologize for any inconvenience caused by the location of the SQL scripts. We strive to continuously improve our documentation and resource accessibility for future releases.

Best Regards,
Team MOSIP

reddi3 · December 21, 2023, 9:52am

Hi Sanchi,

Thanks for the quick response. Yes we are looking for SQL files for all platform modules of MOSIP and also the scripts for creating the database users for each service.

Thanks & Regards
Reddi Naveen

sanchi-singh24 · December 21, 2023, 1:45pm

Thanks, @reddi3 for the clarification. Our team will provide you with the details.

ckm007 · December 25, 2023, 7:27am

@reddi3 check below postgres init helm chart values for detailed list of DB’s with the repo where its sql files are present.
Please use your respective branch/tag

github.com

mosip/mosip-helm/blob/1.2.0.1/charts/postgres-init/values.yaml#L91


      
            dbuserPassword: ""
          
          ## Superuser secret is required to setup DB. It is assumed that the secret was created while creating
          ## DB server(s) and is available in the same namespace.
          ## host: It could be in-cluster service name of postgres if running as pods inside cluster.
          ## su.user: Assumed 'postgres'. Change manually if you have given a different postgres superuser name
          ## su.secret.name: Default name 'postgres-postgresql' if you install bitnami postgres within cluster.
          ## su.secret.key: Default key 'postgres-password' if you install bitnami postgres within cluster.
          ## dml: whether dml is available to be loaded 0/1. Refer SQL scripts in module repos.
          
          databases:
            mosip_master:
              enabled: true
              host: "postgres-postgresql"
              port: 5432
              su:
                user: postgres
                secret:
                  name: postgres-postgresql
                  key: postgres-password
              dml: 0

Best regards
Team MOSIP

Topic		Replies	Views
Mosip deployment	13	450	January 8, 2024
Installation issues Developer	6	271	November 16, 2023
Where is the documentation to start setting up MOSIP on local machine Developer	6	325	October 27, 2023
Failure downloading Prostgre SQL - HTTP Error 404: Not Found Developer pre-registration	3	187	December 11, 2023
Seeking MOSIP demo server Support	5	266	October 11, 2023

Regarding External Database Setup For MOSIP

Related topics