Questions tagged [schema]
A schema describes the structure of various elements like tables, fields, objects, attributes, etc. for example for a database or a directory.
112
questions
0
votes
0
answers
17
views
How to delete a schema with OpenLDAP without service interruption? [duplicate]
I run OpenLDAP 2.6.2. I could successfully add a new custom schema with ldapadd, but now I would like to remove the schema without stopping the OpenLDAP server. In other words I would like to use ...
- 195
0
votes
1
answer
37
views
Is it possible to restrict which object classes a dynamically linked auxiliary class can be added to when extending the AD schema?
I've created a custom auxiliary class for the purpose of adding attributes to AD Group objects. I'm dynamically linking the auxiliary class to individual Groups. I can successfully add it to the ...
- 246
2
votes
2
answers
9k
views
Why can't I grant select privileges to all table in schema with PostgreSQL?
I have a database my_database, and it have some tables named my_table_1, my_table_2, ... , my_table_128 under schema public. I need to grant select privileges for all tables in schema public to user ...
- 195
1
vote
1
answer
36
views
MySQL 1 schema, 1 filesystem
This is a ''general'' question. Hear me out.
Let's say I have a MySQL standalone or even a 3 or 5 nodes cluster.
Would it be a good practice to have 1 filesystem per schema ?
For example, schema{1..5} ...
- 781
1
vote
0
answers
427
views
Active Directory OU Access Control Entry ACE Issue .Net PowerShell and dsa.msc Discrepancy
I’m attempting to automate delegated permissions of an Active Directory (AD) Organizational Unit (OU) using Access Control Entries (ACE).
However, I don’t fully understand Active Directory schema and ...
- 11
1
vote
2
answers
775
views
LDAP schema objectclass multiple inheritance confuses me
I have set up OpenLDAP 2.4.50 on alpine 3.12.1 and fed cosine, inetorgperson and nis LDIF schemas to it using ldapadd. Now I wanted to add a custom object class. I added an entry cn=mystuff,cn=schema,...
- 181
0
votes
2
answers
229
views
Is it OK to install Exchange 2016 when ms-Exch-Schema-Version-Pt rangeUpper = 17001 without an Exchange 2019 server?
An admin in the organization ran /PrepareSchema from an Exchange 2019 ISO and it succeeded. The following day their application vendor said Exchange 2019 is not supported for mail integration. So the ...
- 73
0
votes
1
answer
101
views
Openldap backup > restore omits certain attributes
Migrating from Debian Jessie (openldap 2.4.40) to Debian Buster (openldap 2.4.47), I came across a few bumps but the last one is just baffling.
First issue: ldapsearch does not return all attributes ...
- 232
4
votes
3
answers
3k
views
Issues with LAPS
For the past three hours I've sat at my desk ready to smash my Dell R710 in with a baseball bat. After installing all features of LAPS and running import-module AdmPwd.PS, I can't seem to get AD to ...
- 41
0
votes
1
answer
2k
views
OpenLDAP Group: How to create a group object with both member and memberUid attributes?
I've just installed and configured OpenLDAP 2.4 in CentOS 8 and I'm now creating Groups and it's members for future use.
One of these future use will be LDAP+PAM integration, which is why I want my ...
- 137
0
votes
1
answer
240
views
Why shouldn't LDAP support inequality searches on shadowExpire?
When I try to search my OpenLDAP 2.4.42 server for (shadowExpire<=18074), I get no results. However, a search for (shadowExpire=12671) yields several results.
My ultimate goal is to periodically ...
- 4,771
1
vote
0
answers
289
views
Advantages of Microsoft Enterprise Mode Schema v.2 over v.1?
Title explains it really. The company I work for is considering changing their Enterprise Schema from v.1 to v.2. I am aware that there are structural changes to the coding, however I am not aware of ...
- 19
1
vote
1
answer
74
views
Using PrepareSchema on existing Exchange 2007 Server - Mailboxes have PROTECTED INHERIT flag
I was trying to create a new Receive Connector on my older Exchange 2007 SP3 server (planning underway to upgrade later this year) and when it failed I did some research. The solution I found Here (I ...
- 634
2
votes
1
answer
7k
views
how to modify schema in openldap
So I have a fresh installation of openldap on a debian 9 machine which currently looks like
It's going to be a database for telephone numbers, too keep it easy, I'll use this example: The database ...
- 21
1
vote
1
answer
2k
views
OpenLDAP: Adding olcObjectClasses to scheme
I have added a scheme to OpenLDAP via cn=conf. The scheme was taken from WSO2 Identity Server, but was modified to apply to cn=conf and OpenLDAP.
The scheme loaded without error, but doesn't work. ...
0
votes
1
answer
55
views
How to add logic to a new customized attribute in AD schema
I need to create new attribute named:
LastLoggedWorkstation
This attribute should contain the name of the last machine\IP from which the user logged on.
I know how to add new attribute to AD schema (...
- 111
0
votes
1
answer
208
views
Importing a extended attribute in schema in AD , does it need mAPIID put into LDIF file?
What exactly is mAPIId and should it be put into the ldif file when the schema is imported into a AD forest?
- 827
1
vote
0
answers
255
views
Is it ok to change the EQUALITY on an attributetype in openldap
I'd like to be able to do substring searches against a particular attribute which is defined in the schema as:
attributetype ( 1.3.6.1.1.1.1.25 NAME 'automountInformation'
DESC 'Information ...
0
votes
1
answer
58
views
LDAP: Modify the "must" fields of a class an migrate previous entries
I use the email of my users in my LDAP class as a 'must':
// schema.ldif
objectClasses: ( 2.25.XXXX.3 NAME 'user' SUP inetOrgPerson STRUCTURAL MUST mail MAY ( XXX ) )
And my user are stored in my ...
- 43
0
votes
1
answer
2k
views
How to recover FSMO Schema master
I am trying to raise a secondary "AD DC" server on a WIN 2012. My primary server is a Win 2008. While going through the Add feature process, I got the error message:
error determining whether the ...
- 3
5
votes
3
answers
22k
views
openLDAP ldap_modify: Server is unwilling to perform (53) when trying to delete custom schema
I have created this custom and very basic schema:
objectclass ( 2.25.2.2.1
NAME 'myObjectClass'
DESC 'myObjectClass objectclass'
STRUCTURAL
MUST ( cn )
)
I have added it without ...
0
votes
1
answer
38
views
how do i make a schema for sql server 2008
Brand new Jr. Sys Admin here, trying to wrap my head around the system in place. We've got a DB on Microsoft SQL Server 2008 and I want to get a visual on what tables & Fields are in place. Just ...
0
votes
1
answer
649
views
Debian jessie : OpenLDAP Server how to add new schema?
The following items are schema of context. I will add
attributetype ( 1.3.6.1.4.1.9.500.1.3
NAME 'CiscoDomain'
DESC 'Domain for VPN users'
EQUALITY caseIgnoreMatch
SUBSTR ...
1
vote
1
answer
5k
views
sshPublicKey Attribute not showing - OpenLDAP PHPLDAP SSH Key Auth
I have imported from what I can tell successfully the sshPublicKey schema but the attribute doesn't show in PHPLDAPADMIN.
Anybody have any experience with this issue?
What I did verbatim :
sudo ...
0
votes
1
answer
1k
views
OpenLDAP schema error
I want to import some schemas into the LDAP. But I get this error:
ldapadd: invalid format (line 21) entry: ""
This is the file with the schemas:
# ****-Schema-Datei.
#
# OID prefix: 1.3.6.1.4.1....
- 13
-3
votes
2
answers
54
views
ethernet cable configuration with possibility to connect one computer at the end or at the middle of the cable [closed]
I would like to know if this Ethernet configuration would work.
ethernet configuration
Of course, only one device could be connected to either socket 1 or socket 2.
The cables between router and ...
- 1
1
vote
0
answers
283
views
rfc2307bis LDAP schema: ipNetmaskNumber lookup for an ipHost object
I'm using Openldap for IAM, and consider using it also as a configuration management backend.
The rfc2307bis schema has an ipHost class, which allows for ipHostNumber attribute, but not for the ...
- 928
1
vote
0
answers
630
views
LDAP attribute for image/png
Like the jpegPhoto-attribute (0.9.2342.19200300.100.1.60) of inetOrgPerson for the mime-type image/jpeg - I'm searching a LDAP-attribute for image/png.
Does such a pngPhoto or pngImage exists?
- 11
2
votes
1
answer
544
views
Manually (re-)create Active Directory schema objects msExchRecipientDisplayType and msExchRecipientTypeDetails from Exchange on Samba AD
Somehow, my Active Directory has "lost" (at least) 2 objects from the schema. msExchRecipientDisplayType and msExchRecipientTypeDetails are what I need to recreate.
I believe they were lost, because ...
- 409
1
vote
1
answer
160
views
openldap alternative to modifying core schema syntax
I have an application that stores contacts in OpenLDAP. It uses the c attribute to store a string describing a country name. The syntax of c only allows a two-letter country code, but the application ...
- 1,774
4
votes
2
answers
8k
views
Active Directory User Attribute List
I'm trying to find a list of Active Directory User Attributes that I can use for customization without having to extend the schema. We are using 2008R2 functional level.
I exported a list with ...
- 85
0
votes
2
answers
783
views
LDAP schema edit
I have default LDAP schema (389 DS instance) with the following objectClasses:
objectClasses: ( 1.3.6.1.1.1.2.17 NAME 'automount' DESC 'An entry in an automo
unter map' SUP top STRUCTURAL MUST ( cn $...
- 37
1
vote
2
answers
2k
views
Modifying OpenLDAP Schema - Adding 'host' attribute to 'person' objectclass
We have a legacy custom webapp that authenticates users against an OpenLDAP server. We are trying to set up another, separate OpenLDAP server to replace the older one, but we need to make the new ...
- 111
21
votes
2
answers
43k
views
How to migrate LDAP (database,schema,configuration) to other machine
I'm using openldap 2.4.40, and i need to migrate my existing ldap database, configuration, and schema (basically everything ldap server related) to a new machine.
the problem is, I use cn=config ...
- 608
0
votes
1
answer
154
views
PostgreSQL : Strange Sudden Data type AND select schema issue
Here is my problem :
Actually I am using postgresql 9.4 and postGIS extension.
I am creating a database, and adding new tables with no problems... with geometry data types... until now...
Now, I ...
- 163
3
votes
1
answer
178
views
In the context of Active Directory, what does "single schema" mean and why is this an advantage?
in my learning of AD DS Ecosystem I came across with this definition [link]:
By using the Windows Server® 2008 Active Directory® Lightweight Directory Services (AD LDS) role, formerly known as ...
- 145
1
vote
0
answers
292
views
Samba 4 schema extension - restart needed?
I'm integrating a custom schema in a Samba 4.2 server. This is working quiet well (using ldbmodify) but I wonder if it is necessary to stop the samba service before running ldbmodify. The Samba Wiki ...
- 548
1
vote
1
answer
9k
views
Importing Data Dump Using pgAdmin
I looked around and found the following code on how to import a data dump using pgadmin:
CREATE OR REPLACE FUNCTION db_to_csv(path TEXT) RETURNS void AS $$
tables RECORD;
gmdeclare
statement TEXT;...
- 21
0
votes
2
answers
1k
views
Probelms Installing Exchange 2010 Installation Organization Prep failed|can't Prepare Schema Server
I currently am running two exchange servers. I am running an Windows 2003 server with Exchange 2007 and I am also running a windows 2003 with Exchange 2003. I am adding two new Windows 2008 R2 servers ...
- 109
6
votes
2
answers
589
views
Is it possible for a schema change to not replicate, and a object that uses that schema arrive at a DC?
I'm trying to understand the risk of updating the schema of a very large AD forest, where the schema has not been on every DC, and then an object that uses that schema object is replicated
An example ...
- 8,921
6
votes
1
answer
8k
views
openLDAP how to remove the nis schema from the current configuration
openLDAP 2.4
Ubuntu 14.04
I have found this question dn-based linux groups from ldap. I am trying to include the rfc2307bis schema, but it seems the nis schema must be removed from the configuration ...
- 253
1
vote
1
answer
2k
views
What are the performance issues in SQL for single schema and multiple schema?
I have a critical performance scenario that,
I have to use more than 100 schema in a database. Each schema having more than 50 tables and few views. I need to use join queries for communicating ...
- 121
1
vote
1
answer
1k
views
Cannot see objectClass from custom schema
I added new schema to my ldap server but when I trey to create an entry with custom objectClass an custom attributes, it doesn't see my custom stuff. It's just experimental so OID's are not important.
...
- 185
2
votes
1
answer
106
views
Testing for Active Directory Schema modification (not upgrade)
I am trying to test a schema modification. That is i need to add one of the attributes to global catalog by modifying schema , initially in a lab which is exact replica.My questions are below;
-> ...
- 827
1
vote
3
answers
13k
views
Remove attributes from AD schema?
Can we edit a scheme in Active Directory?
Scheme cannot be deleted. But is there any possibility of editing?
For e.g. If the user object schema has 30 attributes, but i need only 10 attributes in ...
- 89
4
votes
1
answer
10k
views
OpenLDAP cannot add new schema
I'm trying to add new schema to my OpenLDAP server. The version of slapd is 2.4.23. I'm using Debian 6.
If I understood it well, slapd 2.4+ uses OLC configuration with (cn=config) by default for this ...
- 185
1
vote
2
answers
2k
views
AD - storing last 4 of employee social sec number as the employeeNumber attritubte?
I am currently working on scripting some of our access at work and would love an easy way to enter and retrieve the last 4 of a user's social sec number. It's the primary way we identify people that ...
- 333
2
votes
1
answer
734
views
Advantages of auxiliary classes when extending Active Directory schema
I need to add some attributes to the user class in Active Directory.
I see that to do this it is either possible to add the attributes directly to the user class, or to create an auxiliary class ...
- 1,296
0
votes
1
answer
351
views
zabbix change permission scheme
I have situation something like that: In zabbix I have two maps and I am looking for a solution how to set up access to the user had the ability to watch just one map.
Please on advice it is possible ...
- 347
2
votes
1
answer
226
views
Changing LDAP schema casts Confluence AD integration unoperable
I have had our instance of Atlassian Confluence configured to be integrated with our Active Directory.
In AD, all the users were being created under default Users folder in Active Directory Users ...
- 663