Instalasi XAMPP

PROSES INSTALASI

Download

Silahkan download DISINI

Masuk ke root administrator linux sudo su
extract ke hasil sedotan ke /opt

tar xvfz xampp-linux-1.7.7.tar.gz -C /opt

Jalankan Xampp

/opt/lampp/lampp start

sekarang webserver dan mysql sudah run silahkan coba

http://localhost

Here a list of missing security in XAMPP:

1. The MySQL administrator (root) has no password.
2. The MySQL daemon is accessible via network.
3. ProFTPD uses the password "lampp" for user "nobody".
4. PhpMyAdmin is accessible via network.
5. Examples are accessible via network.
6. MySQL and Apache running under the same user (nobody).

To fix most of the security weaknesses simply call the following command:

/opt/lampp/lampp security

It starts a small security check and makes your XAMPP installation quite secure. For example this protects the XAMPP demo pages by a username ('lampp') and password combination.

START AND STOP PARAMETERS
Parameter     Description
start     Starts XAMPP.
stop     Stops XAMPP.
restart     Stops and starts XAMPP.
startapache     Starts only the Apache.
startssl     Starts the Apache SSL support. This command activates the SSL support permanently, e.g. if you restarts XAMPP in the future SSL will stay activated.
startmysql     Starts only the MySQL database.
startftp     Starts the ProFTPD server. Via FTP you can upload files for your web server (user "nobody", password "lampp"). This command activates the ProFTPD permanently, e.g. if you restarts XAMPP in the future FTP will stay activated.
stopapache     Stops the Apache.
stopssl     Stops the Apache SSL support. This command deactivates the SSL support permanently, e.g. if you restarts XAMPP in the future SSL will stay deactivated.
stopmysql     Stops the MySQL database.
stopftp     Stops the ProFTPD server. This command deactivates the ProFTPD permanently, e.g. if you restarts XAMPP in the future FTP will stay deactivated.
security     Starts a small security check programm.
For example: To start Apache with SSL support simply type in the following command (as root):

/opt/lampp/lampp startssl

You can also access your Apache server via SSL under https://localhost.
* What is where?
What is where? A big question of our existens, here are some answers! ;)
IMPORTANT FILES AND DIRECTORIES
File/Directory     Purpose

/opt/lampp/bin/     The XAMPP commands home. /opt/lampp/bin/mysql calls for example the MySQL monitor.
/opt/lampp/htdocs/     The Apache DocumentRoot directory.
/opt/lampp/etc/httpd.conf     The Apache configuration file.
/opt/lampp/etc/my.cnf     The MySQL configuration file.
/opt/lampp/etc/php.ini     The PHP configuration file.
/opt/lampp/etc/proftpd.conf     The ProFTPD configuration file. (since 0.9.5)
/opt/lampp/phpmyadmin/config.inc.php     The phpMyAdmin configuration file.
* Stopping XAMPP

To stop XAMPP simply call this command:

/opt/lampp/lampp stop

You should now see:

Stopping LAMPP 1.7.7...
LAMPP: Stopping Apache...
LAMPP: Stopping MySQL...
LAMPP stopped.

And XAMPP for Linux is stopped.
* Uninstall
To uninstall XAMPP just type in this command:

rm -rf /opt/lampp

Auto Run lampp di ubuntu

# ln -s /opt/lampp/lampp /etc/init.d/lampp

Sumber : http://www.apachefriends.org/en/xampp-linux.html

Membuat Repo di Local Disk

Pengguna ubuntu yang menggunakan repository secara online, selain dari itu menggunakan repository offline melalui iso DVD atau repository local dalam hardisk seperti yang akan kita pelajari sekarang.

• Persiapan file iso repository. – anda dapat mendownloadnya disini: 

http://kambing.ui.ac.id/iso/ubuntu-repository/10.10/

• siapkan direktori untuk melakukan mounting setiap iso repository tersebut. sebaiknya buat direktori terpisah untuk setiap mounting dvd. 

misalnya:
/media/Data/Repository-Maverick-Meerkat/repo-dvd-1/ untuk mounting iso dvd 1,
/media/Data/Repository-Maverick-Meerkat/repo-dvd-2/ untuk mounting iso dvd 2 dan begitu selanjutnya. 

• Setelah direktori mount disiapkan, sekarang saatnya melakukan mounting iso dvd. buka terminal dan jalankan perintah berikut: 

