Docker noob question on CAQ

[HutcHJC]

I am completely new to Docker but I definitely would love to work on this issue but I think I'm missing a basic setup piece to all of this.

I can build this as a container with no issue:
docker build -t caq-srvf server-master

But when I try to run it:
docker container run caq-srvr

I get an error about not connecting to 127.0.0.1:6379
I assume I've simply got a configuration setting wrong or not present. If you have any thoughts I'd like to try to get this running.

[raphydaphy]

If you're working on the project in a development environment, you can simply just use the docker-compose file, which automatically sets up the redist server and a basic load balancer:

docker-compose up --build --scale caq-node=2

However, no matter how you run the dockerfile, you also need a local MySQL database. You can set this up however you like - if you're on windows its probably easiest to just install xampp and use the phpmyadmin frontend to create the caq user & database.

Once you've created an empty database, you'll need to run the sql file located under /setup/setup.sql. This creates all the necessary tables, but it won't add any cards - for that, you'll first need to parse the .csv files. While you are still in the setup directory, run python3 parser.py. This should create the generated.sql file. When you run the generated script, the cards tables will be pre-filled with all of the base cards & expansions found on cardsga.me.

Finally, just create a blank file simply titled .env in the root directory of the server, and add the necessary information to connect to your local database.

MYSQL_HOST=localhost
MYSQL_USER=caq
MYSQL_PASS=your_password
MYSQL_DB=caq

Sorry, that's quite a lot of work - I'll look into simplifying the process of setup up a development environment soon. Let me know if you have any problems and I'll gladly help you out.

[HutcHJC]

I'm on Mac but I'll see what I can do. Thanks for responding.
I assumed your process included adding MySQL but I didn't check to verify. I eventually will probably end up running it on my linux server.

I want to say that we were all very impressed with how well the game worked. I expect we'll play again over the coming weeks.

[HutcHJC]

OK - I got MySQL up and running. I was able to populate the tables. (I'm hoping to add non-CAH cards that I've purchased at some point...who knows when.)

However, when I run using the docker-compose command I no longer get the REDIS connection error I get an error connecting to the MySQL DB on localhost:3306. But it's there and listening...is there something with the way it's attempting to connect to MySQL that's causing it to be refused? I setup a user called "cah" and set the host connection limitation to "%" which should indicate from anywhere...so I'm not sure why the connection is being refused in docker to port 3306.

[HutcHJC]

This is error in nginx:
2020/04/29 18:18:27 [emerg] 1#1: host not found in upstream "caq-node" in /etc/nginx/nginx.conf:13
nginx: [emerg] host not found in upstream "caq-node" in /etc/nginx/nginx.conf:13

Does this mean I need to add some entries to my hosts file?

[HutcHJC]

I tried setting up a MySQL Docker (successfully, was able to populate Docker-ized MySQL DB same as I was local MySQL DB. But in either case I get connection refused to DB.

Maybe it's the DB.JS file?
/build/db.js:19
throw err;
^

Error: connect ECONNREFUSED 127.0.0.1:3306

But I don't know how to look at that file if the container won't stay running

[raphydaphy]

If you're using docker to run the mysql db, it needs to be on the same virtual network as everything else - check the docker-compose file. Also, just try connecting the the db using mysql workbench to make sure it actually works.

[HutcHJC]

Again, thanks for responding.

Running MySQL on my Mac works fine with Workbench. Running MySQL in Docker works find with Workbench.

What's interesting is the default Docker network is 192.168.65.0/28 (my home network is not a 192.168 network). But, it doesn't seem to matter whether I change it to a 10.x range that is within my home network.

So, I am not sure why Docker cannot access MySQL (whether local or Docker) esp. given when I have a single network for Docker. I'll recheck my .env file to ensure userID and PW are what I setup. But, I think the error wouldn't be connection refused so I think I'm still facing a networking issue.