Re: I am receiving an error

That did it. Thanks so much.

Lance

From: Dave Cramer <pg(at)fastcrypt(dot)com>
Date: Tuesday, April 23, 2019 at 10:04 AM
To: Lance Campbell <lance(at)illinois(dot)edu>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: I am receiving an error

Hi Lance,

Ya, I think if you use require it should work

https://jdbc.postgresql.org/documentation/head/ssl-client.html<https://urldefense.proofpoint.com/v2/url?u=https-3A__jdbc.postgresql.org_documentation_head_ssl-2Dclient.html&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=Cr97sDNZLOiCYWOQotL42lPT3Xact1eOfIzSS_axVw4&e=>

Dave Cramer

davec(at)postgresintl(dot)com<mailto:davec(at)postgresintl(dot)com>
www.postgresintl.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.postgresintl.com&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=t0Sat4sxL4dc63M44rdrtybBacB4Od3PvbfDmgjk_OQ&e=>

On Tue, 23 Apr 2019 at 10:58, Campbell, Lance <lance(at)illinois(dot)edu<mailto:lance(at)illinois(dot)edu>> wrote:
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<https://urldefense.proofpoint.com/v2/url?u=http-3A__test.cname.illinois.edu&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=4V692vtWZOlwnkMbBqWLoX0U6_GSwuxp6MybltDtXJE&e=> does not match common name aws.postgresql.server.amazonaws.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__aws.postgresql.server.amazonaws.com&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=iOVm1YKH8GWTfVwPPfBA2htgdpBAwTjRP1fzttvvc74&e=>

getConnection()::Exception:

java.sql.SQLException: Cannot create PoolableConnectionFactory (The hostname test.cname.illinois.edu<https://urldefense.proofpoint.com/v2/url?u=http-3A__test.cname.illinois.edu&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=4V692vtWZOlwnkMbBqWLoX0U6_GSwuxp6MybltDtXJE&e=> could not be verified by hostnameverifier PgjdbcHostnameVerifier.)

Thanks,

LANCE CAMPBELL<https://urldefense.proofpoint.com/v2/url?u=https-3A__directory.illinois.edu_person_lance&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=MRXyCKaKDbGixyeV-nfVkDKYJuE30pFeB2RmQ_g3kwE&e=>
Software Architect

Web Services<https://urldefense.proofpoint.com/v2/url?u=https-3A__webtools.illinois.edu_&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=XFEffEcUU3x6dQazA9a42sfT_1Grxml4jcw767XAr6s&e=>
Public Affairs<https://urldefense.proofpoint.com/v2/url?u=https-3A__publicaffairs.illinois.edu_&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=hIMVDIe97v7xvYv6JGV1-UNZq87w8Gc4yrj6TYFel6U&e=>
Contact the Webtools Team<https://urldefense.proofpoint.com/v2/url?u=https-3A__go.illinois.edu_contactUs&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=ZWVeoM-C9t4Ke_lwtHdTYgt5PBbxJheTF0BXvXaLc58&e=>
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]<https://urldefense.proofpoint.com/v2/url?u=http-3A__illinois.edu_&d=DwMFaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=9-aJ4VHsVhqhiumxz1A01wk4g_KrRQr_UuUOYnbs3NI&m=E6DjrUFs8U5mAbaxi8-C0uLPs2muTVNQCRVpD-6ycz0&s=eU4fLt8qtvSVW5bxmIJxYMINhO7WF5nNz9nVI5OiDvU&e=>

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.