On Tue, Feb 11, 2020 at 11:55:38AM -0500, Jose Blanco wrote: > 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)
Presence of an extension in pg_available_extensions only shows that it is available for installation. Above, 'installed_version' is null, showing that the extension is *not* installed in that database. https://www.postgresql.org/docs/9.4/view-pg-available-extensions.html -- Mark H. Wood Lead Technology Analyst University Library Indiana University - Purdue University Indianapolis 755 W. Michigan Street Indianapolis, IN 46202 317-274-0749 www.ulib.iupui.edu -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/20200212134252.GC29157%40IUPUI.Edu.
signature.asc
Description: PGP signature
