I-Learnings

ORA-12519, TNS:no appropriate service handler found

2018-01-15T15:59:00.000+08:00

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found

SQL> set lines 200

SQL> select * from v$resource_limit where resource_name = 'processes';

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE CON_ID

------------------------------ ------------------- --------------- ---------------------------------------- ---------------------------------------- ----------

processes 988 1000 1000 1000 0

SQL> select count(1) FROM v$session;

COUNT(1)

----------

969

SQL> select status,count(1) FROM v$session group by status;

STATUS COUNT(1)

-------- ----------

ACTIVE 46

INACTIVE 923

We have seen lots if INACTIVE sessions which we need to kill. After killing sessions that were INACTIVE for a very long time. We don't see the errors anymore after re-executing the deployment.

SQL> select status,count(1) FROM v$session group by status;

STATUS COUNT(1)

-------- ----------

ACTIVE 46

INACTIVE 310

SQL> select count(1) FROM v$session;

COUNT(1)

----------

356

SQL>

Vagrant was unable to mount VirtualBox shared folders

2018-01-15T14:27:00.003+08:00

I got this error below while starting vagrant. I am dependent on using CLI in my work so i need to find a solution.

C:\>vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Checking if box 'bento/centos-7.3' is up to date...
==> default: Clearing any previously set forwarded ports...
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
default: Adapter 1: nat
==> default: Forwarding ports...
default: 22 (guest) => 2222 (host) (adapter 1)
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
default: SSH address: 127.0.0.1:2222
default: SSH username: vagrant
default: SSH auth method: private key
default: Warning: Connection reset. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Connection reset. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Connection reset. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Connection reset. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Connection reset. Retrying...
default: Warning: Remote connection disconnect. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Connection reset. Retrying...
==> default: Machine booted and ready!
==> default: Checking for guest additions in VM...
default: No guest additions were detected on the base box for this VM! Gues

default: additions are required for forwarded ports, shared folders, host o
ly
default: networking, and more. If SSH fails on this machine, please install
default: the guest additions and repackage the box to continue.
default:
default: This is not an error message; everything may continue to work prop
rly,
default: in which case you may ignore this message.
==> default: Mounting shared folders...
default: /vagrant => C:/
Vagrant was unable to mount VirtualBox shared folders. This is usually
because the filesystem "vboxsf" is not available. This filesystem is
made available via the VirtualBox Guest Additions and kernel module.
Please verify that these guest additions are properly installed in the
guest. This is not a bug in Vagrant and is usually caused by a faulty
Vagrant box. For context, the command attempted was:

mount -t vboxsf -o uid=1000,gid=1000 vagrant /vagrant

The error output from the command was:

/sbin/mount.vboxsf: mounting failed with the error: No such device

Found some discussions in the stackoverflow. And i tried 1 solution below.

C:\>vagrant plugin install vagrant-vbguest
Installing the 'vagrant-vbguest' plugin. This can take a few minutes...
Fetching: vagrant-share-1.1.9.gem (100%)
Fetching: micromachine-2.0.0.gem (100%)
Fetching: vagrant-vbguest-0.15.1.gem (100%)
Installed the plugin 'vagrant-vbguest (0.15.1)'!

I tried to reinstall it again since i forgot to shut it down first before i install the vagrant-vbgust plugin.

C:\>vagrant halt
==> default: Attempting graceful shutdown of VM...

Since i was already installed in the first run it does not do anything.

C:\>vagrant plugin install vagrant-vbguest
Installing the 'vagrant-vbguest' plugin. This can take a few minutes...
Installed the plugin 'vagrant-vbguest (0.15.1)'!

Then i started the vagrant. After starting it the vagrant reinstalled some libraries.

C:\>vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Checking if box 'bento/centos-7.3' is up to date...
==> default: Clearing any previously set forwarded ports...
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
default: Adapter 1: nat
==> default: Forwarding ports...
default: 22 (guest) => 2222 (host) (adapter 1)
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
default: SSH address: 127.0.0.1:2222
default: SSH username: vagrant
default: SSH auth method: private key
default: Warning: Connection reset. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Connection reset. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Connection reset. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Remote connection disconnect. Retrying...
default: Warning: Connection reset. Retrying...
default: Warning: Connection aborted. Retrying...
default: Warning: Connection reset. Retrying...
==> default: Machine booted and ready!
[default] No installation found.
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.tsukuba.wide.ad.jp
* extras: ftp.tsukuba.wide.ad.jp
* updates: ftp.tsukuba.wide.ad.jp
Package binutils-2.25.1-32.base.el7_4.1.x86_64 already installed and latest vers
ion
Package 1:make-3.82-23.el7.x86_64 already installed and latest version
Package 4:perl-5.16.3-292.el7.x86_64 already installed and latest version
Package bzip2-1.0.6-13.el7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package gcc.x86_64 0:4.8.5-16.el7_4.1 will be installed
--> Processing Dependency: cpp = 4.8.5-16.el7_4.1 for package: gcc-4.8.5-16.el7_
4.1.x86_64
--> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc-4.8.5-16.el
7_4.1.x86_64
---> Package kernel-devel.x86_64 0:3.10.0-693.11.6.el7 will be installed
--> Running transaction check
---> Package cpp.x86_64 0:4.8.5-16.el7_4.1 will be installed
---> Package glibc-devel.x86_64 0:2.17-196.el7_4.2 will be installed
--> Processing Dependency: glibc-headers = 2.17-196.el7_4.2 for package: glibc-d
evel-2.17-196.el7_4.2.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-196.el7_4
.2.x86_64
--> Running transaction check
---> Package glibc-headers.x86_64 0:2.17-196.el7_4.2 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.
17-196.el7_4.2.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-196.el
7_4.2.x86_64
--> Running transaction check
---> Package kernel-headers.x86_64 0:3.10.0-693.11.6.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
gcc x86_64 4.8.5-16.el7_4.1 updates 16 M
kernel-devel x86_64 3.10.0-693.11.6.el7 updates 14 M
Installing for dependencies:
cpp x86_64 4.8.5-16.el7_4.1 updates 5.9 M
glibc-devel x86_64 2.17-196.el7_4.2 updates 1.1 M
glibc-headers x86_64 2.17-196.el7_4.2 updates 676 k
kernel-headers x86_64 3.10.0-693.11.6.el7 updates 6.0 M
Transaction Summary
================================================================================
Install 2 Packages (+4 Dependent packages)
Total download size: 44 M
Installed size: 95 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
--------------------------------------------------------------------------------
Total 2.8 MB/s | 44 MB 00:15
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : kernel-headers-3.10.0-693.11.6.el7.x86_64 1/6
Installing : glibc-headers-2.17-196.el7_4.2.x86_64 2/6
Installing : glibc-devel-2.17-196.el7_4.2.x86_64 3/6
Installing : cpp-4.8.5-16.el7_4.1.x86_64 4/6
Installing : gcc-4.8.5-16.el7_4.1.x86_64 5/6
Installing : kernel-devel-3.10.0-693.11.6.el7.x86_64 6/6
Verifying : cpp-4.8.5-16.el7_4.1.x86_64 1/6
Verifying : glibc-devel-2.17-196.el7_4.2.x86_64 2/6
Verifying : kernel-devel-3.10.0-693.11.6.el7.x86_64 3/6
Verifying : glibc-headers-2.17-196.el7_4.2.x86_64 4/6
Verifying : gcc-4.8.5-16.el7_4.1.x86_64 5/6
Verifying : kernel-headers-3.10.0-693.11.6.el7.x86_64 6/6

Installed:
gcc.x86_64 0:4.8.5-16.el7_4.1 kernel-devel.x86_64 0:3.10.0-693.11.6.el7
Dependency Installed:
cpp.x86_64 0:4.8.5-16.el7_4.1
glibc-devel.x86_64 0:2.17-196.el7_4.2
glibc-headers.x86_64 0:2.17-196.el7_4.2
kernel-headers.x86_64 0:3.10.0-693.11.6.el7

Complete!
Copy iso file C:\Program Files\Oracle\VirtualBox\VBoxGuestAdditions.iso into the
box /tmp/VBoxGuestAdditions.iso
Mounting Virtualbox Guest Additions ISO to: /mnt
mount: /dev/loop0 is write-protected, mounting read-only
Installing Virtualbox Guest Additions 5.1.28 - guest version is unknown
Verifying archive integrity... All good.
Uncompressing VirtualBox 5.1.28 Guest Additions for Linux...........
VirtualBox Guest Additions installer
Removing installed version 5.1.26 of VirtualBox Guest Additions...
Copying additional installer modules ...
Installing additional modules ...
vboxadd.sh: Starting the VirtualBox Guest Additions.
Could not find the X.Org or XFree86 Window System, skipping.
Redirecting to /bin/systemctl start vboxadd.service
Redirecting to /bin/systemctl start vboxadd-service.service
Unmounting Virtualbox Guest Additions ISO from: /mnt
==> default: Checking for guest additions in VM...
==> default: Mounting shared folders...
default: /vagrant => C:/
==> default: Machine already provisioned. Run `vagrant provision` or use the `--
provision`
==> default: flag to force provisioning. Provisioners marked to run always will
still run.

