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

Error 500 on general setting and speedtest not working #943

Closed
Kunalb963 opened this issue Nov 28, 2023 · 47 comments
Closed

Error 500 on general setting and speedtest not working #943

Kunalb963 opened this issue Nov 28, 2023 · 47 comments
Assignees
Labels
🐛 bug Something isn't working

Comments

@Kunalb963
Copy link

Kunalb963 commented Nov 28, 2023

I am using container in Synology DS220+ NAS

❌ There seems to be a failure in checking the web server + PHP-FPM. Here's the response:
#14 /var/www/html/vendor/livewire/livewire/src/Features/SupportPageComponents/HandlesPageComponents.php(14): Livewire\Features\SupportPageComponents\SupportPageComponents::interceptTheRenderOfTheComponentAndRetreiveTheLayoutConfiguration()
#24 /var/www/html/vendor/livewire/livewire/src/Features/SupportPageComponents/HandlesPageComponents.php(14): Livewire\Features\SupportPageComponents\SupportPageComponents::interceptTheRenderOfTheComponentAndRetreiveTheLayoutConfiguration()
#34 /var/www/html/vendor/livewire/livewire/src/Features/SupportPageComponents/HandlesPageComponents.php(14): Livewire\Features\SupportPageComponents\SupportPageComponents::interceptTheRenderOfTheComponentAndRetreiveTheLayoutConfiguration()
#44 /var/www/html/vendor/livewire/livewire/src/Features/SupportPageComponents/HandlesPageComponents.php(14): Livewire\Features\SupportPageComponents\SupportPageComponents::interceptTheRenderOfTheComponentAndRetreiveTheLayoutConfiguration()
#54 /var/www/html/vendor/livewire/livewire/src/Features/SupportPageComponents/HandlesPageComponents.php(14): Livewire\Features\SupportPageComponents\SupportPageComponents::interceptTheRenderOfTheComponentAndRetreiveTheLayoutConfiguration()
#64 /var/www/html/vendor/livewire/livewire/src/Features/SupportPageComponents/HandlesPageComponents.php(14): Livewire\Features\SupportPageComponents\SupportPageComponents::interceptTheRenderOfTheComponentAndRetreiveTheLayoutConfiguration()
#74 /var/www/html/vendor/livewire/livewire/src/Features/SupportPageComponents/HandlesPageComponents.php(14): Livewire\Features\SupportPageComponents\SupportPageComponents::interceptTheRenderOfTheComponentAndRetreiveTheLayoutConfiguration()
#84 /var/www/html/vendor/livewire/livewire/src/Features/SupportPageComponents/HandlesPageComponents.php(14): Livewire\Features\SupportPageComponents\SupportPageComponents::interceptTheRenderOfTheComponentAndRetreiveTheLayoutConfiguration()A clear and concise description of what the bug is.

To Reproduce
version: '3.3'
services:
tracker:
container_name: speedtest-tracker
ports:
- 8080:80
- 6443:443
environment:
- PUID=1026
- PGID=100
- APP_KEY=base64:2Sv4krpXu4yspl8lahCiWpafS9U4OqUPWkbrVEm87C4=
- DB_CONNECTION=mysql
- DB_HOST=db
- DB_PORT=3306
- DB_DATABASE=speedtest_tracker
- DB_USERNAME=speedy
- DB_PASSWORD=password
volumes:
- '/etc/localtime:/etc/localtime:ro'
- '/volume1/docker/speedtest:/config'
- '/volume1/docker/speedtest/web:/etc/ssl/web'
image: 'ghcr.io/alexjustesen/speedtest-tracker:latest'
restart: unless-stopped
depends_on:
- db
db:
image: mariadb:10
restart: always
environment:
- MARIADB_DATABASE=speedtest_tracker
- MARIADB_USER=speedy
- MARIADB_PASSWORD=password
- MARIADB_RANDOM_ROOT_PASSWORD=true
volumes:
- speedtest-db:/var/lib/mysql
volumes:
speedtest-db:

@alexjustesen
Copy link
Owner

It seems to happen pretty randomly, can you restart the container and check if you can access the UI?

If so feel free to close the issue.

@Kunalb963 Kunalb963 changed the title Error 500 on general setting nad speedtest not working Error 500 on general setting and speedtest not working Nov 28, 2023
@Kunalb963
Copy link
Author

i tried every possible solution even deleted the env file i can only access the ui of all except general setting only.

@Kunalb963
Copy link
Author

i tried every possible solution even deleted the env file i can only access the ui of all except general setting only.

also no results shown.
image

@alexjustesen
Copy link
Owner

alexjustesen commented Nov 28, 2023

