[Support] Akaunting

blue8lucian · January 6, 2023

This is one of the most difficult aps, hard to troubleshoot. Yesterday I've made it work for 10 minute, then it's said is an update, I've updated the docker container, now I can't login! I've deleted the docker reinstalled, use the php artisan command, password is not valid, looked in the user part of the database, used the password stored there and surprise "wrong password".

The docker image, get's an update every 2 days, why this often? Is quite bad, the app is good, don't want the cloud app, I want it on my on server for more privacy. Any ideas how to fix it?

TekDRu · January 9, 2023

On 1/6/2023 at 5:55 AM, blue8lucian said:

This is one of the most difficult aps, hard to troubleshoot. Yesterday I've made it work for 10 minute, then it's said is an update, I've updated the docker container, now I can't login! I've deleted the docker reinstalled, use the php artisan command, password is not valid, looked in the user part of the database, used the password stored there and surprise "wrong password".

The docker image, get's an update every 2 days, why this often? Is quite bad, the app is good, don't want the cloud app, I want it on my on server for more privacy. Any ideas how to fix it?

Yeah. It's best to turn off auto updates, and don't apply any updates for now. I realize that it breaks after each update.

blue8lucian · January 12, 2023

Hello community ! I came back whit another problem! Used the php command

php artisan install --db-host="mariadb" --db-port="3306" --db-name="akaunting" --db-username="akaunting" --db-password="p)DyZk-nDSedNN3n" --db-prefix="ld" --company-name="LD" --company-email="[email protected]" --admin-email="[email protected]" --admin-password="#2*Szo#7WYEv&2mA&7!U3#Q^QJvsk$y2$H7#uQv2" --locale="US_EN"

and I can't login "These credentials do not match our records."

I've tried to change the password in the user table in the database same problem afther!

TekDRu · February 7, 2023

On 1/12/2023 at 2:39 AM, blue8lucian said:

Hello community ! I came back whit another problem! Used the php command

php artisan install --db-host="mariadb" --db-port="3306" --db-name="akaunting" --db-username="akaunting" --db-password="p)DyZk-nDSedNN3n" --db-prefix="ld" --company-name="LD" --company-email="[email protected]" --admin-email="[email protected]" --admin-password="#2*Szo#7WYEv&2mA&7!U3#Q^QJvsk$y2$H7#uQv2" --locale="US_EN"

and I can't login "These credentials do not match our records."

I've tried to change the password in the user table in the database same problem afther!

@blue8lucian Does the email and the password that you used in the php command match what you have in your container settings?

97WaterPolo · February 23, 2023

On 9/29/2022 at 11:38 AM, TekDRu said:

Is there anyone that has this app working? After initial install and setup 2 weeks ago, the app was working fine. But recently I've been trying to login and I can't get passed the login screen. It just hangs after entering login info. I do not see any errors in logs and don't know where to go from here. Any help is appreciated.

This is the apps log:

AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.2. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.2. Set the 'ServerName' directive globally to suppress this message
[Wed Sep 28 21:21:22.597968 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.54 (Debian) PHP/8.1.10 configured -- resuming normal operations
[Wed Sep 28 21:21:22.597988 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
[Wed Sep 28 21:22:25.014405 2022] [mpm_prefork:notice] [pid 1] AH00170: caught SIGWINCH, shutting down gracefully
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.2. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.2. Set the 'ServerName' directive globally to suppress this message
[Thu Sep 29 13:55:59.399673 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.54 (Debian) PHP/8.1.10 configured -- resuming normal operations
[Thu Sep 29 13:55:59.399692 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
[Thu Sep 29 13:58:56.208050 2022] [mpm_prefork:notice] [pid 1] AH00169: caught SIGTERM, shutting down
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.2. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.2. Set the 'ServerName' directive globally to suppress this message
[Thu Sep 29 14:00:01.473216 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.54 (Debian) PHP/8.1.10 configured -- resuming normal operations
[Thu Sep 29 14:00:01.473236 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
[Thu Sep 29 14:01:51.570443 2022] [mpm_prefork:notice] [pid 1] AH00170: caught SIGWINCH, shutting down gracefully
Enabling module rewrite.
To activate the new configuration, you need to run:
  service apache2 restart
[28/Sep/2022:21:21:34 -0400] "GET / HTTP/1.1" 302 1651 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
[28/Sep/2022:21:21:34 -0400] "GET /auth/login HTTP/1.1" 200 4753 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
[28/Sep/2022:21:21:50 -0400] "POST /auth/login HTTP/1.1" 500 1211 "http://192.168.50.145:8087/auth/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
Module rewrite already enabled
[29/Sep/2022:13:56:49 -0400] "GET / HTTP/1.1" 302 1651 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
[29/Sep/2022:13:56:49 -0400] "GET /auth/login HTTP/1.1" 200 4755 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
[29/Sep/2022:13:57:28 -0400] "POST /auth/login HTTP/1.1" 500 1211 "http://192.168.50.145:8087/auth/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
Module rewrite already enabled
[29/Sep/2022:14:00:07 -0400] "GET / HTTP/1.1" 302 1651 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
[29/Sep/2022:14:00:07 -0400] "GET /auth/login HTTP/1.1" 200 4755 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
[29/Sep/2022:14:00:33 -0400] "GET / HTTP/1.1" 302 1651 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
[29/Sep/2022:14:00:33 -0400] "GET /auth/login HTTP/1.1" 200 4755 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"
[29/Sep/2022:14:00:46 -0400] "POST /auth/login HTTP/1.1" 500 1211 "http://192.168.50.145:8087/auth/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15"

** Press ANY KEY to close this window **

Thanks

Having the same issue. I stupidly updated this container thinking it would be fine and it just went to hell. I managed to get the php artisan issue fixed by adding DB_PORT and DB_NAME as variables for the container, however when I try to log in I am having this issue where it is throwing a 500 whenever trying to login. Nothing seems to be fixing it.

EDIT: I managed to go through all the latest docker versions downgrading until it worked again. Made it to "akaunting/akaunting:3.0.0" in which everything started working again. Moral of the story, don't update your main instance.

Edited February 23, 2023 by 97WaterPolo

gregoriko · March 15, 2023

Hi.

Someone solved this problem? I was try all from this topic but nothing work. I was try ver. 3.0.0 too.

TekDRu · March 16, 2023

16 hours ago, gregoriko said:

Hi.

Someone solved this problem? I was try all from this topic but nothing work. I was try ver. 3.0.0 too.

What errors or problems are you running into? I am using the app. I do not apply any updates to the container to avoid breaking it. I was able to update to 3.0.12 from within the app itself.

If and when I decide to update the container, there is a process I go through to restore my existing database and avoid loosing everything. Below is a quick list of steps from memory. I can give more detail if needed.

Backup the current database before making container updates
Apply container updates and go through install process from scratch (with php artisan install commands etc.) until I have a running app
Open the backed-up sql file in a text editor, and change the first three initials of all tables in to match the first three letters in new table names from new database
Delete all tables from new database
Import sql file from existing database (with new table names) to replace the new database

gregoriko · March 16, 2023

7 hours ago, TekDRu said:

What errors or problems are you running into? I am using the app. I do not apply any updates to the container to avoid breaking it. I was able to update to 3.0.12 from within the app itself.

If and when I decide to update the container, there is a process I go through to restore my existing database and avoid loosing everything. Below is a quick list of steps from memory. I can give more detail if needed.

Backup the current database before making container updates

Apply container updates and go through install process from scratch (with php artisan install commands etc.) until I have a running app

Open the backed-up sql file in a text editor, and change the first three initials of all tables in to match the first three letters in new table names from new database

Delete all tables from new database

Import sql file from existing database (with new table names) to replace the new database

I need Install first. I use mariaDB.
1. With Setup Account: true docker shutdown.
2. Later i was changed Setup Account: true and used in docker terminal (with my data)

php artisan install --db-host="localhost" --db-port="3306" --db-name="akaunting" --db-username="root" --db-password="" --db-prefix="ak3" --company-name="My Company" --company-email="myemailcompany@gmail" --admin-email="[email protected]" --admin-password="mypass" --locale="es-ES"

Base table are created but I can't logg inn. service apache2 restart doesn't work, docker is closeing. I have log like in this post
3. I tried adding the new variables for DB_PORT and DB_NAME. It's same.
4. I tried install by portainer with integrate mariaDB:

version: '2.1'

services:

  akaunting:
    image: kuralabs/docker-akaunting:latest
    restart: always
    ports:
      - 5003:8080
    environment:
      MYSQL_ROOT_PASSWORD: changeme #Change this password to something at least as long and complicated
    volumes:
      - /mnt/user/appdata/akaunting/mysql:/var/lib/mysql
      - /mnt/user/appdata/akaunting/logs:/var/log
      - /mnt/user/appdata/akaunting/config:/var/www/akaunting/config

but I have other error (screenshot). I don't know what can I do.

TekDRu · March 20, 2023

On 3/16/2023 at 6:47 PM, gregoriko said:

1. With Setup Account: true docker shutdown.
2. Later i was changed Setup Account: true and used in docker terminal (with my data)

The container Setup Account should be set to false. Make that change and run the php artisan install command again and see if that gets you to the setup wizard.

Is the screenshot from portainer? I haven't used portainer before so I can't help there. I've only used the docker with mariadb and use adminer to access my databases.

Edited March 20, 2023 by TekDRu

war1000 · July 8, 2023

For those who got f**ked just like I did after updating, please go edit your container and put "akaunting/akaunting:2.1" in your repository section. This will role it back to the last image before v3 which causes all sorts of issues.

I found this video to be helpful.

It is now working for me again. I was scared that I lost 2 years worth of tracking in this software.

-C- · November 26, 2023

This looks like it'd be super useful for me, but I've had no luck trying to get it up and running.

Before I try the 2.1 version as above, wondering whether there's been any advances on getting the latest versions working in the last 6 months.

K1LLA_KING_KING · January 7

On 11/26/2023 at 11:50 PM, -C- said:

This looks like it'd be super useful for me, but I've had no luck trying to get it up and running.

Before I try the 2.1 version as above, wondering whether there's been any advances on getting the latest versions working in the last 6 months.

Same question from me.

I used the custom string as suggested, which removed the DB NAME and DB PORT error. But now im left with this:

Rolling back toakaunting/akaunting:2.1 is worth it? Or do I just look for a different app?

Edited January 7 by K1LLA_KING_KING

K1LLA_KING_KING · January 7

On 3/16/2023 at 11:16 PM, TekDRu said:

What errors or problems are you running into? I am using the app. I do not apply any updates to the container to avoid breaking it. I was able to update to 3.0.12 from within the app itself.

If and when I decide to update the container, there is a process I go through to restore my existing database and avoid loosing everything. Below is a quick list of steps from memory. I can give more detail if needed.

Backup the current database before making container updates

Apply container updates and go through install process from scratch (with php artisan install commands etc.) until I have a running app

Open the backed-up sql file in a text editor, and change the first three initials of all tables in to match the first three letters in new table names from new database

Delete all tables from new database

Import sql file from existing database (with new table names) to replace the new database

what are you doing with this error?

TekDRu · January 7

12 hours ago, K1LLA_KING_KING said:

what are you doing with this error?

Did you already run the "php artisan install" script?

K1LLA_KING_KING · January 9

On 1/8/2024 at 5:31 AM, TekDRu said:

Did you already run the "php artisan install" script?

yes. Or I would be getting differnt error re: missing db port etc

TekDRu · January 11

hey @K1LLA_KING_KING, can you share a screenshot of your container or the docker run command to see If I notice any issues with the settings.

TekDRu · February 20

Discovered a solution to updating the container without issue. Adding variables for "DB_PREFIX" and "APP_INSTALLED=true" did the trick for me. Got some help from these posts:

https://github.com/akaunting/docker/issues/61#issuecomment-1143664641

https://github.com/akaunting/docker/issues/107

For the DB_PREFIX variable, you will need to use the first 4 characters seen in your specific existing database tables names.

I would advice backing up your database and appdata before making these edits.

feins · April 7

I've just install Akaunting and setup postgresql15.

When i try to launch Akaunting the log show this error and no login page.

Enabling module rewrite.
To activate the new configuration, you need to run:
service apache2 restart
❌ Some options are missing and --no-interaction is present. Please run the following command for more information :
❌ php artisan help install
❌ Missing options are : db-port, db-name
❌ Some options are missing and --no-interaction is present. Please run the following command for more information :
❌ php artisan help install
❌ Missing options are : db-port, db-name
❌ Some options are missing and --no-interaction is present. Please run the following command for more information :
❌ php artisan help install
❌ Missing options are : db-port, db-name
❌ Some options are missing and --no-interaction is present. Please run the following command for more information :
❌ php artisan help install
❌ Missing options are : db-port, db-name
❌ Some options are missing and --no-interaction is present. Please run the following command for more information :
❌ php artisan help install
❌ Missing options are : db-port, db-name
❌ Some options are missing and --no-interaction is present. Please run the following command for more information :
❌ php artisan help install
❌ Missing options are : db-port, db-name

** Press ANY KEY to close this window **

[Support] Akaunting

Recommended Posts

Link to comment

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Yoda

Posted Images

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Join the conversation