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

<Realm DEFAULT>
RewriteUsername s/^([EMAIL PROTECTED]).*/$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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.