Skip to main content


Showing posts from 2011

make sure pgpool node/instance is up ( with bash script )

this idea came to me when some one ask " how do we ensure that postgresql's node has been activated again ? ". by asking google and with have no answer, finally why we don't make a happy script with bash ^_^...

as simple as i love to, this script is run as background service that check node's status every 3 second. And if one of node/both is down, script is automatic bring it UP/ON again.

must to know  how to chek node status:
*> node UP/ON
$ tail /var/log/pgpool.log 2011-12-22 10:06:18 DEBUG: pid 8726: starting health checking 2011-12-22 10:06:18 DEBUG: pid 8726: health_check: 0 th DB node status: 1 2011-12-22 10:06:18 DEBUG: pid 8726: health_check: 1 th DB node status: 1 $ pcp_node_info 10 localhost 9898 postgres password 1 xxxx 1 1073741823.500000 $ pcp_node_info 10 localhost 9898 postgres password 1 | awk '{print $3}' 1
*> node Down $ tail /var/log/pgpool.log 2011-12-22 10:14:41 DEBUG: pid 8726: start…

send oracle 11g audit log to syslog server ( on other PC)

well...... this time i will write about syslog, and for this experiment what we need is :
- kiwi syslog server get from here and install it on your PC( i use xp for this server syslog)
- oracle db
- and of course, a cup of coffee is a must and other thing that make you relax and comfortable ( :p )

first thing to do is redirect oracle audit log to syslog, and than from syslog send to syslog server( kiwi syslog)

 edit initSID.ora and add this folowing config :
create "/var/log/oracle/" firs
audit_file_dest='/var/log/oracle/' audit_trail='OS' AUDIT_SYSLOG_LEVEL=local1.warning after that edit /etc/syslog.conf, and add this folowing config :
#Save oracle rdbms audit trail to oracle_audit.log local1.warning /var/log/oracle/oracle_audit.log #Send oracle rdbms audit trail to remote syslog server local1.warning @ #<= ip your syslog server--2--
restart syslog service with command :
/sbin/service syslog restart …

pgpoolAdmin, web interface for pgpool

next capter of pgpool from my last post ( here), now i wanna post about a tool that can manage pgpool from web interface called pgpoolAdmin. next... enjoy the post... ^_^

first we need to download pgpooladmin from here, extrak and copy or move to http directory( for exp : /var/www) 
$wget $tar zxvf pgpoolAdmin-3.0.3.tar.gz $sudo cp -Rf pgpoolAdmin-3.0.3 /var/www/test
install pgpooladmin via web on: http://localhost/test/install

make sure owner of that file is "www-data"(of course have write akses) and check again

