B4J Question jRDC2 server and mysql port?

Binary Soft

Member
Licensed User
Longtime 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.
 
Sort by date Sort by votes

josejad

Expert
Licensed User
Longtime 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.
 
Upvote 0

Binary Soft

Member
Licensed User
Longtime User
José J. Aguilar said:
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.
Click to expand...

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:
Upvote 0

BillMeyer

Well-Known Member
Licensed User
Longtime User
Erel said:
The MySQL port should be set inside the JdbcURL value.
Click to expand...

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
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
B4J Question Howto transport jRDC2 Server solution to hosted server?
Replies
1
Views
802
aeric
  • Question
B4J Question jRDC2 Server with WebClient
Replies
7
Views
2K
EnriqueGonzalez
V
  • Question
B4J Question jRDC2 connection via linux server
Replies
13
Views
3K
OliverA
  • Question
B4J Question JRDC2 not able to connect to MySql, wrong port 3308
Replies
3
Views
803
marcick
J
  • Question
B4J Question B4J RDC Connection to Mysql
2
Replies
21
Views
3K
jeffkwells
J
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…