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
0 answers
28 views

ssh-certificate LDAP schema existence?

Hello. I'm looking for an LDAP schema to make it possible to publish my ssh-certificates into user/host LDAP nodes. Is there any common one?
8 votes
4 answers
3k views

Where can i find the latest unattended.xml schema (xsd)?

I'm working with Windows Server 2012, Windows Deployment Service (WDS), and Windows Assessment and Deployment Kit (ADK). I created a base unattended.xml file. When I go to edit in an xml editor it's ...
3 votes
2 answers
13k 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 ...
0 votes
1 answer
99 views

Where do I find the LDAP scheme for Postifx or which alternative should I use?

The howto https://www.postfix.org/LDAP_README.html describes LDAP object with object classes virtualaccount ldapgroup ldapuser attributes mail memberdn memberaddr maildrop Where do I find the ...
4 votes
3 answers
4k 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 ...
5 votes
3 answers
24k 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
50 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 ...
10 votes
1 answer
795 views

AD custom attribute of type numerical string crashes MMC when updated

I am using windows server 2008. I have a domain with one domain controller (this is a dev environment). I edited the AD schema and created a custom attribute called TestAttribute2 (the LDAP name is ...
1 vote
2 answers
3k views

OpenLDAP schema location (cn=schema,cn=config) does this exist?

We're trying to get an instance of OpenLDAP up and running. I'm using ApacheDS as the browser. When I go to create my objects in the LDAP database, I see that a number of objects and attributes don't ...
1 vote
1 answer
39 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} ...
1 vote
0 answers
551 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 ...
1 vote
2 answers
942 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,...
0 votes
2 answers
381 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 ...
0 votes
1 answer
111 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 ...
40 votes
2 answers
71k views

How can I do a dump of only the table structure in PostgreSQL?

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?
6 votes
9 answers
9k views

One Database vs. Multiple Databases [closed]

I need to design a system which represents multiple "projects", one per client in SQL Server , something similar to StackExchange... same data model, different sites (one per customer). Each project ...
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 ...
0 votes
1 answer
298 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 ...
1 vote
0 answers
295 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 ...
1 vote
1 answer
77 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 ...
18 votes
1 answer
40k views

What's the required to make a normal user can create schema on PostgreSQL?

I created a new database test and created user 'eonil' with this command: CREATE ROLE eonil LOGIN ENCRYPTED PASSWORD 'password' NOINHERIT VALID UNTIL 'infinity'; on my PostgreSQL. I run psql -U ...
21 votes
2 answers
45k 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 ...
2 votes
1 answer
8k 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 ...
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
63 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 (...
0 votes
1 answer
210 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?
1 vote
0 answers
262 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
98 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 ...
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 ...
0 votes
1 answer
674 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 ...
0 votes
2 answers
849 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 $...
0 votes
1 answer
54 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 ...
1 vote
1 answer
6k 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....
-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 vote
0 answers
303 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 ...
2 votes
0 answers
651 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?
6 votes
4 answers
48k views

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
6 votes
2 answers
654 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 ...
2 votes
1 answer
634 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 ...
1 vote
1 answer
171 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 ...
4 votes
2 answers
9k 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 ...
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 ...
6 votes
1 answer
9k 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 ...
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;...
0 votes
1 answer
160 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 ...
3 votes
1 answer
182 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 ...
1 vote
0 answers
297 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 ...
5 votes
2 answers
16k views

Unable to modify schema in OpenLDAP using run-time configuration cn=config

I'm having trouble modifying the schema of an OpenLDAP installation using the run-time configuration (cn=config). What I'm trying to do is modify existing attributes and add new ones to a custom ...
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 ...