1. sudo mount -t iso9660 -o loop /media/Data/Repository-Maverick-Meerkat/repo-dvd-iso/ubuntu-10.10-repository-i386-1_contrib.iso /media/Data/Repository-Maverick-Meerkat/repo-dvd-1/ 
2. sudo mount -t iso9660 -o loop /media/Data/Repository-Maverick-Meerkat/repo-dvd-iso/ubuntu-10.10-repository-i386-2_contrib.iso /media/Data/Repository-Maverick-Meerkat/repo-dvd-2/ 
3. sudo mount -t iso9660 -o loop /media/Data/Repository-Maverick-Meerkat/repo-dvd-iso/ubuntu-10.10-repository-i386-3_contrib.iso /media/Data/Repository-Maverick-Meerkat/repo-dvd-3/ 
4. dan seterusnya ... 

• buka terminal dan buat backup file /etc/apt/sources.list dengan cara mengcopynya. 

cp /etc/apt/sources.list /home/data/sources.list 

• Bukalah file /etc/apt/sources.list menggunakan editor, misalnya : 

• sudo gedit /etc/apt/sources.list kemudian hapus semua isi file sources.list yang telah terbuka tersebut dan tambahkan baris-baris dibawah: 
• deb file::// maverick main multiverse restricted universe 
• deb file::// maverick main multiverse restricted universe 
• deb file::// maverick main multiverse restricted universe 
• deb file::// maverick main multiverse restricted universe 
• deb file::// maverick main multiverse restricted universe 
• deb file::// maverick main multiverse restricted universe 
• deb file::// maverick main multiverse universe 
• deb file::// maverick main multiverse restricted misalnya: 
• deb file::///media/Data/Repository-Maverick-Meerkat/repo-dvd-8/ maverick main multiverse restricted universe 
• deb file::///media/Data/Repository-Maverick-Meerkat/repo-dvd-7/ maverick main multiverse restricted universe 
• deb file::///media/Data/Repository-Maverick-Meerkat/repo-dvd-6/ maverick main multiverse restricted universe 
• deb file::///media/Data/Repository-Maverick-Meerkat/repo-dvd-5/ maverick main multiverse restricted universe 
• deb file::///media/Data/Repository-Maverick-Meerkat/repo-dvd-4/ maverick main multiverse restricted universe 
• deb file::///media/Data/Repository-Maverick-Meerkat/repo-dvd-3/ maverick main multiverse restricted universe 
• deb file::///media/Data/Repository-Maverick-Meerkat/repo-dvd-2/ maverick main multiverse universe 
• deb file::///media/Data/Repository-Maverick-Meerkat/repo-dvd-1/ maverick main multiverse restricted universe

simpan file tersebut dan tutup editornya. 

• buka terminal dan ketikkan sudo-apt get update jika tidak ada pesan error, maka repository local yang baru saja anda kerjakan sudah dapat di gunakan. anda dapat menginstal software yang dibutuhkan dengan perintah sudo apt-get install >namaSoftware<. untuk mengetahui jenis repositori apa yang terdapat dalam DVD Repo (main, multiverse, universe atau restricted) anda dapat membuka directory pool dalam DVD repo tersebut. Disana akan terdapat folder-folder yang namanya merupakan jenis repositori DVD tersebut. 

Sumber : http://pembelajarprogramming.wordpress.com/2011/04/07/membuat-repository-local-dari-file-iso/

SQUID DI UBUNTU

Install Squid

- ketik sudo apt-get install squid
- apt-get install squid squidclient squid-cgi
- apt-get install ccze

Membuat Directory cache

- mkdir /cache1 && mkdir /cache2 && mkdir /cache3 && mkdir /cache4
- touch /var/log/squid/access.log
- touch /var/log/squid/cache.log

Mengaktifkan directory cache

- chown -R proxy.proxy /cache1
- chown -R proxy.proxy /cache2
- chown -R proxy.proxy /cache3
- chown -R proxy.proxy /cache4
- chown -R proxy.proxy /var/log/squid/access.log

Edit Squid.conf
- gedit /etc/squid/squid.conf

http_port 8080 transparent
cache_mgr apriyee@gmail.com
forwarded_for off
visible_hostname arthabanua.com

cache_mem 16 MB
cache_swap_low 98
cache_swap_high 99
maximum_object_size 128 MB
maximum_object_size_in_memory 32 KB
ipcache_size 2048
ipcache_low 98
ipcache_high 99
memory_pools off
reload_into_ims on
pipeline_prefetch on
cache_replacement_policy heap LFUDA
memory_replacement_policy heap GDSF
cache_dir aufs /cache1 40000 94 256
cache_dir aufs /cache2 40000 94 256
cache_dir aufs /cache3 40000 94 256
cache_dir aufs /cache4 40000 94 256
access_log /var/log/squid/access.log
cache_store_log none
cache_log /var/log/squid/cache.log

