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.<init>(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.<init>(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 >> (org.dspace.services.events.SystemEventService$EventRequestInterceptor@7a567c44) >> >> failed to execute on end (reques >> >> t-426-1480509853231): null >> [java] - java.sql.SQLException: Cannot create >> PoolableConnectionFactory (FATAL: database "dspace" does not exi >> >> st) >> [java] >> [java] Please see the DSpace documentation for assistance. >> [java] >> [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.main(DatabaseUtils.java:105) >> [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.<init>(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.<init>(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] at >> org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304) >> [java] at >> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:229 >> >> >> 0) >> [java] ... 9 more >> >> BUILD FAILED >> /dspace/install/bkpdspace-6.0-src-release/dspace/target/dspace-installer/build.xml:792: >> >> Java returned: 1 >> >> -- 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 post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
