cannot setup, DB connection issue

[hadifarnoud]

I followed the instructions but I get

2024-05-21 14:26:56 2024-05-21 10:56:56 121 [Warning] Access denied for user 'admin'@'172.28.0.3' (using password: YES)

on db container. and get this error on akaunting container:

2024-05-21 14:27:49 Connecting to database akaunting@akaunting-db:3306
2024-05-21 14:27:49 Error: Could not connect to the database! Please, make sure the details are correct.

[adomigold]

Hello @hadifarnoud i had similar problem and i decided to remove akaunting-db from docker-compose and instead to use external db by configuring on run.env

[runlevel-4]

@hadifarnoud So what I ended up doing was similar with an external mariadb database (thanks @adomigold for the idea :) ), but I just defined my db connections within the docker-compose.yml file and commented out the references to the env files altogether. So edit your docker-compose.yml to resemble something like the below code.

Make sure you have the database, user, password, and privileges done in your mariadb/mysql system and they match what is in the docker-compose.yml file.

Then run AKAUNTING_SETUP=true docker-compose up -d. You should be able to hit it from your browser on port 8080.

version: '3.7'

services:

akaunting:
container_name: akaunting
image: docker.io/akaunting/akaunting:latest
build:
context: .
ports:
- 8080:80
volumes:
- akaunting-data:/var/www/html
restart: unless-stopped
env_file: comment this out
- env/run.env comment this out
environment:
- AKAUNTING_SETUP comment this out
DATABASE_HOST: localhost
DATABASE_PORT: 3306
DATABASE_NAME: akaunting
DATABASE_USER: akaunting
DATABASE_PASSWORD: password
depends_on:
- akaunting-db

akaunting-db:
container_name: akaunting-db
image: mariadb
volumes:
- akaunting-db:/var/lib/mysql
restart: unless-stopped
environment:
MYSQL_DATABASE: akaunting
MYSQL_USER: akaunting
MYSQL_PASSWORD: password
env_file: comment this out
- env/db.env comment this out

volumes:
akaunting-data:
akaunting-db: