OMGSW Blog

Ansible freebsd ssh connection hung

2015-07-21T15:41:00.004+03:00

Recently I faced with problem which caused almost a week to find right solution

So the problem was that I wasn't able to connect to my freebsd host from ansible server.

so symptoms were like that

sshpass -d6 ssh -C -v -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/michael/.ansible/cp/ansible-ssh-%h-%p-%r" -o StrictHostKeyChecking=no -o GSSAPIAuthentication=no -o PubkeyAuthentication=no -o User=root -o ConnectTimeout=10 192.168.xxx.xxx /bin/csh -c 'LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/local/bin/python'
[............]
Warning: Permanently added '192.168.2.110' (ECDSA) to the list of known hosts.debug1: SSH2_MSG_NEWKEYS sentdebug1: expecting SSH2_MSG_NEWKEYSdebug1: SSH2_MSG_NEWKEYS receiveddebug1: Roaming not allowed by serverdebug1: SSH2_MSG_SERVICE_REQUEST sentdebug1: SSH2_MSG_SERVICE_ACCEPT receiveddebug1: Authentications that can continue: publickey,keyboard-interactivedebug1: Next authentication method: keyboard-interactive

ansible new-hosts -l freebsd.local -m shell -a 'uptime' -vvv

<192.168.2.110> ESTABLISH CONNECTION FOR USER: root

<192.168.2.110> REMOTE_MODULE command uptime #USE_SHELL

<192.168.2.110> EXEC sshpass -d6 ssh -C -v -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/michael/.ansible/cp/ansible-ssh-%h-%p-%r" -o StrictHostKeyChecking=no -o GSSAPIAuthentication=no -o PubkeyAuthentication=no -o User=root -o ConnectTimeout=10 192.168.xxx.xxx /bin/sh -c 'LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/local/bin/python'

and in that state connection could be couple of hours without any output on ansible server or freebsd logs.

The reason of the problem was FreeBSD PAM module

I had to change line 12 (in my case ) in /etc/pam.d/sshd

was :

auth required pam_unix.so no_warn try_first_pass

become:

auth required pam_unix.so no_warn try_first_pass authtok_prompt=Password:

no sshd restart required

after that changes I was able to get info from my freebsd hosts

ansible new-hosts -l freebsd.local -m ping

freebsd.local | success >> {

"changed": false,

"ping": "pong"

}

ansible new-hosts -l freebsd.local -m shell -a 'uptime'

freebsd.local | success | rc=0 >>

2:30PM up 4 days, 45 mins, 2 users, load averages: 0.11, 0.09, 0.07

installing ffmpeg-php with php5.3+

2014-01-20T23:04:00.001+02:00

the main purpose of this small note is to save your time from the mistakes I've made

so what we have:

centos 5 or 6
php 5.3, 5.4 or 5.5

and great desire to have ffmpeg-php installed on that server :)

so

wget http://sourceforge.net/projects/ffmpeg-php/files/ffmpeg-php/0.6.0/ffmpeg-php-0.6.0.tbz2/download
tar xf ffmpeg-php-0.6.0.tbz2
cd ffmpeg-php-0.6.0
phpize
./configure
and right before make we will do a magic

1) vi ffmpeg_frame.c
:%s/PIX_FMT_RGBA32/PIX_FMT_RGB32

2) vi ffmpeg_movie.c
row 311: list_entry *le; TO zend_rsrc_list_entry *le;
row 346: list_entry new_le; TO zend_rsrc_list_entry new_le;
row 360: hashkey_length+1, (void *)&new_le, sizeof(list_entry), TO hashkey_length+1, (void *)&new_le,sizeof(zend_rsrc_list_entry),

make && make install

Push to multiple remote repositories from a single local repo in Mercurial

2013-05-13T00:02:00.001+03:00

You can set multiple remote repository aliases in the [paths] section of the repository configuration file. This file is in .hg/hgrc, and you would add paths like this:

[paths]

default = http://your-default-repo.com/repo

2nd = http://your-second-repo.com/repo

Then you would run hg push 2nd to push to your second repo and hg push to push to your default repo.

Unfortunately its not possible to run  hg push * to push to all remote hosts at once, you have to specify

each push destination one by one.

view confs without comments

2012-08-09T10:58:00.000+03:00

Just to note to myself. how to generate clean configs w/out any comments

sed -e '/^$/d;/^#/d;/^;/d' /etc/php.ini > php.ini.clean

result

root@ ~ # cat /etc/php.ini |wc -l
1249
root@ ~ # cat php.ini.clean |wc -l
182

{new stable release} Zabbix auto install scripts

2012-05-24T00:03:00.003+03:00

!!!NOTE: this scripts only for education/testing/investigation purposes, use on your own risk

I've prepared 2 auto Zabbix 2.0.0 installation scripts, tested on Centos 5.8 and 6.2

https://www.dropbox.com/s/pdekmf5yi6on8o3/zabbix20_el6_install.sh << Centos 6.2
https://www.dropbox.com/s/6sdlerh4ufthys4/zabbix20_el5_install.sh << Centos 5.8

short desc

#!/bin/sh

#

# Centos 6.2 (5.8) zabbix 2 install w/ psql9.1 jabber IPv6 support

#

# known problems:

# zabbix web config not fully configured during installation

# need manually to setup $ZBX_SERVER and $ZBX_SERVER_NAME parameters after installation finish

# after installation rpm prepared and it is in /root/rpmbuild/RPMS/

# do not know why but in this version zabbix won't work with DB user other than root had to create role for root

#

# reboot required after installation

#

# software distributed under the License is distributed on an "AS IS" BASIS,  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND

# (c) Michael Veselovski support@omgsw.com

# v1: initial release 4/10/2011

# v2: 24/12/2011 new release:

# - psql 9.1 support added

# - db user should be provided during installation

# - zabbix 1.9.8 support added

# v3.1: 15/05/2012 new release

# - script complete rewitten for Centos 6.2 suppport

# - script installing Zabbix 2.0.0rc4 /psql

# v3.2: 15/05/2012 second script for Centos 5.8

# - separate script for Centos 5.8

# v4: 23/05/2012 script for zabbix 2.0.0

# - same problems as above

{new release} Zabbix auto install scripts

2012-05-15T15:13:00.001+03:00

!!!NOTE: this scripts only for education/testing/investigation purposes, use on your own risk

I've prepared 2 auto Zabbix 2.0.0rc4 installation scripts, tested on Centos 5.8 and 6.2

https://www.dropbox.com/s/unzvemer4itptdt/zabbix2rc4_el5_install.sh
https://www.dropbox.com/s/88nudr29280xm61/zabbix2rc4_el6_install.sh

short desc

#!/bin/sh

#

# Centos 6.2 (5.8) zabbix 2rc4 install w/ psql9.1 jabber IPv6 support

#

# known problems:

# zabbix web config not fully configured during installation

# need manually to setup $ZBX_SERVER and $ZBX_SERVER_NAME parameters after installation finish

# after installation rpm prepared and it is in /root/rpmbuild/RPMS/

# do not know why but in this version zabbix won't work with DB user other than root had to create role for root

#

# reboot required after installation

#

# software distributed under the License is distributed on an "AS IS" BASIS,  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND

# (c) Michael Veselovski support@omgsw.com

# v1: initial release 4/10/2011

# v2: 24/12/2011 new release:

# - psql 9.1 support added

# - db user should be provided during installation

# - zabbix 1.9.8 support added

# v3.1: 15/05/2012 new release

# - script complete rewitten for Centos 6.2 suppport

# - script installing Zabbix 2.0.0rc4 /psql

# v3.2: 15/05/2012 second script for Centos 5.8

# - separate script for Centos 5.8

How to upgrade Joomla from 1.5/1.6 to 2.5

2012-05-07T13:00:00.000+03:00

BEFORE APPLYING ANY CHANGES YOU SHOULD CREATE A BACKUP

1) Go to http://domain/administrator => Extensions => Install/Uninstall => Upload Package File “com_jupgrade-2.5.1.zip” => Upload File & Install

2) Extensions => Plugin Manager => find “System - Mootools Upgrade” => Enabled “Yes”

3) create “jupgrade”subfolder in RootDirectory (/var/www/public_html/jupgrade), change owner to Apache user and change permissions to “777”

