{ Berbagi, Menulis, Dan Mengajar } Ilmu… » Archive
referensi trigger on MYSQL 5.xx Series
http://dev.mysql.com/doc/refman/5.0/en/triggers.html http://dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html http://dev.mysql.com/doc/refman/5.0/en/trigger-metadata.html … Read entire article »
Filed under: 7. Operating System
GAMMU with SQL Trigger
Gammu merupakan enggine buat sms gateway yang populer, pa lagi sekarang sudah ada versi buat berbagai macem platform termasuk windus. Guugling aja gammu di inet boeat donglod. Hasilnya, bener-bener simple, ndak perlu ribet mikirin PDU nya, AT Command and lain-lain, sms masuk otomatis udah akan nongol di table inboxnya, sedangkan pas case kita nge bales sms, sms otomatis akan ada di table outbox. Ketika udah terkirim, data di table outbox akan otomatis dihapus and dipindah ke table sentitems. Dengan asumsi koneksi udah berjalan (pake DKU5, blutoth or else), kita akan mencoba untuk membuat autoreplynya, cos fitur ini tidak disediakan secara otomatis oleh gammu dengan menggunakan fitur trigger pada mysql. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the … Read entire article »
Filed under: 7. Operating System
httptunnel Binary on WINDOWS Client
http://www.neophob.com/serendipity/index.php?/archives/85-GNU-HTTPtunnel-v3.3-Windows-Binaries.html — http://www.neophob.com/files/httptunnel-3.3w32.zip – … Read entire article »
Filed under: 7. Operating System
SSH on Windows Client TUNNEL HOW to ?
Download File dibawah ini : http://internode.dl.sourceforge.net/sourceforge/sshwindows/setupssh381-20040709.zip Kamu install dulu sampek Kelar kemudian buka ‘CMD’ Ketik Perintah dibawah ini : ssh ptpn-xi.com -l pengadaan -p 22 -N -C -L3306:127.0.0.1:3306 pass : P****** klo udah konek “HANDSAKING / ESTABLISHED” buka aplikasi MYSQL-FRONT, SQLYOG,dll — Ketik alamat server Database : 127.0.0.1 Ketik Username Database Isikan Password-nya — Enjoy Your Job GoodLuck..!! … Read entire article »
Filed under: 7. Operating System
HowTo upgrade from Debian Etch (4.0 ) to Lenny (5.0)
Posted by Admin on December 29th, 2008 Debian Lenny’s release is getting closer and closer and many people will want to upgrade their Etch servers to Lenny.This is currently in testing so it is not recommended to use these instruction in production. Before Upgrade Take a complete backup of your debian etch server Procedure to follow First you need to take a backup of your sources.list file using the following command #cp /etc/apt/sources.list /etc/apt/sources.list.backup Now edit the /etc/apt/sources.list file #vi /etc/apt/sources.list Now you need to replace “etch†with “lenny“. deb http://ftp.gb.debian.org/debian/ etch main contrib non-free deb-src http://ftp.gb.debian.org/debian/ etch main contrib non-free deb http://security.debian.org/ etch/updates main contrib non-free after replacing etch with lenny the file will look like this deb http://ftp.gb.debian.org/debian/ lenny main contrib non-free deb-src http://ftp.gb.debian.org/debian/ lenny main contrib non-free deb http://security.debian.org/ lenny/updates main contrib non-free The above example is for a system using the main UK … Read entire article »
Filed under: 7. Operating System
apt-get to aptitude
Would be nice to make a table out of this: aptitude install foo was apt-get install fooaptitude search foo was apt-cache search fooaptitude remove foo was apt-get remove fooaptitude ~D foo was apt-cache rdepends fooaptitude ? was apt-cache policy fooaptitude ? was … Read entire article »
Filed under: 7. Operating System
apt-get to aptitude
Would be nice to make a table out of this: aptitude install foo was apt-get install foo aptitude search foo was apt-cache search foo aptitude remove foo was apt-get remove foo aptitude ~D foo was apt-cache rdepends foo aptitude ? was apt-cache policy foo aptitude ? was … Read entire article »
Filed under: 7. Operating System
10 Langkah Installasi php-dbase di LINUX debian-etch
Berikut ini Cara Installasi extension dbase di PHP5 pada sistem operasi Linux debian-etch —- 1. Install terlebih dahulu php5-dev ~# apt-get install php5-dev 2. Download Source Code php5-dev ~# apt-get source php5-dev 3. Unpack Source Code 4. Masuk kedalam direktori ext/dbase 5. Kemudian ketik “phpize” 6. Compile Code-nya :Â ./configure && ./make 7. copykan dbase.so kedalam folder /usr/lib/php5/20060613+lfs 8. Edit file php.ini ~# joe /etc/php5/apache/php.ini 9. Tambahkan Extension db.so ; Example lines: ;extension=mysql.so ;extension=gd.so extension=dbase.so 10. Restart Apache /etc/init.d/apache restart ———– GoodLuck … Read entire article »
Filed under: 7. Operating System
PERSONEL IT KAMADJAjA LOGISTIC
ferry.prasetyo@kamadjaja.com dharma.prasandya@kamadjaja.com … Read entire article »
Filed under: 7. Operating System
Routing for multiple uplinks/providers
A common configuration is the following, in which there are two providers that connect a local network (or even a single machine) to the big Internet. ________ … Read entire article »
Filed under: 7. Operating System