How to Install PhPMyAdmin on Centos 7 from source

Dear Friends,

First of all we will install required repositories.

[root@itpings opt]# rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
[root@itpings opt]# yum -y install epel-release

Now we will install apache, mariadb, mariadb-server and php56

[root@itpings opt]# yum -y install httpd mariadb mariadb-server php56w php-mbstring php-mysql php-soap

Once installed we will download phpmyadmin from phpmyadmin.net

[root@itpings opt]# wget https://files.phpmyadmin.net/phpMyAdmin/4.7.2/phpMyAdmin-4.7.2-all-languages.zip

unzip the content and move it to /var/www/html and rename the unzipped content to phpmyadmin

[root@itpings html]# unzip phpMyAdmin-4.7.2-all-languages.zip
[root@itpings html]# mv phpMyAdmin-4.7.2-all-languages.zip phpmyadmin

Now Change the ownership of the folder

[root@red html]# chown -R apache.apache phpMyAdmin
[root@red html]# chmod -R 755 phpMyAdmin

Now we will copy config.sample file to config.ini.php

[root@itpings html]# cp config.sample.inc.php config.inc.php

Now we will edit config.inc.php and only add root user and password of mysql ( Make sure you have root user and password of mysql)

/* User used to manipulate with storage */
 $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
 $cfg['Servers'][$i]['controluser'] = 'root';
 $cfg['Servers'][$i]['controlpass'] = 'itpings123';

Now to visit phpmyadmin visit http://<your-ip-address>/phpmyadmin and provide the above user and password.

Done

Thanks,

Salman A. Francis
YouTube: Linuxking
Facebook: LZHProject, Linuxking77

How to Add Physical Disk to Increase Size of /dev/mapper/centos-root

Dear Friends,

I ran into a problem where my openstack machine ran out of space. My Logical FS /dev/mapper/centos-root was only 50GB and most of the space was lost.

Solution:
LVM

I Added a new 500GB HDD (sdb), created partition with parted (sdb1) and gave the below commands:

[root@stack opt]# pvcreate /dev/sdb1
Physical volume "/dev/sdb1" successfully created

Next Check your Volumes with “vgdisplay” command

[root@stack opt]# vgdisplay 
 --- Volume group ---
 VG Name centos
 System ID 
 Format lvm2
 Metadata Areas 1
 Metadata Sequence No 4
 VG Access read/write
 VG Status resizable
 MAX LV 0
 Cur LV 3
 Open LV 3
 Max PV 0
 Cur PV 1
 Act PV 1
 VG Size 465.27 GiB
 PE Size 4.00 MiB
 Total PE 119109
 Alloc PE / Size 119109 / 465.27 GiB
 Free PE / Size 0 / 0 
 VG UUID TrvUI3-Xt7U-6vzF-5RtW-OfK0-OCOy-Tejrb6
 
 --- Volume group ---
 VG Name cinder-volumes
 System ID 
 Format lvm2
 Metadata Areas 1
 Metadata Sequence No 5
 VG Access read/write
 VG Status resizable
 MAX LV 0
 Cur LV 0
 Open LV 0
 Max PV 0
 Cur PV 1
 Act PV 1
 VG Size 20.60 GiB
 PE Size 4.00 MiB
 Total PE 5273
 Alloc PE / Size 0 / 0 
 Free PE / Size 5273 / 20.60 GiB
 VG UUID 9LDtLm-52Un-1QJA-yc3q-13vE-LqEc-hX0kiU

Continue reading

Convert pkcs12 key to bks format for Android

Dear Reader,

If you ever want to convert a pkcs12 format key to bks format for Android follow the below instructions.

First of all downlaod bcprov-jdk16-1.46.jar file

[root@itpings certs]# wget http://repo1.maven.org/maven2/org/bouncycastle/bcprov-jdk16/1.46/bcprov-jdk16-1.46.jar
–2017-06-30 17:05:40– http://repo1.maven.org/maven2/org/bouncycastle/bcprov-jdk16/1.46/bcprov-jdk16-1.46.jar
Resolving repo1.maven.org (repo1.maven.org)… 151.101.32.209
Connecting to repo1.maven.org (repo1.maven.org)|151.101.32.209|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 1876535 (1.8M) [application/java-archive]
Saving to: ‘bcprov-jdk16-1.46.jar’

bcprov-jdk16-1.46.j 100%[===================>] 1.79M –.-KB/s in 0.02s

