Thread: BUG #1026: org.apache.commons.dbcp.DbcpException: The connection attempt failed because failed getting backend

The following bug has been logged online:

Bug reference:      1026
Logged by:          NASA

Email address:      g.w.kimbrough@larc.nasa.gov

PostgreSQL version: 7.3.4

Operating system:   Solaris 9

Description:        org.apache.commons.dbcp.DbcpException: The connection
attempt failed because failed getting backend

Details:

We are trying to install DSPACE with POSTGRES.  When we run the ant
fresh_install command we get the following error.  What could be causing a
org.apache.commons.dbcp.DbcpException: The connection attempt failed because
failed getting backend encoding?

$ ant fresh_install
Buildfile: build.xml

update:

install_code:

setup_database:
     [java] 2003-12-23 14:09:48,719 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
     [java] 2003-12-23 14:09:50,143 FATAL
org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
     [java] org.apache.commons.dbcp.DbcpException: The connection attempt
failed because failed getting backend encoding
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(Dri
     [java]     at verManagerConnectionFactory.java:101)
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnec
     [java]     at tionFactory.java:184)
     [java]     at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
     [java]     at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:146)
     [java]     at
java.sql.DriverManager.getConnection(DriverManager.java:512)
     [java]     at
java.sql.DriverManager.getConnection(DriverManager.java:193)
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java
     [java]     at :382)
     [java]     at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:668)
     [java]     at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:76)
     [java] Caused by: The connection attempt failed because failed getting
backend encoding
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Co
     [java]     at nnection.java:358)
     [java]     at org.postgresql.Driver.connect(Driver.java:122)
     [java]     at
java.sql.DriverManager.getConnection(DriverManager.java:512)
     [java]     at
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(Dri
     [java]     at verManagerConnectionFactory.java:95)
     [java]     ... 8 more

BUILD FAILED
file:/export/home/dspace-1.1.1-source/build.xml:220: Java returned: 1

Total time: 18 seconds

Re: BUG #1026: org.apache.commons.dbcp.DbcpException: The

From
Kris Jurka
Date:
> PostgreSQL version: 7.3.4
>
> Description:        org.apache.commons.dbcp.DbcpException: The connection
> attempt failed because failed getting backend
>
> We are trying to install DSPACE with POSTGRES.  When we run the ant
> fresh_install command we get the following error.  What could be causing a
> org.apache.commons.dbcp.DbcpException: The connection attempt failed because
> failed getting backend encoding?

Have you been able to establish a JDBC connection at all or is this error
only with dspace?

Could you enable logging on the server and see if that comes up with
anything interesting?  (Enable log_statement in postgresql.conf and
restart the server making sure the output is going somewhere other than
/dev/null)

What do you get from the results of the following queries when run in
psql?

SELECT version();

SELECT pg_encoding_to_char(1);

SELECT getdatabaseencoding();


Kris Jurka


Re: [JDBC] BUG #1026: org.apache.commons.dbcp.DbcpException:

From
Dave Cramer
Date:
Tammy,

are you building the jar from source? if so can you try running ant test
?
also see my comments below

Dave

On Wed, 2003-12-24 at 09:32, Tammy Jones wrote:
>
> Kris Jurka wrote:
> > > PostgreSQL version: 7.3.4
> > >
> > > Description:        org.apache.commons.dbcp.DbcpException: The connection
> > > attempt failed because failed getting backend
> > >
> > > We are trying to install DSPACE with POSTGRES.  When we run the ant
> > > fresh_install command we get the following error.  What could be causing a
> > > org.apache.commons.dbcp.DbcpException: The connection attempt failed because
> > > failed getting backend encoding?
> > >
> >
> > Have you been able to establish a JDBC connection at all or is this error
> > only with dspace?
> I really haven't tried postgres with anything other than dspace.
> > Could you enable logging on the server and see if that comes up with
> > anything interesting?  (Enable log_statement in postgresql.conf and
> > restart the server making sure the output is going somewhere other than
> > /dev/null)
>
> I enabled logging.  The logging results are below with the query
> results.
> > What do you get from the results of the following queries when run in
> > psql?
> >
> I assume that I am running the queries appropriately.  The database
> service had to be started because of copy paste problems, not because
> of the queries below.   Here are the results:
> > SELECT version();
> $psql -d dspace -c "SELECT version();"

you really should be getting something like
 ~/reiser/informix7.4/bin/psql isp -c "select version()"
                                                     version
------------------------------------------------------------------------------------------------------------------
 PostgreSQL 7.4informix1.4 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
(1 row)

and

 ~/reiser/informix7.4/bin/psql -d isp -c "select pg_encoding_to_char(1)"
 pg_encoding_to_char
---------------------
 EUC_JP
(1 row)


not SELECT ??



