Sweet! What was the solution (in case anyone else searches for it)?
On Wed, Jun 9, 2021 at 12:49 PM Rick Bonnett <richard.bonn...@ascentgl.com> wrote: > Thanks. That got me on the path to success > > *Rick Bonnett* > > *Programmer Analyst* > > Ascent Global Logistics > > PO Box 1039, Augusta, ME, 04332 > > Office: 207.620.8670 > > *ascentgl.com* <http://ascentgl.com/> > > > > > ------------------------------ > *From:* Michael Gentry <blackn...@gmail.com> > *Sent:* Wednesday, June 9, 2021 12:26 PM > *To:* Cayenne Users <user@cayenne.apache.org> > *Subject:* Re: SSL connections to postgresql in Azure > > > *EXTERNAL EMAIL:* Be extra careful around links and attachments. > Hi Rick, > > Are you connecting: > > a) local development system -> Azure Postgres > b) Azure server -> Azure Postgres? > > If "a", are there SSL certificates from Azure you need to load into your > local Java environment. Or you could try turning off SSL verification. See > more (for both options) here: > > https://jdbc.postgresql.org/documentation/head/ssl-client.html > > Also, maybe try adding: > > .put("ssl", "true"); // Or some other combo from above link... > > > On Wed, Jun 9, 2021 at 10:59 AM Rick Bonnett <richard.bonn...@ascentgl.com > > > wrote: > > > > > Having issues connecting to postgres in Azure - because by default SSL > > connections are required. I am using: > > > > - cayenne 3.1 - yes I know it's old but it's what I'm stuck with > > - latest postgres JDBC driver > > > > Code snippets below. > > > > On the JDBC_URLPROPERTY I have tried every flavor of ssslmode=required or > > usessl=true that I've been able to dredge up, but consistenyly getting: > > > > Unable to connect to server: FATAL: SSL connection is required. Please > > specify SSL options and retry. > > > > Hopefully I am just overlooking something simple and obvious. Any > insights? > > > > Module m1 = new Module() { > > public void configure(Binder binder) { > > > binder.bindMap(Constants.PROPERTIES_MAP).put(Constants.JDBC_DRIVER_PROPERTY, > > "org.postgresql.Driver") > > .put(Constants.JDBC_URL_PROPERTY, "jdbc:postgresql:// > > http://mypostgres.postgres.database.azure.com:5432/are";) > > .put(Constants.JDBC_USERNAME_PROPERTY, "<username>") > > .put(Constants.JDBC_PASSWORD_PROPERTY, "<password>"); > > } > > }; > > > > cayenneRuntime = new ServerRuntime("cayenne-ARETariffDomain.xml", m1); > > DataDomain dd = cayenneRuntime.getDataDomain(); > > Collection<DataMap> dmaps = dd.getDataMaps(); > > for (DataMap dm: dmaps) { > > for (DbEntity entity: dm.getDbEntities()) { > > entity.setSchema("p"); > > } > > } > > ObjectContext ORMContext = cayenneRuntime.getContext(); > > > > > > > > *Rick Bonnett* > > > > *Programmer Analyst* > > > > Ascent Global Logistics > > > > PO Box 1039, Augusta, ME, 04332 > > > > Office: 207.620.8670 > > > > *ascentgl.com* <http://ascentgl.com/> > > > > > > > > > > The information transmitted is intended only for the person or entity to > > which it is addressed and may contain proprietary, business-confidential > > and/or privileged material. If you are not the intended recipient of this > > message you are hereby notified that any use, review, retransmission, > > dissemination, distribution, reproduction or any action taken in reliance > > upon this message is prohibited. If you received this in error, please > > contact the sender and delete the material from any computer. > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain proprietary, business-confidential > and/or privileged material. If you are not the intended recipient of this > message you are hereby notified that any use, review, retransmission, > dissemination, distribution, reproduction or any action taken in reliance > upon this message is prohibited. If you received this in error, please > contact the sender and delete the material from any computer. >
