Всё о немногом и немного обо всём

vim

2015-08-25T06:04:00.002-07:00

\c is good to know when your working on other people's stations.

/\croot

:set ic
:set scs

rsync speed

2015-08-25T06:04:00.001-07:00

-e "ssh Ciphers=arcfour"
"ssh Compression=no"

Подключение к консоли через Serial port в Proxmox/KVM

2015-08-25T06:04:00.000-07:00

Кратко, чтобы не забылось опишу настройку подключения к serial port для линукс гостя в Proxmox.
Подключение к сералпорту позволяет работать зайти в консоль виртуалки подобно как в OpenVZ: vzctl enter <CTID>
Включаю сериал консоль для виртуаки ид 101

В хост системе
В файл /etc/pve/qemu-server/101.conf добавляю строку

args: -vnc 127.0.0.1:101,5959 -serial unix:/var/run/qemu-server/101.serial,server,nowait

В виртуалке

В файле /etc/default/grub изменить
GRUB_CMDLINE_LINUX_DEFAULT="console=ttyS0,115200n8"

Для дебиана в /etc/inittab добавить строку
6:2345:respawn:/sbin/getty -L ttyS0 115200 vt102

Для убунту создать файл /etc/init/ttyS0.conf
start on stopped rc or RUNLEVEL=[12345]
stop on runlevel [!12345]
respawn
#exec /sbin/getty -l /usr/local/bin/autologin -n -L ttyS0 115200 vt102
exec /sbin/getty -L ttyS0 115200 vt102

Далее для удобства подключения к консоли создаём файл serial-connect-vd101.sh с содержанием
#!/bin/sh

socat unix-connect:/var/run/qemu-server/101.serial PTY,link=/tmp/pty-101 &
screen /tmp/pty-101

и сделам файл исполняемым
chmod +x serial-connect-vd101.sh

Готово.

SoapUI - использование Groovy Script в TestCase и для установки свойств проекта

2015-08-25T06:03:00.000-07:00

import groovy.json.JsonSlurper;
  
def res = new JsonSlurper().parseText( context.expand( '${post-topic#response}' ));
log.info "topic id:" + res.id;
testRunner.testCase.testSuite.project.setPropertyValue("topicId", "${res.id}" ) ;

post-topic - название шага в TestCase

Кол-во активных подключений к серверу с определением региона (GeoIP)

2014-03-10T14:22:00.000-07:00

#!/usr/bin/python
# 'apt-get install python-geoip' if needed
import GeoIP,os

stream = os.popen("netstat -tna | awk -F' +|:' '/:80/ {print $6}' | sort | uniq -c | sort -n ")
gi = GeoIP.new(GeoIP.GEOIP_MEMORY_CACHE)
s=0
for line in stream.readlines():
    line = line.strip()
    l =line.split() # strip the last from the line
#    print l
    print l[0], "\t",l[1],"\t", gi.country_code_by_addr(l[1])
    s+=int(l[0])

print 'Total:',s

Печать буклета на принтер без двухсторонней печати

2013-12-06T11:30:00.001-08:00

psnup -c -4 original.ps | psbook | psnup -l -pa4 -b27 -m10 -d -2 > out.ps

vzlist

2012-11-05T11:00:00.000-08:00

vzlist -o laverage,hostname,ctid

vztop.sh

#! /bin/bash
# Usage: ovzps <CTID> [ps flags ...]

ctid=${1:-0}
shift

ps $* -p $(grep -l "^envID:[[:space:]]*$ctid\$" /proc/[0-9]*/status |
sed -e 's=/proc/$[0-9]*$/.*=\1=')

Error SSH: Read from socket failed: Connection reset by peer

2012-10-21T14:40:00.004-07:00

Проблема в новом клиенте SSH (OpenSSH_5.8p1 Debian-7ubuntu1, OpenSSL 1.0.0e 6 Sep 2011)
при коннекте получаю:

Read from socket failed: Connection reset by peer

Ошибка чиниться добавлением параметра при подключении

