Upgrading from 3.1.15 to 4.0.122 with MySQL Backend

Hi,

Because of the slow german nod support (still waiting for answer), i hope to solve my problem here.

1st try: Upgrading productive ERAS on Windows Server 2003, Enterprise Edition Service Pack 2, ODBC Ver. 3.51

Differences

Code:

<2010-04-22 18:41:32> Detected Remote Session
<2010-04-22 18:41:32> # Warning: Installed service uses custom account:"domain\root"
<2010-04-22 18:41:34> Converting compact rule 'D, 30, 23:00', ''...
<2010-04-22 18:41:34> Improper or missing last compact date, used default value "1992-01-01"
<2010-04-22 18:42:43> Current session impersonated to account "domain\root"
<2010-04-22 18:42:43> User session reverted
<2010-04-22 18:43:03> delete_threats_enable   = 0, delete_threats_number   = 6, delete_threats_type   = 1
<2010-04-22 18:43:03> delete_scans_enable     = 0, delete_scans_number     = 3, delete_scans_type     = 1
<2010-04-22 18:43:03> delete_events_enable    = 0, delete_events_number    = 3, delete_events_type    = 1
<2010-04-22 18:43:03> delete_firewalls_enable = 0, delete_firewalls_number = 3, delete_firewalls_type = 1
<2010-04-22 18:43:13> Created backup of prior database: D:\Daten\ESET\ESET Remote Administrator\Server\database\backup_db_v2_era.mdb
<2010-04-22 18:44:53> Current session impersonated to account "domain\root"
<2010-04-22 18:44:53> User session reverted
<2010-04-22 18:44:53> Current session impersonated to account "domain\root"
<2010-04-22 18:44:53> User session reverted
<2010-04-22 18:44:53> CREATE TABLE Task ( ID int NOT NULL, PrimaryID int NOT NULL, PrimaryServer varchar(50) NOT NULL, FromServer varchar(50) NOT NULL, ReplicateUp tinyint NULL DEFAULT 0, ReplicateDown tinyint NULL DEFAULT 0, IsForeign tinyint NOT NULL DEFAULT 0, TaskType int NOT NULL DEFAULT 0, Name varchar(50) NOT NULL, Description varchar(250) NULL DEFAULT '', State int NOT NULL DEFAULT 0, StateDate datetime NULL, DateToDeploy datetime NULL, DeleteDone tinyint NOT NULL DEFAULT 0, DateReceived datetime NULL, DateCreated datetime NULL, XMLData char(10) NOT NULL DEFAULT 'N', LastModifiedUserName varchar(50) NULL DEFAULT '', LastModifiedUserPrimaryServer varchar(50) NULL DEFAULT '', LastModifiedUserDate datetime NULL, UserComment varchar(255) NULL DEFAULT '', PRIMARY KEY (ID), INDEX IX_Task_DateToDeploy (DateToDeploy), INDEX IX_Task_Name (Name), INDEX IX_Task_PrimaryID (PrimaryID) ) ENGINE=MyISAM
<2010-04-22 18:44:53> SQL command failed: "Operation: [SqlExecute] Native: [0x41A] State: [S0001] [MySQL][ODBC 3.51 Driver][mysqld-5.0.90-log]Table 'Task' already exists "
<2010-04-22 18:44:53> InstallAbort: Entered
<2010-04-22 18:44:53> Reinstallation from prioer version failed. Creating backup of dump file...

upgrade crashed... V3 uninstalled, V4 install broken. Downgrade to V3 not possible (because nothing is installed)

2st try: creating db dump, test ERAS on Windows XP Professional Service Pack 3 (virtual mashine), ODBC Ver. 3.51

Code:

<2010-04-26 14:46:35> delete_threats_enable   = 1, delete_threats_number   = 6, delete_threats_type   = 1
<2010-04-26 14:46:35> delete_scans_enable     = 1, delete_scans_number     = 3, delete_scans_type     = 1
<2010-04-26 14:46:35> delete_events_enable    = 1, delete_events_number    = 3, delete_events_type    = 1
<2010-04-26 14:46:35> delete_firewalls_enable = 1, delete_firewalls_number = 3, delete_firewalls_type = 1
<2010-04-26 14:48:23> Dropped objects: TASK, IDGENERATOR, THREATLOG, THREATSENSE1, THREATSENSE2, DBPROPERTY, EVENTLOG, FIREWALLLOG, LINKCLIENTTASK, LOCALGROUP, DELETEDDBDATA, CLIENT, POLICY, POLICYRULES, SCANLOG, STATISTICSTASK, NOTIFICATION, LINKCLIENTLOCALGROUP

Upgrade fine...

So, why no dropped objects on 1st try? (which seems the reason for the crash)

 

3rd try: db dump, copy of conf files, test ERAS on Windows XP Professional Service Pack 3 (virtual mashine), ODBC Ver. 3.51

Code:

<2010-04-26 17:08:38> delete_threats_enable   = 0, delete_threats_number   = 6, delete_threats_type   = 1
<2010-04-26 17:08:38> delete_scans_enable     = 0, delete_scans_number     = 3, delete_scans_type     = 1
<2010-04-26 17:08:39> delete_events_enable    = 0, delete_events_number    = 3, delete_events_type    = 1
<2010-04-26 17:08:39> delete_firewalls_enable = 0, delete_firewalls_number = 3, delete_firewalls_type = 1
<2010-04-26 17:13:44> Dropped objects: TASK, IDGENERATOR, THREATLOG, THREATSENSE1, THREATSENSE2, DBPROPERTY, EVENTLOG, FIREWALLLOG, LINKCLIENTTASK, LOCALGROUP, DELETEDDBDATA, CLIENT, POLICY, POLICYRULES, SCANLOG, STATISTICSTASK, NOTIFICATION, LINKCLIENTLOCALGROUP
<2010-04-26 17:14:01> Cannot process SQL command at line 86
<2010-04-26 17:14:01> Update SQL query error: Operation: {Execute} Native: {0x7DD} State: {08S01} [MySQL][ODBC 3.51 Driver][mysqld-5.1.41]Lost connection to MySQL server during query QUERY: INSERT INTO Client (ID,Name,ComputerName,MacAddress,MacPrevious,ClientIID,PrimaryServer,FromServer,ReplicateUp,ReplicateDown,IsForeign,IP,ClientDomain,DomainType,OSName,OSNumber,OSPlatform,OSPlatformName,HWPlatform,HWPlatformName,ProductLastStarted,SectionID,PolicyPrimaryID,PolicyPrimaryServer,PolicyCRC,PolicyApplyDate,ThreatDBVersionName,ThreatDBVersionNumber,ThreatDBVersionBuild,ThreatDBVersionDate,ProductName,ProductVersion,ClientLastConnected,ClientLastInstalled,Configuration,ConfigurationDate,ConfigurationRDate,ConfigurationCRC,Information,InformationDate,InformationRDate,InformationCRC,PluginState,PluginStateDate,PluginStateRDate,PluginStateCRC,Features,FeaturesDate,FeaturesRDate,FeaturesCRC,Sysinfo,SysinfoDate,SysinfoRDate,SysinfoCRC,SysinfoExR,SysinfoExD,PluginStateShort,PluginStateLevel,WaitingForRestart,WaitingForRestartDate,LastThreatText,LastFirewallText,LastEventText,LastEventTextLevel,LastScanScanned,LastScanInfected,LastScanCleaned,LastScanDate,TaskText,MobileUser,NewClient,LastModifiedUserName,LastModifiedUserPrimaryServer,LastModifiedUserDate,UserComment,IPn,CustomInfo,CustomInfoDFlag,ThreatEngineType) VALUES ([I]Data here[/I]);