> SELECT
> $ more logfile
> 2003-12-24 09:21:12 LOG:  database system was shut down at 2003-12-24
> 09:20:46 E
> ST
> 2003-12-24 09:21:12 LOG:  checkpoint record is at 0/84FAA8
> 2003-12-24 09:21:12 LOG:  redo record is at 0/84FAA8; undo record is
> at 0/0; shu
> tdown TRUE
> 2003-12-24 09:21:12 LOG:  next transaction id: 587; next oid: 25169
> 2003-12-24 09:21:12 LOG:  database system is ready
> 2003-12-24 09:21:44 LOG:  query: begin; select getdatabaseencoding();
> commit
> 2003-12-24 09:21:44 LOG:  query: SELECT version();
> RESULT :c=0.00..0.01 :r=1 :w=0
> RESULT :c=0.00..0.01 :r=1 :w=0
> 2003-12-24 09:22:49 LOG:  query: begin; select getdatabaseencoding();
> commit
> 2003-12-24 09:22:49 LOG:  query: SELECT version();
> RESULT :c=0.00..0.01 :r=1 :w=0
> RESULT :c=0.00..0.01 :r=1 :w=0
> > SELECT pg_encoding_to_char(1);
> $ psql -d dspace -c "SELECT pg_encoding_to_char(1);"
> SELECT
> $ more logfile
> 2003-12-24 09:25:28 LOG:  database system was shut down at 2003-12-24
> 09:25:01 E
> ST
> 2003-12-24 09:25:28 LOG:  checkpoint record is at 0/84FAE8
> 2003-12-24 09:25:28 LOG:  redo record is at 0/84FAE8; undo record is
> at 0/0; shu
> tdown TRUE
> 2003-12-24 09:25:28 LOG:  next transaction id: 593; next oid: 25169
> 2003-12-24 09:25:28 LOG:  database system is ready
> 2003-12-24 09:25:33 LOG:  query: begin; select getdatabaseencoding();
> commit
> 2003-12-24 09:25:33 LOG:  query: SELECT pg_encoding_to_char(1);
> RESULT :c=0.00..0.01 :r=1 :w=0
> RESULT :c=0.00..0.01 :r=1 :w=0
> > SELECT getdatabaseencoding();
> $ psql -d dspace -c "SELECT getdatabaseencoding();"
> SELECT
> $ more logfile
> 2003-12-24 09:26:46 LOG:  database system was shut down at 2003-12-24
> 09:26:26 E
> ST
> 2003-12-24 09:26:46 LOG:  checkpoint record is at 0/84FB28
> 2003-12-24 09:26:46 LOG:  redo record is at 0/84FB28; undo record is
> at 0/0; shu
> tdown TRUE
> 2003-12-24 09:26:46 LOG:  next transaction id: 596; next oid: 25169
> 2003-12-24 09:26:46 LOG:  database system is ready
> 2003-12-24 09:26:55 LOG:  query: begin; select getdatabaseencoding();
> commit
> 2003-12-24 09:26:55 LOG:  query: SELECT getdatabaseencoding();
> RESULT :c=0.00..0.01 :r=1 :w=0
> RESULT :c=0.00..0.01 :r=1 :w=0
> > Kris Jurka
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
> >
>
>
> --
> Tammy Jones
>
> ANALYTICAL SERVICES & MATERIALS
> NASA LaRC
> 2 West Durand Street
> Hampton, VA  23681
>
> Mail Stop 185
> Building 1194, Room 106
> Phone:  4-8003
> Fax:    4-8869
>
> _____________________________________________________
> "When your values are clear your decisions are easy"
>     -Walt Disney-
> _____________________________________________________
>


Re: [JDBC] BUG #1026: org.apache.commons.dbcp.DbcpException:

From
Tammy Jones
Date:


Kris Jurka wrote:
PostgreSQL version: 7.3.4

Description:        org.apache.commons.dbcp.DbcpException: The connection
attempt failed because failed getting backend

We are trying to install DSPACE with POSTGRES.  When we run the ant
fresh_install command we get the following error.  What could be causing a
org.apache.commons.dbcp.DbcpException: The connection attempt failed because
failed getting backend encoding?   
Have you been able to establish a JDBC connection at all or is this error
only with dspace?
I really haven't tried postgres with anything other than dspace.

Could you enable logging on the server and see if that comes up with
anything interesting?  (Enable log_statement in postgresql.conf and
restart the server making sure the output is going somewhere other than
/dev/null)

I enabled logging.  The logging results are below with the query results.

What do you get from the results of the following queries when run in
psql? 
I assume that I am running the queries appropriately.  The database service had to be started because of copy paste problems, not because of the queries below.   Here are the results:
SELECT version();
$psql -d dspace -c "SELECT version();"
SELECT
$ more logfile
2003-12-24 09:21:12 LOG:  database system was shut down at 2003-12-24 09:20:46 E
ST
2003-12-24 09:21:12 LOG:  checkpoint record is at 0/84FAA8
2003-12-24 09:21:12 LOG:  redo record is at 0/84FAA8; undo record is at 0/0; shu
tdown TRUE
2003-12-24 09:21:12 LOG:  next transaction id: 587; next oid: 25169
2003-12-24 09:21:12 LOG:  database system is ready
2003-12-24 09:21:44 LOG:  query: begin; select getdatabaseencoding(); commit
2003-12-24 09:21:44 LOG:  query: SELECT version();
RESULT :c=0.00..0.01 :r=1 :w=0
RESULT :c=0.00..0.01 :r=1 :w=0
2003-12-24 09:22:49 LOG:  query: begin; select getdatabaseencoding(); commit
2003-12-24 09:22:49 LOG:  query: SELECT version();
RESULT :c=0.00..0.01 :r=1 :w=0
RESULT :c=0.00..0.01 :r=1 :w=0

