Hello Charles -
Your configuration file is incorrect - it should look like what is shown below (note the Realm clause at the end).
regards
Hugh
#Foreground #LogStdout LogDir /var/adm/radacct DbDir /etc/raddb
SnmpgetProg /usr/local/bin/snmpget Trace 4 RewriteUsername s/^([EMAIL PROTECTED])[EMAIL PROTECTED]/$1/ RewriteUsername s/^([EMAIL PROTECTED])[EMAIL PROTECTED]/$1/ RewriteUsername s/\s+//g RewriteUsername tr/A-Z/a-z/
<Client DEFAULT>
Secret letMEin
DupInterval 0
</Client><SessionDatabase SQL>
DBSource dbi:mysql:radius
DBUsername xxxxxxxx
DBAuth xxxxxxxxxxx
Identifier SQLS AddQuery insert into RADONLINE (USERNAME,\
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,\
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,DNIS) \
values ('%n', '%N',\
'%{NAS-Port}', '%{Acct-Session-Id}', '%o',\
'%{Framed-IP-Address}', '%{NAS-Port-Type}',\
'%{Service-Type}','%{Called-Station-Id}')
DeleteQuery delete from RADONLINE where \
USERNAME = '%n' and NASIDENTIFIER='%N' \
and NASPORT='%{NAS-Port}'ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE \
where ACCTSESSIONID = '%{Acct-Session-Id}'
</SessionDatabase>
<ClientListSQL>
DBSource dbi:mysql:radius
DBUsername xxxxxxxx
DBAuth xxxxxxxxxx
</ClientListSQL><AuthBy UNIX>
DefaultSimultaneousUse 1
Identifier System
Filename /etc/shadow
</AuthBy><AuthBy LDAP2>
DefaultSimultaneousUse 1
Identifier LDAP
Host 127.0.0.1
Port 389
AuthDN uid=searchuser,dc=centurytel,dc=net
AuthPassword xxxxxxxxxx
BaseDN %0=%1,ou=people,dc=centurytel,dc=net
Scope base
UsernameAttr uid
PasswordAttr userPassword
HoldServerConnection
SearchFilter (&(gecos=active)(uid=%1))
AuthAttrDef gidNumber, gid-attr, request
DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP
</AuthBy><AuthBy SQL>
#NoDefault
DefaultSimultaneousUse 1
Identifier CheckSQL DBSource dbi:mysql:radius
DBUsername xxxxxxxxx
DBAuth xxxxxxxxAccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
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
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
from SUBSCRIBERS \
where USERNAME=%0AuthColumnDef 0, User-Password, check
AuthColumnDef 1, GENERIC, check
AuthColumnDef 2, GENERIC, reply
DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP
</AuthBy><Realm DEFAULT>
SessionDatabase SQLS
RewriteUsername s/^([EMAIL PROTECTED]).*/$1/
PostAuthHook file:"%D/postHook"
AcctLogFileName %L/%N/detail #AuthByPolicy ContinueWhileReject
AuthByPolicy ContinueUntilAccept
AuthBy LDAP
AuthBy CheckSQL
AuthBy System</Realm>
On Tuesday, Jul 29, 2003, at 00:59 Australia/Melbourne, Charles Alexander McCain wrote:
Hello,
I'm having an issue with my config. It is not throwing anything into
RADONLINE, in my trace4, i'm not even seeing queries being sent. Perhaps
my configs are wrong?
Here is a copy of the config.
#Foreground #LogStdout LogDir /var/adm/radacct DbDir /etc/raddb
SnmpgetProg /usr/local/bin/snmpget Trace 4 RewriteUsername s/^([EMAIL PROTECTED])[EMAIL PROTECTED]/$1/ RewriteUsername s/^([EMAIL PROTECTED])[EMAIL PROTECTED]/$1/ RewriteUsername s/\s+//g RewriteUsername tr/A-Z/a-z/ <Client DEFAULT>
Secret letMEin DupInterval 0
</Client>
<Realm DEFAULT> RewriteUsername s/^([EMAIL PROTECTED]).*/$1/
PostAuthHook file:"%D/postHook" AcctLogFileName %L/%N/detail
<SessionDatabase SQL>
DBSource dbi:mysql:radius DBUsername xxxxxxxx DBAuth xxxxxxxxxxx Identifier SQLS
AddQuery insert into RADONLINE (USERNAME,\ NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,\ FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,DNIS) \ values ('%n', '%N',\ '%{NAS-Port}', '%{Acct-Session-Id}', '%o',\ '%{Framed-IP-Address}', '%{NAS-Port-Type}',\ '%{Service-Type}','%{Called-Station-Id}')
DeleteQuery delete from RADONLINE where \ USERNAME = '%n' and NASIDENTIFIER='%N' \ and NASPORT='%{NAS-Port}'
ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE \
where ACCTSESSIONID = '%{Acct-Session-Id}'
</SessionDatabase>
<ClientListSQL>
DBSource dbi:mysql:radius DBUsername xxxxxxxx DBAuth xxxxxxxxxx
</ClientListSQL> <AuthBy UNIX>
DefaultSimultaneousUse 1 Identifier System Filename /etc/shadow
</AuthBy>
<AuthBy LDAP2> DefaultSimultaneousUse 1 Identifier LDAP Host 127.0.0.1 Port 389 AuthDN uid=searchuser,dc=centurytel,dc=net AuthPassword xxxxxxxxxx BaseDN %0=%1,ou=people,dc=centurytel,dc=net Scope base UsernameAttr uid PasswordAttr userPassword HoldServerConnection SearchFilter (&(gecos=active)(uid=%1)) AuthAttrDef gidNumber, gid-attr, request DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP </AuthBy> <AuthBy SQL> #NoDefault DefaultSimultaneousUse 1 Identifier CheckSQL
DBSource dbi:mysql:radius DBUsername xxxxxxxxx DBAuth xxxxxxxx
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
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
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \ from SUBSCRIBERS \ where USERNAME=%0
AuthColumnDef 0, User-Password, check AuthColumnDef 1, GENERIC, check AuthColumnDef 2, GENERIC, reply DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP
</AuthBy>
#AuthByPolicy ContinueWhileReject AuthByPolicy ContinueUntilAccept AuthBy LDAP AuthBy CheckSQL AuthBy System
</Realm> === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
