Thanks to antville.org
mysql and shell command

date -d"-1 day ago" +'%b%d'

equals to

mysql -Bse"select date_format(date(date_add(now() , interval 1 day)),'%b%d')"

... Link (4 comments) ... Comment


find dead processes

The 8th column of ps aux command will list the status of the process.

ps aux | awk '{if ($8 ~ "D") print $0}'

Here is a list of the various process statuses and what they mean:

D – Uninterruptible sleep (usually a critical system process, a process that cannot be killed without rebooting)
R – Running
S – Interruptible sleep (waiting for an event to complete)
T – Stopped
Z – Defunct (“zombie”) process

... Link (0 comments) ... Comment


connect to AWS

It is possible to use password to connect to AWS

1) change config file
sudo vi /etc/ssh/sshd_config

PermitRootLogin yes
PasswordAuthentication yes

2) restart
sudo service ssh restart

3) add a password
sudo passwd root

4) ssh without key
ssh root@xxx.com

... Link (0 comments) ... Comment


upgrade ubuntu

Upgrade from 14.04 to 15.04 is a 2 step journey.

sudo nano /etc/update-manager/release-upgrades
change the value to normal

And then use this command twice!
sudo do-release-upgrade

You can check your ubuntu version:

lsb_release -a
Description: Ubuntu 15.04

... Link (0 comments) ... Comment


Libre office on centOS

Here is how to install Libre office on centOS

64 bit
wget download.documentfoundation.org

32 bit
wget download.documentfoundation.org

tar xvf LibreOffice_4.4.4_Linux_x86_rpm.tar.gz

rpm -Uvh LibreOffice_4.4.4.3_Linux_x86_rpm/RPMS/*.rpm

... Link (0 comments) ... Comment


manage iso image file

Here is how you can open and copy files from an iso image.

mkdir /mnt/iso
mount -t iso9660 -o loop /root/Downloads/ubuntu-15.04-desktop-i386.iso /mnt/iso/

ls /mnt/iso/

... Link (0 comments) ... Comment


Create a Reverse SSH Tunnel

on Remote server:
ssh -fN -R 7000:localhost:22 username@yourMachine-ipaddress

Now do an ssh connection request from your machine to your own machine at port 7000:
ssh username@localhost -p 7000

... Link (0 comments) ... Comment


avoid key prompt

Here is a simple tip that will avoid RSA key fingerprint authentication. Edit /etc/ssh/ssh_config for global configuration or ~/.ssh/config for user-specific configuration.

Host 192.168.0.*
StrictHostKeyChecking no
UserKnownHostsFile=/dev/null

... Link (0 comments) ... Comment


Killing mysql

Here are a few ways to kill mysql process.

mysqladmin shutdown
kill -TERM nnnn
killalll mysqld
kill -TERM pidof mysqld
kill -TERM cat /var/run/mysqld.pid

... Link (0 comments) ... Comment


Managing top

While the output of the top command displayed, press F, which will display all fields available for sorting, press n (which is for sorting the processes by Memory) and press enter.

press c, which will display full pathname of running processes

press 1 (number one), which will display the performance data of the individual CPUs.

... Link (0 comments) ... Comment


Online for 6268 days
Last modified: 10/22/19 2:54 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
October 2019
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
2728293031
September
Recent updates
This is nice. At least
I've found a nice blog like this... Worth reading....
by casseverhart13 (10/22/19 2:54 AM)
check out the new
stuff you post in the future! magician Philadelphia
by casseverhart13 (10/21/19 5:03 AM)
Hope to read another
kind of article like this. pressure washing Gainesville
by casseverhart13 (10/18/19 4:35 AM)
Real Human Website Traffic -
The short answer is that it is #traffic that...
by webvisitors (10/17/19 10:01 PM)
Great! Thanks for sharing your
post, it seems really interesting to read. I hope to...
by Anna0203 (10/17/19 7:32 PM)
Great Thanks for posting this
one. :) commercial window cleaning cincinnati ohio
by brielleluna (10/17/19 7:27 PM)
Nice Since then, I always
check your article because it was really an informative one....
by Meggy27 (10/17/19 3:52 PM)
I hope you continue
writing about this kind of entry. carpet steam cleaner
by casseverhart13 (10/17/19 10:15 AM)
It's my pleasure to find
this amazing website who provides mostly unseen information about...
by casseverhart13 (10/17/19 5:26 AM)
Did you know that many
company Buy Website Traffic that is driven to their...
by webvisitors (10/17/19 2:28 AM)
USA State Targeted Traffic you
can isolate marketing efforts with a specific state, or...
by webvisitors (10/17/19 1:20 AM)
Want to work with a
reputable company with countless return customers? Talk to us...
by webvisitors (10/17/19 1:19 AM)
Weekly Email Notification enable Weekly
Email Notification from the Trusted Advisor. 1) Open the AWS...
by shantanuo (10/16/19 3:14 PM)
If most of your customers
are from Texas, don't waste time and money marketing...
by webvisitors (10/15/19 5:52 PM)
Buy Website Traffic - Expand
your reach! Give prospects nationwide exposure to your products...
by webvisitors (10/15/19 5:47 PM)
I hope you continue
writing about this kind of entry. Tree Solutions Hunter's Creek
by casseverhart13 (10/15/19 11:19 AM)
Great blog you have here
but I was wondering if you knew of any...
by casseverhart13 (10/15/19 5:17 AM)
Buy Website Traffic - Expand
your reach! Give prospects nationwide exposure to your products...
by webvisitors (10/15/19 12:43 AM)
Buy Website Traffic - Expand
your reach! Give prospects nationwide exposure to your products...
by webvisitors (10/15/19 12:42 AM)
Buy Website Traffic - Expand
your reach! Give prospects nationwide exposure to your products...
by webvisitors (10/15/19 12:42 AM)
Buy Website Traffic - Expand
your reach! Give prospects nationwide exposure to your products...
by webvisitors (10/15/19 12:42 AM)
Buy Website Traffic - Expand
your reach! Give prospects nationwide exposure to your products...
by webvisitors (10/15/19 12:41 AM)
Buy Website Traffic - Expand
your reach! Give prospects nationwide exposure to your products...
by webvisitors (10/15/19 12:41 AM)
Targeted Web Traffic If you
want the best, come to the best! Based in the...
by webvisitors (10/15/19 12:31 AM)
Prevol Financiera However, this method
of cashless electronic payment transaction has strings attached in terms...
by saeedkhatri (10/14/19 8:33 AM)

RSS feed

Made with Antville
Helma Object Publisher