i tried every possible solution even deleted the env file i can only access the ui of all except general setting only.

also no results shown.

Do you want to keep your data or are you ok with starting over?

If so you can run php artisan app:install --force and it will reset everything but YOU WILL LOSE EVERYTHING.

Been warned.

@Kunalb963
Copy link
Author

php artisan app:install --force

done but still same issue.

@alexjustesen
Copy link
Owner

Can you attach a copy of the log? Should start from line 1.

@Kunalb963
Copy link
Author

Can you attach a copy of the log? Should start from line 1.

🔒 SSL_MODE has been set to MIXED, setting the web server to work in HTTP + HTTPS...
🐇 Configuring Speedtest Tracker...
🔒 Fixing app path file permissions...
✅ Permissions fixed.
🧹 Clearing any previous caches...
✅ Cache cleared.
✅ Environment file exists.
🔗 Creating symlinks for config and log files...
✅ Symlinks created.
✅ An application key environment variable exists.
💰 Building the cache...
✅ Cache set.
🚛 Migrating the database...
✅ Database migrated.
✅ All set, Speedtest Tracker started.
[27-Nov-2023 22:51:14] NOTICE: fpm is running, pid 119
[27-Nov-2023 22:51:14] NOTICE: ready to handle connections
[27-Nov-2023 22:51:14] NOTICE: systemd monitor interval set to 10000ms
❌ There seems to be a failure in checking the web server + PHP-FPM. Here's the response:
172.19.0.1 - - [27/Nov/2023:22:51:32 +0530] "GET / HTTP/2.0" 200 4890 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:51:40 +0530] "GET /admin HTTP/2.0" 200 12459 "https://192.168.2.0:8443/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:51:43 +0530] "GET /livewire/livewire.js?id=2b77c128 HTTP/2.0" 200 69756 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:51:45 +0530] "POST /livewire/update HTTP/2.0" 200 5075 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:52:22 +0530] "POST /livewire/update HTTP/2.0" 200 2694 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:52:24 +0530] "POST /livewire/update HTTP/2.0" 200 1735 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:52:31 +0530] "GET /admin/results HTTP/2.0" 200 20487 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:52:32 +0530] "POST /livewire/update HTTP/2.0" 200 2883 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:53:43 +0530] "GET /admin HTTP/2.0" 200 12457 "https://192.168.2.0:8443/admin/results" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:53:45 +0530] "POST /livewire/update HTTP/2.0" 200 3111 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:53:48 +0530] "POST /livewire/update HTTP/2.0" 200 2641 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:53:49 +0530] "GET /admin/results HTTP/2.0" 200 20890 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:53:56 +0530] "GET /admin HTTP/2.0" 200 12476 "https://192.168.2.0:8443/admin/results" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:53:58 +0530] "POST /livewire/update HTTP/2.0" 200 3093 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
172.19.0.1 - - [27/Nov/2023:22:54:03 +0530] "GET / HTTP/2.0" 200 4905 "https://192.168.2.0:8443/admin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"

@alexjustesen
Copy link
Owner

Just to confirm you can access and sign into the application at /admin and it's just the general settings page throwing the 500 error?

@Kunalb963
Copy link
Author

Kunalb963 commented Nov 29, 2023

Just to confirm you can access and sign into the application at /admin and it's just the general settings page throwing the 500 error?

yes.also not only that even speedtest doesn't run at all as you can see in the above screenshot.can you take over to my device to setup new container build to help me out and if you want to contact me plese send me the email to 963kunal.biswas@gmail.com

@Kunalb963
Copy link
Author

Just to confirm you can access and sign into the application at /admin and it's just the general settings page throwing the 500 error?

yes. can you take over to my device to setup new container build to help me out and if you want to contact me plese send me the email to 963kunal.biswas@gmail.com

because from past 7-8 months i was trying to set it up i get same errors.

@fluidsc
Copy link

fluidsc commented Nov 29, 2023

This same issue popped up for me over the past couple of days...not sure exactly when. The command listed above (php artisan app:install --force) to force a reset of the application has it working again. Just wanted to make that known since I literally just had the 500 status error start for me randomly without me changing anything related to the container.

@Kunalb963
Copy link
Author

This same issue popped up for me over the past couple of days...not sure exactly when. The command listed above (php artisan app:install --force) to force a reset of the application has it working again. Just wanted to make that known since I literally just had the 500 status error start for me randomly without me changing anything related to the container.

php artisan app:install --force) it also did not work for me.

@alexjustesen
Copy link
Owner

I bet this is tied to the recent introduction of the public dashboard setting and potentially a migration that didn't run. I'll look into it tonight.

