(RADIATOR) Msql & Radiator "Big Trouble" HELP

[Hugh Irvine]

Hello Zack -

Please note that "msql" is an open source database - it is *not* 
Microsoft SQL.

If you are using Microsoft MS-SQL, you should use the 
"goodies/sybaseCreate.sql" script.

Once you have built the tables, you should simply use DBD-ODBC to 
connect to the database.

You will find a note on this in section 24.7 of the Radiator 3.5 
reference manual ("doc/ref.html").

regards

Hugh


On Monday, Mar 10, 2003, at 19:55 Australia/Melbourne, info at GoldenIT 
wrote:

> 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.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
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.