[RADIATOR] AcctLogFileName alongside AccountingTable in <AuthBy SQL>

Jens Neu jens.neu at biotronik.com
Thu May 10 01:48:39 CDT 2012


> I was quite puzzled why it does not work for you. I bet you have
> something like this in your log:
> 
> ERR: Unknown keyword 'AcctLogFilename' in file.cfg line 38
> 
> So use AcctLogFileName in your Handlers and it should work. Notice the
> spelling (f vs F). That's where the problem is.
> 
> Thanks!
> Heikki

Hi Heikki,
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.

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



More information about the radiator mailing list