Open Dental

Jordan

Issue: When running the PUT short query against our development open dental database were able to issue the below "select database" with no issues. When we attempt to run the exact same short query against a production database we receive the below error message any ideas on why this may be occurring?

Error Message: "An SQL error occured: Authentication to host '192.168.XX.XX' for user '' using method 'mysql_native_password' failed with message: Access denied for user ''@'D1DS4613.SECRET.LOCAL' (using password: NO)"

Short Query:
{
"queryType": "SQL",
"SqlCommand": "SELECT DATABASE()"
}

Development Open Dental Version: 21.3.51
Production Open Dental Version: 21.3.35

This is the same issue described in https://www.opendentalsoft.com:8085/for ... ery#p34027 and is not a bug.

Please see the information regarding how our Queries methods considers SQL users in our documentation https://www.opendental.com/site/apiqueries.html.

Hello Sarah

We have gone ahead and checked out the below link and the OpenDentalEConnector.exe and also the opendental.exe are both on the same version which is 21.3.35.

Also noticed per Jordan's response in the thread that we should not have to modify any user mysql permissions.

Could we possibly hop on a call?

thank you so much Sarah

You will want to update to 21.3.51, as that is when we last updated how the Queries API methods handled the credentials in the OpenDentalWebConfig.xml file.