B4J Question JRDC2 - Access through 2 ports (17178 and 17179)

[LGS]

Hello everyone.
I need to connect to 2 databases, so I need to use 2 ports using JRDC2.
Currently I can run JRDC2 without any problem using port 17178, but not with port 17179.

On the firewall - Inbound Rules
Specific ports(17179,17178)

config.properties:
DriverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
JdbcUrl=jdbc:sqlserver://localhost:1433;databaseName=Data;encrypt=false;trustServerCertificate=true
User=usr
Password=123
ServerPort=17179

What did I forget to configure?
Please can someone give me a hint?

I appreciate your help
Luis

 

[EnriqueGonzalez]

do you have any error showing up?

 

[LGS]

Hello, Enrique
No, no error appears

 

[LGS]

The connection runs Locally
http://localhost:17179/test

But not with the public IP
http://xx.xxx.xxx.xx:17179/test

 

[OliverA]

Out of the box (using jRDC2 code unmodified), jRDC2 needs to be recompiled and redeployed after making changes to config.properties.

1) If you want two ports, change config.propeeties to the first port. Compile. Move resulting *.jar file to different folder and run. Next change config.properties to second port, compile and move resulting *.jar file to another location.

2) Modify jRDC2 to use an external config.properties file. Compile and deploy *.jar file in separate folders to use external config.properties (each having unique port #)

 

[OliverA]

But not with the public IP
http://xx.xxx.xxx.xx:17179/tes

Ugh, Ninja'd. Is that the public IP address of your router? Your PC? If router, then you need to enable port forwarding. Note that some ISPs use private IP numbers and port forwarding may not work (if your router sees the public IP address and it's not a private IP address, you should be good to go with port forwarding. Unless you ISP blocks ports...)

 

[LGS]

I understand what you indicate.
But currently I am only executing and compiling a single JRDC2 project using port 17179, and the detail is that the connection is not accessible from outside, only locally through that port.
Apart from the fact that I need to use 2 ports, and only using port 17179, I can't connect from outside.
My question is, why can't I use port 17179 externally?

 

[OliverA]

accessible from outside,

What is outside? Are you trying to connect to the server via local network? WiFi? The Internet? Each of these scenarios can have its own issues / solutions.

 

[LGS]

I´m trying to conenect via Internet
Through port 17178 I can connect via the Internet without problem

But using port 17179 no
This is the point, why 17178 Yes and 17179 No

 

[OliverA]

Is the computer that jRDC2 runs on directly connected to the internet? Or is there a router? If there is a router, is it configured to port forward 17179?

 

[aeric]

I need to connect to 2 databases, so I need to use 2 ports using JRDC2

You don't need 2 ports to connect to 2 or more databases.

https://www.b4x.com/android/forum/t...rt-or-2-jrdc2-server-with-1-port-each.143902/

https://www.b4x.com/android/forum/threads/mysql-connector-for-b4i.116617/#post-729095

https://www.b4x.com/android/forum/t...e-for-jrdc2-multi-to-work.134010/#post-847620

 

[LGS]

Is the computer that jRDC2 runs on directly connected to the internet? Or is there a router? If there is a router, is it configured to port forward 17179?

The computer that jRDC2 runs on directly connected to the internet

 

[LGS]

You don't need 2 ports to connect to 2 or more databases.

https://www.b4x.com/android/forum/t...rt-or-2-jrdc2-server-with-1-port-each.143902/

https://www.b4x.com/android/forum/threads/mysql-connector-for-b4i.116617/#post-729095

https://www.b4x.com/android/forum/t...e-for-jrdc2-multi-to-work.134010/#post-847620

Aeric, thanks for the info.
I will read it.
However, this inconvenience of not being able to use another port (17179) I would like to solve it as knowledge...

 

[OliverA]

In a command prompt type

netstat -a -n -o | find "0.0.0.0:171"

Too see if the port is bound properly

 

[LGS]

 

[OliverA]

Run the jrdc2 that's bound to 17179. See if you can access it locally. Check it's logs to make sure it's bound to 0.0.0.0:17179. Check netstat and see it it sees the binding. If you run jrdc2 from the ide, the logging you need to check is in red.

 

[OliverA]

You can also do a

netstat -a -n -o | find "1717"

To check all interfaces for a binding

 

[LGS]

I can connect locally using port 17179

netstat:

 

[OliverA]

If you still don't have access, then you need to enable firewall logging to see if it blocks the call. If the firewall does not block/pass the call, then something strange going on with your ISP.

 

[LGS]