katbert

I'm trying to install ERA Server 6.1.28.0 on Windows 2008 R2 SP1 (Russian) domain controller I install SQL 2008 R2 Express SP2 manually without errors, and can connect to SQL using Management Studio I opened 1433 port https://forum.eset.com/topic/3805-remote-administrator-install-odbc-error/ Setup can connect to database using "SQL Server" ODBC driver and sa SQL account But setup stop with critical error in the step "executing database scripts - installing new database" If connect to SQL using Management Studio before setup rollback - I see database era_db Setup rollback delete database In the install log I see this error: INFO: Custom action 'DbCreate' successfully initialized. INFO: Successful GET property 'P_PRODUCT_NAME' with value - Server INFO: Successful GET property 'P_PRODUCT_GUID' with value - 8863923d-9052-44de-8941-dc611f0a7a4a INFO: Successful GET property 'P_DB_SCRIPTS_DIR' with value - C:\ProgramData\ESET\RemoteAdministrator\Server\SetupData\Database\ INFO: Successful GET property 'P_DB_CONNECTORS_DIR' with value - C:\Users\836D~1\AppData\Local\Temp\EsetRemoteAdminServer\ INFO: Successful GET property 'P_DB_TYPE' with value - MS SQL Server INFO: Successful GET property 'P_DB_DRIVER' with value - SQL Server INFO: Successful GET property 'P_DB_HOSTNAME' with value - localhost INFO: Successful GET property 'P_DB_PORT' with value - 1433 INFO: Successful GET property 'P_DB_NAME' with value - era_db INFO: Successful GET property 'P_DB_ADMIN_USERNAME' with value - sa INFO: Successful GET property 'P_DB_ADMIN_PASSWORD' with value - ********** INFO: Successful GET property 'P_DB_USER_USERNAME' with value - era_user INFO: Successful GET property 'P_DB_USER_PASSWORD' with value - ********** INFO: (GetDatabaseServerConnectionStringWithoutEscape) Created connection string: 'Driver=SQL Server;Server=localhost,1433;Uid=sa;Pwd={******};CharSet=utf8;' INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseWrapper::DropAndCreateDatabaseForDBServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >) INFO: (DropAndCreateDatabaseForDBServer) Skipping file C:\ProgramData\ESET\RemoteAdministrator\Server\SetupData\Database\SQLServer\CreateScripts\version.ini INFO: (DropAndCreateDatabaseForDBServer) Processing file C:\ProgramData\ESET\RemoteAdministrator\Server\SetupData\Database\SQLServer\CreateScripts\1_create_schema_without_views.sql INFO: (DropAndCreateDatabaseForDBServer) Processing file C:\ProgramData\ESET\RemoteAdministrator\Server\SetupData\Database\SQLServer\CreateScripts\2_create_log_tables.sql INFO: (DropAndCreateDatabaseForDBServer) Processing file C:\ProgramData\ESET\RemoteAdministrator\Server\SetupData\Database\SQLServer\CreateScripts\3_create_views.sql INFO: (DropAndCreateDatabaseForDBServer) Processing file C:\ProgramData\ESET\RemoteAdministrator\Server\SetupData\Database\SQLServer\CreateScripts\4_init_data.sql ERROR: (DbCreate) Statement execution failed. Error: @5>1@07>20=85 B8?0 40==KE varchar 2 B8? 40==KE datetime ?@825;> : 2KE>4C 7=0G5=8O 70 ?@545;K 480?07>=0.. File: C:\ProgramData\ESET\RemoteAdministrator\Server\SetupData\Database\SQLServer\CreateScripts\4_init_data.sql. Statement: INSERT INTO tbl_security_users (user_id, user_uuid, user_login, user_comment, password_change_timestamp, change_password_on_next_logon, password_expiration_interval_in_days, auto_logout_time_in_minutes, user_full_name, user_email, user_phone, user_state, disabled, native, removed, user_password_hash, user_password_salt) VALUES (5, dbo.ufn_uuid_str_to_binary('00000000-0000-0000-7002-000000000001'), 'system', '', '2012-01-26 12:00:00', 0, 1500, 10, 'System user', '', '', 0x, 0, 1, 0, 0x20, 0x20), (6, dbo.ufn_uuid_str_to_binary('00000000-0000-0000-7002-000000000002'), 'Administrator', '', '2011-10-12 12:00:00', 0, 1500, 10, 'Administrator', '', '', 0x, 0, 1, 0, 0x0FCF62F35B4D4A5C1D733280F9D476E73FCBD029, 0x75A308F8F28B096A5ADFE94A07DBE5C4555E1CD3D7E43D2D23F850B5ECDEDFB56D13A85BCEE4F13D2C5E9ACB8E685D5FB6ADA597A7A22FA3E874ED65D5A6A55B); INFO: Successful GET property 'P_SILENT' with value - Error 30000. A critical error occurred. Please see the installation log for more information. Enabling the log is described at the ESET knowledge base website: kb.eset.com Issue ID: SOLN406 MSI (s) (68!F8) [18:35:49:692]: Product: ESET Remote Administrator Server -- Error 30000. A critical error occurred. Please see the installation log for more information. Enabling the log is described at the ESET knowledge base website: kb.eset.com Issue ID: SOLN406

I increased the numder of processes and threads of eset_http Now gateway works normally

I have 2 FreeBSD gateways (FreeBSD 7.2 + Squid) with Eset Gateway Security 3.0.22 in different locations esets_http is upstream proxy for Squid Since 14.04.2014 users reports slow internet access After reconfiguring Squid to direct internet access (without esets_http) - users can work normal I do not change configuration of both gateways for a long time Something wrong with signatures?