HowTo: Install MySQL Workbench on RHEL 5.x / CentOS 5.x | x86_64

Hello

What is MySQL Workbench ?

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

MySQL Workbench
MySQL Workbench

Sharing article which will help you all to Install MySQL Workbench on RHEL 5.4 / CentOS 5.4 x86_64 (64-Bit).

Please follow below steps to install MySQL Workbench on RHEL 5.x / CentOS 6.x 64 Bit version.

1. You need to be root to install RPMs.

2. Download MySQL-Workbench RPM from below link,

[root@tejasbarot ~]# wget ftp://ftp.pbone.net/mirror/dev.mysql.com/pub/Downloads/MySQLGUITools/mysql-workbench-oss-5.2.17-1centos.el5.x86_64.rpm

3. Download dependencies from below link:

[root@tejasbarot ~]#  wget http://tejasbarot.com/RPMs/downloads/mysql-workbench.tar.gz
[root@tejasbarot ~]# tar zxvf mysql-workbench.tar.gz
[root@tejasbarot ~]# cd mysql-workbench
[root@tejasbarot mysql-workbench]# rpm -Uvh *.rpm

4. Now Next step to Install downloaded RPM MySQL-Workbench in step 2.

[root@tejasbarot ~]# yum -y localinstall mysql-workbench-oss-5.2.17-1centos.el5.x86_64.rpm --nogpgcheck

5. That’s it. Now Wait for dependencies to be installed and MySQL Workbench will be ready for you.

Hope this will be helpful to you all.

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

Install / Configure Request Tracker 4.0.19 on CentOS / RHEL 5.x

Dear all,

What is Request Tracker ?

Request Tracker, commonly abbreviated to RT, is a ticket-tracking system written in Perl used to coordinate tasks and manage requests among a community of users. RT’s first release in 1996 was written by Jesse Vincent, who later formed Best Practical Solutions LLC to distribute, develop, and support the package. RT is open source (FOSS) and distributed under the GNU General Public License.

Click on this link to know more about Request Tracker :- http://en.wikipedia.org/wiki/Request_Tracker

Request Tracker
Request Tracker

This article is specially for them who find Request Tracker tough and difficult task to Install and Configure. In this article i will show you steps to Install Request Tracker on CentOS and RHEL 5.x. You can try this how to on i386 (32-Bit) and x86_64 architecture.

I have tested this article on RHEL 6.3 x86_64 bit, not tested on CentOS / RHEL 5.x but It should work.

Perform Following steps to Install / Configure Request Tracker on Linux :-

1. You need to be root.

2. Internet must be running from Terminal/CLI.

3. Stop Firewall Services and Disable services on boot. # This is not recommended on Production environment.

[root@requst-tracker ~]# /etc/init.d/iptables stop && /etc/init.d/ip6tables stop && chkconfig iptables off && chkconfig ip6tables off

4. Disable SELinux.

[root@requst-tracker ~]# vi /etc/selinux/config

Change it to SELINUX=disabled

[root@requst-tracker ~]# vi /etc/sysconfig/selinux

Change it to SELINUX=disabled

5. Restart your system to take effect of SELINUX configuration.

6. First of All Let’s move out existing repositories so by that We can avoid issue of conflict in dependencies.

[root@requst-tracker ~]# mkdir /root/origrepos
[root@requst-tracker ~]# mv /etc/yum.repos.d/*.repo /root/origrepos

7. Let’s configure Additional repositories.

[root@requst-tracker ~]# wget http://epel.mirror.net.in/epel/5/i386/epel-release-5-4.noarch.rpm
[root@requst-tracker ~]# rpm -Uvh epel-release-5-4.noarch.rpm
[root@requst-tracker ~]# echo "[master]
name=master
enabled=1
gpgcheck=0
baseurl=http://mirror.centos.org/centos/5/os/\$basearch" > /etc/yum.repos.d/centos.repo

8. Now Let’s Install Required Packages

[root@requst-tracker ~]# yum install  rpm* nmap expect vsftpd net-snmp* ntp* subversion subversion-devel mysql mysql-server mysql-devel screen perl-Crypt-PasswdMD5 graphviz php-xml php-cli php-mhash php-ldap php-devel php-pdo php-imap php-readline php-ncurses php-soap php-snmp php-common php-mcrypt php-odbc php-mbstring php-gd php-bcmath php php-xmlrpc php-pear php-mysql php-dba mod_perl-devel mod_auth_mysql mod_perl mod_authz_ldap gd gd-devel gd-progs gcc* --exclude=gcc-java* --exclude=gcc4-java phpmyadmin mod_fcgid perl-GD perl-GnuPG-Interface perl-GraphViz perl-YAML perl cpan httpd

9. Initiate CPAN Shell, Just Keep on pressing enter and leave default values :-

[root@requst-tracker ~]# perl -MCPAN -e shell

9.1 Set cpan to auto-follow dependencies :-

cpan[1]> o conf prerequisites_policy follow
cpan[2]> o conf commit
cpan[3]> quit

10. Setup required start services  and make sure below services are enabled on every boot.

[root@requst-tracker ~]# service mysqld start
[root@requst-tracker ~]# service httpd start
[root@requst-tracker ~]# chkconfig httpd on
[root@requst-tracker ~]# chkconfig mysqld on

11. Setup MySQL Password, as it will ask you during initializing database.

[root@requst-tracker ~]# mysqladmin -u root password 'YOUR-PASSWORD-HERE'

10. Let’s Now Download, Extract and Install Request Tracker from website :-

[root@requst-tracker ~]# useradd rt
[root@requst-tracker ~]# groupadd -g rt rt
For RHEL / CentOS 6.x
[root@requst-tracker ~]# wget http://download.bestpractical.com/pub/rt/release/rt-4.0.19.tar.gz
[root@requst-tracker ~]# tar zxvf rt-4.0.19.tar.gz
[root@requst-tracker ~]# cd rt-4.0.19
[root@requst-tracker rt-4.0.19]# ./configure --with-db-type=mysql --with-db-host=localhost --with-web-user=apache --with-web-group=apache --with-rt-group=rt --prefix=/opt/rt --enable-graphviz --enable-gd --enable-gpg
[root@requst-tracker rt-4.0.19]# make fixdeps
[root@requst-tracker rt-4.0.19]# make testdeps
[root@requst-tracker rt-4.0.19]# make install
=> In below step it will ask you to provide MySQL Password.
[root@requst-tracker rt-4.0.19]# make initialize-database

 

11. Configure request tracker to serve by Apache:-

[root@requst-tracker rt-4.0.19]# vi /etc/httpd/conf.d/requestracker.conf

###### STARTS FROM HERE #####
AddDefaultCharset UTF-8
Alias /rt/NoAuth/images /opt/rt/share/html/NoAuth/images/
ScriptAlias /rt /opt/rt/sbin/rt-server.fcgi/

DocumentRoot “/opt/rt/share/html”
<location /rt>
Order allow,deny
Allow from all
Options +ExecCGI
AddHandler fcgid-script fcgi
</Location>
###### ENDS HERE #####

12. Let’s fix permissions of some file so apache can access it.

[root@requst-tracker ~]# chown apache:apache /opt/rt/etc/RT_SiteConfig.pm
[root@requst-tracker ~]# chown apache:apache /opt/rt/etc/RT_Config.pm

13. Set Webpath for Request Tracker :-

[root@requst-tracker rt-4.0.19]#vi /opt/rt/etc/RT_SiteConfig.pm

Set($WebPath, “/rt”);

13.1 If you want Request Tracker to open on SSL Port Add below line to the same file
Set($WebPort, 443);

14. Restart Apache ( Web Server ) :-

[root@requst-tracker rt-4.0.19]# service httpd restart

15. Now You can open Request Tracker into your browser.
URL :- http://localhost/rt or http://<your-ip>/rt # If you are accessing from Network.
You can access through Default username and password :-
Username :- root

Password :- password

That’s it. Your Request Tracker is ready to use.

Hope this helps you all.

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 Dropbox on Linux 🙂 Enjoy Ubuntu 🙂 Enjoy Linux 🙂 Enjoy Open Source 🙂

