Hello Le Anh Tuan -
On Fri, 10 Mar 2000, Le Anh Tuan wrote:
>
> We want to customize some field in Log SQL, for example we want the fields
> like this:
> TIME_STAMP datetime
> NASIPADDRESS varchar(50)
> MESSAGE_TYPE int (Warning,Debug etc)
> MESSAGE varchar(255)
>
> but in documentation, I read that the log table must have format like:
> insert into tablename
> (TIME_STAMP, PRIORITY, MESSAGE)
> values (time
> , priority
> , 'message
> ')
>
> Is it possible to customize SQL command (insert into ....), or add some
> parameters in to SQL command, such as NASIPADDRESS, Client IP Address etc
> ...?
The log routine in LogSQL.pm only has access to the three parameters you
mention above. To do what you require will involve either modifying the source
in the module(s) in which you want to add the information (ie. pass everything
you want in the MESSAGE string), or alternatively writing one or more hooks to
do the same thing.
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
