[OPEN-ILS-DEV] Could not determine version of PostgreSQL error

[Demas, Christopher D]

Dan -

Thanks so much!  It was the "\" characters that got me.  I re-ran the command without them and it worked.  I'm really new to the Linux world so I'm learning.  It might be helpful to add a small note on the installation instructions so other people unfamiliar with this might not have the same problem.  Just a suggestion.  Again, thank you so much.

Chris 



> -----Original Message-----
> From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-
> dev-bounces at list.georgialibraries.org] On Behalf Of Dan Scott
> Sent: Monday, March 02, 2009 10:14 AM
> To: Evergreen Development Discussion List
> Subject: Re: [OPEN-ILS-DEV] Could not determine version of PostgreSQL
> error
> 
> 2009/2/27 Demas, Christopher D <cddemas at northeaststate.edu>:
> > Hello all –
> >
> >
> >
> > We need some help.  We are trying to install evergreen and we got to
> Section
> > III number 4 on the instructions
> > http://open-ils.org/dokuwiki/doku.php?id=server:1.4.0:install
> >
> >
> >
> > ·  As the root user, create the database schema and configure your
> system
> > with the corresponding database authentication details for the
> database user
> > that you just created; on most systems, <hostname> will be localhost
> and
> > <port> will be 5432:
> >
> > cd /home/opensrf/Evergreen-ILS-1.4.0.2
> >
> > perl Open-ILS/src/support-scripts/eg_db_config.pl --update-config \
> >
> >        --service all --create-schema --create-bootstrap --create-
> offline \
> >
> >        --user <user> --password <password> --hostname <hostname> --
> port
> > <port> \
> >
> >        --database <dbname>
> >
> >
> >
> >
> >
> > We did this and got the following error:
> >
> >
> >
> >
> >
> > root at ubuntu:/home/opensrf/Evergreen-ILS-1.4.0.2# perl
> > Open-ILS/src/support-scripts/eg_db_config.pl --update-config \ --
> service all
> > --create-schema --create-bootstrap --create-offline \ --user
> evergreen
> > --password evergreen --hostname localhost --port 5432 \ --database
> evergreen
> > Use of uninitialized value in subroutine entry at
> > Open-ILS/src/support-scripts/eg_db_config.pl line 64.
> > Use of uninitialized value in subroutine entry at
> > Open-ILS/src/support-scripts/eg_db_config.pl line 64.
> > Use of uninitialized value in subroutine entry at
> > Open-ILS/src/support-scripts/eg_db_config.pl line 64.
> > Use of uninitialized value in subroutine entry at
> > Open-ILS/src/support-scripts/eg_db_config.pl line 64.
> > Use of uninitialized value in subroutine entry at
> > Open-ILS/src/support-scripts/eg_db_config.pl line 64.
> > Use of uninitialized value in subroutine entry at
> > Open-ILS/src/support-scripts/eg_db_config.pl line 64.
> > Use of uninitialized value in subroutine entry at
> > Open-ILS/src/support-scripts/eg_db_config.pl line 64.
> > Use of uninitialized value in subroutine entry at
> > Open-ILS/src/support-scripts/eg_db_config.pl line 64.
> > Backed up original configuration file to
> > '/openils/conf/opensrf.xml.2009.2.26.14.44.50'
> > psql: FATAL:  no PostgreSQL user name specified in startup packet
> >
> ***********************************************************************
> *********
> > * Could not determine the version of PostgreSQL you have installed.
> Our
> > best  *
> > * guess
> >
> was:
> *
> > *
> > * which didn't make any sense.  For assistance, please
> > email                   *
> > * open-ils-general at list.georgialibraries.org or join #OpenILS-
> Evergreen on
> > the *
> > * freenode IRC
> > network.                                                        *
> >
> ***********************************************************************
> *********
> > Writing database bootstrapping configuration to
> > /openils/conf/live-db-setup.pl
> > Writing offline database configuration to /openils/conf/offline-
> config.pl
> >
> >
> >
> > We have PostgreSQL 8.2.12 installed and it’s running so I’m
> confused.  Any
> > assistance anyone can give would be great.  I’m running on Ubuntu
> 8.10. and
> > I’m a newbie.  Thanks.
> 
> Hi Chris:
> 
> Can you connect to the database if you just issue the command:
> 
> psql -U evergreen -h localhost -p 5432 evergreen
> 
> If not, then the reason the script can't determine the version of
> PostgreSQL that's running is because it can't connect to the database.
> 
> If that's the case, please let us know - the script should fail a
> little more gracefully and issue a more obvious error than that if it
> can't connect.
> 
> Another thought - those "\" characters in the command are supposed to
> appear at the end of line as a means of extending a long command over
> multiple lines. If you're putting the whole command on one line, then
> take those characters out - it might be the case that the script is
> ignoring all of the command line arguments after the first "\" in your
> command.
> 
> --
> Dan Scott
> Laurentian University