Skip to main content

Streamsets Data Collector authentication through LDAP

StreamSets Data Collector (SDC) allows user authentication based on files or LDAP. By default, Data Collector uses file authentication. This post gives you details on how to switch to use your company's LDAP.

To enable LDAP authentication you need to perform the following tasks:
- Configure the LDAP properties for the Data Collector configuration editing the $SDC_CONF/sdc.properties file:
     - set the value of the http.authentication.login.module property to ldap
     - configure the value of the http.authentication.ldap.role.mapping property to map your LDAP groups to Data Collector roles following this syntax:
            <LDAP_group>:<SDC_role>,<additional_SDC_role>,<additional_SDC_role>
        Multiple roles can be mapped to the same group or vice versa. You need to use a semicolon to separate LDAP groups and commas to separate Data Collector roles. Here's an example:
            http.authentication.ldap.role.mapping=LDAP000:admin;LDAP001:creator,manager;LDAP002:guest
        The roles you can use are the same (admin, manager, creator, guest) available by default in SDC for the authentication based on files.
         By default, this property is empty, but it is mandatory to set it when http.authentication.login.module=ldap.
 - Configure the LDAP connection information editing the $SDC_CONF/ldap-login.conf file like in the following example:
     ldap {
         com.streamsets.datacollector.http.LdapLoginModule required
         debug="false"
         useLdaps="false"
         contextFactory="com.sun.jndi.ldap.LdapCtxFactory"
         hostname="ldaphost.yourcompany.com"
         port="389"
         bindDn=""
         bindPassword=""
         authenticationMethod="simple"
         forceBindingLogin="true"
         userBaseDn="ou=ldappages,o=yourcompany.com"
         userRdnAttribute="uid"
         userIdAttribute="mail"
         userPasswordAttribute="userPassword"
         userObjectClass="person"
         roleBaseDn="ou=yourcompanygroups,o=yourcompany.com"
         roleNameAttribute="cn"
         roleMemberAttribute="uniquemember"
         roleObjectClass="groupOfUniqueNames";
     };

where
  • debug: enables debugging.
  • useLdaps: enables using LDAP over SSL.
  • contextFactory: the initial LDAP context factory. You could leave the default value com.sun.jndi.ldap.LdapCtxFactory
  • hostname: the LDAP server name.
  • port: the LDAP server port.
  • bindDn: the root distinguished name.
  • bindPassword: the connection password. The value can be set here or in a file and then set the reference to that file here.
  • authenticationMethod: the authentication method. You could leave the default value, simple
  • forceBindingLogin: determines if binding login checks are performed. Two possible values for this property. When true, SDC passes the user credentials inputted through the login form to the LDAP server for authentication. When false, SDC performs authentication based on the information received by the LDAP server.
  • userBaseDn: the base distinguished name under which user accounts are located.
  • userRdnAttribute: the name of the username attribute.
  • userIdAttribute: the name of the user ID attribute.
  • userPasswordAttribute: the name of the attribute where the user password is stored.
  • userObjectClass: the name of the user object class.
  • roleBaseDn: the base distinguished name to search for role membership.
  • roleNameAttribute: the name of the attribute for roles.
  • roleMemberAttribute: the name of the role attribute for user names.
  • roleObjectClass: the role object class.

In order to check for the proper objects classes, attribute names and values in your company's LDAP, you can use the ldapsearch command-line utility from a Linux machine. This is the syntax of the command in order to retrieve a given user information and the full list of properties for the user object:

ldapsearch -H ldap://<host>:<port> -D "BINDDN" -x -w 'PASSWORD' -b ROLEBASEDN

Example:

ldapsearch -H ldap://ldap.googlielmo.org:389 -D "" -x -w 'ldap123' -b "ou=ldap,o=googlielmo.org" "mail=john.smith@googlielmo.org"

Finally, don't forget to restart SDC to apply the configuration changes above.

Comments

Popular posts from this blog

Exporting InfluxDB data to a CVS file

Sometimes you would need to export a sample of the data from an InfluxDB table to a CSV file (for example to allow a data scientist to do some offline analysis using a tool like Jupyter, Zeppelin or Spark Notebook). It is possible to perform this operation through the influx command line client. This is the general syntax: sudo /usr/bin/influx -database '<database_name>' -host '<hostname>' -username '<username>'  -password '<password>' -execute 'select_statement' -format '<format>' > <file_path>/<file_name>.csv where the format could be csv , json or column . Example: sudo /usr/bin/influx -database 'telegraf' -host 'localhost' -username 'admin'  -password '123456789' -execute 'select * from mem' -format 'csv' > /home/googlielmo/influxdb-export/mem-export.csv

jOOQ: code generation in Eclipse

jOOQ allows code generation from a database schema through ANT tasks, Maven and shell command tools. But if you're working with Eclipse it's easier to create a new Run Configuration to perform this operation. First of all you have to write the usual XML configuration file for the code generation starting from the database: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-2.0.4.xsd">   <jdbc>     <driver>oracle.jdbc.driver.OracleDriver</driver>     <url>jdbc:oracle:thin:@dbhost:1700:DBSID</url>     <user>DB_FTRS</user>     <password>password</password>   </jdbc>   <generator>     <name>org.jooq.util.DefaultGenerator</name>     <database>       <name>org.jooq.util.oracle.OracleDatabase</name>     ...

Turning Python Scripts into Working Web Apps Quickly with Streamlit

 I just realized that I am using Streamlit since almost one year now, posted about in Twitter or LinkedIn several times, but never wrote a blog post about it before. Communication in Data Science and Machine Learning is the key. Being able to showcase work in progress and share results with the business makes the difference. Verbal and non-verbal communication skills are important. Having some tool that could support you in this kind of conversation with a mixed audience that couldn't have a technical background or would like to hear in terms of results and business value would be of great help. I found that Streamlit fits well this scenario. Streamlit is an Open Source (Apache License 2.0) Python framework that turns data or ML scripts into shareable web apps in minutes (no kidding). Python only: no front‑end experience required. To start with Streamlit, just install it through pip (it is available in Anaconda too): pip install streamlit and you are ready to execute the working de...