Hello Jay,
On Apr 3, 2:39pm, Jay West wrote:
> Subject: (RADIATOR) AuthbyRADMIN logging file problems?
> We're having problems with the logfile stuff when using radmin.
>
> Here's our radmin.cfg file:
>
> ==============begin paste================
> AuthPort 1812
> AcctPort 1813
> DictionaryFile /usr/local/etc/raddb/dictionary
> PidFile /var/run/radiusd.pid
> Trace 3
> LogDir /var/log/radius
> LogFile logfile
>
> <ClientListSQL>
> DBSource dbi:mysql:radmin:pearl.tseinc.com
> DBUsername aaaaaa
> DBAuth xxxxxxxx
> </ClientListSQL>
>
> <SessionDatabase SQL>
> DBSource dbi:mysql:radmin:pearl.tseinc.com
> DBUsername aaaaaaa
> DBAuth xxxxxxxx
> </SessionDatabase>
>
> <Realm DEFAULT>
> <AuthBy RADMIN>
> DBSource dbi:mysql:radmin:pearl.tseinc.com
> DBUsername aaaaaaa
> DBAuth xxxxxxxx
>
> # Dont check MAXLOGINS, but do take note of these...
> # FRAMED_NETMASK,FRAMED_FILTER_ID,MAXIDLETIME
> AuthSelect select PASS_WORD,STATICADDRESS,TIMELEFT,\
> NULL,FRAMED_NETMASK,FRAMED_FILTER_ID,\
> MAXIDLETIME \
> from RADUSERS where \
> USERNAME='%n' and BADLOGINS < 5 and \
> VALIDFROM < %t and VALIDTO > %t
> AuthColumnDef 0,Framed-IP-Netmask,reply
> AuthColumnDef 1,Filter-Id,reply
> AuthColumnDef 2,Idle-Timeout,reply
>
> 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=OCTETSOUTLEFT-0%{Acct-Output-Octets} where USERNAME='%n'
>
> AddToReply Service-Type = Framed-User, \
> Framed-Protocol = PPP,\
> Framed-Routing = None,\
> Framed-MTU = 1500,\
> Framed-Compression = Van-Jacobson-TCP-IP
> </AuthBy>
> </Realm>
> =============end paste==============
>
> Several problems...
>
> 1) Even though we have Trace set to 3, radiator is logging lots of level 4
> messages (to RADMESSAGES) which are quite annoying and voluminous :) Any way
> to tell it that trace 3 means just trace 3 and lower?
We have just fixed this problem: basically AuthBy RADMIN was logging everyrhing
and ignoring the trace level. You can find a fixed version that honours the
global Trace level in the patches area at
http://www.open.com.au/radiator/downloads/patches-2.15/AuthRADMIN.pm
We apologise for that.
>
> 2) Radiator set up as above is logging to three places....
> /var/log/radius/logfile, /usr/local/etc/raddb/logfile, and the RADMESSAGES
> table. Is there any way to tell it to log to RADMESSAGES via SQL ONLY -
> nowhere else?
Hmmm, AuthBy RADMIN will only log messages that originate _inside_ the AuthBy
RADMIN. We have a new version of LogSQL avaialble that can be configured to log
anywhere by changing the LogQuery paramter. You may want to use that to catch
mesages that originate outside AuthBy RADMIN?
If so I will send you an early release of the code.
Cheers.
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
2000, NT, MacOS X
===
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.
