Skedler Reports v4- Configure an External Database as Datastore

Modified on Sat, 25 Sep, 2021 at 5:37 PM

Skedler does not require Elasticsearch configuration for Grafana report generation. Skedler now uses an embedded database to store metadata and history data.

The embedded database is located at,

For linux, /var/lib/skedler/skedler.db and /var/lib/skedler/skedlerHistory.db
For windows, C:\\skedler\skedler.db and C:\\skedler\skedlerHistory.db

You can also specify an external database which should either be "MySQL" or "SQLite". Use the below variables to configure Skedler to use the database,

Please edit the external database configuration in the reporting.yml file. Check the below paths to navigate to the reporting.yml file.

Windows: $skedler_home/config/reporting.yml

Linux: $skedler_home/config/reporting.yml

Docker: /opt/skedler/config/reporting.yml

RPM: /etc/skedler-reports/reporting.yml

Below screenshot for your reference,

1	database_type	Specify the database type either "mysql" or "sqlite"
2	database_hostname database_port database_name database_history_name database_username database_password	For `mysql` database configuration, you can configure the database connection by specifying host, name, user and password.
3	database_path database_history_path	For `sqlite` database configuration, you can specify the relative path.
4	max_conn	Maximum number of connection in pool. Default value is set to 5
5	min_conn	Minimum number of connection in pool. Default value is set to 0
6	conn_idle_time	The maximum time, in milliseconds, that a connection can be idle before being released. Default value is set to 10000
7	conn_acquire_time	The maximum time, in milliseconds, that pool will try to get connection before throwing error. Default value is set to 10000