After everything was done tried to access vagrant via PUTTY and now the my local drive is now accessible via vagrant. How cool is that!!!!!

Just another issue while browsing my local directory via vagrant. I throws an error while browsing some Windows default directory. I am not sure why but the important thing is i am able to access my Work directory.

[root@localhost vagrant]# ls -ltr

ls: cannot read symbolic link Documents and Settings: Protocol error

total 14211895

-rwxrwxrwx. 1 vagrant vagrant 5686 Nov 7 2007 vcredist.bmp

Innotop on Centos 6.5 MySQL version 5.5.34

2014-02-14T17:08:00.001+08:00

innotop - MySQL and InnoDB transaction/status monitor.

INSTALLATION

wget https://innotop.googlecode.com/files/innotop-1.9.1-1.el6.noarch.rpm
rpm -ivh innotop-1.9.1-1.el6.noarch.rpm

Posible errros:

error: Failed dependencies:
perl(Term::ReadKey) is needed by innotop-1.9.1-1.el6.noarch
perl(Time::HiRes) is needed by innotop-1.9.1-1.el6.noarch
perl-TermReadKey is needed by innotop-1.9.1-1.el6.noarch
perl-Time-HiRes is needed by innotop-1.9.1-1.el6.noarch

more info about innotop: http://innotop.googlecode.com/svn/html/manual.html

[root@mercury tmp]# yum install perl-TermReadKey
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: centos.mirrors.hoobly.com
* extras: mirrors.xmission.com
* updates: centos.eecs.wsu.edu
* webtatic: us-east.repo.webtatic.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-TermReadKey.x86_64 0:2.30-13.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================
Installing:
perl-TermReadKey x86_64 2.30-13.el6 base 31 k

Transaction Summary
==============================================================================================================================================
Install 1 Package(s)

Total download size: 31 k
Installed size: 62 k
Is this ok [y/N]: y
Downloading Packages:
perl-TermReadKey-2.30-13.el6.x86_64.rpm | 31 kB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-TermReadKey-2.30-13.el6.x86_64 1/1
Verifying : perl-TermReadKey-2.30-13.el6.x86_64 1/1

Installed:
perl-TermReadKey.x86_64 0:2.30-13.el6

Complete!
[root@mercury tmp]# yum install perl-Time-HiRes
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: centos.mirrors.hoobly.com
* extras: mirrors.xmission.com
* updates: centos.eecs.wsu.edu
* webtatic: us-east.repo.webtatic.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-Time-HiRes.x86_64 4:1.9721-136.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================
Installing:
perl-Time-HiRes x86_64 4:1.9721-136.el6 base 48 k

Transaction Summary
==============================================================================================================================================
Install 1 Package(s)

Total download size: 48 k
Installed size: 56 k
Is this ok [y/N]: y
Downloading Packages:
perl-Time-HiRes-1.9721-136.el6.x86_64.rpm | 48 kB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : 4:perl-Time-HiRes-1.9721-136.el6.x86_64 1/1
Verifying : 4:perl-Time-HiRes-1.9721-136.el6.x86_64 1/1

Installed:
perl-Time-HiRes.x86_64 4:1.9721-136.el6

Complete!

[root@mercury tmp]# rpm -ivh innotop-1.9.1-1.el6.noarch.rpm
Preparing... ########################################### [100%]
1:innotop ########################################### [100%]

Mytop on Centos 6.5 Mysql Version : 5.5.34

2014-02-14T16:04:00.003+08:00

Mytop

mytop is a console-based (non-gui) tool for monitoring the threads
and overall performance of a MySQL server.
It runs on most Unix systems which have Perl,
DBI, and Term::ReadKey installed. And with Term::ANSIColor installed
you even get color.

If you install Time::HiRes, you’ll get good real-time queries/second stats.

As of version 0.7, it even run

INSTALLATIONS

Download Package: http://jeremy.zawodny.com/mysql/mytop/
tar -zxvf mytop-.tar.gz
cd mytop-
perl Makefile.PL
make
make install

Possible Errors during installation:

Warning: prerequisite DBD::mysql 1 not found.

Warning: prerequisite DBI 1.13 not found.

Warning: prerequisite Term::ReadKey 2.1 not found.

Solution:

perl-Class-Data-Inheritable-0.08-1.el5.rf.noarch.rpm

perl-DBD-MySQL-4.014-1.el5.rfx.x86_64.rpm

perl-DBI-1.616-1.el5.rfx.x86_64.rpm

perl-DBIx-ContextualFetch-1.03-1.el5.rf.noarch.rpm

perl-Ima-DBI-0.35-1.el5.noarch.rpm

perl-Ima-DBI-0.35-1.el5.src.rpm

perl-TermReadKey-2.30-4.el5.

Error after a successful installation:

Use of uninitialized value $host in substitution (s///) at /usr/local/bin/mytop line 958.

Solution:

Remove this line

$host =~ s/^([^.]+).*/$1/;

$thread->{Host} = $host;

Replace with this

if ($host)

{

$host =~ s/^([^.]+).*/$1/;

$thread->{Host} = $host;

}

Error in option spec: "long|!"

Solution:

The fix for this is to edit the mytop script and comment out the line containing long|!

vi /usr/local/bin/mytop

Run a search for long|! and comment out the following line:

"long|!" => \$config{long_nums},

Start mytop and you should be fine.

Sources:

http://www.eth0.us/node/204

http://www.ashishnepal.com/mytop-centos-5-6-mysql-version-5-5-16/

MySQL 5.5 Installation on Centos/RHEL 6.5 via Yum

2014-02-13T12:52:00.001+08:00

I've been using RPM every time i will install MySQL server in my Linux boxes. But today i will show you on how to install MySQL 5.5 on Centos 6.5 via Yum.

First, to set up the yum repository, install the webtatic-release RPM based on your CentOS/RHEL release.

[root@localhost ~]# rpm -Uvh http://mirror.webtatic.com/yum/el6/latest.rpm
Retrieving http://mirror.webtatic.com/yum/el6/latest.rpm
warning: /var/tmp/rpm-tmp.q3Y9pR: Header V4 DSA/SHA1 Signature, key ID cf4c4ff9: NOKEY
Preparing... ########################################### [100%]

1:webtatic-release ########################################### [100%]

Remove the pre-installed mysql-libs with no dependecy.

[root@localhost ~]# rpm -e mysql-libs

error: Failed dependencies:

libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64

libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64

mysql-libs is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64

[root@localhost ~]# rpm -e --nodeps mysql-libs

After removing the previous version of mysql-libs you can now start the installation of MYSQL via Yum

[root@localhost ~]# yum install mysql55 mysql55-server

Loaded plugins: fastestmirror, refresh-packagekit, security

Loading mirror speeds from cached hostfile

 * base: centos.corenetworks.net

 * extras: centos.mirror.freedomvoice.com

 * updates: mirrors.usinternet.com

 * webtatic: sp.repo.webtatic.com

Setting up Install Process

Resolving Dependencies

--> Running transaction check

---> Package mysql55.x86_64 0:5.5.34-1.w6 will be installed

--> Processing Dependency: mysql55-libs = 5.5.34-1.w6 for package: mysql55-5.5.34-1.w6.x86_64

---> Package mysql55-server.x86_64 0:5.5.34-1.w6 will be installed

--> Processing Dependency: perl-DBI for package: mysql55-server-5.5.34-1.w6.x86_64

--> Processing Dependency: perl-DBD-MySQL for package: mysql55-server-5.5.34-1.w6.x86_64

--> Processing Dependency: perl(DBI) for package: mysql55-server-5.5.34-1.w6.x86_64

--> Running transaction check

---> Package mysql55-libs.x86_64 0:5.5.34-1.w6 will be installed

--> Processing Dependency: libmysqlclient16 for package: mysql55-libs-5.5.34-1.w6.x86_64

---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed

---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed

--> Running transaction check

---> Package libmysqlclient16.x86_64 0:5.1.69-1.w6 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================================

 Package                                 Arch                          Version                              Repository                       Size

==================================================================================================================================================

Installing:

 mysql55                                 x86_64                        5.5.34-1.w6                          webtatic                        5.5 M

 mysql55-server                          x86_64                        5.5.34-1.w6                          webtatic                         10 M

Installing for dependencies:

 libmysqlclient16                        x86_64                        5.1.69-1.w6                          webtatic                        1.0 M

 mysql55-libs                            x86_64                        5.5.34-1.w6                          webtatic                        778 k

 perl-DBD-MySQL                          x86_64                        4.013-3.el6                          base                            134 k

 perl-DBI                                x86_64                        1.609-4.el6                          base                            705 k

Transaction Summary

==================================================================================================================================================

Install       6 Package(s)

Total download size: 18 M

Installed size: 82 M

Is this ok [y/N]: y

Downloading Packages:

(1/6): libmysqlclient16-5.1.69-1.w6.x86_64.rpm                                                                             | 1.0 MB     00:06

(2/6): mysql55-5.5.34-1.w6.x86_64.rpm                                                                                      | 5.5 MB     00:45

(3/6): mysql55-libs-5.5.34-1.w6.x86_64.rpm                                                                                 | 778 kB     00:05

(4/6): mysql55-server-5.5.34-1.w6.x86_64.rpm                                                                               |  10 MB     01:13

(5/6): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm                                                                               | 134 kB     00:02

(6/6): perl-DBI-1.609-4.el6.x86_64.rpm                                                                                     | 705 kB     00:06

--------------------------------------------------------------------------------------------------------------------------------------------------

Total                                                                                                             130 kB/s |  18 MB     02:22

warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cf4c4ff9: NOKEY

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-webtatic-andy

Importing GPG key 0xCF4C4FF9:

 Userid : Andy Thompson 

 Package: webtatic-release-6-4.noarch (installed)

 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-webtatic-andy

Is this ok [y/N]: y

warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

Importing GPG key 0xC105B9DE:

 Userid : CentOS-6 Key (CentOS 6 Official Signing Key) 

 Package: centos-release-6-5.el6.centos.11.1.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)

 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

