The Salmon and the Werewolf....

Edited out some ip's (even non-public ones) and some other stuff. Formatting sucks but it's readable...


******************************************************************************
ORACLE CONFIG
******************************************************************************

Foreground
AuthPort 1645
AcctPort 1646
LogDir /data/LOGFILE
DbDir /usr/local/etc/raddb
#SocketQueueLength 500000

<Log FILE>
Filename %L/%Y-%m-%d-%H-logfile.log
LogMicroseconds
Trace 4
</Log>
<Client localhost>
Secret ********
DupInterval 25
</Client>
<Client 210.14.**.*>
Secret ********
DupInterval 25
</Client>
<Client 210.14.**.**>
Secret *********
NoIgnoreDuplicates Access-Request
DupInterval 10
</Client>
<Client 202.57.***.***>
Secret ******
DupInterval 25
</Client>
<Client 202.57.***.**>
Secret ******
DupInterval 25
</Client>
<Client 210.14.*.**>
Secret *****
DupInterval 25
</Client>
<Client 210.14.*.**>
Secret ******
DupInterval 25
</Client>
<Client 210.14.**.*>
Secret ******
NoIgnoreDuplicates Access-Request
DupInterval 10
</Client>
#ip dial Malolos
<Client 10.255.*.*>
Secret ******
DupInterval 25
</Client>
#ip dial Cabanatuan
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial SFP
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial Dagupan
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial Baguio
<Client 10.255.*.***>
Secret ******
DupInterval 25
</Client>
#ip dial SFU
<Client 10.255.*.***>
Secret ******
DupInterval 25
</Client>
#ip dial Lucena
<Client 10.255.*.*>
Secret ******
DupInterval 25
</Client>
#ip dial Binakayan
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial Batangas
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial Iloilo
<Client 10.255.**.*>
Secret ******
DupInterval 25
</Client>
#ip dial Bacolod
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial GenSan
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial Davao
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial Tarlac
<Client 10.255.*.**>
Secret ******s
DupInterval 25
</Client>
#ip dial Cebu
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
#ip dial Calamba
<Client 10.255.*.**>
Secret ******
DupInterval 25
</Client>
<Client 202.57.***.***>
Secret ******
DupInterval 25
</Client>
<Client 210.14.**.**>
Secret *********
DupInterval 25
</Client>
<Client 210.14.**.***>
Secret *********
DupInterval 25
</Client>

<SessionDatabase SQL>
Identifier PREPAID
DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=192.168.***.***) (PORT=1521)) (CONNECT_DATA=(SID=pps)))
DBUsername pps_prepaid
DBAuth ********
Timeout 200
FailureBackoffTime 90
AddQuery insert into RADONLINE(USERNAME, NASIDENTIFIER, NASPORT,ACCTSESSIONID,
TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,CALLINGSTATIONID)
values ('%u', '%N', 0%{NAS-Port}, '%{Acct-Session-Id}',%{Timestamp}, '%{Framed-IP-Address}',
'%{NAS-Port-Type}','%{Service-Type}','%{Calling-Station-Id}')
</SessionDatabase>

<SessionDatabase SQL>
Identifier POSTPAID
DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=192.168.***.***) (PORT=1521)) (CONNECT_DATA=(SID=pps)))
DBUsername pps_ppaid
DBAuth *************
Timeout 200
FailureBackoffTime 90
AddQuery insert into RADONLINE(USERNAME, NASIDENTIFIER, NASPORT,ACCTSESSIONID,
TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,CALLINGSTATIONID,CALLEDSTATION)
values ('%u', '%N', 0%{NAS-Port}, '%{Acct-Session-Id}',%{Timestamp}, '%{Framed-IP-Address}',
'%{NAS-Port-Type}','%{Service-Type}','%{Calling-Station-Id}','%{Called-Station-Id}')
</SessionDatabase>

