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?
X bl lJJ H i K's user avatar
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 ...
user2690527's user avatar
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 ...
Justin Cervero's user avatar
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 ...
fajin yu's user avatar
  • 205
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} ...
yield's user avatar
  • 800
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 ...
atothek's user avatar
  • 11
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,...
Timor's user avatar
  • 191
0 votes
2 answers
379 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 ...
mavsafe's user avatar
  • 73
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 ...
zenlord's user avatar
  • 242
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 ...
SovietBear's user avatar
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 ...
Rodrigo Renie's user avatar
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 ...
200_success's user avatar
  • 4,790
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 ...
AODonnell95's user avatar
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 ...
ItsPronounced's user avatar
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 ...
lemon's user avatar
  • 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. ...
Björn Vildljung's user avatar
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 (...
E235's user avatar
  • 111
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?
Darktux's user avatar
  • 837
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 ...
Greg Matthews's user avatar
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 ...
Gui13's user avatar
  • 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 ...
Rod's user avatar
  • 3
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 ...
Marco Antonio Suárez Peña's user avatar
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 ...
Andrew-Saarima's user avatar
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 ...
김재훈Jaehun Kim's user avatar
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 ...
FreeSoftwareServers's user avatar
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....
leet's user avatar
  • 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 ...
arckin's user avatar
  • 1
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 ...
badbishop's user avatar
  • 928
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?
mailwurf's user avatar
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 ...
Alex Stragies's user avatar
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 ...
roelvanmeer's user avatar
  • 1,794
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 ...
Gre's user avatar
  • 85
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 $...
alexBl's 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 ...
Karl's user avatar
  • 111
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 ...
J_LDAP's user avatar
  • 608
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 ...
Julo0sS's user avatar
  • 163
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 ...
Noob_Number_1's user avatar
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 ...
tlo's user avatar
  • 558
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;...
Max Power's 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 ...
Tripleb316's user avatar
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 ...
makerofthings7's user avatar
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 ...
lk7777's user avatar
  • 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 ...
felix's user avatar
  • 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. ...
shadox's user avatar
  • 185
2 votes
1 answer
108 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; -> ...
Darktux's user avatar
  • 837
1 vote
3 answers
14k 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 ...
user2490241's user avatar
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 ...
shadox's user avatar
  • 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 ...
soMuch2Learn's user avatar
2 votes
1 answer
783 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 ...
Paolo Tedesco's user avatar
0 votes
1 answer
355 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 ...
Mick's user avatar
  • 347