Hi, I think it can not be found because it's not included into the search path. See this old post for hints on how to fix it: https://groups.google.com/g/dspace-tech/c/Hy8lxiaxH4I/m/8yrHFW5lBgAJ or better if you recreate the pgcrypto extention using the ( *Alternative method: How to enable pgcrypto via a separate database schema.) *found in here https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-PostgreSQL11.x,12.xor13.x(withpgcryptoinstalled).
Mo. On Friday, March 24, 2023 at 2:25:47 PM UTC+3 Baskar Selvaraj wrote: > Hi, > > OS: Ubuntu 22.04.2 > PostgreSQL: 14.7 > DSpace: 7.5 > pgcrypto extension: 1.3 > > init_configs: > [copy] Copying 222 files to /home/dspace/config > [delete] Deleting directory > /dspace-7.5/dspace/target/dspace-installer/config-temp > [copy] Copying 1 file to /home/dspace/config > > test_database: > [java] 2023-03-24 06:55:56,440 WARN > org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by > name or id=database. Will try to look up bean by type next. > [java] > org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean > named 'database' available > [java] at > org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:872) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213) > > ~[spring-beans-5.3.20.jar:5.3.20] > [java] at > org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1160) > > ~[spring-context-5.3.20.jar:5.3.20] > [java] at > org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) > > [dspace-services-7.5.jar:7.5] > [java] at > org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:34) > > [dspace-api-7.5.jar:7.5] > [java] at > org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) > [dspace-api-7.5.jar:7.5] > [java] at > org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) > [dspace-api-7.5.jar:7.5] > [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 14.7 (Ubuntu > 14.7-0ubuntu0.22.04.1) > [java] Database Driver: PostgreSQL JDBC Driver version 42.4.3 > [java] PostgreSQL 'pgcrypto' extension installed/up-to-date? false > (not installed) > [java] FlywayDB Version: 8.4.4 > [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] > > BUILD FAILED > /dspace-7.5/dspace/target/dspace-installer/build.xml:770: Java returned: 1 > > Total time: 9 seconds > > ------------------------------------- > > pgcrypto is installed and enabled > > psql (14.7 (Ubuntu 14.7-0ubuntu0.22.04.1)) > Type "help" for help. > > postgres=# select * from pg_available_extensions; > name | default_version | installed_version | > comment > > --------------------+-----------------+-------------------+------------------------------------------------------------------------ > > intagg | 1.1 | | integer > aggregator and enumerator (obsolete) > tsm_system_rows | 1.0 | | TABLESAMPLE > method which accepts number of rows as a limit > refint | 1.0 | | functions for > implementing referential integrity (obsolete) > pgcrypto | 1.3 | 1.3 | cryptographic > functions > file_fdw | 1.0 | | foreign-data > wrapper for flat file access > hstore | 1.8 | | data type for > storing sets of (key, value) pairs > pg_stat_statements | 1.9 | | track planning > and execution statistics of all SQL statements executed > pg_freespacemap | 1.2 | | examine the > free space map (FSM) > pg_prewarm | 1.2 | | prewarm > relation data > > (46 rows) > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- 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/5690a0ee-b4f1-477f-a6ce-7627262e83b8n%40googlegroups.com.
