Table

cm_oauth2_servers

Description

OAuth2 Servers

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


server_id

integer, foreign key

Server ID

cm_servers:id


serverurl

varchar(256)

OAuth2 Server endpoint

RFC 6749

Endpoint to OAuth2 services

clientid

varchar(120)

OAuth2 Client ID

RFC 6749


client_secret

varchar(80)

OAuth2 Client Secret

RFC 6749

This column should be encrypted

access_grant_typevarchar(2)OAuth2 Access Grant Type

RFC 6749

  • AC: Authorization Code
  • CC: Client Credentials
Implicit and Password Credentials not currently supported
scopevarchar(256)OAuth2 Token ScopeRFC 6749
refresh_tokentextCurrent refresh tokenRFC 6749Column type changed to text from varchar(160) for v4.4.0 (CO-2843)
access_tokentextCurrent access tokenRFC 6749Column type changed to text from varchar(160) for v4.4.0 (CO-2843)
access_token_expintegerCurrent access token expiration timeRFC 6749Added Registry v4.5.0 (CO-2857)
proxyvarchar(512)Proxy configuration string

Proxy host and Proxy port separated by colon punctuation

Added Registry v4.4.0

token_responsetextFull token received from OAuth2Server
Intended so specific implementations can access vendor specific attributes