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.

[root@flubber root]# dmesg | grep tty
ttyS0 at 0x03f8 (irq = 4) is a 16550A
ttyS1 at 0x02f8 (irq = 3) is a 16550A

[root@flubber root]# setserial -g /dev/ttyS[01]
/dev/ttyS0, UART: 16550A, Port: 0x03f8, IRQ: 4
/dev/ttyS1, UART: 16550A, Port: 0x02f8, IRQ: 3

Read more »

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

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 very details way. The Binary Log is used for two main purposes;

* 1. Replication between master and slave server, statement that has been made on Master server will later send it to slave server.
* 2. Recovery, certain recovery job required data stored in MySQL Binary Log.
Read more »

Categories: Linux, Orat-oret | Tags: , , | Leave a 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. (doh)

Check replication on slave

mysql> SHOW SLAVE STATUS G

And one of Slave_IO_Running or Slave_SQL_Running is set to No, then the replication is broken:
Read more »

Categories: Linux, Orat-oret | Tags: , , , , | 2 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 cluster.
* A node may belong to only one GPFS cluster at a time.
* The nodes must be available for the command to be successful. If any of the nodes listed are not available when the command is issued, a message listing those nodes is displayed. You must correct the problem on each node and reissue the command to add those nodes.
You can use command mmaddnode, mmlsnode and mmlscluster.

Read more »

Categories: Linux | Tags: , , , | Leave a comment

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 kritikal.

Berikut step by step membuat Ethernet Bonding di Linux

Read more »

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

Menangislah…

Menangislah Untuk Ramadhan Yang Kan Hilang Nak, menangislah…
Jika itu bisa melapangkan gundah yang mengganjal sanubarimu.
Jika itu adalah ungkapan penyesalanmu.

Bahwa Ramadhan sudah bergegas di akhir hitungan.

Tapi baru merupakan awal tekadmu untuk menyempurnakan tarawih dan qiyamul lailmu yang centang perenang

Menangislah,

Allah tak menjanjikan apa-apa untuk Ramadhan tahun depan,apakah kamu masih disertakan; sedangkan Ramadhan sekarang cuma tersisa beberapa belas. Tak ada yang dapat menjamin usiamu sampai untuk Ramadhan besok, sedang Ramadhan ini tersia-siakan.

Menangislah untuk Ramadhan yang kan hilang.
Biar butir bening itu jadi saksi di yaumil akhir.

Menangislah, lebih keras…
Untuk dosa-dosa yang belum diampuni, tapi kamu masih juga menambahi dengan dosa baru. Berapa kali kamu sholat taubat, tetapi tak lama kemudian ada saja kelalaian yang kamu buat?

Menangislah………

Tuntaskan semuanya mulai malam ini. Karena besok waktu akan bergerak makin cepat, Ramadhan semakin berlari.

Tarawih, sedekah, tilawah Qur’an, qiyamul lail, i’tikaf.
Tahu-tahu sudah sepuluh hari terakhir dan kamu masih juga belum siap.
Sekarang, atau mungkin tidak ada sama sekali…

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

mysql : Got error 127 from storage engine

Duh.. udah sore di telp pula dari client.. katanya a** monitoringnya gajalan, selidik punya selidik ternyata mysql keluarin error “Got error 127 from storage engine” gw pikir cuma tablenya aja yang rusak, so tinggal repair table aja. Tapi setelah dijalanin lagi applikasinya masih tetap mysqlnya keluarin error “Got error 127 from storage engine” dan akhirnya mendapatkan jawabannya kalo mysql default rowsnya terbatas. So harus ditambahin.. Caranya sbb:

Read more »

Categories: Linux | Tags: , , , | 3 Comments

Renaming a NIC on SUSE and openSUSE

Problem:

Say you have installed two NICs in your system e.g. eth0 and eth1 and sometime later you removed one of the nics from your machine, say, eth0.

Now you want to access the remaining nic, eth1, as eth0, or you want to simply name the existing nic (i.e. eth1) as eth0.

Solution:

Read more »

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

Group Mapping MS Windows and UNIX

As usual I’m allways visite my blog to read the manual from samba, because i had always got the problem from samba. So i wrote the documentation, I know I will have to come back here to find it hehehe :D

The following steps describe how to make Samba PDC users members of the Domain Admins group.

1. Create a UNIX group (usually in /etc/group); let’s call it domadm.
2. Add to this group the users that must be “Administrators”. For example, if you want joe, john, and mary to be administrators, your entry in /etc/group will look like this:

ntadmin:x:502:henry,flubber

3. Map this domadm group to the “Domain Admins” group by executing the command:

# net groupmap add ntgroup=”Domain Admins” unixgroup=ntadmin rid=512 type=d

The quotes around “Domain Admins” are necessary due to the space in the group name. Also make sure to leave no white space surrounding the equal character (=).

Read more »

Categories: Uncategorized | Tags: , , , | Leave a comment

Convert Firefox 3 cookies.sqlite to cookies.txt

Now at firefox 3 does not user cookies.txt, they are use cookies.sqlite, if you use wget or curl command to download with cookies, may you must convert cookies.sqlite to cookies.txt, just copy and paste this scipt, and the script will be convert your cookies.sqlite to cookies.txt.

#!/usr/bin/python

import sqlite3 as db
import sys

cookiedb = ‘/home/henry/.mozilla/firefox/pj8x7vu3.default/cookies.sqlite’
targetfile = ‘/home/henry/kuki-.txt’

what = sys.argv[1]
connection = db.connect(cookiedb)
cursor = connection.cursor()
contents = “host, path, isSecure, expiry, name, value”

cursor.execute(“SELECT ” +contents+ ” FROM moz_cookies WHERE host LIKE ‘%” +what+ “%’”)

file = open(targetfile, ‘w’)
index = 0
for row in cursor.fetchall():
file.write(“%stTRUEt%st%st%dt%st%sn” % (row[0], row[1],
str(bool(row[2])).upper(), row[3], str(row[4]), str(row[5])))
index += 1

print “Gesucht nach: %s” % what
print “Exportiert: %d” % index

file.close()
connection.close()

save this script as export-firefox-cookies.py and run with command

./export-firefox-cookies.py rapidshare

Source : http://blog.schlunzen.org/2008/06/19/firefox-3-und-cookiestxt/

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