Thanks for the detailed answers.
yeah i was trying to verify the way you did.
The answers certainly gave more clarity on the requirement.
I could able to open the wordpress from LBR link and i have performed all the steps .
Please check and update why the task has been marked failure for me ?
Hi, the same happened on my end just minutes ago.
@Inderpreet it’s still showing failed status for me .
@Darshan1893 FYI, your wordpress screenshot indicates that you completed the task incorrectly. If you had, you should have seen the blog posts like in my screenshots. Your screenshot only proves that wordpress is running, and you appear to have not restored the specified database dump since it looks like a fresh wordpress install…
I tried installing openssh and openssh-clients package for using scp but it says already installed.
Trying to install in jump_host or db server?
I want to send the file from jump to db host so installing it on jump host.
It looks like you attempted to install those packages on jump_host instead of stdb01. This is based on you being prompted for peter@stdb01’s password before getting the scp: command not found error…
Try to install on db server.
Can you please provide me the command because I tried it from DB host still it is giving me error. I used the following command:
#scp thor@jump_host:/home/thor/db.sql /tmp/
It says: Connection refused error.
Also I gave the necessary permissions to /tmp in case required.
After installation of openssh-clients and openssh-server packages in db server.
It should be work fine. After this restart sshd service and then try your following command.
Sorry to bother you but I’m not able to do the scp thing. I did install the packages restarted the service. Not able to figure out what is wrong I tried on my host machine the same syntax for scp it worked.
P.S. Also tried doing scp with thor user
Have you checked port is active by netstat or ss command?
In addition to @player001’s suggestions, try scp’ing from the jumphost. .e.g.
scp /home/thor/db.sql peter@stdb01:/home/peter/db.sql. That should work if you’ve installed scp correctly on stdb01…
I performed the same task.
I was able to see the databases from all the app servers.
I also configured my.cnf to skip-networking=0 and skip-bind-address.
I was still getting the Connection error issue.
Any thoughts on what might be wrong from my end?
@Inderpreet I have used wrong command while restoring the dump , is it possible to re-assign this task one more time ?