KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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?