@alexjustesen alexjustesen self-assigned this Nov 29, 2023
@alexjustesen alexjustesen added the 🐛 bug Something isn't working label Nov 29, 2023
@Kunalb963
Copy link
Author

I bet this is tied to the recent introduction of the public dashboard setting and potentially a migration that didn't run. I'll look into it tonight.

update us as soon as it resolved

@Minirex96
Copy link

Just wanted to add that I'm also getting this 500 error since the lastest update. Can't access the docker container at all.

@alexjustesen
Copy link
Owner

@Kunalb963 can you dump the settings table from the app's database and attach it as a csv file to this issue? You can connect and dump the database using an application like DBeaver if you're not familiar with working with databases.

@Bulletoverload
Copy link

Bulletoverload commented Dec 3, 2023

Also running in to this 500 error for the last few weeks now

@alexjustesen
Copy link
Owner

Also running in to this 500 error for the last few weeks now

Do you mind also dumping your settings table?

@Bulletoverload
Copy link

Also running in to this 500 error for the last few weeks now

Do you mind also dumping your settings table?

This is probably way more info than you need but I am on Unraid and wasn't sure where to pull the docker config

https://pastebin.com/4XzdfKgU

@alexjustesen
Copy link
Owner

This is probably way more info than you need but I am on Unraid and wasn't sure where to pull the docker config

I was actually looking for the settings database table

@Bulletoverload
Copy link

Bulletoverload commented Dec 4, 2023

This is probably way more info than you need but I am on Unraid and wasn't sure where to pull the docker config

I was actually looking for the settings database table

Sorry, where do I grab that from on Unraid?

@crypticviper
Copy link

crypticviper commented Dec 4, 2023

I have identical issue. I have exported the "settings" table into csv and attached here (had to remove my email id). Hope that helps.

My HW is different. Running on Rpi4, Open Media Vault. Docker image is the latest. I have auto update of docker images setup so that may have caused it to fetch an image that has this issue.

settings.zip

@alexjustesen
Copy link
Owner

I have identical issue. I have exported the "settings" table into csv and attached here (had to remove my email id). Hope that helps.

My HW is different. Running on Rpi4, Open Media Vault. Docker image is the latest. I have auto update of docker images setup so that may have caused it to fetch an image that has this issue.

settings.zip

Thank you, for a while now there's been some random settings only issues cropping up and it's been a PITA to debug

@alexjustesen
Copy link
Owner

@crypticviper are you comfortable manually updating a record? If so can you change your timezone from Europe\/Berlin to Europe/Berlin and let me know if that fixes the issue?

@alexjustesen
Copy link
Owner

@Kunalb963 @Bulletoverload if y'all can dump your settings table from the speedtest database please do so.

@Bulletoverload
Copy link

@Kunalb963 @Bulletoverload if y'all can dump your settings table from the speedtest database please do so.

I don't have access to the app at all. Where can I grab the settings table at? I'm on Unraid

@alexjustesen
Copy link
Owner

I don't have access to the app at all. Where can I grab the settings table at? I'm on Unraid

Are you using sqlite or MySQL for a database?

@Bulletoverload
Copy link

Bulletoverload commented Dec 8, 2023 via email

@Minirex96
Copy link

Can confirm... the Unraid setup uses sqlite
image

@Minirex96
Copy link

Minirex96 commented Dec 8, 2023

@Kunalb963 @Bulletoverload if y'all can dump your settings table from the speedtest database please do so.

I don't have access to the app at all. Where can I grab the settings table at? I'm on Unraid

On Unraid you can find it in Shares>appdata>speedtest-tracker>database.sqlite. Easiest way is to set the appdata share to export=yes and security=public then navigate over your network to that directory. I followed the instructions above and downloaded DBeaver and connected it to the database file and then exported the settings table to csv as requested. All this was new for me but it wasn't hard to figure out.

settings_202312072234.csv

@Minirex96
Copy link

Minirex96 commented Dec 8, 2023

@crypticviper are you comfortable manually updating a record? If so can you change your timezone from Europe\/Berlin to Europe/Berlin and let me know if that fixes the issue?

I tried this with America/New_York and still getting same 500 server error. Stopped the docker container, updated the database, restarted container. No difference. Updated settings attached.
settings_202312072307.csv

@Minirex96
Copy link

Minirex96 commented Dec 8, 2023

My logs...

