Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database connection failed #6

Open
paolosantarsiero opened this issue Feb 13, 2023 · 9 comments
Open

Database connection failed #6

paolosantarsiero opened this issue Feb 13, 2023 · 9 comments

Comments

@paolosantarsiero
Copy link

I tried but when i'm in database install step there is a error on db connection:

An error occurred while trying to update settings: DATABASE_CONNECTION

@gamelaster
Copy link
Owner

What is the configuration? I tested latest image and it works OK for me.

@paolosantarsiero
Copy link
Author

paolosantarsiero commented Feb 13, 2023

The same written in readme! I only changed db user password and switch webserver port to 8080.

@gamelaster
Copy link
Owner

Can you please how me your docker-compose.yml + screenshot of database setup page?

@paolosantarsiero
Copy link
Author

version: '2'
services:
  mariadb:
    image: mariadb
    environment:
     - MYSQL_USER=opensupports
     - MYSQL_PASSWORD=pwdtest
     - MYSQL_DATABASE=opensupports
     - MYSQL_RANDOM_ROOT_PASSWORD=true
    volumes:
     - ./database:/var/lib/mysql

  website:
    image: 'gamelaster/opensupports:latest'
    restart: always
    ports:
      - "8080:80"
    volumes:
     - ./config:/config
    depends_on:
      - mariadb

Schermata del 2023-02-13 16-06-10

@gamelaster
Copy link
Owner

Can you please also put docker-compose logs here? This is really weird, I tested the latest image just week ago and everything worked just fine 😟

@paolosantarsiero
Copy link
Author

There aren't any errors on logs:

mariadb_1  | 2023-02-13 16:18:35 0 [Note] Server socket created on IP: '0.0.0.0'.
mariadb_1  | 2023-02-13 16:18:35 0 [Note] Server socket created on IP: '::'.
mariadb_1  | 2023-02-13 16:18:35 0 [Note] mariadbd: ready for connections.
mariadb_1  | Version: '10.10.3-MariaDB-1:10.10.3+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
website_1  | 172.24.0.1 - - [13/Feb/2023:16:18:46 +0000] "POST /api/system/init-database HTTP/1.1" 200 306 "http://localhost:8080/install/step-3" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36"

@gamelaster
Copy link
Owner

Can you please try this?:

version: '2'
services:
  mariadb:
    image: mariadb
    expose:
     - 3306
    environment:
     - MYSQL_USER=opensupports
     - MYSQL_PASSWORD=pwdtest
     - MYSQL_DATABASE=opensupports
     - MYSQL_RANDOM_ROOT_PASSWORD=true
    volumes:
     - ./database:/var/lib/mysql

  website:
    image: 'gamelaster/opensupports:latest'
    restart: always
    ports:
      - "8080:80"
    volumes:
     - ./config:/config
    depends_on:
      - mariadb

@paolosantarsiero
Copy link
Author

Nothing. Same error

@gamelaster
Copy link
Owner

@paolosantarsiero please, try to delete database and config folder and try again.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants