I have done the task and it failed as “website is not setup correctly as its not working on LBR URL”. i checked it and everything was fine but it failed. Could you please check and let me know what went wrong.
May i know the reason for this task failure if possible.
@sreenivas Sorry for delayed response. I don’t think you tested website finally with LBR URL ? Also the DB password seems incorrect:
I have set the DB password as “root” itself but still it got failed.
@sreenivas I don’t think you tested the website finally on LBR link. Please note that this was a remote DB server and the user you created is for localhost which was not going to work for the application on app servers. See this screenshot from your work.
I have performed below steps for this task.
a. Install/Configure MariaDB server – done
b. Create a database – done
c. There is a DB dump restore done . - done
d. Create a user kodekloud_tim and set any password you like. - done – this done for localhost and for all app servers.
e. Grant full permissions to user on database for localhost and for all app servers .
f. Update database related details in /data/wp-config.php file on storage server – done
Note : I have tried to grant access to db user with 172.16.238.* ipaddress … I am getting the error connecting database via LBR link.
for troubleshooting purpose I have installed the mariadb client on one of the app server and tried to login to my DB . but it was throwing error to login to my DB I for got ot capture error message… ( from app server I was not able to connect DB even my remote config was right) .
So I closed that session for a second chance. this time II used the 172.16.239.3 ip address for granting the user access to DB. this time i was able to get the attached web page from LBR but task was failed.
and I was able to login to my DB from app01 server. attached config snaps here
Please let me know anyone succeeded to complete this task . if yes let me know what am missing here .
I have done this configuration in test set with two machine. LEMP with remote mariadb access. and it was working for me.
I have done the task and it failed as “website is not setup correctly as its not working on LBR URL”. I checked it and everything was fine. Could you please check it
Have you imported dump of sql which was provided in the question?
@player001 yes first I copied dump from jump server to peter@stdb01 (home/peter) than restored it by using this command mysql -u kodekloud_cap -p kodekloud_db2 < db.sql
You can visit this post.
@player001 ok thanks