PyCharm: SSH Auth Fail when connecting to vagrant Postgres DB

Question

I'm developing a Django project in Pycharm 4.5.3, and I can't seem to connect to my Postgres DB on the vagrant instance for the project. Pycharm is able to successfully connect to the box to run the remote interpreter for the project, and I can vagrant ssh just fine, but every time I try to add the Postgres data source under the 'Databases' tab I get the following error:

Connection to PostgreSQL - dbname@localhost failed: SSH: Auth fail

I'm using the following settings:

Database Tab:
    Host: localhost
    Port: 5432
    Database: dbname
    User: vagrant
    Password: <blank> (no password for this DB user)
    URL (autofilled): jdbc:postgresql://localhost:5432/dbname

SSH/SSL Tab:
    Proxy host: localhost
    Port: 2222
    Proxy User: vagrant

Interestingly enough, when I try to use password auth in the SSH/SSL tab with the default password 'vagrant', I get a popup that tells me the password is incorrect, which I know to not be true. Anyone know what the issue might be?

What's the username/rolename for the database? – Burhan Khalid Aug 31 '15 at 05:08 — Burhan Khalid, Aug 31 '15 at 05:08
@BurhanKhalid The username for the database is vagrant – xjtian Aug 31 '15 at 23:13 — xjtian, Aug 31 '15 at 23:13

score 7 · Answer 1 · edited May 23 '17 at 11:54

7

You got almost everything right. The issue is that you are not able to login to the VM via ssh due to authentication failure as the error message states. I only managed to connect changing the auth method.

In order to do so, you must select Key pair authentication type and use vagrant's private key, which is located in <vagrant root>/.vagrant/machines/default/virtualbox/private_key.

This is what my dialog looks like (I replaced my actual path with <my vagrant root>) :

The key at ~/.vagrant.d/insecure_private_key won't work.

This answer helped me to connect with Pycharm, even though the author print screen displays a password based authentication.

edited May 23 '17 at 11:54

Community

1
1

answered Dec 08 '15 at 20:14

alfetopito

1,453
2
18
27

How do you access to this popup? – David Dahan Jun 14 '16 at 10:11
@DavidD. View > Tool Windows > Database, add a new data source – alfetopito Jun 17 '16 at 15:08
My vagrant root does not contain the private_key file. Instead on Windows 10 it was at: C:\Users\\.vagrant.d\boxes\r\0.0.0\virtualbox\vagrant_private_key. Unfortunately, I still cannot successfully connect. – PeterVermont Dec 20 '16 at 15:15

PyCharm: SSH Auth Fail when connecting to vagrant Postgres DB

1 Answers1