4) Download “http://joomlacode.org/gf/download/frsrelease/16804/73116/Joomla_2.5.3-Stable-Full_Package.zip” (download link: http://joomlacode.org/gf/project/joomla/frs/) to this directory (./jupgrade) and unpack

5) Go to http://domain/administrator => Components => Jupgrade => Parameters:
Distribution => Joomla 2.5
Skip checks => Yes
Skip Download => Yes
Skip Decompress => Yes
Enable migration debug => Yes
Enable Mootools version debug => Yes
DO NOT FORGET “Save” on the top and close this window.

6) Press “START UPGRADE”

7) After upgrade you should check all links. You may do that via “Xenu's Link Sleuth”.
This program works under Fedora, Red Hat, Ubuntu (use Wine) and Windows.
You may download it from “http://home.snafu.de/tilman/XENU.ZIP”, just unzip, install and start under Wine.
1) Go to “File => Check URL”
2) Enter “http://domain/jupgrade/”, NOT http://domain/jupgrade, DO NOT FORGET the last “/”.
(More about this program: http://home.snafu.de/tilman/xenulink.html)

8) If all looks fine - create another subfolder “my_old_joomla” in RootDirectory and move all content FROM RootDirectory to this subdirectory (from /var/www/public_html/ to /var/www/public_html/my_old_joomla) except “jupgrade” and “my_old_joomla” folders.

9) As we can see the RootDirectory is contained only two folders “jupgrade” and “my_old_joomla” you should move all content from /var/www/public_html/jupgrade to /var/www/public_html/

10) That’s all.

(c) Yan Ternovsky

Changing tables engine from MyISAM to InnoDB

2012-05-05T21:25:00.001+03:00

1. Edit /etc/my.cnf , make sure that:

#skip-innodb - commented out

innodb_file_per_table = ON

2. install Percona toolkit

Visit http://www.percona.com/software/percona-toolkit/ to download the latest release of Percona Toolkit. Or, get the latest release from the command line:

 
wget percona.com/get/percona-toolkit.tar.gz

wget percona.com/get/percona-toolkit.rpm

wget percona.com/get/percona-toolkit.deb

You can also get individual tools from the latest release:

 
wget percona.com/get/TOOL 
 

Replace TOOL with the name of any tool.

3. using pt-find convert tables from MyISAM to InnoDB

pt-find db-name --engine MyISAM --exec "ALTER TABLE %D.%N ENGINE=INNODB" --print

[how to]Windows slow download speed

2012-05-05T20:58:00.002+03:00

in case if Windows servers show poor download performance in clouds based on Onapp software its necessary to do the following

Networking: Xen network adapter->Xen network device drivers-> Properties
Configure: -> Properties->Advanced

In advanced properties should be set:
CheckSumOffload-> Disabled
LargeSendOffload->Disabled

and as usual reboot VPS

mdadm

2012-01-20T04:25:00.004+02:00

1. start raid

mdadm --assemble --scan

2. start raid in case if you do not have /etc/mdadm.conf (should have raid UUID)

mdadm /dev/md0 --assemble -u e6d85d3d:d20ddcfc:c7cxxxxx:6a0xxxx

3. generate /etc/mdadm.conf

mdadm --detail --scan >> /etc/mdadm.conf

[mdadm] 2 how-tos

2012-01-10T20:55:00.000+02:00

1. how to cancel sync:

in order to cancel raid sync its necessary to left only one drive as active (we are talking about raid1):

mdadm --fail /dev/md2 /dev/sda3

and we will receive something like that (in my case it was md2 and /dev/sda3):

mdadm --detail /dev/md2
/dev/md2:
        Version : 0.90
Creation Time : Fri Feb 4 21:22:50 2011
     Raid Level : raid1
     Array Size : 1462766336 (1395.00 GiB 1497.87 GB)
Used Dev Size : 1462766336 (1395.00 GiB 1497.87 GB)
   Raid Devices : 2
Total Devices : 2
Preferred Minor : 2
    Persistence : Superblock is persistent

    Update Time : Tue Jan 10 18:37:27 2012
          State : clean, degraded
