External Database Setup

[Henry Atsu Agbodza]

Hello all,

i need help on configuration settings for an external postgreqsl server.

My architecture is :

Dspace 6 = Application Server

Postgresql = Another Server (External)

Assetstore = Another Server (NFS)

I have done the connection for the NFS in local.cfg and dspace.cfg succesfully.

For the external postgreqsl server, my settings in  local.cfg and dspace.cfg

is db.url = jdbc:postgresql://xxx.xx.xxx.xx:5432/dspace

But when i run sudo ant fresh_install,

it fails at the Database connection point.

Please i will deeply appreciate help on this.

Thanks in advance.

[Mark H. Wood]

On Wed, Oct 12, 2022 at 11:56:51AM -0700, Henry Atsu Agbodza wrote:
> Hello all,
> i need help on configuration settings for an external postgreqsl server.
> My architecture is :
> Dspace 6 = Application Server
> Postgresql = Another Server (External)
> Assetstore = Another Server (NFS)
>
> I have done the connection for the NFS in local.cfg and dspace.cfg
> succesfully.
> For the external postgreqsl server, my settings in local.cfg and dspace.cfg
> is db.url = jdbc:postgresql://xxx.xx.xxx.xx:5432/dspace
>

> But when i run *sudo ant fresh_install,*
> *it fails at the Database connection point.*

Please show us the messages which indicate this failure.

Here we run several DSpace instances on two different hosts using a
single DBMS on a third host, so what you are trying to do should work
when properly configured.

One thing I would check is whether the DBMS is rejecting the
connection from a different host because it is not permitted by the
*DBMS* configuration. The error report from 'ant' and the DBMS log
file should show whether this is the case.

--
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu

[Henry Atsu Agbodza]

Dear Mark,

thanks for the response. Apparently the IP of the external DBMS was a private IP.

We are thus changing it to a public IP and then we will try the setup again.

Thanks for the help. 

Appreciated. 

--
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 a topic in the Google Groups "DSpace Technical Support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dspace-tech/TnDCHo64oBg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/Y0gQiPVjks%2Bfh4yg%40IUPUI.Edu.

--

Psalm 119:28 My Soul is weary with sorrow ; strengthen me according to your Word.
Sincerely Yours,

Henry Atsu Agbodza

Commonwealth Fellow

Library Systems and Research Support, 

Academic Computing Unit,

University of Ghana Computing Systems (UGCS)

Room G3, Ground Floor - East Wing, 

Balme Library

Legon

Tel.: +233 (0) 207 027360

IP Phone: 2442

UG Repository

UG Library
UG Online Catalogue (UGCat)
UG Research Portal
UG Off - Campus Access to E - Resources

UG Chat with A Librarian Service