radsqlrelay(8) Mac OS X Server Manual Page

Mac Dev Center Mac OS X Reference Library General Mac OS X Man Pages

This manual page is for Mac OS X Server version 10.6.3

If you are running Mac OS X (client), this command is not available.

If you are running a different version of Mac OS X Server, view the documentation locally:

In Xcode
In Terminal, using the man(1) command

Reading manual pages

Manual pages are intended as a quick reference for people who already understand a technology.

For more information about the manual page format, see the manual page for manpages(5).
For more information about this technology, look for other documentation in the Apple Reference Library.
For general information about writing shell scripts, read Shell Scripting Primer.


RADSQLRELAY(8)                            FreeRADIUS helper program                           RADSQLRELAY(8)



NAME
       radsqlrelay - relay SQL queries to a central database server


SYNOPSIS
       radsqlrelay [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-p password] [-1] 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
       -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 password
              Password to use when connecting to server.

       -1     One-shot mode: push the file to database and exit.

       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>



                                                19 June 2005                                  RADSQLRELAY(8)

Reporting Problems

The way to report a problem with this manual page depends on the type of problem:

Content errors: Report errors in the content of this documentation with the feedback links below.
Bug reports: Report bugs in the functionality of the described tool or API through Bug Reporter.
Formatting problems: Report formatting mistakes in the online version of these pages with the feedback links below.

Did this document help you?