Change Time Zone from Command line | CentOS | RHEL | Ubuntu | Fedora

Hello,

As you all know, It is very easy to change Time Zone using Graphical Interface but this article will help you change TimeZone Using command line.

Time Zone

I have tested these steps on CentOS / RHEL and Ubuntu, Please comment down below if doesn’t work for you.

Please follow these steps as root or with root equivalent sudo rights:

  • Check Time Zone using following command
    [root@tejas-barot-linux-ahmedabad ~]# date
  • First Remove symbolic link of current time zone
     [root@tejas-barot-linux-ahmedabad ~]# rm /etc/localtime
     
  • Let’s Change the Time Zone from Command line
    [root@tejas-barot-linux-ahmedabad ~]# ln -sf /usr/share/zoneinfo/Asia/Kolkata /etc/localtime
     

Note : You can find your time zone under /usr/share/zoneinfo/

Disable rate-limiting in rsyslog v5 | Linux | RHEL | CentOS | Ubuntu

Hello,

First of all extremely sorry for not being active as I was busy with some work, Now back to the blogging.

This article will show you how to disable rsyslog rate-limiting, But You can also use rate-limiting according to your requirement.

How to use rate limiting in rsyslog?

This article is tested with rsyslog 5.7.1 on Fedora 13. It will not work with version of rsyslog prior to 5.7.1.

In rsyslog 5.7.1 we introduced rate limiting. This is a option for the Unix Socket Input module called imuxsock. In short, this option limits the amount of messages written into logfiles by a process, if the process tries to write huge amounts of messages in a short period of time.

To Read more Visit : http://www.rsyslog.com/tag/rate-limiting/

Rsyslog
Rsyslog

If you are receiving error messages like below in /var/log/messages

imuxsock begins to drop messages from pid 5923 due to rate-limiting 

Please following below method to stop / disable rate-limiting in rsyslog in version 5.

Note: rsyslog version 7 has this disabled by default but rsyslog version 5 has this enabled.

To disable it, add following parameters to your /etc/rsyslog.conf , You need to add with root user or root equivalent user.

$SystemLogRateLimitInterval 0
$SystemLogRateLimitBurst 0

Execute following command to restart rsyslog services

service rsyslog restart

SAR GUI: Export sar / sysstat reports as PDF using kSar

Hello,

If you are Linux Administrator you must know what SAR is, sar is a very useful utility for Linux Administrators to get the report of CPU Usage and You can monitor I/O, CPU Usage, Idle system state using sar utility. This article will help you to read / export sar reports in Graphical mode.

In this HowTo, I will show you how you can export sar reports as PDF / JPG / PNG using kSar tool.

ksar - PDF
ksar – PDF

In RHEL / CentOS you will find sar reports under /var/log/sa

In Ubuntu / Debian based Linux you will find sar reports under /var/log/sysstat

Perform following steps to export sar report:

1. Make Sure Java is installed on your system to open kSar Utility.

2. Download kSar Utility from below URL

http://sourceforge.net/projects/ksar/

3. Extract / Unzip Downloaded ksar-x-x-x.zip file

root@tejas-barot-linux-ahmedabad:~/Downloads# unzip kSar-5.0.6.zip

4. Give Executable permission to kSar.jar

root@tejas-barot-linux-ahmedabad:~/Downloads/kSar-5.0.6# chmod +x kSar.jar

5. Execute below command to open java file (kSar.jar):

root@tejas-barot-linux-ahmedabad:~/Downloads/kSar-5.0.6# java -jar kSar.jar

6. Now Click on Data -> Load from Text file…

7. Provide Path of sar reports path:

For RHEL: /var/log/sa/sarXX
For Debian/Ubuntu: /var/log/sysstat/sarXX

8. Select “Export to PDF / JPG / PNG” from Data  To Export sar report as PDF / JPG / PNG

Enjoy Sysstat Monitoring 🙂 Enjoy GUI Reports 🙂 Enjoy Linux 🙂 Enjoy Open Source 🙂

This is how you can export sar reports in Graphical format.

If you like this then Please Click Google +1 Button and Show Your Support. Your Support will encourage me to write more articles.

