Akaunting and portainer?
reddit / selfhosted

----------------------------------------------------------------------
DarkKnyt · 2023-12-03 15:46

I tried akaunting and erpnext before just installing frappe books on
my windows VM. But I still think I want a web accessible solution.

Thing is even when I clone to git repo and edited the environment
files it just didn't work. While I think ERP next is just way too much
for me I'd like to give akaunting a fair shake. I'd like to
combine/import the environment files and try a portainer stack has
anyone had recent success with the docker solution?

Similar to what another person asked for, I mostly need tracking
expenses and income for tax purposes, capital depreciation would be
nice.

----------------------------------------------------------------------
Stryker1-1 · 2023-12-03 18:08

What exactly won't work?

----------------------------------------------------------------------
DarkKnyt · 2023-12-03 20:02

With the git install it's likely user error. I just assumed that it
would build the web server dependency.... Silly me.

But I'd prefer docker and not sure what went wrong there. I'm trying
to make a single docker-compose and environment file now and seeing if
it works on portainer. I got to the login screen but my credential
didn't work.

I'll keep at it but I'm having more success this day - nothing good
happens after 22,00!

----------------------------------------------------------------------
DarkKnyt · 2023-12-03 21:24

Ok, definitely user error. But there was a bug introduced in 3.1.4
that kills navigation - will need 3.1.5 to check it out.

For others going the portainer route, here is the relevant setup. On
first run, set the akaunting_setup variable to true. Also, if https
and you haven't set it up correctly it won't load con:

```
version: '3.7'

services:

  akaunting:
    container_name: akaunting
    image: docker.io/akaunting/akaunting:latest
    build:
      context: .
    ports:
      - 1111:80
    volumes:
      - akaunting-data:/var/www/html
    restart: unless-stopped
    env_file:
      - stack.env
    environment:
      - AKAUNTING_SETUP
    depends_on:
      - akaunting-db

  akaunting-db:
    container_name: akaunting-db
    image: mariadb
    volumes:
      - akaunting-db:/var/lib/mysql
    restart: unless-stopped
    env_file:
      - stack.env

volumes:
  akaunting-data:
  akaunting-db:
```

```
APP_URL=http://192.168.8.XXX:1111
LOCALE=en-US
DB_HOST=akaunting-db
DB_PORT=3306
DB_NAME=akaunting
DB_USERNAME=admin
DB_PASSWORD=akaunting
DB_PREFIX=lkw_
COMPANY_NAME=Xxxxxx
COMPANY_EMAIL=Xxxxxx
ADMIN_EMAIL=Xxxxxx
ADMIN_PASSWORD=akaunting
MYSQL_DATABASE=akaunting
MYSQL_USER=admin
MYSQL_PASSWORD=akaunting
MYSQL_RANDOM_ROOT_PASSWORD=yes
AKAUNTING_SETUP=false
```