Installing SQL Relay|
Before you can compile SQL Relay, you will need to install some pre-requisites.
The Rudiments library is essential. It's available from www.firstworks.comonly the client API's will be built. Version 1.8.7 or higher is required.
To build the database connection daemons, you'll need one or more of Oracle (Version 7.3.x, 8.0.x or 8.1.x), MySQL, mSQL, PostgreSQL, SQLite, Lago, unixODBC, iODBC, DB2, Interbase, Sybase or FreeTDS (for accessing either Sybase or MS SQL Server).
To build the GUI configuration tool, you'll need GTK+ and glib. Both are available from www.gtk.org.Downloading SQL Relay:
You can download the most current source distribution of SQL Relay from www.firstworks.com.Unpacking SQL Relay:
To unpack the distribution, copy the file to a location on your machine that you have access to and execute the following commands:
This will create a sqlrelay-X.XX directory. Change directories into that directory.Compiling SQL Relay:
To compile SQL Relay, read the INSTALL file, make sure your ORACLE_HOME environment variable is set if you are going to compile with Oracle support, then execute the following commands:
The configure command takes lots of command line options, most of which tell it where to find prerequisite software in case any of it is installed in non-standard locations. It also takes the --prefix option in case you want to install SQL Relay somewhere other than /usr/local/firstworks. You can run "configure --help" to get a list of command line options.
If you want to rebuild SQL Relay for any reason, type:
If you want to re-configure SQL Relay type:
SQL Relay should compile and function on unix-based systems using the GNU development system. Other compilers may work too but have not been tested on the current version.
The -pedantic flag must be used with newer GNU compilers. This flag is turned on by default, don't disable it.
After a complete, sucessful compilation, the lib directory should contain:
The bin directory should contain:
To install SQL Relay, become root and type:
By default, everything is installed under /usr/local/firstworks.
To uninstall SQL Relay, become root and type:
If your platform supports RedHat Package Manager RPM's, you can build them after running configure and make by running the following command as root:
This will generate RPM's in the packages/RPMS directory. You can install them by changing directories into packages/RPMS and executing the following command as root: