-
Notifications
You must be signed in to change notification settings - Fork 18
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Need help! combine AD with Oracle #69
Comments
Finally we are now able to join Active Direcorty with DB - one step further, but still open issues:
Still not working:
I am still happy for any help. Thanks in advance. |
Issue 1 - case insensitive join (solved)This solution is not perfect, but works fine for our use case. In class from
to
Maybe this could be solved with a config setting? Issue 2 is still unresolved for us
|
For issue 1 - we avoid doing this because we don't want to override the databases' index. i'm not an Oracle expert, but I've done this with SQL Server and MySQL/MariaDB where you can define your index to be case insensitive. Is this an option? For issue 2 - yes, you can use the ACLs insert (look for Access Control in Access Controls in https://www.tremolosecurity.com/docs/tremolosecurity-docs/myvd/1.0.6/myvd.html) . Here's an example - https://github.com/TremoloSecurity/MyVirtualDirectory/blob/master/test/TestServer/testACLs.props |
@mlbiam thanks for your reply! issue 1: We are not able to change anything on the Oracle DB so that's why this change needed for us. Would be great to have a setting for this so other users can also solve such issues. issue 2: Thanks for the examples. Solved now for us. |
Hi
I am a total beginner with LDAP so please be patient with me.
I need to extend user attributes from an Active Directory with data from an Oracle DB.
I'm not able to upload a picture of my AD structure but the DN of one user is distinguishedName: CN=Administrator,CN=Users,DC=mb,DC=local
My DB table structure is as following:
The DB data are as following:
In my test lab I installed a plain AD (mb.local, IP:10.0.4.4), an Oracle server (IP: 10.0.4.40) and a centos server (IP: 10.0.4.41) with latest version of myVirtualDirectory (commit: 5d71c5c).
This is the config I currently have:
I would expect to see at leased the two sources in myVD but I don't see any of them.
So my question is:
I am grateful for any help.
Thanks in advance.
The text was updated successfully, but these errors were encountered: