Re: Connection over SSH tunnel without password not working

Hi Rafael,

Wouldn't you still need to provide the credentials?  Your SSH tunnel is
forwarding the bits to/from PostgreSQL, but your connection still needs to
login to the database.

Does Cayenne Modeler or IntelliJ have the password cached somewhere?


On Mon, Sep 2, 2019 at 1:34 AM Rafael Bugajewski <[email protected]>
wrote:

> Hello,
>
> I recently upgraded to Cayenne 4.1.B2 and I have the strange issue that my
> cayenne-project.xml isn’t working anymore. In my development environment I
> create a SSH tunnel to a machine inside the intranet. JDBC is configured to
> connect to localhost. The relevant parts from cayenne-project.xml in the
> JAR look like this:
>
> <data-source>
>    <driver value="org.postgresql.Driver"/>
>    <url value="jdbc:postgresql://localhost:5432/www2"/>
>    <connectionPool min="1" max="1"/>
>    <login userName="www2"/>
> </data-source>
>
> This used to work without issues. The strange thing is that exactly the
> same connection still works in the Cayenne Modeler, and it also works in my
> IDE (IntelliJ).
>
> A workaround for me was to add a password and configure it in Cayenne. But
> I’m wondering why the configuration suddenly stopped working and why it
> still works in Cayenne Modeler / IntelliJ. Any ideas?
>
> Best,
> Rafael
>
>