This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Port forwarding

Dear community,

I have 2 different databases on our network I want to be accessible remotely to staff once they are out of the hospital. The first one A is running on IP 192.168.1.A , the other is B at 192.168.1.B and my public IP is 160.242.143.153. I have gone ahead to have a address point to these respectful IPs say database1.ug and database2.ug so users dont have to worry about remembering the IP addresses to get to these databases.

Can someone assist me how to configure my firewall and DNAT to accept access to these database while away from the hospital.

Thanks and regards

Brian

This thread was automatically locked due to age.

Parents

0 PatrickLee over 7 years ago

Network Protection / NAT / New NAT Rule

For traffic from: Any

Using service: create new service definition pointing to port#

Going to: External (WAN)

Change the destination to: database1.ug or database2.ug

Automatic firewall rule: check

Hope that helps
Cancel
Vote Up 0 Vote Down

Cancel
0 BrianKaaya over 7 years ago in reply to PatrickLee
Thanks you PatricLee

The thing is I need to use this rule for 2 databases simultaneously at any time. One database uses numerous ports

openmrs_port: 8050

bahmni_reports_port: 8051

bahmni_lab_port: 8052

bahmni_erp_connect_port: 8053

pacs_integration_port: 8054

openerp_port: 8069

dchm4chee_ports: 8055, 8056

event_log_service_port: 8057

and the other has apache running ports 80,443; tomcat 8080 so I am very confused which to run where exactly.
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 BrianKaaya over 7 years ago in reply to PatrickLee
Thanks you PatricLee

The thing is I need to use this rule for 2 databases simultaneously at any time. One database uses numerous ports

openmrs_port: 8050

bahmni_reports_port: 8051

bahmni_lab_port: 8052

bahmni_erp_connect_port: 8053

pacs_integration_port: 8054

openerp_port: 8069

dchm4chee_ports: 8055, 8056

event_log_service_port: 8057

and the other has apache running ports 80,443; tomcat 8080 so I am very confused which to run where exactly.
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 sachingurung over 7 years ago in reply to BrianKaaya

Hi Brian,

As suggested b PatricLee follow the same steps and add a custom service definition which consists of all the ports you need to forward.

Thanks

Sachin Gurung
Team Lead | Sophos Technical Support
Knowledge Base | @SophosSupport | Video tutorials
Remember to like a post. If a post (on a question thread) solves your question use the 'This helped me' link.
Cancel
Vote Up 0 Vote Down

Cancel
0 BrianKaaya over 7 years ago in reply to sachingurung

Dear Sachingurung,

Thank you for your note. I have actually tried and been successful with the advice from PatrickLee but that gets me to view only one of the databases. I would love some help on how to actually do this step by step as I have failed otherwise.
Cancel
Vote Up 0 Vote Down

Cancel
0 PatrickLee over 7 years ago in reply to BrianKaaya

create new service definition

Name: whatever you want for ex. Database Protocol

Type of definition: UDP/TCP

Destination port: 8050:8069

Source port: 1:65535

Comment: Use for Database

Put the new service definition in your DNAT rule
Cancel
Vote Up 0 Vote Down

Cancel
0 ToddCooper over 7 years ago in reply to PatrickLee

Hello Brian, Since you have one successfully gained access to one database by creating the needed configuration, it should be possible for you to use the "clone" feature for each part of your configuration. Changing the IP addresses and descriptions accordingly, then save and test?
Cancel
Vote Up 0 Vote Down

Cancel