DOKK / manpages / debian 10 / freeradius-common / radsqlrelay.8.en
RADSQLRELAY(8) FreeRADIUS helper program RADSQLRELAY(8)

radsqlrelay - relay SQL queries to a central database server

radsqlrelay [-?] [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-P port] [-p password] [-1] [-x] file_path

radsqlrelay tails a SQL logfile and forwards the queries to a database server. Used to replicate accounting records to one (central) database, even if the database has extended downtime.

The SQL logfile is created by the rlm_sql_log module. The module must be configured in the radiusd server before you can use radsqlrelay.

-?
Print usage help information.
Driver to use: mysql, pg, oracle.
Name of the database to use.
Read password from file, instead of command line.
Connect to host.
User for login.
Port number to use for connection.
Password to use when connecting to server.
-1
One-shot mode: push the file to database and exit.
Turn on debugging.
The pathname of the SQL logfile to use.

The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the database description stored in $TNS_ADMIN/tnsnames.ora:

db.domain.tld =

(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <DB SID>)
)
)

rlm_sql_log(5)

Nicolas Baradakis <nicolas.baradakis@cegetel.net>

19 June 2005