Install / Upgrade Firefox 17.x on RHEL / CentOS / 5.x / 32-Bit / 64-Bit / X86_64 / Linux

Hello,

This how will show you the way to Installing / Upgrading  Firefox 17 on RHEL and CentOS 5.x Linux.

In RHEL 5.x and CentOS 5.x there is very Old Firefox version is available, So It is possible that you will not able to use some of the Latest Web based Features from Faebook, Gmail, twitter and LinkedIn.

So To run the Latest Web Based Features, We have to make sure our Firefox version should be Latest and Updated, As of Now there is Firefox 17 is available for the CentOS / RHEL 6.x. We will be Installing / Upgrading the Firefox using YUM.

 

Firefox 17.x on RHEL5
Firefox 17.x on RHEL5

 

Please perform following steps to Install Mozilla Firefox on RHEL / CentOS / 5.x :-

Step 1 :- You need to be Root to Install / Upgrade Firefox 17 on RHEL / CentOS / 5.x :-

Step 2 :- Make sure Internet is Direct or You should be able to use Yum for external Repositories from Command Line.

Step 3 :- Close All Firefox Sessions.

Step 4 :- Execute Following Command to Move Existing Repositories to Another Directory to Avoid Package Conflicts.

[root@linux-support-ahmedabad-tejas-barot ~]# mv /etc/yum.repos.d/*.repo /root

Step 5 :- Download and Configure the Repository for Firefox 17 :-

[root@linux-support-ahmedabad-tejas-barot ~]# wget -c http://www.tejasbarot.com/RPMs/downloads/firefox_tejas_barot.repo
[root@linux-support-ahmedabad-tejas-barot ~]# mv firefox_tejas_barot.repo /etc/yum.repos.d/

Step 6 :- Execute Following Command to Start Installing / Upgrading Firefox 17 on RHEL / CentOS / 5.x 

[root@linux-support-ahmedabad-tejas-barot ~]# yum install -y firefox

Step 7 :- Once Above Process is successfully completed, You will able to use firefox.

Step 8 :- Remove the Firefox Repository and Restore you Previous Repositories.

[root@linux-support-ahmedabad-tejas-barot ~]# rm -rf /etc/yum.repost.d/firefox_tejas_barot.repo
[root@linux-support-ahmedabad-tejas-barot ~]# mv /root/*.repo /etc/yum.repos.d/

That’s IT.

Hope this will helps you all, If you face any issue regarding the same or its not working for your 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 Mozilla Firefox 🙂 Enjoy Browsing 🙂 :)  Enjoy Linux :) Enjoy Open Source

Download and Install imapsync rpm / v1.525 / RHEL / CentOS / 5.x / 6.x | 32-Bit | x86_64 ( 64-Bit)

Hello,

As we already know that Imapsync is very useful and famous Utility and New Version of imapsync 1.525 is now available in Source Packages. (tar.gz, tgz, zip).

FYI :- I have created RPMs and made it available before EPEL and Now It is also Available with EPEL Testing Repository.

Using those source files i have created RPM for RHEL /CentOS / 5.x / 6.x for 32-bit and x86_64 bit architecture.

You can download theses RPMs using following link and You can start Using these RPMs.

I am really Happy to create and make these RPMs available for you guys.

If you found any issue with RPM or it is not working as expected you can please report your issues to http://linuxforums.tejasbarot.com

Download Imapsync version 1.525 RPM for RHEL 5 32-Bit / x86_64 ( 64-Bit ) Version :- http://www.tejasbarot.com/RPMs/imapsync-1.525-1.noarch.rpm

Download Imapsync version 1.525 RPM for RHEL 6 32-Bit / x86_64 ( 64-Bit ) Version :- http://www.tejasbarot.com/RPMs/imapsync-1.525-1.el6.noarch.rpm

I hope this will helps you all and This is the latest version of Imapsync which i have compiled. I will try to upload every new version which is available. Keep Visiting Blog.

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

If Any Errors in this How to then comment down below.

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

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

Enjoy IMAPSYNc on RHEL / CentOS :) Enjoy Linux :) Enjoy Open Source :)

Howto: Installing WINE on RHEL / CentOS 5.x / 6.x | 32-bit | 64-bit | x86_64 | Linux

