External Database Changes when Upgrading from v12.1 or earlier

Progress_iMail_Server_Logo

Release Notes iMail Server

External Database Changes for v12.2

iMail Server added new columns to the iMail ODBC User database table for the new Password Expiration feature. If iMail Server v12.2 or later is installed over a previous version that has one or more domains configured to use a custom external user database the following changes will need to be added to the existing user database columns.

Note: If a custom ODBC driver was used with an earlier version of iMail, the driver must be modified to accommodate the new columns. Source code for the basic ODBCUser.dll driver (tailored for SQL Server and Access) may be obtained by download from the iMail Support Center: http://ipswitchmsg.force.com/kb/articles/FAQ/How-do-I-use-the-ODBC-connector-1307739583175

Column Name	Data Type	Default Value
PASSWORDNEVEREXPIRES	Int	Null
PASSWORDEXPIRED	Int	Null
PASSWORDLASTCHANGED	Int	Null
PASSWORDEXPIREWARNINGLASTSENT	Int	Null

iMail Collaboration Database Changes for v12

iMail Server added new columns to the "Appointments", "Tasks" and "Recurrences" Tables for iMail Collaboration (WorkgroupShare) to handle meeting requests. If iMail Server v12 or later is installed over a previous version that has one or more domains configured to use a custom database the following column names will need to be added to the the following existing tables.

For Access Databases

Appointments Table - Add Columns

Database Column Name	Original Type	Default Value
Globalld	Memo
SequenceNumber	INT	Zero
Importance	INT	Zero
FlagDueBy	DateTime	Null

Tasks Table - Add Columns

Database Column Name	Original Type	Default Value
Reminder	BIT	Null
RemindTime	Datetime	Null
FlagDueBy	DateTime	Null

Recurrences Table - Add Columns

Database Column Name	Original Type	Default Value
EndType	INT	Zero

For SQL Databases

Appointments Table - Add Columns

Database Column Name	Original Type	Default Value
Globalld	MEMO
SequenceNumber	INT	Zero
Importance	INT	Zero
FlagDueBy	DateTime	Null

Tasks Table - Add Columns

Database Column Name	Original Type	Default Value
Reminder	BIT	Null
RemindTime	Datetime	Null
FlagDueBy	DateTime	Null

Recurrences Table - Add Columns

Database Column Name	Original Type	Default Value
EndType	INT	Zero

External Database Changes for v11.03

iMail Server now supports user level Archiving and Full Name encoding for international users. If iMail Server v11.03 or later is installed over a previous version that has one or more domains configured to use a custom external user database the following changes will need to be added to the existing user database columns.

iMail Server v11.03 Altered Column

Database Column Name	Original Type	Default Value
ENABLEARCHIVING	Integer	Null
FULLNAMEENCODING	Varchar(20)	Null

External Database Changes when Upgrading from v11.01 or earlier

iMail Server now supports mailboxes that are larger than 2GB. If iMail Server v11.02 or later is installed over a previous version that has one or more domains configured to use a custom external user database, some changes will need to be made to the existing user database columns. Any column containing a user's Max Mailbox Size (MaxSize in the standard odbcuser.dll) will need to be altered to handle 64-bit values. This can be accomplished by changing the column's type to one that can hold a value up to and including the maximum value of an unsigned 64 bit integer. Example types would be a BIGINT, a DOUBLE, or a NUMERIC(20,0) – the exact type to use may vary depending on which database engine is being used.

iMail Server v11.02 Altered Column

Database Column Name	Original Type	Altered Type
MAXSIZE	INTEGER	BIGINT for SQL DB DOUBLE for Access DB

External Database Changes when Upgrading from v2006.1 or earlier

iMail supports multiple database connections. Enabling this feature will improve performance when using an external database. This can be enabled by creating and setting two registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\iMail\Global\UseMultiConnect
HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\iMail\Global\MaxConnect

The first key, "UseMultiConnect" should be set to "1" to enable multiple database connections.
The second key, "MaxConnect" should be set to the maximum number of connections allowed; "10" is recommended.

When installing iMail v8.2 or later over any version earlier than 7.1 in which one or more hosts are configured to use an external user database, new columns must be added to the database tables. This is due to additional user-level data which must be stored for use with the new Web Messaging features and for Web Calendaring. These new columns must be added to the user table for each iMail host configured to use an external database.

Notes:

If a custom ODBC driver was used with an earlier version of iMail, the driver must be modified to accommodate the new columns. Source code for the basic ODBCUser.dll driver (tailored for SQL Server and Access) may be obtained by download from the iMail Support Center:

ftp://ftp.ipswitch.com/Ipswitch/Product_Support/iMail/odbcuser.dll

These database column additions must be made before installing iMail v8.2. Also, if a custom ODBC database driver will be used with iMail, it must be created and ready for use. New columns and their types are as follows:

iMail Server 2006.1 New Columns

Database Column Name	Type	Default Value
ENABLEALTWGSID	INTEGER	Null
ALTWGSID	VARCHAR(255)	Null

iMail Server v7.1 New Columns

Database Column Name	Type	Default Value
NUMNOTIFY	Integer	Null
LASTNOTIFY	Integer	Null

iMail Server v7.0 New Columns

Database Column Name	Type	Default Value
NUMTRIES	Integer	0
LASTNOTIFY	Integer	0
ATTEMPTTIME	Integer	0
NUMTIMESSUSP	Integer	0
SPNDUSRACCT	Integer	0
IWOPTIONS	Integer	0
SPELLCHKG	Integer	0
ICALENBL	Integer	-1
SPELLENBL	Integer	-1
NUMSGSTNS	Integer	-1
IWDEPTH	Integer	-1
PRVWSIZE	Integer	-1
STRTDAY	Integer	-1
ENTRYGRNL	Integer	-1
STARTTIME	Integer	-1
ENDTIME	Integer	-1
MAXEVNTDISP	Integer	-1
MAXTSKDISP	Integer	-1
MAXNOTEDISP	Integer	-1
MAXDLYRCURCNT	Integer	-1
MAXWKLYRCURCNT	Integer	-1
MAXMONRCURCNT	Integer	-1
MAXRLYRCURCNT	Integer	-1
DISPCMPLTDTSKS	Integer	-1
HOURSCLOCK	Integer	-1
MAXSRCHRESPPG	Integer	-1
CONFIRMONDELETE	Integer	-1
TIMEZONE	Varchar (255)	"" (empty string)
DEFVIEW	Varchar (255)	"" (empty string)
DEFCALNM	Varchar (255)	"" (empty string)

For all existing user records, these columns should be set to the default values shown in the table.