mclusky

In fact this was installation done by all-in-one installer, so suspecting proxy settings issue was accurate. After applying suggested changes update process started to work. Thank you very much for help - problem is solved.

I have successfully deployed ERA Server 6.3 in main office. Unfortunately for me company has 3 computers in 2 branch offices. I installed ERA Agents 6.4 in every branch office computer and configure them to communicate with ERA Server in main office trough internet connection with ports 2222 and 2223 redirected by router. I can say that status reporting and applying policies remotely works (so there is both-direction communication), but from the moment I installed ERA Agents virus signature update stopped working. I receive "server connection error" notification. Trying to apply specific update server address for NOD (by policy) didn't solve the issue. Do you think that deploying proxy server for branch office with 1 computer is absolutely necessary for virus signature update to work, or there should be specific policy applied for branch office computers? Best regards

I successfully deployed 3 other ERA 6 Servers on linux with MySQL local database engine. Now I need to install Era Server 6 on 32b Linux Ubuntu 12.04 Server with database located on 64b Windows Server 2008 R2 SQL 2012. I configured ODBC under Linux and I successfully obtain connection to MS SQL Server with isql or sqsh command (with the same credentials as passed to ERA installer script). But running ERA 6 Server installation fails on 'Checking database connection ... failure'. Log file EraServerInstaller.log contains: 2015-05-07 11:18:42 Information: DbCheckConnection: Set output property: P_DB_ADMIN_CONNECTION_STATUS = 65535 2015-05-07 11:18:42 Information: ERROR: DatabaseException with error code '65535' and message - [unixODBC][FreeTDS][SQL Server]Login failed for user ''. 2015-05-07 11:18:42 Information: DbCheckConnection: Return code: 0 2015-05-07 11:18:42 Information: Installer: Admin connection check failed. Unable to continue. 2015-05-07 11:18:42 Information: Installer: Error: Admin connection not working. Unable to continue. I installed all (I hope) additional packages: unixodbc unixodbc-dev freetds-dev sqsh tdsodbc My DB related installer options are: --db-driver=FreeTDS --db-hostname=192.168.18.5 --db-port=1433 --db-admin-username=sa --db-admin-password=<my pass> My configuration files: /etc/freetds/freetds.conf: [server] host = 192.168.18.5 port = 1433 tds version = 7.0 /etc/odbcinst.ini: [FreeTDS] Description = ODBC for MS SQL Driver = /usr/lib/i386-linux-gnu/odbc/libtdsodbc.so Setup = /usr/lib/i386-linux-gnu/odbc/libtdsS.so FileUsage = 1 /etc/odbc.ini: [server] Driver = FreeTDS Description = ODBC connection via FreeTDS Trace = No Servername = server I hope there is someone who successfully deployed ERA Server with external database. Is it possible I should use different value for '--db-driver=' option ?

Current state: ERA Server 6 on Ubuntu Server 14.04 and over 40 Windows workstations with Agent deployed. Target: All clients connected to new Ubuntu ERA Server 6 with different IP address. I made such change many times under ERA Server 5, but ERA Server 6 has different approach (certificates, agent). I couldn't find tutorial or procedure to follow to. Any idea?

I have found the reason for this issue. It was ODBC definition in /etc/odbcinst.ini. There shouldn't be any leading spaces/tabs before Driver and Setup statements - file content should look like this: [MySQL] Description = ODBC for MySQL Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so FileUsage = 1

This is my firs post here and firs ERA server issue. About 2 weeks ago I installed my first ERA server under Ubuntu 14.04 x64 server - installation went rather smoothly. Yesterday I started next installation on fresh Ubuntu 14.04 x64 server, with same steps - but I am unable to complete due to database connection issue. Here are installation steps so far: 1) installation of mysql-server, setting max_allowed_packet=33M in /etc/mysql/my.cnf 2) installation of xvfb cifs-utils unixodbc libmyodbc 3) set /etc/odbcinst.ini as follows: [MySQL] Description = ODBC for MySQL Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so FileUsage = 1 4) create database and user for ERA Server (era_db and era_user respectively) - this was new step comparing to previous installation 5) issue installer command: sudo ./Server-Linux-x86_64.sh \ --skip-license \ --db-driver='MySQL' \ --db-hostname=127.0.0.1 \ --db-port=3306 \ --db-admin-username=root \ --db-admin-password=[my_pass] \ --server-root-password=[my_pass] \ --db-type='MySQL Server' \ --db-name=era_db \ --db-user-username=era_user \ --db-user-password=[my_pass] \ --cert-hostname="192.168.1.240;Server2" The installer output: Extracting archive, please wait... Archive extracted to /tmp/tmp.lU6NAuLl0Y. Checking OpenSSL ... done [OpenSSL 1.0.1f 6 Jan 2014] Checking installed version... done Status of current installation is: NEW Generating GUID ... done [GUID = 8b0e10fa-7608-4b0a-824d-680da691610b] Checking database connection ... failure Error: Admin connection not working. Unable to continue. The most important part of /var/log/eset/RemoteAdministrator/EraServerInstaller.log file: 2015-04-10 09:23:03 Information: Installer: Checking database connection ... 2015-04-10 09:23:03 Information: DbCheckConnection: Action invoked with: --db-admin-password ********** --db-admin-username admin --db-connectors-dir /tmp/tmp.lU6NAuLl0Y/setup --db-driver MySQL --db-hostname localhost --db-name era_db --db-port 3306 --db-type MySQL Server --db-user-password ********** --db-user-username era_user --silent-reinstall "" 2015-04-10 09:23:03 Information: DbCheckConnection: Set output property: P_DB_PORT = 3306 2015-04-10 09:23:03 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL;Server=localhost;Port=3306;User=admin;Password={******};CharSet=utf8;' 2015-04-10 09:23:03 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TryUserConnectionForDBServer(const string&, const string&, const string&) 2015-04-10 09:23:03 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, bool) 2015-04-10 09:23:03 Information: DbCheckConnection: Set output property: P_DB_ADMIN_CONNECTION_STATUS = 0 2015-04-10 09:23:03 Information: ERROR: DatabaseException with error code '0' and message - [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2015-04-10 09:23:03 Information: DbCheckConnection: Return code: 0 2015-04-10 09:23:03 Information: Installer: Admin connection check failed. Unable to continue. 2015-04-10 09:23:03 Information: Installer: Error: Admin connection not working. Unable to continue. I need to mention that I am able to log with root account (and password passed to installer) to mysql console. I tried also: - changing password for mysql root account and creating new administrator account - using mysql root and password account in installer options --db-user-username and --db-user-password options - using 'localhost' and machine name in installer option --db-hostname but it doesn't solve problem. mclusky