mysql

Januari 26, 2008

Instalasi Mysql dari File Binary

 

1. Ekstrak File Binari Mysql

tar zxvf mysql

 

2. Tambahkan group dan user mysql

groupadd mysql

useradd -g mysql mysql

 

3. Pindahkan hasil ekstrak ke /usr/local/mysql

mv mysql-standard-4.0.23-pc-linux-i686 /usr/local/mysql

 

4. Pindah ke direktori mysql

cd /usr/local/mysql/

 

5.Kopikan file ke /etc.my.cnf

cp my-medium.cnf /etc/my.cnf

 

6. Ganti kepemilikan dan group menjadi mysql

cd /usr/local/

chown -R mysql mysql

chgrp -R mysql mysql

 

7. Masuk ke direktori mysql

cd mysql

 

8. Jalankan mydql daemon

./bin/safe_mysqld &

 

9. Tes koneksi ke mysql

./bin/mysql

Hasilnya akan sebagai berikut

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4 to server version: 4.0.23-standard-log

 

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

 

mysql>

 

10. Keluar dari mysql

mysql>quit

 

11. Mengubah password root mysql

./bin/mysqladmin password disinipasswordnya

 

Instalasi PhpMyadmin

 

  1. Ekstrak file source phpmyadmin dan tempatkan pada directori tempat menyimpan file web.

tar zxvf php phpMyAdmin-2.5.6.tar.gz –C  usr/local/apache2/htdocs

 

  1. Pindah ke direktori tempat menyimpan file web

Cd /usr/local/apache2/htdocs

 

  1. Ganti nama direktori phpMyAdmin-2.5.6 menjadi phpmyadmin ( untuk menyederhanakan saja)

Mv phpMyAdmin-2.5.6 phpmyadmin

 

  1. Edit file config.inc.php di bawah directory phpmyadmin

Vi config.inc.php

 

Yang perlu diubah adalah :

$cfg[‘PmaAbsoluteUri’], menunjukkan url phpadmin, misalnya :

$cfg[‘PmaAbsoluteUri’] = ‘http://192.168.0.14/phpmyadmin/’; (diganti sesuai ip komputer web server)

 

$cfg[‘Servers’][$i][‘auth_type’]     = ‘config’;

 

Nama user dan password untuk koneksi ke mysql , misalnya

$cfg[‘Servers’][$i][‘user’]          = ‘root’;

$cfg[‘Servers’][$i][‘password’]      = ‘password’;

 

  1. Tes phpmyadmin dari browser, misalnya :

http://192.168.0.14/phpmyadmin

Jika muncul tampilan Welcome to PhpMyAdmin berarti instalasi telah berhasil.

 

  1.  Menggunakan  password untuk masuk  phpmyadmin

Edit pada config.inc.php dan ubah sebagai berikut :

$cfg[‘Servers’][$i][‘auth_type’]     = ‘cookies’;

$cfg[‘blowfish_secret’] = ‘aaaa’; (sembarang karakter)

 

  1. Tes melalui browser seperti langkah no 5, masukkan user dan password  mysql.

 

 

Instalasi FTP server dengan Proftpd

 

1. Download paket proftpd-1.2.10.tar.gz dari situs http://www.proftpd.org

2. Ekstrak ke direktori tertentu:

 [root@localhost]# tar zxvf proftpd-1.2.10.tar.gz -C /usr/local/proftpd

 

3. Masuk Ke direktori baru  hasil ekstrak:

[root@localhost]# cd proftpd-1.2.10

 

4..Kompile dan install:

/configure

make

make install

 

4. Buat user yang akan menjalankan proftpd:

[root@localhost proftpd-1.2.10]# useradd proftpd -s /dev/null

 

5.  Buat home directory untuk anonymous

[root@localhost proftpd-1.2.10]# mkdir /home/ftp

 

6. Edit file konfigurasi proftpd dengan text editor 

[root@localhostproftpd-1.2.10]# vi /usr/local/etc/proftpd.conf

 

7. Contoh file konfigurasi proftpd.conf untuk basic ftp server:

 

# This is a basic ProFTPD configuration file (rename it to

# ‘proftpd.conf’ for actual use. It establishes a single server

# and a single anonymous login. It assumes that you have a user/group

# “nobody” and “ftp” for normal operation and anon.

 

ServerName “latihan”

ServerType standalone

DefaultServer on

 

# Port 21 is the standard FTP port.

Port 21

# Umask 022 is a good standard umask to prevent new dirs and files

# from being group and world writable.

Umask 022

 

# To prevent DoS attacks, set the maximum number of child processes

# to 30. If you need to allow more than 30 concurrent connections

# at once, simply increase this value. Note that this ONLY works

# in standalone mode, in inetd mode you should use an inetd server

# that allows you to limit maximum number of processes per service

# (such as xinetd)

MaxInstances 30

 

# Set the user and group that the server normally runs at.

User proftpd

Group proftpd

 

# Normally, we want files to be overwriteable.

<Directory /*>

AllowOverwrite on

</Directory>

 

# A basic anonymous configuration, no upload directories.

<Anonymous /home/ftp>

RequireValidShell off

User ftp

Group ftp

# We want clients to be able to login with “anonymous” as well as “ftp”

UserAlias anonymous ftp

 

# Limit the maximum number of anonymous logins

MaxClients 10

 

# We want ‘welcome.msg’ displayed at login, and ‘.message’ displayed

# in each newly chdired directory.

DisplayLogin welcome.msg

DisplayFirstChdir .message

 

# Limit WRITE everywhere in the anonymous chroot

<Limit WRITE>

DenyAll

</Limit>

 

</Anonymous>

 

8. Jalankan proftpd:

[root@localhost proftpd-1.2.10]# /usr/local/sbin/proftpd

 

10.  Jika ada error, selalu lakukan cek di /var/log/messages

[root@localhostproftpd 1.2.10]# tail /var/log/messages

 

11. Jika tidak ada error, lakukan test dengan mencoba ftp server baru tersebut

[root@localhost proftpd-1.2.10]# ftp localhost

Connected to localhost (127.0.0.1).

220 ProFTPD 1.2.4 Server (latihan) [t]

Name (localhost:root):

331 Password required for

Password:

230 User wawawawa logged in.

Remote system type is UNIX.

Using binary mode to transfer files.

ftp>

 

12. Lakukan test juga terhadap konfigurasi anonymous ftp server.

[root@localhostproftpd-1.2.10]# ftp localhost

Connected to localhost (127.0.0.1).

220 ProFTPD 1.2.4 Server (latihan)

Name (localhost:root): anonymous

331 Anonymous login ok, send your complete email address as your password.

Password:

230 Anonymous access granted, restrictions apply.

Remote system type is UNIX.

Using binary mode to transfer files.

ftp>

 

Jika output yang keluar adalah seperti di atas ftp server  telah berjalan dengan baik .

Hello world!

Januari 19, 2008

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!