[dspace-tech] Re: Build Failed
Dear Euler, Yes, I did check, also in local.cfg.EXAMPLE file I have updated it even if is example file. system user dspace does not have rights to perform $psql command. Is that having effects, I am getting the following error "psql: FATAL: role "dspace" does not exist" when performing *dev:~$ psql* On Wednesday, 30 November 2016 15:46:23 UTC+2, euler wrote: > > Hi Lewatle, > > Did you check that your database name is also the same in the db.url in > your local.cfg? eg., db.url = jdbc:postgresql://localhost:5432/dspace_dev > > Regards, > euler > > On Wednesday, November 30, 2016 at 9:01:46 PM UTC+8, Lewatle Johannes > Phaladi wrote: >> >> Dear Dspace Team, >> >> I am I have used mvn successfully at the moment I am getting build fail >> results when i perform ant update, my database name is dspace_dev but I am >> getting error message saying database dspace doesn't exist, in my >> dspcae.cfg i have clearly indicated database name as dspace_dev, is there >> any configuration file which I should specify database name, in local.cfg I >> have also mentioned database name as dspace_dev >> >> *Please see the following error from terminal, I am upgrading to dspace >> 6.0 * >> >> >> test_database: >> [java] 2016-11-30 14:44:12,516 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 a >> n >> application resource file: java.naming.factory.initial >> [java] 2016-11-30 14:44:13,285 ERROR >> org.dspace.storage.rdbms.DatabaseUtils @ Unable to setup Flyway against DS >> >> pace database >> [java] java.sql.SQLException: Cannot create >> PoolableConnectionFactory (FATAL: database "dspace" does not exist) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:229 >> >> >> 4) >> [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:473) >> [java] at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:98) >> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> [java] at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> [java] at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> [java] at java.lang.reflect.Method.invoke(Method.java:606) >> [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: database >> "dspace" does not exist >> [java] at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458) >> [java] at >> org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2589) >> [java] at >> org.postgresql.core.v3.QueryExecutorImpl.(QueryExecutorImpl.java:116) >> [java] at >> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225) >> [java] at >> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) >> [java] at >> org.postgresql.jdbc.PgConnection.(PgConnection.java:218) >> [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] Error running 'test': >> [java] >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:229 >> >
[dspace-tech] Re: Build Failed
Hi Lewatle, Did you check that your database name is also the same in the db.url in your local.cfg? eg., db.url = jdbc:postgresql://localhost:5432/dspace_dev Regards, euler On Wednesday, November 30, 2016 at 9:01:46 PM UTC+8, Lewatle Johannes Phaladi wrote: > > Dear Dspace Team, > > I am I have used mvn successfully at the moment I am getting build fail > results when i perform ant update, my database name is dspace_dev but I am > getting error message saying database dspace doesn't exist, in my > dspcae.cfg i have clearly indicated database name as dspace_dev, is there > any configuration file which I should specify database name, in local.cfg I > have also mentioned database name as dspace_dev > > *Please see the following error from terminal, I am upgrading to dspace > 6.0 * > > > test_database: > [java] 2016-11-30 14:44:12,516 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 a > n > application resource file: java.naming.factory.initial > [java] 2016-11-30 14:44:13,285 ERROR > org.dspace.storage.rdbms.DatabaseUtils @ Unable to setup Flyway against DS > > pace database > [java] java.sql.SQLException: Cannot create PoolableConnectionFactory > (FATAL: database "dspace" does not exist) > [java] at > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:229 > > > 4) > [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:473) > [java] at > org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:98) > [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > [java] at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > [java] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > [java] at java.lang.reflect.Method.invoke(Method.java:606) > [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: database > "dspace" does not exist > [java] at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458) > [java] at > org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2589) > [java] at > org.postgresql.core.v3.QueryExecutorImpl.(QueryExecutorImpl.java:116) > [java] at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225) > [java] at > org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) > [java] at > org.postgresql.jdbc.PgConnection.(PgConnection.java:218) > [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] Error running 'test': > [java] > [java] at > org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) > [java] at > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:229 > > > 0) > [java] ... 10 more > [java] > [java] Attempting to connect to database > [java] 2016-11-30 14:44:13,321 WARN > org.dspace.services.sessions.SessionRequestServiceImpl @ Request intercept > > or > (or
[dspace-tech] Re: Build Failed
*[java]* * [java] Error running 'test':* * [java] - java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: database "dspace" does not exist)* * [java]* On Wednesday, 30 November 2016 15:01:46 UTC+2, Lewatle Johannes Phaladi wrote: > > Dear Dspace Team, > > I am I have used mvn successfully at the moment I am getting build fail > results when i perform ant update, my database name is dspace_dev but I am > getting error message saying database dspace doesn't exist, in my > dspcae.cfg i have clearly indicated database name as dspace_dev, is there > any configuration file which I should specify database name, in local.cfg I > have also mentioned database name as dspace_dev > > *Please see the following error from terminal, I am upgrading to dspace > 6.0 * > > > test_database: > [java] 2016-11-30 14:44:12,516 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 a > n > application resource file: java.naming.factory.initial > [java] 2016-11-30 14:44:13,285 ERROR > org.dspace.storage.rdbms.DatabaseUtils @ Unable to setup Flyway against DS > > pace database > [java] java.sql.SQLException: Cannot create PoolableConnectionFactory > (FATAL: database "dspace" does not exist) > [java] at > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:229 > > > 4) > [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:473) > [java] at > org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:98) > [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > [java] at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > [java] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > [java] at java.lang.reflect.Method.invoke(Method.java:606) > [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: database > "dspace" does not exist > [java] at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458) > [java] at > org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2589) > [java] at > org.postgresql.core.v3.QueryExecutorImpl.(QueryExecutorImpl.java:116) > [java] at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225) > [java] at > org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) > [java] at > org.postgresql.jdbc.PgConnection.(PgConnection.java:218) > [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] Error running 'test': > [java] > [java] at > org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) > [java] at > org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:229 > > > 0) > [java] ... 10 more > [java] > [java] Attempting to connect to database > [java] 2016-11-30 14:44:13,321 WARN > org.dspace.services.sessions.SessionRequestServiceImpl @ Request intercept > > or > (o