Active Devices : 1
Working Devices : 1
Failed Devices : 1
Spare Devices : 0

           UUID : 71b91f85:bdd01b3f:776c2c25:004bd7b2
         Events : 0.28394

    Number   Major   Minor   RaidDevice State
       0       0        0        0      removed
       1       8       19        1      active sync   /dev/sdb3

       2       8        3        -      faulty spare   /dev/sda3

/dev/sda3 was set as failed.

2. how to re-add failed disk into existing array and restart scan :)

set disk as failed (we already did that in 1st how-to )
remove device from array

mdadm --remove /dev/md2 /dev/sda3

add device one more time

mdadm --add /dev/md2/ /dev/sda3

We can check the status of the arrays on the system with:

watch -n .1 cat /proc/mdstat

mdadm --detail /dev/md0

Zabbix auto install script

2011-10-04T15:54:00.000+03:00

few weeks ago I've noticed that Zabbix team actively developed version 2 of their nice monitoring tool. I decided to install beta version with Postgresql 9.1. Unfortunately Zabbix 1.9.6 does not support Psql 9.1, but with my help :) they fixed that issue. meanwhile I've prepared script which install zabbix from source on clean Centos with Psql 8.4 support.

there is download link to that script https://www.dropbox.com/s/e205kh9vnwyppp8/zabbix_install_centos.sh

this script will be good for testers, sys admins who want to check new features of zabbix :)

reboot hung server

2011-09-03T18:40:00.002+03:00

The "magic SysRq key" provides a way to send commands directly to the kernel through the /proc filesystem. It is enabled via a kernel compile time option, CONFIG_MAGIC_SYSRQ, which seems to be standard on most distributions. First you must activate the magic SysRq option:

    echo 1 > /proc/sys/kernel/sysrq

When you are ready to reboot the machine simply run the following:

    echo b > /proc/sysrq-trigger

This does not attempt to unmount or sync filesystems, so it should only be used when absolutely necessary, but if your drive is already failing then that may not be a concern.

How to upgrade Postgres 8.4.x to 9.0.x

2011-07-14T02:06:00.000+03:00

I've found a couple of manuals where this procedure is described, but I faced with the problem with postgres-libs which were required for my SVN.

so there is my way how to perfom upgrade

1. service postgresql stop
2. rsync -a -v --progress /var/lib/pgsql/ /var/lib/pgsql.old/ #this will backup everything
3. wget http://yum.pgrpms.org/reporpms/9.0/pgdg-centos-9.0-2.noarch.rpm
4. rpm -i pgdg-centos-9.0-2.noarch.rpm
5. /etc/yum.repos.d/CentOS-Base.repo and add 'exclude=postgresql*' to the [base] and [updates] sections
6. yum remove postgresql84*
7. rpm -e postgresql-libs --nodeps
8. yum install postgresql90 postgresql90-server postgresql90-libs postgresql90-contrib postgresql90-devel
9. service postgresql-9.0 initdb
10. export PATH=/usr/pgsql-9.0/bin:$PATH
11. su - postgres ; export PATH=/usr/pgsql-9.0/bin:$PATH ; pg_upgrade --old-datadir "/var/lib/pgsql.old/data" --new-datadir "/var/lib/pgsql/9.0/data" --old-bindir "/usr/bin" --new-bindir "/usr/pgsql-9.0/bin"
12. cp /var/lib/pgsql.old/data/pg_hba.conf /var/lib/pgsql/9.0/data/pg_hba.conf
13. service postgresql-9.0 start
14. vacuumdb --all --analyze-only

Have fun with new Psql version :)

hackmysql mirror

2011-05-31T16:35:00.000+03:00

I've created mirror of hackmysql for personal usage

replace mysql-server with percona server

2011-05-31T16:28:00.000+03:00

what is percona-server:

Quote:

Percona Server is an enhanced drop-in replacement for MySQL. With Percona Server,

Your queries will run faster and more consistently.
You will consolidate servers on powerful hardware.
You will delay sharding, or avoid it entirely.
You will save money on hosting fees and power.
You will spend less time tuning and administering.
You will achieve higher uptime.
You will troubleshoot without guesswork.

Does this sound too good to be true? It's not. Percona Server offers breakthrough performance, scalability, features, and instrumentation. Its self-tuning algorithms and support for extremely high-performance hardware make it the clear choice for companies who demand the utmost performance and reliability from their database server

