blue8lucian Posted January 6, 2023 Share Posted 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? Quote Link to comment
TekDRu Posted January 9, 2023 Share Posted 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. Quote Link to comment
blue8lucian Posted January 12, 2023 Share Posted 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! Quote Link to comment
TekDRu Posted February 7, 2023 Share Posted 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? Quote Link to comment
97WaterPolo Posted February 23, 2023 Share Posted February 23, 2023 (edited) 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 Quote Link to comment
gregoriko Posted March 15, 2023 Share Posted 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. Quote Link to comment
TekDRu Posted March 16, 2023 Share Posted 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 Quote Link to comment
gregoriko Posted March 16, 2023 Share Posted 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. Quote Link to comment
TekDRu Posted March 20, 2023 Share Posted March 20, 2023 (edited) 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 Quote Link to comment
war1000 Posted July 8, 2023 Share Posted 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. Quote Link to comment
-C- Posted November 26, 2023 Share Posted 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. Quote Link to comment
K1LLA_KING_KING Posted January 7 Share Posted January 7 (edited) 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 Quote Link to comment
K1LLA_KING_KING Posted January 7 Share Posted 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? Quote Link to comment
TekDRu Posted January 7 Share Posted 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? Quote Link to comment
K1LLA_KING_KING Posted January 9 Share Posted 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 Quote Link to comment
TekDRu Posted January 11 Share Posted 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. Quote Link to comment
TekDRu Posted February 20 Share Posted 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. Quote Link to comment
feins Posted April 7 Share Posted 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 ** Quote Link to comment
dgwharrison Posted July 11 Share Posted July 11 On 4/7/2024 at 6:47 PM, feins said: 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 ** I'm having exactly the same issue. Did you get it running? @Yoda can you help? Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.