browser icon
You are using an insecure version of your web browser. Please update your browser!
Using an outdated browser makes your computer unsafe. For a safer, faster, more enjoyable user experience, please update your browser today or try a newer browser.

Linux

Rsync using ssh non-standart port ssh

Before we start to explain deep, let me introduce rsync What is Rsync ? rsync is a file transfer program for Unix systems. rsync uses the “rsync algorithm” which provides a very fast method for bringing remote files into sync. It does this by sending just the differences in the files across the link, without … Continue reading »

Categories: Linux, Orat-oret | Tags: , | 1 Comment

Howto: Install PHP Oracle / module php-oci8 on Linux

If you are using Oracle database and  you want to connect, in here you can find how to install module php-oci8. In this how to you can use Oracle’s Instant Client and php oci8 module from pear.  Download the Linux Basic  and the SDK packages from here. At the time of this writing, filename are … Continue reading »

Categories: Linux, Orat-oret | Tags: , , , , | 2 Comments

Export MySQL data to CSV

Melakukan export data MySQL ke CSV sangat mudah di lakukan melalui CLI (Command Line Interface), untuk langkah ini kita mempunya 2 cara, tinggal pilih saja mana yang menurut Anda gampang dilakukan. Langkah 1: select columns INTO OUTFILE ‘/path/to/output.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘n’ from table [where clause] Langkah … Continue reading »

Categories: Linux, Uncategorized | Tags: | 1 Comment

Thunderbird Get MS-Exchange Global Address List

I’m using Thunderbird as Mail User Agent. Now i want to get Global Address List with my Thunderbird. As we know Active Directory using LDAP. To setting up Thunderbird open Tools > Address Book

Categories: Hobby, Linux, Orat-oret | Tags: , | 3 Comments

Exporting Data with the SELECT … INTO OUTFILE Statement

Berikut syntax untuk membatu dalam melakukan dump database, tetapi kita dapat menentukan field-filed yg kita butuhkan, dengan menggunakan SELECT dengan INTO OUTFILE output_file. Ikuti langkah berikut ini untuk mengexport table data_tbl ke dalam file data.txt. mysql> SELECT * FROM data_tbl -> INTO OUTFILE ‘/tmp/data.txt’; Output dari perintah diatas akan membuat file /tmp/data.txt. Jika ingin outpunya … Continue reading »

Categories: Linux, Orat-oret | Tags: , | Leave a comment

Linux Output Display via Console RS232

In the office now being POC avocent for ACS products, which supposedly he can capture the output from linux. After reading read the documentation of the Linux-Serial finally found it, how to make Linux not just to the monitor output (VGA Card) but via RS232 Console (ttyS0). 1. Make sure your system support serial port. … Continue reading »

Categories: Linux, Orat-oret | Tags: , , , | 3 Comments

Remove MySQL Binary Log Files Eating Lots of Disk Space

By default, MySQL 5.0 and above enables MySQL Binary Log. Keeping MySQL Binary Log might take up a lot of disk space for long run. Older MySQL Binary log can be removed in order to keep your hard disk space free. MySQL Binary Log stores query event such as add, delete and update in a … Continue reading »

Categories: Linux, Orat-oret | Tags: , , | 1 Comment

Repair MySQL Replication Duplicate Entry Error

We have 2 servers that will be configured as Circular Replication. It means both servers act as master and slave to another server. And Master server was going down because hardware failure and need restart Master server. When Master server is going up, repication with slave is not running. Check replication on slave mysql> SHOW … Continue reading »

Categories: Linux, Orat-oret | Tags: , , , , | 4 Comments

Adding nodes to a GPFS cluster using use command mmaddnode, mmlsnode and mmlscluster.

You can add nodes to an existing GPFS cluster by issuing the mmaddnode command. The new nodes are available immediately after the successful completion of this command. You must follow these rules when adding nodes to a GPFS cluster: * You may issue the command only from a node that already belongs to the GPFS … Continue reading »

Categories: Linux | Tags: , , , | 2 Comments

Linux Ethernet Bonding

Setelah sekian lama jadi pengen nulis lagi di blog yg tak seberapa ini, saat ini topic yg akan kita bahas Linux Ethernet Bonding yaitu menggabungkan dua buah atau lebih ethernet menjadi 1 device bond. Mengapa kita harus mem-bonding ethernet? Jawabnya dengan bonding ethernet kita bisa memaksimalkan network jika terjadi failure, biasanya digunakan untuk mesin-mesin yg … Continue reading »

Categories: Linux, Orat-oret | Tags: , , , | 6 Comments