Jose,
The most common problem I've seen with this is related the pgcrypto extension
being installed with a superuser account and database that aren't the same as
what's being used by the DSpace installation. The documentation isn't explicit
about this as I recall.
For instance, if your DSpace install uses a database called "dspace6" and the
user "dspaceadmin", you'd want to connect into Postgres database dspace6 as
dspaceadmin and install the pgcrypto extension that way so it's localized to
the active DSpace database and visible to the user connecting in.
-Jeff
________________________________________
From: dspace-tech@googlegroups.com <dspace-tech@googlegroups.com> on behalf of
Jose Blanco <blan...@umich.edu>
Sent: Tuesday, February 11, 2020 10:55 AM
To: DSpace Technical Support
Subject: [dspace-tech] pgcrypto not installed error
getting this error when doing "ant fresh_install"
[java] Database Type: postgres
[java] Database URL: jdbc:postgresql://localhost:5432/dspace-dev-63
[java] Database Schema: public
[java] Database Username: dspace-dev-30
[java] Database Software: PostgreSQL version 9.4.25
[java] Database Driver: PostgreSQL JDBC Driver version 42.2.1.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]
[java] 2020-02-11 11:50:18,893 WARN
org.dspace.services.sessions.SessionRequestServiceImpl @ Request interceptor
(org.dspace.services.events.SystemEventService$EventRequestInterceptor@2bfc86ba)
failed to execute on end (request-796-1581439818722): null
but I see that it is installed.
dspace-dev-63=> SELECT * FROM pg_available_extensions WHERE name = 'pgcrypto';
name | default_version | installed_version | comment
----------+-----------------+-------------------+-------------------------
pgcrypto | 1.1 | | cryptographic functions
(1 row)
--
All messages to this mailing list should adhere to the DuraSpace Code of
Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
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
dspace-tech+unsubscr...@googlegroups.com<mailto:dspace-tech+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-t_8Yh0_5fS%2B4cTEvkcuuiXa%2B5O0L71rWcpWRf0yn_j%2Bg%40mail.gmail.com<https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-t_8Yh0_5fS%2B4cTEvkcuuiXa%2B5O0L71rWcpWRf0yn_j%2Bg%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
All messages to this mailing list should adhere to the DuraSpace Code of
Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
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 dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/BN8PR05MB6644278A91659CB8E6DD90BED0180%40BN8PR05MB6644.namprd05.prod.outlook.com.
