Hi Viktor,
I am new to Open EMR, we have installed AWS cloud Express version of Open EMR and I trying hard to locate where my DB is for this OpenEMR.
Can you kindly assist me locate the same please.
OpenEMR Cloud Express Version
I’m using OpenEMR version 7.0.0
Browser:
Google Chrome
Operating System
Ubuntu 20.04
Your help will be much appreciated.
Hi Ayesha.
I am not familiar with AWS cloud Express version. I am using regular 7.0 version on Ubuntu server. In order to export the database file from the mysql I use PHPmyAdmin platform. In Ubuntu the MySQL files are stored by default in var/lib/mysql fouler.
Hi @AyeshaMuss
Note: Probably recommended to start a new thread for your issue.
I believe the Express deployment is an EC2 instance running the OpenEMR application and DB as containers with Docker.
If you logon to the EC2 instance via SSH you should be able to see the DB container running with some simple Docker commands.
Hi Dave,
You are right.
Its on EC2, I am unable to hop on not sure but tried to follow the documentation but in vain.
Any guidance will be helpful.
Regards,
Ayesha
@AyeshaMuss - To ensure you can logon to the EC2 instance make sure you’ve got the below covered:
You’ll need to ensure you have a Security Group rule allowing SSH to your instance (AWS console) from your IP.
Depending on if your running Windows or MacOS/Linux locally will determine how you connect via SSH to your EC2 instance.
Curious, what are you looking to do when you get access to the DB?
Hi Dave,
Yes I have tried the Putty way to connect to EC2 system.
My system runs on Win 11 so opted for Putty.
I am interested to view the DB for OpenEMR the one I am configuring for my trial and would like to integrate using Mirth as a connector.
Can you please kindly assist me on this.
Kind Regards,
Ayesha
Steps below should give you access to the DB container:
$ docker ps
$ docker exec -it YOURSQLCONTAINERNAME bash
Hi Dave,
Thanks for your response.
I tried the above commands as stated but it says command not found please see the screeenshot below
Try it without the $ character.
Hi Dave,
I tried it gives Authorization denied.
Regards,
Ayesha
Try it with sudo.
Ex. sudo docker ps
Note: I think your best bet here to be successful going forward is it to take a little bit of time to get up to speed on docker and containers.
Then you can run OpenEMR with Docker locally in order to test the Mirth integration configuration.
From there you can easily migrate to a production deployment.
Hi Dave,
You mean install the Standard version of OpenEMR in AWS ???
We tried that but we do not see available in the UAE region. Please find the screenshot below.
can you please let us know if there is a way to enable so we could use the same in UAE.
Kind Regards,
Ayesha
Yayyyyyyyyyyy Dave atleast i am happy your command gave me an o/p
sudo docker ps
CONTAINER ID IMAGE COMMAND CREATE D STATUS PORTS NAMES
c38524ea3cdc openemr/openemr:7.0.0 “./openemr.sh” 2 mont hs ago Up 2 days 0.0.0.0:80->80/tcp, :::80->80/tcp, 0.0.0.0:443->443/tcp, :: :443->443/tcp lightsail_openemr_1
20b0878cf055 openemr/mysql-xtrabackup:latest “docker-entrypoint.s…” 2 mont hs ago Up 2 days 3306/tcp lightsail_mysql_1
THANK YOU DAVE.
Have to figure out what it all means 
Hi Dave,
I figured out the above o/p:
Now challenge is how to access the sql with this data any light please
@AyeshaMuss - after running docker ps and getting the container ID and/or name, you can use the exec command to open an interactive shell to the target container.
Example: sudo docker exec -it 20b0878cf055 /bin/bash
Some docs that may be helpful:
In regards to running OpenEMR locally, I didn’t mean on AWS, I meant right on your laptop/workstation with docker for a more efficient development environment. This way you can skip the SSH to the cloud instance step, and simply work with the container on your local workstation.
Some docs:
Hi Dave,
This is awesome information. It’s an ocean of knowledge for me at the moment.
Let me thrive and see where I reach and will come back to you in case I fall apart.
Thank you so much for keeping me guided.
Appreciate much !!!
Thanks,
Ayesha
HELLO Dave,
I am so happy to come back sharing my learnings with you
Thank you for all your guidance.
I did a bit of learning on Linux, docker and I could use the same on the box and extracted the DB
mysql> SHOW TABLES;
±--------------------------------------+
| Tables_in_openemr |
±--------------------------------------+
| addresses |
| amc_misc_data |
| amendments |
| amendments_history |
| api_log |
| api_refresh_token |
| api_token |
| ar_activity |
| ar_session |
| audit_details |
| audit_master |
| automatic_notification |
| background_services |
| batchcom |
| benefit_eligibility |
| billing |
| calendar_external |
| categories |
| categories_seq |
| categories_to_documents |
| ccda |
| ccda_components |
| ccda_field_mapping |
| ccda_sections |
| ccda_table_mapping |
| chart_tracker |
| claims |
| clinical_plans |
| clinical_plans_rules |
| clinical_rules |
| clinical_rules_log |
| code_types |
| codes |
| codes_history |
| contact |
| contact_address |
| customlists |
| dated_reminders |
| dated_reminders_link |
| direct_message_log |
| document_template_profiles |
| document_templates |
| documents |
| documents_legal_categories |
| documents_legal_detail |
| documents_legal_master |
| drug_inventory |
| drug_sales |
| drug_templates |
| drugs |
| eligibility_verification |
| employer_data |
| enc_category_map |
| erx_narcotics |
| erx_rx_log |
| erx_ttl_touch |
| erx_weno_drugs |
| esign_signatures |
| export_job |
| extended_log |
| external_encounters |
| external_procedures |
| facility |
| facility_user_ids |
| fee_sheet_options |
| form_care_plan |
| form_clinical_instructions |
| form_clinical_notes |
| form_dictation |
| form_encounter |
| form_eye_acuity |
| form_eye_antseg |
| form_eye_base |
| form_eye_biometrics |
| form_eye_external |
| form_eye_hpi |
| form_eye_locking |
| form_eye_mag_dispense |
| form_eye_mag_impplan |
| form_eye_mag_orders |
| form_eye_mag_prefs |
| form_eye_mag_wearing |
| form_eye_neuro |
| form_eye_postseg |
| form_eye_refraction |
| form_eye_ros |
| form_eye_vitals |
| form_functional_cognitive_status |
| form_group_attendance |
| form_groups_encounter |
| form_misc_billing_options |
| form_observation |
| form_reviewofs |
| form_ros |
| form_soap |
| form_taskman |
| form_vital_details |
| form_vitals |
| forms |
| gacl_acl |
| gacl_acl_sections |
| gacl_acl_seq |
| gacl_aco |
| gacl_aco_map |
| gacl_aco_sections |
| gacl_aco_sections_seq |
| gacl_aco_seq |
| gacl_aro |
| gacl_aro_groups |
| gacl_aro_groups_id_seq |
| gacl_aro_groups_map |
| gacl_aro_map |
| gacl_aro_sections |
| gacl_aro_sections_seq |
| gacl_aro_seq |
| gacl_axo |
| gacl_axo_groups |
| gacl_axo_groups_map |
| gacl_axo_map |
| gacl_axo_sections |
| gacl_groups_aro_map |
| gacl_groups_axo_map |
| gacl_phpgacl |
| globals |
| gprelations |
| groups |
| history_data |
| icd10_dx_order_code |
| icd10_gem_dx_10_9 |
| icd10_gem_dx_9_10 |
| icd10_gem_pcs_10_9 |
| icd10_gem_pcs_9_10 |
| icd10_pcs_order_code |
| icd10_reimbr_dx_9_10 |
| icd10_reimbr_pcs_9_10 |
| icd9_dx_code |
| icd9_dx_long_code |
| icd9_sg_code |
| icd9_sg_long_code |
| immunization_observation |
| immunizations |
| insurance_companies |
| insurance_data |
| insurance_numbers |
| insurance_type_codes |
| issue_encounter |
| issue_types |
| jwt_grant_history |
| keys |
| lang_constants |
| lang_custom |
| lang_definitions |
| lang_languages |
| layout_group_properties |
| layout_options |
| lbf_data |
| lbt_data |
| list_options |
| lists |
| lists_medication |
| lists_touch |
| log |
| log_comment_encrypt |
| login_mfa_registrations |
| medex_icons |
| medex_outgoing |
| medex_prefs |
| medex_recalls |
| misc_address_book |
| module_acl_group_settings |
| module_acl_sections |
| module_acl_user_settings |
| module_configuration |
| modules |
| modules_hooks_settings |
| modules_settings |
| multiple_db |
| notes |
| notification_log |
| notification_settings |
| oauth_clients |
| oauth_trusted_user |
| onotes |
| onsite_documents |
| onsite_mail |
| onsite_messages |
| onsite_online |
| onsite_portal_activity |
| onsite_signatures |
| openemr_module_vars |
| openemr_modules |
| openemr_postcalendar_categories |
| openemr_postcalendar_events |
| patient_access_onsite |
| patient_birthday_alert |
| patient_data |
| patient_history |
| patient_portal_menu |
| patient_reminders |
| patient_tracker |
| patient_tracker_element |
| payment_gateway_details |
| payment_processing_audit |
| payments |
| pharmacies |
| phone_numbers |
| pnotes |
| prescriptions |
| prices |
| pro_assessments |
| procedure_answers |
| procedure_order |
| procedure_order_code |
| procedure_providers |
| procedure_questions |
| procedure_report |
| procedure_result |
| procedure_type |
| product_registration |
| product_warehouse |
| registry |
| report_itemized |
| report_results |
| rule_action |
| rule_action_item |
| rule_filter |
| rule_patient_data |
| rule_reminder |
| rule_target |
| sequences |
| session_tracker |
| shared_attributes |
| standardized_tables_track |
| supported_external_dataloads |
| syndromic_surveillance |
| template_users |
| therapy_groups |
| therapy_groups_counselors |
| therapy_groups_participant_attendance |
| therapy_groups_participants |
| transactions |
| user_settings |
| users |
| users_facility |
| users_secure |
| uuid_mapping |
| uuid_registry |
| valueset |
| valueset_oid |
| verify_email |
| version |
| voids |
| x12_partners |
| x12_remote_tracker |
| xtradb_backups |
±--------------------------------------+
255 rows in set (0.18 sec)
woooooooowwwwwwwwwww
Just wanted to share my findings.
Best Regards,
Ayesha
