Install wizard can't create profile file

No (I think) because I have not yet configured mySQL :stuck_out_tongue_winking_eye: on the new instance, but it seems to get past being upset about the profile file and no more errors are logged in catalina.out

In the browser I see:

**The following error occurred at startup:**

Unable to get a connection to the database. Please check your openmrs runtime properties file and make sure you have the correct connection.username and connection.password set

java.lang.Exception: Unable to get a connection to the database. Please check your openmrs runtime properties file and make sure you have the correct connection.username and connection.password set at org.openmrs.util.DatabaseUpdater.getLiquibase(DatabaseUpdater.java:398) at org.openmrs.util.DatabaseUpdater.getLiquibase(DatabaseUpdater.java:378)

Hey is this profile file OK? I gabbed it out of the wiki.

# OpenMRS Runtime Properties file
#
# (comments starting with a pound sign "#" are ignored)
 
### Database connection properties
connection.username=test
connection.password=test
connection.url=jdbc:mysql://localhost:3306/openmrs?autoReconnect=true
 
## If set to true, allows automatic database updates
#auto_update_database=true
 
# Allow/Disallow uploading of a module via the web
module.allow_web_admin=false
 
# If set to true, all patients will be names will be displayed as below
obscure_patients=false
obscure_patients.given_name=John
obscure_patients.middle_name=P.
obscure_patients.family_name=Smith
 
### Debugging options
hibernate.show_sql=false
 
### Customization Options
## If the custom setting is a folder, only files contained in the customization will be overwritten
#custom.images.dir=/myfolder/custom/images
#custom.template.dir=/myfolder/custom/template
#custom.style.css.file=/myfolder/custom/style.css
#custom.index.jsp.file=/myfolder/custom/index.jsp
#custom.login.jsp.file=/WEB-INF/view/login.jsp
#custom.messages=/myfolder/custom/messages.properties
#custom.messages_fr=/myfolder/custom/messages_fr.properties
#custom.patientDashboardForm.jsp.file=/WEB-INF/view/patientDashboardForm.jsp
 
### Other
## Set the directory that OpenMRS uses for its application data
## Will be used as base dir for modules, generated reports, etc
## Defaults to C:/Docs&Settings/username/Application Data/OpenMRS for windows
## Defaults to ~/.OpenMRS for *nix
## (As of build 1.2.0.3426)
# application_data_directory=/opt/openmrs
## Displays optional extra data in the Legacy UI admin screens footer,
## alongside OpenMRS version... etc.
## (As of Legacy UI module 1.7.0)
#legacyui.footer.extradata=Docker Image 45f156d
 
### Encryption Settings
## WARNING! Changing these values will cause all encrypted data to be invalidated!
## Randomly set upon fresh installation but not during upgrade process.
## OpenMRS built-in defaults are:
#encryption.vector=9wyBUNglFCRVSUhMfsTa3Q==
#encryption.key=dTfyELRrAICGDwzjHDjuhw==
 
# These properties are deprecated as of 1.7.0
#scheduler.username=admin
#scheduler.password=test~~~~

In the setup wizard, the first screen should be about selecting a language. The second screen is where you choose the setup type. Go for the first option which will only ask you for the mysql root password. The rest will be next, next …

I see that screen and select English, after that I get the error about not being able to create the profile.

Daniel I think the distillation is:

  • openmrs wakes up on new Debian system
  • when installed by tomcat looks for /var/lib/tomcat9/, dir exists but tomcat can’t write to it, noted in log, “falls back /var/lib”
  • looks for profile in /var/lib/OpenMRS/, directory does not exist

all’s cool still because wizard was not yet run, run wizard, answer prompt about language

  • logs show openmrs looking in same two places for profile file, tries to create it in non-existent /var/lib/OpenMRS/, tells the user it can’t proceed

Do you think you can get some time and we pair up through this at? https://www.uberconference.com/openmrs

yes, thanks Daniel, I’ll slack you to set up