Question Open port in firewall for just one subdomain und redirect it

[Holger]

Hi,
my server details: CentOS 6.10, Plesk Onyx 17.8.11

I want to realize the following scenario:
1. Open a special port (e.g. 12345) in the (plesk) firewall for just one subdomain (e.g. mysub.domain.com)
2. Redirect this port to mysql-port 3306 on my plesk server

Background:
We've a special local application which uses a local mysq-db with a hardcoded port (e.g. 12345). I just can change the db-hostname, so I want to setup a "backup-mysql-server" on my plesk-server.
I can't change the usual mysql-port 3306 on my plesk server, because of several other applications.

thanks for any hints.
Holger

 

[khoubeib bach]

hi, I didn't get it, why opening for a specific domain.
If you want to farward 12345 -> 3306 you shoul do it on iptables !!?
request from outside on port 12345 -> 3306 -> check credential (MySQL side) : OK -> reply
check this link and please if you work on production env, consider to test on preprod one :
Port Forwarding Using iptables - SysTutorials