EI_Systems

Hi there, I've got a bit of a problem installing ESMC on an old Win 2008 R2 x 64 Server. I installed Mysql (first the current version - after finding out, that only 8.0.17 is supported I reverted back to that version). Created a new era_db database and a user exactly as described here: https://support.eset.com/en/kb6852-create-databases-and-database-user-accounts-for-eset-security-management-center-7x When the migration assistant tries to connect, I get the general database configuration problem error message. In the log file I see the following: MSI (c) (10:EC) [12:18:48:611]: Doing action: CA_DbCheckConnection Aktion 12:18:48: CA_DbCheckConnection. Aktion gestartet um 12:18:48: CA_DbCheckConnection. MSI (c) (10:EC) [12:18:48:613]: Transforming table CustomAction. MSI (c) (10:0C) [12:18:48:634]: Invoking remote custom action. DLL: C:\Users\ADMINI~1.SBD\AppData\Local\Temp\5\MSI408B.tmp, Entrypoint: DbCheckConnection MSI (c) (10!00) [12:18:49:491]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Custom action 'CheckStringWithRegex' ended.'. Its new value: 'INFO: Custom action 'DbCheckConnection' successfully initialized.'. MSI (c) (10!00) [12:18:49:491]: PROPERTY CHANGE: Deleting P_DB_CONNECTION_STATUS property. Its current value is '77702'. MSI (c) (10!00) [12:18:49:491]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Custom action 'DbCheckConnection' successfully initialized.'. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_CONNECTION_STATUS' with value - '. MSI (c) (10!00) [12:18:49:492]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_CONNECTION_STATUS' with value - '. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_STATUS' with value - '. MSI (c) (10!00) [12:18:49:492]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_STATUS' with value - '. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_UPGRADE' with value - '. MSI (c) (10!00) [12:18:49:493]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_UPGRADE' with value - '. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_USE_FIRST_USER' with value - '. MSI (c) (10!00) [12:18:49:494]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_USE_FIRST_USER' with value - '. Its new value: 'INFO: Successful GET property 'Installed' with value - '. MSI (c) (10!00) [12:18:49:494]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'Installed' with value - '. Its new value: 'INFO: Successful GET property 'P_UPGRADE' with value - '. MSI (c) (10!00) [12:18:49:495]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_UPGRADE' with value - '. Its new value: 'INFO: Successful GET property 'P_DB_TYPE' with value - MySQL Server'. MSI (c) (10!00) [12:18:49:495]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_TYPE' with value - MySQL Server'. Its new value: 'INFO: Successful GET property 'P_PRODUCT_NAME' with value - Server'. MSI (c) (10!00) [12:18:49:495]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_PRODUCT_NAME' with value - Server'. Its new value: 'INFO: Successful GET property 'P_DB_CONNECTORS_DIR' with value - C:\Users\ADMINI~1.SBD\AppData\Local\Temp\5\EsetRemoteAdminServer\{CBCEEE13-40FB-4BA9-B331-F76002D8FE2C}\'. MSI (c) (10!00) [12:18:49:496]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_CONNECTORS_DIR' with value - C:\Users\ADMINI~1.SBD\AppData\Local\Temp\5\EsetRemoteAdminServer\{CBCEEE13-40FB-4BA9-B331-F76002D8FE2C}\'. Its new value: 'INFO: Successful GET property 'P_DB_SCRIPTS_DIR' with value - C:\Users\ADMINI~1.SBD\AppData\Local\Temp\5\EsetRemoteAdminServer\{CBCEEE13-40FB-4BA9-B331-F76002D8FE2C}\Database'. MSI (c) (10!00) [12:18:49:496]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_SCRIPTS_DIR' with value - C:\Users\ADMINI~1.SBD\AppData\Local\Temp\5\EsetRemoteAdminServer\{CBCEEE13-40FB-4BA9-B331-F76002D8FE2C}\Database'. Its new value: 'INFO: Successful GET property 'P_DB_DRIVER' with value - MySQL ODBC 8.0 Unicode Driver'. MSI (c) (10!00) [12:18:49:497]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_DRIVER' with value - MySQL ODBC 8.0 Unicode Driver'. Its new value: 'INFO: Successful GET property 'P_DB_HOSTNAME' with value - 127.0.0.1'. MSI (c) (10!00) [12:18:49:497]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_HOSTNAME' with value - 127.0.0.1'. Its new value: 'INFO: Successful GET property 'P_DB_PORT' with value - 3306'. MSI (c) (10!00) [12:18:49:497]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_PORT' with value - 3306'. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_PORT' with value - 3306'. MSI (c) (10!00) [12:18:49:498]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_PORT' with value - 3306'. Its new value: 'INFO: Successful GET property 'P_DB_NAME' with value - era_db'. MSI (c) (10!00) [12:18:49:498]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_NAME' with value - era_db'. Its new value: 'INFO: Successful GET property 'P_DB_ADMIN_USERNAME' with value - **********'. MSI (c) (10!00) [12:18:49:498]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_ADMIN_USERNAME' with value - **********'. Its new value: 'INFO: Successful GET property 'P_DB_ADMIN_PASSWORD' with value - **********'. MSI (c) (10!00) [12:18:49:499]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_ADMIN_PASSWORD' with value - **********'. Its new value: 'INFO: (GetDatabaseServerConnectionStringWithoutEscape) Created connection string: 'Driver=MySQL ODBC 8.0 Unicode Driver;Server=127.0.0.1;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;NO_SSPS=1;''. MSI (c) (10!00) [12:18:49:499]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (GetDatabaseServerConnectionStringWithoutEscape) Created connection string: 'Driver=MySQL ODBC 8.0 Unicode Driver;Server=127.0.0.1;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;NO_SSPS=1;''. Its new value: 'INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class Era::Setup::Common::Database::Framework::ConnectOptions)'. MSI (c) (10!00) [12:18:50:772]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class Era::Setup::Common::Database::Framework::ConnectOptions)'. Its new value: 'INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class Era::Setup::Common::Database::Framework::ConnectOptions)'. MSI (c) (10!00) [12:18:50:773]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class Era::Setup::Common::Database::Framework::ConnectOptions)'. Its new value: 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. MSI (c) (10!00) [12:18:50:774]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. Its new value: 'INFO: DatabaseReader: Recycling current DB connection.'. MSI (c) (10!00) [12:18:50:779]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: DatabaseReader: Recycling current DB connection.'. Its new value: 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. MSI (c) (10!00) [12:18:50:779]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionCommentOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. Its new value: 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. MSI (c) (10!00) [12:18:50:780]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. Its new value: 'INFO: DatabaseReader: Recycling current DB connection.'. MSI (c) (10!00) [12:18:50:782]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: DatabaseReader: Recycling current DB connection.'. Its new value: 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. MSI (c) (10!00) [12:18:50:782]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. Its new value: 'INFO: SQL Database server version is '8.0.17', which is considered as SUPPORTED.'. MSI (c) (10!00) [12:18:50:783]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: SQL Database server version is '8.0.17', which is considered as SUPPORTED.'. Its new value: 'INFO: DatabaseReader: Recycling current DB connection.'. MSI (c) (10!00) [12:18:50:788]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: DatabaseReader: Recycling current DB connection.'. Its new value: 'ERROR: Execution test of long statement failed with exception: CMysqlCodeTokenExecutor: CheckVariableMaxAllowedPacket: Server variable max_allowed_packet value 4194304 Bytes is too low.'. MSI (c) (10!00) [12:18:50:789]: PROPERTY CHANGE: Adding P_DB_CONNECTION_STATUS property. Its value is '77702'. MSI (c) (10!00) [12:18:50:789]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'ERROR: Execution test of long statement failed with exception: CMysqlCodeTokenExecutor: CheckVariableMaxAllowedPacket: Server variable max_allowed_packet value 4194304 Bytes is too low.'. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_CONNECTION_STATUS' with value - 77702'. MSI (c) (10!00) [12:18:50:793]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. It Astonishingly the last message is somewhat truncated and the new value is smaller than the orignial one? Obviously I set the max_allowed_packet=33M in the my.ini file of mysql. Any ideas how to get the connection working? Regards, Andreas