Thank you Tom.
1) I have the md5 line in the pg_hba.conf file
3) Changed dspace.hostname to "localhost" then later to localhost (no
quotes) since that's the default
4) Postgres complained with I tried to reset dspace's attributes
postgres=# alter role dspace NOSUPERUSER CREATEDB NOCREATEROLE
NOCREATEUSER;
ERROR: conflicting or redundant options
Not sure what it didn't like but, since it didn't have any superpowers
before, I just added CREATEDB and that passed.
2) Now I can access the database BUT only if I don't specify '-U dspace'.
[root@irtest config]# su - walter
[walter@irtest ~]$ psql -h localhost -p 5432 -d dspace -U dspace
psql: FATAL: Ident authentication failed for user "dspace"
[walter@irtest ~]$ psql -d dspace
psql (9.5.5)
Type "help" for help.
dspace=> \du
List of roles
Role name | Attributes |
Member
of
-----------+------------------------------------------------------------+-------
dspace | Create DB | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
walter | | {}
dspace=> \q
[walter@irtest ~]$ psql -d dspace -U dspace
psql: FATAL: Peer authentication failed for user "dspace"
[walter@irtest ~]$ [walter@irtest ~]$ psql -d dspace -p 5432
psql (9.5.5)
Type "help" for help.
dspace=> \c
You are now connected to database "dspace" as user "walter".
dspace=> \q
[walter@irtest ~]$
The mvn command succeeded but, at first, the 'ant fresh_install' failed. :-(
But I realized that was because *somebody* had stopped the database server.
If failed a second time but AFTER it successfully connected to the database!
That is SO much closer - Now it's only complaining about pgcrypto which I
was
sure I had added weeks ago. Now I wonder if I installed it on a different
database.
test_database:
[java] 2017-01-31 13:06:47,925 WARN
org.dspace.services.email.EmailServiceImpl @ Couldn't get an email session
from environment: Need to specify class name in environment or system
property, or as an applet parameter, or in an application resource file:
java.naming.factory.initial
[java]
[java] Attempting to connect to database
[java] Connected successfully!
[java]
[java] Database Type: postgres
[java] Database URL: jdbc:postgresql://localhost:5432/dspace
[java] Database Schema: public
[java] Database Username: dspace
[java] Database Software: PostgreSQL version 9.5.5
[java] Database Driver: PostgreSQL Native Driver version PostgreSQL
9.4.1211.jre7
[java] PostgreSQL 'pgcrypto' extension installed/up-to-date? false
(not installed)
[java]
[java] WARNING: Required PostgreSQL 'pgcrypto' extension is NOT
INSTALLED on this database.
[java]
[java] ** DSpace REQUIRES PostgreSQL >= 9.4 AND pgcrypto extension >=
1.1 **
[java]
[java] To install it, please connect to your DSpace database as a
'superuser' and manually run the following command:
[java]
[java] CREATE EXTENSION pgcrypto;
[java]
I added the pgcrypto extension and reran the ant command. Holy Smokes! It
worked!
BUILD SUCCESSFUL
Total time: 19 seconds
I haven't gotten to the part where it coordinates with Tomcat but they
shouldn't conflict because
the database is using port 6543 and Tomcat uses 8080.
Thanks again. I'll walk through the rest of the installation. Wish me luck!
--
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.
