Saturday, October 31, 2015

Re size file system Error on Linux System


Re size file system Error on Linux System


Step : 1

[root]# resize2fs /dev/data_vg/backup_lv

resize2fs 1.41.12 (17-May-2010)
Please run 'e2fsck -f /dev/data_vg/backup_lv' first.

Step : 2

[root]# umount /data/dbbd/app/dbbackup

Note: /data/dbbd/app/dbbackup  (file system name)              

Step : 3

[root]# e2fsck -f /dev/data_vg/backup_lv      

Note: /dev/data_vg/backup_lv  (LV Name)           

e2fsck 1.41.12 (17-May-2010)
Pass 1: Checking inodes, blocks, and sizes
Pass 2: Checking directory structure
Pass 3: Checking directory connectivity
Pass 4: Checking reference counts
Pass 5: Checking group summary information
/dev/data_vg/backup_lv: 20/1638400 files (0.0% non-contiguous), 1160953/6553600 blocks

Step : 4

[root]# resize2fs /dev/data_vg/backup_lv

resize2fs 1.41.12 (17-May-2010)
Resizing the filesystem on /dev/data_vg/backup_lv to 13107200 (4k) blocks.
The filesystem on /dev/data_vg/backup_lv is now 13107200 blocks long.

Step : 5

[root]# mount /data/dbbd/app/dbbackup

Note: /data/dbbd/app/dbbackup  (file system name)

Step : 6

[root]# df -h /data/dbbd/app/dbbackup


/dev/mapper/data_vg-backup_lv
                       50G  25G   25G  50% /data/dbbd/app/dbbackup




Extend Volume Group (VG) / Logical Volume (LV) / File System on Linux System

Extend Volume Group (VG) / Logical Volume (LV) / File System on Linux System


Step: 1

Add New Hard Disk into the VM / Physical .

Refer below Link for Adding Disk details.
Add New Virtual (or) Physical Hard Disk on Linux System


Step: 2

Display the Added New Disk.

root@#fdisk -l

Disk /dev/sdb 100 GB, 100000000000 bytes
255 heads, 63 sectors/track, 15665 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000


Step: 3

Extend Volume Group (VG).

root@#vgextend data_vg /dev/sdb
Volume group "data_vg" successfully extended

Step: 4

Extend Logical Volume(LV).

[root]# lvextend -L+25G /dev/data_vg/data_lv

Extending logical volume data_lv to 50.00 GiB
Logical volume data_lv successfully resized

Step: 5

Resize the Logical Volume (LV). It will automatically Increase  file system size.

[root]# resize2fs /dev/data_vg/data_lv

resize2fs 1.41.12 (17-May-2010)
Filesystem at /dev/data_vg/data_lv is mounted on data; on-line resizing required
old desc_blocks = 2, new_desc_blocks = 4
Performing an on-line resize of /dev/data_vg/data_lv to 13107200 (4k) blocks.
The filesystem on /dev/data_vg/data_lv is now 13107200 blocks long.

Step: 6

[root]# df -h /data

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/data_vg-data_lv
                      50G  25G   25G  50% data



Add New Virtual (or) Physical Hard Disk on Linux System

Add New Virtual (or) Physical Hard Disk on Linux System


Add New Hard Disk or New VMware Disk  (or) Virtual Hard Disk into Linux Physical / Virtual System.

Step: 1

Login into root privilege account on Linux system and perform below commands.

Find Out the scsi host adapter.

root#ls /sys/class/scsi_host
host0  host1  host2

Step: 2

Command configures devices and installs device into the linux system.

root#echo "- - -" > /sys/class/scsi_host/host0/scan
root#echo "- - -" > /sys/class/scsi_host/host1/scan
root#echo "- - -" > /sys/class/scsi_host/host2/scan

Step: 3

Check the added new disk logs.

root#tail -f /var/log/messages

Step: 4

Display the Added New Disk.

root#fdisk -l

Disk /dev/sdb: 100 GB, 100000000000 bytes
255 heads, 63 sectors/track, 15665 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

Step: 5

Convert physical disk to physical volume.

root#pvcreate /dev/sdb
Physical volume "/dev/sdb" successfully created

Step: 6

Display the physical volume.

root#pvscan
   PV /dev/sdb                   lvm2 [100.00 GB]
  Total: 2 [149.87 GB] / in use: 1 [49.88 GB] / in no VG: 1 [100.00 GB]

Step: 7

New Volume Group Creation and Adding New physical volume into New VG.

root#vgcreate data_vg /dev/sdb
Volume group "data_vg" successfully created

Step: 8

New Logical Volume creation (LV).

root#lvcreate -n long_lv -L25G /dev/data_vg
Logical volume "backup_lv" created

Step: 9

Display the Logical Volume (LV).

