Wiki Spaces

Documentation
Projects
Resources

Get Help from Others

Q&A: Ask OpenMRS
Discussion: OpenMRS Talk
Real-Time: IRC Chat | Slack

Documentation

Page tree
Skip to end of metadata
Go to start of metadata

MySQL Database Engine

Be sure the MySQL database engine is running first.

If MySQL is not running, the following messages may appear on OpenMRS console log as well as in the Tomcat log file:

org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'messageSourceServiceTarget' defined in class path resource applicationContext-service.xml: :
..........
followed by stack trace

These errors may be related to MySQL Database startup.

MySQL Version

There are multiple different versions of MySQL provided with the link given in the developer’s guide. It could be confusing for new developers.

The easiest way is to download using apt.

Be sure to download MySQL server instead of MySQL client.

War file deploys in Tomcat but it won't start OpenMRS

Try this:

  • Go to MySQL command line (accessible from Start menu)
  • Type the following lines and press Enter after each one:

    use OpenMRS;
    create user openmrs identified by 'PASSWORD';
    GRANT ALL ON openmrs.* TO 'openmrs'@'%';
    
  • Go to C:\Documents and Settings\LocalService\Application Data\OpenMRS
  • There should be a file there called OPENMRS-runtime.properties
  • In this file, ensure it says the following:

    ### Database connection properties
    connection.username=openmrs
    connection.password=openmrs
    
  • Copy the file into C:\Documents and Settings\YOURUSERNAME\Application Data\OpenMRS where YOURUSERNAME is the name you use to log in to windows. This is in case Tomcat looks there instead of in LocalService.

Where to find your openmrs-runtime.properties

Windows XP

  • Under C:\Documents and Settings\YOURUSERNAME\Application Data\OpenMRS
  • Under C:\Windows\system32\config\systemprofile\Application Data\OpenMRS

Windows 7

  • Under C:\Users\YOURUSERNAME\AppData\Roaming\OpenMRS

Ubuntu

  • Under /home/YOURUSERNAME/.OpenMRS
  • Under /usr/share/tomcatX/.OpenMRS

Troubleshooting Tomcat

For more troubleshooting tips see Troubleshooting Tomcat.

Legacy-UI

  1. Download the newest version of legacy UI.
  2. Find the legacy-version-SNAPSHOT.omod file
  3. Put it into the hidden folder ~/.OpenMRS/modules.
  4. Be sure to kill the previous operations running the webapp.
  5. Clear the browser cache.

  6. Rerun the webapp using command:
            mvn jetty:run


Running Maven

The time taken for maven to compile could vary for different computers.

Kill the previous mvn clean install or mvn jetty: run every time you rerun maven. Otherwise, it might gives a following error indicating address already in use.

 

 

HTTP 500 error

After opening http://localhost:8080/openmrs in the web browser, you might encounter the following error.

Close the window and kill the prior operations. 

 Rerun mvn jetty:run in the webapp folder and it usually works.


 

 


 

  • No labels

6 Comments

  1. Unknown User (anu)

    when i tries to open "openmrs" from the link present on the page

    "http://localhost:8080/manager/html", it gave an error

    "

    HTTP Status 404 - /openmrs/


    type Status report

    message /openmrs/

    description The requested resource (/openmrs/) is not available.

    i did all the settings given in this trouble shooting guide but nothing helped.

    can anybody please guide me on this?

    1. Unknown User (michael)

      Hi Anuprita. Have you followed the instructions described on the page Installing OpenMRS? If so, and you still have problems, please write to the implementers mailing list and describe the problem – someone should be able to help you work through it. Thanks!

  2. Unknown User (tharindu.rusira)

    Hi all, I'm trying to install OpenMRS-standalone version. I deployed the .war file correctly as instructed in one of the previous pages.

    I did not install mysql explicitly because I am running wamp server on my Windows machine.

    Whenever I try to install OpenMRS I get this error.

    ?Error executing sql: create database if not exists `?` default character set utf8 - Could not create connection to database server. Attempted reconnect 3 times. Giving up.?
    
    Unable to create the database. The password might be incorrect or the database is not started.
    

    According to the error message, it seems I've not provided my root password for MySQL but I have not set any password for root.

    Any help is appreciated.

    1. Unknown User (tstaake)

      I am getting the same error. I have set up a password for root in mySQL and am able to login to mySQL via terminal using:

      mysql -u root -p -h localhost;

      I should mention that I did have a DB installed and connected to previously but was having issues so I removed the DB and tried to reinitialize as outlined in Installation for Developers on Mac OS

      I installed mySQL via homebrew. 

      I am not seeing the ~/.OpenMRS directory either, I am assuming that is because this setup is what creates it. I do see this when I am trying to initialize:

       do i need to modify this to not be localhost as mentioned in: Installation for Developers on Mac OS?

  3. Unknown User (ayuk)

    hey Rusira i do not if you have found your answer but the root password field is required when doing the initial setup so if you do not have you need to set it for the setup to work nicely.if you are using xampp there is a script at /opt/lampp/lampp security.do this when you are rooted and follow the interactive program to guide you set those credentials up.then you can restart the initialsetup process.hope this helps someone.

  4. Unknown User (vundamat)

    I have installed OpenMRS standalone application. I tried connecting to mysql by doing the following (mentioned in the OpenMRS standalone documentation).:

    -Go to the extracted standalone database/bin folder and execute this at the commandline: ./mysql -u openmrs -p

    The problem is when I am tying the command : ./mysql -u openmrs -p

    it shows the following error

    ./mysql is not recognized as an internal or external command.

    I understand that this means that mysql did not get installed. But, it was mentioned in the documentation that OpenMRS standalone /application comes with embedded mysql.

    How can I resolve this?

    Thanks in advance!