Building DB Relay

The following instructions are known to work on stock development installs of Mac OS X 10.5+ and CentOS 5.2+. On Mac OS X make sure that you have latest XCode Tools installed. A non-development installs of CentOS will need at least the following packages:

$ yum install glibc glibc-devel gcc patch zlib zlib-devel openssl-devel autoconf m4 make

These instructions also assume that the local code repository path is stored in the DBR_GIT environment variable and the target installation path is in the DBR_HOME environment variable. Neither variable is needed for neither building nor running DB Relay.

Download the source code

First, create a local code repository.

$ git clone http://github.com/dbrelay/dbrelay.git ${DBR_GIT}
$ cd ${DBR_GIT}

Then update dependency git sub-modules

$ git submodule init
$ git submodule update

DB Relay instance to query MS SQL Server

Use the freetds configuration parameter.

$ ./configure --prefix=${DBR_HOME} --with-freetds

Run a standard sequence of make and make install commands.

$ make
$ make install

Note, that depending on the system configuration, the install step may need to be executed as a superuser.

DB Relay instance to query the ODBC instances

Otherwise point the ODBC parameter to your system's unixODBC install. There are yet more steps involved in running an ODBC-based instance of DB Relay, which will be covered later or via the mailing list (upon request).

./configure --prefix=${DBR_HOME} --with-odbc=/usr

Run a standard sequence of make and make install commands.

$ make
$ make install

After that you need to configure the ODBC driver manager in /etc/odbc.ini, ~/.odbc.ini, or whatever is the correct file location on your system. Using DB Relay is similar to FreeTDS, simply provide a desired DSN name in the "sql_server" parameter of HTTP requests. You still need to provide valid "sql_database", "sql_user", and other HTTP parameters.