Thanks to antville.org
Install latest mysql

Set up git:

yum install git-core
cd ~/.ssh
ssh-keygen -t rsa -C "shantanu.oak@gmail.com"

Contents of the file "id_rsa.pub" should be copied to gitHub site.
On the GitHub site Click “Account Settings” > Click “SSH Public Keys” > Click “Add another public key”

This will allow passwordless access to github site:
ssh -T git@github.com


Global setup:

git config --global user.name "Shantanu Oak"
git config --global user.email shantanu.oak@gmail.com


Next steps:

mkdir syllabalize_unicode
cd syllabalize_unicode
git init
touch README
git add README
git commit -m 'first commit'
git remote add origin git@github.com:shantanuo/syllabalize_unicode.git
git push -u origin master


Existing Git Repo?

cd existing_git_repo
git remote add origin git@github.com:shantanuo/syllabalize_unicode.git
git push -u origin master


clone (download) the source
git clone git@github.com:ahiguti/HandlerSocket-Plugin-for-MySQL.git


Install MySQL

mkdir download
cd download
wget files.directadmin.com
wget files.directadmin.com
wget files.directadmin.com
wget files.directadmin.com

The commands are as follows:

rpm -iUh *

After installing mysql shared compact library, this was working as expected

wget ftp://ftp.isu.edu.tw/pub/Unix/Database/MySQL/Downloads/MySQL-5.5/MySQL-shared-compat-5.5.24-1.el6.x86_64.rpm
rpm -ihv MySQL-shared-compat-5.5.24-1.el6.x86_64.rpm
yum install php-mysql --skip-broken


Here is how it can be achieved using remi or epel

/usr/bin/wget rpms.famillecollet.com
/bin/rpm -Uvh .rpm
/usr/bin/yum install --enablerepo=remi mysql-server.x86_64

Using epel:

wget download.fedoraproject.org
rpm -Uvh epel-release-5-4.noarch.rpm
yum install python26

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


SSH Tunneling

Tunneling an ssh connection through an ssh connection is completely lawful, but you need to pick unused ports for your forwarding listeners.

ssh user@100.100.100.100 -L 2201:192.168.25.100:22

then
ssh localhost -p 2201

