Migrating Sophos PureMessage to another SQL database is a simple process. On the server you wish to modify, open C:\Program Files\Sophos\PureMessage\Config\LastKnown\LocalConfig.xml
.
Under the <LocalConfig>
tag there are four DBSettings
tags, one for each database. These are called ConfigDBSettings
, QuarDBSettings
, ReportingDBSettings
and DirectoryDBSettings
. Inside each of these is another called <DatabaseName>
. By modifying this DatabaseName
you are able to change where Sophos PureMessage stores its data. This is useful if using an SQL server with more than a few databases. I like to prefix all of my Sophos PureMessage databases with “PM” to make them stand out. An extract of my completed config file looks like this:
<LocalConfig>
<ConfigDataVersion>2</ConfigDataVersion>
<Capabilities>23</Capabilities>
<ConfigDBSettings>
<ServerName>vsql01</ServerName>
<DatabaseName>PMSavexCnfg</DatabaseName>
<AuthType>0</AuthType>
<UserName></UserName>
<Password></Password>
<ConnectionTimeOut>30</ConnectionTimeOut>
<CommandTimeOut>60</CommandTimeOut>
</ConfigDBSettings>
<QuarDBSettings>
<ServerName>vsql01</ServerName>
<DatabaseName>PMSavexQuar</DatabaseName>
<AuthType>0</AuthType>
<UserName></UserName>
<Password></Password>
<ConnectionTimeOut>30</ConnectionTimeOut>
<CommandTimeOut>60</CommandTimeOut>
</QuarDBSettings>
<ReportingDBSettings>
<ServerName>vsql01</ServerName>
<DatabaseName>PMSavexRprt</DatabaseName>
<AuthType>0</AuthType>
<UserName></UserName>
<Password></Password>
<ConnectionTimeOut>30</ConnectionTimeOut>
<CommandTimeOut>60</CommandTimeOut>
</ReportingDBSettings>
<DirectoryDBSettings>
<ServerName>vsql01</ServerName>
<DatabaseName>PMSavexDir</DatabaseName>
<AuthType>0</AuthType>
<UserName></UserName>
<Password></Password>
<ConnectionTimeOut>30</ConnectionTimeOut>
<CommandTimeOut>60</CommandTimeOut>
</DirectoryDBSettings>
</LocalConfig>
Comments/questions
There's no commenting functionality here. If you'd like to comment, please either mention me (@[email protected]) on Mastodon or email me. I don't have any logging or analytics running on this website, so if you found something useful or interesting it would mean a lot to hear from you.