Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 22FC0200C04 for ; Tue, 24 Jan 2017 23:32:32 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 218ED160B38; Tue, 24 Jan 2017 22:32:32 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id EC69A160B3E for ; Tue, 24 Jan 2017 23:32:30 +0100 (CET) Received: (qmail 88248 invoked by uid 500); 24 Jan 2017 22:32:30 -0000 Mailing-List: contact commits-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@drill.apache.org Delivered-To: mailing list commits@drill.apache.org Received: (qmail 88239 invoked by uid 99); 24 Jan 2017 22:32:30 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Jan 2017 22:32:30 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 16280DFBAD; Tue, 24 Jan 2017 22:32:30 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: bridgetb@apache.org To: commits@drill.apache.org Message-Id: X-Mailer: ASF-Git Admin Mailer Subject: drill-site git commit: updates to odbc driver docs for mac os x Date: Tue, 24 Jan 2017 22:32:30 +0000 (UTC) archived-at: Tue, 24 Jan 2017 22:32:32 -0000 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 Authored: Tue Jan 24 14:32:19 2017 -0800 Committer: Bridget Bevens 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 @@ - Dec 24, 2016 + Jan 24, 2017 @@ -1110,20 +1110,21 @@ sources and drivers. To configure an ODBC connection for Linux or Mac OS X, comp steps:

-

Sample Configuration Files

+

Step 1: Copy Sample Configuration Files

Before you connect to Drill through an ODBC client tool -on Mac OS X, copy the following configuration files in /opt/mapr/drillodbc/Setup to your home directory unless the files already exist in your home directory:

+on Mac OS X, copy the following configuration files in /opt/mapr/drill/Setup to your home directory unless the files already exist in your home directory:

  • mapr.drillodbc.ini
    • -
  • odbc.ini
    • -
  • odbcinst.ini
    • +
  • .odbc.ini
    • +
  • .odbcinst.ini

In your home directory, rename the files as hidden files. Use sudo if necessary:

@@ -1131,6 +1132,7 @@ on Mac OS X, copy the following configuration files in /opt/mapr/drillodbc
  • .mapr.drillodbc.ini
  • .odbc.ini
    • +
  • .odbcinst.ini

The installer for Mac OS X creates a sample user DSN in odbc.ini in either of the following locations:

@@ -1149,20 +1151,19 @@ on Mac OS X, copy the following configuration files in /opt/mapr/drillodbc
-

Step 1: Set Environment Variables

+

Step 2: Set Environment Variables

-

Create or modify the /etc/launchd.conf file to set environment variables. Set the SIMBAINI variable to point to the .mapr.drillodbc.ini file, the ODBCINI variable to the .odbc.ini file, and the DYLD_LIBRARY_PATH to the location of the dynamic linker (DYLD) libraries and to the MapR Drill ODBC Driver.

+

Create or modify the /etc/launchd.conf file to set environment variables. Set the MAPRDRILLINI variable to point to the .mapr.drillodbc.ini file.

-

If you installed the iODBC driver manager using the DMG, the DYLD libraries are installed in /usr/local/iODBC/lib. The launchd.conf file should look something like this:

-
setenv SIMBAINI /Users/joeuser/.mapr.drillodbc.ini
+
If you installed the iODBC driver manager using the DMG, the dynamic linker (DYLD) libraries are installed in /usr/local/iODBC/lib. The launchd.conf file should look something like this:

+
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
 

 
Restart the Mac OS X or run launchctl load /etc/launchd.conf.

 
 

 
-
Step 2: Define the ODBC Data Sources in .odbc.ini

+
Step 3: Define the ODBC Data Sources in .odbc.ini

 
 
Define the ODBC data sources in the ~/.odbc.ini configuration file for your environment. 

 
@@ -1180,19 +1181,53 @@ PORT=
 ZKQuorum=<host name>:<port>,<host name>:<port> . . . <host name>:<port>
 ZKClusterID=<cluster name in `drill-override.conf`>
+

Authentication Properties

+ +

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.

+ +

Direct and ZooKeeper Quorum Properties

+ +

To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum and ZKClusterID values from the drill-override.conf file, and define the ZKQuorum and ZKClusterID properties. Format ZKQuorum as a comma separated list of ZooKeeper nodes in the following format:
+<host name/ip address> : <port number>, <host name/ip address> : <port number>, . . .

+ +

For example:

+ +
    +
  • ZKQuorum=centos23:5181,centos28:5181,centos29:5181
    • +
  • ZKClusterID=docs41cluster-drillbits
    • +
+ +

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:

+ +
    +
  • HOST=centos32.lab:5181
    • +
  • PORT=31010
    • +
+ +

Driver Configuration Options describes configuration options available for controlling the +behavior of DSNs using the MapR Drill ODBC Driver.

+ +

Sample Configuration File

+

The following sample shows a possible configuration for using Drill in embedded mode.

+ +
+

Note

+

The password should be provided in the connection string or ODBC application at connection time, not in the INI file.

+
+ 
[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=
-

Authentication Properties

- -

To password protect the DSN, uncomment the AuthenticationType, select Basic Authentication for the AuthenticationType, and configure UID and PWD properties.

- -

Direct and ZooKeeper Quorum Properties

- -

To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum and ZKClusterID values from the drill-override.conf file, and define the ZKQuorum and ZKClusterID properties. Format ZKQuorum as a comma separated list of ZooKeeper nodes in the following format:
-<host name/ip address> : <port number>, <host name/ip address> : <port number>, . . .

- -

For example:

- -
    -
  • ZKQuorum=centos23:5181,centos28:5181,centos29:5181
    • -
  • ZKClusterID=docs41cluster-drillbits
    • -
- -

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:

- -
    -
  • HOST=centos32.lab:5181
    • -
  • PORT=31010
    • -
- -

Driver Configuration Options describes configuration options available for controlling the -behavior of DSNs using the MapR Drill ODBC Driver.

-
-

Step 3: Configure the MapR Drill ODBC Driver

+

Step 4: Configure the MapR Drill ODBC Driver

Configure the MapR Drill ODBC Driver for your environment by modifying the .mapr.drillodbc.ini 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.

@@ -1252,16 +1261,12 @@ file. This configures the driver to work with your ODBC driver manager. The foll

Example

[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

Configuring .mapr.drillodbc.ini

@@ -1271,14 +1276,8 @@ ODBCInstLib=libiodbcinst.dylib
  • Open the mapr.drillodbc.ini configuration file in a text editor.
  • 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.
    A change in state occurs during driver initialization and is propagated to all driver DSNs.
    • -
  • 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.
    • -

  • Edit the ODBCInstLib setting. The value is the name of the ODBCInst shared library for the ODBC driver manager that you use. The configuration file defaults to the shared library for iODBC. The shared library name for iODBC is libiodbcinst.dylib.

    - -

    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 DYLD_LIBRARY_PATH.

    • -

  • Save the mapr.drillodbc.ini configuration file.

    • +
  • 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.
    • +
  • Save the mapr.drillodbc.ini configuration file.

    • Next Step

    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 @@ - Dec 24, 2016 + Jan 24, 2017 @@ -1118,11 +1118,13 @@ the Drill service.

    System Requirements

    +

    To install the driver, you need Administrator privileges on the computer.

    +
      -
    • Mac OS X version 10.6.8 or later
      • +
    • Mac OS X version 10.8.0 or later
    • 100 MB of available disk space
    • iODBC 3.52.7 or later
      -The iodbc-config file in the /usr/local/iODBC/bin includes the version.
      • +The iodbc-config file in the /usr/local/iODBC/bin includes the version of the driver.

    • 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.
      If not, create an entry in /etc/hosts for each node in the following format:

      @@ -1130,8 +1132,6 @@ If not, create an entry in /etc/hosts for each node in the followin Example: 127.0.0.1 localhost

    -

    To install the driver, you need Administrator privileges on the computer.

    -

    Step 1: Download the MapR Drill ODBC Driver

    @@ -1147,7 +1147,7 @@ Example: 127.0.0.1 localhost

    To install the driver, complete the following steps:

      -
    1. Double-click MapRDrill1.3.dmg to mount the disk image.
      2. +
    2. Double-click MapR_Drill_1.3.dmg to mount the disk image.
    3. Double-click MapRDrillODBC.pkg to run the Installer.
    4. Follow the instructions in the Installer to complete the installation process.
    5. When the installation completes, click Close.
      6. @@ -1159,20 +1159,24 @@ Example: 127.0.0.1 localhost

        -
      • /opt/mapr/drillodbc/ErrorMessages – Error messages files directory
        • -
      • /opt/mapr/drillodbc/Setup – Sample configuration files directory
        • -
      • /opt/mapr/drillodbc/lib/universal – Binaries directory
        • +
      • /Library/mapr/drill/ErrorMessages – Error messages files directory
        • +
      • /Library/mapr/drill/Setup – Sample configuration files directory
        • +
      • /Library/mapr/drill/lib – Binaries directory
      -

      Step 3: Check the MapR Drill ODBC Driver version

      +

      Step 3: Check the MapR Drill ODBC Driver Version

      To check the version of the driver you installed, use the following command on the terminal command line:

      -
      $ pkgutil --info mapr.drillodbc
+
      $ 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  
+
      
+
      To display information about the iODBC driver manager installed on the machine, issue the following command:  
      
+
      /usr/local/iODBC/bin/iodbc-config
 
      
 
      Next Step
      
 

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 @@
      - + Jan 24, 2017 @@ -1179,15 +1179,15 @@ Enter ODBC connect string (? shows list):
      1. Start Drill.
      2. Start the iODBC Administrator.app in /Applications.
        -The iODBC Data Source Administrator dialog appears.
        3. -
      3. On the User DSN tab, select the MapR Drill DSN.
        -
        4. +The iODBC Data Source Administrator dialog appears. +
      4. On the User DSN tab, select the MapR Drill.
        +
      5. Click Test.
        -The Login for Sample MapR Drill DSN dialog appears.
        -
        6. +The Login for Sample MapR Drill dialog appears.
        +
      6. If you configured Basic Authentication in the .odbc.ini, enter the user name and password you also configured; otherwise, click OK.
        The success message appears.
        -
        7. +

      Testing the ODBC Connection on Windows

      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 @@ / - Fri, 23 Dec 2016 16:36:27 -0800 - Fri, 23 Dec 2016 16:36:27 -0800 + Tue, 24 Jan 2017 14:28:38 -0800 + Tue, 24 Jan 2017 14:28:38 -0800 Jekyll v2.5.2