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