i have just installed a fresh copy of Radiator and Radmin, everything seems
to work just fine, got my NAS auth'ing, got the SQL stuff working, however, i
seem to have 2 problems...
neither the radwho.cgi included with Radiator nor the Current Sessions link
off listUsers.pl from Radmin ever show me who is online.
i turned the trace up to level 4, and i see where radiator is inserting
information in RADONLINE and RADUSAGE. if i manually select * from RADUSAGE
i can see where data is actually being inserted. however, i never see
anything inserted into RADONLINE. however, if i go to the Usage Summary
link from listUsers.pl accurate data shows up there.
i'm pretty sure this is something minor that i'm missing. here are some more
details:
linux 2.2.16, mysql 3.22.32, Radiator 2.17.1, Radmin 1.4, cisco 5300 VoIP.
------------radius.cfg
#Foreground
#LogStdout
#LogDir /var/adm/log/
#LogFile %L/radius.log
DbDir /usr/local/etc/raddb/
DictionaryFile %D/dictionary
PidFile /var/run/radiusd.pid
# User a lower trace level in production systems:
Trace 5
<Client 10.0.65.66>
Secret xxxxxx
DupInterval 0
</Client>
<Realm DEFAULT>
<AuthBy RADMIN>
DBSource dbi:mysql:radmin:localhost
DBUsername radmin
DBAuth xxxxxxxxxxx
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
AcctSQLStatement update RADUSERS set
TIMELEFT=TIMELEFT-0%{Acct-Session-Time},
OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets}, OCTETSOUTLEFT=OCT
ETSOUTLEFT-0%{Acct-Output-Octets} where USERNAME='%n'
AcctFailedLogFileName %D/missedaccounting
</AuthBy>
</Realm>
<SessionDatabase SQL>
DBSource dbi:mysql:radmin:localhost
DBUsername radmin
DBAuth xxxxxxxxxx
</SessionDatabase>
any and all help would be apprciated!
#---------------------------------------------------------------#
# Ken Sain [EMAIL PROTECTED] #
# Systems Administrator 850.309.7999 - office #
# Genesis Communications Network 888.598.8942 - pager #
#---------------------------------------------------------------#
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