SELECT pg_encoding_to_char(1);
$ psql -d dspace -c "SELECT pg_encoding_to_char(1);"
SELECT
$ more logfile
2003-12-24 09:25:28 LOG:  database system was shut down at 2003-12-24 09:25:01 E
ST
2003-12-24 09:25:28 LOG:  checkpoint record is at 0/84FAE8
2003-12-24 09:25:28 LOG:  redo record is at 0/84FAE8; undo record is at 0/0; shu
tdown TRUE
2003-12-24 09:25:28 LOG:  next transaction id: 593; next oid: 25169
2003-12-24 09:25:28 LOG:  database system is ready
2003-12-24 09:25:33 LOG:  query: begin; select getdatabaseencoding(); commit
2003-12-24 09:25:33 LOG:  query: SELECT pg_encoding_to_char(1);
RESULT :c=0.00..0.01 :r=1 :w=0
RESULT :c=0.00..0.01 :r=1 :w=0

SELECT getdatabaseencoding();
$ psql -d dspace -c "SELECT getdatabaseencoding();"
SELECT
$ more logfile
2003-12-24 09:26:46 LOG:  database system was shut down at 2003-12-24 09:26:26 E
ST
2003-12-24 09:26:46 LOG:  checkpoint record is at 0/84FB28
2003-12-24 09:26:46 LOG:  redo record is at 0/84FB28; undo record is at 0/0; shu
tdown TRUE
2003-12-24 09:26:46 LOG:  next transaction id: 596; next oid: 25169
2003-12-24 09:26:46 LOG:  database system is ready
2003-12-24 09:26:55 LOG:  query: begin; select getdatabaseencoding(); commit
2003-12-24 09:26:55 LOG:  query: SELECT getdatabaseencoding();
RESULT :c=0.00..0.01 :r=1 :w=0
RESULT :c=0.00..0.01 :r=1 :w=0

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
 

-- 
Tammy Jones

ANALYTICAL SERVICES & MATERIALS
NASA LaRC
2 West Durand Street
Hampton, VA  23681

Mail Stop 185
Building 1194, Room 106                              
Phone:  4-8003
Fax:    4-8869

_____________________________________________________ 
"When your values are clear your decisions are easy"   -Walt Disney-
_____________________________________________________ 

Re: [JDBC] BUG #1026: org.apache.commons.dbcp.DbcpException:

From
Dave Cramer
Date:
Tammy,

Sorry, I wasn't clear, ant test is for the jdbc driver.

Either way, if you can't get psql to return version then there are
problems.

Does psql work in interactive mode, can you select anything?

Dave

On Wed, 2003-12-24 at 11:59, Tammy Jones wrote:
> I am building dspace from source, however ant test does not work.  I
> get the following error:
> $ ant test
> Buildfile: build.xml
>
> BUILD FAILED
> Target `test' does not exist in this project.
>
>
> I tried running the psql commands just like below and still only get
> SELECT as the response.
>
> Below is a snippit of our installation process that involved
> postgres.  Maybe it'll help shed some light.
>
> Notation
> Throughout the course of this document we will used the following
> notation:
>
> [postgres-src] – This is the source from which you will build and
> install the PostgreSQL database system.  We used
> /usr/local/postgresql-7.3.4.
>
> [postgres] – The directory in which you will/have install(ed)
> PostgreSQL. We used /usr/local/pgsql.
>
> [postgres-data] – This is the location of the PostgreSQL database,
> which will then contain the data from DSpace.  We used
> /usr/local/pgsql/data.  Note: that this directory must have rwx
> permissions for the PostgreSQL user.
>
>
> PostgreSQL
> We used 7.3.4.
>
>
> Pre-requisite Software:
> gmake or make:  Download the GNU Make binary file, which comes as a
> .tar.gz compressed file.  We located GNU Make at /usr/local/bin/make.
>
> gcc:  Download the gcc binary file, which comes as a .tar.gz
> compressed file.  We located gcc at /usr/local/bin/gcc.
>
> readline:  Download the readline binary file, which comes as a .tar.gz
> compressed file.  We located readline at /usr/local/bin/readline.
>
> Copy the libreadline library into /usr/lib and /usr/local/lib.
>
> JDBC:  Download the JDBC drivers
> athttp://jdbc.postgresql.org/download.html.  We located the download
> at /usr/local/jdbc.
>
>
> Installation:
> Note:  DSpace comes packaged with a postgresql.jar file for an older
> version of PostgreSQL.  To make DSpace work with PostgreSQL 7.2.4 it
> is necessary to replace their version of postgresql.jar with the new
> one created with this installation.
>
> Note: You require Ant 1.5 in order to build PostgreSQL 7.2.4 using the
> –-with-java option required to create the drivers for DSpace.
>
> Note:  You must do the installation in bourne shell.
>
>
> ·        Create a user called postgres and a group of the same name.
>
> ·        Login as postgres in order to do the installation.
>
> ·        Configure the source:
>
> Go to the directory [postgres-src], and run the following command:
>
> ./configure --prefix=[postgres]
>
> –-enable-multibyte
>
> --enable-unicode
>
> --with-java
>
> ·        make PostgreSQL:
>
> In [postgres-src] run the command:
>
> make
>
> ·        Install PostgreSQL:
>
> In [postgres-src] run the command:
>
> make install
>
> ·        Create the database:
>
> Use the following commands (you may be in any system directory
> provided that you use the full path names of each directory):
>
> mkdir [postgres-data]
>
> [postgres]/bin/initdb –D [postgres-data]
>
> ·        Copy the postgresql.jar file
>
> cp [postgres]/share/java [DSpace-src]/lib
>
> ·        Place the libgcc library in the postgres library
>
> cp libgcc_s.so.1 [postgres]/lib/.
>
> ·        Copy the JDBC driver jar file to postgres:
>
> cp jdbcDriver.jar [postgres]/share/java/.
>
> ·        Edit the postgres configuration file,
> [postgres]/data/postgresql.conf. to switch on the TCP/IP connections
> and configure the port:
>
> Set the following configuration parameters:
>
> tcpip_socket=true
>
> port=5432
>
> ·        Set the following environment variables:
>
> PGDATA=[pgsql]/data
>
> PGPORT=5432
>
> ·        Start the database service:
>
> [postgres]/bin/postmaster –o "-i" -D /usr/local/pgsql/data > logfile
> 2>&1 &
>
>
> DSpace Installation
> ·        Create a DSpace user and a group of the same name, containing
> that user.
>
> ·        Log in as DSpace.
>
> ·        Create the DSpace database and user for that database:
>
> Use the following commands in the directory [postgres]/bin:
>
> createuser –U postgres –d –A –P DSpace
>
> createdb –U DSpace DSpace –E UNICODE
>
>
>
>
> Dave Cramer wrote:
> > Tammy,
> >
> > are you building the jar from source? if so can you try running ant test
> > ?
> > also see my comments below
> >
> > Dave
> >
> > On Wed, 2003-12-24 at 09:32, Tammy Jones wrote:
> >
> > > Kris Jurka wrote:
> > >
> > > > > PostgreSQL version: 7.3.4
> > > > >
> > > > > Description:        org.apache.commons.dbcp.DbcpException: The connection
> > > > > attempt failed because failed getting backend
> > > > >
> > > > > We are trying to install DSPACE with POSTGRES.  When we run the ant
> > > > > fresh_install command we get the following error.  What could be causing a
> > > > > org.apache.commons.dbcp.DbcpException: The connection attempt failed because
> > > > > failed getting backend encoding?
> > > > >
> > > > >
> > > >
> > > > Have you been able to establish a JDBC connection at all or is this error
> > > > only with dspace?
> > > >
> > >
> > > I really haven't tried postgres with anything other than dspace.
> > >
> > > > Could you enable logging on the server and see if that comes up with
> > > > anything interesting?  (Enable log_statement in postgresql.conf and
> > > > restart the server making sure the output is going somewhere other than
> > > > /dev/null)
> > > >
> > >
> > > I enabled logging.  The logging results are below with the query
> > > results.
> > >
> > > > What do you get from the results of the following queries when run in
> > > > psql?
> > > >
> > > >
> > >
> > > I assume that I am running the queries appropriately.  The database
> > > service had to be started because of copy paste problems, not because
> > > of the queries below.   Here are the results:
> > >
> > > > SELECT version();
> > > >
> > >
> > > $psql -d dspace -c "SELECT version();"
> > >
> >
> > you really should be getting something like
> >  ~/reiser/informix7.4/bin/psql isp -c "select version()"
> >                                                      version
> > ------------------------------------------------------------------------------------------------------------------
> >  PostgreSQL 7.4informix1.4 on i686-pc-linux-gnu, compiled by GCC gcc
> > (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
> > (1 row)
> >
> > and
> >
> >  ~/reiser/informix7.4/bin/psql -d isp -c "select pg_encoding_to_char(1)"
> >  pg_encoding_to_char
> > ---------------------
> >  EUC_JP
> > (1 row)
> >
> >
> > not SELECT ??
> >
> >
> >
> >
> > > SELECT
> > > $ more logfile
> > > 2003-12-24 09:21:12 LOG:  database system was shut down at 2003-12-24
> > > 09:20:46 E
> > > ST
> > > 2003-12-24 09:21:12 LOG:  checkpoint record is at 0/84FAA8
> > > 2003-12-24 09:21:12 LOG:  redo record is at 0/84FAA8; undo record is
> > > at 0/0; shu
> > > tdown TRUE
> > > 2003-12-24 09:21:12 LOG:  next transaction id: 587; next oid: 25169
> > > 2003-12-24 09:21:12 LOG:  database system is ready
> > > 2003-12-24 09:21:44 LOG:  query: begin; select getdatabaseencoding();
> > > commit
> > > 2003-12-24 09:21:44 LOG:  query: SELECT version();
> > > RESULT :c=0.00..0.01 :r=1 :w=0
> > > RESULT :c=0.00..0.01 :r=1 :w=0
> > > 2003-12-24 09:22:49 LOG:  query: begin; select getdatabaseencoding();
> > > commit
> > > 2003-12-24 09:22:49 LOG:  query: SELECT version();
> > > RESULT :c=0.00..0.01 :r=1 :w=0
> > > RESULT :c=0.00..0.01 :r=1 :w=0
> > >
> > > > SELECT pg_encoding_to_char(1);
> > > >
> > >
> > > $ psql -d dspace -c "SELECT pg_encoding_to_char(1);"
> > > SELECT
> > > $ more logfile
> > > 2003-12-24 09:25:28 LOG:  database system was shut down at 2003-12-24
> > > 09:25:01 E
> > > ST
> > > 2003-12-24 09:25:28 LOG:  checkpoint record is at 0/84FAE8
> > > 2003-12-24 09:25:28 LOG:  redo record is at 0/84FAE8; undo record is
> > > at 0/0; shu
> > > tdown TRUE
> > > 2003-12-24 09:25:28 LOG:  next transaction id: 593; next oid: 25169
> > > 2003-12-24 09:25:28 LOG:  database system is ready
> > > 2003-12-24 09:25:33 LOG:  query: begin; select getdatabaseencoding();
> > > commit
> > > 2003-12-24 09:25:33 LOG:  query: SELECT pg_encoding_to_char(1);
> > > RESULT :c=0.00..0.01 :r=1 :w=0
> > > RESULT :c=0.00..0.01 :r=1 :w=0
> > >
> > > > SELECT getdatabaseencoding();
> > > >
> > >
> > > $ psql -d dspace -c "SELECT getdatabaseencoding();"
> > > SELECT
> > > $ more logfile
> > > 2003-12-24 09:26:46 LOG:  database system was shut down at 2003-12-24
> > > 09:26:26 E
> > > ST
> > > 2003-12-24 09:26:46 LOG:  checkpoint record is at 0/84FB28
> > > 2003-12-24 09:26:46 LOG:  redo record is at 0/84FB28; undo record is
> > > at 0/0; shu
> > > tdown TRUE
> > > 2003-12-24 09:26:46 LOG:  next transaction id: 596; next oid: 25169
> > > 2003-12-24 09:26:46 LOG:  database system is ready
> > > 2003-12-24 09:26:55 LOG:  query: begin; select getdatabaseencoding();
> > > commit
> > > 2003-12-24 09:26:55 LOG:  query: SELECT getdatabaseencoding();
> > > RESULT :c=0.00..0.01 :r=1 :w=0
> > > RESULT :c=0.00..0.01 :r=1 :w=0
> > >
> > > > Kris Jurka
> > > >
> > > >
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 8: explain analyze is your friend
> > > >
> > > >
> > > >
> > >


Re: [JDBC] BUG #1026: org.apache.commons.dbcp.DbcpException:

From
Tammy Jones
Date:
I downloaded the jdbc driver jar which was used by postgres to compile up drivers.

When I ran the queries in psql, I got the same SELECT response.


Dave Cramer wrote:
Tammy,

Sorry, I wasn't clear, ant test is for the jdbc driver.

Either way, if you can't get psql to return version then there are
problems.

Does psql work in interactive mode, can you select anything?

Dave

On Wed, 2003-12-24 at 11:59, Tammy Jones wrote: 
I am building dspace from source, however ant test does not work.  I
get the following error:
$ ant test
Buildfile: build.xml

BUILD FAILED
Target `test' does not exist in this project. 


