Monday, 13 June 2016

How to install clamAV on Centos 6

Install EPEL repo:
Before we can do proceed, you must ensure that you have the EPEL yum repository enabled. To do this,


CentOS 6.x

#rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

CentOS 5.x
#rpm -Uvh http://mirror.pnl.gov/epel/5/x86_64/epel-release-5-4.noarch.rpm

Install clamAV
# yum -y install clamav clamd
# chkconfig clamd on

Update the clamav virus database
# /usr/bin/freshclam

Error:

# /usr/bin/freshclam
ERROR: Please edit the example config file /etc/freshclam.conf
ERROR: Can't open/parse the config file /etc/freshclam.conf

To fix this above  error Comment out the Line with “Example”
#vim  /etc/freshclam.conf
##
## Example config file for freshclam
## Please read the freshclam.conf(5) manual before editing this file.
##
# Comment or remove the line below.

Example


Change to

#vim /etc/freshclam.conf
##
## Example config file for freshclam
## Please read the freshclam.conf(5) manual before editing this file.
##
# Comment or remove the line below.

# Example


Run freshclam again
# /usr/bin/freshclam

Start Clamav
# service clamd start

 Starting Clam AntiVirus Daemon: ERROR: Please edit the example config file /etc/clamd.conf
ERROR: Can't open/parse the config file /etc/clamd.conf
 [FAILED]

Edit the config file, comment out “Example”

##
## Example config file for the Clam AV daemon
## Please read the clamd.conf(5) manual before editing this file.
##
# Comment or remove the line below.

#Example



"ERROR: Please define server type (local and/or TCP)"
You may need to uncomment the "TCPSocket" line in clamd.conf.


Set Clamav to run a daily scan

#vim /etc/cron.daily/clamscan

#!/bin/bash

# setup the scan location and scan log

CLAM_SCAN_DIR="/var/www/vhosts"

CLAM_LOG_FILE="/var/log/clamav/dailyscan.log"

# update the virus database

/usr/bin/freshclam

# run the scan

/usr/bin/clamscan -i -r $CLAM_SCAN_DIR >> $CLAM_LOG_FILE

MAILTO=user@domain.com


or

#clamscan -i -r --log=/var/log/clamscan-date.txt /var/www/vhosts/*

Set the cron file as an executible
#chmod 555 /etc/cron.daily/clamscan

Test your installation and cron job
 #/etc/cron.daily/clamscan


Try to scan.
[root@mail ~]# clamscan --infected --remove --recursive /home          #/home is your scan folder
----------- SCAN SUMMARY -----------
Known viruses: 3509099
Engine version: 0.98.4
Scanned directories: 94
Scanned files: 109
Infected files: 0
Data scanned: 0.95 MB
Data read: 0.89 MB (ratio 1.07:1)
Time: 8.485 sec (0 m 8 s)

# Download trial virus
[root@amir ~]# wget http://www.eicar.org/download/eicar.com
[root@amir ~]# clamscan --infected --remove --recursive .

./eicar.com: Eicar-Test-Signature FOUND
./eicar.com: Removed. # just detected

----------- SCAN SUMMARY -----------
Known viruses: 3509099
Engine version: 0.98.4
Scanned directories: 110
Scanned files: 147
Infected files: 1
Data scanned: 0.78 MB
Data read: 0.64 MB (ratio 1.21:1)
Time: 7.982 sec (0 m 7 s)

Tuesday, 31 May 2016

How to Fix “Configuration of pmadb… not OK” in phpMyAdmin or phpmyadmin configuration storage is not completely.

To fix this you have to import/create the phpmyadmin database with it’s tables. An SQL script called create_tables.sql should be in the scripts, examples or sql folder of your phpMyAdmin installation.
To find out create_tables.sql run this below command

#find / -name create_tables.sql
Sample Output should be like this...
Go to create_table.sql directory
#mysql -u root -p < create_tables.sql  
Give your mysql root password ********
# mysql -u root –p
Give your mysql root password ********
>CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass';
>GRANT ALL PRIVILEGES ON `phpmyadmin`.* TO 'pma'@'localhost' WITH GRANT OPTION;
>FLUSH PRIVILEGES;
>exit


Now edit /etc/phpMyAdmin/config.inc.php and configure/uncomment those lines:

#vim /etc/phpMyAdmin/config.inc.php

/*
 * phpMyAdmin configuration storage settings.
 */

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

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

Finally logout and login again to phpMyadmin.

Wednesday, 25 May 2016

MySql database administration in Linux

  • How to set MySQL Root password?
                 #mysqladmin -u root password YOURNEWPASSWORD
  • How to Change MySQL Root password?
                 #mysqladmin -u root -p oldpassword password 'newpassword'
 
  • How to check MySQL Server is running?
               # mysqladmin -u root -p ping
                 Enter password:
                 mysqld is alive

  • How to Check which MySQL version
               # mysqladmin -u root -p version

  • How to Find current Status of MySQL server?
               # mysqladmin -u root -ptmppassword status

  • How to check & see MySQL Server Variable’s and value’s?
               # mysqladmin -u root -p extended-status
               #mysqladmin  -u root -p variables

  • How to check all the running Process of MySQL server?
              # mysqladmin -u root -p processlist

  • How to create a Database?
               # mysqladmin -u root -p create databasename

  • How to delete a Database?
               # mysqladmin -u root -p drop databasename

  • How to reload/refresh MySQL Privileges?
               # mysqladmin -u root -p reload;
               # mysqladmin -u root -p refresh

  • How to shutdown MySQL server Safely?
               #mysqladmin -u root -p shutdown

MySQL Flush commands
  • flush-hosts: Flush all host information from host cache.
               # mysqladmin -u root -p flush-hosts

  • flush-tables: Flush all tables.
                # mysqladmin -u root -p flush-tables

  • flush-threads: Flush all threads cache.
                # mysqladmin -u root -p flush-threads

  • flush-logs: Flush all information logs.
                # mysqladmin -u root -p flush-logs

  • flush-privileges: Reload the grant tables (same as reload).
                # mysqladmin -u root -p flush-privileges

  • flush-status: Clear status variables.
                # mysqladmin -u root -p flush-status

  • How to Connect remote mysql server
                # mysqladmin  -h 172.16.25.126 -u root –p

  • How to store MySQL server Debug Information to logs?
                # mysqladmin  -u root -p debug

Monday, 28 March 2016

How to reset/recover/break linux Grub Boot Loader Password




Step 1:  Get the CentOS/Red Hat bootable CD/DVD/USB media.And insert the media into system. 

Step 2:  On booting you will see some options on screen.Use any one method given below:
Select “Rescue installed system” and hit enter.

Alternatively, you can also press TAB key and add the word “linux rescue” and hit enter.

Do not worry, after this all steps are same.

Now please see this video Recover Linux Grub Password


Here my OS version is centos 6.7. If you have an query please feel free to comment below. Thanks....


Related Video: How to Protect GRUB with Password in Linux