SBFspotUpload not uploading after upgrading ubuntu 16.04

Topics: 5. Support
Apr 29, 2016 at 2:43 AM
Edited May 1, 2016 at 12:58 AM
Guys having issues after upgrading Ubuntu to 16.04 with the upload daemon.

I even recompiled the code yet still not uploading to pvoutput, my config files have not changed and data is still going into the mysql database.

seeing NULL in the db

mysql> SELECT * FROM DayData;
+------------+------------+------------+-------+----------+
| TimeStamp | Serial | TotalYield | Power | PVoutput |
+------------+------------+------------+-------+----------+
| 1461443400 | 2100481850 | 17785828 | 0 | NULL |
| 1461443700 | 2100481850 | 17785830 | 24 | NULL |
| 1461444000 | 2100481850 | 17785833 | 36 | NULL |
| 1461444300 | 2100481850 | 17785838 | 60 | NULL |


After building again for Sqlite3 and changing the database location everything is working, looks to be a mysql issues


cat SBFspotUpload.cfg
LogDir=/usr/local/bin/sbfspot.3/OUT
PVoutput_SID=2100481850:XXXX
PVoutput_Key=XXXXXXXXXXX
SQL_Database=/usr/local/bin/sbfspot.3/Sql.db

root@VC60:/usr/local/bin/sbfspot.3# tail -f ./OUT/SBFspotUpload20160501.log
[10:52:25] INFO: Starting SBFspotUploadDeamon Version 1.0.1
[10:52:25] INFO: Starting Daemon...
[10:52:27] INFO: Uploading 30 datapoints, starting with 20160501,08:20,17870423,372 => OK (200)
[10:53:31] INFO: Uploading datapoint: 20160501,10:50,17871283,564,,,54.4,238.67 => OK (200)
Marked as answer by eng1970 on 5/2/2016 at 3:09 PM
Coordinator
May 2, 2016 at 10:22 AM
It's confirmed as a bug. See issue 150
Jan 6 at 1:17 PM
Edited Jan 6 at 1:21 PM
Ok - Thanks. Worked to use the SQL code there!

:-)