I tried running the psql commands just like below and still only get
SELECT as the response.

Below is a snippit of our installation process that involved
postgres.  Maybe it'll help shed some light.

Notation
Throughout the course of this document we will used the following
notation:

[postgres-src] – This is the source from which you will build and
install the PostgreSQL database system.  We used
/usr/local/postgresql-7.3.4.

[postgres] – The directory in which you will/have install(ed)
PostgreSQL. We used /usr/local/pgsql.

[postgres-data] – This is the location of the PostgreSQL database,
which will then contain the data from DSpace.  We used
/usr/local/pgsql/data.  Note: that this directory must have rwx
permissions for the PostgreSQL user.


PostgreSQL
We used 7.3.4.


Pre-requisite Software:
gmake or make:  Download the GNU Make binary file, which comes as a
.tar.gz compressed file.  We located GNU Make at /usr/local/bin/make.

gcc:  Download the gcc binary file, which comes as a .tar.gz
compressed file.  We located gcc at /usr/local/bin/gcc.

readline:  Download the readline binary file, which comes as a .tar.gz
compressed file.  We located readline at /usr/local/bin/readline.

Copy the libreadline library into /usr/lib and /usr/local/lib.

JDBC:  Download the JDBC drivers
athttp://jdbc.postgresql.org/download.html.  We located the download
at /usr/local/jdbc.


Installation:
Note:  DSpace comes packaged with a postgresql.jar file for an older
version of PostgreSQL.  To make DSpace work with PostgreSQL 7.2.4 it
is necessary to replace their version of postgresql.jar with the new
one created with this installation.

Note: You require Ant 1.5 in order to build PostgreSQL 7.2.4 using the
–-with-java option required to create the drivers for DSpace.

Note:  You must do the installation in bourne shell.


·        Create a user called postgres and a group of the same name.

