[Cdash] cdash 1.4.2 fails to install on postgresql 8.3

[John Calixto]

Hi Julien,

Thanks for the quick turnaround.  I managed to get cdash installed with your install.php.  However, I have an issue with the code coverage module - I'll describe it and maybe you can tell me if it's related to pgsql db initialization.

Repro Steps
-----------
1. Click on a Coverage Percentage link for a test run
2. Click on a source code file link to view the line-by-line coverage
3. For the postgresql-backed cdash instance, observe that instead of the annotated source code, you see something like:

    Resource id #19

FWIW, I have a cdash instance pointed at a temporary MySQL server for comparison.  I installed cdash using your latest install.php, add an identical project using the UI, and ran the same ``make Experimental`` from my build (just pointed at the new cdash instance), and I got the expected result - a source file with the coverage annotations on the left.

Thanks for any insight you may have on this one,
John

-----Original Message-----
From: Julien Jomier [mailto:julien.jomier at kitware.com]
Sent: Wednesday, December 23, 2009 12:00 PM
To: John Calixto
Cc: cdash at public.kitware.com
Subject: Re: [Cdash] cdash 1.4.2 fails to install on postgresql 8.3

Hi John,

There was a bug in the install script for PostGreSQL. I have attached a new install.php file that you should replace and rerun the install script (drop the database before).

Let me know if that works,
Julien

John Calixto wrote:
> Hello folks,
>
> I'm trying to install CDash with a postgresql 8.3.8 backend, install.php fails with:
>
>     ERROR: cannot insert multiple commands into a prepared statement
>
> I'm not sure which query failed.  When I inspect the db using psql, I see many tables, but I see an empty ``user`` table and an empty ``version`` table.
>
> Can somebody help direct my investigation of this issue?
>
> Thanks,
>
> John
>
> This message contains information which is confidential and privileged.  Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message.
> _______________________________________________
> Cdash mailing list
> Cdash at public.kitware.com
> http://public.kitware.com/cgi-bin/mailman/listinfo/cdash
>

This message contains information which is confidential and privileged.  Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message.