Database Installation / Configuration Instructions.

BoincSpy has the ability to save all the results sent to BOINC projects to be saved locally to a database, this can be used to calculate the following analytics:

Usage

 

BoincSpy supports 4 different databases. They are:

 

Database Version Capabilities
Microsoft SQL Server 2005 or greater Supports running  BOINC running on other computers, requires  SQL server knowledge
MySQL 5.1  or greater Supports running BOINC running on other computers, requires mySQL knowledge
SQLite 1.6.x or greater Embedded SQL Server engine. Used when there is only one computer saving results. No setup required.
SetiSpy N/A Legacy, not all analytic data available, no setup required.

 

 

Microsoft SQL Server / MySQL servers require a lot of setup and knowledge, however SQLlite and SetiSpy require no setup except to launch a background process.

 

Setup

 

Before you use BoincSpy.Setup.exe, you need to provide username / passwords for  Microsoft SQL  and MySql servers. If you are not running these, you can skip to Running BoincSpy.Setup.exe

 

MySQL:

Microsoft SQL Server:

 

You can use the management console to create the user or use the command line below: ( You need to be logged into the machine that the server is installed on )             

	osql>EXEC sp_addlogin 'some_user', 'some_password'
	osql> go

 

Running BoincSpy.Setup.exe.

 

BoincSpy.Setup will:

Execute BoincSpy.Setup.exe.

 

If you have not run BoincSpy before it will prompt you to accept a disclaimer. Hit next, The following screen will then be shown:

 

Select Database

 

Select the database you wish to use. If you selected either Microsoft SQL Server or MySql then you will shown the username / password and Hostname where the server is located.

 

Credentials

 

 

Once all the parameters have been selected, Hit the next key and if there are no issues the database will be created and you should be can start using BoincSpy. If there are errors they will be in BoincSpy/log directory called BoincSpy.Setup.log

 

Windows only: After running setup. Log out of your workstation and log in again.

 

For Mono platforms, you can start the DBAgent manually by going to the BoincSpy\bin directory and executing:

 

mono BoincSpyAgent.exe

 

 

Updating Database

 

When you install a new version of BoincSpy all applications will check if the current database schema version needs to be upgraded. They will tell you to run BoincSpy.Setup.exe. You will be shown a screen similar to below:

 

Database upgrade

 

Click on upgrade to initiate the upgrade.

 

 

Supporting Multiple BOINC clients to store results.

 

If you have selected the Mysql or Microsoft SQL server database option, you can get the result of other BOINC client  to be stored on the database. To do this:

You will see the following:

 

Database exists.

 

Select No, if you hit Yes YOU WILL RE-CREATE the database. Loosing all your data. You will need to restore the database from a Backup.

 

Windows only: After running setup. Log out of your workstation and log in again.

 

For Mono platforms, you can start the DBAgent manually by going to the BoincSpy\bin directory and executing:

 

mono BoincSpyAgent.exe

 

 

Running the Agent as service:.

 

 

This is no longer supported, if you have already set this up, the agent it will still continue to work.

 

 

Last Updated: May 01, 2011 16:36