Please Keep in Touch with Social Networking :-

Facebook Page :- https://www.facebook.com/AllLinuxUsersBlog

Download Ubuntu 14.10 Utopic Unicorn Final ISO / CD / DVD / x86_64 / 32-Bit

Hello,

This post will contain links for Downloading Ubuntu 14.10 Utopic Unicorn Final.

I always Prefer New Releases of Ubuntu and Instantly Install it for Experience the New World of Ubuntu, Ubuntu is very fast to recognize and Fix the Bugs so even if you install it very early you will get bug fixes very quickly and that’s the reason I switch to Ubuntu from Fedora as Fedora is very Lazy in releases as well as Bug fixes and Even Resource Hungry too.

Once you download and use this Ubuntu 14.10 Utopic Unicorn then please do not forget to post comments on your experience.

Ubuntu 14.10 Utopic Unicorn
Ubuntu 14.10 Utopic Unicorn


Now Ubuntu 14.10 Utopic Unicorn Final is now available for download.

Ubuntu 14.10 Utopic Unicorn Final ISO is available for Download in 32-Bit (i386 ) and X86_64 ( 64-Bit) Versions.

You can go through this link and Download Ubuntu 14.10 Utopic Unicorn Final :-

Download Ubuntu 14.10 Utopic Unicorn Final 32-Bit ( i386) :- http://releases.ubuntu.com/14.10/ubuntu-14.10-desktop-i386.iso

Download Ubuntu 14.10 Utopic Unicorn Final x86_64 ( 64-Bit) :- http://releases.ubuntu.com/14.10/ubuntu-14.10-desktop-amd64.iso

Download Ubuntu 14.10 Utopic Unicorn Final Server Edition 32-Bit ( i386) :- http://releases.ubuntu.com/14.10/ubuntu-14.10-server-i386.iso

Download Ubuntu 14.10 Utopic Unicorn Final Server Edition X86_64 ( 64-Bit) :- http://releases.ubuntu.com/14.10/ubuntu-14.10-server-amd64.iso

If you like this then Please Click Google +1 Button and Show Your Support. Your Support will encourage me to write more articles.

Please Keep in Touch with Social Networking :- 
Facebook Page :- https://www.facebook.com/AllLinuxUsersBlog

MySQL: Drop all tables from Database using Script / Linux

Hello,

Few days back, I got a task to do, Task was Keep the database as it is, So that we do not have to add database users, privileges and everything again and again, Just Drop all the databases tables inside the database. If there are only few tables like 5 or 10 than it is easy to do it manually, but what if you have the 100s or 1000s of tables inside database ?

I was in same situation, there were more than 500 tables and  I need to drop it quickly as it was production server, So for the same I managed to do it easily by using few command line parameters and loop, After that I have created script for the same which helps me to drop those tables very easily, You don’t have to worry about each and every table, It will keep database as it is but will drop all the tables from the selected database.

I am sharing that script and steps how to use that script, Would request you to test on non production environment first, Wherever you are executing this script its totally on your risk.

MySQL Script
MySQL Script

 

SUGGESTION: Take a Backup of your database / tables / MySQL Before executing Script, So if anything goes wrong you can also recover.

Steps to execute script :-

1. Download Script

tejas-barot@linux-ahmedabad:~$ wget tejasbarot.com/Scripts/dropall_mysql_tables.sh

2. Give executable permissions

tejas-barot@linux-ahmedabad:~$ chmod +x dropall_mysql_tables.sh

3. Now Let’s execute Script

tejas-barot@linux-ahmedabad:~$ ./dropall_mysql_tables.sh

4. Provide name of the MySQL database from which you want to drop all the tables.

Enter Database name:                         <—- Provide Database name here
Enter MySQL root Password:          
<—- Provide root password of MySQL Here

5. Script will take a Full database backup into /tmp, but I would request don’t depend on this, before executing script take backup.

6. That’s it wait for few minutes, It will drop all the tables from MySQL Database.

Enjoy MySQL 🙂 Enjoy Linux 🙂 Enjoy Open Source 🙂

