GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  RADSQLRELAY (8)

NAME

radsqlrelay - relay SQL queries to a central database server

CONTENTS

Synopsis
Description
Options
Notes
     Oracle driver
See Also
Author

SYNOPSIS

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

DESCRIPTION

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.

OPTIONS

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

NOTES

    Oracle driver

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>) ) )

SEE ALSO

rlm_sql_log(5)

AUTHOR

Nicolas Baradakis <nicolas.baradakis@cegetel.net>
Search for    or go to Top of page |  Section 8 |  Main Index


RADSQLRELAY (8) 19 June 2005

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.