1 .\" # DS - begin display
13 .TH RADSQLRELAY 8 "19 June 2005" "" "FreeRADIUS helper program"
16 radsqlrelay - relay SQL queries to a central database server
36 \fBradsqlrelay\fP tails a SQL \fIlogfile\fP and forwards the queries
37 to a database server. Used to replicate accounting records to one
38 (central) database, even if the database has extended downtime.
40 The SQL logfile is created by the \fBrlm_sql_log\fP module. The module
41 must be configured in the \fBradiusd\fP server before you can use
45 .IP "\-d \fIsql_driver\fP"
46 Driver to use: mysql, pg, oracle.
47 .IP "\-b \fIdatabase\fP"
48 Name of the database to use.
50 Read password from file, instead of command line.
55 .IP "\-p \fIpassword\fP"
56 Password to use when connecting to server.
58 One-shot mode: push the file to database and exit.
60 The pathname of the SQL logfile to use.
64 The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the
65 database description stored in $TNS_ADMIN/tnsnames.ora:
71 (ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
74 (SERVICE_NAME = <DB SID>)
83 Nicolas Baradakis <nicolas.baradakis@cegetel.net>