(RADIATOR) Re: Problem about SQL 7 SP3
Chairath K
chairath at lensodatacom.co.th
Wed Feb 27 19:50:35 CST 2002
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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020228/d1fb0c3d/attachment.html>
More information about the radiator
mailing list