2022.1

l max_allowed_packet = 500M : In some implementations, especially when using
Capture OnTheGo, large packet sizes are required to allow transferring binary files.
This substantial packet size maximum setting ensures that the data received by
PrintShop Mail Connect will be able to be stored within the database.
l character-set-server = utf8 , collation-server = utf8_unicode_ci , default-
character-set=utf8 : These indicate database support for UTF-8/Unicode.
l The database configuration must allow the use of mixed case table names.
This is particularly an issue on Linux MySQLinstallations.
l The SQL instance must be open to access from other computers. This means the bind-
address option should not be set to 127.0.0.1 or localhost.
Warning
If you chose not to install the supplied MariaDBdatabase, and instead opt for using a
pre-existing (External) database then you yourself must ensure that the External
database is accessible to Connect.
Upland Objectif Lune will take no responsibility for setting up database connections to
any but the supplied MariaDBdatabase.
Options available within the installer:
l The Configuration page for the local MySQL is displayed.
l MySQL settings are pre-filled with default values if no existing MySQL database
configuration is found.
l MySQL settings are pre-filled with existing database configuration settings, if they point to
a MySQL database type.
Installing Connect using an existing Microsoft SQL Server instance
If Microsoft SQLServer is already present and you wish to use it, the following should be taken
into consideration:
Warning
If you chose not to install the supplied MariaDBdatabase, and instead opt for using a
Page 16