acl all src 0.0.0.0/0.0.0.0
acl localnet src 192.168.1.0/24, 192.168.88.0/24, 192.168.4.0/24
acl manager proto cache_object
acl localhost src 127.0.0.1/255.255.255.255
acl to_locahost dst 127.0.0.0/8
acl SSL_ports port 443
acl Safe_ports port 80
acl Safe_ports port 21
acl Safe_ports port 443
acl Safe_ports port 70
acl Safe_ports port 210
acl Safe_ports port 1025-65535
acl Safe_ports port 280
acl Safe_ports port 488
acl Safe_ports port 591
acl Safe_ports port 777
acl CONNECT method CONNECT

http_access allow manager localhost
http_access allow localhost
http_access allow localnet
http_access deny manager
http_access deny !Safe_ports
http_access deny CONNECT !SSL_ports
http_access deny all
http_reply_access allow all
icp_access allow all

Pengecekan file Squid.conf

- squid -k parse

membuat direktori swap
- squid -z
- squid -DFY

Reboot Squid Proxy

cek squid apakah sudah berfungsi
- ps -ax|grep squid

Terakhir jalankan perintah :

iptables -t nat -A POSTROUTING -j MASQUERADE

Konfigurasi Tambahan di Mikrotik

/ip firewall nat chain=dstnat in-interface=ToSwitch src-address=!192.168.0.4 protocol=tcp dst-port=80
action=dst-nat to-addresses=192.168.0.4 to-ports=8080
/ip firewall nat chain=srcnat out-interface=ToSwitch src-address=192.168.0.0/24 protocol=tcp
action=src-nat to-addresses=192.168.0.1 to-ports=0-65535

Install Webmin

Instalasi webmin dengan menggunakan versi 1.520 tar file,

Download webmin versi tar file di situsnya webmin

truz Install dulu perl, libcrypt-ssleay-perl, libnet-ssleay-perl (biar bisa pake SSL)

*** login dulu sebagai root ...
sudo su enter trus enter password

** Install dulu paket pendukungnya
# apt-get install perl libcrypt-ssleay-perl libnet-ssleay-perl

Kalo passwd rootnya blm di set, set dulu

sudo passwd root
copy webmin ke direktori /usr/share

cp webmin*.tar.gz /usr/share
Ekstrak

# tar xvfz webmin*.tar.gz
pindah direktori ke folder hasil ekstrak'an
# cd webmin*

*** jalankan script setup

# ./setup.sh

*** Masukin beberapa paramater konfigurasinya

1. Config file directory [/etc/webmin]: <-- Default, langsung tekan Enter
2. Log file directory [/var/webmin]: <-- Langsung tekan Enter
3. Full path to perl (default /usr/bin/perl): <-- Enter lagi
4. Web server port (default 10000): 10000
5. Login name: (default admin)
6. Use SSL (y/n):y
7. Start Webmin at boot time (y/n): y

***********************************************************************
Webmin has been installed and started successfully. Use your web
browser to go to

https://unknown-laptop:10000/

Wine untuk ODBC Powerbuilder dengan Ubuntu

Install Wine terlebih dahulu
Install package-package dependency yang diperlukan:

di terminal ketik :

wget -q http://wine.budgetdedicated.com/apt/387EE263.gpg -O- | sudo apt-key add -

Tambahkan Wine repository
Ketik di terminal:

sudo wget http://wine.budgetdedicated.com/apt/sources.list.d/intrepid.list -O /etc/apt/sources.list.d/winehq.list

Update

sudo apt-get update

Proses install Wine
Ketik di terminal :

sudo apt-get install wine

Sekarang proses instalasi komponen Aplikasi windows
Install komponen-komponen windows dengan bantuan winetricks

Winetricks merupakan script yang berguna untuk mendownload komponen-komponen windows yang diperlukan. Script ini dapat didownload dari http://winezeug.googlecode.com/svn/trunk/winetricks. Ikuti langkah-langkah ini:


$ sudo apt-get install cabextract
$ wget -c http://winezeug.googlecode.com/svn/trunk/winetricks
$ chmod 755 winetricks
$ ./winetricks


Tandai package-package jet40, mdac28 dan mfc42 dan kemudian clik OK. Winetricks akan mendownload package-package ybs. dan menginstallkan ke wine. Ikuti tahap-tahap penginstallan tiap-tiap package.


# Set format tanggal Wine sesuai dengan format tanggal Indonesia

Program e-spt mensyaratkan format tanggal harus dalam dd/MM/yyyy. Untuk itu ubahlah key registry HKEY_CURRENT_USER\ControlPanel\International\sShortDate menjadi dd/MM/yyyy

$ wine regedit