Yes bro…two different users… root and openmrs-user
Yes… The default password created in the openmrs run-time-propertires for connecting to mysql… I had changed the password using normal sql user password changing method… But after that i cant able to take backup… I tried changing password directly in openmrs-runtime-properties also…But after that also,facing the same issue…
Im using Sdk…Version: 2.1.1 Build 725db5 IS using…
can you post your run-time properties here for the exact sdk server thats having issues ??
what do u mean two differet users?? a default user for openmrs and a root user for mysql??
@mithu please clarify which user password changes you mean here, it will be easier to understand what it is that is wrong and where the problem lies.
Users are “root” and “openmrs-user”
are those users accounts for mySQL??
its a matter of setting up your mysql , change the user passwords , and also reflect the same change in your openmrs run-time properties file
Example of run-time properties file
#Auto generated by OpenMRS initialization wizard #Tue Mar 05 15:01:15 EAT 2019 encryption.vector=4EjE8q/78ntmOJzwEdyGpA\=\= connection.url=jdbc\:mysql\://localhost\:3306/EmrApiTest3?autoReconnect\=true&sessionVariables\=default_storage_engine%3DInnoDB&useUnicode\=true&characterEncoding\=UTF-8 module.allow_web_admin=true connection.username=**USER** auto_update_database=false encryption.key=KijkSt2Apx1nDJHpJ3nw/A\=\= connection.driver_class=com.mysql.jdbc.Driver connection.password=**PASSWORD_YOU_SET_IN_mySQL
After changing my password it didnt reflected in this runtime properties… After i tried to change it manually…but same issue is there…it effects the backup…
no in the openmrs run-time properties file, it cant change automaticaly , you have to manually change it
take note of the exact user and corresponding password in your mySQL. put the same user and password in your run-time properties file
@mithu are you able to access your mysql database using your user and password?
I tried the same and the issue is still there…
Yes…I can able to access…
can you paste your server logs in pastebin and post the link here??
are you runing sdk?
yeah…im running sdk…
can you follow this on setting up the sdk https://wiki.openmrs.org/display/docs/OpenMRS+SDK