[ome-devel] fresh install problem

[kristian kvilekval]

Thanks the quotes solved the first problem.. 

There was another problem unrelated, but troublesome.
I had recently changed offices and while the DNS was updated
I had forgotten to update the /etc/hosts file.  Strangely
everything worked well except OMEIS.  This would croak
and return strange error messages.. Finally  I was trying
to send command directly using telnet <machine> 80
and I noticed the error.  And I've been wondering why
OME failed to work after the move.. 


On Thu, 2005-03-10 at 15:55 -0500, Josiah Johnston wrote: 
> 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
> >
-- 
Kristian Kvilekval,Ph.D.
kris at cs.ucsb.edu  http://www.cs.ucsb.edu/~kris w:805-893-2526 h:504-9756