Android Question SOLVED - Jrdc2 - Problem to reach database

[IlCasti]

Hi all.
can someone tell me what does it mean?
i never reach database connection with jrdc2

/test web connection
RemoteServer is running (02/20/2018 14:53:49)
Connection successful.

from b4a app i can't get data from any query and app log says
<pre> Not Found</pre></p><hr><a href="http://eclipse.org/jetty">Powered by Jetty:// 9.4.z-SNAPSHOT</a><hr/>

i had some problem of Error reading response: (DataFormatException) java.util.zip.DataFormatException: incorrect header check

i had also warning about trust ssl connection than before i hadn't.. why???

please help me to understand
thank you

 

[OliverA]

What is your connection url to the JRDC2 server?

 

[OliverA]

The SSL issue is separate. You are connecting from the JRDC2 server to MySQL via SSL and it complains (do you have a valid SSL certificate for you MySQL server?)

 

[IlCasti]

Connection url is:

Private const rdcLink As String = "http://192.168.0.148:17178/xxxxxxxx" in b4a

JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8
User=root
Password=
#Java server port
ServerPort=17178
in config.properties

i launch jRDC.jar through a .bat file (java -jar jRDC.jar)
but i have not a ssl certificate on local mysql server..

i use my work laptop connect to a mobile router and my phone connected too

Until yesterday everything works!

Image show port 3307 used in previously tests

 

[OliverA]

Unless you modified the JRDC2 server code, the xxxxxxxx portion of your URL needs to be rdc. Otherwise you are not going to be successful.

Private const rdcLink As String = "http://192.168.0.148:17178/rdc"

 

[OliverA]

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

If you don't like the SSL warning (it's just a warning) and you don't want to use SSL change your connection URL for the database to

JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8&useSSL=false

See: https://www.b4x.com/android/forum/threads/mysql-ssl-warning.80017/

 

[IlCasti]

Unless you modified the JRDC2 server code, the xxxxxxxx portion of your URL needs to be rdc. Otherwise you are not going to be successful.

Private const rdcLink As String = "http://192.168.0.148:17178/rdc"

Ehi man, great suggestion!
Change all, thank you!
Now it works.

 

[IlCasti]

If you don't like the SSL warning (it's just a warning) and you don't want to use SSL change your connection URL for the database to

JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8&useSSL=false

See: https://www.b4x.com/android/forum/threads/mysql-ssl-warning.80017/

Works too!
Thank you