.....snipped.....
[2023-12-08 04:21:32] production.ERROR: No application encryption key has been specified. {"exception":"[object] (Illuminate\Encryption\MissingAppKeyException(code: 0): No application encryption key has been specified. at /var/www/html/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:79)
[stacktrace]
.....snipped.....

@parallax-home
Copy link

As a brand new user I just did a completely fresh install on a new VM/Docker from the docker-compose in the instructions using Postgres, and after entering the default user/password it returns me to the "getting started" screen. Clicking on the "sign in / admin panel" link again returns me to the "getting started" screen. I am unable to proceed and have never got to the main screen.

There's no error in the logs for either the db container or the main app, but a few restarts ago I got the "There seems to be a failure in checking the web server + PHP-FPM. Here's the response:" error from the first post. I ran php artisan app:install --force and that fixed the problem.

Again, this was a completely new install - I've never run this program before.

Ubuntu 23.10
Docker 24.0.7

@alexjustesen
Copy link
Owner

As a brand new user I just did a completely fresh install on a new VM/Docker from the docker-compose in the instructions using Postgres, and after entering the default user/password it returns me to the "getting started" screen. Clicking on the "sign in / admin panel" link again returns me to the "getting started" screen. I am unable to proceed and have never got to the main screen.

This has been fixed in a beta build, just click for the admin panel again.

There's no error in the logs for either the db container or the main app, but a few restarts ago I got the "There seems to be a failure in checking the web server + PHP-FPM. Here's the response:" error from the first post. I ran php artisan app:install --force and that fixed the problem.

Again, this was a completely new install - I've never run this program before.

Ubuntu 23.10
Docker 24.0.7

Fpm issues are random and can be ignored. This issue relates to the settings page so if your having other problems please open a separate issue.

@parallax-home
Copy link

Well, the being sent back to the "getting started" screen every time seems to be a problem specific to Firefox, the application works on Chrome (which I don't particularly want to use). My version of Firefox is :
"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:120.0) Gecko/20100101 Firefox/120.0"

@alexjustesen
Copy link
Owner

@Minirex96 your error is in the first line of the output. It's asking for an app key which has been covered in other issues and generating one is in the docs. That should solve your issue.

@alexjustesen
Copy link
Owner

Well, the being sent back to the "getting started" screen every time seems to be a problem specific to Firefox, the application works on Chrome (which I don't particularly want to use). My version of Firefox is :
"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:120.0) Gecko/20100101 Firefox/120.0"

Yeah that's new, can you do me a favor and open a new issue?

@crypticviper
Copy link

@crypticviper are you comfortable manually updating a record? If so can you change your timezone from Europe\/Berlin to Europe/Berlin and let me know if that fixes the issue?

I changed this, restarted the container. Still same issue.

@Bulletoverload
Copy link

@Kunalb963 @Bulletoverload if y'all can dump your settings table from the speedtest database please do so.

I don't have access to the app at all. Where can I grab the settings table at? I'm on Unraid

On Unraid you can find it in Shares>appdata>speedtest-tracker>database.sqlite. Easiest way is to set the appdata share to export=yes and security=public then navigate over your network to that directory. I followed the instructions above and downloaded DBeaver and connected it to the database file and then exported the settings table to csv as requested. All this was new for me but it wasn't hard to figure out.

settings_202312072234.csv

This was perfect thanks. @alexjustesen Attached is my settings table.

settings.csv

@alexjustesen
Copy link
Owner

Yeah formatting of the time zone is wrong again. I'm going to make a cli command to fix settings manually.

@Bulletoverload
Copy link

oh ya that funky extra slash. I'll change it manually and see if it fixes.

@Bulletoverload
Copy link

I changed the timezone entry to "America/New_York", restarted the container and confirmed the change stuck, but still getting the error.

@alexjustesen
Copy link
Owner

I changed the timezone entry to "America/New_York", restarted the container and confirmed the change stuck, but still getting the error.

Can you also remove the null from within the speedtest servers array?

@Bulletoverload
Copy link

Bulletoverload commented Dec 8, 2023

Removed. Still nothing.

Updated settings for you incase I did it wrong.

settings.csv

@Minirex96
Copy link

@Minirex96 your error is in the first line of the output. It's asking for an app key which has been covered in other issues and generating one is in the docs. That should solve your issue.

Yep fixed it

@crypticviper
Copy link

@crypticviper are you comfortable manually updating a record? If so can you change your timezone from Europe\/Berlin to Europe/Berlin and let me know if that fixes the issue?

I changed this, restarted the container. Still same issue.

Ok, I had an additional issue of missing app key. Somehow, it was not being read from .env file. So I had to set it in my docker compose file and it started working.

Thanks for your help.

@alexjustesen
Copy link
Owner

Closing haven't heard from OP in 2 weeks, feel free to open a new issue if the problem persists.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
🐛 bug Something isn't working
Projects
None yet
Development

No branches or pull requests

7 participants