ERA Agent installation on Mac OS X terminal failed

[pipboy3000 3]

Hi all,

 

I've encountered a problem while installing the ESET Agent using terminal on Mac OS X 10.12.1. The agent is already installed, but the connection between the client and the server occasionally drops. I've seen this happening before and to fix this, I usually had to run the agent installation script again. This time however it failed. Any clues?

 

 

 

Edited November 29, 2016 by pipboy3000

[MartinK 378]

From screenshot it seems you are running it using non-standard shell (bash-3.2?) which results in syntax failure... could you try it with /bin/bash ?

 

Also we would be interested in reason why connection fails. From method you use to fix it (using installation repair) it seems there may be problem with AGENTs service/daemon stability. During installation repair, service is restarted which may help in your case. Have you ever discovered or reported this issue on support? Was there any interesting information in trace.log?

Edited November 29, 2016 by MartinK

[pipboy3000 3]

I'm using Putty ver 0.67 to remotely connect to all devices. The same command works on other machines, so I can't see how this could be a problem. Is there any command to manually start the agent from the terminal?

 

I have reported this many moons ago, but at the time our ERA Server was running on Windows 7, so the environment was not stable. It has been moved to virtual appliance since, but the problems still keeps coming back. At the time (probably May - June) I was told that there's a bug in the agent for Mac OS X. 

 

I have ERA Installation log available:

