1= Installing SQL Relay From Packages =
2
3* [#platforms Supported Platforms]
4* [#linux Linux]
5* [#freebsd FreeBSD]
6* [#netbsd NetBSD]
7* [#windows Windows]
8
9[=#platforms]
10== Supported Platforms ==
11
12SQL Relay packages are currently available for:
13
14* RPM-based Linux (Fedora, !CentOS/RHEL, and !OpenSuSE)
15* !FreeBSD
16* !NetBSD
17* Windows
18
19Packages are not currently available for other platforms, but on other platforms, SQL Relay can be built from [installing.html source].
20
21[=#linux]
22== Linux ==
23
24SQL Relay packages are currently available for RPM-based Linux distributions like Fedora, !CentOS/RHEL, and !OpenSuSE Linux, for the x86_64 architecture.
25
26Packages are not currenly available for dpkg-based Linux like Ubunutu and Debian Linux, or for non-x86_64 architectures.  On these platforms SQL Relay must be built from [installing.html source].
27
28To download the Linux packages, download the [http://sourceforge.net/projects/sqlrelay/files/sqlrelay/@SQLR_VERSION@/sqlrelay-binary-distribution-@SQLR_VERSION@.tar.gz/download SQL Relay Binary Distribution for Linux].  This file is a tar.gz containing RPMs for all supported Linux platforms.
29
30To install the packages, first extract the file:
31
32{{{#!blockquote
33{{{
34tar xfz sqlrelay-binary-distribution-@SQLR_VERSION@.tar.gz
35}}}
36}}}
37
38Then, change directories into the directory that was created during the extraction:
39
40{{{#!blockquote
41{{{
42cd sqlrelay-binary-distribution-@SQLR_VERSION@
43}}}
44}}}
45
46Then, change directories into the directory for the appropriate distribution.  For example:
47
48{{{#!blockquote
49{{{
50cd centos7x64
51}}}
52}}}
53
54Then, install the RPMs.  Since different platforms use different packaging systems, installation instructions depend on the platform.
55
56{{{#!blockquote
57
58On Fedora platforms, run (as root):
59
60{{{#!blockquote
61{{{
62dnf localinstall *
63}}}
64}}}
65
66On !CentOS platforms, run (as root):
67
68{{{#!blockquote
69{{{
70yum localinstall *
71}}}
72}}}
73
74On !OpenSuSE platforms, run (as root):
75
76{{{#!blockquote
77{{{
78zypper install *
79}}}
80}}}
81
82}}}
83
84In any case, the package packaging system should install the RPMs as well as any dependencies that they require.
85
86Client libraries for most of the databases supported by SQL Relay are available as RPMs and should be automatically installed by the packaging system.  However, packages for commercial databases are not available from any standard package repository and must be installed manually for SQL Relay to actually work with these databases.
87
88For SQL Relay to work with a commercial database, you must install and configure client libraries for one or more of [http://www.oracle.com Oracle], [http://scn.sap.com/community/developer-center/oltp-db SAP/Sybase], [http://www.ibm.com/software/data/db2/ DB2], or [http://www.ibm.com/software/data/informix/ Informix].
89
90SQL Relay should now be installed.  At this point, it's safe to delete the sqlrelay-binary-distribution-@SQLR_VERSION@ directory and sqlrelay-binary-distribution-@SQLR_VERSION@.tar.gz file.
91
92[=#freebsd]
93== !FreeBSD ==
94
95SQL Relay is available as a [http://www.freshports.org/databases/sqlrelay/ FreeBSD port].  To install all packages related to SQL Relay, run (as root):
96
97{{{#!blockquote
98{{{
99pkg install sqlrelay py27-sqlrelay
100}}}
101}}}
102
103[=#netbsd]
104== !NetBSD ==
105
106SQL Relay is available as a [http://ftp.netbsd.org/pub/pkgsrc/current/pkgsrc/databases/sqlrelay/README.html NetBSD] package. To install all available packages related to SQL Relay, run (as root):
107
108{{{#!blockquote
109{{{
110pkgin install sqlrelay sqlrelay-sqlite sqlrelay-pgsql sqlrelay-odbc sqlrelay-nodejs sqlrelay-mysql sqlrelay-freetds
111ruby22-sqlrelay ruby21-sqlrelay ruby200-sqlrelay py27-sqlrelay php56-sqlrelay php55-sqlrelay p5-sqlrelay
112}}}
113}}}
114
115[=#windows]
116== Installing SQL Relay from Packages on Windows ==
117
118SQL Relay packages are currently available for Windows, for the x86 and x86_64 architectures.
119
120To download the Windows packages, download the [http://sourceforge.net/projects/sqlrelay/files/sqlrelay/@SQLR_VERSION@/sqlrelay-binary-distribution-@SQLR_VERSION@.zip/download SQL Relay Binary Distribution for Windows].  This file is a zip containing Windows packages for supported platforms.
121
122To install the packages:
123
124* Open the folder that the zip was downloaded into.
125* Right click the zip file and select Extract All...
126* Open the folder that was created by the extraction (if it didn't open automatically).
127* Open the folder that is appropriate for your architecture (x86 or x64).
128* Install Rudiments...
129 * Open the rudiments folder.
130 * Double-click "setup".
131 * Follow the instructions in the installer.  Accept all defaults.
132 * In Windows Explorer, click the back arrow to return to the parent folder.
133* Install SQL Relay...
134 * Open the sqlrelay folder.
135 * Double-click "setup".
136 * Follow the instructions in the installer.  Accept all defaults.
137
138SQL Relay should now be installed.  At this point, it's safe to delete the sqlrelay-binary-distribution-@SQLR_VERSION@ folder and sqlrelay-binary-distribution-@SQLR_VERSION@.zip file.
139
140NOTE: Rudiments and SQL Relay are currently built using Visual Studio 2013, and require the [https://www.microsoft.com/en-us/download/details.aspx?id=40784 Visual C++ Redistributable Packages for Visual Studio 2013].  Try installing this package manually if you encounter problems when trying to run SQL Relay.
141