[
https://issues.apache.org/jira/browse/OPENMEETINGS-1492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15594828#comment-15594828
]
nikolay commented on OPENMEETINGS-1492:
---------------------------------------
The structure of the om_user table is:
CREATE TABLE `om_user` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`activatehash` VARCHAR(255) NULL DEFAULT NULL,
`age` DATETIME NULL DEFAULT NULL,
`deleted` BIT(1) NULL DEFAULT NULL,
`domain_id` BIGINT(20) NULL DEFAULT NULL,
`external_id` VARCHAR(255) NULL DEFAULT NULL,
`external_type` VARCHAR(255) NULL DEFAULT NULL,
`firstname` VARCHAR(255) NULL DEFAULT NULL,
`forceTimeZoneCheck` BIT(1) NULL DEFAULT NULL,
`inserted` DATETIME NULL DEFAULT NULL,
`language_id` BIGINT(20) NULL DEFAULT NULL,
`lastlogin` DATETIME NULL DEFAULT NULL,
`lastname` VARCHAR(255) NULL DEFAULT NULL,
`lasttrans` BIGINT(20) NULL DEFAULT NULL,
`login` VARCHAR(255) NULL DEFAULT NULL,
`owner_id` BIGINT(20) NULL DEFAULT NULL,
`password` VARCHAR(1024) NULL DEFAULT NULL,
`pictureuri` VARCHAR(255) NULL DEFAULT NULL,
`regdate` DATETIME NULL DEFAULT NULL,
`resethash` VARCHAR(255) NULL DEFAULT NULL,
`salutation` VARCHAR(20) NULL DEFAULT NULL,
`sendSMS` BIT(1) NULL DEFAULT NULL,
`show_contact_data` BIT(1) NOT NULL,
`show_contact_data_to_contacts` BIT(1) NOT NULL,
`time_zone_id` VARCHAR(255) NULL DEFAULT NULL,
`type` VARCHAR(20) NULL DEFAULT NULL,
`updated` DATETIME NULL DEFAULT NULL,
`user_offers` VARCHAR(255) NULL DEFAULT NULL,
`user_searchs` VARCHAR(255) NULL DEFAULT NULL,
`address_id` BIGINT(20) NULL DEFAULT NULL,
`sip_user_id` BIGINT(20) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `I_OM_USER_SIPUSER` (`sip_user_id`),
INDEX `address_id` (`address_id`),
CONSTRAINT `om_user_ibfk_1` FOREIGN KEY (`address_id`) REFERENCES
`address` (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=4
;
It is actually used only the following fields:
firstname,lastname,login. If we say about LOCAL DB<->MS AD....
> OM 3.1.3 duplication records in database
> ----------------------------------------
>
> Key: OPENMEETINGS-1492
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-1492
> Project: Openmeetings
> Issue Type: New Feature
> Components: LDAP
> Affects Versions: 3.1.3
> Environment: OS Centos 7
> Reporter: nikolay
> Assignee: Maxim Solodovnik
>
> I've installed OM 3.1.3 on Centos 7 and I got some ussues.
> The first of them is a dupplication of user's records in a local MySQL DB.
> Each time when a user logs into OM via ldap (MS AD) the new record for this
> user appears in OM database.
> If a user logs into OM locally (local DB [internal]) then it's OK.
> om_ldap.cfg file has ldap_provisioning=AUTOCREATE.
> Can anybody help me?
> Thanks.
> Regards
> Nikolay
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
