search

BigBoot / AutoKuma

AutoKuma is a utility that automates the creation of Uptime Kuma monitors based on Docker container labels. With AutoKuma, you can eliminate the need for manual monitor creation in the Uptime Kuma UI.
MIT License
309 stars 15 forks source link

Postgres and MySQL monitor types failing on `sql_query` invalid column name #65

Closed andyloree closed 3 months ago

andyloree commented 3 months ago

Trying to add a new mysql monitor type, fails server INSERT error, complaining there is no "sql_query" column in the monitor table:

INFO [autokuma::sync] Creating new monitor: postgres
WARN [autokuma::sync] Encountered error during sync: Server responded with an error: insert into `monitor` (`accepted_statuscodes_json`, `database_connection_string`, `interval`, `kafka_producer_brokers`, `kafka_producer_sasl_options`, `name`, `parent`, `retry_interval`, `sql_query`, `type`, `user_id`) values ('["200-299"]', 'postgres://root:[REDACT]@postgres.[REDACT]:5432/postgres', 60, NULL, NULL, 'Postgres', 40, 60, 'SELECT 1', 'postgres', 1) - SQLITE_ERROR: table monitor has no column named sql_query
INFO [autokuma::sync] Creating new monitor: mysqldb
WARN [autokuma::sync] Encountered error during sync: Server responded with an error: insert into `monitor` (`accepted_statuscodes_json`, `database_connection_string`, `interval`, `kafka_producer_brokers`, `kafka_producer_sasl_options`, `name`, `parent`, `retry_interval`, `sql_query`, `type`, `user_id`) values ('["200-299"]', 'mysql://root:[REDACT]@mysql.[REDACT]:3306/mysql', 60, NULL, NULL, 'MySql', 40, 60, 'SELECT 1', 'mysql', 1) - SQLITE_ERROR: table monitor has no column named sql_query