·        Login as postgres in order to do the installation.

·        Configure the source:

Go to the directory [postgres-src], and run the following command:

./configure --prefix=[postgres] 

–-enable-multibyte

--enable-unicode

--with-java

·        make PostgreSQL:

In [postgres-src] run the command:

make

·        Install PostgreSQL:

In [postgres-src] run the command:

make install

·        Create the database:

Use the following commands (you may be in any system directory
provided that you use the full path names of each directory):

mkdir [postgres-data]

[postgres]/bin/initdb –D [postgres-data]

·        Copy the postgresql.jar file

cp [postgres]/share/java [DSpace-src]/lib

·        Place the libgcc library in the postgres library 

cp libgcc_s.so.1 [postgres]/lib/.

·        Copy the JDBC driver jar file to postgres:

cp jdbcDriver.jar [postgres]/share/java/.

·        Edit the postgres configuration file,
[postgres]/data/postgresql.conf. to switch on the TCP/IP connections
and configure the port:

Set the following configuration parameters:

tcpip_socket=true

port=5432

·        Set the following environment variables:

PGDATA=[pgsql]/data

PGPORT=5432

·        Start the database service:

[postgres]/bin/postmaster –o "-i" -D /usr/local/pgsql/data > logfile 
2>&1 &


DSpace Installation
·        Create a DSpace user and a group of the same name, containing
that user. 

·        Log in as DSpace.

·        Create the DSpace database and user for that database:

Use the following commands in the directory [postgres]/bin:

createuser –U postgres –d –A –P DSpace

createdb –U DSpace DSpace –E UNICODE




Dave Cramer wrote:   
Tammy,

are you building the jar from source? if so can you try running ant test
?
also see my comments below

Dave

On Wed, 2003-12-24 at 09:32, Tammy Jones wrote:      
Kris Jurka wrote:          
PostgreSQL version: 7.3.4

Description:        org.apache.commons.dbcp.DbcpException: The connection
attempt failed because failed getting backend

We are trying to install DSPACE with POSTGRES.  When we run the ant
fresh_install command we get the following error.  What could be causing a
org.apache.commons.dbcp.DbcpException: The connection attempt failed because
failed getting backend encoding?                     
Have you been able to establish a JDBC connection at all or is this error
only with dspace?              
I really haven't tried postgres with anything other than dspace.          
Could you enable logging on the server and see if that comes up with
anything interesting?  (Enable log_statement in postgresql.conf and
restart the server making sure the output is going somewhere other than
/dev/null)              
I enabled logging.  The logging results are below with the query
results.          
What do you get from the results of the following queries when run in
psql?               
I assume that I am running the queries appropriately.  The database
service had to be started because of copy paste problems, not because
of the queries below.   Here are the results:          
SELECT version();              
$psql -d dspace -c "SELECT version();"          
you really should be getting something like~/reiser/informix7.4/bin/psql isp -c "select version()"                                                    version
------------------------------------------------------------------------------------------------------------------PostgreSQL 7.4informix1.4 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
(1 row)

and 
~/reiser/informix7.4/bin/psql -d isp -c "select pg_encoding_to_char(1)"pg_encoding_to_char
---------------------EUC_JP
(1 row)


not SELECT ??


      
SELECT
$ more logfile
2003-12-24 09:21:12 LOG:  database system was shut down at 2003-12-24
09:20:46 E
ST
2003-12-24 09:21:12 LOG:  checkpoint record is at 0/84FAA8
2003-12-24 09:21:12 LOG:  redo record is at 0/84FAA8; undo record is
at 0/0; shu
tdown TRUE
2003-12-24 09:21:12 LOG:  next transaction id: 587; next oid: 25169
2003-12-24 09:21:12 LOG:  database system is ready
2003-12-24 09:21:44 LOG:  query: begin; select getdatabaseencoding();
commit
2003-12-24 09:21:44 LOG:  query: SELECT version();
RESULT :c=0.00..0.01 :r=1 :w=0 
RESULT :c=0.00..0.01 :r=1 :w=0 
2003-12-24 09:22:49 LOG:  query: begin; select getdatabaseencoding();
commit
2003-12-24 09:22:49 LOG:  query: SELECT version();
RESULT :c=0.00..0.01 :r=1 :w=0 
RESULT :c=0.00..0.01 :r=1 :w=0           
SELECT pg_encoding_to_char(1);              
$ psql -d dspace -c "SELECT pg_encoding_to_char(1);"
SELECT
$ more logfile
2003-12-24 09:25:28 LOG:  database system was shut down at 2003-12-24
09:25:01 E
ST
2003-12-24 09:25:28 LOG:  checkpoint record is at 0/84FAE8
2003-12-24 09:25:28 LOG:  redo record is at 0/84FAE8; undo record is
at 0/0; shu
tdown TRUE
2003-12-24 09:25:28 LOG:  next transaction id: 593; next oid: 25169
2003-12-24 09:25:28 LOG:  database system is ready
2003-12-24 09:25:33 LOG:  query: begin; select getdatabaseencoding();
commit
2003-12-24 09:25:33 LOG:  query: SELECT pg_encoding_to_char(1);
RESULT :c=0.00..0.01 :r=1 :w=0 
RESULT :c=0.00..0.01 :r=1 :w=0           
SELECT getdatabaseencoding();              
$ psql -d dspace -c "SELECT getdatabaseencoding();"
SELECT
$ more logfile
2003-12-24 09:26:46 LOG:  database system was shut down at 2003-12-24
09:26:26 E
ST
2003-12-24 09:26:46 LOG:  checkpoint record is at 0/84FB28
2003-12-24 09:26:46 LOG:  redo record is at 0/84FB28; undo record is
at 0/0; shu
tdown TRUE
2003-12-24 09:26:46 LOG:  next transaction id: 596; next oid: 25169
2003-12-24 09:26:46 LOG:  database system is ready
2003-12-24 09:26:55 LOG:  query: begin; select getdatabaseencoding();
commit
2003-12-24 09:26:55 LOG:  query: SELECT getdatabaseencoding();
RESULT :c=0.00..0.01 :r=1 :w=0 
RESULT :c=0.00..0.01 :r=1 :w=0           
Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
               
 

