Connecting to various databases
Introduction
This page lists details on how to connect to various databases in Bahmni.
Bahmni comprises of different sub-components, like OpenMRS, OpenELIS, OpenERP/Odoo, Dcm4chee, PACS-Integration service, etc. Each component talks to its own database, which may be created within MySQL or Postgres. To see the contents of a particular database, you will need to use the right command line tool for MySQL or Postgres, and also appropriate credentials.
List of Application Databases
| Application | DB Server Type | Database Name | Connection Command | |
|---|---|---|---|---|
| 1. | OpenMRS (EMR) | MySQL | openmrs | bash mysql -uopenmrs-user -ppassword openmrs # For Bahmni 0.92 > mysql -uroot -pP@ssw0rd openmrs]]> |
| 2. | OpenELIS (Lab) | PostgreSQL | clinlims | psql -Uclinlims clinlims]]> |
| 3. | OpenERP/Odoo | PostgreSQL | openerp/odoo | psql -Uopenerp openerp OR > psql -Uodoo odoo]]> |
| 4. | dcm4chee | PostgreSQL | pacsdb | psql -Upostgres pacsdb]]> |
| 5. | PACS Integration Service | PostgreSQL | bahmni_pacs | psql -Upostgres bahmni_pacs]]> |
| 6. | Crater (Bahmni LITE) | MySQL | crater | mysql -ucrater -pcrater crater # connect to crater atomfeed db > mysql -ucrater_atomfeed_user -ppassw0rd crater_atomfeed]]> |
> mysql -uopenmrs-user -ppassword openmrs
# For Bahmni 0.92
> mysql -uroot -pP@ssw0rd openmrs> psql -Uclinlims clinlims> psql -Uopenerp openerp
OR
> psql -Uodoo odoo> psql -Upostgres pacsdb> psql -Upostgres bahmni_pacs# connect to crater db
> mysql -ucrater -pcrater crater
# connect to crater atomfeed db
> mysql -ucrater_atomfeed_user -ppassw0rd crater_atomfeed원문 정보
원문 보기 ↗Bahmni Wiki · CC BY-SA 4.0