Known Issues
ISSUE
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.
ISSUE
The Toolbox Server cannot connect to the PostgreSQL database when the server application and PostgreSQL are deployed on separate machines
The error log shows:
Npgsql.PostgresException: 28000: no pg_hba.conf entry for host "", 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.
FIX
- Go to PostgreSQL server's Data folder (default folder C:\Program Files\PostgreSQL\9.6\data) and open the pg_hba.conf file.
- 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.
host all qsartoolbox md5
- Restart the PostgreSQL service.
- Restart the QSAR Toolbox Server application/service.
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)'.
FIX
- Go to Toolbox server's Bin folder (default folder C:\Program Files (x86)\QSAR Toolbox\QSAR Toolbox 4.2\Toolbox Server\Bin).
- Delete the ToolboxServerWindowsSvc.exe.config file
- Rename a copy of ToolboxServerApp.exe.config to ToolboxServerWindowsSvc.exe.config. Make sure you don't just rename the original file.
- Restart the service.