{ Berbagi, Menulis, Dan Mengajar } Ilmu…

Linux files systems work great. Especially ext3 is a mature file system and very robust. With journaling turned the filesystems stays consistent also on an unexpected power loss or system crash (wich normally never happens on linux ) and you don’t need long disk checks to repair the file system in such a case. There is almost no disk fragmentation and a lot of more cool features … But the best linux feature is: if you remove a file or directory it’s gone It’s not moved to trash, its not marked as deleted, there are no annoying messageboxes, it just does what you say. I love that! But from time to time also experienced users make mistakes and you delete something wrong. As Murphy’s law says: “if anything can … Read entire article »

http://www.mobilefx.com/web/documents/Fastrack_M1206.pdf … Read entire article »

Manufacturer     : Wavecom Model             : unknown (MULTIBAND 900E 1800) Firmware        : 652a09gg.Q2406A 1489876 060706 17:19 IMEI             : 351621000512260 SIM IMSI        : 510101825265652 … Read entire article »

# apt-get install rsync # ssh-keygen -t rsa # scp .ssh/id_rsa.pub root@remotebox1.server.com:.ssh/authorized_keys2 # scp .ssh/id_rsa.pub root@remotebox2.server.com:.ssh/authorized_keys2 —> Kalo Menggunakan Port lain #scp -P23 limanjaya01072014.sql dms@www.ikc.co.id:/home/dms #rsync -avz -e ssh /home/ root@192.168.11.254:/home/dms/rsync-files #rsync -avz -e ssh /etc/ root@192.168.11.254:/home/dms/rsync-files #rsync -avz -e ssh /var/lib/mysql root@192.168.11.254:/home/dms/rsync-files —- —- Isikan ke crontab … … Read entire article »

Q. I’d like to configure my Debian box to backup two remote servers using rsnapshot software. It should make incremental snapshots of local and remote filesystems for any number of machines on 2nd hard disk located at /disk1 ( /dev/sdb2). A. rsnapshot is perfect open source solution for making backups on local system. It supports both remote and local systems. From the man page: rsnapshot saves much more disk space than you might imagine. The amount of space required is roughly the size of one full backup, plus a copy of each additional file that is changed. rsnapshot makes extensive use of hard links, so if the file doesn’t change, the next snapshot is simply a hard link to the exact same file. The following instructions are compatible with both Debian and … Read entire article »

INSERT INTO outbox( updatedindb, insertintodb, sendingdatetime, “text”, destinationnumber, coding, udh, “class”, textdecoded, id, multipart, relativevalidity, senderid, sendingtimeout, deliveryreport, creatorid) VALUES (now(), ‘1970-01-01 00:00:00′, ‘1970-01-01 00:00:00′, NULL, ‘08155031882’, ‘Default_No_Compression’, NULL, -1, ‘Haloo Papa Dimas… saya test ya’, nextval(‘outbox_id_seq'::regclass), FALSE, -1, NULL, ‘1970-01-01 00:00:00′, ‘default’, ”); … Read entire article »

php-mysql-postgres.pdf … Read entire article »

Gambaran Aplikasi yang ingin di buat 1.Terdiri dari beberapa modem 2.Terdapat satu database besar yang merupakan pusat database 3.Setiap modem akan berhubungan dengan satu database perantara yang terhubung dengan database besar tadi. Langkah-langkah yang dilakukan untuk eksperimen Buat databasenya (isinya sesuai dengan yang disediakan gammu). smsdMaster untuk menyimpan semua data dari berbagai database pembantu. smsd0 yang akan terhubung dengan modem0. smsd1 yang akan terhubung dengan modem1 dan smsd2 yang akan terhubung dengan modem2. Buat file log untuk masing-masing modem (pada eksperimen ini di /var/log/gammu/gammulog, gammulog1 dangammulog2. Pasang tiga buah modem (saya pakai itegno 3000). Edit file gammurc tambahkan [gammu1] dan [gammu2] sesuaikan port dan logfilenya. [gammu] port = /dev/ttyUSB0 ;model = 6110 connection = at115200 ;synchronizetime = yes logfile = /var/log/gammu/gammulog logformat = textall ;use_locking = yes ;gammuloc = locfile ;startinfo = yes ;gammucoding = utf8 ;usephonedb = yes [gammu1] port = /dev/ttyUSB1 ;model = 6110 connection = at115200 ;synchronizetime = yes logfile = … Read entire article »

apt-get update apt-get install pgsql Create Language Example plpgsql su postgres createlang plpgsql template1 exit Change authentication method We need to edit file pg_hba.conf to change authentification method for accessing PostgreSQL database. cp /etc/postgresql/pg_hba.conf /etc/postgresql/pg_hba.confbak vi /etc/postgresql/pg_hba.conf Find this section # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD # Database administrative login by UNIX sockets local all postgres ident sameuser # # All other connections by UNIX sockets local all all ident sameuser # # All IPv4 connections from localhost host all all 127.0.0.1 255.255.255.255 ident sameuser # # All IPv6 localhost connections host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff ident sameuser host all all ::ffff:127.0.0.1/128 ident sameuser # # reject all other connection attempts host all all … Read entire article »