Yes. That is the way I designed it. In the future I want to detect the display and send the proper selected files to each device. The minions are in the backroom working.
Hi @GaryFunk,
Further testing of my Hub power requirements: 71.5hours, 2033mAh, 5.08V = 28.4mA=144mW. Hub RSSI -62, Air -66, Sky -59. I have ordered another USB power monitor to double check these readings.
cheers Ian
That seems too good to be true but I cannot dispute your readings.
@dsj May I please get a super Hub like Ian has?
Hi @GaryFunk,
Brilliant. Now I am being lazy by asking you this next question rather than researching for the answer myself. Can I access the database from another computer on the same network? If so then I may relatively easily generate my graphs etc using excel which I am very familiar with.
cheers Ian
Yes. Any application that is capable of accessing a MySQL database will work. It uses the standard 3306 port and the same user and password that is in your config file.
My rough testing came up with about 400mW but my USB power meter shows a current of 0.07-0.09A but mostly 0.08A at 5.18V, still in the 400mW range.
That’s what I get too. I think @iladyman is one of David’s favorites and he got the super duper Hub.
Hi @GaryFunk,
It will be a while before I get my second backup USB power monitor. In the mean time I wonder what might change the results. My RSSI readings? and I do not have any bluetooth running. Perhaps my meter being digital is not registering it accurately.
You know the raspberry pi monitors power output and limits output to its ports, I couldnt find how to get that data from the operating system???
But it will be nice if we discover a low power design option
cheers Ian
I am going to open up the USB cable to measure the current flow with a Fluke 287. I’ll either get a true reading or I’ll blow up a power supply and maybe the Hub. What could possible go wrong?
Just start receiving those messages:
2019-01-31 13:00:02 Starting DailyStats v1.7.15.030
2019-01-31 13:00:02 Error in updateDailyAirRecord ER_BAD_FIELD_ERROR: Unknown column ‘NaN’ in ‘field list’
2019-01-31 13:00:07 No errors encountered
Nothing was changed in database by me. database and files are up to date (latest version). Any idea what is happening?
I measured with my powerbank and that reads 0.1 A at 5.01 V (current goes only in 0.1 A units, so it can be anywhere between 0.05 and 0.15 A, assuming it rounds correctly)
I have no idea. Try running AlterTables.
I tried already, also tried to run repairtable.js but result is same. What kind of column is NaN? I will add it manualy.
NaN is not a field in any table. It’s an error meaning Not a Number.
Something else is happening to cause that error.
For last two days in DailyAir below field are empty: TempHD, TempLD, PressHD, PressLD and all fields right from PressLD. Does this saying something usefull?
Run UpdateFiles from the About tab. I added some new error output in dailystats.js that should show the error.
You can manually run dailystats from a terminal window and then look at the log file to see the output.
2019-01-31 19:04:14 Error in updateDailyAirRecord ER_BAD_FIELD_ERROR: Unknown column ‘NaN’ in ‘field list’ 2019-01-31 19:04:14UPDATE DailyAir SET insert_datestamp = NOW(), tempH = 1.33,tempHT = 1548939007,tempHD = ‘2019-01-31 13:50:07’,tempL = -0.29,tempLT = 1548907278,tempLD = ‘2019-01-31 05:01:18’,presH = 980,presHT = 1548957784,presHD = ‘2019-01-31 19:03:04’,presL = 975.9,presLT = 1548904639,presLD = ‘2019-01-31 04:17:19’,humH = 0,humHT = 1548889226,humHD = ‘2019-01-31 00:00:26’,humL = 0,humLT = 1548889226,humLD = ‘2019-01-31 00:00:26’,strikeH = 0,strikeHT = null,strikeHD = null,strikeTotal = 0,strikeTime = 0,strikeDistance = 0,dewH = NaN,dewHT = 1548889226,dewL = NaN,dewLT = 1548889226,airdenH = NaN,airdenHT = 1548889226,airdenL = NaN,airdenLT = 1548889226,denaltH = NaN,denaltHT = 1548889226,denaltL = NaN,denaltLT = 1548889226 WHERE today = ? AND serial_number = ? 2019-01-31 19:04:16 No errors encountered
Sorry for formatting, this is additionally in LOG
For some strange reason, your Humidity High and Low is 0 (zero) which is not possible.
Yes, I just discovered that, started few days ago. Dropping from 90 to 40, then decreasing to 0 over time. Currently humidity reading is 0. Maybe sensor is dead…