Hi,
I could not connect to the database: java.sql.SQLException: Cannot
create PoolableConnectionFactory (The connection attempt
failed.)java.sql.SQLException: Cannot create PoolableConnectionFactory (The
connection attempt failed.)
Are you able to connect in the data base by command line: (psql -U
"user-name" ) and then the passowrd.
Best regards
Luiz Claudio Santos
http://luizclaudiosantos.me/
On Mon, Jan 30, 2017 at 5:56 PM, Walter Rutherford <[email protected]>
wrote:
> This is the output from the 'ant fresh-install' command. I believe the
> first error is just a non-fatal WARNing, the fatal
> problems come when it tries to access the postgres database. But I can't
> tell if the problem stems from postgres,
> java, Maven (that created the ant files), ant, DNS, etc..
>
> I'm new enough to both java and postgres that the error messages don't
> tell me anything.
>
> [dspace@irtest dspace]$ cd target/dspace-installer/
> [dspace@irtest dspace-installer]$ ant fresh_install
> Buildfile: /home/dspace/dspace-6.0-src-release/dspace/target/dspace-
> installer/build.xml
>
> init_installation:
>
> prepare_configs:
> [mkdir] Created dir: /home/dspace/dspace-6.0-src-
> release/dspace/target/dspace-installer/config-temp
> [copy] Copying 157 files to /home/dspace/dspace-6.0-src-
> release/dspace/target/dspace-installer/config-temp
> [copy] Copying 1 file to /home/dspace/dspace-6.0-src-
> release/dspace/target/dspace-installer/config-temp
> [copy] Copying 16 files to /home/dspace/dspace-6.0-src-
> release/dspace/target/dspace-installer/config-temp
>
> init_configs:
> [copy] Copying 1 file to /home/dspace/config
> [delete] Deleting directory /home/dspace/dspace-6.0-src-
> release/dspace/target/dspace-installer/config-temp
>
> test_database:
> [java] 2017-01-30 12:14:37,830 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]
> [java] Error running 'test': 2017-01-30 12:14:38,542 ERROR
> org.dspace.storage.rdbms.DatabaseUtils @ Unable to setup Flyway against
> DSpace database
> [java] - java.sql.SQLException: Cannot create
> PoolableConnectionFactory (The connection attempt failed.)
> [java]
> [java]
> [java] Please see the DSpace documentation for assistance.
> [java]
> [java] java.sql.SQLException: Cannot create PoolableConnectionFactory
> (The connection attempt failed.)java.sql.SQLException: Cannot create
> PoolableConnectionFactory (The connection attempt failed.)
> [java]
> [java] at org.apache.commons.dbcp2.BasicDataSource.
> createPoolableConnectionFactory(BasicDataSource.java:2294) at
> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactor
> y(BasicDataSource.java:2294)
> [java]
> [java] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(
> BasicDataSource.java:2039) at org.apache.commons.dbcp2.BasicDataSource.
> createDataSource(BasicDataSource.java:2039)
> [java]
> [java] at org.apache.commons.dbcp2.BasicDataSource.getConnection(
> BasicDataSource.java:1533) at org.apache.commons.dbcp2.
> BasicDataSource.getConnection(BasicDataSource.java:1533)
> [java] at org.dspace.storage.rdbms.DatabaseUtils.main(
> DatabaseUtils.java:105)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java]
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:57)
> [java] at org.dspace.storage.rdbms.DatabaseUtils.setupFlyway(
> DatabaseUtils.java:473) at sun.reflect.DelegatingMethodAccessorImpl.
> invoke(DelegatingMethodAccessorImpl.java:43)
> [java]
> [java] at java.lang.reflect.Method.invoke(Method.java:606)
> [java] at org.dspace.storage.rdbms.DatabaseUtils.main(
> DatabaseUtils.java:98)
> [java] at org.dspace.app.launcher.ScriptLauncher.runOneCommand(
> ScriptLauncher.java:229) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> [java] at org.dspace.app.launcher.ScriptLauncher.main(
> ScriptLauncher.java:81)
> [java] Caused by: org.postgresql.util.PSQLException: The connection
> attempt failed.
> [java]
> [java] at org.postgresql.core.v3.ConnectionFactoryImpl.
> openConnectionImpl(ConnectionFactoryImpl.java:275)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:57) at org.postgresql.core.
> ConnectionFactory.openConnection(ConnectionFactory.java:54)
> [java]
> [java] at org.postgresql.jdbc.PgConnection.<init>(
> PgConnection.java:218) at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> [java]
> [java] at org.postgresql.Driver.makeConnection(Driver.java:407)
> [java] at org.postgresql.Driver.connect(Driver.java:275) at
> java.lang.reflect.Method.invoke(Method.java:606)
> [java]
> [java] at org.apache.commons.dbcp2.DriverConnectionFactory.
> createConnection(DriverConnectionFactory.java:39) at
> org.dspace.app.launcher.ScriptLauncher.runOneCommand(
> ScriptLauncher.java:229)
> [java] at org.apache.commons.dbcp2.PoolableConnectionFactory.
> makeObject(PoolableConnectionFactory.java:256)
> [java]
> [java] at org.apache.commons.dbcp2.BasicDataSource.
> validateConnectionFactory(BasicDataSource.java:2304) at
> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81)
> [java] at org.apache.commons.dbcp2.BasicDataSource.
> createPoolableConnectionFactory(BasicDataSource.java:2290)
> [java]
> [java] ... 9 more
> [java] Caused by: java.net.UnknownHostException: "
> irtest.library.uaf.edu"Caused by: org.postgresql.util.PSQLException: The
> connection attempt failed.
> [java] at java.net.AbstractPlainSocketImpl.connect(
> AbstractPlainSocketImpl.java:178)
> [java] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
> [java]
> [java] at java.net.Socket.connect(Socket.java:576) at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(
> ConnectionFactoryImpl.java:275)
> [java] at org.postgresql.core.PGStream.<init>(PGStream.java:64)
> [java]
> [java] at org.postgresql.core.ConnectionFactory.openConnection(
> ConnectionFactory.java:54)
> [java] at org.postgresql.core.v3.ConnectionFactoryImpl.
> openConnectionImpl(ConnectionFactoryImpl.java:147) at org.postgresql.jdbc.
> PgConnection.<init>(PgConnection.java:218)
> [java] ... 17 more
> [java]
> [java] at org.postgresql.Driver.makeConnection(Driver.java:407)
> [java] at org.postgresql.Driver.connect(Driver.java:275)
> [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] ... 10 more
> [java] Caused by: java.net.UnknownHostException: "
> irtest.library.uaf.edu"
> [java] at java.net.AbstractPlainSocketImpl.connect(
> AbstractPlainSocketImpl.java:178)
> [java] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
> [java] at java.net.Socket.connect(Socket.java:576)
> [java] at org.postgresql.core.PGStream.<init>(PGStream.java:64)
> [java] at org.postgresql.core.v3.ConnectionFactoryImpl.
> openConnectionImpl(ConnectionFactoryImpl.java:147)
> [java] ... 18 more
> [java]
> [java] Attempting to connect to database
> [java] 2017-01-30 12:14:38,608 WARN
> org.dspace.services.sessions.SessionRequestServiceImpl
> @ Request interceptor (org.dspace.services.events.SystemEventService$
> EventRequestInterceptor@17fcf875) failed to execute on end
> (request-814-1485810878464): null
>
> BUILD FAILED
> /home/dspace/dspace-6.0-src-release/dspace/target/dspace-installer/build.xml:792:
> Java returned: 1
>
> Total time: 10 seconds
> [dspace@irtest dspace-installer]$
>
> --
> 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 [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