ssh root@host -c aes256-ctr

или в /etc/ssh/ssh_config

Host *
Ciphers 3des-cbc

или же

Ciphers aes256-ctr,arcfour256,arcfour128,aes128-cbc,3des-cbc

Источник: https://bugs.launchpad.net/ubuntu/+source/openssh/+bug/708493

mysqlcheck

2012-05-11T09:38:00.001-07:00

http://www.informit.com/articles/article.aspx?p=174365&seqNum=5

php disable_functions

2012-04-09T07:30:00.005-07:00

disable_functions = "apache_child_terminate, apache_setenv, define_syslog_variables, escapeshellarg, escapeshellcmd, eval, exec, fp, fput, ftp_connect, ftp_exec, ftp_get, ftp_login, ftp_nb_fput, ftp_put, ftp_raw, ftp_rawlist, highlight_file, ini_alter, ini_get_all, ini_restore, inject_code, openlog, passthru, php_uname, phpAds_remoteInfo, phpAds_XmlRpc, phpAds_xmlrpcDecode, phpAds_xmlrpcEncode, popen, posix_getpwuid, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid, posix_setuid, posix_setuid, posix_uname, proc_close, proc_get_status, proc_nice, proc_open, proc_terminate, shell_exec, syslog, system, xmlrpc_entity_decode,mail"

disable_functions= "exec,passthru,shell_exec,system,proc_open,popen,parse_ini_file,show_source "

for VirtualMin

#!/bin/bash
cd /home

for i in `ls`; do
   dir=/home/$i/etc/php5
   if [ -d $dir ]; then

        cd  $dir
        lsattr php.ini
        chattr -i php.ini
        sed -i.bak -e "s@\W*open_basedir\s*=.*@open_basedir = /home/$i@" \
        -e 's@\W*disable_functions\s*=.*@disable_functions = "apache_child_terminate, apache_setenv, define_syslog_variables, escapeshellarg, escapeshellcmd, eval, exec, fp, fput, ftp_connect, ftp_exec, ftp_get, ftp_login, ftp_nb_fput, ftp_put, ftp_raw, ftp_rawlist, highlight_file, ini_alter, ini_get_all, ini_restore, inject_code, openlog, passthru, php_uname, phpAds_remoteInfo, phpAds_XmlRpc, phpAds_xmlrpcDecode, phpAds_xmlrpcEncode, popen, posix_getpwuid, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid, posix_setuid, posix_setuid, posix_uname, proc_close, proc_get_status, proc_nice, proc_open, proc_terminate, shell_exec, syslog, system, xmlrpc_entity_decode,mail"@' php.ini
        chattr +i php.ini
   else
        echo $i empty           
   fi;
done

openmeetings over proxy

2012-03-31T07:25:00.000-07:00

Relevant section of openmeetings virtual host:

<VirtualHost *:80>
        ServerAdmin developer@xxxxxxxxxxxx
        ServerName openmeetings.mydomain.com

        ProxyPass / http://openmeetings.mydomain.com:5080/
        ProxyPassReverse / http://openmeetings.mydomain.com:5080/
...
</VirtualHost>

Relevant section of openmeetings-rtmpt virtual host:

<VirtualHost *:80>
        ServerAdmin developer@xxxxxxxxxxxx
        ServerName rtmpt.mydomain.com

        ProxyPass /openmeetings http://openmeetings.mydomain.com:5080/openmeetings
        ProxyPassReverse /openmeetings http://openmeetings.mydomain.com:5080/openmeetings

        ProxyPass / http://openmeetings.mydomain.com:8088/
        ProxyPassReverse / http://openmeetings.mydomain.com:8088/
...
</VirtualHost>

OpenMeetings config:

red5/webapps/openmeetings/config.xml:

<rtmphostlocal>rtmpt.mydomain.com</rtmphostlocal>

<rtmpTunnelport>80</rtmpTunnelport>

<red5httpport>80</red5httpport>

--

программы и скрипты для мониторинга здоровья системы

