mirror of
https://github.com/librespeed/speedtest.git
synced 2026-05-13 16:26:38 +00:00
750f043872
* Initial plan * Fix critical security vulnerability: Move SQLite database outside webroot Co-authored-by: sstidl <12804296+sstidl@users.noreply.github.com> * Update documentation to explain secure SQLite database path Co-authored-by: sstidl <12804296+sstidl@users.noreply.github.com> * Clarify SQLite database security requirements for different installation scenarios Co-authored-by: sstidl <12804296+sstidl@users.noreply.github.com> * Improve security documentation with web server configuration guidance Co-authored-by: sstidl <12804296+sstidl@users.noreply.github.com> * Fix incomplete file path in documentation example Co-authored-by: sstidl <12804296+sstidl@users.noreply.github.com> * Clarify that database file is created after first test in verification step Co-authored-by: sstidl <12804296+sstidl@users.noreply.github.com> --------- Co-authored-by: copilot-swe-agent[bot] <198982749+Copilot@users.noreply.github.com> Co-authored-by: sstidl <12804296+sstidl@users.noreply.github.com>
35 lines
1.3 KiB
PHP
Executable file
35 lines
1.3 KiB
PHP
Executable file
<?php
|
|
|
|
// Type of db: "mssql", "mysql", "sqlite" or "postgresql"
|
|
$db_type = 'sqlite';
|
|
// Password to login to stats.php. Change this!!!
|
|
$stats_password = 'PASSWORD';
|
|
// If set to true, test IDs will be obfuscated to prevent users from guessing URLs of other tests
|
|
$enable_id_obfuscation = false;
|
|
// If set to true, IP addresses will be redacted from IP and ISP info fields, as well as the log
|
|
$redact_ip_addresses = false;
|
|
|
|
// Sqlite3 settings
|
|
$Sqlite_db_file = __DIR__ . '/../../speedtest_telemetry.db';
|
|
|
|
// mssql settings
|
|
$MsSql_server = 'DB_HOSTNAME';
|
|
$MsSql_databasename = 'DB_NAME';
|
|
$MsSql_WindowsAuthentication = true; //true or false
|
|
$MsSql_username = 'USERNAME'; //not used if MsSql_WindowsAuthentication is true
|
|
$MsSql_password = 'PASSWORD'; //not used if MsSql_WindowsAuthentication is true
|
|
$MsSql_TrustServerCertificate = true; //true, false or comment out for driver default
|
|
//Download driver from https://docs.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver16
|
|
|
|
// Mysql settings
|
|
$MySql_username = 'USERNAME';
|
|
$MySql_password = 'PASSWORD';
|
|
$MySql_hostname = 'DB_HOSTNAME';
|
|
$MySql_databasename = 'DB_NAME';
|
|
$MySql_port = '3306';
|
|
|
|
// Postgresql settings
|
|
$PostgreSql_username = 'USERNAME';
|
|
$PostgreSql_password = 'PASSWORD';
|
|
$PostgreSql_hostname = 'DB_HOSTNAME';
|
|
$PostgreSql_databasename = 'DB_NAME';
|