Thursday, 23 July 2015

Auto Filling the Column

1. Shortcut for moving between excel sheets

CRTL + pgup or pgDn

2. Shortcut Auto numbering in column

Select column from starting cell having starting number with
Shift + Down arrow
press Ctrl + D
then Alt + E+I+S

Wednesday, 15 July 2015

FTP server

Here we download data from FTP link

1. Make sure yum server is working on your RHEL machine
2. install vsftpd, ftp pakages

yum install vsftpd  or
#rpm -ivh  rpm -ivh vsftpd-2.2.2-11.el6_4.1.x86_64.rpm


yum install ftp or
#rpm -ivh ftp-0.17-54.el6.x86_64.rpm

3. make firewall off
#iptables -F

4. make enforcing permissible

# getenforce
[root@localhost packages]# getenforce
Enforcing

the  setenforce 0

it is temporary solution to make enforcing permanently off do the changes under Selinux policy

5. service vsftpd restart

#service vsftpd status

to make service on permanently
#chkconfig vsftpd on

6. #getsebool -a | grep ftp
     #setsebool -ftp_home_dir 1

#service vsftpd restart
#service ftp restart

to check working of ftp


[root@localhost ~]# ftp 198.182.52.51
Connected to 198.182.52.51 (198.182.52.51).
220-
  
230 Anonymous access granted, restrictions apply
Remote system type is UNIX.
Using binary mode to transfer files.
ftp> binary
200 Type set to I
ftp> cd /pub/outgoing
250 CWD command successful
ftp> get CDC2015.tar.gz
local: CDC2015.tar.gz remote: CDC2015.tar.gz
227 Entering Passive Mode (198,182,52,51,143,50).
150 Opening BINARY mode data connection for CDC2015.tar.gz (51047711 bytes)
226 Transfer complete
51047711 bytes received in 92.6 secs (551.33 Kbytes/sec)
ftp> quit
221 Goodbye.





 

Saturday, 11 July 2015

Solution for: error while loading shared libraries: libexpat.so.0: cannot open shared object file: No such file or directory

First of all yum server should be properly installed and working:

for installation of of "libexpat.so.0" you can go for

# yum install libexpat.so.0
 this will install "libexpat" for 32 bit OS

for the installation in 64 bit os

# yum install compat-expat1

Package compat-expat1-1.95.8-8.el6.x86_64 already installed





to check version of redhat OS
#uname -a  or
#uname -r

Solution of :: error while loading shared libraries: libtermcap.so.2: cannot open shared object file: No such file or directory

here target package is libtermcap.so.2
 so commands are:
1. # rpm -qf /lib/libtermcap.so.2   -->> this will produce following result on terminal


compat-libtermcap-2.0.8-49.el6.i686

2.#  rpm -qa | grep  compat-libtermcap  --->> this will produce the following results on terminal

compat-libtermcap-2.0.8-49.el6.i686


from i686 it is clear that  this package is for 32bit OS

3. # find /lib -name libtermcap.so.2

TO INSTALL its 64bit version ::
first of all yum server should be properly working if it is working then use the following command for installation of libtermcap.so.2:::
# yum install compat-libtermcap

(
In Red Hat 6 the library name has changed to compat-libtermcap. If you try to install just libtermcap via Yum it will fail saying "No package libtermcap available." If you try to install libertermcap.so.2 (based on the error message) via Yum it will only install the 32-bit library by default "compat-libtermcap-2.0.8-49.el6.i686"

But, because we are using the 64-bit installer, we need the 64-bit compat-libtermcap library installed. The command to install compat-libtermcap on Red Hat 6 is "yum install compat-libtermcap" This will install the correct library you need "compat-libtermcap-2.0.8-49.el6.x86_64"
)