OAuth v4.6.0 table is now using ttl variable, where it used to use rttl variable.

Products

• CA API Gateway

Issue/Introduction

Customer noticed that there is a difference between the ttl variable used when inserting to this tables

oauth_refresh_token_view_client_key

oauth_refresh_token_view_resource_owner

between v4.6.0 and previous version. In previous version of OTK solution kit, it used to insert the data with the refresh token ttl value and looks like with version 4.6.0, it is inserting with ttl value of the actual token expiration, not the refresh token.  

This is the Cassandra query in question: 

INSERT INTO oauth_refresh_token_view_client_key (client_key, resource_owner, otk_token, client_name) 
VALUES (${client_key}, ${resource_owner}, ${rtoken}, ${client_name}) 
USING TTL ${ttl};

INSERT INTO oauth_refresh_token_view_resource_owner (client_key, resource_owner, otk_token, client_name, status) 
VALUES (${client_key}, ${resource_owner}, ${rtoken}, ${client_name}, ${token_status}) 
USING TTL ${ttl};

Environment

Appliance Gateway 11.0, Software Gateway 11.0

Oauth Toolkit 4.6.0.

Cassandra database: DataStax Enterprise Server 5.1.39. 

Cause

Needed to update the ttl value on the OAuth code.

Resolution

We have updated TTL value. Fix provided OauthSolutionKit-4.6.0-Patch-2025_06.sskar