title: Connect to Remote Firebird DB from AWS Glue
body: <p><strong>Attempt 1: AWS Glue</strong>
  In AWS Glue, we are trying to run an ETL job against a remote Firebird DB.
  We start by: AWS Glue &gt; Databases &gt; Connections &gt; &quot;New Connection&quot;</p>
  <ol>
  <li>Connection Type: JDBC</li>
  <li>jdbc:firebirdsql://xxx.xxx.xxx.xxx:3050/C:\program files (x86)\folder\database\dbname.FDB</li>
  <li>We chose a VPC, Subnet and Security Group.
  Completed.</li>
  </ol>
  <p>When we &quot;TEST Connection&quot;, I get Error, check logs. When go to check logs, nothing exists. (although access to write logs exsits)</p>
  <p>I'm essentially looking for the correct steps to connect Firebird as a datasource for ETL in AWS Glue or AWS Glue DataBrew.</p>
  <p><a href="https://i.stack.imgur.com/fll7p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fll7p.png" alt="enter image description here" /></a></p>
  <p><strong>Attempt 2:</strong>
  I also tried using Python locally:
  conn = firebirdsql.connect() which gives us a No connection could be made because target mahcine actively refused it (When firewall was off)</p>
  <pre><code>&gt;&gt;&gt; conn = firebirdsql.connect(
  ...     host='108.xxx.xxx.xxx', 
  ...     database=&quot;c:/program files (x86)/folder1/database/datab.fdb&quot;,
  ...     user='sysdba',
  ...     password='masterkey',
  ...     timeout=50
  ... )
  Traceback (most recent call last):
    File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;
    File &quot;C:\Users\Scripts\lib\site-packages\firebirdsql\__init__.py&quot;, 
  line 95, in connect
  conn = Connection(**kwargs)
    File &quot;C:\Users\Scripts\lib\site-packages\firebirdsql\fbcore.py&quot;, line 
  641, in __init__
      self.sock = SocketStream(self.hostname, self.port, self.timeout, 
  cloexec)
    File &quot;C:\Users\Scripts\lib\site-packages\firebirdsql\socketstream.py&quot;, 
  line 46, in __init__
      self._sock = socket.create_connection((host, port), timeout)
    File &quot;C:\Program Files\Python39\lib\socket.py&quot;, line 844, in 
  create_connection
      raise err
    File &quot;C:\Program Files\Python39\lib\socket.py&quot;, line 832, in 
  create_connection
      sock.connect(sa)
  ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it
  </code></pre>