|
Post by doxidad on Sept 13, 2019 3:46:40 GMT -8
I may have missed this - did create a root password in MariaDB? If you didn't and are trying to use phpmyadmin - that could be your problem. The fork of mysql (Maria) doesn't ask you to create a root password. You must create it manually. See articles on creating root password on MariaDB
|
|
|
Post by doxidad on Sept 4, 2019 4:22:33 GMT -8
Nice ^^
To add to handy things - here's something that has followed me around for the past 30+ years.
Here's a little command I called psg (ps and grep).
#!/bin/bash ps ax | grep $1 | grep -v grep | grep -v psg
Create these 2 lines in a file called psg in your bin directory (~pi/bin) - if bin doesn't exist created it with mkdir bin then change the the protection on the file psg to be executable chmod 755 psg
Since your bin directory is in your path you should be able to just type psg python at the prompt to find if python is running or any other program that you would like (or string).
What the script does is executes the ps command and searches for the string you entered (that's the $1) and then removes anything from the output with the string grep and then the same with the string psg so you only get what you are searching for not the commands that you are using to do the search.
Hopefully somebody will find this useful.
|
|
|
Post by doxidad on Aug 18, 2019 12:08:32 GMT -8
I found another one. I reported this on the GWP Blynk code a while back and it is in this code also
In updateBlynk.py the line that formats V56 (the gauge on the solar screen) has a "%" in the format code that causes the gauge not to display.
IS -> val = "{0:0.1f}%".format(state.batteryCharge) SHOULD BE -> val = "{0:0.1f}".format(state.batteryCharge)
|
|
|
Post by doxidad on Aug 17, 2019 11:15:23 GMT -8
Here are couple of things that need to be remediated in V045
startserver.sh contains the wrong directory and code
#!/bin/bash cd /home/pi/SDL_Pi_GroveWeatherPi sudo python GroveWeatherPi.py
PowerCurrentGraph.py & PowerVoltageGraph.py still use axisbg for the background color.
In the older version of the matplotlib, it barked about this being depreciated but it didn't cause any problems other than the message. In the latest version of the matplotlib (v 2.2.3-6) it causes an exception with no explanation other than it doesn't know about axisbg.
axisbg needs to be replaced with facecolor or the 2 Power Graphs will never run.
Also, BarometerLightningGraph.py still multiplies the barometer reading * 10 causing it not to be displayed since it is over ranged for the graph.
Sorry to whine, but somebody may want to use the graphs or the contents an startserver and not know what the problem is.
|
|
|
Post by doxidad on Aug 14, 2019 14:23:30 GMT -8
I came home today to find everything down. Down meaning nothing powered. No LEDs lit on boards including the suncontrol.
Configuration -
WeatherSky with SunControl (was an upgrade to GWP)
Battery reads 4.1v
5v wall wort connected.
NO solar cells - I have them just not in use yet -need to make mount for them.
This has been running this way for over a year - I know WeatherSky hasn't been out that long but it was on a
GWP set up the same way. This has been running in my family room running on a desk.
So the checks - Battery V4.1 when not plugged in to the board. The wall wort puts out a tad above 5V. Plugging in the wall wart into the board causes the wall wart voltage to go to 0 as read at the board + the LED on the wall wart goes out.
Somethings not happy and yes i did try 2 other 5v sources.
The suncontrol was ordered right after they were announced.
Suggestions?
Thanks TR
|
|
|
Post by doxidad on Aug 11, 2019 10:00:32 GMT -8
We do something similar everyday on a production databases at work. We make batches of stuff and everything that goes into making it - raw materials, chemistries, events and tracking of production is recorded in a L2 database and chemistry database. To complicate things the batches then make a lot of smaller things that need to be kept. That's a lot of data per batch and children of stuff. We make about 40-45 batches a dayof this stuff 365 days/year so it adds up. We trim it back by either date (chemistries) or number of batches kept in L2. Not even going into the environmental data that needs to be kept for 7+ years.
Not a bad thing to do - also the DB should be backed up or exported somewhere other than the SD card on a schedule. SD cards do go bad without warning - I've had a couple go to computer heaven just doing normal things like SkyWeather does. phpMyAdmin can export the whole database in a file suitable to rebuild the database including data up to the point when the export was done. If you are accessing phpMyAdmin from a PC you can have it store the export zipped up on the PC.
Good post. Thanks for reminding me (and others?)
|
|
|
Post by doxidad on Jul 31, 2019 14:57:50 GMT -8
In the graphs directory BarometerLightning.py has an error that prevents the barometer values from displaying. for i in range(len(s)): s = s * 10
Causes the values to over range and not be displayed. Comment it out if you want the Barometer readings to be displayed.
Hmmmm... I thought I reported this a long time ago in the GWP code. Could you make the changes in this code base and also in the GWP (it's still has it in it).
Thanks
|
|
|
Post by doxidad on Jul 4, 2019 8:14:41 GMT -8
Check out the MariaDB (MySql) documentation site. You can set the timezone for the database on how timestamps are stored.
|
|
|
Post by doxidad on Jun 20, 2019 14:28:55 GMT -8
From Docs - Part A - One of - Bud Box Enclosure - BUD Industries NBB-22241 Style B Plastic NEMA Box with Solid Indoor, 10-23/32" Length x 6-25/32" Width x 4-21/64" Height Amazon link amzn.to/2DdP6RU
|
|
|
Post by doxidad on May 28, 2019 4:47:04 GMT -8
This is odd. I have never experienced this with our GWP systems and then run for months. Is this custom software or out of box? BP This is out of the box GWP software. Doesn't happen frequently, but does happen.
|
|
|
Post by doxidad on May 23, 2019 6:54:40 GMT -8
My colleague printed a transparent hood which now shows me, the led i=on the detector burning permanently??? That happens to me once in awhile. It's like the interrupt is never handled/missed by the Pi. Of course the only way to fix it is to restart the application.
|
|
|
Post by doxidad on Mar 28, 2019 16:14:32 GMT -8
Whats the chances of getting a GrovePowerSave? From a post above... ------------- Free Grove PowerSave for you folks ------------- The next time you order from SwitchDoc Labs, mention you have had this problem and we will include a grove power save with two Grove cables free with your order.
I ordered a powersave to control my oled and a new mica window for the sunlight sensor. On my request SDL included the offered free powersave.
Thanks I know I can request one for free when ordering but I don't need to order anything for a, while. I was inquiring if I could receive one without ordering
|
|
|
Post by doxidad on Mar 28, 2019 8:47:18 GMT -8
Whats the chances of getting a GrovePowerSave?
|
|
|
Post by doxidad on Mar 27, 2019 5:43:16 GMT -8
blynkinit is looking for a file called EnglishMetric.txt to see how you want to display your values - English or Metric. If it doesn't find this file it gives you the error you are seeing and then defaults to english. The file, if I recall correctly, either has a "1" or a "0" in it to specify which to use.
Blynk works without this file and defaults to English.
|
|
|
Post by doxidad on Feb 11, 2019 13:31:23 GMT -8
Actually, the changes I made have nothing to do with the AM2315.
Sorry you took it that I had made some great discovery. Wish I did!.
I should have said things differently. 314 seems to be fairly stable for me.
I did see the large negative numbers - Not sure how they were getting through since you have a clamp at -1000.
|
|