How to to update link between Apache tomcat and PostgreSQL server
My company got 2 Ubuntu server (ver 18 )
svr-erpdb (IP :192.168.2.1/24 & GW : 192.168.2.254)
svr-erapp (IP :192.168.2/2/24 & GW : 192.168.2.254)
url 192.168.2.2 to access erp.
Now we setup 2 VM for above 2 erp server at DR Center.
But DR center IP segment is 192.168.1.0 /24
I had did below:
Step 1:Change both server IP address
svr-erpdb change to 192.168.1.67/24 & Gw : 192.168.1.222
svr-erpapp change to 192.168.1.68/24 & Gw : 192.168.1.222
result : able ping both server from client PC
Step 2 : update pg_hba.conf at svr-erpdb
change to 192.168.1.68 from 192.168.2.2
then sudo reboot
both server
Step 3 : update postgresql.conf
change ip to 192.168.1.67,192.168.1.68 from 192.168.2.1,192.168.2.1
then sudo reboot
Step4 : change URL to new IP
192.168.1.68
Yellow error page come out said : FATAL: no pg_hba.conf entry for host "192.168.1.68", user "postgres", database "symphonydb", SSL off
update : 17/1/2019
I finally find out the reason why i did all but still received error msg no pg_hpa.conf for host 192.168.1.68
bcos this new ip app-server still keep connected to old db server (192.168.2.2)
so the solution is update the link between app server and db server.
app server installed Apache tomcat 8.0.35 and db server installed postgreSql 10
pls guide me how to update the link between apache tomcat server and postgresql server (mean instruct app server 192.168.1.68 point to db server 192.168.1.67, not 192.168.2.2 anymore)
thanks in advance.
apache2 postgresql ip database tomcat
add a comment |
My company got 2 Ubuntu server (ver 18 )
svr-erpdb (IP :192.168.2.1/24 & GW : 192.168.2.254)
svr-erapp (IP :192.168.2/2/24 & GW : 192.168.2.254)
url 192.168.2.2 to access erp.
Now we setup 2 VM for above 2 erp server at DR Center.
But DR center IP segment is 192.168.1.0 /24
I had did below:
Step 1:Change both server IP address
svr-erpdb change to 192.168.1.67/24 & Gw : 192.168.1.222
svr-erpapp change to 192.168.1.68/24 & Gw : 192.168.1.222
result : able ping both server from client PC
Step 2 : update pg_hba.conf at svr-erpdb
change to 192.168.1.68 from 192.168.2.2
then sudo reboot
both server
Step 3 : update postgresql.conf
change ip to 192.168.1.67,192.168.1.68 from 192.168.2.1,192.168.2.1
then sudo reboot
Step4 : change URL to new IP
192.168.1.68
Yellow error page come out said : FATAL: no pg_hba.conf entry for host "192.168.1.68", user "postgres", database "symphonydb", SSL off
update : 17/1/2019
I finally find out the reason why i did all but still received error msg no pg_hpa.conf for host 192.168.1.68
bcos this new ip app-server still keep connected to old db server (192.168.2.2)
so the solution is update the link between app server and db server.
app server installed Apache tomcat 8.0.35 and db server installed postgreSql 10
pls guide me how to update the link between apache tomcat server and postgresql server (mean instruct app server 192.168.1.68 point to db server 192.168.1.67, not 192.168.2.2 anymore)
thanks in advance.
apache2 postgresql ip database tomcat
Hi mature, thanks a lot for your review and edit my question, i'm new here and ubuntu, do u have any idea whr i do wrong? why i did all still cant access erp server via new ip? pls advice TQ
– kit Yoon
Jan 14 at 8:30
add a comment |
My company got 2 Ubuntu server (ver 18 )
svr-erpdb (IP :192.168.2.1/24 & GW : 192.168.2.254)
svr-erapp (IP :192.168.2/2/24 & GW : 192.168.2.254)
url 192.168.2.2 to access erp.
Now we setup 2 VM for above 2 erp server at DR Center.
But DR center IP segment is 192.168.1.0 /24
I had did below:
Step 1:Change both server IP address
svr-erpdb change to 192.168.1.67/24 & Gw : 192.168.1.222
svr-erpapp change to 192.168.1.68/24 & Gw : 192.168.1.222
result : able ping both server from client PC
Step 2 : update pg_hba.conf at svr-erpdb
change to 192.168.1.68 from 192.168.2.2
then sudo reboot
both server
Step 3 : update postgresql.conf
change ip to 192.168.1.67,192.168.1.68 from 192.168.2.1,192.168.2.1
then sudo reboot
Step4 : change URL to new IP
192.168.1.68
Yellow error page come out said : FATAL: no pg_hba.conf entry for host "192.168.1.68", user "postgres", database "symphonydb", SSL off
update : 17/1/2019
I finally find out the reason why i did all but still received error msg no pg_hpa.conf for host 192.168.1.68
bcos this new ip app-server still keep connected to old db server (192.168.2.2)
so the solution is update the link between app server and db server.
app server installed Apache tomcat 8.0.35 and db server installed postgreSql 10
pls guide me how to update the link between apache tomcat server and postgresql server (mean instruct app server 192.168.1.68 point to db server 192.168.1.67, not 192.168.2.2 anymore)
thanks in advance.
apache2 postgresql ip database tomcat
My company got 2 Ubuntu server (ver 18 )
svr-erpdb (IP :192.168.2.1/24 & GW : 192.168.2.254)
svr-erapp (IP :192.168.2/2/24 & GW : 192.168.2.254)
url 192.168.2.2 to access erp.
Now we setup 2 VM for above 2 erp server at DR Center.
But DR center IP segment is 192.168.1.0 /24
I had did below:
Step 1:Change both server IP address
svr-erpdb change to 192.168.1.67/24 & Gw : 192.168.1.222
svr-erpapp change to 192.168.1.68/24 & Gw : 192.168.1.222
result : able ping both server from client PC
Step 2 : update pg_hba.conf at svr-erpdb
change to 192.168.1.68 from 192.168.2.2
then sudo reboot
both server
Step 3 : update postgresql.conf
change ip to 192.168.1.67,192.168.1.68 from 192.168.2.1,192.168.2.1
then sudo reboot
Step4 : change URL to new IP
192.168.1.68
Yellow error page come out said : FATAL: no pg_hba.conf entry for host "192.168.1.68", user "postgres", database "symphonydb", SSL off
update : 17/1/2019
I finally find out the reason why i did all but still received error msg no pg_hpa.conf for host 192.168.1.68
bcos this new ip app-server still keep connected to old db server (192.168.2.2)
so the solution is update the link between app server and db server.
app server installed Apache tomcat 8.0.35 and db server installed postgreSql 10
pls guide me how to update the link between apache tomcat server and postgresql server (mean instruct app server 192.168.1.68 point to db server 192.168.1.67, not 192.168.2.2 anymore)
thanks in advance.
apache2 postgresql ip database tomcat
apache2 postgresql ip database tomcat
edited Jan 17 at 5:17
kit Yoon
asked Jan 12 at 3:45
kit Yoonkit Yoon
12
12
Hi mature, thanks a lot for your review and edit my question, i'm new here and ubuntu, do u have any idea whr i do wrong? why i did all still cant access erp server via new ip? pls advice TQ
– kit Yoon
Jan 14 at 8:30
add a comment |
Hi mature, thanks a lot for your review and edit my question, i'm new here and ubuntu, do u have any idea whr i do wrong? why i did all still cant access erp server via new ip? pls advice TQ
– kit Yoon
Jan 14 at 8:30
Hi mature, thanks a lot for your review and edit my question, i'm new here and ubuntu, do u have any idea whr i do wrong? why i did all still cant access erp server via new ip? pls advice TQ
– kit Yoon
Jan 14 at 8:30
Hi mature, thanks a lot for your review and edit my question, i'm new here and ubuntu, do u have any idea whr i do wrong? why i did all still cant access erp server via new ip? pls advice TQ
– kit Yoon
Jan 14 at 8:30
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1109049%2fhow-to-to-update-link-between-apache-tomcat-and-postgresql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1109049%2fhow-to-to-update-link-between-apache-tomcat-and-postgresql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hi mature, thanks a lot for your review and edit my question, i'm new here and ubuntu, do u have any idea whr i do wrong? why i did all still cant access erp server via new ip? pls advice TQ
– kit Yoon
Jan 14 at 8:30