<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>Postgres problem</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>I'm having an issue installing 2_6_0 on a CentOS box. The box has a working Postgresql 8.1.4 installation, and the user posgres exists. The OME installer dies with:<BR>
-><BR>
--------------------<BR>
Database Bootstrap<BR>
--------------------<BR>
<BR>
(All verbose information logged in /var/tmp/OME/install/CoreDatabaseTablesTask.log)<BR>
<BR>
Finding DB configuration in installation environment [USING DEFAULT].<BR>
Database connection information<BR>
N.B.: The database host must already be installed and running.<BR>
It must already be configured for accepting the connection<BR>
specified here, or a superuser connection from user "postgres".<BR>
Database Delegate Class: OME::Database::PostgresDelegate<BR>
Database Name: ome<BR>
Host: undefined (local)<BR>
Port: undefined (default)<BR>
Username for DB connection: undefined (process owner)<BR>
<BR>
Are these values correct ? [y/n]:<BR>
Creating OME PostgreSQL SUPERUSER (ome)Use of uninitialized value in concatenation (.) or string at /home/mrmike/OME_2_6/OME/src/perl2/OME/Install/CoreDatabaseTablesTask.pm line 1328, <STDIN> line 32.<BR>
Use of uninitialized value in concatenation (.) or string at /home/mrmike/OME_2_6/OME/src/perl2/OME/Install/CoreDatabaseTablesTask.pm line 1337, <STDIN> line 32.<BR>
Use of uninitialized value in concatenation (.) or string at /home/mrmike/OME_2_6/OME/src/perl2/OME/Install/CoreDatabaseTablesTask.pm line 1348, <STDIN> line 32.<BR>
[FAILURE].<BR>
Use of uninitialized value in concatenation (.) or string at /home/mrmike/OME_2_6/OME/src/perl2/OME/Install/CoreDatabaseTablesTask.pm line 1352, <STDIN> line 32.<BR>
<BR>
<BR>
Errors executing task: Unable to create PostgreSQL superuser 'ome', see CoreDatabaseTablesTask.log for details.<BR>
Database error:<BR>
at (eval 214) line 1<BR>
<BR>
at install.pl line 82<BR>
main::run_tasks() called at install.pl line 266<BR>
# Looks like your test died before it could output anything.<BR>
<-<BR>
<BR>
The log file looks like:<BR>
-><BR>
[root@cisrdev OME]# more /var/tmp/OME/install/CoreDatabaseTablesTask.log<BR>
Creating OME PostgreSQL SUPERUSER (ome)<BR>
Result for creating OME_USER ome:<BR>
<BR>
Result for creating OME_USER ome as postgres:<BR>
<BR>
Result for creating OME_USER ome as postgres After euid()<BR>
<-<BR>
<BR>
It appears that $db_delegate->errorStr() never gets set in CoreDatabaseTablesTask.pm even though there is an error of some type.<BR>
I can manually create an ome database and the user ome.<BR>
<BR>
Any idea where to start looking?<BR>
<BR>
Thanks,<BR>
Mike<BR>
<BR>
Michael J. McCaughey, PhD<BR>
Molecular Physiology and Biophysics<BR>
U9203 MRBIII<BR>
6-6175<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>