<SessionDatabase SQL>
Identifier PLAN
DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=192.168.***.***) (PORT=1521)) (CONNECT_DATA=(SID=pps)))
DBUsername pps_ppaid
DBAuth *************
Timeout 200
FailureBackoffTime 90
AddQuery insert into RADONLINE(USERNAME, NASIDENTIFIER, NASPORT,ACCTSESSIONID,
TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,CALLINGSTATIONID,CALLEDSTATION)
values ('%u', '%N', 0%{NAS-Port}, '%{Acct-Session-Id}',%{Timestamp}, '%{Framed-IP-Address}',
'%{NAS-Port-Type}','%{Service-Type}','%{Calling-Station-Id}','%{Called-Station-Id}')
</SessionDatabase>

<Handler Calling-Station-Id = "">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Calling-Station-Id = "/^\d$/">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Calling-Station-Id = "/^\d\d$/">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Calling-Station-Id = "/^\d\d\d$/">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Calling-Station-Id = "/^\d\d\d\d$/">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Calling-Station-Id = "/^\d\d\d\d\d$/">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Calling-Station-Id = "/^\d\d\d\d\d\d$/">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Calling-Station-Id = "/^\d\d\d\d\d\d\d$/">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Calling-Station-Id = "/^\d\d\d\d\d\d\d\d$/">
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>

<Handler Realm=admin.pldtvibe.com>
RewriteUsername s/^([^@]+).*/$1/
MaxSessions 1
AcctLogFileName %L/ADMIN/%Y-%m-%d-detail
AcctLogFileFormat %m %d %Y %H:%M:%S NAS-IP-Address=%{NAS-IP-Address} NAS-Port=%{NAS-Port}
User-Name=%{User-Name} Called-Station-Id=%{Called-Station-Id}
Calling-Station-Id=%{Calling-Station-Id}
Acct-Status-Type=%{Acct-Status-Type} Service-Type=%{Service-Type}
Acct-Session-Id=%{Acct-Session-Id} Framed-Protocol=%{Framed-Protocol}
Framed-IP-Address=%{Framed-IP-Address} Acct-Session-Time=%{Acct-Session-Time}
<AuthBy FILE>
Filename %D/pldtusers
</AuthBy>
</Handler>

<Handler Called-Station-Id = "101388">
AccountingHandled
MaxSessions 1
SessionDatabase PLAN
AcctLogFileName %L/PLAN/%Y-%m-%d-detail
#PasswordLogFileName %L/PLAN/%Y-%m-%d-password
AcctLogFileFormat %m %d %Y %H:%M:%S NAS-IP-Address=%{NAS-IP-Address} NAS-Port=%{NAS-Port}
User-Name=%{User-Name} Called-Station-Id=%{Called-Station-Id}
Calling-Station-Id=%{Calling-Station-Id} Acct-Status-Type=%{Acct-Status-Type}
Service-Type=%{Service-Type} Acct-Session-Id=%{Acct-Session-Id}
Framed-Protocol=%{Framed-Protocol} Framed-IP-Address=%{Framed-IP-Address}
Acct-Session-Time=%{Acct-Session-Time} Tunnel-Server-Auth-ID=%{Tunnel-Server-Auth-ID}
Acct-Terminate-Cause=%{Acct-Terminate-Cause}
#PreAuthHook file:"%D/roaming.hook"
<AuthBy SQL>
AuthSelect select trim(PASSWORD), EXPIRATION, DEFAULTREPLY,time_func3_roam_rnd(username),
time_func3_roam_rnd(username) from pps_ppaid.pps_SUBSCRIBER where ROAMING_FLAG = '1'
and USERNAME = '%n' and plantype > 0
#AuthSelect select trim(PASSWORD), EXPIRATION, DEFAULTREPLY, SESSIONREPLY, SESSIONREPLY
from pps_ppaid.pps_SUBSCRIBER where ROAMING_FLAG = '1' and USERNAME = '%n' and
plantype > 0
#AuthSelect select trim(ENCRYPTED_PASSWORD), EXPIRATION, DEFAULTREPLY, SESSIONREPLY,
SESSIONREPLY from pps_ppaid.pps_SUBSCRIBER where ROAMING_FLAG = '1' and USERNAME = '%n'
AuthColumnDef 0, User-Password, check
#AuthColumnDef 0, Encrypted-Password, check
AuthColumnDef 1, Expiration, check
AuthColumnDef 2, GENERIC, reply
AuthColumnDef 3, Session-Timeout, reply
AuthColumnDef 4, Ascend-Maximum-Time, reply

DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.***.***)
(PORT=1521)) (CONNECT_DATA=(SID=pps)))
DBUsername pps_ppaid
DBAuth *************
Timeout 10
FailureBackoffTime 90
AccountingTable pps_ppaid.ACCOUNTING
AccountingStopsOnly
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP_DATE,Timestamp,formatted-date,to_date('%e %m %Y %H:%M:%S',
'DD-MM-YYYY HH24 MI SS')
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
AcctColumnDef CALLEDSTATIONID,Called-Station-Id
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctFailedLogFileName %L/CLUSTER/testnetra.prepaid.log
AcctLogFileFormat %{User-Name}|%m %d %Y %H:%M:%S|%{Acct-Status-Type}||||%{Acct-Session-Id}
|%{Acct-Session-Time} |%{Acct-Terminate-Cause}|%{NAS-IP-Address}|%{NAS-Port}
|%{Calling-Station-Id}|%{Called-Station-Id}|||%{Framed-IP-Address}
</AuthBy>
</Handler>

<Handler Called-Station-Id = "101355">
AccountingHandled
MaxSessions 1
SessionDatabase PLAN
AcctLogFileName %L/PLAN/%Y-%m-%d-detail
#PasswordLogFileName %L/PLAN/%Y-%m-%d-password
AcctLogFileFormat %m %d %Y %H:%M:%S NAS-IP-Address=%{NAS-IP-Address} NAS-Port=%{NAS-Port}
User-Name=%{User-Name} Called-Station-Id=%{Called-Station-Id} Calling-Station-Id=
%{Calling-Station-Id} Acct-Status-Type=%{Acct-Status-Type} Service-Type=%{Service-Type}
Acct-Session-Id=%{Acct-Session-Id} Framed-Protocol=%{Framed-Protocol}
Framed-IP-Address=%{Framed-IP-Address} Acct-Session-Time=%{Acct-Session-Time}
Tunnel-Server-Auth-ID=%{Tunnel-Server-Auth-ID}
Acct-Terminate-Cause=%{Acct-Terminate-Cause}
#PreAuthHook file:"%D/plannew.hook"
<AuthBy SQL>
AuthSelect select trim(PASSWORD), EXPIRATION, CLI, DEFAULTREPLY, time_func3_plan_rnd(username),
time_func3_plan_rnd(username) from pps_ppaid.pps_SUBSCRIBER where CLI='%{Calling-Station-Id}'
and USERNAME = '%n' and plantype > 0
#AuthSelect select trim(PASSWORD), EXPIRATION, CLI, DEFAULTREPLY, SESSIONREPLY, SESSIONREPLY
from pps_ppaid.pps_SUBSCRIBER where CLI='%{Calling-Station-Id}' and USERNAME = '%n' and
plantype > 0
#AuthSelect select trim(ENCRYPTED_PASSWORD), EXPIRATION, CLI, DEFAULTREPLY, SESSIONREPLY,
SESSIONREPLY from pps_ppaid.pps_SUBSCRIBER where CLI='%{Calling-Station-Id}' and
USERNAME = '%n'
AuthColumnDef 0, User-Password, check
#AuthColumnDef 0, Encrypted-Password, check
AuthColumnDef 1, Expiration, check
AuthColumnDef 2, Calling-Station-Id, check
AuthColumnDef 3, GENERIC, reply
AuthColumnDef 4, Session-Timeout, reply
AuthColumnDef 5, Ascend-Maximum-Time, reply

DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.***.***)
(PORT=1521)) (CONNECT_DATA=(SID=pps)))
DBUsername pps_ppaid
DBAuth *************
Timeout 10
FailureBackoffTime 90
AccountingTable pps_ppaid.ACCOUNTING
AccountingStopsOnly
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP_DATE,Timestamp,formatted-date,to_date('%e %m %Y %H:%M:%S',
'DD-MM-YYYY HH24 MI SS')
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
AcctColumnDef CALLEDSTATIONID,Called-Station-Id
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctFailedLogFileName %L/CLUSTER/testnetra.prepaid.log
AcctLogFileFormat %{User-Name}|%m %d %Y %H:%M:%S|%{Acct-Status-Type}|||
|%{Acct-Session-Id}|%{Acct-Session-Time} |%{Acct-Terminate-Cause}|%{NAS-IP-Address}
|%{NAS-Port}|%{Calling-Station-Id}|%{Called-Station-Id}|||%{Framed-IP-Address}
</AuthBy>
</Handler>

<Handler Called-Station-Id = "101333">
AccountingHandled
MaxSessions 1
SessionDatabase PREPAID
#RewriteUsername tr/A-Z/a-z/
AcctLogFileName %L/PREPAID/%Y-%m-%d-detail
#PasswordLogFileName %L/PREPAID/%Y-%m-%d-password
AcctLogFileFormat %m %d %Y %H:%M:%S NAS-IP-Address=%{NAS-IP-Address} NAS-Port=%{NAS-Port}
User-Name=%{User-Name} Called-Station-Id=%{Called-Station-Id} Calling-Station-Id=%{Calling-Station-Id}
Acct-Status-Type=%{Acct-Status-Type} Service-Type=%{Service-Type} Acct-Session-Id=%{Acct-Session-Id}
Framed-Protocol=%{Framed-Protocol} Framed-IP-Address=%{Framed-IP-Address} Acct-Session-Time=%{Acct-Session-Time}
Tunnel-Server-Auth-ID=%{Tunnel-Server-Auth-ID} Acct-Terminate-Cause=%{Acct-Terminate-Cause}
#PreAuthHook file:"%D/prepaid.hook"
<AuthBy SQL>
AuthSelect select trim(ENCRYPTED_PASSWORD), EXPIRATION, DEFAULTREPLY,
time_func3_prepd_rnd(username), time_func3_prepd_rnd(username)
from pps_prepaid.SUBSCRIBERS where USERNAME = '%n' and STATUS = '1'
#AuthSelect select trim(ENCRYPTED_PASSWORD), EXPIRATION, DEFAULTREPLY, SESSIONREPLY, SESSIONREPLY
from pps_prepaid.SUBSCRIBERS where USERNAME = '%n' and STATUS = '1'
AuthColumnDef 0, Encrypted-Password, check
AuthColumnDef 1, Expiration, check
AuthColumnDef 2, GENERIC, reply
AuthColumnDef 3, Session-Timeout, reply
AuthColumnDef 4, Ascend-Maximum-Time, reply

DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.***.***)
(PORT=1521)) (CONNECT_DATA=(SID=pps)))
DBUsername pps_prepaid
DBAuth ********
Timeout 10
FailureBackoffTime 90
AccountingTable pps_prepaid.ACCOUNTING
AccountingStopsOnly
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP_DATE,Timestamp,formatted-date,to_date('%e %m %Y %H:%M:%S',
'DD-MM-YYYY HH24 MI SS')
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
AcctColumnDef CALLEDSTATIONID,Called-Station-Id
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctFailedLogFileName %L/CLUSTER/testnetra.prepaid.log
AcctLogFileFormat %{User-Name}|%m %d %Y %H:%M:%S|%{Acct-Status-Type}||||%{Acct-Session-Id}
|%{Acct-Session-Time} |%{Acct-Terminate-Cause}|%{NAS-IP-Address}|%{NAS-Port}
|%{Calling-Station-Id}|%{Called-Station-Id}|||%{Framed-IP-Address}
</AuthBy>
</Handler>

