Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-360

Authenticate EXASolution user against LDAP server

    Details

    • Type: How To
    • Status: Published
    • Affects Version/s: EXASolution 5.0.13
    • Fix Version/s: None
    • Component/s: EXAoperation, EXASolution
    • Labels:
      None
    • Solution:
      Hide

      To authenticate EXASolution users against LDAP server(s), it is necessary to edit the corresponding database configuration in EXAoperation to the your LDAP server(s) URL.

      The comma seperated LDAP servers list must be in the following format:

      ldap[s]://my.ldapserver.example.com[:PORTNUMBER]
      

      Please note, that a configuration changes requires a database restart for new settings being activated.

      After the restart of the database users can be added in the database with the help of the following SQL statement:

      CREATE USER user_2 IDENTIFIED AT LDAP
      AS 'cn=user_2,dc=authorization,dc=exasol,dc=com';
      

      Please refer to the EXASolution User Manual https://www.exasol.com/support/secure/attachment/38778/EXASolution_User_Manual-5.0.13-en.pdf for more details on syntax.

      procedure
      • stop database
      • edit database configuration

      • add LDAP server
      • start database
      Show
      To authenticate EXASolution users against LDAP server(s), it is necessary to edit the corresponding database configuration in EXAoperation to the your LDAP server(s) URL. The comma seperated LDAP servers list must be in the following format: ldap[s]://my.ldapserver.example.com[:PORTNUMBER] Please note, that a configuration changes requires a database restart for new settings being activated. After the restart of the database users can be added in the database with the help of the following SQL statement: CREATE USER user_2 IDENTIFIED AT LDAP AS 'cn=user_2,dc=authorization,dc=exasol,dc=com'; Please refer to the EXASolution User Manual https://www.exasol.com/support/secure/attachment/38778/EXASolution_User_Manual-5.0.13-en.pdf for more details on syntax. procedure stop database edit database configuration add LDAP server start database
    • Category 1:
      Cluster Administration - DB Instance Management
    • Category 2:
      Database Administration

      Attachments

        Issue Links

        1. ldap-entry-db.png
          ldap-entry-db.png
          16 kB
        2. edit-db.png
          edit-db.png
          120 kB
        3. db.png
          db.png
          60 kB

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: