# ContinuaCI cannot initialise PostgresSql
**URL:** https://www.finalbuilder.com/forums/t/continuaci-cannot-initialise-postgressql/5650
**Category:** Discussion
**Created:** [June 12, 2016, 2:59am UTC](https://www.finalbuilder.com/forums/t/continuaci-cannot-initialise-postgressql/5650 "2016-06-12T02:59:58Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@j\_kour](https://www.finalbuilder.com/forums/u/j_kour)
#### Post date: [June 12, 2016, 2:59am UTC](https://www.finalbuilder.com/forums/t/continuaci-cannot-initialise-postgressql/5650/1 "2016-06-12T02:59:58Z")
Hi,
I have the following installation:
On Mac: PostgresSQL (neContinuaCI database)
on Win10 Virtual Machine: ContinuaCI installed and the connection string properly configured.
When I try to access ContinuaCI from a browser, I get the following error:
Log Name: Application
Source: Continua
Date: 12-Jun-16 1:21:31 AM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: NE-BUILD-SERVER
Description:
Could not initialise database:
Npgsql.NpgsqlException:
no pg\_hba.conf entry for host “192.168.1.65”, user “administrator”, database “neContinuaCI”, SSL off
Severity: FATAL
Code: 28000
at Npgsql.NpgsqlState.d\_\_0.MoveNext()
at Npgsql.NpgsqlState.ProcessAndDiscardBackendResponses(NpgsqlConnector context)
at Npgsql.NpgsqlConnector.Open()
at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnection.Open()
at FluentMigrator.Runner.Processors.GenericProcessorBase.EnsureConnectionIsOpen()
at FluentMigrator.Runner.Processors.Postgres.PostgresProcessor.Exists(String template, Object[] args)
at FluentMigrator.Runner.VersionLoader.LoadVersionInfo()
at FluentMigrator.Runner.MigrationRunner…ctor(Assembly assembly, IRunnerContext runnerContext, IMigrationProcessor processor)
at FluentMigrator.Runner.Initialization.TaskExecutor.Initialize()
at FluentMigrator.Runner.Initialization.TaskExecutor.Execute()
at Continua.Migrations.Runner.Execute(String database, String connectionString, String fileName)
at Continua.Server.Service.Migrator.Begin()
Exiting…
Event Xml:
0
2
0
0x80000000000000
622
Application
NE-BUILD-SERVER
Could not initialise database:
Npgsql.NpgsqlException:
no pg\_hba.conf entry for host “192.168.1.65”, user “administrator”, database “neContinuaCI”, SSL off
Severity: FATAL
Code: 28000
at Npgsql.NpgsqlState.<ProcessBackendResponses>d\_\_0.MoveNext()
at Npgsql.NpgsqlState.ProcessAndDiscardBackendResponses(NpgsqlConnector context)
at Npgsql.NpgsqlConnector.Open()
at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnection.Open()
at FluentMigrator.Runner.Processors.GenericProcessorBase.EnsureConnectionIsOpen()
at FluentMigrator.Runner.Processors.Postgres.PostgresProcessor.Exists(String template, Object[] args)
at FluentMigrator.Runner.VersionLoader.LoadVersionInfo()
at FluentMigrator.Runner.MigrationRunner…ctor(Assembly assembly, IRunnerContext runnerContext, IMigrationProcessor processor)
at FluentMigrator.Runner.Initialization.TaskExecutor.Initialize()
at FluentMigrator.Runner.Initialization.TaskExecutor.Execute()
at Continua.Migrations.Runner.Execute(String database, String connectionString, String fileName)
at Continua.Server.Service.Migrator.Begin()
Exiting…
The pg\_hba file on mac has the following entry:
host all all 0.0.0.0/0 trust
and I have added listen\_addresses=’\*'
Now, what does this “cannot initialise database” mean? That Continua can’t connect to postgressql or that after it connects there is another problem?
What do you think?
Thanks
John
---
### Author:  [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)
#### Post date: [June 12, 2016, 3:32am UTC](https://www.finalbuilder.com/forums/t/continuaci-cannot-initialise-postgressql/5650/2 "2016-06-12T03:32:29Z")
It looks to me like it’s connecting. Did you restart postgresql after changing the pg\_hba.conf ( or run SELECT pg\_reload\_conf(); ). Also, I would not use trust, it allows anyone to connect without specifiying a password, totall insecure.
---
### Author:  [@j\_kour](https://www.finalbuilder.com/forums/u/j_kour)
#### Post date: [June 12, 2016, 4:43am UTC](https://www.finalbuilder.com/forums/t/continuaci-cannot-initialise-postgressql/5650/3 "2016-06-12T04:43:46Z")
Yes I have restarted the server but still the same. I know about “trust”. I’ll change it after Continua connects. I was thinking of something else; are database names and user names case-sensitive in Postgresql?
---
### Author:  [@j\_kour](https://www.finalbuilder.com/forums/u/j_kour)
#### Post date: [June 12, 2016, 5:53am UTC](https://www.finalbuilder.com/forums/t/continuaci-cannot-initialise-postgressql/5650/4 "2016-06-12T05:53:36Z")
After hours of digging and experimenting, the connection string holds case sensitive values (databasename, username, etc.) and in my setup with VMs, the IP of mac needs to be entered in the pg\_hba.conf file.
I think I’ve moved one step further.