root#lvdisplay
/dev/data_vg/long_lv


Step: 10

Creating file system.

root#mkfs.ext3 -m 0 /dev/data_vg/long_lv
file system "/dev/data_vg/long_lv" successfully created

Step: 9

Add entry on /etc/fstab for auto mount file system after restart linux system.

root#cd /
root#mkdir logs
root#vi /etc/fstab
/dev/data_vg/long_lv /logs ext3 defaults 0 0

Step: 10

Manual Mount file system.

root#mount /logs

Step : 11

Display New file system.

root#df -h /logs

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/data_vg-long_lv
                       25G  173M   25G   1% /logs



Sunday, October 25, 2015

How to Remove Duplicate Emails from 'Sent Items' Folder of MS Outlook 2013 & 2016


How to Remove Duplicate Emails from 'Sent Items' Folder of MS Outlook 2013 & 2016

This situation causes duplicity of emails and you end up with more than one copies of an email item. Therefore, the best solution to prevent such situations .

 Mentioned below are the steps to perform in Outlook 2013 & 2016:

Step : 1


Step : 2



Step : 3



Step : 4



Step : 5



Step : 6





Prevent Duplicate Mails in Sent Items on Microsoft Outlook 2013 and 2016

Prevent Duplicate Mails in Sent Items on Microsoft Outlook 

2013 & 2016



To prevent Sent Items from being duplicated, you’ll need to disable the Outlook option to save a copy of your Sent Items in your mail account.



The duplicates are caused because Outlook is saving a copy of the sent item as well as gmail. The solution is to stop Outlook doing this.

To disable, go to File > Account Settings > Account Settings > (your mail account) > Change… > More Settings… > Sent Items and then check the option "Do not save copies of sent items --> click OK and Finish.



Below Step by step Procedures:-



To disable this option in Outlook 2013 or Outlook 2016:



Step : 1

File-> Account Settings-> Account Settings





Step : 2

Select your Mail Account-> button Change





Step : 3

Click button More Settings


Step : 4

Tab Advanced-> option: Do not save copies of sent items --> Click OK button.






Sunday, October 11, 2015

MySQL table is marked as crashed and should be repaired on Nagios


MySQL table is marked as crashed and should be repaired on Nagios  or Any Other Applications


Cause:


Often after running a similar unexpected events. Frequently Linux file system / Windows drive out of disk space, some of the database tables may have become corrupt. This often occurs after you experience out of disk space problems on the disk partition where your database resides.

Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these:
  • tbl_name.frm is locked against change.
  • Can't find file tbl_name.MYI.
  • Unexpected end of file.
  • Record file is crashed.
  • Got error nnn from table handler.

Error Code:


151010 13:00:59 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_timedevents' is marked as crashed and should be repaired
151010 13:00:59 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_timedeventqueue' is marked as crashed and should be repaired
151010 13:04:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_systemcommands' is marked as crashed and should be repaired
151010 13:04:00 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_hostchecks' is marked as crashed and should be repaired
.......................................Etc.

Resolution:

Perform below steps on MySQL DB.

mysql> select * from nagios_servicechecks;

ERROR 1046 (3D000): No database selected

mysql> SELECT database();
+------------+
| database() |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

mysql> USE nagios

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select * from nagios_servicechecks;

ERROR 145 (HY000): Table './nagios/nagios_servicechecks' is marked as crashed and should be repaired.

mysql> REPAIR TABLE nagios_servicechecks;

+-----------------------------+--------+----------+-------------------------------------------------------------------------------+
| Table                       | Op     | Msg_type | Msg_text                                                                      |
+-----------------------------+--------+----------
| nagios.nagios_servicechecks | repair | info     | Wrong block with wrong total length starting at 4322280                       |
| nagios.nagios_servicechecks | repair | info     | Wrong block with wrong total length starting at 4322928        
.......Etc


mysql> REPAIR TABLE nagios_servicestatus; 
mysql> REPAIR TABLE nagios_hostchecks;
mysql> REPAIR TABLE nagios_systemcommands;
mysql> REPAIR TABLE nagios_timedeventqueue;

mysql> REPAIR TABLE nagios_timedevents;



MySQL Database login Access denied for user 'root'

MySQL Database login Access denied for user 'root'


Trying to login MySQL Database on Linux system getting Access denied issue in root user.

Error:-

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO).

Resolution:-

Try command on Linux prompt mysql -u root -p

[root@eznag bin]# ./mysql -u root -p

Enter password: --> Type Root Password

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.52 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from nagios_servicechecks;
ERROR 1046 (3D000): No database selected
mysql> 






Gitlab Automation Project Showcase

My GitLab Projects Showcase 🚀 Welcome to my portfolio of GitLab projects. Each repository reflects my journey as an engineer, focusing...