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/5c7a160d-6df9-4224-b00c-0c8856fef8edn%40googlegroups.com.
