Hi Tom,
It was a very complete answer, you should put it in a wiki page as a
troubleshooting.
Best
Luiz Claudio Santos
http://luizclaudiosantos.me/
On Tue, Jan 31, 2017 at 4:03 PM, Tom Desair <[email protected]> wrote:
> 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.
>
--
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.
