search

marcinadd / projecty-web

Project management software based on spring
GNU General Public License v3.0
74 stars 74 forks source link

Database Error #58

Closed JBetts97 closed 4 years ago

JBetts97 commented 4 years ago

Hello,

Nice to meet you all, and hope you are well.

I have followed the docker steps to get the development build up and running however I am coming across some issues with the MySQL Database. I successfully signed-up as a user, however when I go to sign-in I get the following error message in my docker terminal window:

image

When I explore mySQL database using the oracle "MySQL Workbench" software, I can't see any issues with the DB setup: image

I am thinking that when I run the docker command "docker-compose up", the database is not found by docker. When I run the docker command with the database already started up, I get this error message: image

Is my docker session, and mySQL database not allowed to be using the same port?

Kindest Regards, Joseph

marcinadd commented 4 years ago

Sorry for late reply. I haven't get any notification about new issue. I will take a look at it tomorrow.

JBetts97 commented 4 years ago

No problem. Thank you.

On Fri, 15 May 2020 at 19:26, Marcin Zasuwa notifications@github.com wrote:

Sorry for late reply. I haven't get any notification about new issue. I will take a look at it tomorrow

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/marcinadd/projecty-web/issues/58#issuecomment-629411049, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJE3TJU2DNVK6VSJKBZQW6TRRWCMZANCNFSM4MY52SPA .

marcinadd commented 4 years ago

Ok issues have been fixed. I will fix tests tomorrow. Here is my comment about your issue: This app uses flyway as a migration tool and contributor who implemented it forgot to add version information to gradle.build. There was probably a major update of flyway and app cannot detect a migration and perform it so there weren't necessary tables for storing OAuth tokens. Now it's also an obsolete solution. It's better to use Keycloak.

Is my docker session, and MySQL database not allowed to be using the same port?

Check docker-compose.yaml file. Database container is bound to 3306 port so you cannot run other application on port 3306 on your pc. Of course, you can change it to for example 3307 and container will be running on 3307 etc.

Thanks for your contribution. Give me back info if the issue has been fixed for you Marcin

JBetts97 commented 4 years ago

Thank you @marcinadd this has resolved my issue, and I am now able to login using the front-end website.

Kindest Regards, Joseph