drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill-site git commit: updates to odbc driver docs for mac os x
Date Tue, 24 Jan 2017 22:32:30 GMT
Repository: drill-site
Updated Branches:
  refs/heads/asf-site f30add6fd -> 50300febe


updates to odbc driver docs for mac os x


Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/50300feb
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/50300feb
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/50300feb

Branch: refs/heads/asf-site
Commit: 50300febe6177f5b57df9aaa214b75ba5197c831
Parents: f30add6
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Tue Jan 24 14:32:19 2017 -0800
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Tue Jan 24 14:32:19 2017 -0800

----------------------------------------------------------------------
 docs/configuring-odbc-on-mac-os-x/index.html    | 119 +++++++++----------
 docs/img/odbc_data_source_names.png             | Bin 0 -> 142484 bytes
 docs/img/odbc_login.png                         | Bin 0 -> 16687 bytes
 docs/img/success.png                            | Bin 0 -> 31079 bytes
 .../index.html                                  |  30 +++--
 docs/testing-the-odbc-connection/index.html     |  14 +--
 feed.xml                                        |   4 +-
 7 files changed, 85 insertions(+), 82 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/configuring-odbc-on-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc-on-mac-os-x/index.html b/docs/configuring-odbc-on-mac-os-x/index.html
index ac08ed4..b226d00 100644
--- a/docs/configuring-odbc-on-mac-os-x/index.html
+++ b/docs/configuring-odbc-on-mac-os-x/index.html
@@ -1099,7 +1099,7 @@
 
     </div>
 
-     Dec 24, 2016
+     Jan 24, 2017
 
     <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
@@ -1110,20 +1110,21 @@ sources and drivers. To configure an ODBC connection for Linux or
Mac OS X, comp
 steps:</p>
 
 <ul>
-<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-1:-set-environment-variables">Step
1: Set Environment Variables</a></li>
-<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-2:-define-the-odbc-data-sources-in-.odbc.ini">Step
2: Define the ODBC Data Sources in odbc.ini</a></li>
-<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-4:-configure-the-mapr-drill-odbc-driver">Step
3: Configure the MapR Drill ODBC Driver</a></li>
+<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-1:-copy-sample-configuration-files">Step
1: Copy Sample Configuration Files</a></li>
+<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-2:-set-environment-variables">Step
2: Set Environment Variables</a></li>
+<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-3:-define-the-odbc-data-sources-in-.odbc.ini">Step
3: Define the ODBC Data Sources in odbc.ini</a></li>
+<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-4:-configure-the-mapr-drill-odbc-driver">Step
4: Configure the MapR Drill ODBC Driver</a></li>
 </ul>
 
-<h2 id="sample-configuration-files">Sample Configuration Files</h2>
+<h2 id="step-1:-copy-sample-configuration-files">Step 1: Copy Sample Configuration
Files</h2>
 
 <p>Before you connect to Drill through an ODBC client tool
-on Mac OS X, copy the following configuration files in <code>/opt/mapr/drillodbc/Setup</code>
to your home directory unless the files already exist in your home directory:</p>
+on Mac OS X, copy the following configuration files in <code>/opt/mapr/drill/Setup</code>
to your home directory unless the files already exist in your home directory:</p>
 
 <ul>
 <li><code>mapr.drillodbc.ini</code></li>
-<li><code>odbc.ini</code></li>
-<li><code>odbcinst.ini</code></li>
+<li><code>.odbc.ini</code></li>
+<li><code>.odbcinst.ini</code></li>
 </ul>
 
 <p>In your home directory, rename the files as hidden files. Use sudo if necessary:</p>
@@ -1131,6 +1132,7 @@ on Mac OS X, copy the following configuration files in <code>/opt/mapr/drillodbc
 <ul>
 <li>.mapr.drillodbc.ini</li>
 <li>.odbc.ini</li>
+<li>.odbcinst.ini</li>
 </ul>
 
 <p>The installer for Mac OS X creates a sample user DSN in odbc.ini in either of the
following locations:</p>
@@ -1149,20 +1151,19 @@ on Mac OS X, copy the following configuration files in <code>/opt/mapr/drillodbc
 
 <hr>
 
-<h2 id="step-1:-set-environment-variables">Step 1: Set Environment Variables</h2>
+<h2 id="step-2:-set-environment-variables">Step 2: Set Environment Variables</h2>
 
