Thank you, I have done all of the above, it was not so hard - backed up old database, put latest OS on new SD card, set up user and wifi, imported old database… all looks like it worked fine but unfortunately it is still not displaying that it is logging locally and is now also appears to not be uploading to EmonCMS.
emoncms.log
2018-03-20 19:27:58.344|ERROR|phpmqtt_input.php|exception 'Mosquitto\Exception' in /var/www/emoncms/scripts/phpmqtt_input.php:125
Stack trace:
#0 /var/www/emoncms/scripts/phpmqtt_input.php(125): Mosquitto\Client->connect('localhost', 1883, 5)
#1 {main}
2018-03-20 19:27:58.541|WARN|phpmqtt_input.php|Not connected, retrying connection
2018-03-20 19:28:04.002|WARN|phpmqtt_input.php|Not connected, retrying connection
2018-03-20 19:28:04.004|WARN|phpmqtt_input.php|Connecting to MQTT server: Connection Accepted.: code: 0
2018-03-20 19:28:11.957|WARN|phpmqtt_input.php|Not connected, retrying connection
2018-03-20 19:28:11.979|WARN|phpmqtt_input.php|Connecting to MQTT server: Connection Accepted.: code: 0
emonhub.log
2018-03-20 19:17:32,881 INFO MainThread EmonHub emonHub emon-pi variant v2.1.1
2018-03-20 19:17:32,883 INFO MainThread Opening hub...
2018-03-20 19:17:32,884 INFO MainThread Logging level set to DEBUG
2018-03-20 19:17:32,885 INFO MainThread Creating EmonHubJeeInterfacer 'RFM2Pi'
2018-03-20 19:17:32,889 DEBUG MainThread Opening serial port: /dev/ttyAMA0 @ 38400 bits/s
2018-03-20 19:17:34,896 INFO MainThread RFM2Pi device firmware version & configuration: not available
2018-03-20 19:17:34,898 INFO MainThread Setting RFM2Pi frequency: 433 (4b)
2018-03-20 19:17:35,900 INFO MainThread Setting RFM2Pi group: 210 (210g)
2018-03-20 19:17:36,903 INFO MainThread Setting RFM2Pi quiet: 0 (0q)
2018-03-20 19:17:37,905 INFO MainThread Setting RFM2Pi baseid: 5 (5i)
2018-03-20 19:17:38,908 INFO MainThread Setting RFM2Pi calibration: 230V (1p)
2018-03-20 19:17:39,911 DEBUG MainThread Setting RFM2Pi subchannels: ['ToRFM12']
2018-03-20 19:17:39,912 DEBUG MainThread Setting RFM2Pi pubchannels: ['ToEmonCMS']
2018-03-20 19:17:39,914 INFO MainThread Creating EmonHubMqttInterfacer 'MQTT'
2018-03-20 19:17:39,920 DEBUG MainThread Setting MQTT subchannels: ['ToEmonCMS']
2018-03-20 19:17:39,922 DEBUG MainThread Setting MQTT pubchannels: ['ToRFM12']
2018-03-20 19:17:39,923 INFO MainThread Setting MQTT nodevar_format_enable: 1
2018-03-20 19:17:39,925 INFO MainThread Setting MQTT node_format_enable: 1
2018-03-20 19:17:39,928 INFO MainThread Setting MQTT nodevar_format_basetopic: emon/
2018-03-20 19:17:39,931 INFO MainThread Creating EmonHubEmoncmsHTTPInterfacer 'emoncmsorg'
2018-03-20 19:17:39,934 DEBUG MainThread Setting emoncmsorg subchannels: ['ToEmonCMS']
2018-03-20 19:17:39,937 DEBUG MainThread Setting emoncmsorg pubchannels: ['ToRFM12']
2018-03-20 19:17:39,938 INFO MainThread Setting emoncmsorg url: https://emoncms.org
2018-03-20 19:17:39,940 INFO MainThread Setting emoncmsorg senddata: 1
2018-03-20 19:17:39,943 WARNING MainThread Setting emoncmsorg apikey: obscured
2018-03-20 19:17:39,945 INFO MainThread Setting emoncmsorg sendstatus: 1
2018-03-20 19:17:40,003 DEBUG RFM2Pi device settings updated: E i5 g210 @ 433 MHz q1 USA 0
2018-03-20 19:17:40,111 DEBUG RFM2Pi device settings updated: E i5 g210 @ 433 MHz q1 USA 0
2018-03-20 19:17:40,218 DEBUG RFM2Pi 1 NEW FRAME : OK 5 0 0 0 0 0 0 174 95 30 0 180 0 85 0 0 0 0 0 0 0 1 0 0 0 (-0)
2018-03-20 19:17:40,221 DEBUG RFM2Pi 1 Timestamp : 1521573460.22
2018-03-20 19:17:40,222 DEBUG RFM2Pi 1 From Node : 5
2018-03-20 19:17:40,223 DEBUG RFM2Pi 1 Values : [0, 0, 0, 244.94, 3, 18, 8.5, 0, 0, 0, 1]
2018-03-20 19:17:40,224 DEBUG RFM2Pi 1 Sent to channel(start)' : ToEmonCMS
2018-03-20 19:17:40,225 DEBUG RFM2Pi 1 Sent to channel(end)' : ToEmonCMS
2018-03-20 19:17:40,329 DEBUG RFM2Pi device settings updated: E i5 g210 @ 433 MHz q0 USA 0
2018-03-20 19:17:40,432 DEBUG RFM2Pi device settings updated: E i5 g210 @ 433 MHz q0 USA 0
2018-03-20 19:17:40,434 INFO MQTT Connecting to MQTT Server
2018-03-20 19:17:40,436 INFO MQTT Could not connect...
2018-03-20 19:17:40,541 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 6 121 255 192 234 131 220 68 64 217 69 179 3 109 211 221 120 16 194 6 111 (-100)
2018-03-20 19:17:40,554 DEBUG emoncmsorg Buffer size: 1
2018-03-20 19:17:40,645 DEBUG RFM2Pi device settings updated: E i5 g210 @ 433 MHz q0 USA 0
2018-03-20 19:17:40,754 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 16 186 241 64 50 83 200 92 62 220 120 241 4 28 76 185 116 177 245 213 59 (-106)
2018-03-20 19:17:40,865 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 4 98 42 126 60 36 39 115 18 178 99 187 219 95 106 10 233 16 9 179 102 (-109)
2018-03-20 19:17:42,686 DEBUG RFM2Pi 2 NEW FRAME : OK 5 0 0 0 0 0 0 11 96 30 0 180 0 85 0 0 0 0 0 0 0 1 0 0 0 (-0)
2018-03-20 19:17:42,689 DEBUG RFM2Pi 2 Timestamp : 1521573462.69
2018-03-20 19:17:42,690 DEBUG RFM2Pi 2 From Node : 5
2018-03-20 19:17:42,691 DEBUG RFM2Pi 2 Values : [0, 0, 0, 245.87, 3, 18, 8.5, 0, 0, 0, 1]
2018-03-20 19:17:42,692 DEBUG RFM2Pi 2 Sent to channel(start)' : ToEmonCMS
2018-03-20 19:17:42,693 DEBUG RFM2Pi 2 Sent to channel(end)' : ToEmonCMS
2018-03-20 19:17:42,801 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 7 124 213 192 91 165 117 55 47 229 100 2 38 239 36 42 150 230 248 52 150 (-101)
2018-03-20 19:17:42,947 INFO MQTT Connecting to MQTT Server
2018-03-20 19:17:42,949 INFO MQTT Could not connect...
2018-03-20 20:14:53,557 DEBUG emoncmsorg Buffer size: 1
2018-03-20 20:14:53,995 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 18 200 90 211 19 38 239 112 12 15 153 155 98 140 162 230 166 66 20 40 137 (-102)
2018-03-20 20:14:54,205 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 18 105 58 189 48 224 145 79 35 252 71 199 183 62 179 20 150 0 78 185 215 (-105)
2018-03-20 20:14:56,222 DEBUG RFM2Pi 3 NEW FRAME : OK 5 0 0 0 0 0 0 175 95 30 0 180 0 85 0 0 0 0 0 0 0 1 0 0 0 (-0)
2018-03-20 20:14:56,225 DEBUG RFM2Pi 3 Timestamp : 1521576896.22
2018-03-20 20:14:56,226 DEBUG RFM2Pi 3 From Node : 5
2018-03-20 20:14:56,227 DEBUG RFM2Pi 3 Values : [0, 0, 0, 244.95000000000002, 3, 18, 8.5, 0, 0, 0, 1]
2018-03-20 20:14:56,232 DEBUG RFM2Pi 3 Sent to channel(start)' : ToEmonCMS
2018-03-20 20:14:56,233 DEBUG RFM2Pi 3 Sent to channel(end)' : ToEmonCMS
2018-03-20 20:14:56,302 INFO MQTT Connecting to MQTT Server
2018-03-20 20:14:56,305 INFO MQTT Could not connect...
2018-03-20 20:14:59,055 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 5 73 164 32 146 237 227 175 21 104 192 75 100 152 164 32 30 127 107 226 189 (-105)
2018-03-20 20:14:59,669 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 24 208 159 52 243 141 160 34 136 106 40 240 100 152 164 32 30 127 107 226 189 (-110)
2018-03-20 20:15:01,285 DEBUG RFM2Pi 4 NEW FRAME : OK 5 0 0 0 0 0 0 135 95 30 0 180 0 85 0 0 0 0 0 0 0 1 0 0 0 (-0)
2018-03-20 20:15:01,289 DEBUG RFM2Pi 4 Timestamp : 1521576901.28
2018-03-20 20:15:01,290 DEBUG RFM2Pi 4 From Node : 5
2018-03-20 20:15:01,291 DEBUG RFM2Pi 4 Values : [0, 0, 0, 244.55, 3, 18, 8.5, 0, 0, 0, 1]
2018-03-20 20:15:01,292 DEBUG RFM2Pi 4 Sent to channel(start)' : ToEmonCMS
2018-03-20 20:15:01,293 DEBUG RFM2Pi 4 Sent to channel(end)' : ToEmonCMS
2018-03-20 20:15:01,334 INFO MQTT Connecting to MQTT Server
2018-03-20 20:15:01,337 INFO MQTT Could not connect...
2018-03-20 20:15:01,420 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 6 101 114 205 59 214 137 161 167 102 157 20 24 97 244 238 156 0 211 131 228 (-101)
2018-03-20 20:15:01,631 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 23 114 232 221 92 3 2 153 133 23 157 20 24 97 244 238 156 0 211 131 228 (-103)
2018-03-20 20:15:04,048 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 19 109 50 178 132 55 6 43 139 245 143 9 145 131 55 151 252 116 16 111 83 (-101)
2018-03-20 20:15:04,158 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 8 55 98 173 8 21 6 43 139 245 143 9 145 131 55 151 252 116 16 111 83 (-108)
2018-03-20 20:15:05,184 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 5 96 61 144 169 70 227 76 134 209 10 88 19 211 16 6 128 28 63 185 64 (-111)
2018-03-20 20:15:06,297 DEBUG RFM2Pi 5 NEW FRAME : OK 5 0 0 0 0 0 0 159 95 31 0 180 0 85 0 0 0 0 0 0 0 1 0 0 0 (-0)
2018-03-20 20:15:06,301 DEBUG RFM2Pi 5 Timestamp : 1521576906.3
2018-03-20 20:15:06,302 DEBUG RFM2Pi 5 From Node : 5
2018-03-20 20:15:06,302 DEBUG RFM2Pi 5 Values : [0, 0, 0, 244.79, 3.1, 18, 8.5, 0, 0, 0, 1]
2018-03-20 20:15:06,303 DEBUG RFM2Pi 5 Sent to channel(start)' : ToEmonCMS
2018-03-20 20:15:06,304 DEBUG RFM2Pi 5 Sent to channel(end)' : ToEmonCMS
2018-03-20 20:15:06,364 INFO MQTT Connecting to MQTT Server
2018-03-20 20:15:06,469 INFO MQTT connection status: Connection successful
2018-03-20 20:15:06,471 DEBUG MQTT CONACK => Return code: 0
2018-03-20 20:15:06,573 INFO MQTT on_subscribe
2018-03-20 20:15:07,230 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 0 208 118 175 196 206 42 121 76 233 240 213 237 224 5 161 234 82 106 120 111 (-99)
2018-03-20 20:15:07,943 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 11 37 202 50 150 205 200 57 221 128 48 143 6 45 96 147 120 40 87 108 112 (-102)
2018-03-20 20:15:08,155 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 17 224 151 111 11 117 17 143 249 96 230 28 123 59 223 176 99 160 23 12 144 (-101)
2018-03-20 20:15:08,570 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 4 17 208 34 248 23 126 94 20 232 216 46 32 28 181 193 5 136 30 15 249 (-102)
2018-03-20 20:15:11,305 DEBUG RFM2Pi 6 NEW FRAME : OK 5 0 0 0 0 0 0 177 95 30 0 180 0 85 0 0 0 0 0 0 0 1 0 0 0 (-0)
2018-03-20 20:15:11,309 DEBUG RFM2Pi 6 Timestamp : 1521576911.31
2018-03-20 20:15:11,310 DEBUG RFM2Pi 6 From Node : 5
2018-03-20 20:15:11,311 DEBUG RFM2Pi 6 Values : [0, 0, 0, 244.97, 3, 18, 8.5, 0, 0, 0, 1]
2018-03-20 20:15:11,311 DEBUG RFM2Pi 6 Sent to channel(start)' : ToEmonCMS
2018-03-20 20:15:11,312 DEBUG RFM2Pi 6 Sent to channel(end)' : ToEmonCMS
2018-03-20 20:15:11,401 DEBUG MQTT Publishing: emon/emonpi/power1 0
2018-03-20 20:15:11,403 DEBUG MQTT Publishing: emon/emonpi/power2 0
2018-03-20 20:15:11,404 DEBUG MQTT Publishing: emon/emonpi/power1pluspower2 0
2018-03-20 20:15:11,406 DEBUG MQTT Publishing: emon/emonpi/vrms 244.97
2018-03-20 20:15:11,407 DEBUG MQTT Publishing: emon/emonpi/t1 3
2018-03-20 20:15:11,409 DEBUG MQTT Publishing: emon/emonpi/t2 18
2018-03-20 20:15:11,410 DEBUG MQTT Publishing: emon/emonpi/t3 8.5
2018-03-20 20:15:11,412 DEBUG MQTT Publishing: emon/emonpi/t4 0
2018-03-20 20:15:11,417 DEBUG MQTT Publishing: emon/emonpi/t5 0
2018-03-20 20:15:11,419 DEBUG MQTT Publishing: emon/emonpi/t6 0
2018-03-20 20:15:11,421 DEBUG MQTT Publishing: emon/emonpi/pulsecount 1
2018-03-20 20:15:11,423 INFO MQTT Publishing: emonhub/rx/5/values 0,0,0,244.97,3,18,8.5,0,0,0,1
2018-03-20 20:15:11,428 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 0 20 246 167 178 205 247 114 227 131 242 203 126 147 74 159 249 239 31 228 155 (-110)
2018-03-20 20:15:11,641 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 22 62 160 31 218 9 234 20 73 172 171 144 131 183 113 48 112 128 196 239 40 (-105)
2018-03-20 20:15:11,852 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 27 206 74 108 176 243 144 223 161 48 115 38 116 160 241 242 90 61 20 202 96 (-107)
2018-03-20 20:15:14,710 DEBUG RFM2Pi Discarding RX frame 'unreliable content'? 10 36 121 108 121 149 185 219 166 2 100 54 112 214 50 101 239 78 235 77 123 (-100)
I’m rery much at the limit of my understanding, please help.