Could not initialise database

Continua CI Discussion
1

Hi,

I've been trying to install Continua for the last two days. I've finally reached the stage where I have the ContinuaCI Application Service and the ContinuaCI SSH Server running and a full installation of postgreSQL is present. I've created a database in postgreSQL owned by user "continua" called "ContinuaCI".

When I try to access ContinuaCI via localhost:8101 (which is the port where I'm running the website), I get the following log message:

------

The Continua Server Service is starting up...

    12:35 PM : Starting
    12:35 PM : Creating Application Setup.
    12:35 PM : Creating Application instance.
    12:35 PM : Starting
    12:35 PM : Setting up Loggers
    12:35 PM : Migrating Database
    12:35 PM : Could not initialise database: Unable to resolve any connectionstring using parameters "/connection" and "/configPath" Check the eventlog for more info.

    12:35 PM : Starting Application instance.

------

In the event log, I have the following:

 

Event Type:    Error
Event Source:    Continua
Event Category:    None
Event ID:    0
Date:        22/08/2012
Time:        12:35:17 PM
User:        N/A
Computer:    WINDSORDEV
Description:
Could not initialise database:

FluentMigrator.Runner.Initialization.UndeterminableConnectionException: Unable to resolve any connectionstring using parameters "/connection" and "/configPath"
   at FluentMigrator.Runner.Initialization.ConnectionStringManager.OutputResults()
   at FluentMigrator.Runner.Initialization.ConnectionStringManager.LoadConnectionString()
   at FluentMigrator.Runner.Initialization.TaskExecutor.InitializeProcessor(String assemblyLocation)
   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...

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

------

 

Could you suggest what I need to do to fix this problem?

 

 

Many thanks,

James

2

Hi James,
It looks like the database settings maybe incorrect. You can find the settings in the Continua.Server.Service.exe.config file. If you installed Continua in the default location it would be in: C:\Program Files\VSoft Technologies\ContinuaCI\Server<br>

Open the config file in an editor (Notepad, etc…) and look for the section:


In this section you’ll find a property element like this:

[code]Server=127.0.0.1;Port=9001;Database=ContinuaCI;UserId=postgres;Password=password;MinPoolSize=10;MaxPoolSize=256[/code]

Alternatively you could just search the file for “connection.connection_string”.

Verify all the attributes of that element reflect the database you’re trying to connect to.

Let us know how you go and we’ll take it from.


You mentioned it’s taken you two days to get it up and running. Are there problems you encountered that would’ve been easier to solve if there were more instructions in the wiki?



3

Hi Vinnie,

Thanks for the quick response. In my config file under the header , I had an empty connection string, i.e.,


I copied across the one from the commented section and updated the parameters, and the connection now works. James

4

Hi James

Can you tell us whether you are using the 32bit or 64bit version and the same goes for Server 2003.

5

Both are 32-bit.