[OPEN-ILS-DEV] DB error on install

[Dan Scott]

Hi:

On Debian, by default you need to specify the hostname and port to
which you are connecting for the PostgreSQL database. These are
normally set as part of the 'make config' command and passed as part
of the set of arguments to the build-db.sh script in
Open-ILS/src/sql/Pg/.

Try:

PGHOST=localhost PGPORT=5432 PGPASSWORD=evergreen PGUSER=evergreen
PGDATABASE=evergreen psql -f 000.english.pg81.fts-config.sql

or:

pgsql -U evergreen -h localhost -f 000.english.pg81.fts-config.sql

Dan

2008/5/16  <evergreen at copelan.com>:
> Hello,
> I am trying to install Evergreen 1.2.2.0 on Debian.   Everything worked on
> until step 6 when doing the "make install".   When doing the
> storage-bootstrap section there is a failure mesasge: "psql: could not
> connect to server: Connection refused".  I have confirmed that psql can
> connect to the server by entering it on the command line.  I went into the
> scripts and manually typed one of the statements from the script being
> executed by that step:
> PGPASSWORD=evergreen PGUSER=evergreen PGDATABASE=evergreen psql -f
> 0000.english.pg81.fts-config.sql
>
> That gets a  "psql: FATAL: Ident authentication failed for user "evergreen"
>
> I have dropped and recreated the role evergreen in order to validate the
> password.   Am probably missing something really obvious but since my
> background is mySQL and not postgresql it just isn't clear.
>
> Any ideas would be appreciated.
> Regards,
> Robert
>
>
>
>



-- 
Dan Scott
Laurentian University