[RADIATOR] AcctLogFileName alongside AccountingTable in <AuthBy SQL>

[Heikki Vatiainen]

On 05/10/2012 09:48 AM, Jens Neu wrote:

> unfortunately the error is in my email only, i typed this from my config 
> file and did not copy/paste. I'll be a little bit more verbose, here's my 
> current handler config, just stripped for some AcctColumnDefs. I Tried the 
> "AcctLogFileName %L/detail.local-testing" on various positions. The 
> current one is just based on my common sense. Effect is silence, no error 
> in the log or something (Trace is 4). "Filename %L/authlog.local-testing" 
> works as expected.

Hmm, I took your configuration I tried it on a machine that even does
not have Oracle stuff installed. The SQL insert of course failed, but
detail.loca-testing was created with the accounting record. So for me it
worked as expected.

Are you sure you are not handling accounting with some other Handler (or
possibly Realm)?

Heikki

> <Handler Client-Identifier=local-testing>
> 
>         AcctLogFileName %L/detail.local-testing
> 
>         <AuthLog SQL>
>                 DBSource 
> dbi:Oracle:host=db.host.example.com;service_name=radiator
>                 DBUsername      radiator
>                 DBAuth          radiator
>                 Table RADAUTHLOG
>                 LogSuccess 1
>                 SuccessQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, 
> TYPE) values (%t, '%n', 1)
>                 LogFailure 1
>                 FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, 
> TYPE, REASON) values (%t, '%n', 0, %1)
>         </AuthLog>
> 
>         <AuthLog FILE>
> 
>                 Identifier filelogger_local-testing
>                 Filename %L/authlog.local-testing
> 
>                 LogSuccess 1
>                 LogFailure 1
>         </AuthLog>
> 
>         AuthByPolicy ContinueWhileAccept
> 
>         <AuthBy GROUP>
>                 AuthByPolicy ContinueWhileAccept
>                 <AuthBy SQL>
> 
>                         DBSource 
> dbi:Oracle:host=db.host.example.com;service_name=radiator
>                         DBUsername      radiator
>                         DBAuth  radiator
> 
>                         AuthSelect select PASSWORD from DEVICE where 
> USER_NAME=%0
> 
>                         AccountingTable ACCOUNTING
>                         AcctColumnDef   USERNAME,User-Name
>                 [...]
>                         AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
> 
>                         AcctFailedLogFileName %D/missedaccounting
>                         SQLRecoveryFile %D/missedaccounting
>                  </AuthBy>
> 
>                 <AuthBy DYNADDRESS>
> 
>                         AddressAllocator                allocator.pool1
>                         PoolHint                        pool1
>                 </AuthBy>
>         </AuthBy>
> </Handler>
> 
> 
> www.biotronik.com
> 
> BIOTRONIK SE & Co. KG
> Woermannkehre 1, 12359 Berlin, Germany
> Sitz der Gesellschaft: Berlin, Registergericht: Berlin HRA 6501
> 
> Vertreten durch ihre Komplementärin:
> BIOTRONIK MT SE
> Sitz der Gesellschaft: Berlin, Registergericht: Berlin HRB 118866 B
> Geschäftsführende Direktoren: Christoph Böhmer, Dr. Werner Braun, Dr. 
> Lothar Krings, Dr. Torsten Wolf
> 
> BIOTRONIK - A global manufacturer of advanced Cardiac Rhythm Management 
> systems and Vascular Intervention devices. Quality, innovation, and 
> reliability define BIOTRONIK and our growing success. We are innovators of 
> technologies like the first wireless remote monitoring system - Home 
> Monitoring®, Closed Loop Stimulation and coveted lead solutions as well as 
> state-of-the-art stents, balloons and guide wires for coronary and 
> peripheral indications. We highly invest in the development of drug 
> eluting devices and are leading the industry with our drug eluting 
> absorbable metal scaffold program.
> 
> This e-mail and the information it contains including attachments are 
> confidential and meant only for use by the intended recipient(s); 
> disclosure or copying is strictly prohibited. If you are not addressed, 
> but in the possession of this e-mail, please notify the sender immediately 
> and delete the document.
> 
> 
> 
> www.biotronik.com
> 
> BIOTRONIK SE & Co. KG
> Woermannkehre 1, 12359 Berlin, Germany
> Sitz der Gesellschaft: Berlin, Registergericht: Berlin HRA 6501
> 
> Vertreten durch ihre Komplementärin:
> BIOTRONIK MT SE
> Sitz der Gesellschaft: Berlin, Registergericht: Berlin HRB 118866 B
> Geschäftsführende Direktoren: Christoph Böhmer, Dr. Werner Braun, Dr. 
> Lothar Krings, Dr. Torsten Wolf
> 
> BIOTRONIK - A global manufacturer of advanced Cardiac Rhythm Management 
> systems and Vascular Intervention devices. Quality, innovation, and 
> reliability define BIOTRONIK and our growing success. We are innovators of 
> technologies like the first wireless remote monitoring system - Home 
> Monitoring®, Closed Loop Stimulation and coveted lead solutions as well as 
> state-of-the-art stents, balloons and guide wires for coronary and 
> peripheral indications. We highly invest in the development of drug 
> eluting devices and are leading the industry with our drug eluting 
> absorbable metal scaffold program.
> 
> This e-mail and the information it contains including attachments are 
> confidential and meant only for use by the intended recipient(s); 
> disclosure or copying is strictly prohibited. If you are not addressed, 
> but in the possession of this e-mail, please notify the sender immediately 
> and delete the document.
> 
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator


-- 
Heikki Vatiainen <hvn at open.com.au>

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS,
NetWare etc.