Pentaho

 View Only
  • 1.  Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-08-2022 09:07

    While configuring LDAP active directory with Pentaho BA server.

    We need to put server url, username & password then clicked on 'Test Server Connection' It's fine, I am able to connect LDAP server.

    After that while inserting - "Pentaho System Administrator" details 

    Select user from LDAP server: 

    Select role from LDAP server:

    I have selected Username but getting error as - "During your search, we were unable to find Admin user PentaHO. Please try a different Admin user."

    PentaHO is username which I have selected.

    Please help why getting such error, Even if all domain rights given to that perticular(PentaHO) user in LDAP active directory.



    ------------------------------
    Nikhil Shete
    IT Support Manager
    sansys
    ------------------------------


  • 2.  RE: Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-12-2022 06:14
    Hi Nikhil,

    Can you help me with the below details,

    - the user you have selected is it shown via the LDAP tree structure?
    - Or is this a service account?
    - Attach the applicationContext-security-ldap.properties file from /pentaho-solutions/system directory
    - Can you select the LDAP Provider to "Custom Configuration" and modify the search base where all your users are located


    ------------------------------
    Jagdeesh SS
    Application Architecture Engineering - Senior
    Hitachi Vantara
    ------------------------------



  • 3.  RE: Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-13-2022 01:41

    Hello Jagdeesh,

    Thank you so much for your response. 

    -Question: the user you have selected is it shown via the LDAP tree structure?

    Answer: No.

     -Question: Can you select the LDAP Provider to "Custom Configuration" and modify the search base where all your users are located

    Answer: Actually "Custom Configuration" option there but it is after selection of

    Pentaho System Administrator
    Select user from LDAP server:

    -Question: Attach the applicationContext-security-ldap.properties file from /pentaho-solutions/system directory

    Answer: As I am not able to proceed from LDAP configuration like mentioned in above screenshot, applicationContext-security-ldap.properties is same as original.

    please find details :

    contextSource.providerUrl=ldap\://localhost\:10389/ou\=system
    contextSource.userDn=uid\=admin,ou\=system
    contextSource.password=secret

    userSearch.searchBase=ou\=users
    userSearch.searchFilter=(cn\={0})

    populator.convertToUpperCase=false
    populator.groupRoleAttribute=cn
    populator.groupSearchBase=ou\=roles
    populator.groupSearchFilter=(roleOccupant\={0})
    populator.rolePrefix=
    populator.searchSubtree=false

    allAuthoritiesSearch.roleAttribute=cn
    allAuthoritiesSearch.searchBase=ou\=roles
    allAuthoritiesSearch.searchFilter=(objectClass\=organizationalRole)

    allUsernamesSearch.usernameAttribute=uid
    allUsernamesSearch.searchBase=ou\=users
    allUsernamesSearch.searchFilter=objectClass\=Person

    adminRole=cn\=Administrator,ou\=roles
    adminUser=uid\=admin,ou\=users



    ------------------------------
    Nikhil Shete
    IT Support Manager
    sansys
    ------------------------------



  • 4.  RE: Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-13-2022 07:53
    Hi Nikhil,

    Follow the below link to  configure your Pentaho application again,

    https://help.hitachivantara.com/Documentation/Pentaho/9.3/Setup/MSAD_security

    https://help.hitachivantara.com/Documentation/Pentaho/9.3/Setup/LDAP_security

    Following the steps should help you to authenticate Pentaho with your LDAP users.

    ------------------------------
    Jagdeesh SS
    Application Architecture Engineering - Senior
    Hitachi Vantara
    ------------------------------



  • 5.  RE: Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-13-2022 09:15
    Hello Jagdeesh,

    I already have those documents, i have followed same steps but at step 5 while selecting pentaho system administrator, i am not able to find username in LDAP tree structure, if i have manually put values there like cn=,ou=,dc= then pentaho through error as "unable to find admin user PentaHO"
    (as PentaHO is our LDAP user).

    My problem is I am not able to find PentaHO (system administrator) user from tree structure and that is why I could not proceed.

    ------------------------------
    Nikhil Shete
    IT Support Manager
    sansys
    ------------------------------



  • 6.  RE: Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-13-2022 11:00
    Nikhil,

    Are you able to test your LDAP server when you click the connection test? If not, give the correct URL of your LDAP server.
    I would also suggest you try the "Manual Configuration" approach where you will be modifying the backend file.

    ------------------------------
    Jagdeesh SS
    Application Architecture Engineering - Senior
    Hitachi Vantara
    ------------------------------



  • 7.  RE: Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-13-2022 23:20
    Yes, I am able to connect LDAP server when i click on test connection. After that I have to select system administrator user name & role from LDAP server I am not able to see my username in LDAP tree.( but user is there).​

    ------------------------------
    Nikhil Shete
    IT Support Manager
    sansys
    ------------------------------



  • 8.  RE: Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-15-2022 12:24
    Hi Nikhil,

    I would suggest you follow the manual configuration approach. This would require a screen sharing session, unfortunately, we can do that only for enterprise customers.

    ------------------------------
    Jagdeesh SS
    Application Architecture Engineering - Senior
    Hitachi Vantara
    ------------------------------



  • 9.  RE: Getting error; Admin user issue, Pentaho configuration with LDAP

    Posted 12-18-2022 17:15
    Hi Jagdeesh

    You should try installed a copy of OpenLDAP, finding your admin user in there and then comparing the search string to the one you've entered into Pentaho.

    LDAP search is tricky.

    Regards

    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------