Tables Listing in Confluence
mysql> show tables; +----------------------+ | Tables_in_confluence | +----------------------+ | ATTACHMENTDATA | | ATTACHMENTS | | BANDANA | | BODYCONTENT | | CLUSTERSAFETY | | CONFANCESTORS | | CONFVERSION | | CONTENT | | CONTENTLOCK | | CONTENT_LABEL | | CONTENT_PERM | | CONTENT_PERM_SET | | DECORATOR | | DRAFT | | EXTRNLNKS | | INDEXQUEUEENTRIES | | LABEL | | LINKS | | NOTIFICATIONS | | OS_PROPERTYENTRY | | PAGETEMPLATES | | PLUGINDATA | | SPACEGROUPS | | SPACEPERMISSIONS | | SPACES | | TRACKBACKLINKS | | external_entities | | external_members | | groups | | hibernate_unique_key | | local_members | | os_group | | os_user | | os_user_group | | users | +----------------------+
How Confluence Stores Its Users and Groups
Confluence stores its users and groups information in four tables, namely users, os_user, os_group and os_user_group.
mysql> describe users; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | id | bigint(20) | | PRI | 0 | | | name | varchar(255) | | | | | | password | varchar(255) | YES | | NULL | | | email | varchar(255) | YES | | NULL | | | created | datetime | YES | | NULL | | | fullname | varchar(255) | YES | | NULL | | +----------+--------------+------+-----+---------+-------+
mysql> describe os_group; +-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+-------+ | id | bigint(20) | | PRI | 0 | | | groupname | varchar(255) | | UNI | | | +-----------+--------------+------+-----+---------+-------+
mysql> describe os_user; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | id | bigint(20) | | PRI | 0 | | | username | varchar(255) | | UNI | | | | passwd | varchar(255) | YES | | NULL | | +----------+--------------+------+-----+---------+-------+
mysql> describe os_user_group; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | group_id | bigint(20) | | PRI | 0 | | | user_id | bigint(20) | | PRI | 0 | | +----------+------------+------+-----+---------+-------+
Reference
- Atlassian LDAP Integration contact person: Nick Faiz
- About Atlassian User and LDAP integration

- Enable LDAP Authentication on Confluence 2.0

- Enable LDAP authentication for Confluence 2.1
