Hi Zikrul,
Try this in the sequence you see it.
1) su - postgres
2) psql
3) \password
4) drop database dspace;
5) drop user dspace;
6) drop extension if exists pgcrypto;
7) drop schema extensions;
8) \q
9) createuser --username=postgres --no-superuser --pwprompt dspace
10) createdb --username=postgres --owner=dspace --encoding=UNICODE dspace
11) psql --username=postgres dspace
12) CREATE SCHEMA extensions;
13) CREATE EXTENSION pgcrypto SCHEMA extensions;
14) GRANT USAGE ON SCHEMA extensions TO dspace;
15) SELECT set_config('search_path',current_setting('search_path') ||
',extensions',false) WHERE current_setting('search_path') !~
'(^|,)extensions(,|$)';
16) SHOW search_path;
17) ALTER DATABASE dspace SET search_path FROM CURRENT;
18) \q
19) exit
20) systemctl enable postgresql
21) systemctl restart postgresql
22) psql -U dspace -W -h localhost
23) \conninfo
24) \q
25) exit
### Conitune DSpace installation
Hope it help
Mo.
On Tuesday, March 28, 2023 at 4:06:10 PM UTC+3 Zikrul wrote:
> Hi Mohammad,
>
> Many thanks for your prompt reply. I have tried $ant fresh_install after
> each fix for pgcrypto you have mentioned but issue did not resolved. Any
> other idea please?
>
> test_database:
> [java] 2023-03-28 13:59:20,868 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-03-28 13:59:21,165 WARN
> org.flywaydb.core.internal.database.base.Database @ Flyway upgrade
> recommended: PostgreSQL 15.2 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
>
> Regards
> Zikrul
> On Tuesday, 28 March 2023 at 13:22:38 UTC+1 Mohammad S. AlMutairi wrote:
>
>> Hi Zikrul,
>>
>> All you need to fix it without having to recreate the pgcrypto extension
>> using the second method is by adding it into the search path by one of
>> these commands ( *psql --username=postgres dspace -c 'ALTER ROLE dspace
>> IN DATABASE dspace SET search_path = "$user",public,extensions,pgcrypto;'*
>> ) or ( *psql --username=postgres dspace -c 'ALTER DATABASE dspace SET
>> search_path = "$user",public,extensions,pgcrypto;'* ) and then double
>> check it to see if it's included by ( *psql --username=postgres dspace
>> -c 'SHOW search_path;'* ).
>>
>> NB: Creating the pgcrypto extension using the second method will save you
>> from creating it again if you later for any reason have to clean your
>> database. Please read *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).
>>
>> Carefully.
>>
>> Hope it help
>>
>> Mo.
>>
>>
>>
>> On Tuesday, March 28, 2023 at 2:51:55 PM UTC+3 Zikrul wrote:
>>
>>> 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/9370ebcc-f0e6-42f8-badd-be61853467dfn%40googlegroups.com.
