Radiator Radius Installation connecting to ORACLE (CentOS)

1. Download and install the Oracle client connectors.

http://www.oracle.com/index.html

oracle-instantclient-basic-10.2.0.3-1.i386.rpm
oracle-instantclient-devel-10.2.0.3-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

rpm -Uvh oracle-instantclient-basic-10.2.0.3-1.i386.rpm
rpm -Uvh oracle-instantclient-devel-10.2.0.3-1.i386.rpm
rpm -Uvh oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

2. Set the environment variables.

# ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client/lib
# export ORACLE_HOME
# export LD_LIBRARY_PATH=$ORACLE_HOME

# TNS_ADMIN=/usr/lib/oracle/10.2.0.3/client/admin
# export TNS_ADMIN

# mkdir /usr/lib/oracle/10.2.0.3/client/admin


3. Edit /etc/profiles and insert the lines below.

ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client/lib
export ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME

TNS_ADMIN=/usr/lib/oracle/10.2.0.3/client/admin
export TNS_ADMIN

4. Create a file "tnsnames.ora" and insert the settings below.

SERVER1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

5. Install Mysql Server for internal testing.

# yum install mysql-server.i386

this will install the following, and perl-DBI as well which you will need
as dependencies for Perl-Oracle-DBD.

============================
Package Arch Version Repository Size
============================
Installing:
mysql-server i386 5.0.45-7.el5 base 9.7 M

Installing for dependencies:
mysql i386 5.0.45-7.el5 base 4.1 M
perl-DBD-MySQL i386 3.0007-1.fc6 base 147 k
perl-DBI i386 1.52-1.fc6 base 605 k

6. Now we need to install Perl DBD Oracle Connector:
(note: you may need to install other dependencies
to make the configuration work)

a. Login as root

b. Create a temporary directory

# mkdir tempDBD
# cd tempDBD

c. gunzip/untar the DBD module

# gunzip DBD-Oracle-1.16.tar.gz
# tar -xvf DBD-Oracle-1.16.tar
# cd DBD-Oracle-1.16

d. Make/Install DBD

# perl Makefile.PL
# make
# make install

e. Remove temporary DBD directory and files

# cd ../..
# rm -rf tempDBD

7. To test if it is working run the following:

Make a pl file containig the line below
(replace the actual user and password).

use strict;
use DBI;

my $dbh = DBI->connect( 'dbi:Oracle:SERVER1',
'username',
'password',
{
RaiseError => 1,
AutoCommit => 0
}
) || die "Database connection not made: $DBI::errstr";
$dbh->disconnect();

8. Or run a direct connection to oracle.

# sqlplus /@SID

e.g. sqlplus username@password/SERVER1

If both connection doesn't have error connecting to Oracle Server, everything goes well.

__________________________
Download Reference:

DBI-1.48.tar.gz
http://www.idevelopment.info/data/Oracle/DBA_tips/support_data/DBI_DBD/DBI-1.48.tar.gz

DBD-Oracle-1.16.tar.gz
http://www.idevelopment.info/data/Oracle/DBA_tips/support_data/DBI_DBD/DBD-Oracle-1.16.tar.gz

ref: (for installation instruction)
http://www.idevelopment.info/data/Oracle/DBA_tips/Programming/PROGRAMMING_2.shtml
http://search.cpan.org/search?query=DBD::Oracle

9. Install the radiator rpm package.

# useradd radiusd
# groupadd radiusd

# rpm -Uvh Radiator-4.3.1-1.noarch.rpm

10. Install Radmin a radius web control center.

(Note : Install first the Apache2 server)

# tar xzvf Radmin-1.11.tgz

# cd Radmin-1.11

# sh installMysql.sh ("for Mysql") or # sh installOracle.sh (for Oracle)
note : you need to edit content of the .sh file based from the
account you have for the database server .e.g username, password, etc.

# perl install.pl

11. Edit radmin.cfg located in /etc/radiator

12. To start it run "/etc/init.d/radiator start"