SQLSTATE[HY000] [2002] No such file or directory about docker-flarum HOT 30 CLOSED

Switch DEBUG environment variable to true to see the error message (after something went wrong).

from docker-flarum.

I found this: SQLSTATE[HY000] [2002] No such file or directory
May this be the problem?

from docker-flarum.

May this be the problem?

Yes. Your database seems to not be in a good state. Your have a connect error using PDO. Try to recreate your database container and rename your volume :

docker-compose stop mariadb
docker-compose rm mariadb
mv /mnt/docker/mysql /mnt/docker/mysql.bak
docker-compose up -d

Can you give me your docker-compose.yml file content and MariaDB logs ?

from docker-flarum.

 ⚡ root@bjorn  ~/docker-flarum  cat docker-compose.yml
flarum:
  image: mondedie/docker-flarum:0.1.0-beta.7.1-stable
  container_name: flarum
  links:
    - mariadb:mariadb
  ports:
    - "8888:8888"
  environment:
    - FORUM_URL=https://forum.domain.tld
    - DB_PASS=flarum
    - UID=nginx
    - GID=nginx
    - DEBUG=true
  volumes:
    - /mnt/docker/flarum/assets:/flarum/app/assets
    - /mnt/docker/flarum/extensions:/flarum/app/extensions

mariadb:
  image: mariadb:10.1
  container_name: mariadb
  volumes:
    - /mnt/docker/mysql/db:/var/lib/mysql
  environment:
    - MYSQL_ROOT_PASSWORD=flarum
    - MYSQL_DATABASE=flarum
    - MYSQL_USER=flarum
    - MYSQL_PASSWORD=flarum

from docker-flarum.

MariaDB logs: https://pastebin.com/JMB29wAy

from docker-flarum.

I can't reproduce your error with a fresh install. Any idea @Hydrog3n @Magicalex ?

Does your database works with another service ?

from docker-flarum.

Can I use it without traefik?

EDIT: I don't use this database for anything other than Flarum.

from docker-flarum.

Yes of course.

from docker-flarum.

Maybe @TimonPeng issue is related : #9 (comment)

This is very strange. Try to access your database with another container like Adminer. And test a connection with flarum user.

from docker-flarum.

Are you sure about your MariaDB hostname ?

With your docker-compose : MYSQL Host = mariadb

from docker-flarum.

I reproduced your error with a bad hostname :

from docker-flarum.

So if I change "localhost" to "mariadb" this error shouldn't appear?

from docker-flarum.

Yes, best way is to try

from docker-flarum.

Apparently it actually finishes installation, but then home page is broken and it says Something went wrong while trying to load the full version of the site...

from docker-flarum.

Clean your browser cache.

from docker-flarum.

Tried cleaning cache, cookies or entirely different browser, nothing worked

from docker-flarum.

Reinstall flarum and retry.

docker-compose stop flarum && docker-compose stop mariadb
docker-compose rm flarum && docker-compose rm mariadb
rm -rf /mnt/docker/flarum
rm -rf /mnt/docker/mysql
docker-compose up -d

Nothing wrong in logs (docker logs, php logs, nginx logs, browser logs) ? Do you have any files in /mnt/docker/flarum/assets ?

from docker-flarum.

Reinstalling didn't help.
Flarum logs are still empty although debug env is set to true.
Nginx logs: something about favicon missing.
PHP logs are the same as before.
Files in /mnt/docker/flarum/assets:

drwxr-xr-x 2 libuuid libuuid   4096 Feb  1 18:47 fonts
-rw-r--r-- 1 libuuid libuuid 875633 Feb  1 18:47 forum-9cb81cf1.js
-rw-r--r-- 1 libuuid libuuid  17928 Feb  1 18:47 forum-en-deb59aba.js
-rw-r--r-- 1 libuuid libuuid 115069 Feb  1 18:47 forum-f07d00f5.css
-rw-r--r-- 1 libuuid libuuid     71 Feb  1 18:47 rev-manifest.json

EDIT: should it be libuuid?

from docker-flarum.

docker exec flarum ls -la /flarum/app/assets
id -nu libuuid

Both commands should return the same uid.

from docker-flarum.

It returns libuuid on host and nginx in container.

from docker-flarum.

Ok, it's good. Ask to flarum dev how to find the cause. I have no idea why you have this error.

from docker-flarum.

https://discuss.flarum.org/d/2061-something-went-wrong-while-trying-to-load-the-full-version-of-this-site
https://discuss.flarum.org/d/4229-something-went-wrong-while-trying-to-load-the-full-version-of-this-site
https://discuss.flarum.org/d/6406-something-went-wrong-while-trying-to-load-the-full-version-of-this-site
https://discuss.flarum.org/d/7525-something-went-wrong-while-trying-to-load-the-full-version-of-this-site

from docker-flarum.

Ok, thanks

from docker-flarum.

Try this maybe :

docker exec -ti flarum php /flarum/app/flarum cache:clear

Do you have any error in your browser logs ?

from docker-flarum.

After recreating containers without removing any files it works, but... now logging in returns 403 in debug logs.

from docker-flarum.

What debug logs ?

from docker-flarum.

In login box I have "DEBUG" button, after clicking it reveals generic 403 html page

from docker-flarum.

JS console, container and nginx logs seem empty

from docker-flarum.

In login box I have "DEBUG" button, after clicking it reveals generic 403 html page

You used probably a wrong account or password.

POST http://flarum.local/login

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
</head>
<body>

<h1>403 Forbidden</h1>
<p>You do not have permissions to access this page.</p>

</body>
</html>

from docker-flarum.

I had a typo in my password and thought it was a server error...
Thanks, everything works now.

from docker-flarum.