Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
20 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 ...
user avatar
0 votes
0 answers
7 views

Updating ApacheDs. Changing source code to match

I was wondering how to change the ApacheDs source code to match the updated ones. What is typically the main issue in the code that needs updating. Thank you!
user avatar
0 votes
2 answers
833 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 ...
user avatar
  • 145
1 vote
1 answer
32 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} ...
user avatar
  • 615
1 vote
0 answers
197 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 ...
user avatar
  • 11
1 vote
2 answers
433 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,...
user avatar
  • 151
0 votes
2 answers
89 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 ...
user avatar
  • 73
0 votes
1 answer
66 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 ...
user avatar
  • 197
2 votes
1 answer
2k 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 ...
user avatar
0 votes
1 answer
980 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 ...
user avatar
0 votes
1 answer
110 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 ...
user avatar
  • 4,681
1 vote
0 answers
284 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 ...
user avatar
1 vote
1 answer
70 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 ...
user avatar
1 vote
1 answer
6k 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 ...
user avatar
  • 11
1 vote
1 answer
1k 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. ...
user avatar
0 votes
1 answer
52 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 (...
user avatar
  • 111
0 votes
1 answer
198 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?
user avatar
  • 827
1 vote
0 answers
178 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 ...
user avatar
0 votes
1 answer
41 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 ...
user avatar
  • 71
0 votes
1 answer
947 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 ...
user avatar
  • 3
3 votes
3 answers
17k 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 ...
user avatar
0 votes
1 answer
32 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 ...
user avatar
0 votes
1 answer
561 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 ...
user avatar
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 ...
user avatar
0 votes
1 answer
931 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....
user avatar
  • 13
-3 votes
2 answers
53 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 ...
user avatar
  • 1
1 vote
0 answers
219 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 ...
user avatar
  • 878
1 vote
0 answers
561 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?
user avatar
2 votes
1 answer
438 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 ...
user avatar
1 vote
1 answer
140 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 ...
user avatar
  • 1,680
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 ...
user avatar
  • 85
0 votes
2 answers
558 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 $...
user avatar
  • 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 ...
user avatar
  • 11
20 votes
2 answers
39k 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 ...
user avatar
  • 588
0 votes
1 answer
135 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 ...
user avatar
  • 163
3 votes
1 answer
149 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 ...
user avatar
1 vote
0 answers
279 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 ...
user avatar
  • 528
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;...
user avatar
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 ...
user avatar
6 votes
2 answers
543 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 ...
user avatar
5 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 ...
user avatar
  • 133
1 vote
1 answer
1k 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 ...
user avatar
  • 121
1 vote
1 answer
924 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. ...
user avatar
  • 165
2 votes
1 answer
103 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; -> ...
user avatar
  • 827
0 votes
3 answers
11k 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 ...
user avatar
2 votes
1 answer
9k 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 ...
user avatar
  • 165
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 ...
user avatar
2 votes
1 answer
627 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 ...
user avatar
0 votes
1 answer
347 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 ...
user avatar
  • 327
2 votes
1 answer
220 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 ...
user avatar