Dear Tim, Thanks for your answer. I encoded my database in postgrsql in UTF-8 with the extension pgcrypto but may be I need to do in other step?
El miércoles, 27 de julio de 2022 a las 12:15:09 UTC-4, Tim Donohue escribió: > Hi, > > The main error appears to be this one: > Cannot create PoolableConnectionFactory (FATAL: la autentificaci¾n > password fall¾ para el usuario ½dspace╗ (pgjdbc: autodetected > server-encoding to be ISO-8859-1, if the message is not readable, please > check database logs and/or host, port, dbname, user, password, > pg_hba.conf))ADVERTENCIA: SQLException occurred while connecting to > localhost:5432 > > In that message, it's saying that your database is being "autodetected" as > having a server-encoding of ISO-8859-1. This isn't valid for DSpace, as > DSpace requires that you use UTF-8 (Unicode) at all times. See the setup > notes for PostgreSQL: > https://wiki.lyrasis.org/display/DSDOC6x/Installing+DSpace#InstallingDSpace-PostgreSQL9.4orlater(withpgcryptoinstalled) > > So, you will need to likely reinstall or recreate your database to use > UTF-8 encoding instead of ISO-8859-1. > > If you need more help, let us know on this list. > > Tim > > On Friday, July 22, 2022 at 8:32:39 PM UTC-5 [email protected] wrote: > >> Hello, i am triying to install dspace 6.3 in windows 10. >> >> When I execute >> >> c:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer>ant >> fresh_install >> >> I get the following, what can I do? >> >> >> >> >> Buildfile: >> c:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer\build.xml >> >> init_installation: >> >> prepare_configs: >> [mkdir] Created dir: >> c:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer\config-temp >> [copy] Copying 159 files to >> c:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer\config-temp >> [copy] Copying 1 file to >> c:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer\config-temp >> [copy] Copying 16 files to >> c:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer\config-temp >> >> init_configs: >> [copy] Copying 1 file to >> C:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer\dpsace\config >> [delete] Deleting directory >> c:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer\config-temp >> >> test_database: >> [java] 2022-07-22 22:19:49,917 WARN >> org.dspace.services.email.EmailServiceImpl @ Couldn't get an email session >> from environment: Need to specify class name in environment or system >> property, or as an applet parameter, or in an application resource file: >> java.naming.factory.initial >> [java] jul 22, 2022 10:19:50 PM >> org.postgresql.core.v3.ConnectionFactoryImpl log >> [java] 2022-07-22 22:19:50,339 ERROR >> org.dspace.storage.rdbms.DatabaseUtils @ Unable to setup Flyway against >> DSpace database >> [java] java.sql.SQLException: Cannot create >> PoolableConnectionFactory (FATAL: la autentificaci¾n password fall¾ para el >> usuario ½dspace╗ (pgjdbc: autodetected server-encoding to be ISO-8859-1, if >> the message is not readable, please check database logs and/or host, port, >> dbname, user, password, pg_hba.conf))ADVERTENCIA: SQLException occurred >> while connecting to localhost:5432 >> [java] >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) >> [java] org.postgresql.util.PSQLException: FATAL: la autentificaci¾n >> password fall¾ para el usuario ½dspace╗ (pgjdbc: autodetected >> server-encoding to be ISO-8859-1, if the message is not readable, please >> check database logs and/or host, port, dbname, user, password, pg_hba.conf) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475) >> [java] at >> org.dspace.storage.rdbms.DatabaseUtils.setupFlyway(DatabaseUtils.java:472) >> at >> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) >> [java] >> [java] at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:97) >> [java] at >> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) >> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> [java] at >> org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> [java] >> [java] at org.postgresql.Driver.makeConnection(Driver.java:452) >> [java] at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >> at org.postgresql.Driver.connect(Driver.java:254) >> [java] >> [java] at java.lang.reflect.Method.invoke(Method.java:498) >> [java] at >> org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229) >> [java] at >> org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) >> [java] Caused by: org.postgresql.util.PSQLException: FATAL: la >> autentificaci¾n password fall¾ para el usuario ½dspace╗ (pgjdbc: >> autodetected server-encoding to be ISO-8859-1, if the message is not >> readable, please check database logs and/or host, port, dbname, user, >> password, pg_hba.conf) at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) >> [java] >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) >> >> at >> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) >> [java] >> [java] at >> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) >> >> at >> org.dspace.storage.rdbms.DatabaseUtils.setupFlyway(DatabaseUtils.java:472) >> [java] >> [java] at >> org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:97) >> [java] >> [java] at org.postgresql.Driver.makeConnection(Driver.java:452) >> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> [java] at org.postgresql.Driver.connect(Driver.java:254) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> [java] >> [java] at >> org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) >> [java] at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> [java] at java.lang.reflect.Method.invoke(Method.java:498) >> [java] at >> org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229) >> >> at >> org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) >> [java] >> [java] at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) >> [java] ... 10 more >> [java] >> [java] >> [java] >> [java] Attempting to connect to databasejul 22, 2022 10:19:50 PM >> org.postgresql.Driver connect >> [java] >> [java] GRAVE: Connection error: >> [java] org.postgresql.util.PSQLException: FATAL: la autentificaci¾n >> password fall¾ para el usuario ½dspace╗ (pgjdbc: autodetected >> server-encoding to be ISO-8859-1, if the message is not readable, please >> check database logs and/or host, port, dbname, user, password, pg_hba.conf) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) >> [java] at >> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) >> [java] at >> org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) >> [java] at org.postgresql.Driver.makeConnection(Driver.java:452) >> [java] at org.postgresql.Driver.connect(Driver.java:254) >> [java] at >> org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) >> [java] at >> org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) >> [java] at >> org.dspace.storage.rdbms.DatabaseUtils.setupFlyway(DatabaseUtils.java:472) >> [java] at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:97) >> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> [java] at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> [java] at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> [java] at java.lang.reflect.Method.invoke(Method.java:498) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) >> [java] >> [java] jul 22, 2022 10:19:50 PM >> org.postgresql.core.v3.ConnectionFactoryImpl log >> [java] ADVERTENCIA: SQLException occurred while connecting to >> localhost:5432 >> [java] org.postgresql.util.PSQLException: FATAL: la autentificaci¾n >> password fall¾ para el usuario ½dspace╗ (pgjdbc: autodetected >> server-encoding to be ISO-8859-1, if the message is not readable, please >> check database logs and/or host, port, dbname, user, password, pg_hba.conf) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) >> [java] at >> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) >> [java] at >> org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) >> [java] at org.postgresql.Driver.makeConnection(Driver.java:452) >> [java] at org.postgresql.Driver.connect(Driver.java:254) >> [java] at >> org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) >> [java] at >> org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) >> [java] at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:104) >> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> [java] at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> [java] at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> [java] at java.lang.reflect.Method.invoke(Method.java:498) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) >> [java] >> [java] jul 22, 2022 10:19:50 PM org.postgresql.Driver connect >> [java] GRAVE: Connection error: >> [java] org.postgresql.util.PSQLException: FATAL: la autentificaci¾n >> password fall¾ para el usuario ½dspace╗ (pgjdbc: autodetected >> server-encoding to be ISO-8859-1, if the message is not readable, please >> check database logs and/or host, port, dbname, user, password, pg_hba.conf) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) >> [java] at >> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) >> [java] at >> org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) >> [java] at org.postgresql.Driver.makeConnection(Driver.java:452) >> [java] at org.postgresql.Driver.connect(Driver.java:254) >> [java] at >> org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) >> [java] at >> org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) >> [java] at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:104) >> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> [java] at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> [java] at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> [java] at java.lang.reflect.Method.invoke(Method.java:498) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) >> [java] >> [java] >> [java] Error running 'test': >> [java] - java.sql.SQLException: Cannot create >> PoolableConnectionFactory (FATAL: la autentificaci¾n password fall¾ para el >> usuario ½dspace╗ (pgjdbc: autodetected server-encoding to be ISO-8859-1, if >> the message is not readable, please check database logs and/or host, port, >> dbname, user, password, pg_hba.conf)) >> [java] >> [java] Please see the DSpace documentation for assistance. >> [java] >> [java] java.sql.SQLException: Cannot create >> PoolableConnectionFactory (FATAL: la autentificaci¾n password fall¾ para el >> usuario ½dspace╗ (pgjdbc: autodetected server-encoding to be ISO-8859-1, if >> the message is not readable, please check database logs and/or host, port, >> dbname, user, password, pg_hba.conf)) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) >> [java] at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:104) >> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> [java] at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> [java] at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> [java] at java.lang.reflect.Method.invoke(Method.java:498) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229) >> [java] at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) >> [java] Caused by: org.postgresql.util.PSQLException: FATAL: la >> autentificaci¾n password fall¾ para el usuario ½dspace╗ (pgjdbc: >> autodetected server-encoding to be ISO-8859-1, if the message is not >> readable, please check database logs and/or host, port, dbname, user, >> password, pg_hba.conf) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) >> [java] at >> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) >> [java] at >> org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) >> [java] at org.postgresql.Driver.makeConnection(Driver.java:452) >> [java] at org.postgresql.Driver.connect(Driver.java:254) >> [java] at >> org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) >> [java] at >> org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290) >> [java] ... 9 more >> [java] 2022-07-22 22:19:50,589 WARN >> org.dspace.services.sessions.SessionRequestServiceImpl @ Request >> interceptor >> (org.dspace.services.events.SystemEventService$EventRequestInterceptor@144aacc9) >> >> failed to execute on end (request-646-1658539190214): null >> >> BUILD FAILED >> c:\dpsace\dspace-6.3-src-release\dspace\target\dspace-installer\build.xml:789: >> >> Java returned: 1 > > -- 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 Community" 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-community/254a2fb1-095a-487a-a7a0-ad488ba7be3dn%40googlegroups.com.
