(RADIATOR) Log SYSLOG

Faisal Imtiaz Faisal at Snappydsl.net
Mon Oct 9 22:06:50 CDT 2006


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.


More information about the radiator mailing list