# HG changeset patch
# User Michiel Broek <mbroek@mbse.eu>
# Date 1559243983 -7200
# Node ID 2395bdfac38774ee376f42ae290ed10cf9cc0002
# Parent  547c23b50d009297d14f3235e7ff2eaaa4eee4e6
Better MySQL fault logging.

diff -r 547c23b50d00 -r 2395bdfac387 bmsd/mysql.c
--- a/bmsd/mysql.c	Thu May 30 20:47:08 2019 +0200
+++ b/bmsd/mysql.c	Thu May 30 21:19:43 2019 +0200
@@ -355,6 +355,7 @@
 
     if (mysql_query(con, query)) {
 	syslog(LOG_NOTICE, "MySQL: INSERT INTO mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con));
+	syslog(LOG_NOTICE, query);
     } else {
 	syslog(LOG_NOTICE,  "MySQL: insert new node %s", node->node);
     }
@@ -383,6 +384,7 @@
 
     if (mysql_query(con, query)) {
 	syslog(LOG_NOTICE, "MySQL: UPDATE mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con));
+	syslog(LOG_NOTICE, query);
     }
 
     free(query);
@@ -395,10 +397,10 @@
     char        *query = malloc(512);
 
     snprintf(query, 511, "UPDATE mon_nodes SET online='N' WHERE node='%s'", node);
-//    printf("%s\n", query);
 
     if (mysql_query(con, query)) {
 	syslog(LOG_NOTICE, "MySQL: UPDATE mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con));
+	syslog(LOG_NOTICE, query);
     }
 
     free(query);
@@ -445,10 +447,9 @@
 	fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi,
 	fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light);
 
-//    printf("%s\n", query);
-
     if (mysql_query(con, query)) {
 	syslog(LOG_NOTICE, "MySQL: INSERT INTO mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con));
+	syslog(LOG_NOTICE, query);
     } else {
 	syslog(LOG_NOTICE,  "MySQL: insert new fermenter %s/%s", fermenter->node, fermenter->alias);
     }
@@ -494,10 +495,9 @@
 	fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi,
 	fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light, fermenter->uuid);
 
-//    printf("%s\n", query);
-
     if (mysql_query(con, query)) {
 	syslog(LOG_NOTICE, "MySQL: UPDATE mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con));
+	syslog(LOG_NOTICE, query);
     }
 
     free(query);
@@ -516,6 +516,7 @@
 
     if (mysql_query(con, query)) {
 	syslog(LOG_NOTICE, "MySQL: UPDATE mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con));
+	syslog(LOG_NOTICE, query);
     }
 
     free(query);