Unable to establish TCPS connections on Port 2484 with remote Oracle Server

[kedarpethe37]

Steps to reproduce

Please refer https://github.com/rsim/oracle-enhanced/tree/master/guides/bug_report_templates
to create an executable test case

Expected behavior

We are using below configuration in our FluentD 5.0.3 configuration on client side and expecting below connection to successfully establish secure connection to TCPS port configured on 2484 on Oracle Server side.

<match MIOLogMessageContents>
	@type sql
	host OracleServer
	**database "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=OracleServer.swqa.tst)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=orclpdb)))"**
	adapter oracle_enhanced
	username "#{require('C:\opt\fluent\etc\fluent\mycredential'); MyCredential.decrypt(:user)}"
	password "#{MyCredential.decrypt(:pass)}"
	<table>
		table mio_logmessagecontents
	    column_mapping 'messageid,timestamputc,contentshash,contents,series'
	</table>
    <buffer>
        total_limit_size 1024MB
        chunk_limit_size 16MB
        flush_mode interval
        flush_interval 20s  
        flush_thread_count 2  
    </buffer>
</match>

Actual behavior

• Connection is never established by the client to the port 2484 on Oracle server using above connection string.
• We also tried putting the above connection string in tnsnames.ora file on our client side
• It is always established with non-secure TCP protocol port 1521 even if we have not specified 1521 anywhere in our FluentD configuration file. This was confirmed through Wireshark also.
• I can see protocol=TCP hardcoded everywhere in this repository. We have accepted dynamic connection string but hardcoded Protocol=TCP over there.

System configuration

Rails version: Not installed.

Oracle enhanced adapter version: 6.1.6

Ruby version: ruby 3.2.3 (2024-01-18 revision 52bb2ac0a6)

Oracle Database version: 19C

[andynu]

Thanks for the report. I think there might be a mix-up here about what oracle-enhanced does. This gem is for connecting Rails apps to Oracle databases, specifically via ActiveRecord.

From what I can see, your issue looks more like it's about Fluentd setup and its SQL plugin. That's not something handled in this repo. You'd probably have better luck checking Fluentd's GitHub or asking in their support forums.

If you are using Rails and having trouble with oracle-enhanced, you're in the right place. But if it's just about Fluentd, this isn't the repo for that. Cheers.