5956e07a7a
* Create telemetry_mssql.sql SQL to create the speedtest_users table on Microsoft SQL server. This SQL is based on the original templates, and continues to uses nvarchar for all fields as the templates do – even though some of the fields should be int. * Added support for Microsoft SQL Server * New sanitycheck.php page plus required updates to telemetry_db.php Created a sanity check page to verify that the required PHP extensions are installed, and that it is possible to connect to the database. * Update README.md - MS SQL support Added mention of Microsoft SQL Server as a supported DB engine. * Added missing <tr> to sanitycheck.php
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 = 'mysql';
|
|
// 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 = '../../speedtest_telemetry.sql';
|
|
|
|
// 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';
|