2017-06-30 17:05:40 (89.3 MB/s) – ‘bcprov-jdk16-1.46.jar’ saved [1876535/1876535]

Now Convert the File as follow with keytool

[root@itpings certs]# keytool –importkeystore –srckeystore user.P12 -srcstoretype pkcs12 –destkeystore user.bks –deststoretype bks –provider org.bouncycastle.jce.provider.BouncyCastleProvider -–providerpath bcprov-jdk16-1.46.jar
Enter destination keystore password:
Re-enter new password:
Enter source keystore password:
Entry for alias 1 successfully imported.
Import command completed: 1 entries successfully imported, 0 entries failed or cancelled
[root@itpings certs]# ls
user.bks

Done.

Thanks,
Salman Aftab
ITpings
YouTube: LinuxKing
FaceBook: LZHProject

How to Bring back eth0 on CentOS 7 ( No Dynamic Ethernet Names)

To Install CentOS 7 without dynamic Ethernet names such as enps2001 use the following technique.

Edit the grub file

Go to /etc/default/grub and add the following lines

In front of /root add the following

biosdevname=0 net.ifnames=0

Then issue the following command

grub2-mkconfig -o /boot/grub2/grub.cfg
Reboot the machine and you will see eth0 and eth1 instead of enps2001 etc.

Thanks,
Salman

Linux Tips ( grep the text without hashes and blank lines )

In our second post of linux tips i would like to share a very simple example in which i will use grep tool to remove all the hashes and blank lines from a file.

In our example we will use file1.txt with the following content

linux-11oz:/test # cat file.txt 
#The file with hashes
###
####
##

This is a test file

With lots of spaces


and few lines with


####hashes
###

So lets remove the hashes and blank lines with single grep command

We can use the following trick

linux-11oz:/test # grep . file.txt | grep -v "#"
This is a test file
With lots of spaces
and few lines with

The “.” will remove the blank lines and  “-v” will invert the match of #

Thats how simple it is. If you know a better way of doing it , Please send me an email or comment.

Email: learning@itpings.com

Thanks

Salman A. Francis

 

Linux Tips ( chmod tip )

Hey Guys this is going to be a new series of posts in which i will be sharing some cool linux tips.  You can watch the video of this post on http://www.youtube.com/linuxking

So here is the first tip Chmod:

I hope you guys are already familiar with chmod command if not checkout my Youtube “Linuxking” channel for theses commands.

With Chmod you can change the mode of the files and directories.
e.g
chmod 775 dir  command will change the permission on directory with rwxrwxrw-

Also using -R option with chmod will change the permission on the directory as well the content within the directory with same permissions.

However lets say you want to change the permissions of a directories to executable within a directory without changing permissions of file use the below tip.

Lets say you have a directory “test1” & “test2” inside “test” directory

test directory has also a  file inside it called file1.txt

file1.txt has permission rw——-

directory test1 has permission rwx——

directory test2 has permission rw——-

linux-11oz:/test # ls -ltr
total 0
-rw------- 1 root root 0 Mar 22 17:06 file.txt
drwx------ 1 root root 0 Mar 22 17:07 test2
drwx------ 1 root root 0 Mar 22 17:07 test1

Now if you try to change the permission with a simple ” chmod -R command ” of all the directories to “executable” inside test directory you could also change permission of the file inside test diretory.

Example:

linux-11oz:/ # chmod -R ug+x test/
linux-11oz:/ # cd test/
linux-11oz:/test # ls -ltr
total 0
-rwx--x--- 1 root root 0 Mar 22 17:06 file.txt  (You can see that the file also became executable)
drwx--x--- 1 root root 0 Mar 22 17:07 test2
drwx--x--- 1 root root 0 Mar 22 17:07 test1

Now to avoid such situation we will use X instead of x, lets see the impact of X with chmod command

