[
https://issues.apache.org/jira/browse/KNOX-3326?focusedWorklogId=1021260&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-1021260
]
ASF GitHub Bot logged work on KNOX-3326:
----------------------------------------
Author: ASF GitHub Bot
Created on: 20/May/26 13:19
Start Date: 20/May/26 13:19
Worklog Time Spent: 10m
Work Description: hanicz opened a new pull request, #1237:
URL: https://github.com/apache/knox/pull/1237
(It is very **important** that you created an Apache Knox JIRA for this
change and that the PR title/commit message includes the Apache Knox JIRA ID!)
[KNOX-3326](https://issues.apache.org/jira/browse/KNOX-3326) - Add SSL
configuration for Oracle DB support
## What changes were proposed in this pull request?
Adds SSL configuration support to Oracle DB
## How was this patch tested?
Tested with an actual Oracle DB that had TCPS setup
```
<property>
<name>gateway.service.tokenstate.impl</name>
<value>org.apache.knox.gateway.services.token.impl.JDBCTokenStateService</value>
</property>
<property>
<name>gateway.database.connection.url</name>
<value>jdbc:oracle:thin:@tcps://host:2484/FREEPDB1?oracle.net.ssl_server_dn_match=false</value>
</property>
<property>
<name>gateway.database.type</name>
<value>oracle</value>
</property>
<property>
<name>gateway.database.ssl.enabled</name>
<value>true</value>
</property>
<property>
<name>gateway.database.ssl.verify.server.cert</name>
<value>true</value>
</property>
<property>
<name>gateway.database.ssl.truststore.file</name>
<value>/tmp/oracle_truststore.jks</value>
</property>
```
`install/knox-3.0.0-SNAPSHOT/bin/knoxcli.sh generate-jwk --saveAlias
knox.token.hash.key`
`install/knox-3.0.0-SNAPSHOT/bin/knoxcli.sh create-aliases --alias
gateway_database_user --value knox_user --alias gateway_database_password
--value mypw23 --alias gateway_database_ssl_truststore_password --value mypw22`
```
SQL> select * from KNOX_TOKENS;
TOKEN_ID
--------------------------------------------------------------------------------
ISSUE_TIME EXPIRATION MAX_LIFETIME
--------
Issue Time Tracking
-------------------
Worklog Id: (was: 1021260)
Remaining Estimate: 0h
Time Spent: 10m
> Add SSL configuration for Oracle DB support
> -------------------------------------------
>
> Key: KNOX-3326
> URL: https://issues.apache.org/jira/browse/KNOX-3326
> Project: Apache Knox
> Issue Type: Improvement
> Components: Server
> Affects Versions: 2.1.0
> Reporter: Tamás Hanicz
> Assignee: Tamás Hanicz
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
