Log in

QSAR Toolbox: Known issues

1. [15.02.2018] Issue: The Toolbox Client cannot connect to the QSAR Toolbox Windows service.

The error log shows:
StructureMap.Building.StructureMapBuildException: Failure while building 'Lambda: new Database(value(LMC.Toolbox.Server.StartUp.StructureMapBootstrap+<>c__DisplayClass35).connectionStringName)'.

  1. Go to Toolbox server's Bin folder (default folder C:\Program Files (x86)\QSAR Toolbox\QSAR Toolbox 4.2\Toolbox Server\Bin).
  2. Delete the ToolboxServerWindowsSvc.exe.config file
  3. Rename a copy of ToolboxServerApp.exe.config to ToolboxServerWindowsSvc.exe.config. Make sure you don't just rename the original file.
  4. Restart the service.
2. [01.03.2018] Issue: Toolbox server cannot connect to PostgreSQL database when server application and PostgreSQL are deployed on separate machines.

The error log shows:
Npgsql.PostgresException: 28000: no pg_hba.conf entry for host "<IP Address>", user "qsartoolbox", database "EpiReports42".
This happens when the QSAR Toolbox Server is installed on one machine and the PostgreSQL database is deployed on a different machine. The PostgreSQL server would need to be configured to allow access to the deployed databases for the QSAR Toolbox Server Application.

  1. Go to PostgreSQL server's Data folder (default folder C:\Program Files\PostgreSQL\9.6\data) and open the pg_hba.conf file.
  2. Add a line to the bottom of the file changing <ToolboxServerHost> to the IP address or hostname of the computer than is hosting the QSAR Toolbox Server.
  3. host       all           qsartoolbox       <ToolboxServerHost>   md5
  4. Restart the PostgreSQL service.
  5. Restart the QSAR Toolbox Server application/service.
3. [10.07.2018] You have a previous deployment of PostgreSQL server but don't know the password for it. You need to reset the PostgreSQL password.

Fix: Follow the instructions in this document.