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
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.
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?
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.