|
Post by doxidad on Jun 17, 2023 12:00:56 GMT -8
What version of WeatherSense are you running? The current version in github is V018 February 2,2022 Did you install python-aqi If not - use this command: sudo pip install python-aqi
See if that fixes the problem.
If not, post the output you get while trying to run the program.
|
|
|
Post by doxidad on May 8, 2023 13:02:29 GMT -8
There is a small hole on he bottom of the box that is for condensation. It should not be sealed (I think that is mentioned in the documentation somewhere).
|
|
|
Post by doxidad on Feb 5, 2023 4:45:12 GMT -8
Your battery voltage is low < 3v The value of 6 in auxa is translated as Low battery, Solar present, and controller present.
|
|
|
Post by doxidad on Oct 27, 2022 13:18:19 GMT -8
Whoops- eyes and finger not in sync.
sudo python WeatherSenseMonitor.py
|
|
|
Post by doxidad on Oct 27, 2022 8:00:45 GMT -8
Check the WeatherSenseWireless database to see if the tables were created Example:
pi@WPI2:~/SDL_Pi_WeatherSense $ sudo mysql -u root -p WeatherSenseWireless Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 26110 Server version: 10.3.36-MariaDB-0+deb10u2 Raspbian 10
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [WeatherSenseWireless]> show tables; +--------------------------------+ | Tables_in_WeatherSenseWireless | +--------------------------------+ | AQI433MHZ | | AS433MHZ | | Generic | | IndoorTHSensors | | RAD433MHZ | | SkyCamPictures | | SkyCamSensors | | SolarMax433MHZ | | TB433MHZ | | WeatherData | +--------------------------------+ 10 rows in set (0.001 sec)
If the tables are present the database should be OK.
The WeatherSenseWireless.sql script only needs to be run one time to create the database and tables.
What errors do you get when you execute
sudo python WeatherSenseWireless.py
|
|
|
Post by doxidad on Oct 14, 2022 16:52:07 GMT -8
I had the same problem last spring. It was a oak flower in the bottom of the funnel. I had a problem getting the funnel off too. I just kept working at it until I got it to free. It has some tight tolerances and being plastic you need to keep trying.
|
|
|
Post by doxidad on Aug 7, 2022 16:06:40 GMT -8
Did you install python3-mysqldb ?
|
|
|
Post by doxidad on Jun 25, 2022 2:51:38 GMT -8
|
|
|
Post by doxidad on Jun 24, 2022 16:34:13 GMT -8
Your making progress. I would assume that you would at least need SolarMax433MHZ
If I do show tables on my WeatherSenseWireless I get the following
MariaDB [WeatherSenseWireless]> show tables; +--------------------------------+ | Tables_in_WeatherSenseWireless | +--------------------------------+ | AQI433MHZ | | AS433MHZ | | Generic | | IndoorTHSensors | | RAD433MHZ | | SkyCamPictures | | SkyCamSensors | | SolarMax433MHZ | | TB433MHZ | | WeatherData | +--------------------------------+ 10 rows in set (0.001 sec)
|
|
|
Post by doxidad on Jun 23, 2022 4:21:36 GMT -8
I just looked and yep the alter statements are in the current repository.
They shouldn't be there in that spot for tables that don't exist yet.
I have an older version without the alter statements so couldn't figure out why they are present.
If you want to use that script, comment out the alter statements with '--' and run it again and it should work.
edit it with nano
nano WeatherSenseWireless.sql
Hey BP!! This is a problem for those that are trying to create tables using this script!! (WeatherSenseWireless.sql)
|
|
|
Post by doxidad on Jun 22, 2022 16:48:48 GMT -8
You can use the more command to look at text files (.sql file is a text file).
more WeatherSenseWireless.sql
Will display the file. Use the enter key to move by line or a space bar to move by 1 page at a time. See man more for complete explanation.
If what you posted is the contents of WeatherSenseWireless.sql, the first 6 alter statements will cause an error since they are trying to alter the the columns in the tables that don't exist yet.
|
|
|
Post by doxidad on Jun 21, 2022 16:47:58 GMT -8
That's strange. That script should have created the tables if they didn't exist. If you look at the script, what version is do you have. Here is the version I have: 1 -- phpMyAdmin SQL Dump 2 -- version 4.9.1 3 -- www.phpmyadmin.net/ 4 -- 5 -- Host: localhost:3306 6 -- Generation Time: Jan 30, 2021 at 10:00 AM 7 -- Server version: 10.3.23-MariaDB-0+deb10u1 8 -- PHP Version: 7.3.19-1~deb10u1
After checking to see if the database exists it checks for the tables and if they don't they are created.
Example - if table AQI433MHZ doesn't exist - create it
33 CREATE TABLE IF NOT EXISTS `AQI433MHZ` ( 34 `ID` int(11) NOT NULL, 35 `timestamp` timestamp NOT NULL DEFAULT current_timestamp(), 36 `messageID` int(11) NOT NULL, 37 `deviceid` int(11) NOT NULL, 38 `protocolversion` int(11) NOT NULL, 39 `softwareversion` int(11) NOT NULL, 40 `weathersenseprotocol` int(11) NOT NULL, 41 `PM1_0S` int(11) NOT NULL, 42 `PM2_5S` int(11) NOT NULL, 43 `PM10S` int(11) NOT NULL, 44 `PM1_0A` int(11) NOT NULL, 45 `PM2_5A` int(11) NOT NULL, 46 `PM10A` int(11) NOT NULL, 47 `AQI` int(11) NOT NULL, 48 `AQI24Hour` float NOT NULL, 49 `batteryvoltage` float NOT NULL, 50 `batterycurrent` float NOT NULL, 51 `loadvoltage` float NOT NULL, 52 `loadcurrent` float NOT NULL, 53 `solarvoltage` float NOT NULL, 54 `solarcurrent` float NOT NULL, 55 `auxa` int(11) NOT NULL, 56 `batterycharge` float NOT NULL, 57 `batterypower` float NOT NULL, 58 `loadpower` float NOT NULL, 59 `solarpower` float NOT NULL, 60 `test` text NOT NULL, 61 `testdescription` text NOT NULL 62 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 63
|
|
|
Post by doxidad on Jun 21, 2022 3:22:39 GMT -8
Whoops! It should be
sudo mysql -p -u root WeatherSenseWireless < WeatherSenseWireless.sql
I forgot the database name. Note to self: Read what you write before committing it!
|
|
|
Post by doxidad on Jun 20, 2022 17:25:51 GMT -8
sudo mysql -p -u root < WeatherSenseWireless.sql
|
|
|
Post by doxidad on Jun 20, 2022 16:34:00 GMT -8
Use the script WeatherSenseWireless.sql
It won't try to re-create the the WeatherSenseWireless database if it already exists.
It will check to see if the tables needed are present and if not it will creates them.
|
|