Tech Tip: Clear text sql queries from server to client by default
PRODUCT: 4D | VERSION: 14.0 | PLATFORM: Mac & Win
Published On: April 25, 2014
Databases that are in client-server mode and use sql queries requests are sent as clear text by default through the network shown below:
The sample table below will have a sql query call to access the whole table:
Begin SQL select * from Table_1 End SQL |
The sql request is intercepted using Wireshark on the default client-server sql port 19812. Below are the first two records that depict the location of the data that are color coded:
Suggestion would be to encrypt the communication by checking "Encypt Client-Server Connections" and that the "4DSLI.DLL" file is required.
A KB technote provides information on the encryption:
Tech Tip: Public Cases: Is the communication between 4D Client and 4D Server encrypted?