mcrossley wrote: ↑Fri 08 Apr 2022 7:04 pm
Re-generate your reports in MX, then post your latest MXdiags log file here please.
I am posting the last minutes because it says it is too big.
I hope you can see where the error is and why every time I restart the Raspberry (and CumulusMX) the monthly and annual rain counters go to zero.
Thank you very much!
9 22:34:00.180 DoLogFile: Writing log entry for 09/04/2022 22:34:00
2022-04-09 22:34:00.181 DoLogFile: log entry for 09/04/2022 22:34:00 written
2022-04-09 22:34:00.183 Writing today.ini, LastUpdateTime = 09/04/2022 22:34:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:34:00.187 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:34:18.804 Done uploading standard Data file
2022-04-09 22:35:00.237 DoLogFile: Writing log entry for 09/04/2022 22:35:00
2022-04-09 22:35:00.238 DoLogFile: log entry for 09/04/2022 22:35:00 written
2022-04-09 22:35:00.240 Writing today.ini, LastUpdateTime = 09/04/2022 22:35:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:35:00.244 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:35:08.217 Done uploading graph data files
2022-04-09 22:35:08.217 FTP[Int]: Uploading daily graph data files
2022-04-09 22:35:08.217 FTP[Int]: Done uploading daily graph data files
2022-04-09 22:35:08.338 FTP[Int]: Process complete
2022-04-09 22:35:55.517 Creating NOAA yearly report
2022-04-09 22:35:55.519 Error at line 1 of dayfile.txt: Input string was not in a correct format.
2022-04-09 22:35:55.519 Please edit the file to correct the error
2022-04-09 22:35:55.520 Saving yearly NOAA report as Reports/NOAAYR2022.txt
2022-04-09 22:36:00.203 DoLogFile: Writing log entry for 09/04/2022 22:36:00
2022-04-09 22:36:00.204 DoLogFile: log entry for 09/04/2022 22:36:00 written
2022-04-09 22:36:00.206 Writing today.ini, LastUpdateTime = 09/04/2022 22:36:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:36:00.210 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:36:17.860 Done uploading standard Data file
2022-04-09 22:37:00.307 DoLogFile: Writing log entry for 09/04/2022 22:37:00
2022-04-09 22:37:00.308 DoLogFile: log entry for 09/04/2022 22:37:00 written
2022-04-09 22:37:00.311 Writing today.ini, LastUpdateTime = 09/04/2022 22:37:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:37:00.317 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:37:07.136 Done uploading graph data files
2022-04-09 22:37:07.137 FTP[Int]: Uploading daily graph data files
2022-04-09 22:37:07.137 FTP[Int]: Done uploading daily graph data files
2022-04-09 22:37:07.203 FTP[Int]: Process complete
2022-04-09 22:37:29.200 Creating NOAA yearly report
2022-04-09 22:37:29.202 Error at line 1 of dayfile.txt: Input string was not in a correct format.
2022-04-09 22:37:29.202 Please edit the file to correct the error
2022-04-09 22:37:29.203 Saving yearly NOAA report as Reports/NOAAYR2022.txt
2022-04-09 22:38:00.356 DoLogFile: Writing log entry for 09/04/2022 22:38:00
2022-04-09 22:38:00.357 DoLogFile: log entry for 09/04/2022 22:38:00 written
2022-04-09 22:38:00.359 Writing today.ini, LastUpdateTime = 09/04/2022 22:38:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:38:00.362 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:38:23.888 Done uploading standard Data file
2022-04-09 22:39:00.435 DoLogFile: Writing log entry for 09/04/2022 22:39:00
2022-04-09 22:39:00.437 DoLogFile: log entry for 09/04/2022 22:39:00 written
2022-04-09 22:39:00.439 Writing today.ini, LastUpdateTime = 09/04/2022 22:39:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:39:00.443 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:39:21.650 Done uploading graph data files
2022-04-09 22:39:21.651 FTP[Int]: Uploading daily graph data files
2022-04-09 22:39:21.651 FTP[Int]: Done uploading daily graph data files
2022-04-09 22:39:21.775 FTP[Int]: Process complete
2022-04-09 22:40:00.420 DoLogFile: Writing log entry for 09/04/2022 22:40:00
2022-04-09 22:40:00.422 DoLogFile: log entry for 09/04/2022 22:40:00 written
2022-04-09 22:40:00.425 Writing today.ini, LastUpdateTime = 09/04/2022 22:40:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:40:00.432 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:40:26.931 Done uploading standard Data file
2022-04-09 22:41:00.451 DoLogFile: Writing log entry for 09/04/2022 22:41:00
2022-04-09 22:41:00.452 DoLogFile: log entry for 09/04/2022 22:41:00 written
2022-04-09 22:41:00.454 Writing today.ini, LastUpdateTime = 09/04/2022 22:41:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:41:00.464 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:41:36.292 Done uploading graph data files
2022-04-09 22:41:36.293 FTP[Int]: Uploading daily graph data files
2022-04-09 22:41:36.293 FTP[Int]: Done uploading daily graph data files
2022-04-09 22:41:36.371 FTP[Int]: Process complete
2022-04-09 22:42:00.523 DoLogFile: Writing log entry for 09/04/2022 22:42:00
2022-04-09 22:42:00.524 DoLogFile: log entry for 09/04/2022 22:42:00 written
2022-04-09 22:42:00.526 Writing today.ini, LastUpdateTime = 09/04/2022 22:42:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:42:00.533 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:42:16.262 Done uploading standard Data file
2022-04-09 22:43:00.538 DoLogFile: Writing log entry for 09/04/2022 22:43:00
2022-04-09 22:43:00.539 DoLogFile: log entry for 09/04/2022 22:43:00 written
2022-04-09 22:43:00.541 Writing today.ini, LastUpdateTime = 09/04/2022 22:43:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:43:00.545 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:43:27.815 Done uploading graph data files
2022-04-09 22:43:27.816 FTP[Int]: Uploading daily graph data files
2022-04-09 22:43:27.816 FTP[Int]: Done uploading daily graph data files
2022-04-09 22:43:27.895 FTP[Int]: Process complete
2022-04-09 22:44:00.179 DoLogFile: Writing log entry for 09/04/2022 22:44:00
2022-04-09 22:44:00.193 DoLogFile: log entry for 09/04/2022 22:44:00 written
2022-04-09 22:44:00.196 Writing today.ini, LastUpdateTime = 09/04/2022 22:44:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:44:00.262 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:44:19.894 Done uploading standard Data file
2022-04-09 22:44:58.424 Realtime[222]: Warning, a previous cycle is still trying to connect to FTP server, skip count = 1
2022-04-09 22:44:58.424 Realtime[222]: No FTP attempted this cycle
2022-04-09 22:45:00.207 DoLogFile: Writing log entry for 09/04/2022 22:45:00
2022-04-09 22:45:00.209 DoLogFile: log entry for 09/04/2022 22:45:00 written
2022-04-09 22:45:00.212 Writing today.ini, LastUpdateTime = 09/04/2022 22:45:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:45:00.231 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:45:08.432 Realtime[223]: Warning, a previous cycle is still trying to connect to FTP server, skip count = 2
2022-04-09 22:45:08.432 Realtime[223]: No FTP attempted this cycle
2022-04-09 22:45:18.431 Realtime[224]: Warning, a previous cycle is still trying to connect to FTP server, skip count = 3
2022-04-09 22:45:18.431 Realtime[224]: No FTP attempted this cycle
2022-04-09 22:45:22.102 FTP[221]: Error uploading web/realtimegauges.txt to /cmx/realtimegauges.txt : Timed out trying to read data from the socket stream!
2022-04-09 22:45:22.106 Realtime[221]: Aborting this upload
2022-04-09 22:45:22.106 Realtime[221]: Error during realtime FTP update that requires reconnection
2022-04-09 22:45:22.106 RealtimeReconnect: Realtime ftp attempting disconnect
2022-04-09 22:45:22.106 RealtimeReconnect: Realtime ftp disconnected
2022-04-09 22:45:22.106 RealtimeReconnect: Realtime ftp attempting to reconnect
2022-04-09 22:45:23.130 RealtimeReconnect: Reconnected with server (we think)
2022-04-09 22:45:23.131 RealtimeReconnect: Realtime ftp testing the connection
2022-04-09 22:45:23.260 RealtimeReconnect: Realtime ftp connection test found Present Working Directory OK - [/]
2022-04-09 22:45:23.260 RealtimeReconnect: Realtime FTP now connected to server (tested)
2022-04-09 22:45:23.260 RealtimeReconnect: Realtime FTP operations will be restarted
2022-04-09 22:45:26.749 Done uploading graph data files
2022-04-09 22:45:26.750 FTP[Int]: Uploading daily graph data files
2022-04-09 22:45:26.750 FTP[Int]: Done uploading daily graph data files
2022-04-09 22:45:26.867 FTP[Int]: Process complete
2022-04-09 22:46:00.257 DoLogFile: Writing log entry for 09/04/2022 22:46:00
2022-04-09 22:46:00.259 DoLogFile: log entry for 09/04/2022 22:46:00 written
2022-04-09 22:46:00.262 Writing today.ini, LastUpdateTime = 09/04/2022 22:46:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:46:00.281 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:46:21.883 Done uploading standard Data file
2022-04-09 22:47:00.326 DoLogFile: Writing log entry for 09/04/2022 22:47:00
2022-04-09 22:47:00.341 DoLogFile: log entry for 09/04/2022 22:47:00 written
2022-04-09 22:47:00.344 Writing today.ini, LastUpdateTime = 09/04/2022 22:47:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:47:00.351 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:47:28.764 Done uploading graph data files
2022-04-09 22:47:28.764 FTP[Int]: Uploading daily graph data files
2022-04-09 22:47:28.764 FTP[Int]: Done uploading daily graph data files
2022-04-09 22:47:28.834 FTP[Int]: Process complete
2022-04-09 22:48:00.327 DoLogFile: Writing log entry for 09/04/2022 22:48:00
2022-04-09 22:48:00.328 DoLogFile: log entry for 09/04/2022 22:48:00 written
2022-04-09 22:48:00.332 Writing today.ini, LastUpdateTime = 09/04/2022 22:48:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:48:00.338 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.
2022-04-09 22:48:21.937 Done uploading standard Data file
2022-04-09 22:49:00.326 DoLogFile: Writing log entry for 09/04/2022 22:49:00
2022-04-09 22:49:00.327 DoLogFile: log entry for 09/04/2022 22:49:00 written
2022-04-09 22:49:00.329 Writing today.ini, LastUpdateTime = 09/04/2022 22:49:00 raindaystart = 129.9972 rain counter = 130.9116
2022-04-09 22:49:00.335 DoLogFile: Error encountered during MySQL operation = Unable to connect to any of the specified MySQL hosts.