2012-02-27T15:29:00.000-08:00

top
htop
atop
iotop
sysstat: sar iostat
vmstat
ps .....
netstat .....
lsof
fuser
smem
pmap
ps -e -O rss,user | awk '/php[^[]/{sum+=$2}END{print sum}'

Prestashop multishop

2012-02-27T15:17:00.004-08:00

1) make soft link of image folder from main shop to new shop

ln -fs main_shop/img new_shop/img

2)Rename new_shop_db and main_shop_db to your names in sql procedure and run sql script

DELIMITER $$
DROP PROCEDURE if exists make_linked_tables $$

CREATE PROCEDURE make_linked_tables() 
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE str VARCHAR(250);
DECLARE cur CURSOR FOR 
 SELECT table_name FROM information_schema.tables WHERE 
table_schema = 'new_shop_db' AND (table_name LIKE 'ps_product%'
OR  table_name LIKE 'ps_category%') 
UNION
SELECT 'ps_image'
UNION
SELECT 'ps_image_lang'
;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur;
REPEAT
 FETCH cur INTO str;
 SET @s = CONCAT("RENAME TABLE ", str," TO ");
 SET @s = CONCAT(@s,str,"_orig");
 PREPARE sth FROM @s;
 EXECUTE sth;
 DEALLOCATE PREPARE sth;

 SET @s = CONCAT("CREATE VIEW ",str," as SELECT * FROM main_shop_db.",str);
 PREPARE sth2 FROM @s;
 EXECUTE sth2;
 DEALLOCATE PREPARE sth2;

UNTIL done END REPEAT;
CLOSE cur;
END$$
DELIMITER ;

3)Run procedure

CALL make_linked_tables();
DROP PROCEDURE if exists make_linked_tables;

Manually customize categories list of new shop:

drop table if exists ps_category;
create OR replace view ps_category AS
SELECT * FROM MAIN_SHOP_DB.`ps_category` WHERE 
id_category in ( 1,17,28,35) OR id_parent in (17,28,35);

drop table if exists ps_category_group;
create OR replace view ps_category_group AS
SELECT * FROM MAIN_SHOP_DB.`ps_category_group` WHERE 
id_category in ( SELECT id_category FROM `ps_category` ) ;

drop table if exists ps_category_lang;
create OR replace view ps_category_lang AS
SELECT * FROM MAIN_SHOP_DB.`ps_category_lang` WHERE 
id_category in ( SELECT id_category FROM `ps_category`);

drop table if exists ps_category_product;
create OR replace view ps_category_product AS
SELECT * FROM MAIN_SHOP_DB.`ps_category_product` WHERE 
id_category in ( SELECT id_category FROM `ps_category`) ;

There are  id_category = 1 - main category(required), 17(subcategory optional)  ....

custom php.ini для fastcgi

2012-01-25T13:09:00.001-08:00

php5.fcgi :

#!/bin/bash

PHPRC=$PWD/../etc/php5

#PHPINIDir=$PWD/../etc/php5

#PHP_INI_SCAN_DIR=$PWD/../etc/php5/conf.d

#export PHPINIDir

#export PHP_INI_SCAN_DIR



export PHPINIDIR=$PWD/../etc/php5

export PHP_INI_PATH=$PWD/../etc/php5



export PHPRC

umask 022 

export PHP_FCGI_CHILDREN

SCRIPT_FILENAME=$PATH_TRANSLATED

export SCRIPT_FILENAME

exec /usr/bin/php5-cgi

или же в php.ini раскоментировать строчку

; Name for user-defined php.ini (.htaccess) files. Default is ".user.ini"
user_ini.filename = ".user.ini"

и в корневой вебдиректории можно создать файл .user.ini и писать в него конфигурацию php

bash Test

2012-01-25T07:16:00.001-08:00

http://www.ibm.com/developerworks/library/l-bash-test/index.html

установка Gimp 2.7 на Ubuntu

2012-01-25T06:34:00.000-08:00

