Membangun Web Server dengan ZendCore For Oracle

Kontributor: roninmorgue
Tuesday, 04 September 2007
Terakhir Diperbaharui Tuesday, 04 September 2007

Adapun kebutuhan dari web server tersebut adalah dapat berkomunikasi dengan database Oracle (Oracle 10g)
(pada mesin yang berbeda/remote) dan MySQL(lokal mesin), serta PHP sebagai bahasa pemrograman web-nya.
Berdasarkan kebutuhan tersebut maka Software yang digunakan adalah:
1. ZendCoreForOracle-v2.0.1-Linux-x86.tar.gz
2. oracle-instantclient-basic-10.2.0.3-1.i386.rpm
3. oracle-instantclient-devel-10.2.0.3-1.i386.rpm
4. mysql-5.0.45-linux-i686-glibc23.tar.gz
5. phpMyAdmin-2.11.0-rc1-all-languages.tar.bz2
Langkah-langkah :
Instalasi ZendCoreForOracle
1. Login sebagai root pada shell anda dan extract ZendCoreForOracle
[root@webserver gunawan]# gunzip /home/gunawan/ZendCoreForOracle-v2.0.1-Linux-x86.tar.gz | tar xvf -
2. Masuk kedalam direktori hasil extract
[root@webserver gunawan]# cd ZendCoreForOracle-v2.0.1-Linux-x86
3. Jalankan script instalasi
[root@webserver gunawan]# ./install
4. Saat Wizard Instalasi berjalan, ikuti semua petunjuknya sampai instalasi selesai.
5. Untuk mengakses/melakukan konfigurasi ZendCore dapat menggunakan web based
http://alamat_host:port/ZendCore
Instalasi oracle-instantclient-basic dan oracle-instantclient-devel
1. Login sebagai root
[root@webserver gunawan]# rpm -Uvh oracle-instantclient-basic-10.2.0.3-1.i386.rpm
[root@webserver gunawan]# rpm -Uvh oracle-instantclient-devel-10.2.0.3-1.i386.rpm
Instalasi dan konfigurasi mysql-5.0.45
1. login sebagai root dan buat group mysql untuk menjalankan aplikasi:
[root@webserver /]# ./usr/sbin/groupadd mysql
2. Buat user mysql untuk menjalankan aplikasi
[root@webserver /]# ./usr/sbin/useradd -g mysql mysql
3. Extract file mysql-5.0.45-linux
[root@webserver local]# gunzip /home/gunawan/mysql-5.0.45-linux-i686-glibc23.tar.gz | tar xvf -
4. Buat link file
[root@webserver local]# ln -s /home/gunawan/mysql-5.0.45-linux-i686-glibc23 mysql
[root@webserver local]# cd mysql
5. Rubah kepemilikan user
[root@webserver mysql]# chown -R mysql .
6. Rubah kepemilikan group
[root@webserver mysql]# chgrp -R mysql .
7. Jalankan script untuk mengaktifkan mysql
[root@webserver mysql]# scripts/mysql_install_db --user=mysql
Neither host 'webserver' nor 'localhost' could be looked up with ./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with the --force option
[root@webserver mysql]# scripts/mysql_install_db --force --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
OK
Setelah semuanya di install, kita harus melakukan testing
[root@webserver mysql]# ./support-files/mysql.server status
MySQL running (7585) [ OK ]
8. Agar mysql dijalankan pada saat server/mesin berjalan lakukan konfigurasi pada file /etc/rc.local
mercubuana-it.org
http://mercubuana-it.org/ _PDF_POWERED _PDF_GENERATED 5 July, 2009, 13:40
[root@webserver mysql]# vi /etc/rc.local
-- sesuaikan path-nya dengan direktori instalasi anda
./home/gunawan/mysql-5.0.45-linux-i686-glibc23/bin/mysqld_safe --user=mysql &
Instalasi phpMyAdmin-2.11.0
1. Login sebagai root dan extract phpMyAdmin-2.11.0-rc1-all-languages.tar.bz2
2. Pindahkan direktory phpMyAdmin-2.11.0-rc1-all-languages ke direktory web root
[root@webserver gunawan]# mv ./phpMyAdmin-2.11.0-rc1-all-languages ./usr/local/Zend/apache2/htdocs/phpMyadmin
Konfigurasi phpMyadmin
1. /* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki .
*
* @version $Id: config.sample.inc.php 10142 2007-03-20 10:32:13Z cybot_tm $
*/
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'k4t4r4h4514k4mupuny4'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1'; // sesuaikan dengan nama host lokal anda
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
/*
* End of servers configuration
*/
/*
mercubuana-it.org
http://mercubuana-it.org/ _PDF_POWERED _PDF_GENERATED 5 July, 2009, 13:40
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
2. Berikan password untuk user root pada database
[root@webserver bin]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.45
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> UPDATE mysql.user SET Password = PASSWORD('passwordrootanda') WHERE User = 'root';
Query OK, 3 rows affected (0.10 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.02 sec)
mysql> select host,user from mysql.user;
+-----------+------+
| host | user |
+-----------+------+
| 127.0.0.1 | root |
| localhost | root |
| webserver | root |
+-----------+------+
3 rows in set (0.02 sec)
mysql> select host,user,password from mysql.user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *89045956ED##############EDIT############ |
| webserver | root | *89045956ED##############EDIT############ |
| 127.0.0.1 | root | *89045956ED##############EDIT############ |
+-----------+------+-------------------------------------------+
3 rows in set (0.00 sec)
mysql>
Terakhir kita lakukan perubahan kepemilikan user pada direktori /htdocs
[root@webserver gunawan]# chown -R gunawan /usr/local/Zend/apache2/htdocs
mercubuana-it.org
http://mercubuana-it.org/ _PDF_POWERED _PDF_GENERATED 5 July, 2009, 13:40


diperoleh dari :http://mercubuana-it.org/index2.php?option=com_content&do_pdf=1&id=49