-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
Android Question Encrypt MSSQL login credentials
- Thread starter Mostez
- Start date
- Similar Threads Similar Threads
[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...
Tutorial of connecting Android to MS SQL Server using jRDC2
Hi Here is a tutorial that shows the steps of how to make an Android connection to MS SQL Server using jRDC2. Download tutorial here: Attached the Mobile Project in B4A and the JRDC2 Project in B4J Any questions please ask in the forum Bladimir Silva Toro Teacher programming software
Here's SQL
Android database encryption with SQLCipher library
SQLCipher is an open source project that extends SQLite and adds full database encryption. License: https://www.zetetic.net/sqlcipher/open-source/ B4A SQLCipher is a special subtype of SQL object. There is almost no need to change any code in order to switch from regular SQL to SQLCipher. The...
Last edited:
Upvote
0
it is in my first post and title MS SQL 2012 Server. what I did not mention is "I use jtds-1.3.1 for connection", is it possible to use SQLCipher with it?
Upvote
0
SQLCipher is not a server solution. You need a solution for a server base, in this role JRDC2 works best ... both locally and remotely via the Internet and the data is encrypted ...
P.S
Sorry ... the title contains a kind of database ...
P.S
Sorry ... the title contains a kind of database ...
Last edited:
Upvote
0
1) Make sure you SQL server has a certificate set up
2) Use the ssl option of the JTDS driver (see http://jtds.sourceforge.net/faq.html#urlFormat)
3) Cross your fingers...
2) Use the ssl option of the JTDS driver (see http://jtds.sourceforge.net/faq.html#urlFormat)
3) Cross your fingers...
Upvote
0
I created SSL certificate and assigned it to SQL server, server services started OK and i can login to server from application, I added SSL option to jtds like this:
I monitored the packets sent from phone to server, but I still see username and password in plain text and protocol is TDS not SSL
B4X:
dbJDBCurl = "jdbc:jtds:sqlserver://" & dbCurrentIP & "/" & dbName & ";ssl = request"I monitored the packets sent from phone to server, but I still see username and password in plain text and protocol is TDS not SSL
Upvote
0
How are you monitoring the packets? The client should first create an SSL connection to the server and then use TDS over SSL to communicate with the server.
Upvote
0
The SSL connection to the SQL server should happen before the TDS connection. In Wireshark, you should see the client establish the SSL connection to the server and, if successful, all traffic to the server should be encrypted. If that is not happening, you may need to look at the log files on the server to see what is going on.
Upvote
0
Similar Threads
- Question
Android Question
Validation of username and password from phpmyAdmin
- Question
Android Question
Send password in clear text to my api with SSL secure enough