There was an error trying to fetch latest speedtest results.

[siutung]

Hello,all.

I was installed speedtest on ubuntu 20.04 lts(Apache/2.4.41 + PHP 7.4.3 + mysql 8.0.33,installed them by apt.)

follow:https://fdossena.com/?p=speedtest/quickstart_v5_ubuntu.frag
step by step.

But when I vist http://myip/results/stats.php,
entered the password(logined successfully).The page says that:There was an error trying to fetch latest speedtest results. under the "Search test results".there haven't any test results.

But the speedtest frontpage is normal.

The apache2's access.log:
10.167.46.90 - - [14/Aug/2023:01:35:36 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1158 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:38 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:38 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:38 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:39 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:39 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:39 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:39 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:40 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:40 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:40 +0000] "GET /results/stats.php?op=logout HTTP/1.1" 200 978 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:40 +0000] "GET /results/stats.php HTTP/1.1" 200 1022 "http://10.167.45.154/results/stats.php?op=logout" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:43 +0000] "POST /results/stats.php?op=login HTTP/1.1" 200 978 "http://10.167.45.154/results/stats.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:43 +0000] "GET /results/stats.php HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=login" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"

The apache2's error.log:
[Mon Aug 14 01:19:38.940877 2023] [mpm_prefork:notice] [pid 9438] AH00163: Apache/2.4.41 (Ubuntu) configured -- resuming normal operations
[Mon Aug 14 01:19:38.951400 2023] [core:notice] [pid 9438] AH00094: Command line: '/usr/sbin/apache2'
[Mon Aug 14 01:33:04.046813 2023] [mpm_prefork:notice] [pid 9438] AH00169: caught SIGTERM, shutting down
[Mon Aug 14 01:33:28.687801 2023] [mpm_prefork:notice] [pid 710] AH00163: Apache/2.4.41 (Ubuntu) configured -- resuming normal operations
[Mon Aug 14 01:33:28.695237 2023] [core:notice] [pid 710] AH00094: Command line: '/usr/sbin/apache2'

What is my mistake,any idea?
Thanks.

[lill-peter]

I have th same problem.

[SX86]

Same for me. Created the speedtest_users table in my librespeed database, but it looks like it is not getting populated by results.

[g93920079]

Same for me. Does anyone know how to solve this? I try both mysql and postgres,the result is the same.

[MLQ-BA]

Try run Sanity check
/results/sanitycheck.php

On my installation the pdo_sqlite was missing, seems to have been lost in upgrade of php

[mbasri]

Hello,

I had exactly the same issues with the MySQL integration. In the end, I realized that the root cause was the password I was using to connect to the database

services:
  librespeed:
    container_name: librespeed
    image: linuxserver/librespeed:latest
    environment:
      DB_TYPE: 'mysql'
      DB_NAME: '...'
      DB_HOSTNAME: '...'
      DB_USERNAME: '...'
      DB_PASSWORD: 'ABC$CDE'
      DB_PORT: '...'

When this password is used to populate the /app/www/public/results/telemetry_settings.php file, it results in the following line

// Mysql settings
$MySql_username = '...';
$MySql_password = 'ABC';
$MySql_hostname = '...';
$MySql_databasename = '...';
$MySql_port = '...';

With the $DEF part being recognized as a variable...

Removing the '$' character from the password solved my problem. It is very likely that this is the same root cause for all types of databases, given that the database passwords are all populated in the /app/www/public/results/telemetry_settings.php file.

[scratchfury]

Make sure the JSON extension is enabled in PHP. I've learned that prior to 8.0 it wasn't installed automatically. If the following command returns no output, it's not enabled:

php -i | grep json

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.