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

Document Influxdb as an alternative to mysql #1193

Closed
AxReds opened this issue Feb 20, 2024 · 1 comment
Closed

Document Influxdb as an alternative to mysql #1193

AxReds opened this issue Feb 20, 2024 · 1 comment
Labels
❓ question Further information is requested

Comments

@AxReds
Copy link

AxReds commented Feb 20, 2024

Would it be possible to add the steps to configure the connection to an InfluxDB database (either 1.8 or 2.x)?

Simply changeging the follwing variables in the docker compose script seems not working:
- DB_CONNECTION=influxdb
- DB_HOST=192.xxx.yy.z
- DB_PORT=8086

this is the generated log:
User uid: 1000
User gid: 1000

🔒 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.
✅ Environment file exists.
🔗 Creating symlinks for config and log files...
✅ Symlinks created.
⏳ Generating an application key...
[2024-02-20 19:03:33] production.ERROR: Database connection [influxdb] not configured. {"exception":"[object] (InvalidArgumentException(code: 0): Database connection [influxdb] not configured. at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:196)

[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(159): Illuminate\Database\DatabaseManager->configuration()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(101): Illuminate\Database\DatabaseManager->makeConnection()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(210): Illuminate\Database\DatabaseManager->connection()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(98): Illuminate\Cache\CacheManager->createDatabaseDriver()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(61): Illuminate\Cache\CacheManager->resolve()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(72): Illuminate\Cache\CacheManager->store()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheServiceProvider.php(35): Illuminate\Cache\CacheManager->driver()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(908): Illuminate\Cache\CacheServiceProvider->Illuminate\Cache\{closure}()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(795): Illuminate\Container\Container->build()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(957): Illuminate\Container\Container->resolve()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(731): Illuminate\Foundation\Application->resolve()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(942): Illuminate\Container\Container->make()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(1454): Illuminate\Foundation\Application->make()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(237): Illuminate\Container\Container->offsetGet()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(208): Illuminate\Support\Facades\Facade::resolveFacadeInstance()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(349): Illuminate\Support\Facades\Facade::getFacadeRoot()
#16 /var/www/html/app/Providers/RouteServiceProvider.php(27): Illuminate\Support\Facades\Facade::__callStatic()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Providers\RouteServiceProvider->boot()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1030): Illuminate\Container\Container->call()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1011): Illuminate\Foundation\Application->bootProvider()
#24 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1010): array_walk()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(263): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(447): Illuminate\Foundation\Application->bootstrapWith()
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(199): Illuminate\Foundation\Console\Kernel->bootstrap()
#30 /var/www/html/artisan(35): Illuminate\Foundation\Console\Kernel->handle()
#31 {main}
"}
⚠️ An application key was generated at start up, no environment variable was set.
👀 To set an application key that persists, read the docs: https://docs.speedtest-tracker.dev/
💰 Building the cache...
[2024-02-20 19:03:33] production.ERROR: Database connection [influxdb] not configured. {"exception":"[object] (InvalidArgumentException(code: 0): Database connection [influxdb] not configured. at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:196)

[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(159): Illuminate\Database\DatabaseManager->configuration()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(101): Illuminate\Database\DatabaseManager->makeConnection()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(210): Illuminate\Database\DatabaseManager->connection()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(98): Illuminate\Cache\CacheManager->createDatabaseDriver()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(61): Illuminate\Cache\CacheManager->resolve()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(72): Illuminate\Cache\CacheManager->store()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Cache/CacheServiceProvider.php(35): Illuminate\Cache\CacheManager->driver()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(908): Illuminate\Cache\CacheServiceProvider->Illuminate\Cache\{closure}()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(795): Illuminate\Container\Container->build()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(957): Illuminate\Container\Container->resolve()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(731): Illuminate\Foundation\Application->resolve()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(942): Illuminate\Container\Container->make()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(1454): Illuminate\Foundation\Application->make()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(237): Illuminate\Container\Container->offsetGet()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(208): Illuminate\Support\Facades\Facade::resolveFacadeInstance()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(349): Illuminate\Support\Facades\Facade::getFacadeRoot()
#16 /var/www/html/app/Providers/RouteServiceProvider.php(27): Illuminate\Support\Facades\Facade::__callStatic()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Providers\RouteServiceProvider->boot()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1030): Illuminate\Container\Container->call()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1011): Illuminate\Foundation\Application->bootProvider()
#24 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1010): array_walk()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(263): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(447): Illuminate\Foundation\Application->bootstrapWith()
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(199): Illuminate\Foundation\Console\Kernel->bootstrap()
#30 /var/www/html/artisan(35): Illuminate\Foundation\Console\Kernel->handle()
#31 {main}
"}
In DatabaseManager.php line 196:

Database connection [influxdb] not configured.

s6-rc: warning: unable to start service laravel-automations: command exited 1
/run/s6/basedir/scripts/rc.init: warning: s6-rc failed to properly bring all the services up! Check your logs (in /run/uncaught-logs/current if you have in-container logging) for more information.
prog: fatal: stopping the container.

@alexjustesen alexjustesen added the ❓ question Further information is requested label Feb 20, 2024
@alexjustesen
Copy link
Owner

To integrate with InfluxDB you can follow the directions here https://docs.speedtest-tracker.dev/settings/data-platforms/influxdb2, the application still requires an application database which can be either sqlite, mysql or postges.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
❓ question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants