Task "Install and Configure DB Server" Need Help

pmpcert2013 · March 30, 2020, 11:12pm

Hi Friends,
I am trying to accomplish this task which has seven sub-tasks but somewhere I am failing & unable to complete even after multiple try. I am seeking your help & in providing some inputs if possible that can help me resolving the problem.

a. Install/Configure MariaDB server. - Success

b. Create a database with name kodekloud_db8. - Success

c. There is a DB dump on jump_host under location /home/thor/db.sql. Restore this database in newly create database. - Success

d. Create a user kodekloud_tim and set any password you like. - Success

e. Grant full permissions to user kodekloud_tim on database kodekloud_db8. - I am doubtful though I am following the right process.

f. Update database related details in /data/wp-config.php file on storage server which is our NFS server having a share /data that is mounted on each app server on location /var/www/html. (for more details about how to update WordPress config file please visit Editing wp-config.php – Documentation – WordPress.org) - Success as per process but not sure if any mistake from myside.

g. You can access the website on LBR link, to do so click on the + button on top of your terminal and select option Select port to view on Host 1 and after adding port 80 click on Display Port. - Failing with error “Error establishing database connection”.

Please suggest if any correction required in my approach.

Screenshots attached for reference.

Thanks,
Pradip
![image|605x243] (upload://1XoZ7xfaiX5XJ2ueF38Ta1Rihhd.png)

pmpcert2013 · April 1, 2020, 7:13am

Hi All,

Any helpful tips?

Thanks,
Pradip

Tej-Singh-Rana · April 1, 2020, 7:36am

I haven’t got this task and didn’t work on wordpress.
mostly people not respond here .

Lalit · April 1, 2020, 8:38am

To configure MariaDB for remote client access, edit /etc/my.cnf and add below values under [mysqld] section.

skip-networking=0
skip-bind-address

then restart mariadb service.

hasmukhrathod · April 2, 2020, 4:32pm

@pmpcert2013

First we need to understand the error message.
Please turn on 「 define( 'WP_DEBUG' , false);」to define( 'WP_DEBUG' , true);
in the file /data/wp-config.php on NFS server.
It will tell us the exact error message for db connection.

Then, need to check the grant of DB to a particular user.
I forgot once to execute 「FLUSH PRIVILEGES;」which simply assign new privileges.

I hope you will get some pointers and complete your task.

Thank you.

swaroopcs88 · April 21, 2020, 2:23pm

@pmpcert2013 @Tej-Singh-Rana @hasmukhrathod @Lalit
There is a DB dump on jump_host under location /home/thor/db.sql. Restore this database in newly create database. -
for this step. should I copy this sql file to db server using scp command and restore the sql from db server on newly created database?
or this should be done in a different way?
could you please check and advise.

Tej-Singh-Rana · April 21, 2020, 5:41pm

copy this sql file jump_host to db server from scp command and restore it this sql file.

rajeshr.rajeshnet · June 7, 2020, 12:49pm

You may transfer this DB dump file to DB server using sftp and restore

rajeshr.rajeshnet · June 7, 2020, 12:51pm

Try to use Port 80 and launch WP site

bushido · June 8, 2020, 4:31am

In /** MySQL hostname **/ section use hostname (e.g. stdb01) only instead of IP:Port (172.16.239.10:3306)

Hope this will resolves your problem.

Jethan · June 8, 2020, 6:32am

Hi Pradip,

I think you have problems while connecting to database. And it must be related to the user privileges.
Before you modify user privilege, I request you to check if you are able to connect using those user credentials from terminal.

If it fails, then drop your user and execute as below,

MariaDB [(none)]> drop user ‘kodekloud_tim’@‘%@%’;

MariaDB [(None)]> create user ‘kodekloud_tim’@‘%’ identified by ‘Pra2468@’ ;

MariaDB [(None)]> grant all privileges on kodekloud_db8.* to ‘kodekloud_tim’@‘%’;

MariaDB [(None)]> Flush privileges;

Try and let us know!!

ali.za.ac · August 18, 2020, 5:13am

Hey @bushido I tired but still not luck with the advise you gave, can you please advise what the issue could be ?
@pmpcert2013 Hey did you get this resolved ? if so please advise how to correct the error " Error establishing database connection"
@Tej-Singh-Rana would you be able to give some input

Tej-Singh-Rana · August 18, 2020, 5:23am

Hello, ali.za.ac
Which task you got assigned?

ali.za.ac · August 18, 2020, 5:24am

@Tej-Singh-Rana Install and Configure DB Server

selvag · August 28, 2020, 7:46am

Bellow steps works for me

db server


sudo yum install -y mariadb-server

sudo yum install -y mariadb*

systemctl restart mariadb

sudo systemctl enable mariadb && systemctl start mariadb && systemctl status mariadb

sudo mysql_secure_installation

...Set root password? [Y/n] **y**
New password:
root pwd : pass 

...Remove anonymous users? [Y/n] **Y**
 ... skipping.

...Disallow root login remotely? [Y/n] **Y**

...Remove test database and access to it? [Y/n] **Y**

...Reload privilege tables now? [Y/n] **Y**

login with root user with root pwd

mysql -u root -p
create database kodekloud_db7;
create user ‘kodekloud_top’@localhost identified by ‘pass’;
grant all on kodekloud_db7.* to ‘kodekloud_top’ identified by ‘pass’ WITH GRANT OPTION;
grant all privileges on kodekloud_db7.* to ‘kodekloud_top’@‘%’ WITH GRANT OPTION;

FLUSH PRIVILEGES;
exit

[root@stdb01 peter]# vi /etc/my.cnf
bind-address=172.16.239.10
port=3306

to import dump

mysql -u kodekloud_top -p kodekloud_db7 < /tmp/db.sql

systemctl restart mariadb

To Validate from db server

mysql -u kodekloud_top -p -h stdb01
mysql -u kodekloud_top -p -h localhost

login to storage server

cat /data/wp-config.php | grep DB_NAME
cat /data/wp-config.php | grep DB_USER
cat /data/wp-config.php | grep DB_PASSWORD
cat /data/wp-config.php | grep DB_HOST

sudo sed -i 's/dbname/kodekloud_db7/g' /data/wp-config.php
sudo sed -i 's/dbuser/kodekloud_top/g' /data/wp-config.php
sudo sed -i 's/dbpass/pass/g' /data/wp-config.php
sudo sed -i 's/dbhost/stdb01/g' /data/wp-config.php

one more step to validate my sql connection from app server:
login app server install my sql client and try to login mariadb using specified user

app server

yum install mysql -y
mysql -u kodekloud_top -p -h stdb01

Final LBR link will be look like below

nidhincn · August 29, 2020, 12:13pm

Hi @selvag,
Your solution helped me to complete the task successfully, much appreciated.

Regards
Nidhin

sreedhar · October 20, 2020, 8:47pm

Hi Selvag,

I followed your steps am getting this page.Can you please assist me.

Thanks
Sree

selvag · October 21, 2020, 2:52am

Can you please share the steps which you done? or take review in task board.

sreedhar · October 21, 2020, 9:14am

Thanks for your reply, sorted my dumps was not correctly copied.Now my task is success

girish.shet187 · December 18, 2020, 9:47pm

@selvag @Tej-Singh-Rana @ramashish.sharma @satagrawal @Inderpreet @akshayyw

I have issue’s completing this task, Getting “Error Establishing Database Connection” issues.
Guy’s please help me out to finish the task. PFA screenshots.

![2-6|690x164]