Hello All,

There are so many request from blog visitors to write Article on Wine Installation. Thanks for your request.

This article is for Install Wine on CentOS and RHEL 5.x and 6.x easily. Actually i have planned this article through script but due to shortage of time and now a days busy too, So Couldn’t implement complete script so Demonstrating manual how to over here.

I hope you guys will like the same.

Like VLC installation on Red Hat Enterprise Linux 5.x and 6.x and CentOS 5.x and 6.x its bit complicated and So much dependencies issues are there. So To make installation a bit easier and without too much headache i am writing this article.

This HOWTO performed on Blank RHEL / CentOS 5.x and 6.x if you are running with Latest or OLD RPMs you might face issue of Dependencies. Do it at your own risk wherever you are performing this howto.

To Install WINE on RHEL/CentOS 5.x and 6.x, Perform following Howto.

For RHEL / CentOS 6 32-Bit and 64-Bit (x86_64) :-

1. You need to be root to perform rest steps.

2. This step is must otherwise you might face dependencies issues. Now Lets take a backup of your Original Repository. By Executing Following Command :-
[root@wine-on-linux-ahmedabad-tejas-barot ~]# mkdir /repobackup
[root@wine-on-linux-ahmedabad-tejas-barot ~]#mv /etc/yum.repos.d/*.repo /repobackup/

3. Now Clean Previously Cached Repository by Executing Following command :-
[root@wine-on-linux-ahmedabad-tejas-barot ~]# yum clean all

4. Now Download and Install EPEL and Tejas Barot’s RPM for Wine to Install Wine on RHEL / CentOS 6.x.

To Download RPMs :-
[root@wine-on-linux-ahmedabad-tejas-barot ~]# cd /tmp
[root@wine-on-linux-ahmedabad-tejas-barot tmp]# wget http://www.tejasbarot.com/RPMs/epel-release-6-7.noarch.rpm
[root@wine-on-linux-ahmedabad-tejas-barot tmp]# wget http://www.tejasbarot.com/RPMs/wine-install-tejas-barot-2.0-2.noarch.rpm

To Install RPMs :-

[root@wine-on-linux-ahmedabad-tejas-barot tmp]# rpm -ivh –force epel-release-6-7.noarch.rpm
[root@wine-on-linux-ahmedabad-tejas-barot tmp]# rpm -ivh –force wine-install-tejas-barot-2.0-2.noarch.rpm
[root@wine-on-linux-ahmedabad-tejas-barot tmp]# cd

5. To install wine and its Packages execute following command :-

[root@wine-on-linux-ahmedabad-tejas-barot ~]# yum install –nogpgcheck wine*

When it ask for”YES”and”NO”Please go ahead with your choice.

6. That’s it, You are done now. Wine Installed Successfully.

7. Now Revert your previous repositories. by Following commands
[root@wine-on-linux-ahmedabad-tejas-barot ~]# rm -rf /etc/yum.repos.d/*.repo
[root@wine-on-linux-ahmedabad-tejas-barot ~]# mv /repobackup/*.repo /etc/yum.repos.d/

8. That’s It now. You have installed wine on RHEL / CentOS 6x Successfully and Your Previous Repositories also reverted back.

For RHEL / CentOS 5.x 32-Bit and 64-Bit (x86_64) :-

1. You need to be root to perform rest steps.

2. This step is must otherwise you might face dependencies issues. Now Lets take a backup of your Original Repository. By Executing Following Command :-
[root@wine-on-linux-ahmedabad-tejas-barot ~]# mkdir /repobackup
[root@wine-on-linux-ahmedabad-tejas-barot ~]#mv /etc/yum.repos.d/*.repo /repobackup/

3. Now Clean Previously Cached Repository by Executing Following command :-
[root@wine-on-linux-ahmedabad-tejas-barot ~]# yum clean all

4. Now Download and Install EPEL and Tejas Barot’s RPM for Wine to Install Wine on RHEL / CentOS 5.x.

