search

rundeck / docker-zoo

196 stars 82 forks source link

Missing option in RUNDECK_DATABASE_URL? #7

Closed NFDWADM closed 2 years ago

NFDWADM commented 5 years ago

I am using docker-compose to start a rundeck container (self made but based on the offical one) and a mysql container.

rundeck fails with 

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.,
[...]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed,

In docker-compose.yaml I had to change RUNDECK_DATABASE_URL to this to make it work:

RUNDECK_DATABASE_URL: jdbc:mysql://mysql/rundeck?autoReconnect=true&useSSL=false&allowPublicKeyRetrieval=true

Note the addition of &allowPublicKeyRetrieval=true

Should this be added to the official docker-compose.yaml or did I make a mistake somehwere else?

Host: Red Hat 7.4

fdevans commented 2 years ago

I think this depends on the version of MySQL. As of version 8 this string was needed. Good catch, thanks.