I IlCasti Active Member Licensed User Longtime User Feb 20, 2018 #1 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 Attachments Immagine.png 76.2 KB · Views: 696
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 Expert Licensed User Longtime User Feb 20, 2018 #2 What is your connection url to the JRDC2 server? Upvote 0
OliverA Expert Licensed User Longtime User Feb 20, 2018 #3 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?) Upvote 0
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?)
I IlCasti Active Member Licensed User Longtime User Feb 20, 2018 #4 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 Upvote 0
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 Expert Licensed User Longtime User Feb 20, 2018 #5 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. Code: Private const rdcLink As String = "http://192.168.0.148:17178/rdc" Upvote 0
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. Code: Private const rdcLink As String = "http://192.168.0.148:17178/rdc"
OliverA Expert Licensed User Longtime User Feb 20, 2018 #6 IlCasti said: JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8 Click to expand... 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 Code: JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8&useSSL=false See: https://www.b4x.com/android/forum/threads/mysql-ssl-warning.80017/ Upvote 0
IlCasti said: JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8 Click to expand... 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 Code: JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8&useSSL=false See: https://www.b4x.com/android/forum/threads/mysql-ssl-warning.80017/
I IlCasti Active Member Licensed User Longtime User Feb 20, 2018 #7 OliverA said: 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. Code: Private const rdcLink As String = "http://192.168.0.148:17178/rdc" Click to expand... Ehi man, great suggestion! Change all, thank you! Now it works. Upvote 0
OliverA said: 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. Code: Private const rdcLink As String = "http://192.168.0.148:17178/rdc" Click to expand... Ehi man, great suggestion! Change all, thank you! Now it works.
I IlCasti Active Member Licensed User Longtime User Feb 20, 2018 #8 OliverA said: 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 Code: JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8&useSSL=false See: https://www.b4x.com/android/forum/threads/mysql-ssl-warning.80017/ Click to expand... Works too! Thank you Upvote 0
OliverA said: 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 Code: JdbcUrl=jdbc:mysql://localhost/xxxxxxxx?characterEncoding=utf8&useSSL=false See: https://www.b4x.com/android/forum/threads/mysql-ssl-warning.80017/ Click to expand... Works too! Thank you
