Database remote connections error

[iozuniga]

Username:

TITLE

Database remote connections error

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Plesk Obsidian Web Admin Edition
Version 18.0.74 Update #3
localhost:3306 (default for MariaDB, v11.4.9)

PROBLEM DESCRIPTION

Only IPs under 'Allow remote connections from' section work correctly. A valid DNS value does not work.

Regards,

STEPS TO REPRODUCE

1. Select Databases
2. Choose one
3. Select 'user management'
4. Select any database user
5. On Access control, select 'Allow remote connections from'
6. Insert any valid DNS value which resolves correctly to an IP address
7. Click on 'Apply'

ACTUAL RESULT

Database not reachable from that IP address.
Error 1045 - Access denied por user ....

EXPECTED RESULT

Database reachable from that IP address

ANY ADDITIONAL INFORMATION

None

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[Sebahat.hadzhi]

Hello, @iozuniga . MariaDB performs a reverse DNS lookup (PTR) on the destination server IP address, rather than a forward DNS check. Thus, if there's no valid PTR record for the DNS value you are entering this is expected behavior.