Hi Walter,
You need to make sure of the following:
1. *Allow the "dspace" PostgreSQL user to connect using a password:* This
means having the following line to the pg_hba.conf file:
- "host dspace dspace 127.0.0.1 255.255.255.255
md5"
- This tells the Postgres server to allow database connection for
user DSpace using password authentication but only when the request comes
from ip address *127.0.0.1 *(which is localhost)
2. *Test database connection*: On your DSpace server, verify that as
a user which is not dspace that you can connect to the PostgreSQL database
using:
- psql -h localhost -p 5432 -d dspace -U dspace
- This should prompt you for a password
3. *local.cfg values: *In your local.cfg file, you should have the
following property:
- db.url = jdbc:postgresql://localhost:5432/dspace
- Note that using "localhost" here is important because in step 1 we
told the Postgres database to only allow connection coming from
localhost.
If you put "irtest.library.uaf.edu" here, the request to the database
will go through the full network stack and the Postgres database will see
your external network IP address as the request IP address and not allow
access.
4. *Make sure the "dspace" user has the correct roles: *Connect to
your PostgreSQL database and execute:
- ALTER ROLE dspace NOSUPERUSER CREATEDB NOCREATEROLE NOCREATEUSER;
Do these steps solve your problem?
[image: logo] Tom Desair
250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586
Esperantolaan 4, Heverlee 3001, Belgium
www.atmire.com
<http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=tomdesair>
2017-01-31 21:23 GMT+01:00 Walter Rutherford <[email protected]>:
> I remember having some difficulty during the database part of the
> installation. I'm tempted to rip out the
> database down to reinstalling Postgres and starting over. But before I do,
> should the dspace user have
> an special privileges? I didn't see where any should be set in the
> instructs so it looks pretty bare:
>
>> dspace=> \du
>> List of roles
>> Role name | Attributes |
>> Member
>> of
>> -----------+------------------------------------------------
>> ------------+-------
>> ----
>> dspace | |
>> {}
>> postgres | Superuser, Create role, Create DB, Replication, Bypass RLS |
>> {}
>> walter | |
>> {}
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