2016-Nov-29 16:34:38 Information: installationcheck: Initialized logging to /tmp/erainstall.log
2016-Nov-29 16:34:38 Information: installationcheck: Output redirected to /tmp/erainstall.log
2016-Nov-29 16:34:38 Information: installationcheck: Created temporary directory /tmp/erainstall
2016-Nov-29 16:34:38 Information: installationcheck: Package path is ''
2016-Nov-29 16:34:38 Information: installationcheck: Default location is ''
2016-Nov-29 16:34:38 Information: installationcheck: Target volume is ''
ESET Remote Administrator Agent v.6.4.232.0 is already installed
2016-Nov-29 16:34:38 Information: installationcheck: ProductInstanceID loaded from config file /Library/Application Support/com.eset.remoteadministrator.agent//config.cfg (15d93774-1f8a-4aab-8e4f-516bf6356e74)
2016-11-29 16:34:38 Information: LoadInstalledData: Action invoked with:  --db-connectors-dir /Applications/ESET Remote Administrator Agent.app/Contents/Helpers/ --db-path /Library/Application Support/com.eset.remoteadministrator.agent//data.db --db-type SQLite --modules-dir /Library/Application Support/com.eset.remoteadministrator.agent//Modules/ --product-guid 15d93774-1f8a-4aab-8e4f-516bf6356e74 --product-name Agent
2016-11-29 16:34:38 Information: Entering function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetConfigEngineData(const std::string &)
2016-11-29 16:34:38 Information: Leaving function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetConfigEngineData(const std::string &)
2016-11-29 16:34:38 Error: get_config_data: CNativeSqliteResultStream: Prepared statement failed with error code 11 and message: database disk image is malformed
2016-11-29 16:34:38 Information: Missing replication link data in configuration
2016-11-29 16:34:38 Information: LoadInstalledData: Return code: 0
Writing detected values (/tmp/InstallationCheck.plist) ... done
Unloading launchd daemon (com.eset.remoteadministrator.agent) ... done
2016-Nov-29 16:34:38 Information: installationcheck: Removed temporary directory /tmp/erainstall
2016-Nov-29 16:34:38 Information: installationcheck: Output redirection terminated
2016-Nov-29 16:34:38 Information: installationcheck: Moving installation log '/tmp/erainstall.log' to '/Users/Administrator/Library/Logs/Eset/RemoteAdministrator/EraAgentInstaller.log'
2016-11-29 16:34:42.N Information: Installer: *******************************************
2016-11-29 16:34:42.N Information: Installer: Initialized log file: /Users/Administrator/Library/Logs/Eset/RemoteAdministrator/EraAgentInstaller.log
2016-11-29 16:34:43.N Information: Installer: Creating directories...
2016-11-29 16:34:43.N Information: Installer: Created 'config' directory: /Library/Application Support/com.eset.remoteadministrator.agent/
2016-11-29 16:34:43.N Information: Installer: Created 'data' directory: /Library/Application Support/com.eset.remoteadministrator.agent//
2016-11-29 16:34:43.N Information: Installer: Created 'logs' directory: /Library/Application Support/com.eset.remoteadministrator.agent//Logs/
2016-11-29 16:34:43.N Information: Installer: Created 'libs' directory: /Applications/ESET Remote Administrator Agent.app//Contents/MacOS/
2016-11-29 16:34:43.N Information: Installer: Starting install sequence.
2016-11-29 16:34:43.N Information: Installer: Installed version loaded from config-file is: 6.4.232.0
2016-11-29 16:34:43.N Information: Installer: GUID loaded from config-file with value: 15d93774-1f8a-4aab-8e4f-516bf6356e74
2016-11-29 16:34:43.N Information: Installer: Checking installed version ...
2016-11-29 16:34:43 Information: CheckVersion: Action invoked with:  --cert-auth-content ********** --cert-auth-path "" --cert-auth-temp-path "" --cert-content ********** --cert-password ********** --cert-password-is-base64 ********** --cert-path "" --cert-temp-path "" --cert-to-check-password ********** --cert-to-check-path "" --computer-added-uuid "" --computer-group-choice "" --connection-chosen host --current-version 6.4.232.0 --db-connectors-dir /Applications/ESET Remote Administrator Agent.app/Contents/Helpers --db-path /Library/Application Support/com.eset.remoteadministrator.agent///data.db --db-scripts-dir /Library/Application Support/com.eset.remoteadministrator.agent///_tmp_db_scripts --db-type SQLite --db-upgrade "" --era-lib-dir /Applications/ESET Remote Administrator Agent.app// --hostname 10.16.1.10 --initial-static-group "" --installed "" --installed-version 6.4.232.0 --log-sequence-id "" --modules-dir /Library/Application Support/com.eset.remoteadministrator.agent///Modules/ --port 2222 --product-guid 15d93774-1f8a-4aab-8e4f-516bf6356e74 --product-name Agent --replication-interval "" --server-cert-temp-path "" --upgrade "" --webconsole-hostname "" --webconsole-password ********** --webconsole-port "" --webconsole-use-domain "" --webconsole-user ""
2016-11-29 16:34:43 Information: CheckVersion: Set output property: P_VERSION_STATUS = REPAIR
2016-11-29 16:34:43 Information: CheckVersion: Return code: 0
2016-11-29 16:34:43.N Information: Installer: Parsed output property: arg_version_status=REPAIR
2016-11-29 16:34:43.N Information: Installer: Loading correct GUID...
2016-11-29 16:34:43 Information: LoadCorrectProductGuid: Action invoked with:  --cert-auth-content ********** --cert-auth-path "" --cert-auth-temp-path "" --cert-content ********** --cert-password ********** --cert-password-is-base64 ********** --cert-path "" --cert-temp-path "" --cert-to-check-password ********** --cert-to-check-path "" --computer-added-uuid "" --computer-group-choice "" --connection-chosen host --current-version 6.4.232.0 --db-connectors-dir /Applications/ESET Remote Administrator Agent.app/Contents/Helpers --db-path /Library/Application Support/com.eset.remoteadministrator.agent///data.db --db-scripts-dir /Library/Application Support/com.eset.remoteadministrator.agent///_tmp_db_scripts --db-type SQLite --db-upgrade "" --era-lib-dir /Applications/ESET Remote Administrator Agent.app// --hostname 10.16.1.10 --initial-static-group "" --installed REPAIR --installed-version 6.4.232.0 --log-sequence-id "" --modules-dir /Library/Application Support/com.eset.remoteadministrator.agent///Modules/ --port 2222 --product-guid 15d93774-1f8a-4aab-8e4f-516bf6356e74 --product-name Agent --replication-interval "" --server-cert-temp-path "" --upgrade "" --webconsole-hostname "" --webconsole-password ********** --webconsole-port "" --webconsole-use-domain "" --webconsole-user ""
2016-11-29 16:34:43 Information: GetProductGuid: Loading GUID from the database...
2016-11-29 16:34:43 Information: GetProductGuid: Could not read ProductGuid from the DATABASE because of the error: CNativeSqliteResultStream: Prepared statement failed with error code 11 and message: database disk image is malformed
2016-11-29 16:34:43 Information: GetProductGuid: GUID was NOT loaded from the database. Loading GUID from the property...
2016-11-29 16:34:43 Information: GetProductGuid: Final choice of GUID is: 15d93774-1f8a-4aab-8e4f-516bf6356e74
2016-11-29 16:34:43 Information: LoadCorrectProductGuid: Set output property: P_PRODUCT_GUID = 15d93774-1f8a-4aab-8e4f-516bf6356e74
2016-11-29 16:34:43 Information: LoadCorrectProductGuid: Return code: 0
2016-11-29 16:34:43.N Information: Installer: Parsed output property: arg_product_guid=15d93774-1f8a-4aab-8e4f-516bf6356e74
2016-11-29 16:34:43.N Information: Installer: Loading of GUID was successful (new GUID = 15d93774-1f8a-4aab-8e4f-516bf6356e74)
2016-11-29 16:34:43.N Information: Installer: Creating config file: /Library/Application Support/com.eset.remoteadministrator.agent//config.cfg
2016-11-29 16:34:43.N Information: Installer: Config file created
2016-11-29 16:34:43.N Information: Installer: Copying ESET Modules to /Library/Application Support/com.eset.remoteadministrator.agent///Modules/
2016-11-29 16:34:44.N Information: Installer: Reading database status...
2016-11-29 16:34:44 Information: DbCheckConnection: Action invoked with:  --cert-auth-content ********** --cert-auth-path "" --cert-auth-temp-path "" --cert-content ********** --cert-password ********** --cert-password-is-base64 ********** --cert-path "" --cert-temp-path "" --cert-to-check-password ********** --cert-to-check-path "" --computer-added-uuid "" --computer-group-choice "" --connection-chosen host --current-version 6.4.232.0 --db-connectors-dir /Applications/ESET Remote Administrator Agent.app/Contents/Helpers --db-path /Library/Application Support/com.eset.remoteadministrator.agent///data.db --db-scripts-dir /Library/Application Support/com.eset.remoteadministrator.agent///_tmp_db_scripts --db-type SQLite --db-upgrade "" --era-lib-dir /Applications/ESET Remote Administrator Agent.app// --hostname 10.16.1.10 --initial-static-group "" --installed REPAIR --installed-version 6.4.232.0 --log-sequence-id "" --modules-dir /Library/Application Support/com.eset.remoteadministrator.agent///Modules/ --port 2222 --product-guid 15d93774-1f8a-4aab-8e4f-516bf6356e74 --product-name Agent --replication-interval "" --server-cert-temp-path "" --upgrade "" --webconsole-hostname "" --webconsole-password ********** --webconsole-port "" --webconsole-use-domain "" --webconsole-user ""
2016-11-29 16:34:44 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 
2016-11-29 16:34:44 Information: DbCheckConnection: Set output property: P_DB_STATUS = 
2016-11-29 16:34:44 Information: DbCheckConnection: Set output property: P_DB_UPGRADE = 
2016-11-29 16:34:44 Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER = 
2016-11-29 16:34:44 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const std::string &, bool)
2016-11-29 16:34:44 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const std::string &, bool)
2016-11-29 16:34:44 Information: Entering function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatusForEmbeddedDB(const std::string &, const std::string &, const std::string &)
2016-11-29 16:34:44 Information: DatabaseReader: Recycling current DB connection.
2016-11-29 16:34:44 Information: Entering function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatus(const std::string &, const std::string &, const std::string &, std::stringstream &, std::vector<std::string> &)
2016-11-29 16:34:44 Information: Leaving function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatus(const std::string &, const std::string &, const std::string &, std::stringstream &, std::vector<std::string> &)
2016-11-29 16:34:44 Information: Leaving function: std::string Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatusForEmbeddedDB(const std::string &, const std::string &, const std::string &)
2016-11-29 16:34:44 Information: DbCheckConnection: Set output property: P_DB_STATUS = DB_INVALID
2016-11-29 16:34:44 Information: DbCheckConnection: Set output property: P_DB_UPGRADE = 0
2016-11-29 16:34:44 Error: It is not possible to deploy the database, status of the database is: DB_INVALID
2016-11-29 16:34:44 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 77701
2016-11-29 16:34:44 Information: DbCheckConnection: Return code: 0
2016-11-29 16:34:44.N Information: Installer: Parsed output property: arg_db_connection_status=77701
2016-11-29 16:34:44.N Information: Installer: Parsed output property: arg_db_status=DB_INVALID
2016-11-29 16:34:44.N Information: Installer: Parsed output property: arg_db_upgrade=0
2016-11-29 16:34:44.N Information: Installer: Parsed output property: arg_db_use_first_user=
2016-11-29 16:34:44.N Information: Installer: Database read successfully.
2016-11-29 16:34:44.N Information: Installer: Database status is 'DB_INVALID'
2016-11-29 16:34:44.N Information: Installer: /tmp/PKInstallSandbox.BuyXzn/Scripts/com.eset.remoteadministrator.agent.SufSCv/postinstall: Database status is 'DB_INVALID'. Database cannot be upgraded, because it is corrupted or it is not ERA database.

Edited November 29, 2016 by pipboy3000

[MartinK 378]

Installation repair fails because AGENTs database is corrupted and we are not able to recover from this state. We have not seen much of errors like this -> it is most probably caused by HW or power failure.

Simplest solution in this case is to re-install AGENT (uninstall using Uninstall.command + install) which will result in "duplicate" entry in Webconsole.

[pipboy3000 3]

Ok, what's the command syntax to uninstall the agent?

[MartinK 378]

Ok, what's the command syntax to uninstall the agent?

 

I cannot verify it currently, but uninstallation script should be located on path:

/Applications/ESET Remote Administrator Agent.app/Contents/Scripts/Uninstall.command

or somewhere around. You have to run it with administrator (sudo) privileges.

[pipboy3000 3]

Brilliant, this worked and the script was exactly where you said it is. Uninstall, fresh install and the problem is gone.