linux-11oz:/ # chmod -R ug+X test/
linux-11oz:/ # cd test/
linux-11oz:/test # ls -ltr
total 0
-rw------- 1 root root 0 Mar 22 17:06 file.txt (You can see the file's permission has not changed to executable)
drwx--x--- 1 root root 0 Mar 22 17:07 test2
drwx--x--- 1 root root 0 Mar 22 17:07 test1
linux-11oz:/test #

I hope you have Enjoyed this tip, keep visiting our site for more information.

Recovery of the File System from Disaster

Hey Guys, long time no see…Well i am back and this time the issue is File System.

What Happened ?

Well My Backup Server’s root partition ran out of space due to some issue, and since it was on LVM (Logical Volume Manager) i took some space from my /home partition (it was 400 GB ) and added to my root partition. Following commands were used to resize the partition.

umount /dev/mapper/centos-home

lvreduce -L 200G /dev/mapper/centos-home

Note first i unmounted the partition and then reduced the space from my /home partition which was mounted as /centos-home
I took 200 GB out of it and added to my root partition.

The Mistake: I forgot to remount /home to /dev/mapper/centos-home

But i extended the partition with the following command:

lvextend -r -l+100%FREE /dev/mapper/centos-root

As per above command the partition will be re-sized to the 100% free space available from the reduced volume. Of course it was 200 GB. All was good when i saw the partition sized changed from no space to +200 GB. But then i realized that i was not able to mount /home to /centos-home and that was the time when all problem started. I “Rebooted The Machine” and when it came back it refused to enter the normal boot prompt but went into “Emergency mode”

Things i Tried:

I tried to fix the partition with xfs_repair tool , but in vain , and i received the error that “Cannot Find Super Block “

I tried to run the fixes couple of time but failed every time.

The Fix:

I fixed the issue by the following commands:

lvremove /dev/mapper/centos-home
lvcreate -L 200GB -n home centos

mkfs.xfs /dev/centos/home

mount /dev/mapper/centos-home

Luckily there was no important data on my /home partition and i was able to save my server.

Good Practice:

If you every fall prey to such situation, remember to “Backup” to an external drive and then proceed with the above mentioned technique to rescue yourself from such difficult situation.

I hope it will help some one some where, Let me know with your feedback.

Thanks & Best Regards,

Salman A. Francis

Linux Partitioning of more than 2GB Disk

So just wanted to share how to partition your hard drive from Linux command line if you have a drive greater than 2GB.

In my case its 3TB and i want to create a single partition out of it.

I used “gdisk” , its similar to “fdisk” but can create and understand large disk partitioning system.

 root@M-PVPS:/# gdisk /dev/sdb

GPT fdisk (gdisk) version 0.8.5

Partition table scan:
MBR: MBR only
BSD: not present
APM: not present
GPT: not present
***************************************************************
Found invalid GPT and valid MBR; converting MBR to GPT format.
THIS OPERATION IS POTENTIALLY DESTRUCTIVE! Exit by typing ‘q’ if
you don’t want to convert your MBR partitions to GPT format!
***************************************************************
Command (? for help):

Now we will type “p” to print partition table.

Number Start (sector) End (sector) Size Code Name
1 2048 52889599 25.2 GiB 0700 #####
2 209713152 216107007 3.0 GiB 0700 #####

Now i will delete the available partition with “d”

Command (? for help): d
Partition number (1-2): 1

Now i will delete the 2nd partition with “d” and then typing “2”

Now i will print the partitioning table with “p”

Command (? for help): p
Disk /dev/sdb: 5860533168 sectors, 2.7 TiB
Logical sector size: 512 bytes
Disk identifier (GUID): 7F138376-657F-441A-B784-96E22BDAB49D
Partition table holds up to 128 entries
First usable sector is 34, last usable sector is 5860533134
Partitions will be aligned on 2048-sector boundaries
Total free space is 5860533101 sectors (2.7 TiB)

Now i will create the partition with “n” and selecting all the default values.

Command (? for help): n
Partition number (1-128, default 1):
First sector (34-5860533134, default = 2048) or {+-}size{KMGTP}:
Last sector (2048-5860533134, default = 5860533134) or {+-}size{KMGTP}:
Current type is ‘Linux filesystem’
Hex code or GUID (L to show codes, Enter = 8300):
Changed type of partition to ‘Linux filesystem’

Now i will print the partition table with “p”

Number  Start (sector)    End (sector)  Size       Code  Name
1            2048      5860533134   2.7 TiB     8300  Linux filesystem

Now we will write and save partition with “w” command.

Command (? for help): w

Final checks complete. About to write GPT data. THIS WILL OVERWRITE EXISTING
PARTITIONS!!

Do you want to proceed? (Y/N): y
OK; writing new GUID partition table (GPT) to /dev/sdb.
The operation has completed successfully.

Now we will create the file system with “mkfs -t ext3 /dev/sdb” command

root@M-PVPS:/# mkfs -t ext3 /dev/sdb1
mke2fs 1.42.5 (29-Jul-2012)
/dev/sdb is entire device, not just one partition!
Proceed anyway? (y,n) y

Now you can check the drive with df -h command