Hello Adrian,
On Thursday 24 June 2010 01:17:00 am Adrian Mustelier Camino wrote:
> Hi:
>
> I trying to configure the logSQL feature in Radiator. I put the code
> below inside the realm as indicated on the manual. The problem is that I
> not receiving any data in My SQL server. I test the SQL database with
> other application and work well.
>
> <Log SQL>
> DBSource dbi:mSQL:Radiatorlogsql
> DBUSername radiatorlog
> DBAuth radiatorlog
> Table RADLOG
> LogQuery insert into %3 (TIME_STAMP, PRIORITY, MESSAGE)
> values (%t, %0, %2)
> </Log>
>
>
> The Radiatorlogsql database is in the SQL server and the Server is using
> SQL authentication.
>
> My first question is:
> Is correct the code over this lines?
Yes, provided you are really wanting to use mini-SQL as your SQL server.
You dont say what the type of your SQL server is.
Few people use min-SQL these days. Information from other parts of your
organisation makes me think you really want to use Microsoft SQL, in which
case you would want to use something like:
<Log SQL>
DBSource dbi:ODBC:Radiatorlogsql
DBUSername radiatorlog
DBAuth radiatorlog
Table RADLOG
LogQuery insert into %3 (TIME_STAMP, PRIORITY, MESSAGE)
values (%t, %0, %2)
</Log>
> I need an extra module to proper interface Radiator with SQL server than
> the default installed with perl?
To use ODBC, you may have to install the DBD-ODBC perl module, and configure
the ODBC setting on your host machine.
> I can debug the SQLlog process?.
You might expect to see some messages in the Radiator log file at trace level
4 if there are problems.
Cheers.
>
> thanks
--
Mike McCauley [email protected]
Open System Consultants Pty. Ltd
9 Bulbul Place Currumbin Waters QLD 4223 Australia http://www.open.com.au
Phone +61 7 5598-7474 Fax +61 7 5598-7070
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.
_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
