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
1 vote
1 answer
947 views

Server 2008 R2 schema changes - any since RC?

I know that there were schema updates in the 2008 R2 beta and more in the 2008 R2 Release Candidate. Does anyone know if there are any additional schema changes required for 2008 R2 RTM? I haven't ...
serialhobbyist's user avatar
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
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 ...
mj_'s user avatar
  • 131
1 vote
1 answer
12k views

How to change OrganizationName after setup /p

I am working on cloning our primary AD DC to create a development environment. I have exported the relevant data from AD using ldifde but in order to import it on the new server, I need the Exchange ...
jamesbtate's user avatar
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
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
1 vote
1 answer
76 views

Is this normal or due to bug in mongodb?

I am new to mongodb and i installed it on xen para virtual vm and when given command "mongo" terminal freezed and on the top output command mongo is taking almost 100% CPU. Is this a bug,or does ...
Kevin Parker's user avatar
1 vote
1 answer
566 views

ActiveDirectory lastLogonTimeStamp Inactive

In joining a new company, I have inherited it's history. I find that the User and Computer Object property lastLogonTimeStamp is not available. I have checked that the AD Schema version is 2003 R2, ...
gWaldo's user avatar
  • 12k
1 vote
1 answer
3k views

Where is "Custom Attribute 14" in AD Schema?

I'm getting the following error when writing to Active Directory attribute 14 00002082: AtrErr: DSID-03151314, #1: 0: 00002082: DSID-03151314, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att ...
makerofthings7's user avatar
1 vote
1 answer
1k views

LDAP schema design

I am pretty new to LDAP & trying to design a schema for a particular need. I have a Support Organization. There are three levels P1 - lowest permissions P2 - middle P3 - highest permissions. I ...
Genboy's user avatar
  • 69
1 vote
1 answer
3k views

Is there a maximum number of schemas allowed in SQL Server 2005?

What is the maximum number of user schemas one can create in a single SQL Server 2005 database? Is this figure different on SQL Server Express vs SQL Server Standard? I've searched the MSDN ...
hjd's user avatar
  • 115
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
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
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
1 vote
2 answers
590 views

Looking for advice on LDAP objectClasses for syncing with Google Apps

I am setting up an OpenLDAP server on Ubuntu so that this will be the authoritative user database for authentication. I'm going to be using Atlassian Crowd with it so that Google Apps can then use SSO ...
Philip Colmer's user avatar
1 vote
1 answer
70 views

Is there a "rigorous" method for choosing a database? [closed]

I'm not experienced with NoSQL, but one person on my team is calling for its use. I believe our data and its usage isn't optimal for a NoSQL implementation. However, my understanding is based off ...
vowel-house-might's user avatar
1 vote
1 answer
3k views

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

I have the following ldif file which I am trying to load into openLDAP: Custom schema being created for the Monas project dn: cn=testSchemas,cn=schema,cn=config objectClass: olcSchemaConfig cn: ...
Dark Star1's user avatar
  • 1,425
1 vote
1 answer
1k views

AD Schema updates, Exchange 2007 SP3 == Server 2008?

In terms of schema updates does 'Exchange 2007 SP3' adprep /forestprep and 'Server 2008' adprep /forestprep do the same thing? I'd like to add a 2008r2 DC to an existing 2003-level forest (which ...
BoyMars's user avatar
  • 1,012
1 vote
0 answers
554 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
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
0 answers
264 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
1 vote
0 answers
304 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
1 vote
1 answer
172 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
1 vote
0 answers
298 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
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
1 vote
1 answer
213 views

Unable to change schema of a Publication Database using TSQL (Ready-roll): being forced stop replication

I am trying to apply schema changes using T-SQL (using Ready-Roll database source control tool with Octopus Deployment) to a Publication database however it is forcing me stop Replication for the ...
Daniel's user avatar
  • 11
1 vote
2 answers
2k views

How do I update a table's schema with a new custom schema I have created?

I am using SQL Server 2008 Express and Sql Server Management Studio 2008. I am trying to associate a database table with a new schema. I have created a new Schema by navigating to Security->Schemas ...
Lewray's user avatar
  • 143
1 vote
2 answers
501 views

File sharing/permissions scheme for students/teachers/staff?

I've recently inherited administration of an Xserve running OS X Server 10.5.8. I have a specific need for teaching staff to access the home folders of students via network shares. Ideally in groups - ...
Music Tech's user avatar
1 vote
1 answer
821 views

XML Schema For MBSA Reports

I'm in the process of creating a script to run the command line version of Microsoft Baseline Security Analyzer (mbsacli.exe) against all of our servers. Since the MBSA reports are provided as XML ...
Steve Hawkins's user avatar
0 votes
2 answers
3k views

SQL Server Database Design for Archiving Process

I am currently working on a large project to move an MS Access application to SQL server. Our team has been having discussions on the best way to design a part of the new database so I figured I ...
Taryn's user avatar
  • 103
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
1k views

What would prevent me from modifying my LDAP schema?

I am trying to follow this guide to configure kerberos on my Ubuntu server. I got up the part where they want to add the new schema to my server user ldapadd I follow the instructions as they say. I ...
AtomicPorkchop's user avatar
0 votes
1 answer
917 views

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a ...
Continuation's user avatar
  • 3,130
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
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
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
0 votes
2 answers
851 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
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
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
0 votes
1 answer
88 views

Install the same Active Directory Schema extension again

is there any possibilty of problems, due to a 2nd time installation of the schema extension for a lync server, in an active directory childdomain of a forest? Replication overhead would not be that ...
namefieldcleared's user avatar
0 votes
2 answers
782 views

how to add groupOfEntries object class to openLDAP

I am working on the design of LDAP structure, that basically should hold users and groups. There should be support for nested groups (so I thought on using groupOfNames object class) and for the ...
hovanessyan's user avatar
0 votes
1 answer
2k views

Remove security permissions from AD objects for old SID´s

I have the following problem. Recently we have migrated from Notes/Domino to Exchange 2010. We had some problems with the first installation. In case of that we decided to reinstall Exchange. Stupid ...
MRae's user avatar
  • 109
0 votes
2 answers
519 views

How to define user as dbo of a specific schema

I'm creating a multi-tenant application that will utilize a single database with multiple schemas. Each tenant will have their own respective login/password. I was able to restrict view permissions to ...
Omar's user avatar
  • 195
0 votes
1 answer
344 views

Do I need R2 of Server 2003 to update the schema on a DC to support Mac systems?

I'm attempting to integrate a Snow Leopard server and a number of client machines into my AD network and I'm wondering if I can update the schema on a DC running Server 2003 (NOT R2) to support mac ...
Christopher at CMU's user avatar
0 votes
1 answer
4k views

auto generate AD network Diagram with visio or other tools

It's there a way in visio to automaticly design the Network Diagram of my domain ? I found Microsoft Active Directory Topology Diagrammer, but this software not design the member of my domain. I ...
Cédric Boivin's user avatar
0 votes
2 answers
7k views

how long to replicate adprep /forestprep to second domain controller?

i updated our sbs 2003 server using adprep /forestprep waited about 1/2hr and checked the second DC 's usn number, the sbs 2003 is 8875 and the usn for the second DC is 4410? can i force the second ...
dasko's user avatar
  • 1,244
0 votes
1 answer
98 views

Active Directory Trusts and Schema

Our company is in the process of implementing a "cloud proxy" that will utilize Active Directory for user/password lookup. The idea is to expend this and build trusts to customer's AD. My Question ...
kruczkowski's user avatar
0 votes
0 answers
30 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
106 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