(RADIATOR) SQL Accounting not working

[Hugh Irvine]

Hello Todd -

I will need to see a trace 4 debug from Radiator showing what is 
happening.

regards

Hugh


On 19 Jan 2004, at 17:08, Your Own ISP .com wrote:

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

NB: 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.
-
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.