now if you want to have such miracle on your cpanel server you need to do this steps for replacing mysql-server with percona-server:

1. backup VPS.
2. dump all dbs.
3. stop all services on the vps

Code:

/etc/init.d/httpd  stop ; /etc/init.d/exim stop ; /etc/init.d/pure-ftpd stop ;  /etc/init.d/dovecot stop ; /etc/init.d/cpanel stop ; /etc/init.d/lfd  stop ; /etc/init.d/munin-node stop ; /etc/init.d/crond stop ;  /etc/init.d/mysql stop ; /etc/init.d/exim stop ;

4. make sure that everything is stopped
5. check what mysql packages are installed

Code:

rpm -qa | grep -i mysql

in my case it was MySQL-client MySQL-devel MySQL-test MySQL-bench MySQL-shared MySQL-server
so I run this command to completely remove mysql from vps

Code:

yum remove MySQL-client MySQL-devel MySQL-test MySQL-bench MySQL-shared MySQL-server

6. add percona repo

Code:

rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

7. check what packages are available in percona repo

Code:

yum list | grep percona

should be something like

Code:

# yum list | grep percona

percona-release.x86_64                    0.0-1                        installed

Percona-SQL-50-debuginfo.x86_64           5.0.92-b23.85.rhel5          percona

Percona-SQL-client-50.x86_64              5.0.92-b23.85.rhel5          percona

Percona-SQL-devel-50.x86_64               5.0.92-b23.85.rhel5          percona

Percona-SQL-server-50.x86_64              5.0.92-b23.85.rhel5          percona

Percona-SQL-shared-50.x86_64              5.0.92-b23.85.rhel5          percona

Percona-SQL-shared-compat.x86_64          5.1.43-2                     percona

Percona-SQL-test-50.x86_64                5.0.92-b23.85.rhel5          percona

Percona-Server-51-debuginfo.x86_64        5.1.56-rel12.7.224.rhel5     percona

Percona-Server-55-debuginfo.x86_64        5.5.11-rel20.2.115.rhel5     percona

Percona-Server-client-51.x86_64           5.1.56-rel12.7.224.rhel5     percona

Percona-Server-devel-51.x86_64            5.1.56-rel12.7.224.rhel5     percona

Percona-Server-server-51.x86_64           5.1.56-rel12.7.224.rhel5     percona

Percona-Server-shared-51.x86_64           5.1.56-rel12.7.224.rhel5     percona

Percona-Server-test-51.x86_64             5.1.56-rel12.7.224.rhel5     percona

gnuplot.x86_64                            4.2.6-14                     percona

gnuplot-emacs.x86_64                      4.2.6-14                     percona

maatkit.noarch                            7284-1                       percona

xtrabackup.x86_64                         1.6-245.rhel5                percona

xtrabackup-debuginfo.x86_64               1.6-245.rhel5                percona

8. decide what version you need 5.1 or 5.5
in my case I've installed percona 5.5

Code:

# rpm -qa | grep Percona

Percona-Server-client-55-5.5.11-rel20.2.115.rhel5

Percona-Server-server-55-5.5.11-rel20.2.115.rhel5

Percona-Server-shared-55-5.5.11-rel20.2.115.rhel5

Percona-Server-shared-compat-5.5.11-rel20.2.115.rhel5

Percona-Server-devel-55-5.5.11-rel20.2.115.rhel5

Percona-Server-test-55-5.5.11-rel20.2.115.rhel5

9. after Percona-server installation it is necessary to check if it started correctly as some variables in my.cnf are not supported.
10. after successful start it is necessary to run mysql_upgrade.
11. for finishing installation run easyapache and recompile apache/php/etc
12. Go to Server Configuration -> Update Config and set MySQL to "never", save, double check it has been done
13. Test new Apache to be sure server is working

add json support into Flex4

2011-03-25T14:31:00.000+02:00

Adobe itself made a JSON library that you can find at https://github.com/mikechambers/as3corelib Follow these steps to add your JSON library to your Flex project:

