(RADIATOR) How to log to MySQL-database? [Public]

[Hugh Irvine]

Hello Hugo -

The Log SQL clause needs to be referenced in the rest of the 
configuration file.

<Log SQL>
         Identifier LogSQL
        DBSource        dbi:mysql:This_Database
        DBUsername      radiator
        DBAuth          SeCrEt
        insert into RADLOG (TIME_STAMP, PRIORITY, MESSAGE)\
                values (%t, %0, %2)
         Trace 4
</Log>

.....

# define Realm(s) or Handler(s)

<Handler ...>

	Log LogSQL

	.....

</Handler>

To log accounting to the database you will need to use the AuthBy SQL 
clause.

See sections 6.13 and 6.29 in the Radiator 3.11 reference manual 
("doc/ref.html").

There are also a number of examples in the "goodies" directory.

regards

Hugh



On 26 Jan 2005, at 21:40, Miedema, Hugo wrote:

> I want to log connection request and accounting to a MySQL-database. 
> I've created the database by the script 'mysqlCreate.sql' which is 
> included in the package of Radiator 3.11.
> In the config-file I've included:
>  
> <Log SQL>
>         DBSource        dbi:mysql:This_Database
>         DBUsername      radiator
>         DBAuth          SeCrEt
>         insert into RADLOG (TIME_STAMP, PRIORITY, MESSAGE)
>         values (%t, %0, %2)
> </Log>
>  
>  
> But this doesn't seems to work. How can I send the logging to the 
> database?
>
> _________________________________
>  
> Hugo Miedema
>

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.