Unable to deploy Rails app to Heroku Postgres DB using Rubymine

Question

I am using Rubymine to connect to an Heroku hosted Postgres DB.

I was able to connect a few weeks ago, but now I am getting this error whenever I try to connect:

'The specified user/password combination is rejected: FATAL: password authentication failed for user "X3v...'

My Heroku DB URL is:

postgres://<password>:X3vuEswiMHjkADaeI5RQvY4WI4@ec2-23-21-170-57.compute-1.amazonaws.com:5432/de8u1hq5ipli85

I am using JDBC to connect. In the "Data Source Properties" dialog box the (partial) URL is:

jdbc:postgresql://ec2-23-21-170-57.compute-1.amazonaws.com:5432/

And I have added my username and password to the User and Password fields.

In the advanced tab I have added

ssl = true
sslfactory = org.postgresql.ssl.NonValidatingFactory

I'm not sure what I have missed.

Gustavo Morales · Accepted Answer · 2016-04-29 12:44:45Z

1

I understand this is not a solution, but it's works for me:

I guess, but not sure, system uses same driver for the various editors (Idea, DataGrip, pgadmin3). It's setting a bottleneck.

If you have better solution, please write it here.

Gustavo Morales

2,6709 gold badges34 silver badges40 bronze badges

answered Apr 29, 2016 at 12:16

5466 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bohdan Mart · Accepted Answer · 2016-06-20 15:43:49Z

0

I'm not sure if this is still relevant, but you misinterpreted URL

In URL schema first gous user, then password <protocol>://[<user>[:<password]@]<host>[:<port>]/... so you mixed username with password

answered Jun 20, 2016 at 15:43

Bohdan Mart

5069 silver badges23 bronze badges