Android Question Remote Database Connector and SSL (https)

[b4auser1]

How to setup SSL (HTTPS) for connetions to Remote Database Connector server ?

 

[Erel]

RDC currently doesn't support SSL. You can use a reverse proxy for that.

 

[b4auser1]

Thank you. I see.

 

[timbald]

I get how RDC works and SSL etc. but lost on how a Reverse Proxy gives security on the connection between Android handset and Server with RDC/MySql on. Could someone please possible point me in the right direction as this is exactly what I now need to do with my first B4A android App. Many thanks.

 

[Erel]

There might be simpler solutions now with B4J as B4J servers do support SSL. You can replace RDC with a B4J server.

 

[Fernando Melo]

Using an ssh tunnel is a reliable solution?

 

[KMatle]

RSA Encryption -> httputils -> php -> Decryption -> database (and vice versa)

https://www.b4x.com/android/forum/threads/using-rsa-in-b4a-to-communicate-with-php-openssl.59445/

 

[Fernando Melo]

I das thinking in reuse the rdc client passing the connection through a ssh tunnel. The rdc proofs to be very fast. In a application i have. But i would like to improve the security with minor code chances.

 

[Erel]

jRDC supports SSL connections: https://www.b4x.com/android/forum/threads/59251/#content

https://www.b4x.com/android/forum/threads/40130/#content

 

[Fernando Melo]

Thanks excellent work

 

[Fernando Melo]

Using jRDC with SSL is working well. I only have a caveat when I try to save a Blob into file. The following was working well.

If result.Tag = "descarregaficheiro" Then
                ProgressDialogShow2(Main.trans.GetText("Importing")&"...",False)
                For Each row() As Object In result.Rows
                    Dim out As OutputStream = File.OpenOutput(File.DirInternalCache,"out.csv",False)
                    Dim In As InputStream
                    Dim Buffer() As Byte
                    Buffer = row(0) ' gives error here, says that can not convert a string to byte array
                    In.InitializeFromBytesArray(Buffer, 0, Buffer.Length)
                    File.Copy2(In, out)
                    out.Close
                    In.Close

The upload code works well and I can see the csv file in database.
Can you help please.

 

[Erel]

Please start a new thread for this in B4J questions forum.

 

[Fernando Melo]

Thanks I created this topic https://www.b4x.com/android/forum/threads/save-blob-field-in-file-using-jrdc.59812/