Demo Data

The first time I tried to import this demo data, I got an error related to the patientflags_tag_displaypoint table. I don't remember exactly what the error was. For my database that table was empty, so I dropped it and then was able to import the demo data file with no problems.

Hi Mike,

Thanks for working on this, I thought we want to have demo data not to specify a db, i.e a user should be able to import it into any db named anything else besides openmrs without having to edit anything in the script.

Ah! ok, I will try to edit the script later today

I did a successful install of OpenMRS 1.9.3 Enterprise WAR Package version with the initial demo data, with java version 1.7.0_03, tomcat 6.0.35 and mysql 5.5.31 on Ubuntu Server 12.04.2 LTS.

mysql> SELECT username FROM users;

+----------+

| username |

+----------+

|                |

| daemon |

+----------+

2 rows in set (0.01 sec)

mysql> SELECT system_id FROM users;

+-----------+

| system_id |

+-----------+

| admin |

| daemon |

+-----------+

2 rows in set (0.00 sec)

mysql> SELECT given_name, COUNT(*) FROM person_name;

+------------+----------+

| given_name | COUNT(*) |

+------------+----------+

| Horatio | 3 |

+------------+----------+

1 row in set (0.00 sec)

I was able to login with the admin account and browse around.

Then i decided to download and load demo-data into mysql

org.openmrs.module.ModuleException: Unable to start OpenMRS. Error thrown was: Should not be here because updates were run previously.

To finally get OpenMRS 1.9.3 war package going with demo data demo-1.9.0.sql, with java version 1.7.0_03, tomcat 6.0.35 and mysql 5.5.31 on Ubuntu Server 12.04.2 LTS, i had to approach the

installation like an upgrade. I am not sure if this is what i should have done initially, but i did not see instruction as to whether or not.

1.  Undeploy OpenMRS if already running
2. Remove the previous openmrs-runtime-properties file, and ther files and folders in /usr/share/tomcat6/.OpenMRS
3. Create a new openmrs database
   mysql -u -p;
   mysql> CREATE DATABASE openmrs;
4. load the demo-data, source demo-1.9.0.sql
   mysql> use openmrs;
   mysql> source /home/jawara/mysql/demo-data/demo-1.9.0.sql
5. Deploy openmrs in tomcatWeb Application Manager
6. Open web browser and go to openmrs url to start the initial setup.
   http://xxxx:8080/openmrs

Initial set up options:

• English
• Advanced
  Step 1 of 5
• Set Database connection and Yes then set Database name
  Step 2 of 5
• No, No, Yes then set Username and Password
  Step 3 of 5
• Yes, Yes
  Step 4 of 5
  Step 5 of 5
• Set information
• Overview of settings
• Task to execute; Update the database

## Errors

A core module failed to start, 'core'

Solution:

Restarted tomcat and Retried the install set up options process

http://xxxx:8080/openmrs

When installing this demo data, the initial password for the user 'admin' is 'test'. You should change the password after installing the demo data.

## Error

At this point i was unable to login, the default credentials did not work.

Solution:

Reset forgotten admin password from openmrs-guide.pdf.

SELECT DATABASE()

mysql> SELECT user_id,system_id,username FROM users;

+---------+-----------+----------+

| user_id | system_id | username |

+---------+-----------+----------+

| 1 | admin | NULL |

| 2 | daemon | daemon |

+---------+-----------+----------+

2 rows in set (0.00 sec)

mysql> SELECT username FROM users WHERE user_id = 1;

mysql> SELECT username FROM users WHERE system_id = 'admin';

+----------+

| username |

+----------+

| NULL |

+----------+

1 row in set (0.01 sec)

MySQL UPDATE command:

### admin username

mysql> UPDATE users SET username = 'admin' WHERE system_id = 'admin';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT user_id,system_id,username FROM users WHERE system_id = 'admin';

+---------+-----------+----------+

| user_id | system_id | username |

+---------+-----------+----------+

| 1 | admin | admin |

+---------+-----------+----------+

1 row in set (0.01 sec)

### password

mysql> UPDATE users SET password = '4a1750c8607d0fa237de36c6305715c223415189' WHERE system_id = 'admin';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT user_id,system_id,username,password FROM users WHERE system_id = 'admin';

+---------+-----------+----------+------------------------------------------+

| user_id | system_id | username | password |

+---------+-----------+----------+------------------------------------------+

| 1 | admin | admin | 4a1750c8607d0fa237de36c6305715c223415189 |

+---------+-----------+----------+------------------------------------------+

1 row in set (0.00 sec)

### salt

mysql> UPDATE users SET salt = 'c788c6ad82a157b712392ca695dfcf2eed193d7f' WHERE system_id = 'admin';

Query OK, 1 row affected (0.01 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT user_id,system_id,username,salt FROM users WHERE system_id = 'admin';

+---------+-----------+----------+------------------------------------------+

| user_id | system_id | username | salt |

+---------+-----------+----------+------------------------------------------+

| 1 | admin | admin | c788c6ad82a157b712392ca695dfcf2eed193d7f |

+---------+-----------+----------+------------------------------------------+

1 row in set (0.01 sec)

##### Launch OpenMRS

http://xxxx.xxx.xxx.xxx:8080/openmrs/

admin/test

There was an error starting the module: Logic Module ('Reading' this alert 'reads' it for all recipients)

You have <span id="unreadAlertSize">1</span> unread alert You have 1 unread alert

So far seems to be working  fine.

There is one thing that needs to be changed. I created a new database (given it another name other openmrs) and when I ran "source demo_file.sql" I noticed it dropped and created a new database using name "openmrs". I think this is not good because I actually already had another database by the same name. This is not desirable at all. The script should not assume that people do not have openmrs already. Imagine the frustration having your database dropped when you need it the most!!

Note: I ran into this using demo.1.9.0.zip file.

Definitely agree with Ahmed.

I just installed OpenEMR to be able to use openMRS.  During openemr install i chose to name the database openmrs.  All the login configuration is setup with that.

Then source demo-1.10.0.sql blew it away and when I login i get 

Failure during database access! Check server error log