.\"     # DS - begin display
.de DS
.RS
.nf
.sp
..
.\"     # DE - end display
.de DE
.fi
.RE
.sp
..
.TH RADSQLRELAY 8 "19 June 2005" "" "FreeRADIUS helper program"

.SH NAME
radsqlrelay - relay SQL queries to a central database server

.SH SYNOPSIS
.B radsqlrelay
.RB [ \-? ]
.RB [ \-d
.IR sql_driver ]
.RB [ \-b
.IR database ]
.RB [ \-f
.IR file ]
.RB [ \-h
.IR host ]
.RB [ \-u
.IR user ]
.RB [ \-P
.IR port ]
.RB [ \-p
.IR password ]
.RB [ \-1 ]
.RB [ \-x ]
\fIfile_path\fP

.SH DESCRIPTION
\fBradsqlrelay\fP tails a SQL \fIlogfile\fP and forwards the queries
to a database server. Used to replicate accounting records to one
(central) database, even if the database has extended downtime.
.PP
The SQL logfile is created by the \fBrlm_sql\fP module with the
rlm_sql_null driver logging to disk.. The module must be configured in
the \fBradiusd\fP server before you can use \fBradsqlrelay\fP.

.SH OPTIONS
.IP "\-?"
Print usage help information.
.IP "\-d \fIsql_driver\fP"
Driver to use: mysql, pg, oracle.
.IP "\-b \fIdatabase\fP"
Name of the database to use.
.IP "\-f \fIfile\fP"
Read password from file, instead of command line.
.IP "\-h \fIhost\fP"
Connect to host.
.IP "\-u \fIuser\fP"
User for login.
.IP "\-P \fIport\fP"
Port number to use for connection.
.IP "\-p \fIpassword\fP"
Password to use when connecting to server.
.IP "\-1"
One-shot mode: push the file to database and exit.
.IP "\-x"
Turn on debugging.
.IP "file_path"
The pathname of the SQL logfile to use.

.SH NOTES
.SS Oracle driver
The command "radsqlrelay \-d oracle \-b db.domain.tld sql-relay" reads the
database description stored in $TNS_ADMIN/tnsnames.ora:
.PP
.DS
db.domain.tld =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = <DB SID>)
    )
  )
.DE

.SH AUTHOR
Nicolas Baradakis <nicolas.baradakis@cegetel.net>