To Download RPMs :-
[root@wine-on-linux-ahmedabad-tejas-barot ~]# cd /tmp
[root@wine-on-linux-ahmedabad-tejas-barot tmp]# wget http://www.tejasbarot.com/RPMs/epel-release-5-4.noarch.rpm
[root@wine-on-linux-ahmedabad-tejas-barot tmp]#wget http://www.tejasbarot.com/RPMs/wine-install-tejas-barot-1.0-1.noarch.rpm

To Install RPMs :-

[root@wine-on-linux-ahmedabad-tejas-barot tmp]# rpm -ivh –force epel-release-5-4.noarch.rpm
[root@wine-on-linux-ahmedabad-tejas-barot tmp]# rpm -ivh –force wine-install-tejas-barot-1.0-1.noarch.rpm
[root@wine-on-linux-ahmedabad-tejas-barot tmp]# cd

5. To install wine and its Packages execute following command :-

[root@wine-on-linux-ahmedabad-tejas-barot ~]# yum install –nogpgcheck wine*

When it ask for”YES”and”NO”Please go ahead with your choice.

6. That’s it, You are done now. Wine Installed Successfully.

7. Now Revert your previous repositories. by Following commands
[root@wine-on-linux-ahmedabad-tejas-barot ~]# rm -rf /etc/yum.repos.d/*.repo
[root@wine-on-linux-ahmedabad-tejas-barot ~]# mv /repobackup/*.repo /etc/yum.repos.d/

8. That’s It now. You have installed wine on RHEL / CentOS 5.x Successfully and Your Previous Repositories also reverted back.

Hope this will helps you, Waiting for your feedback.

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/

Enjoy Wine on Red Hat Enterprise Linux and CentOS 5.x and 6.x 🙂 Enjoy Linux 🙂 Enjoy Open Source 🙂

Howto: Installing VLC Media Player / RHEL 5.x / CentOS 5.x / Linux / Script

Hello Friends,

Today I am sharing one more how to for those who is fresher or experience but unable to Install VLC Player on Red Hat Enterprise Linux 5.x. By Performing this howto you will able to install VLC Player in Just 6 Steps.

Following things must exist on your Computer/Linux :-

=> Direct Working Internet Connection or Yum Should run from Terminal. If you are using Internet connection with Proxy then it will be problematic for you.

=> RHEL 5.x must be installed

What is VLC Player ?

=> VLC media player is an open source, free software media player and multimedia framework written by the VideoLAN project.

There are so many peoples who is facing issue while installing VLC Player on Linux and CentOS, Most of the peoples suffer with dependencies problem if they are going to install VLC Player using RPM or YUM.

But Now you will find a very easy way to install VLC Player, I have created Bash Script to Install VLC Player with all Dependencies, So Forget about all problems Just Download and Run Bash Script which I have created for VLC Player Installation on RHEL 5.

Note :- This script is tested in Local Environment, Think many times before you execute on Production/Local/Anywhere, Do it at your OWN RISK.

Perform Following Steps to Install VLC Player on RHEL 5.x / Cent OS 5.x

1. You need to be root to run this script.

2. Download this VLC INSTALLATION SCRIPT.

3. Execute following Command where you have downloaded the script.
[root@tejasbarot ~]# chmod +x vlc-installation.sh

4. Now Execute your script by two ways mentioned below

[root@tejasbarot ~]# sh vlc-installation.sh
OR
[root@tejasbarot ~]# ./vlc-installation.sh

5. Now Just Site Back and Relax for Few Minutes as per your Internet Connection it will Install VLC Player Without any error.

6. Remember you have to be normal user to run VLC Player, You cannot Run VLC Player as root.

Hope you ENJOY THIS………

If this works for you then Show your support and encourage me to write some more howto’s by commenting on the same topic or by sending me mail on blog(at)tejasbarot(dot)com

If this doesn’t work for you then also please do let me know so i can helps you out to solve the issue, If you are facing the error then please send me mail on blog(at)tejasbarot(dot)com with Subject:- VLC Installation Issue

Enjoy Ubuntu 11.10 Oneiric Ocelot :) Enjoy Ubuntu  :) Enjoy Open Source :) Enjoy Linux :)

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

Enjoy VLC on Linux 🙂 Enjoy Linux 🙂 Enjoy Open Source 🙂 Enjoy Players on Linux.