Is this ok [y/N]: y

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

  Installing : perl-DBI-1.609-4.el6.x86_64                                                                                                    1/6

  Installing : libmysqlclient16-5.1.69-1.w6.x86_64                                                                                            2/6

  Installing : mysql55-libs-5.5.34-1.w6.x86_64                                                                                                3/6

  Installing : mysql55-5.5.34-1.w6.x86_64                                                                                                     4/6

  Installing : perl-DBD-MySQL-4.013-3.el6.x86_64                                                                                              5/6

  Installing : mysql55-server-5.5.34-1.w6.x86_64                                                                                              6/6

  Verifying  : libmysqlclient16-5.1.69-1.w6.x86_64                                                                                            1/6

  Verifying  : perl-DBD-MySQL-4.013-3.el6.x86_64                                                                                              2/6

  Verifying  : mysql55-libs-5.5.34-1.w6.x86_64                                                                                                3/6

  Verifying  : perl-DBI-1.609-4.el6.x86_64                                                                                                    4/6

  Verifying  : mysql55-5.5.34-1.w6.x86_64                                                                                                     5/6

  Verifying  : mysql55-server-5.5.34-1.w6.x86_64                                                                                              6/6

Installed:

  mysql55.x86_64 0:5.5.34-1.w6                                         mysql55-server.x86_64 0:5.5.34-1.w6

Dependency Installed:

  libmysqlclient16.x86_64 0:5.1.69-1.w6  mysql55-libs.x86_64 0:5.5.34-1.w6  perl-DBD-MySQL.x86_64 0:4.013-3.el6  perl-DBI.x86_64 0:1.609-4.el6

Complete!

After installing, the commands needed to activate it to run at system startup depend on your operating system. On Linux, you can use chkconfig:

[root@localhost ~]# chkconfig --add mysqld

On some Linux systems, the following command also seems to be necessary to fully enable the mysql script:

[root@localhost ~]# chkconfig --level 345 mysqld on

You can now start MySQL as a service.

[root@localhost bin]# service mysqld start
Starting mysqld: [ OK ]
[root@localhost bin]# ps ax | grep mysql
26597 pts/2 S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
26804 pts/2 Sl 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
26836 pts/2 S+ 0:00 grep mysql
[root@localhost bin]#

Source: http://webtatic.com/packages/mysql55/

MySQL: Localhost vs 127.0.0.1

2012-12-11T10:14:00.004+08:00

Yesterday i was trying to connect to MySQL localhost with another port aside from 3306:

mysql -uroot -p -h localhost --port=3390

to my suprise i was login to the default port. My collegue told me that i need to used 127.0.0.1 instead of localhost so i tried it then i search everywhere to find the answer on why oh why its like this until i found a blog that explained the difference between localhost and 127.0.0.1.

source: http://blogs.sakienvirotech.com/index.php/random/2011/08/30/mysql-101-connecting-to-a

With network connections, there are two special addresses that always refer to the machine you are currently using. This is either called 'localhost' or has the IP address of 127.0.0.1. In general using these is equivalent and interchangeable, and uses a special path through the networking subsystem called the local loopback interface. However MySQL has reserved 'localhost' for the special purpose of indicating the use of a UNIX socket and not use networking. This can cause some confusion to new users, but if you understand what is going on it is pretty clear.

'localhost' in MySQL uses the UNIX socket and ignores any port you may supply.

127.0.0.1 in MySQL uses networking and requires a port, using the default if you don't supply it.

ERROR 1018 (HY000): Can't read dir of '.' (errno: 24)

2012-11-20T14:22:00.006+08:00

We encountered an error in MySQl below:

ERROR 1018 (HY000): Can't read dir of '.' (errno: 24)

Upon searching for some solutions at google we found out that the error means 'Too many open files'. Everything you do in linux is a file (or rather a file descriptor). Every mysql connection, every apache connection etc.

To see how many files a user has open try this

sudo lsof -u mysql

edit the file in /etc/security/limits.conf and add these two mysql lines in at the bottom



#@student        -       maxlogins       4
mysql   soft    nofile  4096
mysql   hard    nofile  8192
# End of file









There is some debate as to whether you need to reboot for this to 
take effect (i say debate, i rebooted, and didnt google for it as i was 
in a rush ymmv).


Once this is set you need to make some changes in the mysql file as 
well.  Assuming yours lives in /etc/mysql/my.cnf - edit or add these 
values





open-files-limit = 2048
table_cache            = 512



