Question Good day,
1. I have managed to download the CIEL/MVP dictionary from Andrew Kanter DropBox and I need to import this into the Meta Data Sharing module where I am selecting Import and nothing seems to be importing. I get the error An Internal Error has Occurredjava.lang.NullPointerException
2. I need to import these concepts into HTML forms , how do I go about it?
3. Also, with my standalone installation, it seems its not pointing to MySQL, how do I check this, and how do make that the openmrs database is created, and Tomcat. One thing that I have seen is if I unzip the folder and run the openmrs-standalone.jar file from any machine , it seems to be running , but not creating the database .
Cheten, I think folks might need more information than just the null pointer exception (like the log). So you were able to properly run the SQL but then failed when you tried to run MDS? There were some content issues with a few duplicate names but I have never heard that it failed right off the bat like that.
@chetenm, please see the “Importing the Dictionary” section of this page. Basically, what you got from dropbox is a zipped sql script, and you need to run this against your database.
Unfortunately that wiki page has some out of date content, and the bit mentioned at “Getting updates for the dictionary (to be available in the future)” does not actually work. (It seems like this is what you’re trying to do.)
@raff, would you mind doing a quick pass through that wiki page any removing anything that’s no longer relevant at all (e.g. the Concept Subscribing module workflow).?
@darius, Thank you.
Secondly, I need to view these existing concepts in HTML form entry , and call forms when e.g doing registration or Admit patient , depending on the task that I will be performing at that time.
Thirdly, with my standalone installation, it seems its not pointing to MySQL, and no OpenMRS database is created.
When I tried to open the concept sql file, it says it’s not connected. how do I check this, and how do make sure that the openmrs database is created. One thing that I have seen is if I unzip the folder and run the openmrs-standalone.jar file from any machine , it seems to be running , but not creating the database .
So, how do I know that the OpenMRS database is created. If i check via MySQL workbench on Mac , there is no OpenMRS database created.
I think this would require a new subject line as I don’t think the standalone folks would know that you are having an issue. Perhaps @dkayiwa could help.
@dkayiwa, I have had looked at this . Seems the openmrs database is not created.
Chetens-MacBook-Pro:database cheten$ cd bin
Chetens-MacBook-Pro:bin cheten$ ls
mysql mysql.exe mysqld mysqld.exe
Chetens-MacBook-Pro:bin cheten$ ./mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34
Server version: 5.6.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.04 sec)
mysql> exit;
Bye
Chetens-MacBook-Pro:bin cheten$ ./mysql -u openmrs -p
Enter password:
ERROR 1045 (28000): Access denied for user 'openmrs'@'localhost' (using password: YES)
Chetens-MacBook-Pro:bin cheten$ ./mysql -u openmrs -p
Enter password:
ERROR 1045 (28000): Access denied for user 'openmrs'@'localhost' (using password: YES)
Chetens-MacBook-Pro:bin cheten$
Remember that the standalone creates its own mysql database and not the one that comes standard on the Mac. You should be sure you are using the connect string from the properties file and not JUST the user and password.
@dkayiwa, I have done this command , and below are the errors.
Chetens-MacBook-Pro:openmrs-standalone-2.2 cheten$ java -jar openmrs-standalone.jar
Attempting to load properties file in current directory: openmrs-standalone-runtime.properties
Using runtime properties file: openmrs-standalone-runtime.properties
Attempting to load properties file in current directory: openmrs-standalone-runtime.properties
Using runtime properties file: openmrs-standalone-runtime.properties
Attempting to load properties file in current directory: openmrs-standalone-runtime.properties
Using runtime properties file: openmrs-standalone-runtime.properties
Exception: java.lang.Error thrown from the UncaughtExceptionHandler in thread "reportingRestTimerFactory-1"
Exception: java.lang.Error thrown from the UncaughtExceptionHandler in thread "reportingTimerFactory-1"
Exception: java.lang.Error thrown from the UncaughtExceptionHandler in thread "idgenTimerFactory-1"
Exit:0
[MysqldResource] Mysqld not running. No file: /Users/cheten/OpenMRS/openmrs-standalone-2.2/database/data/MysqldResource.pid
Chetens-MacBook-Pro:openmrs-standalone-2.2 cheten$