<Handler Called-Station-Id = "101300">
AccountingHandled
SessionDatabase POSTPAID
RewriteUsername tr/A-Z/a-z/
AcctLogFileName %L/POSTPAID/%Y-%m-%d-detail
#PasswordLogFileName %L/POSTPAID/%Y-%m-%d-password
AcctLogFileFormat %m %d %Y %H:%M:%S NAS-IP-Address=%{NAS-IP-Address} NAS-Port=%{NAS-Port}
User-Name=%{User-Name} Called-Station-Id=%{Called-Station-Id} Calling-Station-Id=%{Calling-Station-Id}
Acct-Status-Type=%{Acct-Status-Type} Service-Type=%{Service-Type} Acct-Session-Id=%{Acct-Session-Id}
Framed-Protocol=%{Framed-Protocol} Framed-IP-Address=%{Framed-IP-Address}
Acct-Session-Time=%{Acct-Session-Time} Tunnel-Server-Auth-ID=%{Tunnel-Server-Auth-ID}
Acct-Terminate-Cause=%{Acct-Terminate-Cause}
#PreAuthHook file:"%D/updatesessiontime.hook"
AuthByPolicy ContinueWhileReject
<AuthBy SQL>
AuthSelect select trim(ENCRYPTED_PASSWORD), EXPIRATION, CLI, DEFAULTREPLY,
time_func3_RND(cli), time_func3_RND(cli)
from pps_ppaid.pps_SUBSCRIBER where CLI='%{Calling-Station-Id}' and
USERNAME = '%n' and plantype = 0
#AuthColumnDef 0, User-Password, check
AuthColumnDef 0, Encrypted-Password, check
AuthColumnDef 1, Expiration, check
AuthColumnDef 2, Calling-Station-Id, check
AuthColumnDef 3, GENERIC, reply
AuthColumnDef 4, Session-Timeout, reply
AuthColumnDef 5, Ascend-Maximum-Time, reply

DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.***.***)
(PORT=1521)) (CONNECT_DATA=(SID=pps)))
DBUsername pps_ppaid
DBAuth *************
Timeout 10
FailureBackoffTime 90
AccountingTable pps_ppaid.ACCOUNTING
AccountingStopsOnly
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP_DATE,Timestamp,formatted-date,to_date('%e %m %Y %H:%M:%S',
'DD-MM-YYYY HH24 MI SS')
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
AcctColumnDef CALLEDSTATIONID,Called-Station-Id
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctFailedLogFileName %L/CLUSTER/testnetra.postpaid.log
AcctLogFileFormat %{User-Name}|%m %d %Y %H:%M:%S|%{Acct-Status-Type}||||%{Acct-Session-Id}
|%{Acct-Session-Time} |%{Acct-Terminate-Cause}|%{NAS-IP-Address}|%{NAS-Port}
|%{Calling-Station-Id}|%{Called-Station-Id}|||%{Framed-IP-Address}
</AuthBy>
<AuthBy SQL>
AuthSelect select trim(ENCRYPTEDPASSWD), DEFAULTREPLY, SESSIONREPLY, SESSIONREPLY from
pps_ppaid.SUBSCRIBERS where USERNAME='%n'
#AuthColumnDef 0, User-Password, check
AuthColumnDef 0, Encrypted-Password, check
AuthColumnDef 1, GENERIC, reply
AuthColumnDef 2, Session-Timeout, reply
AuthColumnDef 3, Ascend-Maximum-Time, reply