The table_cache should be researched (start here: http://dev.mysql.com/doc/refman/5.0/en/table-cache.html) and changes monitored.  The default value is 64, so 512 should be a safe bet to begin with.

MySQL anonymous user login

2012-08-02T17:42:00.001+08:00

After a fresh install of mysql at our linux box server. I was able to login to mysql with any user which we didn't defined.
[root@spica ~]# mysql -utest

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

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> quit
Bye

To fix you need to delete the blank user at the mysql.user tables.

[root@spica ~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 14

Server version: 5.1.61 Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

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

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| test |

+--------------------+

3 rows in set (0.00 sec)

mysql> select user,host from mysql.user;

+------+------------+

| user | host |

+------+------------+

| root | 127.0.0.1 |

| | localhost |

| root | localhost |

| | meitnerium |

| root | meitnerium |

+------+------------+

5 rows in set (0.00 sec)

mysql> delete from mysql.user where user='';

Query OK, 2 rows affected (0.00 sec)

mysql> select user,host from mysql.user;

+------+------------+

| user | host |

+------+------------+

| root | 127.0.0.1 |

| root | localhost |

| root | meitnerium |

+------+------------+

3 rows in set (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> quit

Bye

[root@spica ~]# mysql -utest

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

[root@spica ~]#

crontab: command not found

2012-08-01T18:10:00.002+08:00

Upon issuing crontab command got an error below

[root@shizune installer]# crontab -e
-bash: crontab: command not found

To Fix install crontabs package.

[root@shizune installer]# yum --enablerepo=remi install crontabs
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: ossm.utm.my
* extras: ossm.utm.my
* remi: remi-mirror.dedipower.com
* updates: centosk3.centos.org
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be installed
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-7.el6 will be installed
--> Processing Dependency: dailyjobs for package: cronie-1.4.4-7.el6.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-7.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================================================
Package Arch Version Repository Size
==================================================================================================================================================================
Installing:
crontabs noarch 1.10-33.el6 base 10 k
Installing for dependencies:
cronie x86_64 1.4.4-7.el6 base 70 k
cronie-anacron x86_64 1.4.4-7.el6 base 29 k

Transaction Summary
==================================================================================================================================================================
Install 3 Package(s)

Total download size: 110 k
Installed size: 211 k
Is this ok [y/N]: y
Downloading Packages:
(1/3): cronie-1.4.4-7.el6.x86_64.rpm | 70 kB 00:00
(2/3): cronie-anacron-1.4.4-7.el6.x86_64.rpm | 29 kB 00:00
(3/3): crontabs-1.10-33.el6.noarch.rpm | 10 kB 00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 102 kB/s | 110 kB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : cronie-1.4.4-7.el6.x86_64 1/3
Installing : crontabs-1.10-33.el6.noarch 2/3
Installing : cronie-anacron-1.4.4-7.el6.x86_64 3/3
Verifying : crontabs-1.10-33.el6.noarch 1/3
Verifying : cronie-1.4.4-7.el6.x86_64 2/3
Verifying : cronie-anacron-1.4.4-7.el6.x86_64 3/3

Installed:
crontabs.noarch 0:1.10-33.el6

Dependency Installed:
cronie.x86_64 0:1.4.4-7.el6 cronie-anacron.x86_64 0:1.4.4-7.el6

Complete!

[root@shizune installer]# service crond start
Starting crond: [ OK ]

telnet localhost 25 refused

2012-08-01T16:57:00.004+08:00

Was trying to configure my linux box to send email. When I tried to telnet the port 25 for localhost I've got the error below:

[root@shizune installer]# telnet localhost 25
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused

After issuing the netstat -nl command, I didn't see pot 25 listening to daemon at the localhost.

[root@shizune installer]# netstat -nl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 :::80 :::* LISTEN
tcp 0 0 :::22 :::* LISTEN
Active UNIX domain sockets (only servers)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ACC ] STREAM LISTENING 6453 @/com/ubuntu/upstart
unix 2 [ ACC ] STREAM LISTENING 18878 /var/lib/mysql/mysql.sock
unix 2 [ ACC ] STREAM LISTENING 7991 @/var/run/hald/dbus-Hvebo5KGlA
unix 2 [ ACC ] STREAM LISTENING 7908 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 8418 /var/run/abrt/abrt.socket
unix 2 [ ACC ] STREAM LISTENING 7996 @/var/run/hald/dbus-9kHuL7iipY

To fix the problem you need to install the postfix into your server.

[root@shizune installer]# yum --enablerepo=remi install postfix
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: centos.ipserverone.com
* extras: centos.ipserverone.com
* remi: iut-info.univ-reims.fr
* updates: centosk3.centos.org
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package postfix.x86_64 2:2.6.6-2.2.el6_1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================================================
Package Arch Version Repository Size
==================================================================================================================================================================
Installing:
postfix x86_64 2:2.6.6-2.2.el6_1 base 2.0 M

Transaction Summary
==================================================================================================================================================================
Install 1 Package(s)

Total download size: 2.0 M
Installed size: 9.7 M
Is this ok [y/N]: y
Downloading Packages:
postfix-2.6.6-2.2.el6_1.x86_64.rpm | 2.0 MB 00:03
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : 2:postfix-2.6.6-2.2.el6_1.x86_64 1/1

Installed:
postfix.x86_64 2:2.6.6-2.2.el6_1

Complete!
[root@shizune installer]# service postfix status
master is stopped
[root@shizune installer]# service postfix start
Starting postfix: [ OK ]
[root@shizune installer]# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 shizune.localhost.org ESMTP Postfix

[root@shizune installer]# netstat -nl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 :::80 :::* LISTEN
tcp 0 0 :::22 :::* LISTEN
Active UNIX domain sockets (only servers)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ACC ] STREAM LISTENING 6453 @/com/ubuntu/upstart
unix 2 [ ACC ] STREAM LISTENING 18878 /var/lib/mysql/mysql.sock
unix 2 [ ACC ] STREAM LISTENING 7991 @/var/run/hald/dbus-Hvebo5KGlA
unix 2 [ ACC ] STREAM LISTENING 7908 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 8418 /var/run/abrt/abrt.socket
unix 2 [ ACC ] STREAM LISTENING 7996 @/var/run/hald/dbus-9kHuL7iipY
unix 2 [ ACC ] STREAM LISTENING 28810 public/cleanup
unix 2 [ ACC ] STREAM LISTENING 28817 private/tlsmgr
unix 2 [ ACC ] STREAM LISTENING 28821 private/rewrite
unix 2 [ ACC ] STREAM LISTENING 28825 private/bounce
unix 2 [ ACC ] STREAM LISTENING 28829 private/defer
unix 2 [ ACC ] STREAM LISTENING 28833 private/trace
unix 2 [ ACC ] STREAM LISTENING 28837 private/verify
unix 2 [ ACC ] STREAM LISTENING 28841 public/flush
unix 2 [ ACC ] STREAM LISTENING 28845 private/proxymap
unix 2 [ ACC ] STREAM LISTENING 28849 private/proxywrite
unix 2 [ ACC ] STREAM LISTENING 28853 private/smtp
unix 2 [ ACC ] STREAM LISTENING 28857 private/relay
unix 2 [ ACC ] STREAM LISTENING 28861 public/showq
unix 2 [ ACC ] STREAM LISTENING 28865 private/error
unix 2 [ ACC ] STREAM LISTENING 28869 private/retry
unix 2 [ ACC ] STREAM LISTENING 28873 private/discard
unix 2 [ ACC ] STREAM LISTENING 28877 private/local
unix 2 [ ACC ] STREAM LISTENING 28881 private/virtual
unix 2 [ ACC ] STREAM LISTENING 28885 private/lmtp
unix 2 [ ACC ] STREAM LISTENING 28889 private/anvil
unix 2 [ ACC ] STREAM LISTENING 28893 private/scache

No rule to make target `/usr/lib64/perl5/CORE/config.h', needed by `Makefile'

2012-08-01T12:50:00.001+08:00

While i was trying to install an application using Makefile.PL it returns an error below.

[root@shizune ExtUtils-MakeMaker-6.62]# perl Makefile.PL
Using included version of JSON::PP (2.27104) because it is not already installed.
Using included version of File::Copy::Recursive (0.38) because it is not already installed.
Using included version of CPAN::Meta::YAML (0.003) because it is not already installed.
Using included version of ExtUtils::Manifest (1.58) as it is newer than the installed version (1.56).
Using included version of JSON::PP::Compat5006 (1.09) because it is not already installed.
Using included version of version (0.88) as it is newer than the installed version (0.77).
Using included version of CPAN::Meta (2.112150) because it is not already installed.
Using included version of Parse::CPAN::Meta (1.4401) because it is not already installed.
Using included version of Version::Requirements (0.101020) because it is not already installed.
Writing Makefile for ExtUtils::MakeMaker
Writing MYMETA.yml and MYMETA.json

[root@shizune ExtUtils-MakeMaker-6.62]# make
make: *** No rule to make target `/usr/lib64/perl5/CORE/config.h', needed by `Makefile'. Stop.

Solution:

Check if the perl-devel was installed. If not try installing it then your problem is solved.

[root@shizune mytop-1.6]# rpm -qa | grep perl-devel
perl-devel-5.10.1-127.el6.x86_64
[root@shizune mytop-1.6]#

[root@shizune ExtUtils-MakeMaker-6.62]# yum --enablerepo=remi install perl-devel
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: centos.ipserverone.com
* extras: centos.ipserverone.com
* remi: rpms.famillecollet.com
* updates: centoso4.centos.org
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-devel.x86_64 4:5.10.1-127.el6 will be installed
--> Processing Dependency: perl = 4:5.10.1-127.el6 for package: 4:perl-devel-5.10.1-127.el6.x86_64
--> Processing Dependency: perl(ExtUtils::ParseXS) for package: 4:perl-devel-5.10.1-127.el6.x86_64
--> Processing Dependency: perl(ExtUtils::MakeMaker) for package: 4:perl-devel-5.10.1-127.el6.x86_64
--> Processing Dependency: perl(ExtUtils::Installed) for package: 4:perl-devel-5.10.1-127.el6.x86_64
--> Running transaction check
---> Package perl.x86_64 4:5.10.1-119.el6_1.1 will be updated
--> Processing Dependency: perl = 4:5.10.1-119.el6_1.1 for package: 1:perl-Module-Pluggable-3.90-119.el6_1.1.x86_64
--> Processing Dependency: perl = 4:5.10.1-119.el6_1.1 for package: 3:perl-version-0.77-119.el6_1.1.x86_64
--> Processing Dependency: perl = 4:5.10.1-119.el6_1.1 for package: 1:perl-Pod-Simple-3.13-119.el6_1.1.x86_64
--> Processing Dependency: perl = 4:5.10.1-119.el6_1.1 for package: 1:perl-Pod-Escapes-1.04-119.el6_1.1.x86_64
--> Processing Dependency: perl = 4:5.10.1-119.el6_1.1 for package: 4:perl-libs-5.10.1-119.el6_1.1.x86_64
---> Package perl.x86_64 4:5.10.1-127.el6 will be an update
---> Package perl-ExtUtils-MakeMaker.x86_64 0:6.55-127.el6 will be installed
--> Processing Dependency: perl(Test::Harness) for package: perl-ExtUtils-MakeMaker-6.55-127.el6.x86_64
---> Package perl-ExtUtils-ParseXS.x86_64 1:2.2003.0-127.el6 will be installed
--> Running transaction check
---> Package perl-Module-Pluggable.x86_64 1:3.90-119.el6_1.1 will be updated
---> Package perl-Module-Pluggable.x86_64 1:3.90-127.el6 will be an update
---> Package perl-Pod-Escapes.x86_64 1:1.04-119.el6_1.1 will be updated
---> Package perl-Pod-Escapes.x86_64 1:1.04-127.el6 will be an update
---> Package perl-Pod-Simple.x86_64 1:3.13-119.el6_1.1 will be updated
---> Package perl-Pod-Simple.x86_64 1:3.13-127.el6 will be an update
---> Package perl-Test-Harness.x86_64 0:3.17-127.el6 will be installed
---> Package perl-libs.x86_64 4:5.10.1-119.el6_1.1 will be updated
---> Package perl-libs.x86_64 4:5.10.1-127.el6 will be an update
---> Package perl-version.x86_64 3:0.77-119.el6_1.1 will be updated
---> Package perl-version.x86_64 3:0.77-127.el6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================================================
Package Arch Version Repository Size
==================================================================================================================================================================
Installing:
perl-devel x86_64 4:5.10.1-127.el6 base 421 k
Installing for dependencies:
perl-ExtUtils-MakeMaker x86_64 6.55-127.el6 base 291 k
perl-ExtUtils-ParseXS x86_64 1:2.2003.0-127.el6 base 43 k
perl-Test-Harness x86_64 3.17-127.el6 base 229 k
Updating for dependencies:
perl x86_64 4:5.10.1-127.el6 base 10 M
perl-Module-Pluggable x86_64 1:3.90-127.el6 base 38 k
perl-Pod-Escapes x86_64 1:1.04-127.el6 base 30 k
perl-Pod-Simple x86_64 1:3.13-127.el6 base 210 k
perl-libs x86_64 4:5.10.1-127.el6 base 576 k
perl-version x86_64 3:0.77-127.el6 base 49 k

Transaction Summary
==================================================================================================================================================================
Install 4 Package(s)
Upgrade 6 Package(s)

Total download size: 12 M
Is this ok [y/N]: y
Downloading Packages:
(1/10): perl-5.10.1-127.el6.x86_64.rpm | 10 MB 00:10
(2/10): perl-ExtUtils-MakeMaker-6.55-127.el6.x86_64.rpm | 291 kB 00:00
(3/10): perl-ExtUtils-ParseXS-2.2003.0-127.el6.x86_64.rpm | 43 kB 00:00
(4/10): perl-Module-Pluggable-3.90-127.el6.x86_64.rpm | 38 kB 00:00
(5/10): perl-Pod-Escapes-1.04-127.el6.x86_64.rpm | 30 kB 00:00
(6/10): perl-Pod-Simple-3.13-127.el6.x86_64.rpm | 210 kB 00:01
(7/10): perl-Test-Harness-3.17-127.el6.x86_64.rpm | 229 kB 00:00
(8/10): perl-devel-5.10.1-127.el6.x86_64.rpm | 421 kB 00:02
(9/10): perl-libs-5.10.1-127.el6.x86_64.rpm | 576 kB 00:01
(10/10): perl-version-0.77-127.el6.x86_64.rpm | 49 kB 00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 592 kB/s | 12 MB 00:20
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : 1:perl-Pod-Escapes-1.04-127.el6.x86_64 1/16
Updating : 4:perl-libs-5.10.1-127.el6.x86_64 2/16
Updating : 1:perl-Pod-Simple-3.13-127.el6.x86_64 3/16
Updating : 3:perl-version-0.77-127.el6.x86_64 4/16
Updating : 1:perl-Module-Pluggable-3.90-127.el6.x86_64 5/16
Updating : 4:perl-5.10.1-127.el6.x86_64 6/16
Installing : 1:perl-ExtUtils-ParseXS-2.2003.0-127.el6.x86_64 7/16
Installing : perl-ExtUtils-MakeMaker-6.55-127.el6.x86_64 8/16
Installing : 4:perl-devel-5.10.1-127.el6.x86_64 9/16
Installing : perl-Test-Harness-3.17-127.el6.x86_64 10/16
Cleanup : 1:perl-Pod-Escapes-1.04-119.el6_1.1.x86_64 11/16
Cleanup : 1:perl-Pod-Simple-3.13-119.el6_1.1.x86_64 12/16
Cleanup : 3:perl-version-0.77-119.el6_1.1.x86_64 13/16
Cleanup : 4:perl-libs-5.10.1-119.el6_1.1.x86_64 14/16
Cleanup : 4:perl-5.10.1-119.el6_1.1.x86_64 15/16
Cleanup : 1:perl-Module-Pluggable-3.90-119.el6_1.1.x86_64 16/16

Installed:
perl-devel.x86_64 4:5.10.1-127.el6

Dependency Installed:
perl-ExtUtils-MakeMaker.x86_64 0:6.55-127.el6 perl-ExtUtils-ParseXS.x86_64 1:2.2003.0-127.el6 perl-Test-Harness.x86_64 0:3.17-127.el6

Dependency Updated:
perl.x86_64 4:5.10.1-127.el6 perl-Module-Pluggable.x86_64 1:3.90-127.el6 perl-Pod-Escapes.x86_64 1:1.04-127.el6 perl-Pod-Simple.x86_64 1:3.13-127.el6
perl-libs.x86_64 4:5.10.1-127.el6 perl-version.x86_64 3:0.77-127.el6

Complete!

[root@shizune ExtUtils-MakeMaker-6.62]# perl Makefile.PL
Using included version of JSON::PP (2.27104) because it is not already installed.
Using included version of File::Copy::Recursive (0.38) because it is not already installed.
Using included version of CPAN::Meta::YAML (0.003) because it is not already installed.
Using included version of ExtUtils::Manifest (1.58) as it is newer than the installed version (1.56).
Using included version of JSON::PP::Compat5006 (1.09) because it is not already installed.
Using included version of version (0.88) as it is newer than the installed version (0.77).
Using included version of CPAN::Meta (2.112150) because it is not already installed.
Using included version of Parse::CPAN::Meta (1.4401) because it is not already installed.
Using included version of Version::Requirements (0.101020) because it is not already installed.
Writing Makefile for ExtUtils::MakeMaker
Writing MYMETA.yml and MYMETA.json
[root@shizune ExtUtils-MakeMaker-6.62]# make
cp inc/ExtUtils/Manifest.pm blib/lib/ExtUtils/Manifest.pm
cp inc/File/Copy/Recursive.pm blib/lib/File/Copy/Recursive.pm
cp lib/ExtUtils/MM_VOS.pm blib/lib/ExtUtils/MM_VOS.pm
cp lib/ExtUtils/Mksymlists.pm blib/lib/ExtUtils/Mksymlists.pm
cp lib/ExtUtils/MM.pm blib/lib/ExtUtils/MM.pm
cp inc/JSON/PP.pm blib/lib/JSON/PP.pm
cp lib/ExtUtils/MM_UWIN.pm blib/lib/ExtUtils/MM_UWIN.pm
cp lib/ExtUtils/testlib.pm blib/lib/ExtUtils/testlib.pm
cp lib/ExtUtils/MM_DOS.pm blib/lib/ExtUtils/MM_DOS.pm
cp lib/ExtUtils/MM_Cygwin.pm blib/lib/ExtUtils/MM_Cygwin.pm
cp inc/version/vpp.pm blib/lib/version/vpp.pm
cp lib/ExtUtils/MM_Win95.pm blib/lib/ExtUtils/MM_Win95.pm
cp lib/ExtUtils/Liblist.pm blib/lib/ExtUtils/Liblist.pm
cp lib/ExtUtils/MM_Darwin.pm blib/lib/ExtUtils/MM_Darwin.pm
cp lib/ExtUtils/MM_AIX.pm blib/lib/ExtUtils/MM_AIX.pm
cp lib/ExtUtils/Liblist/Kid.pm blib/lib/ExtUtils/Liblist/Kid.pm
cp lib/ExtUtils/Mkbootstrap.pm blib/lib/ExtUtils/Mkbootstrap.pm
cp lib/ExtUtils/MakeMaker/FAQ.pod blib/lib/ExtUtils/MakeMaker/FAQ.pod
cp inc/ExtUtils/MANIFEST.SKIP blib/lib/ExtUtils/MANIFEST.SKIP
cp lib/ExtUtils/MM_NW5.pm blib/lib/ExtUtils/MM_NW5.pm
cp lib/ExtUtils/MM_OS2.pm blib/lib/ExtUtils/MM_OS2.pm
cp lib/ExtUtils/MakeMaker.pm blib/lib/ExtUtils/MakeMaker.pm
cp inc/version.pm blib/lib/version.pm
cp inc/CPAN/Meta/Feature.pm blib/lib/CPAN/Meta/Feature.pm
cp inc/version/Internals.pod blib/lib/version/Internals.pod
cp lib/ExtUtils/MM_Unix.pm blib/lib/ExtUtils/MM_Unix.pm
cp inc/JSON/PP/Boolean.pm blib/lib/JSON/PP/Boolean.pm
cp lib/ExtUtils/MM_Win32.pm blib/lib/ExtUtils/MM_Win32.pm
cp inc/CPAN/Meta/Spec.pm blib/lib/CPAN/Meta/Spec.pm
cp inc/CPAN/Meta/History.pm blib/lib/CPAN/Meta/History.pm
cp lib/ExtUtils/MY.pm blib/lib/ExtUtils/MY.pm
cp lib/ExtUtils/MM_MacOS.pm blib/lib/ExtUtils/MM_MacOS.pm
cp lib/ExtUtils/MM_VMS.pm blib/lib/ExtUtils/MM_VMS.pm
cp lib/ExtUtils/MM_BeOS.pm blib/lib/ExtUtils/MM_BeOS.pm
cp lib/ExtUtils/MakeMaker/Tutorial.pod blib/lib/ExtUtils/MakeMaker/Tutorial.pod
cp inc/CPAN/Meta/YAML.pm blib/lib/CPAN/Meta/YAML.pm
cp lib/ExtUtils/MM_QNX.pm blib/lib/ExtUtils/MM_QNX.pm
cp inc/CPAN/Meta/Converter.pm blib/lib/CPAN/Meta/Converter.pm
cp lib/ExtUtils/Command/MM.pm blib/lib/ExtUtils/Command/MM.pm
cp lib/ExtUtils/MakeMaker/Config.pm blib/lib/ExtUtils/MakeMaker/Config.pm
cp inc/JSON/PP/Compat5006.pm blib/lib/JSON/PP/Compat5006.pm
cp inc/CPAN/Meta.pm blib/lib/CPAN/Meta.pm
cp inc/Parse/CPAN/Meta.pm blib/lib/Parse/CPAN/Meta.pm
cp inc/CPAN/Meta/Prereqs.pm blib/lib/CPAN/Meta/Prereqs.pm
cp inc/Version/Requirements.pm blib/lib/Version/Requirements.pm
cp inc/CPAN/Meta/Validator.pm blib/lib/CPAN/Meta/Validator.pm
cp inc/version.pod blib/lib/version.pod
cp lib/ExtUtils/MM_Any.pm blib/lib/ExtUtils/MM_Any.pm
cp bin/instmodsh blib/script/instmodsh
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/instmodsh
Manifying blib/man1/instmodsh.1
Manifying blib/man3/ExtUtils::Manifest.3pm
Manifying blib/man3/File::Copy::Recursive.3pm
Manifying blib/man3/ExtUtils::MM_VOS.3pm
Manifying blib/man3/ExtUtils::Mksymlists.3pm
Manifying blib/man3/ExtUtils::MM.3pm
Manifying blib/man3/JSON::PP.3pm
Manifying blib/man3/ExtUtils::MM_UWIN.3pm
Manifying blib/man3/ExtUtils::testlib.3pm
Manifying blib/man3/ExtUtils::MM_DOS.3pm
Manifying blib/man3/ExtUtils::MM_Cygwin.3pm
Manifying blib/man3/ExtUtils::MM_Win95.3pm
Manifying blib/man3/ExtUtils::Liblist.3pm
Manifying blib/man3/ExtUtils::MM_Darwin.3pm
Manifying blib/man3/ExtUtils::MM_AIX.3pm
Manifying blib/man3/ExtUtils::Mkbootstrap.3pm
Manifying blib/man3/ExtUtils::MakeMaker::FAQ.3pm
Manifying blib/man3/ExtUtils::MM_NW5.3pm
Manifying blib/man3/ExtUtils::MM_OS2.3pm
Manifying blib/man3/ExtUtils::MakeMaker.3pm
Manifying blib/man3/CPAN::Meta::Feature.3pm
Manifying blib/man3/version::Internals.3pm
Manifying blib/man3/ExtUtils::MM_Unix.3pm
Manifying blib/man3/JSON::PP::Boolean.3pm
Manifying blib/man3/ExtUtils::MM_Win32.3pm
Manifying blib/man3/CPAN::Meta::Spec.3pm
Manifying blib/man3/CPAN::Meta::History.3pm
Manifying blib/man3/ExtUtils::MY.3pm
Manifying blib/man3/ExtUtils::MM_MacOS.3pm
Manifying blib/man3/ExtUtils::MM_VMS.3pm
Manifying blib/man3/ExtUtils::MM_BeOS.3pm
Manifying blib/man3/ExtUtils::MakeMaker::Tutorial.3pm
Manifying blib/man3/ExtUtils::MM_QNX.3pm
Manifying blib/man3/CPAN::Meta::YAML.3pm
Manifying blib/man3/CPAN::Meta::Converter.3pm
Manifying blib/man3/ExtUtils::Command::MM.3pm
Manifying blib/man3/JSON::PP::Compat5006.3pm
Manifying blib/man3/ExtUtils::MakeMaker::Config.3pm
Manifying blib/man3/CPAN::Meta.3pm
Manifying blib/man3/CPAN::Meta::Prereqs.3pm
Manifying blib/man3/Parse::CPAN::Meta.3pm
Manifying blib/man3/CPAN::Meta::Validator.3pm
Manifying blib/man3/Version::Requirements.3pm
Manifying blib/man3/version.3pm
Manifying blib/man3/ExtUtils::MM_Any.3pm

[root@shizune ExtUtils-MakeMaker-6.62]# make install
Installing /usr/share/perl5/version.pm
Installing /usr/share/perl5/version.pod
Installing /usr/share/perl5/Parse/CPAN/Meta.pm
Installing /usr/share/perl5/Version/Requirements.pm
Installing /usr/share/perl5/CPAN/Meta.pm
Installing /usr/share/perl5/CPAN/Meta/YAML.pm
Installing /usr/share/perl5/CPAN/Meta/History.pm
Installing /usr/share/perl5/CPAN/Meta/Prereqs.pm
Installing /usr/share/perl5/CPAN/Meta/Feature.pm
Installing /usr/share/perl5/CPAN/Meta/Spec.pm
Installing /usr/share/perl5/CPAN/Meta/Converter.pm
Installing /usr/share/perl5/CPAN/Meta/Validator.pm
Installing /usr/share/perl5/File/Copy/Recursive.pm
Installing /usr/share/perl5/ExtUtils/MM_QNX.pm
Installing /usr/share/perl5/ExtUtils/MM_Cygwin.pm
Installing /usr/share/perl5/ExtUtils/MM_Win95.pm
Installing /usr/share/perl5/ExtUtils/MM_VMS.pm
Installing /usr/share/perl5/ExtUtils/MM_BeOS.pm
Installing /usr/share/perl5/ExtUtils/MM_NW5.pm
Installing /usr/share/perl5/ExtUtils/MM_Any.pm
Installing /usr/share/perl5/ExtUtils/Manifest.pm
Installing /usr/share/perl5/ExtUtils/MM_VOS.pm
Installing /usr/share/perl5/ExtUtils/MM_DOS.pm
Installing /usr/share/perl5/ExtUtils/MM_Darwin.pm
Installing /usr/share/perl5/ExtUtils/testlib.pm
Installing /usr/share/perl5/ExtUtils/MM_AIX.pm
Installing /usr/share/perl5/ExtUtils/MM_UWIN.pm
Installing /usr/share/perl5/ExtUtils/Mkbootstrap.pm
Installing /usr/share/perl5/ExtUtils/MM_Unix.pm
Installing /usr/share/perl5/ExtUtils/MANIFEST.SKIP
Installing /usr/share/perl5/ExtUtils/Mksymlists.pm
Installing /usr/share/perl5/ExtUtils/MY.pm
Installing /usr/share/perl5/ExtUtils/MM.pm
Installing /usr/share/perl5/ExtUtils/MM_MacOS.pm
Installing /usr/share/perl5/ExtUtils/MM_OS2.pm
Installing /usr/share/perl5/ExtUtils/Liblist.pm
Installing /usr/share/perl5/ExtUtils/MM_Win32.pm
Installing /usr/share/perl5/ExtUtils/MakeMaker.pm
Installing /usr/share/perl5/ExtUtils/Liblist/Kid.pm
Installing /usr/share/perl5/ExtUtils/Command/MM.pm
Installing /usr/share/perl5/ExtUtils/MakeMaker/FAQ.pod
Installing /usr/share/perl5/ExtUtils/MakeMaker/Tutorial.pod
Installing /usr/share/perl5/ExtUtils/MakeMaker/Config.pm
Installing /usr/share/perl5/JSON/PP.pm
Installing /usr/share/perl5/JSON/PP/Compat5006.pm
Installing /usr/share/perl5/JSON/PP/Boolean.pm
Installing /usr/share/perl5/version/vpp.pm
Installing /usr/share/perl5/version/Internals.pod
Installing /usr/share/man/man1/instmodsh.1
Installing /usr/share/man/man3/ExtUtils::MakeMaker::Config.3pm
Installing /usr/share/man/man3/ExtUtils::MM_UWIN.3pm
Installing /usr/share/man/man3/ExtUtils::Mksymlists.3pm
Installing /usr/share/man/man3/CPAN::Meta::Converter.3pm
Installing /usr/share/man/man3/ExtUtils::MY.3pm
Installing /usr/share/man/man3/ExtUtils::Liblist.3pm
Installing /usr/share/man/man3/CPAN::Meta.3pm
Installing /usr/share/man/man3/ExtUtils::MM_AIX.3pm
Installing /usr/share/man/man3/ExtUtils::MakeMaker::FAQ.3pm
Installing /usr/share/man/man3/JSON::PP.3pm
Installing /usr/share/man/man3/version.3pm
Installing /usr/share/man/man3/ExtUtils::MM_VMS.3pm
Installing /usr/share/man/man3/ExtUtils::MM_Darwin.3pm
Installing /usr/share/man/man3/ExtUtils::MM_MacOS.3pm
Installing /usr/share/man/man3/ExtUtils::Mkbootstrap.3pm
Installing /usr/share/man/man3/ExtUtils::MM_Any.3pm
Installing /usr/share/man/man3/ExtUtils::MM_OS2.3pm
Installing /usr/share/man/man3/ExtUtils::MM_Cygwin.3pm
Installing /usr/share/man/man3/CPAN::Meta::YAML.3pm
Installing /usr/share/man/man3/ExtUtils::MakeMaker.3pm
Installing /usr/share/man/man3/CPAN::Meta::History.3pm
Installing /usr/share/man/man3/ExtUtils::MM_VOS.3pm
Installing /usr/share/man/man3/ExtUtils::MM_NW5.3pm
Installing /usr/share/man/man3/ExtUtils::Manifest.3pm
Installing /usr/share/man/man3/ExtUtils::MM_Win95.3pm
Installing /usr/share/man/man3/CPAN::Meta::Spec.3pm
Installing /usr/share/man/man3/ExtUtils::MM_Unix.3pm
Installing /usr/share/man/man3/ExtUtils::MM_QNX.3pm
Installing /usr/share/man/man3/ExtUtils::MakeMaker::Tutorial.3pm
Installing /usr/share/man/man3/ExtUtils::MM_DOS.3pm
Installing /usr/share/man/man3/JSON::PP::Compat5006.3pm
Installing /usr/share/man/man3/CPAN::Meta::Feature.3pm
Installing /usr/share/man/man3/JSON::PP::Boolean.3pm
Installing /usr/share/man/man3/ExtUtils::Command::MM.3pm
Installing /usr/share/man/man3/ExtUtils::MM.3pm
Installing /usr/share/man/man3/ExtUtils::testlib.3pm
Installing /usr/share/man/man3/Parse::CPAN::Meta.3pm
Installing /usr/share/man/man3/File::Copy::Recursive.3pm
Installing /usr/share/man/man3/CPAN::Meta::Prereqs.3pm
Installing /usr/share/man/man3/ExtUtils::MM_Win32.3pm
Installing /usr/share/man/man3/version::Internals.3pm
Installing /usr/share/man/man3/Version::Requirements.3pm
Installing /usr/share/man/man3/ExtUtils::MM_BeOS.3pm
Installing /usr/share/man/man3/CPAN::Meta::Validator.3pm
Installing /usr/bin/instmodsh
Appending installation info to /usr/lib64/perl5/perllocal.pod

Eventum Configuration Error GD extension

2012-07-31T16:50:00.003+08:00

Configuration Error:

The following problems were found:

The GD extension needs to be enabled in your PHP.INI file in order for Eventum to work properly.
The Multibyte String Functions extension is not enabled in your PHP installation. For localization to work properly You need to install this extension. If you do not install this extension localization will be disabled.

Please resolve the issues described above. For file permission errors, please provide the appropriate permissions to the user that the web server run as to write in the directories and files specified above.

[root@localhost home]# yum install php-gd
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
* base: mirror.nus.edu.sg
* extras: mirror.nus.edu.sg
* remi: remi-mirror.dedipower.com
* updates: mirror.nus.edu.sg
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-gd.x86_64 0:5.3.15-1.el6.remi will be installed
--> Processing Dependency: libt1.so.5()(64bit) for package: php-gd-5.3.15-1.el6.remi.x86_64
--> Running transaction check
---> Package t1lib.x86_64 0:5.1.2-6.el6_2.1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================
Package Arch Version Repository Size
==================================================================================================================
Installing:
php-gd x86_64 5.3.15-1.el6.remi remi 133 k
Installing for dependencies:
t1lib x86_64 5.1.2-6.el6_2.1 base 160 k

Transaction Summary
==================================================================================================================
Install 2 Package(s)

Total download size: 293 k
Installed size: 1.0 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): php-gd-5.3.15-1.el6.remi.x86_64.rpm | 133 kB 00:06
(2/2): t1lib-5.1.2-6.el6_2.1.x86_64.rpm | 160 kB 00:00
------------------------------------------------------------------------------------------------------------------
Total 31 kB/s | 293 kB 00:09
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
remi-release-6-1.el6.remi.noarch has missing requires of epel-release >= ('0', '6', None)
Installing : t1lib-5.1.2-6.el6_2.1.x86_64 1/2
Installing : php-gd-5.3.15-1.el6.remi.x86_64 2/2