Ура! в GIMP 2.7 появилась наконец-то опция всё в одном окне.
Устанавливаю по инструкции
http://www.gimpusers.com/tutorials/compiling-gimp-for-ubuntu

манипуляция строками в bash

2012-01-25T05:41:00.000-08:00

a="aaa/bbbb.t"
# удалить с начала строки макс. вхождений
echo "${a##*/}"
# удалить с начала строки мин. вхождений
echo "${a#*/}"
# удалить с конца строки мин. вхождений
echo "${a%/}"
# удалить с конца строки макс. вхождений
echo "${a%%/}"
# замена первой найденой подстроки
echo "${a/a/_}"
# замена всех найденых подстрок
echo "${a//a/_}"

источник: http://tldp.org/LDP/abs/html/string-manipulation.html

Git INFO Common Commands

2012-01-25T05:23:00.000-08:00

Configure Git client options:
# show config options
git config --list # show all
git config --global --list # show only global
git config --local --list # show only local

# --global option impacts options at a global level
# --local option impacts options at a local level (.git/config)
# set username/email associated with client
git config --global user.email "joe@example.com"
git config --global user.name "Joe Jaz"

# add color syntax highlighting
git config --global color.status auto
git config --global color.branch auto

# set default pager and editor
git config --global core.editor vim # or set the GIT_EDITOR environment variable
git config --global core.pager less # or set the GIT_PAGER environment variable

# display an option value
git config group.value
git config user.name

Start a new repository and import:
# In the root folder to add to version control:
git init
git init --bare # creates a new repository (with no working copy)
git add . # add everything in directory to repo
git commit -m 'initial commit'

Making commits:
# commit specific files
git commit file1 file2 -m 'comment'

# commit all 'added' files
git commit -a -m 'comment'

# change a commit message
git commit --amend -m 'New Message'

Create new repository by cloning existing one:
git clone --bare . path_or_url_to_git_dir.git

Setting the remote repository (to push and pull from):
git remote add short_name path_or_url_to_git_dir.git
git remote add origin git://github.com/imagescape/iscape-authlog.git

Show remote branches:
git ls-remote orig
git remote show orig

Show remote repositories available:
git remote
git remote -v # show the url
git remote show origin # show detail information about origin

Remove a remote repository:
git remove repo_name

Rename a remote repository:
git rename old_repo_name new_repo_name

Push and Pull from remote repository:
git push origin # push recent commits to remote repository called "origin"
git pull origin # pull updates from origin

Revert changes in working copy:
git clean -n
git clean --dry-run

Show file differences:
git diff # show differences between working copy and any files staged for commit
git diff --staged # compares staged changes with last commit
git diff --cached # same as above for git older than 1.6.1

Show File/s History:
git log filename # Show single file versions

# Show number of lines changed in file/s
git log -stat filename # single file
git log -stat # multiple files

# show log summaries on one line
git log --pretty=oneline # Pre-defined format
git log --pretty=format:"%h - %cD (%an) %s" # custom format (see below)
git log --pretty=format:"%h %s" --graph

Pre-Defined Pretty formats:
oneline
short
medium
full
fuller
email
raw
format:string # where string is