-<p>Create or modify the <code>/etc/launchd.conf</code> file to set environment
variables. Set the SIMBAINI variable to point to the <code>.mapr.drillodbc.ini</code>
file, the ODBCINI variable to the <code>.odbc.ini</code> file, and the DYLD_LIBRARY_PATH
to the location of the dynamic linker (DYLD) libraries and to the MapR Drill ODBC Driver.
</p>
+<p>Create or modify the <code>/etc/launchd.conf</code> file to set environment
variables. Set the MAPRDRILLINI variable to point to the <code>.mapr.drillodbc.ini</code>
file. </p>
 
-<p>If you installed the iODBC driver manager using the DMG, the DYLD libraries are
installed in <code>/usr/local/iODBC/lib</code>. The launchd.conf file should look
something like this:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">setenv
SIMBAINI /Users/joeuser/.mapr.drillodbc.ini
+<p>If you installed the iODBC driver manager using the DMG, the dynamic linker (DYLD)
libraries are installed in <code>/usr/local/iODBC/lib</code>. The launchd.conf
file should look something like this:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">setenv
MAPRDRILLINI /Users/joeuser/.mapr.drillodbc.ini
 setenv ODBCINI /Users/joeuser/.odbc.ini
-setenv DYLD_LIBRARY_PATH /usr/local/iODBC/lib:/opt/mapr/drillodbc/lib/universal
 </code></pre></div>
 <p>Restart the Mac OS X or run <code>launchctl load /etc/launchd.conf</code>.</p>
 
 <hr>
 
-<h2 id="step-2:-define-the-odbc-data-sources-in-.odbc.ini">Step 2: Define the ODBC
Data Sources in .odbc.ini</h2>
+<h2 id="step-3:-define-the-odbc-data-sources-in-.odbc.ini">Step 3: Define the ODBC
Data Sources in .odbc.ini</h2>
 
 <p>Define the ODBC data sources in the <code>~/.odbc.ini</code> configuration
file for your environment. </p>
 
@@ -1180,19 +1181,53 @@ PORT=
 ZKQuorum=&lt;host name&gt;:&lt;port&gt;,&lt;host name&gt;:&lt;port&gt;
. . . &lt;host name&gt;:&lt;port&gt;
 ZKClusterID=&lt;cluster name in `drill-override.conf`&gt;
 </code></pre></div>
+<h3 id="authentication-properties">Authentication Properties</h3>
+
+<p>If the Drillbit requires a username and password for authentication, uncomment the
AuthenticationType, select Basic Authentication for the AuthenticationType, and configure
UID and PWD properties.</p>
+
+<h3 id="direct-and-zookeeper-quorum-properties">Direct and ZooKeeper Quorum Properties</h3>
+
+<p>To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum
and ZKClusterID values from the <code>drill-override.conf</code> file, and define
the ZKQuorum and ZKClusterID properties. Format ZKQuorum as a comma separated list of ZooKeeper
nodes in the following format:<br>
+<code>&lt;host name/ip address&gt; : &lt;port number&gt;, &lt;host
name/ip address&gt; : &lt;port number&gt;, . . .</code> </p>
+
+<p>For example:</p>
+
+<ul>
+<li><code>ZKQuorum=centos23:5181,centos28:5181,centos29:5181</code><br></li>
+<li><code>ZKClusterID=docs41cluster-drillbits</code></li>
+</ul>
+
+<p>To use Drill in local mode, do not define the ZKQuorum and ZKClusterID properties.
Start Drill using the drill-localhost command, set ConnectionType to Direct, and define HOST
and PORT properties. For example:</p>
+
+<ul>
+<li><code>HOST=centos32.lab:5181</code><br></li>
+<li><code>PORT=31010</code></li>
+</ul>
+
+<p><a href="/docs/odbc-configuration-reference/#configuration-options">Driver
Configuration Options</a> describes configuration options available for controlling
the
+behavior of DSNs using the MapR Drill ODBC Driver.</p>
+
+<h3 id="sample-configuration-file">Sample Configuration File</h3>
+
 <p>The following sample shows a possible configuration for using Drill in embedded
mode. </p>
+
+<div class="admonition note">
+  <p class="first admonition-title">Note</p>
+  <p class="last">The password should be provided in the connection string or ODBC
application at connection time, not in the INI file.  </p>
+</div>
+ 
 <div class="highlight"><pre><code class="language-text" data-lang="text">[ODBC]
 # Specify any global ODBC configuration here such as ODBC tracing.
 
 [ODBC Data Sources]
-Sample MapR Drill DSN=MapR Drill ODBC Driver
+Sample MapR Drill=MapR Drill ODBC Driver
 