Installed:
php-gd.x86_64 0:5.3.15-1.el6.remi

Dependency Installed:
t1lib.x86_64 0:5.1.2-6.el6_2.1

Complete!

You also need to install the php-mbstring

to install

yum install php-mbstring

How to Install MySQL 5.5.25a and PHP 5.3 on Centos 6.2

2012-07-31T16:46:00.000+08:00

Remove existing MySQL version,mysql-libs,php-mysql

Download the version 6 remi-release and Install

wget http://rpms.famillecollet.com/enterprise/6/remi/x86_64/remi-release-6-1.el6.remi.noarch.rpm

rpm -Uvh remi-release-6-1.el6.remi.noarch.rpm --nodeps

Download and Install MySQL RPM at http://dev.mysql.com/downloads/mysql/#downloads

wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.25a-1.el6.x86_64.rpm/from/http://na.mirror.garr.it/mirrors/MySQL/
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.25a-1.el6.x86_64.rpm/from/http://na.mirror.garr.it/mirrors/MySQL/
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-devel-5.5.25a-1.el6.x86_64.rpm/from/http://na.mirror.garr.it/mirrors/MySQL/
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-shared-5.5.25a-1.el6.x86_64.rpm/from/http://na.mirror.garr.it/mirrors/MySQL/

rpm -ivh MySQL-server-5.5.25a-1.el6.x86_64.rpm MySQL-client-5.5.25a-1.el6.x86_64.rpm MySQL-devel-5.5.25a-1.el6.x86_64.rpm MySQL-shared-5.5.25a-1.el6.x86_64.rpm

