(RADIATOR) Unable to get AcctFailedLogFileName working

[Hugh Irvine]

Hello Premkumar -

Can you please tell me the name of the registered company that has  
purchased this copy of Radiator?

Please reply to me directly.

In answer to your question, I suspect this has more to do with the  
behaviour of your firewall than Radiator.

A good way to make sure you have all of the accounting data is to  
write everything to a file on the Radiator host.

Something like this:

<Realm ....>

	<AuthBy ...>
		.....
	</AuthBy>
	
	AcctLogFileName	%L/accounting-%Y-%m-%d

</Realm>


This will create a new accounting file for each day of the form

	accounting-2006-07-06

hope that helps

regards

Hugh


On 6 Jul 2006, at 16:45, Premkumar wrote:

> Hi,
>
>   I am trying to get radius to write accounting records to a file  
> when it is not able to contact my MySQL server. My cisco device  
> sends the accounting records to radius which in turn writes to my  
> MySQL database. Everything works fine as long as the database  
> server is reachable. Once I break the link to my database server (I  
> do this my blocking the path from radius server to DB server at my  
> firewall) I notice that the radius server just stops at the last  
> successful MySQL Insert in the log files. Even after 10 minutess  
> nothing gets written to the Failed-log-file. Once the connection to  
> the DB server is resumed, the radius server starts to write again  
> to the DB after a minute or two. So all the accounting records  
> during this gap is lost.
>
>   I have googled as much I can and so far am not able to find  
> anything that can help. I have posted my sql.cfg file for  
> reference. Maybe someone can tell me what I am doing wrong.
>
>
>
> Thanks in advance
>
>
>
> Regards
>
> Premkumar
>
>
>
>
>
> Foreground
>
> LogStdout
>
> LogDir          .
>
> DbDir           .
>
>
>
> AuthPort        XXXX
>
> AcctPort        XXXX
>
>
>
> Trace   4
>
>
>
> <Client 127.0.0.1>
>
>         Secret  ***********
>
>         DupInterval 0
>
> </Client>
>
>
>
> <Client XX.XX.XX.XX>
>
>         Secret ************
>
>         DupInterval 0
>
> </Client>
>
>
>
>
>
>
>
> <Realm>
>
> <AuthBy SQL>
>
>
>
>         DBSource        dbi:mysql:*************
>
>         DBUsername      ************
>
>         DBAuth             *************
>
>
>
>         AccountingStopsOnly
>
>
>
>         AccountingTable ACCOUNTING
>
>
>
>         AcctColumnDef   USERNAME,User-Name
>
>         AcctColumnDef   TIME_STAMP,Timestamp,integer
>
>         AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
>
>         AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
>
>         AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
>
>         AcctColumnDef   ACCTTERMINATECAUSE,cisco-h323-disconnect-cause
>
>         AcctColumnDef   DISCONNECTCAUSE,cisco-h323-disconnect-cause
>
>         AcctColumnDef   NASIDENTIFIER,NAS-IP-Address
>
>         AcctColumnDef   REMOTEADDRESS,cisco-h323-remote-address
>
>         AcctColumnDef   CALLEDNO,Called-Station-Id
>
>
>
>         AcctInsertQuery insert into ****************
>
>
>
>         AcctFailedLogFileName FailLog
>
> </AuthBy>
>
> </Realm>
>
>


NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
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.