(RADIATOR) SQL Accounting not working

Your Own ISP .com mylist at lightwavetech.com
Mon Jan 19 00:08:47 CST 2004


I have been breaking my head on this for a few days off and on.

I think I have my config file correct but I never see anything in my
"accounting" table..

I see that Radiator is logging to the text file just fine, I can dialup
through a NAS an get authed fine. I even have Radiator checking the list of
phone numbers for each realm in a MySQL file.

All my MySQL perms are right etc..

I am at a loss.. I have pasted my config below, I have removed most of the
realms so you all won't have to view such a large file.

Any clues? Thanks!

Thanks,
Todd Routhier
Lightwave Technologies, LLC.

--
Start Your Own Internet Service!
http://www.YourOwnISP.com

ISP Information Exchange
http://www.ISPboard.com


############Config###############

Foreground
#LogStdout
LogDir  c:/Program Files/Radiator
DbDir  c:/Program Files/Radiator
AuthPort 1645
AcctPort 1646

# This will log at DEBUG level: very verbose
# User a lower trace level in production systems, typically use 3
Trace   4

# You will probably want to add other Clients to suit your site,
# one for each NAS you want to work with. This will work
# at least with radpwtst running on the local machine
    <Client DEFAULT>
 Secret MySecret
 DupInterval 0
    </Client>

    <Realm gtest.us>
        AuthByPolicy ContinueWhileAccept
        AuthBy MySQLAuth
        #AuthBy CheckCalledStationId_G
    </Realm>

<AuthBy SQL>
 Identifier CheckCalledStationId_G
 DBSource dbi:mysql:<DatabaseName>:<MySqlIP>:<MySQLPort>
 DBUsername   <UID>
 DBAuth  <PASS>
 NoDefault
 AuthSelect select Action from netg \
  where DataNumber = '%{Called-Station-Id}'
 AuthColumnDef 0, GENERIC, check
</AuthBy>


    <AuthBy SQL>
  Identifier MySQLAuth
 DBSource dbi:mysql:<DatabaseName>:<MySqlIP>:<MySQLPort>
 DBUsername   <UID>
 DBAuth  <PASS>

 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

    </AuthBy>






===
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