(RADIATOR) SQL Accounting not working

[Hugh Irvine]

Hello again Todd -

It sounds like either you are not receiving any accounting requests, or 
the database insert is failing.

regards

Hugh



On 19 Jan 2004, at 17:33, Hugh Irvine wrote:

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

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.