Fri, 22 Jul 2022 12:15:05 +0200
Version 0.3.41. Use INSERT IGNORE .. for insert log messages from fermenters, co2meters and ispindels. Connect to MySQL servers with MYSQL_OPT_RECONNECT instead of manual working around the connection lost problem if a mysql server is restarted. Removed unused bms_mysql_ping function.
<?php /* * Check for development server */ if (isset($_SERVER['SERVER_NAME']) && ( strcmp($_SERVER['SERVER_NAME'], "seaport.mbse.ym") == 0)) { define ('DBASE_NAME', 'bms_dev'); define ('DBASE_HOST', 'lx02'); define ('DBASE_USER', 'bms_dev'); define ('DBASE_PASS', 'bms_dev'); define ('DBASE_CHARSET', 'utf8'); define ('EMAIL_FROM', 'noreply@mbse.ym'); define ('MQTT_HOST', 'localhost'); define ('MQTT_PORT', 1883 ); define ('MQTT_USER', 'mqtt_user' ); define ('MQTT_PASS', 'mqtt_pass' ); setlocale ( LC_TIME , 'nl_NL' ); } else { define ('DBASE_NAME', 'bms_dev'); define ('DBASE_HOST', 'lx02'); define ('DBASE_USER', 'bms_dev'); define ('DBASE_PASS', 'bms_dev'); define ('DBASE_CHARSET', 'utf8'); define ('EMAIL_FROM', 'noreply@mbse.ym'); define ('MQTT_HOST', 'localhost'); define ('MQTT_PORT', 1883 ); define ('MQTT_USER', 'mqtt_user' ); define ('MQTT_PASS', 'mqtt_pass' ); setlocale ( LC_TIME , 'nl_NL' ); }