Please Keep in Touch with Social Networking :- 
Facebook Page :- https://www.facebook.com/AllLinuxUsersBlog

Youtube-dl: Download Youtube Videos in Ubuntu using Command Line

Hello All,

We all Know How Youtube is popular for Videos. We also know that, There are many other ways to download Videos from Youtube and it is easy too.

I was searching a Utility to Download Youtube video in Ubuntu ( 11.10,12.04,12.10,13.04 ) @ Ubuntu Software Center. I got a very nice utility called, youtube-dl.

I am not sure whether the same utility is available on Fedora too, But It might be possible youtube-dl rpm is available on Fedora/RHEL/CentOS, Procedure will be same whether it’s Fedora/CentOS/RHEL or Ubuntu.

Youtube-dl is very easy to use and Download videos from youtube.com.

Just Showing example one or two commands that How you can download Videos from YouTube using Command line.

Step 1 :- To Install Youtube-dl on Ubuntu :-

tejas-barot@linux-ubuntu-youtube-dl:~$ sudo apt-get install youtube-dl

Step 2 :- To Download Video from YouTube, Have a Look at Picture for Output of this command :-

tejas-barot@linux-ubuntu-youtube-dl:~$ youtube-dl http://www.youtube.com/watch?v=nUo-oATZ8BI
YoutTube_dl
YoutTube_dl

Step 3 :- To Download Low Quality Video, Execute Following Command :- 

tejas-barot@linux-ubuntu-youtube-dl:~$ youtube-dl -f worst http://www.youtube.com/watch?v=nUo-oATZ8BI

That’s it. By Following this Method You can Download Youtube video using command line on Linux.

Hope this will helps you all, If you face any issue regarding the same or its not working for you some how then please raise your questions / issues at http://linuxforums.tejasbarot.com

If you like this then Please Click Google +1 Button and Show Your Support. Your Support will encourage me to write more articles.

All Linux User’s Blog Mobile Applications :- http://www.tejasbarot.com/download-mobile-apps/

Please Keep in Touch with Social Networking :- 

Facebook Page :- https://www.facebook.com/AllLinuxUsersBlog

Enjoy Videos 🙂 Enjoy YouTube 🙂 Enjoy Ubuntu 🙂 Enjoy Linux 🙂 Enjoy Open Source 🙂

Install FlareGet Download Manager on Ubuntu / Linux Mint

Hello,

I have already posted the article for the Download Manager but Posting for One More Internet Download Manager called FlareGet on Linux.

By Performing this Howto You will able to Install and Use FlareGet Internet Download Manager on Ubuntu 13.04 / 12.10 / 12.04 / 11.10 and Linux Mint 14 / 13 / 12 .

I am using FlareGet from Past few days and It is worth Internet Download Manager to have on Linux Platform.

FlareGet
FlareGet

 

Remove If any previous version of FlareGet is Installed.

tejas-barot@linux-support-ahmedabad:~# sudo apt-get remove flareget

# Now Lets Install FlareGet on Ubuntu / Linux Mint :-

Step 1 :- Add PPA to your Ubuntu  

tejas-barot@linux-support-ahmedabad:~# sudo add-apt-repository ppa:upubuntu-com/flareget-i386

Step 2 :- Update Repository

tejas-barot@linux-support-ahmedabad:~# sudo apt-get update

Step 3 :- Install FlareGet

tejas-barot@linux-support-ahmedabad:~# sudo apt-get install flareget

Step 4 :- Execute Following command to Launch FlareGet

tejas-barot@linux-support-ahmedabad:~# flareget

That’s IT. FlareGet is Installed and Ready to use.

Hope this will helps you all, If you face any issue regarding the same or its not working for you some how then please raise your questions / issues then comment down below.

If you like this then Please Click Google +1 Button and Show Your Support. Your Support will encourage me to write more articles.

All Linux User’s Blog Mobile Applications :- http://www.tejasbarot.com/download-mobile-apps/

Please Keep in Touch with Social Networking :- 

Facebook Page :- https://www.facebook.com/AllLinuxUsersBlog

Enjoy FlareGet 🙂 Enjoy Linux 🙂 Enjoy Open Source 🙂