1 .TH RADSQLRELAY 8 "19 June 2005" "" "FreeRADIUS helper program"
4 radsqlrelay - relay SQL queries to a central database server
24 \fBradsqlrelay\fP tails a SQL \fIlogfile\fP and forwards the queries
25 to a database server. Used to replicate accounting records to one
26 (central) database, even if the database has extended downtime.
28 The SQL logfile is created by the \fBrlm_sql_log\fP module. The module
29 must be configured in the \fBradiusd\fP server before you can use
33 .IP "\-d \fIsql_driver\fP"
34 Driver to use: mysql, pg, oracle.
35 .IP "\-b \fIdatabase\fP"
36 Name of the database to use.
38 Read password from file, instead of command line.
43 .IP "\-p \fIpassword\fP"
44 Password to use when connecting to server.
46 One-shot mode: push the file to database and exit.
48 The pathname of the SQL logfile to use.
52 The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the
53 database description stored in $TNS_ADMIN/tnsnames.ora:
59 (ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
62 (SERVICE_NAME = <DB SID>)
71 Nicolas Baradakis <nicolas.baradakis@cegetel.net>