(RADIATOR) Msql & Radiator "Big Trouble" HELP

[info@GoldenIT]

Hi Everyone,

I have been trying to install radiator on Windows(2K) with
MsSql(Enterprise2000) server backend. i have had nothing but trouble so far.
is there any docs on this at all, as the doc on Ref.pdf is really very
wrong. even the MsqlCreate,sql file is not working SQL QUERY ANALYSER.
PLEASE HELP anybody have a step by step doc or a rough note on how to get
radiator on MSQL.

So far have been able to modify the MsqlCreate.sql to this and have been
able to add majority of the tables but not theses two

create table RADSQLRADIUS (
       TARGETNAME   char(50),
       HOST1    char(50),
       HOST2    char(50),
       SECRET    char(50),
       AUTHPORT    char(20),
       ACCTPORT    char(20),
       RETRIES    int,
       RETRYTIMEOUT   int,
       USEOLDASCENDPASSWORDS  int,
       SERVERHASBROKENPORTNUMBERS int,
       SERVERHASBROKENADDRESSES  int,
       IGNOREREPLYSIGNATURE  int,
       FAILUREPOLICY   int,
       UNIQUE     RADSQLRADIUS_I (TARGETNAME)
       ON [PRIMARY]
GO



create table RADSQLRADIUSINDIRECT (
       SOURCENAME   char(50),
       TARGETNAME   char(50),
       UNIQUE     RADSQLRADIUSINDIRECT_I (SOURCENAME)
      ) ON [PRIMARY]
GO





Edited TABLE that has been added to the SQl server.

create table SUBSCRIBERS (
 USERNAME char(50),
 PASSWORD char(50),
 ENCRYPTEDPASSWORD char(50),
 CHECKATTR char(200),
 REPLYATTR char(200)
) ON [PRIMARY]
GO

# Create an index for fast lookup
create unique index USERNAME_I on SUBSCRIBERS (USERNAME) ON [PRIMARY]
GO

# You must have at least username and timestamp
# You can add more feilds to the database, but you will also
# have to change AcctColumnDef to make sure they get inserted
create table ACCOUNTING (
 USERNAME char(50),
 TIME_STAMP int,
 ACCTSTATUSTYPE char(10),
 ACCTDELAYTIME int,
 ACCTINPUTOCTETS int,
 ACCTOUTPUTOCTETS int,
 ACCTSESSIONID char(30),
 ACCTSESSIONTIME int,
 ACCTTERMINATECAUSE int,
 NASIDENTIFIER char(50),
 NASPORT  int,
 FRAMEDIPADDRESS char(22)
) ON [PRIMARY]
GO
create index ACCOUNTING_I on ACCOUNTING (USERNAME) ON [PRIMARY]
GO


insert into SUBSCRIBERS (
 USERNAME,
 PASSWORD,
 ENCRYPTEDPASSWORD,
 CHECKATTR,
 REPLYATTR
 )
 values (
 'mikem',
 'fred',
 '1xMKc0GIVUNbE',
 'Service-Type = Framed-User',
 'Framed-Protocol = PPP,Framed-IP-Netmask = 255.255.255.0,cisco-avpair =
"testing testing"'
 )
GO


create table RADONLINE (
 USERNAME char(50),
 NASIDENTIFIER char(50),
 NASPORT  int,
 ACCTSESSIONID char(30),
 TIME_STAMP int,
 FRAMEDIPADDRESS char(22),
 NASPORTTYPE char(10),
 SERVICETYPE char(20)
) ON [PRIMARY]
GO

create unique index RADONLINE_I on RADONLINE
(NASIDENTIFIER, NASPORT) ON [PRIMARY]
GO
create index RADONLINE_I2 on RADONLINE
(USERNAME) ON [PRIMARY]
GO


create table RADPOOL (
 STATE  int NOT NULL,
 TIME_STAMP int,
 EXPIRY  int,
 USERNAME char(50),
 POOL  char(50) NOT NULL,
 YIADDR  char(50) NOT NULL,
 SUBNETMASK char(50) NOT NULL,
 DNSSERVER char(50)
) ON [PRIMARY]
GO


create unique index RADPOOL_I on RADPOOL (YIADDR)ON [PRIMARY]
GO
create index RADPOOL_I2 on RADPOOL (POOL)ON [PRIMARY]
GO


create table RADLOG (
 TIME_STAMP int,
 PRIORITY int,
 MESSAGE  char(200)
) ON [PRIMARY]
GO


create table RADCLIENTLIST (
 NASIDENTIFIER   char(50) NOT NULL,
 SECRET    char(50) NOT NULL,
 IGNOREACCTSIGNATURE  int,
 DUPINTERVAL   int,
 DEFAULTREALM   char(50),
 NASTYPE    char(20),
 SNMPCOMMUNITY   char(20),
 LIVINGSTONOFFS   int,
 LIVINGSTONHOLE   int,
 FRAMEDGROUPBASEADDRESS  char(50),
 FRAMEDGROUPMAXPORTSPERCLASSC int,
 REWRITEUSERNAME   char(50),
 NOIGNOREDUPLICATES  char(50),
 PREHANDLERHOOK   char(50)
) ON [PRIMARY]
GO

create unique index NASIDENTIFIER_I on RADCLIENTLIST (NASIDENTIFIER) ON
[PRIMARY]
GO


insert into RADCLIENTLIST (
 NASIDENTIFIER,
 SECRET,
 DUPINTERVAL
 )
 values (
 '203.63.154.1',
 'mysecret',
 0
 )
GO


create table RADSQLRADIUS (
       TARGETNAME   char(50),
       HOST1    char(50),
       HOST2    char(50),
       SECRET    char(50),
       AUTHPORT    char(20),
       ACCTPORT    char(20),
       RETRIES    int,
       RETRYTIMEOUT   int,
       USEOLDASCENDPASSWORDS  int,
       SERVERHASBROKENPORTNUMBERS int,
       SERVERHASBROKENADDRESSES  int,
       IGNOREREPLYSIGNATURE  int,
       FAILUREPOLICY   int,
       UNIQUE     RADSQLRADIUS_I (TARGETNAME)
       ON [PRIMARY]
GO



create table RADSQLRADIUSINDIRECT (
       SOURCENAME   char(50),
       TARGETNAME   char(50),
       UNIQUE     RADSQLRADIUSINDIRECT_I (SOURCENAME)
      ) ON [PRIMARY]
GO



create table RADSTATSLOG (
       TIME_STAMP   int,
       TYPE    char(20),
       IDENTIFIER   char(30),
       ACCESSACCEPTS   int,
       ACCESSCHALLENGES   int,
       ACCESSREJECTS   int,
       ACCESSREQUESTS   int,
       ACCOUNTINGREQUESTS  int,
       ACCOUNTINGRESPONSES  int,
       BADAUTHACCESSREQUESTS  int,
       BADAUTHACCOUNTINGREQUESTS int,
       BADAUTHREQUESTS   int,
       DROPPEDACCESSREQUESTS  int,
       DROPPEDACCOUNTINGREQUESTS int,
       DROPPEDREQUESTS   int,
       DUPACCESSREQUESTS  int,
       DUPACCOUNTINGREQUESTS  int,
       DUPLICATEREQUESTS  int,
       MALFORMEDACCESSREQUESTS  int,
       MALFORMEDACCOUNTINGREQUESTS int,
       PROXIEDNOREPLY   int,
       PROXIEDREQUESTS   int,
       REQUESTS    int,
       RESPONSETIME   decimal(12,6)
) ON [PRIMARY]
GO

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.