[CDash] Installing and Setting up CDash/Postgresql

[Andrew Maclean]

Following on:
1) You need to create the postgresql user and the cdash database first.
2) You then need to config.local.php as appropriate and then set the
correct permissions on some folders.
3) Then in the browser type: http://localhost/CDash/install.php
After filling in the form I get the following error:
"ERROR: relation "uuid" already exists"
At this point the build table and indexes have been created.
If I do a refresh and resubmit the form, I get this error:
"ERROR: relation "build" already exists"

Ok ... "build" already exists but the script will not continue.

Now after commenting out line 42 in cdash.sql and redoing the install, I
get the database built (100 tables).

Looking at the documentation in:
http://www.postgresql.org/docs/9.0/static/ddl-constraints.html
It seems that "Adding a unique constraint will automatically create a
unique btree index on the column or group of columns used in the
constraint." so that line is not needed in Postgresql.

Is this a safe thing to do?
When you read on there is this paragraph:
"In general, a unique constraint is violated when there is more than one
row in the table where the values of all of the columns included in the
constraint are equal. However, two null values are not considered equal in
this comparison. That means even in the presence of a unique constraint it
is possible to store duplicate rows that contain a null value in at least
one of the constrained columns. This behavior conforms to the SQL standard,
but we have heard that other SQL databases might not follow this rule. So
be careful when developing applications that are intended to be portable."

Thanks
    Andrew


On Thu, Feb 25, 2016 at 10:32 AM, Andrew Maclean <andrew.amaclean at gmail.com>
wrote:

> I'm setting up CDash in Ubuntu and I think that I have followed all the
> instructions Ok, however when I type: http://localhost/CDash/ in the
> browser it comes up with:
> http://localhost/CDash/viewProjects.php.
> How do I continue the install process?
> The documentation on  http://public.kitware.com/Wiki/CDash:Installation
> seems to indicate that "The first step will confirm the host login and
> password for the database, the default admin account and password are also
> displayed, make a note of these as you'll need them later, as its easy to
> skip past this step missing them ".
>
> Attached is a markdown file documenting what I have done so far. I
> installed and set up Apache and I am now trying to set up CDash. Then I
> will set up Postgres. Or do I need to set up Postgresql before setting up
> CDash? If so what will be the database name and user name?
>
>
> Any help would be appreciated.
>
> Rgeards
>    Andrew
>
> --
> ___________________________________________
> Andrew J. P. Maclean
>
> ___________________________________________
>



-- 
___________________________________________
Andrew J. P. Maclean

___________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://public.kitware.com/pipermail/cdash/attachments/20160225/0c47a0c7/attachment-0001.htm>