B4J Question jRDC2 server and mysql port?

Binary Soft

Member
Licensed User
Hello,

I tested jRDC2 server and client app, everything is ok.
Now I change mysql server port 3306 to other eg. 3300.
My jRDC2 Server can not connect with mysql.

How can I change jRDC2 to connect mysql.
(*** not ServerPort = xxxxx in config.properties for client)

Thanks.
 

José J. Aguilar

Well-Known Member
Licensed User
You must change the server port in config properties of jRDC2 server. Remenber that jRDC2 is a middleware server, are not your clients who connect to mysql, but jRDC2.
Your clients must connect to jRDC2 port, not to mysql port.
 

Binary Soft

Member
Licensed User
You must change the server port in config properties of jRDC2 server. Remenber that jRDC2 is a middleware server, are not your clients who connect to mysql, but jRDC2.
Your clients must connect to jRDC2 port, not to mysql port.
mysql server use other port 3001 (not use default 3306).
jRDC2 server can not connect to mysql as follow:
in browser
xxx.xxx.xxx:17170/test
Error fetching connection

when I change mysql to default 3306 port,
jRDC2 server is connect successfully as follow:

RemoteServer is running (03/06/2019 03:50:00)
Connection successful.

I have to use my sqlserver on port 3301 for other app and web.
 
Last edited:

BillMeyer

Well-Known Member
Licensed User
The MySQL port should be set inside the JdbcURL value.
Ha - Thought so - but was not sure - so I did not answer.

So it should look like this: (In the config.properties file) if i am correct ?

JdbcUrl=jdbc:mysql://xxx.xxx.xxx.xxx:3001/n7tc?characterEncoding=utf8
 
Top