Download the .zip archive and extract it. What you need is the .swc file in the lib folder.
In Flex Builder / Flash Builder, go to your project’s properties, and then to the Flex Build Path panel.
Click on Add SWC, and select the as3corelib.swc file
In your project, add the following line: import com.adobe.serialization.json.JSON;

You should be able now to use JSON functionalities in your Flex project

where is my free disk space :)

2010-12-17T05:01:00.000+02:00

To list files larger than 10M:
find / -type f -size +10000k -exec ls -lh {} \; | awk '{ print $8 ": " $5 }'

To list files larger than 100M:
find / -type f -size +100000k -exec ls -lh {} \; | awk '{ print $8 ": " $5 }'

how to convert tables to InnoDB

2010-11-29T23:18:00.000+02:00

Using nice tool from Maatkit, we can easy convert tables from any storage engine to other. there is example how to convert from myisam to innodb

mk-find db-name --engine MyISAM --exec "ALTER TABLE %D.%N ENGINE=INNODB" --print

how to install php5.3.x & 5.2.x centos

2010-11-22T22:57:00.002+02:00

there are 3 steps how to install/upgrade php on centos server/vps

1. install webtatic repo:

rpm -ivh http://repo.webtatic.com/yum/centos/5/`uname -i`/webtatic-release-5-1.noarch.rpm

2. install/upgrade php 5.3.x

yum --enablerepo=webtatic install php
yum --enablerepo=webtatic upgrade php

3. install/upgrade php 5.2.x

yum --enablerepo=webtatic --exclude=php*5.3* update php
yum --enablerepo=webtatic --exclude=php*5.3* install php

reset CPAN first run

2010-10-08T18:55:00.000+03:00

to reset CPAN configuration it is necessary to run this command

perl -e "use CPAN::FirstTime; CPAN::FirstTime::init();"

3 ways to reset root password in linux

2010-09-20T14:04:00.000+03:00

today I'm gonna to explain how to reset root password in linux. 2 of this ways can be applied only if you have access to PC physically. 3rd way can be applied if your service provider have recovery console or something like that:)

so lets start:

1 EDITING LOADER (in my case it will be GRUB)

boot machine
when the GRUB menu appears, use arrow keys to choose OS to be booted
press letter "e'' on the keyboard to enter edit mode
use arrow keys to select the kernel line for kernel to be booted
press "e" to edit line
go to end of line and type "single" (without quotes) as a separate word
press ESC key to exit the edit mode
press "b" to boot into single user mode
after booting you can set password for root by running passwd commnad
reboot and login with new pw

2. MAGIC WAY :)

If the easy method doesn't work on your machine, another way to solve the "lost root password" problem is to boot your computer from your Linux Installation CD/DVD, or from a live-CD/DVD such as Knoppix.

Boot with the live-disk then go to a terminal and su to root (no password is required) then issue the following commands (be sure to replace each /sda1 with your own root partition device):

Code:

mount -o dev,rw /mnt/sda1
 
cd /mnt/sda1/etc

Once you are into your system /etc directory, you can use a text editor (vim, nano, pico, etc.) to edit the /etc/shadow file where the password is stored. Various information about root and user accounts is kept in this plain-text file but we are only concerned with the password portion.

For example, the /etc/shadow entry for the "root" account may look something like this:

Code:

root:$1$aB7mx0Licb$CTbs2RQrfPHkz5Vna0.fnz8H68tB.:10852:0:99999:7:::

Now, using your favorite editor (I'll use vim) delete the password hash. For this example, the password is in green text and is all those characters between the 1st and 2nd colons.

Code:

vim shadow

After you've edited this field, it should look like this:

Code:

root::10852:0:99999:7:::

Now save the file and change back to the root directory and unmount the system root partition (don't forget to change the /sda1) as follows:

Code:

cd /
umount /mnt/sda1

Now reboot the computer.

Once the computer has booted and you're at the login prompt, type "root" and when asked for the password just press ENTER (entering no password). After a successful login, you need to set the new password for root using the following command:

Code:

passwd

this way was not tested by me and I found it in google :)
3.RECOVERY CONSOLE or LIVE CD/DVD

1.Boot from LIVECD or in RC
2. mount root partition
- if no raid on server than
mount /dev/hda2 /mnt/newroot
- if you have raid
mount /dev/md1 /mnt/newroot
NOTE make sure that you replace hhd name with your own

3. Bind /dev/random from your server
mount –bind /dev /mnt/newroot/dev
4. changing the root file system. (e.g.):
# chroot /mnt/newroot /bin/bash
5.change root password
passwd
6. reboot in normal mode

installin JDK and JRE gentoo way

2010-09-14T13:21:00.000+03:00

had a task to install JDK and JRE on customer server. And when I found that on server Gentoo has been installed it was too late for me :) ( it is my first experience with Gentoo)

