1RADSQLRELAY(8)             FreeRADIUS helper program            RADSQLRELAY(8)
2
3
4

NAME

6       radsqlrelay - relay SQL queries to a central database server
7
8

SYNOPSIS

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

DESCRIPTION

15       radsqlrelay tails a SQL logfile and forwards the queries to a  database
16       server. Used to replicate accounting records to one (central) database,
17       even if the database has extended downtime.
18
19       The SQL logfile is created by the rlm_sql module with the  rlm_sql_null
20       driver  logging  to disk.. The module must be configured in the radiusd
21       server before you can use radsqlrelay.
22
23

OPTIONS

25       -?     Print usage help information.
26
27       -d sql_driver
28              Driver to use: mysql, pg, oracle.
29
30       -b database
31              Name of the database to use.
32
33       -f file
34              Read password from file, instead of command line.
35
36       -h host
37              Connect to host.
38
39       -u user
40              User for login.
41
42       -P port
43              Port number to use for connection.
44
45       -p password
46              Password to use when connecting to server.
47
48       -1     One-shot mode: push the file to database and exit.
49
50       -x     Turn on debugging.
51
52       file_path
53              The pathname of the SQL logfile to use.
54
55

NOTES

57   Oracle driver
58       The command "radsqlrelay -d oracle -b  db.domain.tld  sql-relay"  reads
59       the database description stored in $TNS_ADMIN/tnsnames.ora:
60
61       db.domain.tld =
62         (DESCRIPTION =
63           (ADDRESS_LIST =
64             (ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
65           )
66           (CONNECT_DATA =
67             (SERVICE_NAME = <DB SID>)
68           )
69         )
70
71

AUTHOR

73       Nicolas Baradakis <nicolas.baradakis@cegetel.net>
74
75
76
77                                 19 June 2005                   RADSQLRELAY(8)