-[Sample MapR Drill DSN]
+[Sample MapR Drill]
 # Description: DSN Description.
 # This key is not necessary and only describes the data source.
 Description=Sample MapR Drill ODBC Driver DSN
 # Driver: The location where the ODBC driver is installed.
-Driver=/opt/mapr/drillodbc/lib/universal/libmaprdrillodbc.dylib
+Driver=/Library/mapr/drill/lib/libdrillodbc_sbu.dylib
 
 # The DriverUnicodeEncoding setting is only used for SimbaDM
 # When set to 1, SimbaDM runs in UTF-16 mode.
@@ -1211,40 +1246,14 @@ ZKQuorum=[Zookeeper Quorum]
 ZKClusterID=[Cluster ID]
 AuthenticationType=No Authentication
 UID=[USERNAME]
-PWD=[PASSWORD]
+PWD=[PASSWORD] 
 AdvancedProperties=CastAnyToVarchar=true;HandshakeTimeout=5;QueryTimeout=180;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys,INFORMATION_SCHEMA;NumberOfPrefetchBuffers=5;
 Catalog=DRILL
-Schema=
+Schema=  
 </code></pre></div>
-<h3 id="authentication-properties">Authentication Properties</h3>
-
-<p>To password protect the DSN, uncomment the AuthenticationType, select Basic Authentication
for the AuthenticationType, and configure UID and PWD properties.</p>
-
-<h3 id="direct-and-zookeeper-quorum-properties">Direct and ZooKeeper Quorum Properties</h3>
-
-<p>To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum
and ZKClusterID values from the <code>drill-override.conf</code> file, and define
the ZKQuorum and ZKClusterID properties. Format ZKQuorum as a comma separated list of ZooKeeper
nodes in the following format:<br>
-<code>&lt;host name/ip address&gt; : &lt;port number&gt;, &lt;host
name/ip address&gt; : &lt;port number&gt;, . . .</code> </p>
-
-<p>For example:</p>
-
-<ul>
-<li><code>ZKQuorum=centos23:5181,centos28:5181,centos29:5181</code><br></li>
-<li><code>ZKClusterID=docs41cluster-drillbits</code></li>
-</ul>
-
-<p>To use Drill in local mode, do not define the ZKQuorum and ZKClusterID properties.
Start Drill using the drill-localhost command, set ConnectionType to Direct, and define HOST
and PORT properties. For example:</p>
-
-<ul>
-<li><code>HOST=centos32.lab:5181</code><br></li>
-<li><code>PORT=31010</code></li>
-</ul>
-
-<p><a href="/docs/odbc-configuration-reference/#configuration-options">Driver
Configuration Options</a> describes configuration options available for controlling
the
-behavior of DSNs using the MapR Drill ODBC Driver.</p>
-
 <hr>
 
-<h2 id="step-3:-configure-the-mapr-drill-odbc-driver">Step 3: Configure the MapR Drill
ODBC Driver</h2>
+<h2 id="step-4:-configure-the-mapr-drill-odbc-driver">Step 4: Configure the MapR Drill
ODBC Driver</h2>
 
 <p>Configure the MapR Drill ODBC Driver for your environment by modifying the <code>.mapr.drillodbc.ini</code>
configuration
 file. This configures the driver to work with your ODBC driver manager. The following sample
shows a possible configuration, which you can use as is if you installed the default iODBC
driver manager.</p>
@@ -1252,16 +1261,12 @@ file. This configures the driver to work with your ODBC driver manager.
The foll
 <p><strong>Example</strong></p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">[Driver]
 ## - Note that this default DriverManagerEncoding of UTF-32 is for iODBC.
-DisableAsync=0
-DriverManagerEncoding=UTF-32
-ErrorMessagesPath=/opt/mapr/drillodbc/ErrorMessages
+DisableAsync=0    
+ErrorMessagesPath=/Library/mapr/drill/ErrorMessages
 
 LogLevel=0
 LogPath=
 SwapFilePath=/tmp
-
-# iODBC
-ODBCInstLib=libiodbcinst.dylib
 </code></pre></div>
 <h3 id="configuring-.mapr.drillodbc.ini">Configuring .mapr.drillodbc.ini</h3>
 
@@ -1271,14 +1276,8 @@ ODBCInstLib=libiodbcinst.dylib
 <li>Open the <code>mapr.drillodbc.ini</code> configuration file in a text
editor.<br></li>
 <li>Edit the DisableAsync setting if you want to enable a synchronous ODBC connection
for performance reasons. Change the default 0 to 1 to disable the asynchronous and enable
the synchronous connection.<br>
  A change in state occurs during driver initialization and is propagated to all driver DSNs.<br></li>
