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.
113
questions
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 ...
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 ...
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
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 ...
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 ...
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;...
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 ...
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, ...
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 ...
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 ...
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 ...
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
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 ...
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. ...
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 ...
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 ...
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: ...
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 ...
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 ...
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
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 ...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 - ...
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 ...
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 ...
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
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 ...
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 ...
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
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 ...
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....
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 $...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...