May 04

Introduction

MapServer is an open source and free software for rendering maps, images, and vector data on the web. MapServer was originally developed by the University of Minnesota (UMN) ForNet project in cooperation with NASA and the Minnesota Department of Natural Resources. Presently, the MapServer project is hosted by the TerraSIP, a NASA sponsored project between the UMN and consortium of land management interests (http://mapserver.gis.umn.edu).

MapServer can be compiled on many platforms and operating systems, but in this tutorial, I will focus on unix like system, especially Linux.

Prerequisites

Operating system used in this tutorial is Linux Fedora Core 7 with Apache (httpd-2.0.55), PHP (php-5.2.3), and PostgreSQL(postgresql-8.2.4) already installed using manual source installation (not using default rpm package). Required libraries that already installed are libpng, libjpeg, libtiff, and zlib. Installation manual for those softwares and libraries are beyond the scope of this tutorial. Continue reading »

Mar 11

InnoDB is one of MySQL storage engines, it supports transactions, row-level locking, and foreign-keys. However, by default, InnoDB is not enabled by XAMPP. To enable it, locate the my.cnf configuration file (normally in C:/xampp/mysql/bin directory) and search for the following lines:

# Comment the following if you are using InnoDB tables
skip-innodb
#innodb_data_home_dir = “C:/xampp/mysql/”
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = “C:/xampp/mysql/”
#innodb_log_arch_dir = “C:/xampp/mysql/”
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
Continue reading »

Feb 27

Tips ini untuk mengatasi permasalahan pada saat instalasi XAMPP pada windows dimana apache tidak bisa menerima koneksi HTTP. Kondisinya adalah dimana setelah instalasi xampp berhasil dan aplikasi apache telah dijalankan melalui control panel xampp tapi kita tetap tidak bisa mengakses halaman default dari xampp (http://localhost). Hal ini disebabkan karena adanya bentrok dengan program antivirus yang ada di komputer kita. Secara default, apache menggunakan WinSock V2 API AcceptEx() daripada fungsi standar Accept() (BSD Styles) . Beberapa aplikasi antivirus memiliki bug yang mempengaruhi fungsi AcceptEx(). Untuk mengatasinya, tambahkan tag Win32DisableAcceptEx pada file konfigurasi apache (httpd.conf) untuk menonaktifkan fungsi AcceptEx(). Continue reading »