Format Strings
%H: commit hash
%h: abbreviated commit hash
%T: tree hash
%t: abbreviated tree hash
%P: parent hashes
%p: abbreviated parent hashes
%an: author name
%aN: author name (respecting .mailmap, see git-shortlog(1) or git-blame(1))
%ae: author email
%aE: author email (respecting .mailmap, see git-shortlog(1) or git-blame(1))
%ad: author date (format respects --date= option)
%aD: author date, RFC2822 style
%ar: author date, relative
%at: author date, UNIX timestamp
%ai: author date, ISO 8601 format
%cn: committer name
%cN: committer name (respecting .mailmap, see git-shortlog(1) or git-blame(1))
%ce: committer email
%cE: committer email (respecting .mailmap, see git-shortlog(1) or git-blame(1))
%cd: committer date
%cD: committer date, RFC2822 style
%cr: committer date, relative
%ct: committer date, UNIX timestamp
%ci: committer date, ISO 8601 format
%d: ref names, like the --decorate option of git-log(1)
%e: encoding
%s: subject
%f: sanitized subject line, suitable for a filename
%b: body
%B: raw body (unwrapped subject and body)
%N: commit notes
%gD: reflog selector, e.g., refs/stash@{1}
%gd: shortened reflog selector, e.g., stash@{1}
%gs: reflog subject
%Cred: switch color to red
%Cgreen: switch color to green
%Cblue: switch color to blue
%Creset: reset color
%C(…): color specification, as described in color.branch.* config option
%m: left, right or boundary mark
%n: newline
%%: a raw %
%x00: print a byte from a hex code
%w([[,[,]]]): switch line wrapping, like the -w option of git-shortlog(1).

Show git branches available:
git branch

Show all branches including remote branches:
git branch -a

Create new branch:
git branch new_branch

Change branches:
git checkout new_branch

Delete branch:
git branch -D new_branch

Merge branch into current copy:
git merge branch_to_merge_in

Resolve a Merge:
1) Edit file to resolve
2) git add conflict_file
3) git commit

Undo a Merge: # restores state to pre-merge
git reset --heard HEAD

~/.gitignore

[color]
 diff = auto
 status = auto
 branch = auto
[user]
 name = Joe Jaz
 email = joe@example.com
[alias]
 st = status
 stu = status -uno
 ci = commit
 co = checkout
 br = branch -v
 tree = log --graph --pretty=oneline --abbrev-commit --decorate
[core]
 editor = vim
 pager = less

References:
http://jonas.nitro.dk/git/quick-reference.html
http://www.vogella.de/articles/Git/article.html#git_stagingindex
http://book.git-scm.com/3_basic_branching_and_merging.html

redmine эмайл увидомления с приложениями

2012-01-22T07:33:00.000-08:00

Патч добавляющий в тело эмайла ссылки на приложения к задачи
http://pastebin.com/p0Esq3iP

diff --git a/app/models/attachment.rb b/app/models/attachment.rb
index ff434d8..0a7e69a 100644
--- a/app/models/attachment.rb
+++ b/app/models/attachment.rb
@@ -116,6 +116,11 @@ class Attachment < ActiveRecord::Base
   def deletable?(user=User.current)
     container.attachments_deletable?(user)
   end
+  
+  # my fix for email attachment
+  def to_s
+        self.filename
+  end
 
   def image?
     self.filename =~ /\.(jpe?g|gif|png)$/i
diff --git a/app/views/mailer/_issue_text_html.rhtml b/app/views/mailer/_issue_text_html.rhtml
index 3d851d4..06f0aec 100644
--- a/app/views/mailer/_issue_text_html.rhtml
+++ b/app/views/mailer/_issue_text_html.rhtml
@@ -7,6 +7,16 @@
 <li><%=l(:field_assigned_to)%>: <%=h issue.assigned_to %></li>
 <li><%=l(:field_category)%>: <%=h issue.category %></li>
 <li><%=l(:field_fixed_version)%>: <%=h issue.fixed_version %></li>
+<% if issue.attachments.size > 0 %>
+    <li>
+        <ul>
+           <%=l(:label_attachment)%>: 
+           <% issue.attachments.each do | c | %>
+               <li> <%= link_to(c.to_s(), "http://redmine.tnt.it-solutions.cz/attachments/"+ c.id.to_s() + "/" + c.to_s() ) %> </li>
+        <% end %>
+        </ul>
+    </li>
+<% end %>
 <% issue.custom_field_values.each do |c| %>
   <li><%=h c.custom_field.name %>: <%=h show_value(c) %></li>
 <% end %>
