(RADIATOR) Re: Problem about SQL 7 SP3
Hugh Irvine
hugh at open.com.au
Thu Feb 28 02:12:08 CST 2002
Hello Chairath -
You will need to make the same change that you made to the Radiator
configuration file in the Radmin file called "Radmin/Sql.pm". You will either
need to change the file in the Radmin distribution directory and re-install,
or you can change the file in the Perl hierarchy directly.
regards
Hugh
On Thu, 28 Feb 2002 12:50, Chairath K wrote:
> Hello Hugh,
>
> Now I can start Radaitor Service by re-setting ODBC System DSN . But the
> problem still occure when I use Radmin. Error Message below is shown when I
> use web-browser to open Radmin
>
> Error
> A serious error has occurred:
> Could not connect to SQL database dbi:ODBC:Radmin: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Login failed for user 'RADTEMP\IUSR_RADTEMP'.
> (SQL-28000)(DBD: db_login/SQLConnect err=-1)
>
> So how can I fix it?
>
> Regards,
> Chairath
>
> P.S. Our system is running Radiator 2.18 and Radmin 1.4 on Windows NT
>
>
>
> ----- Original Message -----
> From: Chairath K
> To: Hugh Irvine
> Sent: Wednesday, February 27, 2002 10:52 AM
> Subject: Problem about SQL 7 SP3
>
>
> Hello Hugh,
>
> I have install Service Pack 3 of Microsoft SQL server 7.0 for NT in oder
> for Replication Application . But after I install it , I can't start
> Radiator Service . So how can I fix it to work provperly with SQL 7 SP3 ?
>
> Regards,
> Chairath
>
> Wed Feb 27 10:37:33 2002: DEBUG: Adding Clients from SQL database
> Wed Feb 27 10:37:33 2002: DEBUG: Query is: select
> NASIDENTIFIER,
> SECRET,
> IGNOREACCTSIGNATURE,
> DUPINTERVAL,
> DEFAULTREALM,
> NASTYPE,
> SNMPCOMMUNITY,
> LIVINGSTONOFFS,
> LIVINGSTONHOLE,
> FRAMEDGROUPBASEADDRESS,
> FRAMEDGROUPMAXPORTSPERCLASSC,
> REWRITEUSERNAME,
> NOIGNOREDUPLICATES,
> PREHANDLERHOOK from RADCLIENTLIST
>
> Wed Feb 27 10:37:33 2002: ERR: Execute failed for 'select
> NASIDENTIFIER,
> SECRET,
> IGNOREACCTSIGNATURE,
> DUPINTERVAL,
> DEFAULTREALM,
> NASTYPE,
> SNMPCOMMUNITY,
> LIVINGSTONOFFS,
> LIVINGSTONHOLE,
> FRAMEDGROUPBASEADDRESS,
> FRAMEDGROUPMAXPORTSPERCLASSC,
> REWRITEUSERNAME,
> NOIGNOREDUPLICATES,
> PREHANDLERHOOK from RADCLIENTLIST': [Microsoft][ODBC SQL Server
> Driver][SQL Server]Invalid object name 'RADCLIENTLIST'. (SQL-S0002)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
> prepared. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1) Wed Feb 27
> 10:37:33 2002: ERR: Execute failed for 'select
> NASIDENTIFIER,
> SECRET,
> IGNOREACCTSIGNATURE,
> DUPINTERVAL,
> DEFAULTREALM,
> NASTYPE,
> SNMPCOMMUNITY,
> LIVINGSTONOFFS,
> LIVINGSTONHOLE,
> FRAMEDGROUPBASEADDRESS,
> FRAMEDGROUPMAXPORTSPERCLASSC,
> REWRITEUSERNAME,
> NOIGNOREDUPLICATES,
> PREHANDLERHOOK from RADCLIENTLIST': [Microsoft][ODBC SQL Server
> Driver][SQL Server]Invalid object name 'RADCLIENTLIST'. (SQL-S0002)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
> prepared. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
>
> ---------------------------------------------------------------------------
>----------------------------------------------------------------------------
>------------------------------------------------------------ Foreground
> LogStdout
> LogDir d:/Radiator-2.18/log
> DbDir d:/Radiator-2.18
> LogFile %L/logfile-%d-%m-%Y
>
> # Dont turn this up too high, since all log messages are logged
> # to the RADMESSAGES table in the database. 3 will give you everything
> # except debugging messages
> Trace 4
>
>
> # PreClientHook to add NAS-Port attribute
> PreClientHook file:"%D/addNASPort"
>
> # You will probably want to change this to suit your site.
> # You should list all the clients you have, and their secrets
> # If you are using the Radmin Clients table, you wil probably
> # want to disable this.
> #<Client DEFAULT>
> # Secret mysecret
> # DupInterval 0
> #</Client>
>
> # You can put additonal (or all) client details in your Radmin
> # database table
> # and get their details from there with something like this:
> # You can then use the Radmin 'Add Radius Client' to add new clients.
> <ClientListSQL>
> DBSource dbi:ODBC:Radmin
> DBUsername xxxx
> DBAuth xxxx
> </ClientListSQL>
>
> #<AuthBy RADIUS>
> # Identifier ProxyTofunk
> # Host 10.2.0.6
> # Secret test
> #</AuthBy>
>
> #<Realm funk>
> # strip Realm
> # RewriteUsername s/^([^@]+).*/$1/
> # AuthBy ProxyTofunk
> #</Realm>
>
> <AuthBy RADMIN>
> Identifier RADMINAUTH
> # Change DBSource, DBUsername, DBAuth for your database
> # See the reference manual. You will also have to
> # change the one in <SessionDatabse SQL> below
> # so its the same
> DBSource dbi:ODBC:Radmin
> DBUsername xxx
> DBAuth xxx
> DateFormat %e %m %Y %T
>
> AuthSelect select PASS_WORD,STATICADDRESS,TIMELEFT,MAXLOGINS from RADUSERS
> where USERNAME='%n' and BADLOGINS < 8 and VALIDFROM < %t and VALIDTO > %t
>
> # You can add to or change these if you want, but you
> # will probably want to change the database schema first
> AccountingTable RADUSAGE
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type,integer
> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
> AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
> AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> AcctColumnDef NASIDENTIFIER,NAS-Identifier
> AcctColumnDef NASIDENTIFIER,NAS-IP-Address
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef DNIS,Called-Station-Id
> AcctColumnDef DATE,Timestamp,integer-date
> # This updates the time and octets left
> # for this user
> AcctSQLStatement update RADUSERS set
> TIMELEFT=TIMELEFT-0%{Acct-Session-Time},
> OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets},
> OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets} where USERNAME='%n'
>
> </AuthBy>
>
> <AuthBy FILE>
> Identifier CheckTime
> Filename %D/adsl.users
> </AuthBy>
>
> <AuthBy GROUP>
> Identifier WithIdleTimeout
> AuthBy RADMINAUTH
> # These are the classic things to add to each users
> # reply to allow a PPP dialup session. It may be
> # different for your NAS. This will add some
> # reply items to everyone's reply
> AddToReply Framed-Protocol = PPP,\
> Service-Type = Framed-User,\
> Framed-IP-Netmask = 255.255.255.255,\
> Framed-Routing = None,\
> Framed-MTU = 1500,\
> Framed-Compression = Van-Jacobson-TCP-IP,\
> Idle-Timeout = 600,\
> Class = %{NAS-Port}
> </AuthBy>
>
>
> <AuthBy GROUP>
> Identifier WithOutIdleTimeout
> AuthBy RADMINAUTH
> # These are the classic things to add to each users
> # reply to allow a PPP dialup session. It may be
> # different for your NAS. This will add some
> # reply items to everyone's reply
> AddToReply Framed-Protocol = PPP,\
> Service-Type = Framed-User,\
> Framed-IP-Netmask = 255.255.255.255,\
> Framed-Routing = None,\
> Framed-MTU = 1500,\
> Framed-Compression = Van-Jacobson-TCP-IP,\
> Class = %{NAS-Port}
> </AuthBy>
>
> <AuthBy GROUP>
> Identifier TimeZone
> AuthBy CheckTime
> # These are the classic things to add to each users
> # reply to allow a PPP dialup session. It may be
> # different for your NAS. This will add some
> # reply items to everyone's reply
> AddToReply Framed-Protocol = PPP,\
> Service-Type = Framed-User,\
> Framed-IP-Netmask = 255.255.255.255,\
> Framed-Routing = None,\
> Framed-MTU = 1500,\
> Framed-Compression = Van-Jacobson-TCP-IP,\
> Idle-Timeout = 600,\
> Session-Timeout = "until Time",\
> Class = %{NAS-Port}
> </AuthBy>
>
>
> <Handler Request-Type=Accounting-Request>
> AuthBy RADMINAUTH
> </Handler>
>
> <Handler Realm=hz.qnet>
> AuthBy TimeZone
> </Handler>
>
> <Handler Realm=qnetcorp>
> AuthBy WithOutIdleTimeout
> </Handler>
>
> <Handler Realm=qnetoffice>
> AuthBy WithOutIdleTimeout
> </Handler>
>
> <Handler Realm=o64.qnet>
> AuthBy WithOutIdleTimeout
> </Handler>
>
> <Handler Realm=o128.qnet>
> AuthBy WithOutIdleTimeout
> </Handler>
>
> <Handler Realm=o256.qnet>
> AuthBy WithOutIdleTimeout
> </Handler>
>
> <Handler Realm=o512.qnet>
> AuthBy WithOutIdleTimeout
> </Handler>
>
> <Handler>
> AuthBy WithIdleTimeout
> </Handler>
>
>
> # Handle User with NO Realm with RADMIN
> #<Realm>
> # AuthBy RADMINAUTH
> #</Realm>
>
> # Handle everyone with RADMIN
> #<Realm DEFAULT>
> # AuthBy RADMINAUTH
> #</Realm>
>
> <SessionDatabase SQL>
> # This database spec usually should be exactly the same
> # as in <AuthBy RADMIN> above
> DBSource dbi:ODBC:Radmin
> DBUsername xxx
> DBAuth xxx
> ClearNasQuery
> </SessionDatabase>
--
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.
More information about the radiator
mailing list