Android Question Bluhost VPS + RDC

[achtrade]

I just purchased a VPS with Bluhost.com now I need to install the RDC server there but I have no idea where to start.

someone has a little tutorial or a place where I can learn how to setup this?

 

[NJDude]

There are some instructions HERE, also, you should check your provider's knowledge base for answers.

 

[achtrade]

someone can teach me how to install java and setup a RDC-Server in my bluhost.com vps ? I'm willing to pay for it

The mysql db is already setup.

 

[Erel]

You shouldn't have made three duplicate posts for this.

Lets start with Java. You do not need to install Java. Only to extract the files. You need to download the Java tar file (for linux) to your PC: https://java.com/en/download/manual.jsp
Upload it to your linux and extract it.

Now copy RDC files to your linux. The command to start it is similar to RunRDC.bat command. You need to replace the semi-colons with colons.

 

[achtrade]

You shouldn't have made three duplicate posts for this.

Lets start with Java. You do not need to install Java. Only to extract the files. You need to download the Java tar file (for linux) to your PC: https://java.com/en/download/manual.jsp
Upload it to your linux and extract it.

Now copy RDC files to your linux. The command to start it is similar to RunRDC.bat command. You need to replace the semi-colons with colons.

sorry for that, but I'm running out of time and I don't want that my app goes offline.

I'll try this

thanks.

 

[achtrade]

What do these errors mean ?


my config.properties:
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://127.0.0.1:3306/xxxxx99?characterEncoding=utf8

User=xxx
Password=xxx
ServerPort=17178
Debug=true

#commands

 

[achtrade]

I'm using this files

mysql-connector-java-5.1.35-bin

and

jre1.8.0_45

any idea ?

 

[achtrade]

this is my c3p0

c3p0.maxStatements=150
c3p0.maxIdleTime=1800
c3p0.idleConnectionTestPeriod=600
c3p0.checkoutTimeout=60000
c3p0.testConnectionOnCheckout=true

 

[Erel]

RDC fails to connect to the MySQL db. Maybe the password is incorrect, or the port or MySQL is not running at all.

 

[achtrade]

MySql is running 3888, I don't know why, see pic.

I changed my config to this

JdbcUrl=jdbc:mysql://127.0.0.1/xxxxx99?characterEncoding=utf8

and this

JdbcUrl=jdbc:mysql://127.0.0.1:3888/xxxxx99?characterEncoding=utf8

and this

JdbcUrl=jdbc:mysql://localhost/xxxxx99?characterEncoding=utf8

and I got the same error

User and password double checked, they are ok, I'm connected to mysql with workbench without problem, but the WB is using the port 3306

any another idea ?

 

[achtrade]

Also, I tried to access the db using ssh

mysql -u username -p databasename

The connection was successful

 

[achtrade]

What does this mean ? what is the correct port and ip ?

 

[achtrade]

One more question: how can I check if my port 17178 is opened from outside ? if is not open, How can I open it ?

I'm using WHM and I added the port 17178 here "Allow incoming TCP ports" and here "Allow outgoing TCP ports" and here "Allow incoming UDP ports" and here "Allow outgoing UDP ports"
and then I restarted csf+lfd

 

[achtrade]

this is my java program running

 

[Erel]

Are you able to connect to the server from the browser: http://www.b4x.com/android/forum/th...r-rdc-connect-to-any-remote-db.31540/#content (see step #7)?

 

[achtrade]

it says:

HTTP request set; waiting for response

and then:

RemoteServer is running
java.sql.sqlexception: connections could not be acquired from the underlying database!

 

[Erel]

This means that the firewall is configured properly.

The problem is between RDC and the database server. Hard to say what is the problem without access to the server.

 

[achtrade]

This means that the firewall is configured properly.

The problem is between RDC and the database server. Hard to say what is the problem without access to the server.

I can give you access to my server

 

[Erel]

Send me the ssh details in a private message and I'll try to check it.