login with user that you create on /etc/pcp.conf (for more detail see my last post

and done.ya.. tooo.......!!!

my unity desktop

take a look at my desktop unity with conky and AWN

postgresql replication with pgpool2 on ubuntu

next capter from may last post, now we'll make repication of postgreSQL with pgpool on ubuntu. assumtion, we have 2 server with postgresql installed ( n running well ) on each server.
 first install pgpooll2, with
sudo apt-get install pgpool2--2--
 edit config file on /etc/pgpool.conf
# Host name or IP address to listen on: '*' for all, '' for no TCP/IP # connections listen_addresses = '*' # Port number for pgpool port = 5433 # Port number for pgpool communication manager pcp_port = 9898 parallel_mode = false # Replication mode replication_mode = true # Load balancing mode, i.e., all SELECTs are load balanced. # This is ignored if replication_mode is false. load_balance_mode = true backend_hostname0 = '' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '' backend_hostname1 = '' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '' edit config file o…

install lighttp + postgresql di ubuntu

-- back from old day--
long time since write my latest post. Now, it's time to write again.... ^_^
starting with this tittle..

just simple as usually, type this command on your terminal
$ sudo apt-get install postgresql postgresql-client libpq-dev postgresql-client-common lighttpd php5-cgi php5-pgsql php5-cli
edit "php.ini" on
vi /etc/php5/cgi/php.ini ; of zero causes PHP to behave as before. Default is 1. You should fix your scripts ; to use SCRIPT_FILENAME rather than PATH_TRANSLATED. ; cgi.fix_pathinfo=1
then run this command To enable the fastcgi configuration
sudo lighttpd-enable-mod fastcgi sudo lighttpd-enable-mod fastcgi-php sudo /etc/init.d/lighttpd force-reload
--test & jajal--
create php file on /var/www containing :
<?php phpinfo(); ?>

Webalizer - Statistik trafik/kunjungan web (ubuntu)

make subdomain trafik statistik

run this command :
sudo apt-get install webalizeredit "/etc/apache2/apache2.conf" , set
HostnameLookups Off into :
HostnameLookups On
All we need is already prepared, now set log of vhost in "/etc/apache2/sites-enabled" to spesifict folder.
exp. $sudo vi /etc/apache2/sites-enabled/monitor CustomLog ${APACHE_LOG_DIR}/access.log into: CustomLog ${APACHE_LOG_DIR}/vhost/monitor/access.logrestart service
$sudo /etc/init.d/apache2 restart
create another file config of webalizer in /etc/webalizer
exp. vi /etc/webalier/monitor.conf
set the LogFile to apache2 logfile:
LogFile /var/log/apache2/vhost/monitor/access.log # apache log OutputDir /var/webalizer/monitor/ #webalizer report Incremental yes ReportTitle Usage statistics for HostName
create script to run webalizer via crontab
exp. vi /etc/webalizer/cron_job
#!/bin/bash echo "di jalankan pada: `date +"%d-%B-%Y %r"…

my Desktop ~ ubuntu 10.10

just wanna share, this is may desktop :D:

list directori on NginX

-- goal --
we can list a directory under web root folder

-- 1 --
edit /etc/nginx/sites-enabled/default
sudo vi /etc/nginx/sites-enabled/default-- 2 --
add this following config :
server { listen 80; ## listen for ipv4 listen [::]:80 default ipv6only=on; ## listen for ipv6 server_name localhost; autoindex on; # add this to your config access_log /var/log/nginx/localhost.access.log; --3--
then restart your services:
sakti@sakti-sama:~$ sudo /etc/init.d/nginx restart Restarting nginx: nginx.. -- test&jajal --

blok domain dengan bind

 nb: mungkin dah ada yang publish, tetapi ini berdasar pengalaman pribadi ( dah lama cuman baru mod nulisnya :D )

--goal-- intinya adalah untuk mem- blok domain yang kita inginkan sehingga user tidak bisa meng- akses.

--peralatan-- peralatan yang perlu disiapkan antaralain :
- secangkir kopi
- cemilan apa aja ( rilex can be fun :D )
*sesuaikan letak file zone nya dengan file zone settingan anda
- bind sudah ter-install dengan baik di server(gateway). intinya, ready to use.

--1-- tambahkan pada file /etc/bind/named.conf.local
include "/etc/bind/spywaredomains.zones";
--2-- restart bind anda :
/etc/init.d/bind9 restart
--cek n jajal-- root@traficmng# nslookup Server: Address: Name: Address: NB: - sudah inputkan dalam file spywaredomains.zones.
- Uji coba pada kubuntu 10.04 :D

--saran-- bisa di gabung dengan crontab atau yang script lain, untuk penjad…

Set Up manual ip address in kubuntu

Do the following things to get kubuntu connection working :
1) Disable Network Manager: sudo update-rc.d -f NetworkManager remove sudo apt-get remove network-manage2) Edit /etc/network/interfaces: auto lo eth0 iface lo inet loopback iface eth0 inet static address netmask gateway dns-domain Edit /etc/resolv.conf: domain Home nameserver Restart networking: sudo /etc/init.d/networking restartFinally, test it with your own risk :D

source : ubuntu forum