Hi,
I also have the same problem as Baskar while running $ant fresh_install.
Regarding Mohammad's reply to recreate pgcrypto, I did create successfully
before. If I try to recreate now then it says below as already it is there.
bash-4.4$ psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;"
ERROR: extension "pgcrypto" already exists
I am not sure Baskar, if you had a chance to fix it or found any solution
of it. Please share if possible or can someone help please?
I have checked there is no table
Following is my current setup environment:
===================================
OS: Red Hat Enterprise Linux 8.7
OpenJDK: v17.0.6
Apache: v2.4.37
Tomcat: v10.0.27
Maven: v3.8.6
Ant: 1.10.12
Postgres: v15
DSpace: v7.5 (Failing/Warning during ant fresh_install. Does not create any
tables after ant finishes)
ant fresh_install full output:
----------------------------------
$ ant fresh_install
...............
init_configs:
............
[java] 2023-02-21 11:11:45,527 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] 2023-02-21 11:11:45,820 WARN
org.flywaydb.core.internal.database.base.Database @ Flyway upgrade
recommended: PostgreSQL 15.1 is newer than this version of Flyway and
support has not been tested. The latest supported version of PostgreSQL is
14.
[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 15.1
[java] Database Driver: PostgreSQL JDBC Driver version 42.4.3
[java] PostgreSQL 'pgcrypto' extension installed/up-to-date? true
(version=1.3)
[java] FlywayDB Version: 8.4.4
install_code:
............
[echo]
[echo]
====================================================================
[echo] The DSpace code has been installed.
[echo]
====================================================================
[echo]
fresh_install:
copy_webapps:
......
build_webapps_wars:
check_spiders:
init_spiders:
[echo]
[echo]
====================================================================
[echo] The DSpace code has been installed.
[echo]
[echo] To complete installation, you should do the following:
[echo]
[echo] * Setup your Web servlet container (e.g. Tomcat) to look for
your
......................
[echo]
====================================================================
[echo]
BUILD SUCCESSFUL
Total time: 7 seconds
NO Tables CREATED in DSpace during ant fresh_install:
#######################################
$ psql dspace
psql (15.1)
Type "help" for help.
dspace=> \dt
Did not find any relations.
On Friday, 24 March 2023 at 11:56:52 UTC Mohammad S. AlMutairi wrote:
> 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/2763ca4d-c644-4f32-a789-16df861c1270n%40googlegroups.com.
