Is it possible to control how GMS Webmail connects and disconnects to the addressbooks database?

Question

GMS Webmail address book is stored in a local SQL database. There are several ways to access the database which affect the way that GMS Webmail behaves. Gordano have chosen the optimum settings but these may be altered to suite specific requirements.

Answer

The user variable SQLConnectionMode controls how and when GMS connects and disconnects to the addressbooks database.

The options for this variable are:

1. Open/close SQL connection for every database transaction. SQLConnectionMode=0
2. Open/close SQL connection for every WWW connection. i.e. The SQL connection is opened at the start of a WWW connection and closed at the end of the WWW connection. Multiple database transactions may take place in between.
   SQLConnectionMode=1

3. Open/close SQL connection on a WWW session basis. i.e. The SQL connection is opened when a session is created and closed when the session is destroyed.
   SQLConnectionMode=2

The default for this variable is 1. To change the variable ensure that you have the ‘Allowed direct editing of system variables’ checked under SECURITY–>CONTROL, then goto SUPPORT–>USER VARIABLES
select the variable SQLConnectionMode from the list of variables, enter the new value and press CHANGE VALUE.

Keywords:webmail addressbook database mysql sql connect