You should end up on server B (unless something's already bound to local:2201, in which case, pick another port).


There are times when you need to connect to a remote server through some other server. You can skip logging to an intermediate server and connect directly to remote server using SSH like this...

ssh -t -t root@192.168.1.1 "ssh -i /root/remote_server.pem ec2-1-2-3-4.compute-1.amazonaws.com"

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


setting cron from a file

To upload the cron job from a file to another user, combine it with -u option.

crontab -u root /home/oracle/mycronjobs.txt

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


log output as well as show on screen

log a command to console and to 2 files separately stdout and stderr

command > >(tee stdout.log) 2> >(tee stderr.log >&2)


Real full backup copy of /etc folder

rsync -a /etc /destination

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


yum install tips!

If your repository is available on a server for e.g. 10.10.10.6, you need to point it to that server in your config file.

cat /etc/yum.repos.d/rhel.repo

[base]
name=RHEL 5 $releasever - $basearch - Base
baseurl=10.10.10.6
enabled=1
gpgcheck=0

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


Net connectivity from server

If the internet is not working from a server, you need to change one file.

cat /etc/resolove.conf

nameserver 8.8.8.8
nameserver 10.10.10.1
nameserver 10.10.10.6

/etc/init.d/network restart

The mail command will not work if the internet is down.

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


Cache Service installation

Download and Install redis from www.redis.io or use the following commands on the target server.

$ wget redis.googlecode.com
$ tar xzf redis-2.2.8.tar.gz
$ cd redis-2.2.8
$ make

Start the redis server. To start the redis server please use the following command
$src/redis-server

configure the redis server ip in the Java properties file (cache.server) and ip (cache.port). The default port is 6379.

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


Set the correct date under linux

Important things to remember about Linux date:

  • /etc/sysconfig/clock sets whether the hardware clock is stored as UTC or local time.
  • Symlink /etc/localtime to /usr/share/zoneinfo/... to set your timezone.
  • Run ``date MMDDhhmm'' to set the current system date/time.
  • Type ``/sbin/hwclock --systohc [--utc]'' to set the hardware clock.

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


Using memory as device

// copy the file to RAM - 30 times faster
cp -af /root/100mb.bin /dev/shm/

// increase it to 4GB
mount -o remount,size=4G /dev/shm

// new memory device
mkdir -p /var/www/www.mysite.com/ramdrive
mount -t tmpfs -o size=500M,mode=0744 tmpfs /var/www/www.mysite.com/ramdrive

// add it to /etc/fstab to make it permanent:
tmpfs /var/www/www.mysite.com/ramdrive tmpfs size=500M,mode=0777 0 0

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


show processlist

ps aux
When you run ps you will only get the first 40 or so characters displayed. In order to view the entire string, use ...
ps auxgww

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


Online for 6605 days
Last modified: 4/12/20 2:01 PM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
September 2020
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
27282930
April
Recent updates
important leafy vegetables 1. Amaranthus
caudatus: rajgira. 2. Amaranthus tricolor: Math.  (Chhoti Chulai- Hindi, Cheera-...
by shantanuo (4/12/20 2:01 PM)
program creek program creek
seems to be a good site for handy references of python...
by shantanuo (4/11/20 11:24 AM)
Standard out to a file
This code will change the standard out to a file...
by shantanuo (4/11/20 11:18 AM)
Create config file for AWS
command line tool While creating amazon config file in a...
by shantanuo (2/20/20 6:00 AM)
setting colors in pandas This
is how to set the colors in pandas mapper =...
by shantanuo (2/20/20 5:53 AM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20 10:33 AM)
access AWS API gateway using
python Amazon API gateway allows us to host server-less API's...
by shantanuo (2/16/20 9:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20 10:28 AM)
backup mysql users  3
steps to install perconal utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
by shantanuo (2/13/20 1:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20 1:30 PM)
apply colors to pandas Here
is how to change the color of negative values to...
by shantanuo (2/12/20 8:57 AM)
Holidays in India These are
the common holidays celebrated in India (Mumbai) during 2016 -...
by shantanuo (2/11/20 1:53 PM)
change log file size in
MySQL Here are the steps to be followed while changing...
by shantanuo (2/11/20 10:38 AM)
MySQL common error messages 1146
Table does not exist 1054 column does not exist 1062...
by shantanuo (2/11/20 10:13 AM)
ipython parallel demo First start
ipython in cluster mode ipcluster start -n 4 from IPython.parallel...
by shantanuo (2/9/20 9:02 AM)
djanog settings You may see
this message if you have DEBUG = True in your...
by shantanuo (2/9/20 4:07 AM)
clear tmp folder Here is
following commands to clear unwanted stuff from the /tmp partition...
by shantanuo (2/8/20 2:41 PM)
change your server time to
IST If you need to change your server clock to...
by shantanuo (2/8/20 2:39 PM)
Transfer root emails to another
email address If you have root access to the server...
by shantanuo (2/8/20 2:32 PM)
special strings in cron Instead
of the first five fields, you can use any one...
by shantanuo (2/8/20 2:30 PM)
LibreOffice version conflict I am
not able to install latest version of Libre office. I...
by shantanuo (1/29/20 9:15 AM)
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20 12:24 PM)
compare mysql schema And here
is poor man's schema compare using good old diff command......
by shantanuo (1/26/20 11:49 AM)
Selecting from error log grep
"error" error_log |awk -F[ {'print $4'} \ | sort |...
by shantanuo (1/26/20 10:40 AM)
Rank mysql records using variables
SET @rank = 0, @prev_val = NULL; SELECT rank, correct...
by shantanuo (1/26/20 9:45 AM)

RSS feed

Made with Antville
Helma Object Publisher