SQLAlchemy connection via proxy

Asked Feb 12 '18 at 13:51

Active Nov 29 '20 at 17:01

Viewed 1,663 times

I need to connect to existing database from SQLAlchemy via proxy.

        self.DB = {
            'drivername': 'oracle',
            'host': url,
            'port': port,
            'username': username,
            'password': password,
            'database': dbname
        }
        _engine = create_engine(URL(**self.DB))

        self.connection = _engine.connect()

I'm getting:

cx_Oracle.DatabaseError: ORA-12170: TNS:Connect timeout occurred

And I'm pretty sure I just need proxy because of my company policy. I couldn't find any tips in documentation how can I create connection via proxy.

edited Nov 29 '20 at 17:01

a121

asked Feb 12 '18 at 13:51

Dawid Fieluba

1,241
11
32

1

I'm not a Oracle expert, so I am not familiar with proxying db connections. How do you connect to the database from another tool, for instance the sqlplus command line tool? – codeape Aug 11 '18 at 15:50
For instance - SQL Developer. – Dawid Fieluba Aug 11 '18 at 23:46
Ok. How do you specify the connection info in sql developer? – codeape Aug 13 '18 at 06:29
Are you able to connect using another tool? – codeape Aug 13 '18 at 15:41
@codeape I'm not longer able to reproduce this error as our servers infrastracture was changed and proxy is no longer needed. The think is that with SQL Developer or some other tool I can specify proxy if it's needed. – Dawid Fieluba Aug 13 '18 at 16:37

SQLAlchemy connection via proxy

0 Answers0