ArchiveSW - Display & Data Archive Storage

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.

5 Likes

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 :slight_smile:

1 Like

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 :slight_smile:

1 Like

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.

5 Likes

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.

1 Like

That’s what I get too. I think @iladyman is one of David’s favorites and he got the super duper Hub.

3 Likes

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 :slight_smile:

1 Like

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? :slight_smile:

1 Like

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?

1 Like

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)

2 Likes

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.

1 Like

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?

1 Like

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

1 Like

Sorry for formatting, this is additionally in LOG

1 Like

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…

1 Like