Task #7943
Remove the hard code pointing cn-ucsb postgresql on the portal configuration
100%
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
refs: #7943. localized the postgresql configuration to localhost (instead of round robin url)
refs: #7943. localized the postgresql configuration to localhost (instead of round robin url)
refs: #7943. commenting out the reconfiguration of postgresql in postinst, because we are using localhost now (don't need to customize for environment)
refs: #7943. commenting out the reconfiguration of postgresql in postinst, because we are using localhost now (don't need to customize for environment)
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)
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)
refs: #7943. This time in 2.3 branch: localized the postgresql configuration to localhost (instead of round robin url)
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 7 years ago
- Assignee changed from Jing Tao to Rob Nahf
#2 Updated by Rob Nahf over 7 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 7 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 7 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
