Using SSL with oracle


#1

how to setup SSL with re-dash connecting to oracle.

we are testing oracle secure connection (SSL) but its failing with error ORA-12547 with TCPS port 2484

in the connection page also there is no option to provide the tns alias directly rather than the port/service detail which might be constructing the string on run.


#2

got workaround of this by modifying oracle.py to use tnsnmaes.ora

self.connection_string = “{}/{}@{}”.format(self.configuration[“user”], self.configuration[“password”],self.configuration[“servicename”] )

and commenting out host/port input

def configuration_schema(cls):
    return {
        "type": "object",
        "properties": {
            "user": {
                "type": "string"
            },
            "password": {
                "type": "string"
            },
            "servicename": {
                "type": "string",
                "title": "DSN Service Name"
            }
        },
        "required": ["servicename", "user", "password"],
        "secret": ["password"]
    }