blob: f161cc3d15cbd39fade2ac3b6f7d6bd57ec80e84 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
.\" # 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>
|
