(RADIATOR) RADONLINE problems. No queries.

[Charles Alexander McCain]

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/^([^@]+)\@somewhere.net/$1/
RewriteUsername         s/^([^@]+)\@elsewhere.net/$1/
RewriteUsername         s/\s+//g
RewriteUsername         tr/A-Z/a-z/
<Client DEFAULT>
                                                                                                              
        Secret letMEin
        DupInterval 0
                                                                                                              
</Client>

<Realm DEFAULT>
RewriteUsername s/^([^@]+).*/$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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.