Project

General

Profile

Task #7943

Remove the hard code pointing cn-ucsb postgresql on the portal configuration

Added by Jing Tao over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
d1_portal_servlet
Target version:
Start date:
2016-11-29
Due date:
% Done:

100%

Milestone:
None
Product Version:
*
Story Points:
Sprint:

Description

We need to check with Ben if we really needs postgresql configuration. If we need, the postgresql should point to local postgresql instead.

Associated revisions

Revision 18508
Added by Rob Nahf over 5 years ago

refs: #7943. localized the postgresql configuration to localhost (instead of round robin url)

Revision 18508
Added by Rob Nahf over 5 years ago

refs: #7943. localized the postgresql configuration to localhost (instead of round robin url)

Revision 18509
Added by Rob Nahf over 5 years ago

refs: #7943. commenting out the reconfiguration of postgresql in postinst, because we are using localhost now (don't need to customize for environment)

Revision 18509
Added by Rob Nahf over 5 years ago

refs: #7943. commenting out the reconfiguration of postgresql in postinst, because we are using localhost now (don't need to customize for environment)

Revision 18510
Added by Rob Nahf over 5 years ago

refs: #7943. (in 2.3 branch this time): commenting out the reconfiguration of postgresql in postinst, because we are using localhost now (don't need to customize for environment)

Revision 18510
Added by Rob Nahf over 5 years ago

refs: #7943. (in 2.3 branch this time): commenting out the reconfiguration of postgresql in postinst, because we are using localhost now (don't need to customize for environment)

Revision 18511
Added by Rob Nahf over 5 years ago

refs: #7943. This time in 2.3 branch: localized the postgresql configuration to localhost (instead of round robin url)

Revision 18511
Added by Rob Nahf over 5 years ago

refs: #7943. This time in 2.3 branch: localized the postgresql configuration to localhost (instead of round robin url)

History

#1 Updated by Jing Tao over 5 years ago

  • Assignee changed from Jing Tao to Rob Nahf

#2 Updated by Rob Nahf over 5 years ago

There isn't a hardcoded cn-ucsb-1.dataone.org link in any portal component (d1_portal, d1_portal_servlet, or cn-buildout/d1-portal), but there is hardcoded baseurl to the round-robin url (cn.dataone.org) in d1_portal_servlet WEB-INF/client.xml:

https://cn.dataone.org/portal/ready
https://cilogon.org/oauth
https://cilogon.org/delegate
PRIVATE_KEY_PATH
PUBLIC_KEY_PATH
DataONE
864000
MYPROXY_ID
<!-- myproxy:oa4mp,2012:/client/501a796b5dab878f71665731028bd8a9 -->

    <postgresql 
        username="oa4mp" 
        password="oa4mp" 
        driver="org.postgresql.Driver"
        host="cn.dataone.org"
        port="5432" 
        schema="oauth" 
        database="oauth" 
        tablename="assets" 
        prefix="oauth" 
        useSSL="true">
        <assetStore/>
        <transactions/>
        <clients/>
        <clientApprovals/>
    </postgresql>

#3 Updated by Jing Tao over 5 years ago

Here is the client.xml on cn-dev-orc which I just installed today:

https://cn-dev.test.dataone.org/portal/ready
https://cilogon.org/oauth
https://cilogon.org/delegate
/etc/ssl/private/.test.dataone.org.key.pk8
/etc/ssl/certs/
.test.dataone.org.crt.publickey
DataONEDev
864000
myproxy:oa4mp,2012:/client/24a10c2cd8bda4e6b5cf244ab7532b2
<!-- myproxy:oa4mp,2012:/client/501a796b5dab878f71665731028bd8a9 -->





You see, in the host of postgresql, it always pointed to the ip address of 128.111.54.78 which is the cn-dev-ucsb-1. Since the machine is cn-dev-orc-1, we need it to point to the address of cn-dev-orc-1.

#4 Updated by Rob Nahf over 5 years ago

  • Category set to d1_portal_servlet
  • Status changed from New to Closed
  • % Done changed from 0 to 100

ben confirms that only the postgresql configuration should be changed.

(changing to host="localhost")

changes done in trunk. Need to copy to 2.3 branch

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 14.8 MB)