-<li>Edit the DriverManagerEncoding setting if necessary. The value is typically UTF-16
or UTF-32, but depends on the driver manager used. iODBC uses UTF-32 and unixODBC uses UTF-16.
Review your ODBC Driver Manager documentation for the correct setting.<br></li>
-<li><p>Edit the <code>ODBCInstLib</code> setting. The value is the
name of the <code>ODBCInst</code> shared library for the ODBC driver manager that
you use. The configuration file defaults to the shared library for <code>iODBC</code>.
The shared library name for <code>iODBC</code> is <code>libiodbcinst.dylib</code>.
 </p>
-
-<p>Specify an absolute or relative filename for the library. If you use
-the relative file name, include the path to the library in the library path
-environment variable. The library path environment variable is
-named <code>DYLD_LIBRARY_PATH</code>.  </p></li>
-<li><p>Save the <code>mapr.drillodbc.ini</code> configuration file.</p></li>
+<li>Edit the DriverManagerEncoding setting if necessary. The value is typically UTF-16
or UTF-32, but depends on the driver manager used. iODBC uses UTF-32 and unixODBC uses UTF-16.
Review your ODBC Driver Manager documentation for the correct setting.</li>
+<li>Save the <code>mapr.drillodbc.ini</code> configuration file.</li>
 </ol>
 
 <h3 id="next-step">Next Step</h3>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/img/odbc_data_source_names.png
----------------------------------------------------------------------
diff --git a/docs/img/odbc_data_source_names.png b/docs/img/odbc_data_source_names.png
new file mode 100644
index 0000000..a63eed7
Binary files /dev/null and b/docs/img/odbc_data_source_names.png differ

http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/img/odbc_login.png
----------------------------------------------------------------------
diff --git a/docs/img/odbc_login.png b/docs/img/odbc_login.png
new file mode 100644
index 0000000..1a4be04
Binary files /dev/null and b/docs/img/odbc_login.png differ

http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/img/success.png
----------------------------------------------------------------------
diff --git a/docs/img/success.png b/docs/img/success.png
new file mode 100644
index 0000000..e18fb00
Binary files /dev/null and b/docs/img/success.png differ

http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/installing-the-driver-on-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-mac-os-x/index.html b/docs/installing-the-driver-on-mac-os-x/index.html
index 3fdd754..16ee601 100644
--- a/docs/installing-the-driver-on-mac-os-x/index.html
+++ b/docs/installing-the-driver-on-mac-os-x/index.html
@@ -1099,7 +1099,7 @@
 
     </div>
 
-     Dec 24, 2016
+     Jan 24, 2017
 
     <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
@@ -1118,11 +1118,13 @@ the Drill service.</p>
 
 <h2 id="system-requirements">System Requirements</h2>
 
+<p>To install the driver, you need Administrator privileges on the computer.</p>
+
 <ul>
-<li>Mac OS X version 10.6.8 or later<br></li>
+<li>Mac OS X version 10.8.0 or later<br></li>
 <li>100 MB of available disk space<br></li>
 <li>iODBC 3.52.7 or later<br>
-The iodbc-config file in the <code>/usr/local/iODBC/bin</code> includes the version.<br></li>
+The iodbc-config file in the <code>/usr/local/iODBC/bin</code> includes the version
of the driver.<br></li>
 <li><p>The client must be able to resolve the actual host name of the Drill node
or nodes from the IP address. Verify that a DNS entry was created on the client machine for
the Drill node or nodes.<br>
 If not, create an entry in <code>/etc/hosts</code> for each node in the following
format:  </p>
 
@@ -1130,8 +1132,6 @@ If not, create an entry in <code>/etc/hosts</code> for each
node in the followin
 Example: <code>127.0.0.1 localhost</code></p></li>
 </ul>
 
-<p>To install the driver, you need Administrator privileges on the computer.</p>
-
 <hr>
 
 <h2 id="step-1:-download-the-mapr-drill-odbc-driver">Step 1: Download the MapR Drill
ODBC Driver</h2>
@@ -1147,7 +1147,7 @@ Example: <code>127.0.0.1 localhost</code></p></li>
 <p>To install the driver, complete the following steps:</p>
 
 <ol>
-<li>Double-click <code>MapRDrill1.3.dmg</code> to mount the disk image.</li>
+<li>Double-click <code>MapR_Drill_1.3.dmg</code> to mount the disk image.</li>
 <li>Double-click <code>MapRDrillODBC.pkg</code> to run the Installer.</li>
 <li>Follow the instructions in the Installer to complete the installation process.</li>
 <li>When the installation completes, click <strong>Close.</strong></li>
