I am receiving an error

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: I am receiving an error
Date: 2019-04-23 14:57:49
Message-ID: F527F0F6-BDB0-4154-A460-D998E2EAD3A2@illinois.edu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Postgresql-42.2.5.jar

I have AWS RDS PostgreSQL servers set up. I have C-Names that point to the AWS server names. Why?
1) My C-names are easy to remember the AWS RDS names are not.
2) If some issue comes up I can very quickly change the target database by simply changing the C-name record to point to a different database name.

After moving to the above JAR file I get the below error. Is there a parameter I can add to tell the JDBC drive to ignore the validation that is comparing my C-Name to the AWS RDS host name?

23-Apr-2019 09:20:47.152 SEVERE [ajp-nio-8019-exec-1] org.postgresql.ssl.PGjdbcHostnameVerifier.verify Server name validation failed: hostname test.cname.illinois.edu does not match common name aws.postgresql.server.amazonaws.com

getConnection()::Exception:

java.sql.SQLException: Cannot create PoolableConnectionFactory (The hostname test.cname.illinois.edu could not be verified by hostnameverifier PgjdbcHostnameVerifier.)

Thanks,

LANCE CAMPBELL<https://directory.illinois.edu/person/lance>
Software Architect

Web Services<https://webtools.illinois.edu/>
Public Affairs<https://publicaffairs.illinois.edu/>
Contact the Webtools Team<https://go.illinois.edu/contactUs>
217.333.0382
lance(at)illinois(dot)edu<mailto:lance(at)illinois(dot)edu>

[/var/folders/wp/1f6l7hw95y718z976kgnl5f9kr5rtc/T/com.microsoft.Outlook/WebArchiveCopyPasteTempFiles/signature_logo.png]<http://illinois.edu/>

Under the Illinois Freedom of Information Act any written communication to or from university employees regarding university business is a public record and may be subject to public disclosure.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2019-04-23 15:03:47 Re: I am receiving an error
Previous Message Kamal Kumlien 2019-04-19 20:29:45 [pgjdbc/pgjdbc] d0453b: docs: cosmetic fixes on sample settings (#1379)