Running Services List

There are various ways and tools to find and list all running services under Fedora / RHEL / CentOS Linux systems.
Some of them are:

service --status-all
service --status-all | grep ntpd
service --status-all | less

To print the status of apache (httpd) service:

service httpd status

ANL

1 click install of KDE4.3

Hi guys and gals,
Some days ago i faced serious problems with kde4.2 beta, i upgrade my system from 4.1.3 to 4.2 beta and everything goes wrong. Nothing was working, every time desktop crashes.
I start using gnome then.

But today i tried again the 1 click install, and wow everything back to normal. Its working very nice and smoothly. Kde4.3 is really a move and give a chance thing. i am impressed by the new added features.
Can try the 1 click install from here:
1 click install kde4.3

Note: Its for openSUSE 11.1 and 11.0.
I had tried it on openSUSE 11.0.

So best of luck, and enjoy the new polish desktop.

ANL

MySQL: Find Out Which Table is Consuming Resources

You can use mytop command a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL.
Install Mytop:
First install required perl modules:

cpan -i Term::ReadKey
cpan -i Term::ANSIColor
cpan -i Time::HiRes

Next, install mytop, enter:

wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz
tar -zxvf mytop-1.6.tar.gz
cd mytop-1.6
perl Makefile.PL
make
make test
make install

To view information about database called foo, enter:

$ mytop -u dba -p 'password' -h 10.2.4.5 -d foo

Where,

* -u : Database username.
* -p : Database password.
* -h : Database server IP address.
* -d : Database name.

Read mytop man page for further information:

perldoc mytop

ANL

SSH System Bootup In Progress Please Wait Error and Solution

System bootup in progress -please wait
This error appers when system config or root user creates /etc/nologin file. If the file /etc/nologin exists, login will allow access only to root. Other users will be shown the contents of this file and their logins will be refused. The solution is simple, delete the file /etc/nologin manually:

rm /etc/nologin

If this error occurs after reboot open /etc/default/rcS file and set DELAYLOGIN to no:

DELAYLOGIN=no

If this option set to yes, /etc/init.d/bootmisc.sh will create /etc/nologin, which causes a default SSH and PAM configuration to prevent all logins.

This problem cannot be solved over remote ssh session. However, if you can login via KVM or serial console, then you can fix it over remote session.

ANL