EOC Connection [Guide]

[Korpusftw]

I'm in the same boat. Create user failed. So I ran some queries on the db and I did find that the user existed. So I moved on and ran the grants. But it still fails to connect.

I'm trying to connect to the db on my cloud server. I made sure to open the necessary port.

I also tried installing EOC on my PC. I cloned the repo, created a .env file. But docker-compose up is failing to bring up any containers. Build fails with

failed to solve with frontend dockerfile.v0: failed to create LLB definition: docker.io/laradock/workspace:2.2-5.5: not found
Service 'workspace' failed to build : Build failed

I grabbed a recent peq dump, so I can find most of what I am looking for, but it's a pain. I would love to use EOC.

I created a custom db name, db user, and db password.

[Hurb]

I'm having the same issue with EOC 2.0 from Chrome Browser, with popup blocker off

http://eoc.akkadius.com/EOC2/login.php

I checked settings and ports in mysql and command line interface:

sudo netstat -plnt

- tcp 0 LOCAL 0 127.0.0.1:3306 FOREIGN 0.0.0.0:* LISTEN 626/mysqld

MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.001 sec)

Create your Database User
To create your database user you will need to run the query below to create your database user:
This will allow connections only from EOC via the specified user below, you shouldn't need to change the password because you are only allowing from the EOC server
CREATE USER 'eoc_database_user'@'192.99.119.164' IDENTIFIED BY 'eoc_database_password';
GRANT GRANT OPTION ON *.* TO 'eoc_database_user'@'192.99.119.164';
GRANT ALL ON *.* TO 'eoc_database_user'@'192.99.119.164';

MariaDB [(none)]> SELECT user,host FROM mysql.user;
+-------------------+----------------+
| user | host |
+-------------------+----------------+
| eoc_database_user | 192.99.119.164
| <other user> | 192.99.119.164
| xxxx | localhost

i know my external IP (amazon web services host)

i know my Database name in MariaDB (not peq and i tried that anyway just in case, my db is named differently...)

the 3306 port should be open and ready

i tried username/password combos in case i was misunderstanding but none of my users/pw work

i know im doing something wrong or missing something, maybe its even the browser.. ill post if i find my mistake