Mysql Commands

Filed in Network and Server 1 Comment

Reset root password
1. Stop mysql server
/etc/init.d/mysql stop
2. Start mysql server with safe mode and skip grant tables
#mysqld_safe –skip-grant-table
Continue Reading

Using update-rc.d

Filed in Linux System Leave a comment

Remove a service from all runlevel:
update-rc.d -f ssh remove

Tips for Postfix

Filed in Network and Server Leave a comment

Viewing current queue:
postqueue -p

Delete all deferred messages:
postsuper -d ALL deferred

Delete all message from admin@yahoo.com:
postqueue -p | grep admin@yahoo.com | cut -c 0-12 | tr -d [:blank:] |postsuper -d -

Whitelist IP:
Create or edit file: /etc/postfix/rbl_client_exceptions, then add IP that you want to whitelist. For example 98.139.91.0/32, you can write:
98.139.91 OK

Then, run this command:
postmap /etc/postfix/rbl_client_exceptions

Finally, restart postfix:
/etc/init.d/postfix restart

Iptables (Scratch)

Filed in Network and Server Leave a comment

I just want to access my web server from my local address:

iptables -I INPUT -p tcp --dport 80 -s ! 127.0.0.1 -j DROP -m comment --comment "Only for local address"

Squid’s General Information

Filed in Information Technology Leave a comment

Setting up a proxy configuration:
# export http_proxy=”http://username:password@host:port”

Reloading Squid’s configuration:
# squid -k reconfigure

Ubuntu Installation Problem on Dell Poweredge 1650

Filed in Network and Server Leave a comment

Specifications:

  1. Ubuntu Server 8.10 Intrepid Ibex
  2. Dell Poweredge 1650
    SCSI with RAID Controller
    Three SCSI hard disks, 32GB each
    RAID 0, each hard disk has its own array controller
  3. dev/sda1 = /grub, /dev/sda2 = / , /dev/sda5 = swap

Problem:

  1. After Ubuntu Server installation has finished, server couldn’t boot normally. It stucked forever at BIOS screen, not even reached Grub.
  2. I reinstalled it with different RAID type, but the result was null.

Solution:

  1. Install Ubuntu Server
  2. Boot with Ubuntu Desktop (Live CD)
  3. Open Partition editor, select each partition’s flag to be marked the flag as “raid”, and “boot” + “raid” for boot partition.
  4. Open terminal, escalate to root, then reinstall Grub.
    #grub
    grub> root (hd0,0)
    grub> setup hd0
    grub> quit
  5. Edit menu.lst file, then add “root=/dev/sda5” to your kernel’s argument. I still can’t figure out, how could Grub data in /dev/sda1 to be read at /dev/sda5 partition after I boot it. But that’s the fact.
  6. Reboot the system, eject CD. If you are thrown into BusyBox, from that command prompt, try locate the Grub path. Then fix the kernel’s argument in menu.lst file.

Bad english huh? but … whatever….

Encrypt Hard Disk Partition with LuKS

Filed in Information Technology 2 Comments

This method is good enough to prevent low entropy attack.

Main requirements:
1. Linux Ubuntu Hardy Heron
2. Cryptsetup
3. cryptmount

Continue Reading

EXTENDING PHP WITH PHP-GTK

Filed in Information Technology | Linux System Leave a comment

We can use PHP to make a desktop application, by adding GTK extension. These are what we have to do:
1. Prepare the file
Requirement:
- checkinstall
- php5-cli (PHP5 Command Line Interface)
- php5-dev
- libglib2.0-dev
- libgtk2-dev
Download PHP-GTK-20.beta.tar.gz
Continue Reading

Extending GDAL with ECW Support

Filed in Geographic Information System | Information Technology Leave a comment

MAIN REQUIREMENTS:

- Ubuntu 7.10 Gutsy Gibbon fresh installation + 5 repositories DVD
- checkinstall : a program to build .deb package from binary, to make package management easier.

We will try to compile and install PHPMapscript with .ECW (ErMapper Compression Wavelets) capabilities. GDAL (Geospatial Data Abstraction Layer) as its main library, doesn’t have default capability to read .ecw image. It needs external library from ErMapper, which has limited license.

These are what we have to do:
1. Compile and install libecwj2
2. Compile and install gdal 1.5.0
3. Install libgdal from your repositories
4. Test Gdal capability with gdalinfo
5. Compile and install MapServer
6. Check with phpinfo
7. Final Test
Thus, you should remove any installed packages mentioned above.

Continue Reading

Tips for Bash

Filed in Information Technology | Linux System Leave a comment

$ echo {{1,2,3},1,2,3}
1 2 3 1 2 3

$ echo {{1,2,3}1,2,3}
11 21 31 2 3

Continue Reading

TOP