(RADIATOR) Log SYSLOG
Hugh Irvine
hugh at open.com.au
Tue Oct 10 00:04:15 CDT 2006
Hello Faisal -
See this item in the FAQ:
file:///Local/src/Radiator/Radiator-3.15/doc/faq.html#68
regards
Hugh
On 10 Oct 2006, at 13:06, Faisal Imtiaz wrote:
>
> Hello,
>
> I am having a problem in getting Radiator to log to SYSLOG, I am
> running
> FreeBSD .
>
> Using Radiator Ver 3.12 on FreeBSD.
> Using Syslog-ng -> fully operational.
> Test messages using 'logger' show up in the syslog
> Did the h2ph * sys/ *
>
> Debug Trace does not show any errors or attempt to output to syslog.
>
> Any suggestions to what I may be doing wrong ?
>
> Thanks. !
> ---------------------------------------------------------------
>
>
> My Radius.cfg
> -----------------------------------
> #Foreground
> LogStdout
> LogDir /usr/local/etc/radiator
> DbDir /usr/local/etc/radiator
>
> AuthPort 1645,1812
> AcctPort 1646,1813
>
> # Priority level of trace messages to be logged in the log file (0
> - 5)
> Trace 3
>
> <Realm negia.net>
> <AuthBy RADIUS>
> Host 69.55.xx.xx
> Secret xxxxx
> AuthPort 1812
> AcctPort 1813
> </AuthBy>
>
> <ClientListSQL>
> DBSource dbi:mysql:radius:localhost
> DBUsername xxxxx
> DBAuth xxxxxxxx
> RefreshPeriod 30
> </ClientListSQL>
>
> <AuthLog SQL>
> # MySQL DB, DB radius, host localhost
> DBSource dbi:mysql:radius:localhost
> DBUsername xxxxxx
> DBAuth xxxxxxxxxxx
> Table RADAUTHLOG
> SuccessQuery insert into RADAUTHLOG (TIME_STAMP,
> USERNAME,
> TYPE, REASON, PASSWORD) values ('%l','%n', %0, 'Succeeded','%P')
> FailureQuery insert into RADAUTHLOG (TIME_STAMP,
> USERNAME,
> TYPE, REASON, PASSWORD) values ('%l','%n', %0, 'Failed','%P')
> LogSuccess 1
> LogFailure 1
>
> </AuthLog>
>
> </Realm>
>
>
>
> <Realm DEFAULT>
> <AuthBy SQL>
> # MySQL DB, DB radius, host localhost
> DBSource dbi:mysql:radius:localhost
> DBUsername xxxxxxx
> DBAuth xxxxxxx
>
> # Define Table and Columns for Authentication
> AuthSelect select PASSWORD, SERVICETYPE,
> FRAMEDPROTOCOL,
> TRAFFICSHAPE, ACL, PORTLIMIT, TIMELEFT, IPPOOL, FRAMEDIPADD,
> FRAMEDIPNETMASK, FRAMEDROUTE, FRAMEDROUTING, DNS \
> from SUBSCRIBERS where USERNAME = %0
> AuthColumnDef 0, Password, check
> AuthColumnDef 1, GENERIC, check
> AuthColumnDef 2, GENERIC, reply
> AuthColumnDef 3, GENERIC, reply
> AuthColumnDef 4, GENERIC, reply
> AuthColumnDef 5, GENERIC, reply
> AuthColumnDef 6, GENERIC, reply
> AuthColumnDef 7, GENERIC, reply
> AuthColumnDef 8, GENERIC, reply
> AuthColumnDef 9, GENERIC, reply
> AuthColumnDef 10, GENERIC, reply
> AuthColumnDef 11, GENERIC, reply
> AuthColumnDef 12, GENERIC, reply
>
> # Define Table and Columns for Accounting
> AccountingTable ACCOUNTING
> AcctColumnDef USERNAME,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,formatted-date,\
> '%Y/%m/%e %H:%M:%S'
> 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 NASIPADDRESS,NAS-IP-Address
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> </AuthBy>
> <ClientListSQL>
> DBSource dbi:mysql:radius:localhost
> DBUsername xxxxxx
> DBAuth xxxxxxxx
> RefreshPeriod 30
> </ClientListSQL>
>
> <SessionDatabase SQL>
> DBSource dbi:mysql:radius:localhost
> DBUsername xxxxxx
> DBAuth xxxxxxxx
> AddQuery insert into RADONLINE (USERNAME,
> NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
> NASPORTTYPE, SERVICETYPE) values ('%u', '%{NAS-Identifier}', '%2', %
> 3, '%A',
> '%{Framed-IP-Address}', '%{NAS-Port-Type}', '%{Service-Type}')
> DeleteQuery delete from RADONLINE where USERNAME=%0
> </SessionDatabase SQL>
>
> # Log accounting to a detail file
> AcctLogFileName /usr/local/etc/radiator/detail
>
> <AuthLog SQL>
> # MySQL DB, DB radius, host localhost
> DBSource dbi:mysql:radius:localhost
> DBUsername xxxxx
> DBAuth xxxxxxxxx
> Table RADAUTHLOG
> SuccessQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME,
> TYPE, REASON, PASSWORD) values ('%l','%n', %0, 'Succeeded','%P')
> FailureQuery insert into RADAUTHLOG (TIME_STAMP,
> USERNAME,
> TYPE, REASON, PASSWORD) values ('%l','%n', %0, 'Failed','%P')
> LogSuccess 1
> LogFailure 1
> </AuthLog>
> <Log SYSLOG>
> # Identifier
> # Log to syslog facility called 'radius'
> Facility local5
> # Show everything up to and including INFO level
> # Trace 4
> # # Log to a remote host via syslog over udp:
> # LogHost 127.0.0.1
> LogSock udp
> # # LogSuccess 1
> # # LogFailure 1
> # # SuccessFormat %l,%n,%0,Success
> # # FailureFormat %l,%n,%0,Failure,%P
> </Log>
>
> </Realm>
>
> ---------------------------------------------------
>
>
> Faisal Imtiaz
> Computer Office Solutions Inc. /SnappyDSL.net
> Ph: (305) 663-5518
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
NB:
Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/
radiator)?
Have you had a quick look on Google (www.google.com)?
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, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.
--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list