Short Query - Possible Bug

For requests or help with our API
Post Reply
PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

Short Query - Possible Bug

Post by PBECKER » Tue Feb 22, 2022 10:11 am

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
Attachments
root.png
root.png (88.47 KiB) Viewed 2461 times
shortQuery.png
shortQuery.png (142.02 KiB) Viewed 2461 times

SLeon
Posts: 476
Joined: Mon Mar 01, 2021 10:00 am

Re: Short Query - Possible Bug

Post by SLeon » Tue Feb 22, 2022 11:28 am

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.

PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

Re: Short Query - Possible Bug

Post by PBECKER » Tue Feb 22, 2022 12:43 pm

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

SLeon
Posts: 476
Joined: Mon Mar 01, 2021 10:00 am

Re: Short Query - Possible Bug

Post by SLeon » Tue Feb 22, 2022 2:08 pm

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.

Post Reply