Install the mysql-libs php-mysql via yum

yum --enablerepo=remi install mysql-libs

yum --enablerepo=remi install php-mysql

Note : if its asking for some dependencies just install it.

apr_sockaddr_info_get() failed

2012-07-31T11:27:00.001+08:00

I was trying to start apache from a VM. I am getting the error below:

[root@shizune ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: httpd: apr_sockaddr_info_get() failed for shizune.tes.org
httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
[ OK ]

The solution for this problem is problem is too simple just try the following steps:

1. Modify the apache configuration file.

[root@shizune ~]# vi /etc/httpd/conf/httpd.conf

2. Just add the following line.

ServerName localhost [ localhost will be the servername. ]

3. Restart apache.

[root@shizune ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
[root@shizune ~]#

Unable to start MySQl

2011-04-07T08:38:00.000+08:00

We are not able to start MySQL because of the error below.

110407 00:32:13 mysqld started
110407 0:32:14 InnoDB: Error: cannot allocate 3221241856 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 37679104 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
InnoDB: Fatal error: cannot allocate the memory for the buffer pool
110407 0:33:17 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
110407 0:33:17 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
110407 0:33:17 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

I tried to remove the /etc/my.cnf. Always remember to back up the file first :). When i tried to start again the MySQL service still getting the errors. I tried to find some solutions in the web but i cannot find any related problems. I tried to set again the mysql configuration file. And when i tried to start MySQL and kaboom it started. hehehe.. I don't know why but i am able to start the MySQL :)

When i was starting the server i am seeing some weird logs before the MySQl started.

[root@TESTING01 etc]# service mysql start
/usr/bin/my_print_defaults: unknown option '--use-mysqld_safe'
/usr/bin/my_print_defaults: unknown option '--use-mysqld_safe'
Starting MySQL...... [ OK ]
[root@TESTING01 etc]# tail -f /var/lib/mysql/

PHP Compilation Errors and Solutions.

2008-07-25T15:51:00.000+08:00

Additional solutions. Previously i posted some solutions regarding some errors in compiling PHP from source. Some errors below were posted in my previous postings.

---------------------------
checking for bison version... invalid
configure: warning: bison versions supported for regeneration of the Zend/PHP parsers: 1.28 1.35 1.75 1.875 2.0 2.1 2.2 2.3 (found: none).
checking for flex... lex
checking for yywrap in -ll... no
checking lex output file root... ./configure: line 3276: lex: command not found

solution: flex-2.5.4a-33.i386.rpm
---------------------------
checking whether to enable LIBXML support... yes
checking libxml2 install dir... no
checking for xml2-config path...
configure: error: xml2-config not found. Please check your libxml2 installation.

solution: libxml2-devel-2.6.16-6.i386.rpm
---------------------------
checking whether to enable JIS-mapped Japanese font support in GD... no
checking for fabsf... yes
checking for floorf... yes
configure: error: libjpeg.(a|so) not found.

solution:libjpeg-devel-6b-33.i386.rpm
---------------------------

checking for jpeg_read_header in -ljpeg... yes
configure: error: libpng.(a|so) not found.

libpng-devel-1.2.7-1.el4.2.i386.rpm
---------------------------
checking for png_write_image in -lpng... yes
If configure fails try --with-xpm-dir=
configure: error: freetype2 not found!

Solution: up2date freetype-devel
---------------------------

checking for LDAP support... yes, shared
checking for LDAP Cyrus SASL support... no
configure: error: Cannot find ldap.h

solution: up2date openldap-devel
---------------------------

Setting a UTC Timezone

2008-05-16T20:39:00.000+08:00

What timezone should you use for your server? Perhaps you should try Universal Co-ordinated Time (UTC).

vi /etc/sysconfig/clock and change the UTC line to: "UTC=true"

Set localtimezone to UTC: ln -sf /usr/share/zoneinfo/UTC /etc/localtime

If you want to set your timezone to something else, perhaps your personal timezone, then you find that timezone under /usr/share/zoneinfo and link that to /etc/localtime. For example: ln -sf /usr/share/zoneinfo/Australia/Brisbane /etc/localtime.

How to get and install Apache in Linux

2008-02-20T03:06:00.001+08:00

1. Get the latest Apache distribution at http://www.apache.org

2. Download and save it to /home/someuser/source/

3. Open terminal

4. # cd /home/someuser/source/

5. Unpack the distribution

· # tar xzvf httpd-x.x.x tar.gz

6. Go to the Apache source directory

· # cd httpd-x.x.x

7. Configure, compile and install Apache

· # ./configure --prefix=/usr/local/apache --enable-module=all --enable-shared=max

· # make

· # make install

How to use crontabs

2008-02-13T15:13:00.000+08:00

Crontab Commands
__________
export EDITOR=vi ;to specify a editor to open crontab file.

crontab -e Edit your crontab file, or create one if it doesn't already exist.
crontab -l Display your crontab file.
crontab -r Remove your crontab file.
crontab -v Display the last time you edited your crontab file. (This option is only available on a few systems.)

Crontab syntax :-
A crontab file has five fields for specifying day , date and time followed by the command to be run at that interval.

* in the value field above means all legal values as in braces for that column.
The value column can have a * or a list of elements separated by commas. An element is either a number in the ranges shown above or two numbers in the range separated by a hyphen (meaning an inclusive range).

Note: The specification of days can be made in two fields: month day and weekday. If both are specified in an entry, they are cumulative meaning both of the entries will get executed .

Crontab Example

A line in crontab file like below removes the tmp files from /home/someuser/tmp each day at 6:30 PM.

30 18 * * * rm /home/someuser/tmp/*

Below runs the script every 3 minutes.

*/3 * * * * /home/perl/update.pl

Disable Email

By default cron jobs sends a email to the user account executing the cronjob. If this is not needed put the following command At the end of the cron job line .

>/dev/null 2>&1

How to install JDK 6 Update 4 in RHEL 4/5

2008-02-08T17:31:00.000+08:00

STEP 1:DOWNLOADING FILE
Download Linux RPM in self-extracting file from http://java.sun.com/.

jdk-6u4-linux-i586-rpm.bin - for non 64 bit computer
jdk-6u4-linux-x64-rpm.bin - for 64 bit computer

STEP 2: HOW TO INSTALL

chmod a+x jdk-6u4-linux-xxxx.rpm.bin
./ jdk jdk-6u4-linux-xxxx.rpm.bin
Remove the existing java installation. you can identify the package by executing 'rpm -qa | grep java' you can remove the package by executing rpm -e 'java-1.x.x.'
rpm jdk-6u4-linux-xxxx.rpm
vi /root/.bash_profile and add this ..
PATH=$PATH:$HOME/bin:/usr/java/jdk1.6.0_04/bin

After doing the steps reboot your machine.

PHP Compilation Error: configure: error: Cannot find rfc822.h. Please check your c-client installation.

2008-02-08T17:08:00.000+08:00

If you are getting this error while compiling the PHP source, this is how to fix the problem.

Solution: If your machine is registered to redhat network just execute up2date -i libc-client-devel to install in your machine

If your machine is not registered download the libjpeg-devel.x.x.x.rpm then install it your machine.

rpm -ivh libc-client-devel.x.x.x.rpm

PHP Compilation Error: lib64/libc-client.a: could not read symbols: Bad value | make: *** [ext/imap/imap.la] Error 1

2008-02-08T16:59:00.000+08:00

/usr/lib/gcc/x86_64-redhat-linux/3.4.6/../../../../lib64/libc-client.a: could not read symbols: Bad value
collect2: ld returned 1 exit status
make: *** [ext/imap/imap.la] Error 1

If you are getting this error, you can fix this by installing an older version of the following rpm's below.

libc-client.x.x.x.rpm
libc-client-devel.x.x.x.rpm

Some older php-source is not compatible with the latest libc-client.

I don't know if this is the ultimate solution but it works when I tried to install the older version of libc-client. =-)

PHP Compilation Error: configure: error: libjpeg.(a|so) not found.

2008-02-08T16:07:00.000+08:00

If you are getting this error while compiling the PHP source, this is how to fix the problem.

Solution: If your machine is registered to redhat network just execute up2date -i libjpeg-devel to install in your machine

If your machine is not registered download the libjpeg-devel.x.x.x.rpm then install it your machine.

rpm -ivh libjpeg-devel.x.x.x.rpm

Sendmail error:unqualified host name (localhost) unknown; sleeping for retry

2007-07-20T06:36:00.000+08:00

Solution:Make sure the host's names (including localhost) are
defined in /etc/hosts, and that /etc/hosts is being used in
name resolution.

Possible Fixes:
The solution will fix in shortening waiting time execution
of mailq,sendmail -q, and restarting the service of sendmail.