diff --git a/app/views/mailer/_issue_text_plain.rhtml b/app/views/mailer/_issue_text_plain.rhtml
index bea2a58..5e49b99 100644
--- a/app/views/mailer/_issue_text_plain.rhtml
+++ b/app/views/mailer/_issue_text_plain.rhtml
@@ -7,6 +7,7 @@
 <%=l(:field_assigned_to)%>: <%= issue.assigned_to %>
 <%=l(:field_category)%>: <%= issue.category %>
 <%=l(:field_fixed_version)%>: <%= issue.fixed_version %>
+<% if issue.attachments.size > 0 %><%=l(:label_attachment)%>: <%= issue.attachments.join(", ") %><% end %>
 <% issue.custom_field_values.each do |c| %><%= c.custom_field.name %>: <%= show_value(c) %>
 <% end %>

perl oneliner

2012-01-20T04:13:00.001-08:00

perl -n -e 'm/(?:[^\d.])((?:\d*)(?:(\.\d{0,2})?))(?:\s\&euro)/ && {print "$1\n"}'

java

2011-12-28T15:52:00.000-08:00

http://zetcode.com/tutorials/jeetutorials/javaservers/
http://www.java2s.com/
http://www.vogella.de/java.html
http://www.discursive.com/books/cjcook/reference/book-cjcook.html

http://www.discursive.com/books/cjcook/reference/app-infra-sect-composite-config.html

http://www.javafaq.nu/topics.html

Обновление Cyrus 2.1 на 2.2

2011-12-14T06:50:00.000-08:00

После апгрейда убунты на 10,04 перестал запускаться cyrus. Вылитает ошибка:

/etc/init.d/cyrus2.2: Database backends mismatch! You must manually
/etc/init.d/cyrus2.2: verify and update the Cyrus databases to the
/etc/init.d/cyrus2.2: new backends.
/etc/init.d/cyrus2.2: Please refer to /usr/share/doc/cyrus-common-2.2/README.Debian
/etc/init.d/cyrus2.2: for instructions.

Лекарство:

# делаем бекап системных файлов
cd /var/lib
tar cfvz cyrus-backup.tgz cyrus
# при необходимости бекап почтовых ящиков
tar cfvz cyrus-spool-backup.tgz /var/spool/cyrus

#
rm /usr/lib/cyrus/cyrus-db-types.active
sudo chown -R cyrus:mail /var/lib/cyrus
dpkg-reconfigure cyrus-common-2.2

Doctrine Versionable: получить все версии объекта

2011-12-02T07:34:00.000-08:00

Процесс создания модели у которой ведётся сохрание изменений
http://www.doctrine-project.org/documentation/manual/1_0/en/behaviors#core-behaviors:versionable

там описана возможность получить текущую версию объекта

$blogPost->version;

и откатить изменения при помощи метода

$blogPost->revert(1);

Чтобы получить все версии $blogPost:
$blogPost->getVersion()

UTF 8 and my.cnf

2011-11-25T03:50:00.001-08:00

Settings for mysql that will help ensure Unicode top to bottom.

[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'

[client]
default-character-set=utf8

Ubuntu/Debian downgrade php5.3 to 5.2

2011-11-22T10:42:00.000-08:00

Делаю downgrade в Lucid только для следующих пакетов в версии из репозитария Hardy

vim /etc/apt/preferences.d/php5-pin

Package: php5-cgi
Pin: release a=hardy
Pin-Priority: 1001

Package: libapache2-mod-php5
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-common
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-cli
Pin: release a=hardy
Pin-Priority: 1001

Package: php-auth
Pin: release a=hardy
Pin-Priority: 1001

Package: php-pear
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-curl
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-dev
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-gd
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-imagick
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-imap
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-mcrypt
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-mysql
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-sqlite
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-tidy
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-xmlrpc
Pin: release a=hardy
Pin-Priority: 1001

Package: php5-xsl
Pin: release a=hardy
Pin-Priority: 1001

aptitude install php5-cgi php-auth php-pear php5-cli php5-curl php5-dev php5-gd php5-imagick php5-imap php5-mcrypt php5-mysql php5-sqlite php5-tidy php5-xmlrpc php5-xsl