|
|
|
|
|
This topic describes MySQL-specific details of how MOVEit Automation interfaces to its database. When MySQL has been selected as the database engine (and this is the default), MOVEit Automation installs, upgrades, manages, and updates its database automatically, so very few sites will need the information contained in this topic.
In MySQL, the tables can be created with SQL statements like:
CREATE TABLE `stats` (
`ID` bigint(20) NOT NULL auto_increment,
`LogStamp` varchar(24) default NULL,
`TaskID` int(11) NOT NULL default '0',
`Node` smallint(6) NOT NULL default '0',
`NominalStart` varchar(24) NOT NULL default '',
`Action` varchar(12) default NULL,
`SourceHost` varchar(100) default NULL,
`SourceFilename` varchar(255) default NULL,
`SourceFilenameOnly` varchar(255) default NULL,
`SourceFileID` varchar(24) NOT NULL default '',
`SourceStamp` varchar(24) default NULL,
`SourceNBytes` double default '-1',
`SourceDuration` double default '-1',
`SourceMsgID` text,
`SourceMDN` text,
`DestHost` varchar(100) default NULL,
`DestFilename` varchar(255) default NULL,
`DestFilenameOnly` varchar(255) default NULL,
`DestFileID` varchar(24) NOT NULL default '',
`NBytes` double default NULL,
`DestDuration` double default '-1',
`DestMsgID` text,
`DestMDN` text,
`ErrCode` int(11) default NULL,
`Message` varchar(250) default NULL,
`Hash` varchar(40) default NULL,
PRIMARY KEY (`ID`),
KEY `StatsUniqueRun` (`TaskID`,`NominalStart`),
KEY `Action` (`Action`),
KEY `ErrCode` (`ErrCode`),
KEY `LogStampTaskIDIndex` (`LogStamp`,`TaskID`)
);
CREATE TABLE `taskruns` (
`ID` bigint(20) NOT NULL auto_increment,
`LogStamp` varchar(24) default NULL,
`TaskID` int(11) NOT NULL default '0',
`Node` smallint(6) NOT NULL default '0',
`NominalStart` varchar(24) NOT NULL default '',
`TaskName` varchar(200) default NULL,
`RecType` varchar(8) default NULL,
`TimeStarted` varchar(24) default NULL,
`TimeEnded` varchar(24) default NULL,
`StartedBy` varchar(32) default NULL,
`Success` varchar(12) default NULL,
`FilesSent` int(11) default NULL,
`TotalBytesSent` double default NULL,
`HasBeenRead` int(11) default '0',
`LastErrorType` int(11) default NULL,
`LastErrorText` varchar(250) default NULL,
`Hash` varchar(40) default NULL,
PRIMARY KEY (`ID`),
KEY `TaskRunsUniqueRun` (`TaskID`,`NominalStart`),
KEY `Success` (`Success`),
KEY `HasBeenRead` (`HasBeenRead`),
KEY `LogStampTaskIDIndex` (`LogStamp`,`TaskID`)
);
CREATE TABLE `taskgroups` (
`GroupName` varchar(50) default NULL,
`TaskID` int(11) NOT NULL default '0'
);
CREATE TABLE `audit` (
`ID` bigint(20) NOT NULL auto_increment,
`LogTime` varchar(24) default NULL,
`Node` smallint(6) default NULL,
`Action` varchar(24) default NULL,
`TargetType` varchar(24) default NULL,
`TargetID` varchar(50) default NULL,
`TargetName` varchar(200) default NULL,
`CentralVersion` varchar(12) default NULL,
`AgentBrand` varchar(32) default NULL,
`AgentVersion` varchar(12) default NULL,
`Username` varchar(80) default NULL,
`IPAddress` varchar(16) default NULL,
`Error` int(11) default NULL,
`ErrorText` text,
`Message` text,
`Hash` varchar(40) default NULL,
`ClientIP` varchar(16) default NULL,
PRIMARY KEY (`ID`),
KEY `LogTime` (`LogTime`)
);
CREATE TABLE `tmplastruns` (
`TaskIDOfMax` int(11) default NULL,
`IDOfMax` bigint(20) default NULL
);
You must also grant access to the MySQL database with a statement like:
GRANT ALL ON MICStats.* TO MICentral@localhost IDENTIFIED BY 'mypassword123';This example creates a user named MICentral with a password of mypassword123.
Then create an ODBC DSN and specify the username and password you gave above. Be sure to check the "Change BIGINT columns to INT" option.
The DSN associated with this database is provided to MOVEit Automation by configuring the DSN field in the MOVEit Automation Config program.