DBSource dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.***.***)
(PORT=1521)) (CONNECT_DATA=(SID=pps)))
DBUsername pps_ppaid
DBAuth **********
Timeout 10
FailureBackoffTime 90
AccountingTable pps_ppaid.ACCOUNTING
AccountingStopsOnly
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
AcctColumnDef CALLEDSTATIONID,Called-Station-Id
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctFailedLogFileName %L/CLUSTER/testnetra.postpaid.log.
AcctLogFileFormat %{User-Name}|%m %d %Y %H:%M:%S|%{Acct-Status-Type}||||%{Acct-Session-Id}
|%{Acct-Session-Time} |%{Acct-Terminate-Cause}|%{NAS-IP-Address}|%{NAS-Port}
|%{Calling-Station-Id}|%{Called-Station-Id}|||%{Framed-IP-Address}
</AuthBy>
</Handler>

<Handler>
<AuthBy FILE>
Filename %D/rejected.users
</AuthBy>
</Handler>




******************************************************************************
SQL DUMP (Not part of oracle config)
******************************************************************************


-- MySQL dump *.**
--
-- Host: localhost Database: adminDB
---------------------------------------------------------
-- Server version *.**.**

--
-- Table structure for table 'ACCOUNTING'
--

CREATE TABLE ACCOUNTING (
USERNAME char(50) NOT NULL default '',
TIME_STAMP int(11) default NULL,
ACCTSTATUSTYPE char(10) default NULL,
ACCTDELAYTIME int(11) default NULL,
ACCTINPUTOCTETS int(11) default NULL,
ACCTOUTPUTOCTETS int(11) default NULL,
ACCTSESSIONID char(30) default NULL,
ACCTSESSIONTIME int(11) default NULL,
ACCTTERMINATECAUSE int(11) default NULL,
NASIDENTIFIER char(50) default NULL,
NASPORT int(11) default NULL,
FRAMEDIPADDRESS char(22) default NULL,
CALLEDSTATIONID char(20) default NULL,
CALLINGSTATIONID char(20) default NULL,
KEY ACCOUNTING_I (USERNAME)
) TYPE=MyISAM;

--
-- Dumping data for table 'ACCOUNTING'
--


INSERT INTO ACCOUNTING VALUES ('*******',0,'Stop',NULL,NULL,NULL,'00001234',1000,NULL,'203.63.***.*',
1234,'202.163.***.***','123456789','987654321');

etc....

CREATE TABLE SUBSCRIBERS (
USERNAME char(15) NOT NULL default '',
PASSWORD char(30) default NULL,
ENCRYPTEDPASSWORD char(30) NOT NULL default '',
EXPIRATION char(12) binary default '*** * 2005',
DEFAULTREPLY char(200) binary default 'Service-Type = Framed-User,Framed-Protocol = PPP,
Framed-MTU = 1500,Framed-Compression = Van-Jacobson-TCP-IP',
FRAMEDIP char(20) binary default '0.0.0.0',
SESSIONREPLY char(7) default NULL,
USEDTIME int(11) default NULL,
MAXTIME int(11) default NULL,
STATUS char(1) binary default '0',
DATEACTIVATION date default NULL,
COMMENT char(100) default NULL,
COMPANYNAME char(50) default NULL,
UNIQUE KEY USERNAME_I (USERNAME)
) TYPE=MyISAM;

--
-- Dumping data for table 'SUBSCRIBERS'
--


INSERT INTO SUBSCRIBERS VALUES ('****','*********','**********','*** ** 2005','Service-Type = Framed-User,
Framed-Protocol = PPP, Framed-MTU = 1500,Framed-Compression = Van-Jacobson-TCP-IP',
'202.***.***.***',NULL,NULL,NULL,'1',NULL,NULL,'eREBZ');
INSERT INTO SUBSCRIBERS VALUES ('****','**********','**********','**** ** 2006','Service-Type = Framed-User,
Framed-Protocol = PPP,Framed-MTU = 1500, Framed-Compression = Van-Jacobson-TCP-IP',
'202.***.***.***',NULL,NULL,NULL,'1',NULL,NULL,'eREBZ');

etc....