Cannot connect to database with oryd/hydra:v1.0.0-rc.6_oryOS.10


#1

Earlier we were using oryd/hydra:v1.0.0-beta.8 and we were using postgres db with a special character in the password and it was working fine.

But now we are upgrading to oryd/hydra:v1.0.0-rc.6_oryOS.10 and we are not able to connect to the same database. It is showing net/ userinfo error on db connection but the hydra migration is working


#2

Please provide more context such as configuration, error logs, and so on.


#3

Password was something like this
u}1TOTz-zW

And Error was
Connecting to SQL fail
retrying in 15.0000 seconds
Then at the last we got this error
db url parse error:
net/url: invalid userinfo

But the same password was working with the previous hydra version


#4

Would you mind showing the full DATABASE_URL? Feel free to change things to anonymize them but if it includes special characters please leave them or choose an appropriate substitute.


#5

You can also PM it to me if that’s easier / more confidential for you


#6

We are using somewhat similar password but getting the exact same error.
But this password is working fine with this docker image oryd/hydra:v1.0.0-beta.8 and hydra works well

As described in the image
we are using this image oryd/hydra:v1.0.0-rc.6_oryOS.10
Following scenarios were noted while using the latest image:

  1. Hydra migrate sql is working great
  2. Hydra is not able to connect to database

#7

Could you try and urlencode the username? https://www.urlencoder.org/


#8

We are already using it as urlencode so in docker-compose, Im using the password as this
zu%7D1LTOTz-zW


#9

Any idea ??


#10

Sorry I didn’t have time to look into it but please open an issue in GitHub so we can track this.


#11

I created an issue for this: https://github.com/ory/hydra/issues/1266


#12

Thanks


#13

The issue has been resolved with PR ( https://github.com/ory/hydra/pull/1267 ) and will the fix will be included in the next release. Thank you for the report!