@@ -1159,20 +1159,24 @@ Example: <code>127.0.0.1 localhost</code></p></li>
 </div>
 
 <ul>
-<li><code>/opt/mapr/drillodbc/ErrorMessages</code> – Error messages files
directory</li>
-<li><code>/opt/mapr/drillodbc/Setup</code> – Sample configuration files
directory</li>
-<li><code>/opt/mapr/drillodbc/lib/universal</code> – Binaries directory</li>
+<li><code>/Library/mapr/drill/ErrorMessages</code> – Error messages files
directory</li>
+<li><code>/Library/mapr/drill/Setup</code> – Sample configuration files
directory</li>
+<li><code>/Library/mapr/drill/lib</code> – Binaries directory</li>
 </ul>
 
-<h2 id="step-3:-check-the-mapr-drill-odbc-driver-version">Step 3: Check the MapR Drill
ODBC Driver version</h2>
+<h2 id="step-3:-check-the-mapr-drill-odbc-driver-version">Step 3: Check the MapR Drill
ODBC Driver Version</h2>
 
 <p>To check the version of the driver you installed, use the following command on the
terminal command line:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">$
pkgutil --info mapr.drillodbc
+<div class="highlight"><pre><code class="language-text" data-lang="text">$
pkgutil -pkg-info mapr.drillodbc  
+
 package-id: mapr.drillodbc
-version: 1.3.0 (may also display as 3.52.12)
+version: 1.3.0 (You may see 3.52.12.)
 volume: /
 location: 
-install-time: 1433465518
+install-time: 1433465518  
+</code></pre></div>
+<p>To display information about the iODBC driver manager installed on the machine,
issue the following command:  </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">/usr/local/iODBC/bin/iodbc-config
 </code></pre></div>
 <h3 id="next-step">Next Step</h3>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/testing-the-odbc-connection/index.html
----------------------------------------------------------------------
diff --git a/docs/testing-the-odbc-connection/index.html b/docs/testing-the-odbc-connection/index.html
index 91822d3..76fd243 100644
--- a/docs/testing-the-odbc-connection/index.html
+++ b/docs/testing-the-odbc-connection/index.html
@@ -1099,7 +1099,7 @@
 
     </div>
 
-     
+     Jan 24, 2017
 
     <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
@@ -1179,15 +1179,15 @@ Enter ODBC connect string (? shows list):
 <ol>
 <li><a href="/docs/starting-drill-on-linux-and-mac-os-x/">Start Drill</a>.<br></li>
 <li>Start the iODBC Administrator.app in <code>/Applications</code>.<br>
-The iODBC Data Source Administrator dialog appears.<br></li>
-<li>On the User DSN tab, select the MapR Drill DSN.<br>
-<img src="/docs/img/odbc-mac1.png" alt=""><br></li>
+The iODBC Data Source Administrator dialog appears. </li>
+<li>On the User DSN tab, select the MapR Drill.<br>
+<img src="/docs/img/odbc_data_source_names.png" alt=""><br></li>
 <li>Click <strong>Test</strong>.<br>
-The Login for Sample MapR Drill DSN dialog appears.<br>
-<img src="/docs/img/odbc-mac2.png" alt=""><br></li>
+The Login for Sample MapR Drill dialog appears.<br>
+<img src="/docs/img/odbc_login.png" alt=""><br></li>
 <li>If you configured Basic Authentication in the <code>.odbc.ini</code>,
enter the user name and password you also configured; otherwise, click <strong>OK</strong>.<br>
 The success message appears.<br>
-<img src="/docs/img/odbc-mac3.png" alt=""><br></li>
+<img src="/docs/img/success.png" alt=""><br></li>
 </ol>
 
 <h2 id="testing-the-odbc-connection-on-windows">Testing the ODBC Connection on Windows</h2>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index 57764b9..a30c9e1 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
 </description>
     <link>/</link>
     <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
-    <pubDate>Fri, 23 Dec 2016 16:36:27 -0800</pubDate>
-    <lastBuildDate>Fri, 23 Dec 2016 16:36:27 -0800</lastBuildDate>
+    <pubDate>Tue, 24 Jan 2017 14:28:38 -0800</pubDate>
+    <lastBuildDate>Tue, 24 Jan 2017 14:28:38 -0800</lastBuildDate>
     <generator>Jekyll v2.5.2</generator>
     
       <item>


Mime
View raw message