title: Error when connecting to redshift: "server certificate does not match host name"
body: <p>After trying to run a query on redshift, I get the following error message:</p>
  
  <blockquote>
    <p>OperationalError: (psycopg2.OperationalError) server certificate for
    "" does not match host name "".</p>
  </blockquote>
  
  <p>I already installed the sqlalchemy-redshift package, as well as the Psycopg2 package. My code:</p>
  
  <pre><code>from sqlalchemy import create_engine
  
  def run_query(query, connection_string):
  
   red_engine = create_engine(connection_string)
   data_set = pd.read_sql_query(query, red_engine)
  
   return data_set
  </code></pre>
  
  <p>The exact same code does work on another computer, so we are sure that the login name, password and queries are correct, and the problem is specific to my computer. Any suggestions?</p>