-- 
Tammy Jones

ANALYTICAL SERVICES & MATERIALS
NASA LaRC
2 West Durand Street
Hampton, VA  23681

Mail Stop 185
Building 1194, Room 106                              
Phone:  4-8003
Fax:    4-8869

_____________________________________________________ 
"When your values are clear your decisions are easy"   -Walt Disney-
_____________________________________________________ 

Re: [JDBC] BUG #1026: org.apache.commons.dbcp.DbcpException:

From
Tammy Jones
Date:
I am building dspace from source, however ant test does not work.  I get the following error:
$ ant test
Buildfile: build.xml

BUILD FAILED
Target `test' does not exist in this project.


I tried running the psql commands just like below and still only get SELECT as the response.

Below is a snippit of our installation process that involved postgres.  Maybe it'll help shed some light.

Notation

Throughout the course of this document we will used the following notation:

[postgres-src] – This is the source from which you will build and install the PostgreSQL database system.  We used /usr/local/postgresql-7.3.4.

[postgres] – The directory in which you will/have install(ed) PostgreSQL.  We used /usr/local/pgsql.

[postgres-data] – This is the location of the PostgreSQL database, which will then contain the data from DSpace.  We used /usr/local/pgsql/data.  Note: that this directory must have rwx permissions for the PostgreSQL user.

PostgreSQL

We used 7.3.4.

Pre-requisite Software:

gmake or make:  Download the GNU Make binary file, which comes as a .tar.gz compressed file.  We located GNU Make at /usr/local/bin/make.

gcc:  Download the gcc binary file, which comes as a .tar.gz compressed file.  We located gcc at /usr/local/bin/gcc.

readline:  Download the readline binary file, which comes as a .tar.gz compressed file.  We located readline at /usr/local/bin/readline.

Copy the libreadline library into /usr/lib and /usr/local/lib.

JDBC:  Download the JDBC drivers at http://jdbc.postgresql.org/download.html.  We located the download at /usr/local/jdbc.

Installation:

Note:  DSpace comes packaged with a postgresql.jar file for an older version of PostgreSQL.  To make DSpace work with PostgreSQL 7.2.4 it is necessary to replace their version of postgresql.jar with the new one created with this installation.

Note: You require Ant 1.5 in order to build PostgreSQL 7.2.4 using the –-with-java option required to create the drivers for DSpace.

Note:  You must do the installation in bourne shell.

·         Create a user called postgres and a group of the same name.

·         Login as postgres in order to do the installation.

·         Configure the source:

Go to the directory [postgres-src], and run the following command:

./configure --prefix=[postgres]

–-enable-multibyte

--enable-unicode

--with-java

·         make PostgreSQL:

In [postgres-src] run the command:

make

·         Install PostgreSQL:

In [postgres-src] run the command:

make install

·         Create the database:

Use the following commands (you may be in any system directory provided that you use the full path names of each directory):

mkdir [postgres-data]

[postgres]/bin/initdb –D [postgres-data]

·         Copy the postgresql.jar file

cp [postgres]/share/java [DSpace-src]/lib

·         Place the libgcc library in the postgres library

cp libgcc_s.so.1 [postgres]/lib/.

·         Copy the JDBC driver jar file to postgres:

cp jdbcDriver.jar [postgres]/share/java/.

·         Edit the postgres configuration file, [postgres]/data/postgresql.conf.  to switch on the TCP/IP connections and configure the port:

Set the following configuration parameters:

tcpip_socket=true

port=5432

·         Set the following environment variables:

PGDATA=[pgsql]/data

PGPORT=5432

·         Start the database service:

[postgres]/bin/postmaster –o "-i" -D /usr/local/pgsql/data > logfile  2>&1 &

DSpace Installation

·         Create a DSpace user and a group of the same name, containing that user.

·         Log in as DSpace.

·         Create the DSpace database and user for that database:

Use the following commands in the directory [postgres]/bin:

createuser –U postgres –d –A –P DSpace

createdb –U DSpace DSpace –E UNICODE


Dave Cramer wrote:

Tammy,

are you building the jar from source? if so can you try running ant test
?
also see my comments below

Dave

On Wed, 2003-12-24 at 09:32, Tammy Jones wrote: 
Kris Jurka wrote:   
PostgreSQL version: 7.3.4

Description:        org.apache.commons.dbcp.DbcpException: The connection
attempt failed because failed getting backend

We are trying to install DSPACE with POSTGRES.  When we run the ant
fresh_install command we get the following error.  What could be causing a
org.apache.commons.dbcp.DbcpException: The connection attempt failed because
failed getting backend encoding?          
Have you been able to establish a JDBC connection at all or is this error
only with dspace?     
I really haven't tried postgres with anything other than dspace.   
Could you enable logging on the server and see if that comes up with
anything interesting?  (Enable log_statement in postgresql.conf and
restart the server making sure the output is going somewhere other than
/dev/null)     
I enabled logging.  The logging results are below with the query
results.   
What do you get from the results of the following queries when run in
psql?      
I assume that I am running the queries appropriately.  The database
service had to be started because of copy paste problems, not because
of the queries below.   Here are the results:   
SELECT version();     
$psql -d dspace -c "SELECT version();"   
you really should be getting something like~/reiser/informix7.4/bin/psql isp -c "select version()"                                                    version
------------------------------------------------------------------------------------------------------------------PostgreSQL 7.4informix1.4 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
(1 row)

and 
~/reiser/informix7.4/bin/psql -d isp -c "select pg_encoding_to_char(1)"pg_encoding_to_char
---------------------EUC_JP
(1 row)


not SELECT ??


 
SELECT
$ more logfile
2003-12-24 09:21:12 LOG:  database system was shut down at 2003-12-24
09:20:46 E
ST
2003-12-24 09:21:12 LOG:  checkpoint record is at 0/84FAA8
2003-12-24 09:21:12 LOG:  redo record is at 0/84FAA8; undo record is
at 0/0; shu
tdown TRUE
2003-12-24 09:21:12 LOG:  next transaction id: 587; next oid: 25169
2003-12-24 09:21:12 LOG:  database system is ready
2003-12-24 09:21:44 LOG:  query: begin; select getdatabaseencoding();
commit
2003-12-24 09:21:44 LOG:  query: SELECT version();
RESULT :c=0.00..0.01 :r=1 :w=0 
RESULT :c=0.00..0.01 :r=1 :w=0 
2003-12-24 09:22:49 LOG:  query: begin; select getdatabaseencoding();
commit
2003-12-24 09:22:49 LOG:  query: SELECT version();
RESULT :c=0.00..0.01 :r=1 :w=0 
RESULT :c=0.00..0.01 :r=1 :w=0    
SELECT pg_encoding_to_char(1);     
$ psql -d dspace -c "SELECT pg_encoding_to_char(1);"
SELECT
$ more logfile
2003-12-24 09:25:28 LOG:  database system was shut down at 2003-12-24
09:25:01 E
ST
2003-12-24 09:25:28 LOG:  checkpoint record is at 0/84FAE8
2003-12-24 09:25:28 LOG:  redo record is at 0/84FAE8; undo record is
at 0/0; shu
tdown TRUE
2003-12-24 09:25:28 LOG:  next transaction id: 593; next oid: 25169
2003-12-24 09:25:28 LOG:  database system is ready
2003-12-24 09:25:33 LOG:  query: begin; select getdatabaseencoding();
commit
2003-12-24 09:25:33 LOG:  query: SELECT pg_encoding_to_char(1);
RESULT :c=0.00..0.01 :r=1 :w=0 
RESULT :c=0.00..0.01 :r=1 :w=0    
SELECT getdatabaseencoding();     
$ psql -d dspace -c "SELECT getdatabaseencoding();"
SELECT
$ more logfile
2003-12-24 09:26:46 LOG:  database system was shut down at 2003-12-24
09:26:26 E
ST
2003-12-24 09:26:46 LOG:  checkpoint record is at 0/84FB28
2003-12-24 09:26:46 LOG:  redo record is at 0/84FB28; undo record is
at 0/0; shu
tdown TRUE
2003-12-24 09:26:46 LOG:  next transaction id: 596; next oid: 25169
2003-12-24 09:26:46 LOG:  database system is ready
2003-12-24 09:26:55 LOG:  query: begin; select getdatabaseencoding();
commit
2003-12-24 09:26:55 LOG:  query: SELECT getdatabaseencoding();
RESULT :c=0.00..0.01 :r=1 :w=0 
RESULT :c=0.00..0.01 :r=1 :w=0    
Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
      
-- 
Tammy Jones

ANALYTICAL SERVICES & MATERIALS
NASA LaRC
2 West Durand Street
Hampton, VA  23681

Mail Stop 185
Building 1194, Room 106                              
Phone:  4-8003
Fax:    4-8869

_____________________________________________________ 
"When your values are clear your decisions are easy"   -Walt Disney-
_____________________________________________________ 
   
 

-- 
Tammy Jones

ANALYTICAL SERVICES & MATERIALS
NASA LaRC
2 West Durand Street
Hampton, VA  23681

Mail Stop 185
Building 1194, Room 106                              
Phone:  4-8003
Fax:    4-8869

_____________________________________________________ 
"When your values are clear your decisions are easy"   -Walt Disney-
_____________________________________________________