Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
Section
Column

When accessing your database from an externally hosted SaaS

...

Server, follow these steps to ensure your data is secure. You may also wish to consider one or all of these step even when using the

...

in-house version if you feel your intranet is not secure.

Using the

...

Database Connector's security mechanism, combined with only accepting SSL connections to the database connector from the web application container, will prevent unauthorized access to your database queries. The steps below describe how to secure your data.

Column
width240px

On this page:

Table of Contents
maxLevel1

 

Configure SSL

The database connector doe does not have any specific configuration to handle SSL. Since it runs inside the Servelet container, it is typically the responsibility of the container to handle this layer of security. In any case, here is what we have done for customers that needed SSL and were using Tomcat: 

...

  • Configure Tomcat to accept only SSL connections to the frevvo Database  Database Connector. This encrypts data sent between the hosted frevvo Form Server and the frevvo Database Connector installed in your local machine, thus protecting the queryKey.
  • Create a SSL self-signed certificate and install in Tomcat’s keystore. The self-signed certificate will ensure that the data being transmitted and received by the frevvo Database  Database Connector is private and cannot be snooped by anyone who may be eavesdropping on the connection.
  • If you are running the frevvo Database the  Database Connector under Tomcat you can find more details here: [http: //tomcat.apache.org/tomcat-6.0-doc/ssl-howto.html Tomcat6 SSL How To] 

The queryKey attribute

The '''queryKey''' attribute queryKey attribute enables a password authentication mechanism that limits query execution to only those who know the queryKey password string. Every HTTP request that is sent to the database connector to execute that query must contain the key. The connector will deny all requests that do not contain the key.
 
For example, given the configuration below:

...

SQL Injection Protection

The frevvo Database  Database Connector automatically protects your data from Injection Attacks. No configuration is required for this security measure.

...