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> |
- Re: (RADIATOR) Re: Problem about SQL 7 SP3 Chairath K
- Re: (RADIATOR) Re: Problem about SQL 7 SP3 Hugh Irvine