so there are the steps

1. update portage

#emerge --sync

2. install JDK/JRE

# emerge virtual/jdk
or
# emerge virtual/jre

3. Configuring JVM

list of java virtual machines

# java-config --list-available-vms

out put should be like:

# java-config --list-available-vms
The following VMs are available for generation-2:
1)      IcedTea6-bin 1.4.1 [icedtea6-bin]
2)      Sun JDK 1.5.0.20 [sun-jdk-1.5] (Build Only)

3)      Sun JDK 1.6.0.16 [sun-jdk-1.6]

set VM

(By handle (preferred))
# java-config --set-system-vm sun-jdk-1.6
Now using sun-jdk-1.6 as your generation-2 system JVM
(By number)
# java-config --set-system-vm 3
Now using sun-jdk-1.6 as your generation-2 system JVM

ref http://www.gentoo.org/doc/en/java.xml

Mysql master-master replication

2010-09-10T21:11:00.002+03:00

Today I’m going to write a short manual how to create failover mysql cluster.
What we need:

Server1 = master 1/slave2
Server2 = master2/slave2
Internal or external IPs (in this example I will use server1 _ip and server2_ip)
Replication user = replicau

Step-by-step how to:
Step 1.
On server 1 in my.cnf we need to add following lines

[mysqld]
#master config
Server-id =1
Log-bin = mysql-bin
binlog-do-db = test_db
… #we can add as many DB as we need to replicate
#slave config
replicate-do-db = test_db
… #we can add as many DB as we need to replicate
master-host = server2_ip
master-user= replicau
master-password =password_of_user_replicau
master-port = 3306

same lines we should add in my.cnf on server2, the only thing we should change is master-host parameter to use server1_ip instead of server2_ip and change server-id parameter
Step 2
Restart mysql servers
Step 3
On each server we need to create replication user:
Server1

mysql>GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'replicau'@'server2_ip' IDENTIFIED BY 'password';
server2

mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'replicau'@'server1_ip' IDENTIFIED BY 'password';

Step 4
Add server2 as slave to server1
- we need to set read_only parameter as ON on server1 (master 1)

mysql> SET GLOBAL read_only = ON;
mysql> show master status;
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000006 | 7984 | | |
+------------------+----------+--------------+------------------+
1 row in set (0,00 sec)
on server2

mysql>slave stop;
mysql> CHANGE MASTER TO MASTER_HOST = "server2_ip", MASTER_USER = "replicau", MASTER_PASSWORD = "password_of_user_replication", MASTER_LOG_FILE = "mysql-bin.000006", MASTER_LOG_POS = 7984;
mysql> slave start;

on server1

mysql> SET GLOBAL read_only = OFF;

on server2 check connection status

mysql> show slave status;

if we do not receive any errors, everything is perfect 

Step 5
Do Step 4 for connecting server 1 as slave to server2.

Step 6
Check if everything is fine, if no try from step 1 

Step 7
It’s time to have a cup of coffee/tea of a bottle of beer

enable snmp windows 7

2010-09-09T20:41:00.002+03:00

To install SNMP on Windows 7, open Control Panel and then click on Programs and Features. Then, click on "Turn Windows features on or off" link in the left pane. If UAC prompted, then click on Yes. Then, in the Windows Features window, scroll down and select "Simple Network Management Protocol (SNMP)" check box and click on OK. Then, wait for some time to install SNMP.

After installing SNMP, click on Start Orb and then type Services.msc in the Search box and hit Enter. Then, scroll down in the right pane and right click on SNMP Services and select Properties. Then, click on Traps tab. Now, in the Community Name box, type the community name to which your computer will send trap messages and then click on "Add to list" button. Then, click on Apply and then OK.