[ome-devel] fresh install problem

[Josiah Johnston]

The fix is to change line 201 of 
OME/src/perl2/OME/Database/PostgresDelegate.pm to:
         my $sql = "CREATE USER \"$username\"";

This add quotes around the username. This should fix your problem. 
There is a chance other places in the code will bomb out with 
non-standard user names. I can't easily set up a testing harness 
though. Can you try it and report back to the bug page?

I started a bug for this:
	http://bugs.openmicroscopy.org.uk/show_bug.cgi?id=471
But couldn't CC you on it because this address (kris at cs.ucsb.edu) isn't 
registered on bugzilla.

-josiah

On Mar 9, 2005, at 9:14 PM, kristian kvilekval wrote:

>
> I am trying to do a fresh install of 2.4.0 released (3/07) and
> have run into a problem: log below
>
> -------------------------------
> Finding DB configuration in installation environment [USING DEFAULT].
> Database connection information
> N.B.:  The database host must already be installed and running.
> It must already be configured for accepting the connection
> specified here, or a superuser connection from user "postgres".
>    Database Delegate Class: OME::Database::PostgresDelegate
>              Database Name: ome
>                       Host: undefined (local)
>                       Port: undefined (default)
> Username for DB connection: undefined (process owner)
>
> Are these values correct ? [y/n]:
> Creating OME PostgreSQL SUPERUSER (ome)[SUCCESS].
> Creating Apache PostgreSQL SUPERUSER (www-data)[FAILURE].
>
>
> Errors executing task: Unable to create PostgreSQL superuser 
> 'www-data',
> see CoreDatabaseTablesTask.log for details. at (eval 171) line 1
>
>         main::run_tasks() called at install.pl line 249
> # Looks like your test died before it could output anything.
> ------------------------------------
>
>
> $tail /var/tmp/OME/install/CoreDatabaseTablesTask.log
> Creating OME PostgreSQL SUPERUSER (ome)
> Unable to create PostgreSQL superuser 'www-data'
> ERROR:  syntax error at or near "-" at character 60
> $
>
>
>
> Any clues to how to resolve this one
>
>
>
> -- 
> Kristian Kvilekval,Ph.D.
> kris at cs.ucsb.edu  http://www.cs.ucsb.edu/~kris w:805-893-2526 
> h:504-9756
>
> _______________________________________________
> ome-devel mailing list
> ome-devel at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-devel
>