After my fresh install today, the temp and humidity values on the Dashboard are not updating. They are stuck at 23 C and 72% humidity.

In addition, the chart isn't updating.

The sensor diagnostic returns "all good."

BTW, I think this problem began after I install the updates from a couple days ago -- so it is probably not an issue with the most recent updates.

The dialog came up and the options were yes and no. What's the best response?

At the bottom of https://github.com/fruxefarms/FruxePi#launch-app, would it make sense to add:

How do I find my Pi's IP address? 
[Check out the following link](https://learn.adafruit.com/adafruits-raspberry-pi-lesson-3-network-setup/finding-your-pis-ip-address)

This had me stumped for a while (because of the quantity of IP address-looking numbers with sudo ifconfig).

Or maybe it would be better to just put a link in the new docker-install section to the section created previously which has details about adding users and turning on sensors.

After running sudo apt-get install phpmyadmin -y a dialog box appeared that looked like this:

I presume the correct thing to do was to hit ENTER, which selects apache2.

Adding those instructions may help.

I'm referring to this line in the documentation:

Make sure that the following fields are set properly with your MYSQL database credentials.

'hostname' => 'localhost:3306',
'username' => 'frxpi',
'password' => 'password',
'database' => 'frx_db',

I merely changed 'password' to match what I used elsewhere. Do I need to update any of these other variables?

I hope you don't mind me layering on several feature requests!!

I'm trying to figure out the best way to automate watering with FruxePi. I've not had much luck with getting soil moisture meters to work reliably (they corrode/fail and aren't very accurate). Plus, sometimes plants need to be dry for a period before being re-watered (obviously, this could be programmed in concert with a reliable, accurate moisture meter). In my experience, moisture probes are great to monitor general trends, alert possible problems, and play with, but not great for keeping plants alive! I like the idea that FruxePi supports moisture meters, but I think there are other ways to program watering.

I like the idea of watering based on a schedule. FruxePi's Pump settings currently gets close (i.e, it allows once per day at a specified time with a duration in minutes). The duration setting is perfect, but I need more options for scheduling. Depending on conditions and plants, the water schedule varies significantly. Here's some examples:

-- 2 times/day
-- 5 times/day
-- Once per day
-- On Mondays and Thursdays

Would it be possible to add a more fully featured scheduler for the pump?

I have four other, related requests, if the above is possible:

1. Add support for additional pumps (I sometimes have up 10 zones, with different watering needs).
2. I like the idea of controlling low-voltage, battery-powered solenoids (that would switch on/off pressured water). This is how my current system works -- a standalone controller sets a schedule/duration and then switches solenoids on and off. The relay hardware setup that the Pump feature currently supports could work for solenoids -- but a kit of solenoids and battery power supply would be ideal. I'd buy this for the right price!
3. Finally, I like my current hardware controller for a couple of reasons, which I dream that far-off future versions of FruxePi will support -- hardware on/off buttons for "manual" watering.
4. A "rain delay" feature, which cancels the next set of scheduled waterings with a single button press (or in Version 19, it could be based on an API query of tomorrow's local weather forecast...for example, IF chance of rain > 90%, NO water tomorrow). Obviously this is for growing outside on the "farm."

That's my two cents!

I think it should just be moved up a couple lines to before:

sudo mysql -u frxpi -p frx_db < /var/www/html/db/frx_db.sql

More of a request than an issue.

Being able to pull from more than 1 heat/humidity sensor, moisture sensor and control more than one fan, set of lights or pump

After I enter the login screen (where I entered the default username and password), I get the following:

FruxePi » A Database Error Occurred
Error Number: 1146

Table 'frx_db.users' doesn't exist

SELECT `email`, `email`, `id`, `password`, `active`, `last_login` FROM `users` WHERE `email` = '[email protected]' ORDER BY `id` DESC LIMIT 1

Filename: models/Ion_auth_model.php

Line Number: 1038

I re-updated twice, today, after the latest commit (f6781fa) and the same error occurred

Ignore this!

Self-explanatory. I don't mind the Celcius but I know others who will be looking would prefer Fahrenheit.

On Technical » Pump

The "Manual Controls" language isn't consistent with the slider switch.

Changing the label from "On/Off" to "Off/On" seems better to me.

Also, it would be good to change this on the other controllable items, so the change is needed on:

• Lights
• Fans
• Pump

Hi!

Sometimes, the DHT22 gives wildly inaccurate readings. This seems to be caused by the hardware of the DHT22...especially in the case of humidity. This is usually momentary and it returns to normal ranges quickly. The problem is that the values can be so high that it throws off the hourly average -- for example, one hour shows an impossibly high relative humidity of 123%.

A simple way to handle this may be to use median instead of mean for calculating the hourly temp and humidity "central tendency."

Another way would be to constrain the range for each fetch. Although this could make troubleshooting difficult, it would also serve to unnecessarily switch off/on fans. I think I prefer this approach, although I'm not certain how best to constrain the range.

What do you think?

I don't think the fan (and pump) schedules are working.

Doesn't fruxepi.py need to import time so that time.sleep(timeInterval) works?

The install bash script gave this error:

pi@raspberrypi:~/FruxePi $ sudo bash install.sh

FruxePi v0.2-BETA Install
version: frx-pi-v0.2-BETA
web: docs.fruxe.co

Getting Latest Updates...
Installing required packages..
Building Docker containers... This will take several minutes.
Configuring Docker containers...
Error! Unable to configure Docker images.

This only occurred on one of my Raspberry Pi's (the other one has the login error at the moment, but the installation occurs without this error).

I've checked for differences in the OS and done updates of the OS and packages, but I still get the install error.

I looked for differences between my two Pi's using the following commands and found no differences. Both machines look the same, according to these commands:

lsb_release -a
Description: Raspbian GNU/Linux 9.8 (stretch)

hostnamectl
Linux 4.14.98-v7+

And to see if disk space was a problem:
df -h
(this showed more than 20 gb of available space)

cat /sys/firmware/devicetree/base/model
Raspberry Pi 3 Model B Plus Rev 1.3

docker version
Version: 18.09.0

One difference is that they are on different wifi networks, but I'm not able to test across on both.

I've set my local machine to use the timezone in which I live. However, the dashboard is off, presumably because it is using UTC. Running date inside the docker container is different than running date at the pi@raspberrypi:~ $ prompt.

I tried to change it with this:

sudo docker exec -it frxpi-APACHE bash
echo Europe/Stockholm >/etc/timezone && \
dpkg-reconfigure -f noninteractive tzdata

and then this:

sudo docker exec -it frxpi-MYSQL bash
echo Europe/Stockholm >/etc/timezone && \
dpkg-reconfigure -f noninteractive tzdata

Instead of "Europe/Stockholm" you'd enter your timezone from here.

Now, the dates match inside the docker containers and the host...however, the dashboard still displays the wrong date.

I guess, ideally this would be done via Docker. Ideas about how to do this in Docker-Compose are here.

Technical » Camera » Take Photo works wonderfully. However, clicking on the camera icon on the dashboard page just pulls up the stock image.

nano database.php didn't work for me

sudo nano database.php did.

Update documentation?

Under Codeigniter Config there is the following instruction:

Open the Codeigniter database.php config file in the /frx-pi/application/config/ folder

However, it was unclear to me how to do that. Here's what worked for me:

$ cd /var/www/html/application/config
$ nano database.php

Then scroll to the bottom of the file.

I just did a fresh install and the chart isn't updating with new data. Are you still working on this?

The power to my Raspberry Pi was cut off and on unexpectedly today. After the reboot, the temp/humidity and the chart stopped updating. Can anything be done to make a power failure not cause havoc? Or is a sequence of things possible to do to recover settings and data?

Maybe I'm dreaming again, but my Pi is outside in the greenhouse, and this kind of thing will happen, unfortunately.

The chart is stuck with old data.

I'm trying to troubleshoot the following error when I try to the Fruxe frontend via a web browser (currently I receive a an error like: "192.168.2.19 refused to connect.").

One thing I noticed is that the directory structure didn't exactly match the installation structure.

Of note, I located database.php file in this folder:

/var/www/html/application/config

Whereas the installation instructions said it would be here:

/frx-pi/application/config/

On my machine, I don't seem to have that path.

On the Technical -> Lights page, e.g., there is a toggle button for "Enable/Disable Probe." I think removing "Probe" for Lights (and Fans and Pump) would be more intuitive -- because these are not exactly probes.

Removing the word "Probe" from all the button labels might make the most sense (and be the easiest).

When attempting to log into the dashboard it cycles and doesn't log in no matter what is put into the UID and password fields. No errors or messages are present.
I have verified in the DB that the correct email is present. I also pulled the hash and verified that it matches with the password provided.

Below is what I did to remove the prior beta version of Fruxe-Pi in preparation for installing the newer version. I'm not totally sure ALL of this is needed, but thought I'd document what I did. Maybe something like this could be added to the documents at some point.

List the docker containers:

sudo docker ps

Stop and then remove the dockers, by ID, that showed up in the list above:

sudo docker stop [insert docker ID here, without brackets]
sudo docker [insert docker ID here, without brackets]

Remove the volumes that stored the database (you may be able to keep this, to keep the data you collected up to this point)

List the volumes:

sudo docker volume ls

Remove the volume (assuming the name is docker_db_data):

sudo docker volume rm docker_db_data

Remove the folder where the git downloads the docker into:

cd
sudo rm -r FruxePi

I have grandiose ideas about how to make the charts on the dashboard more user friendly and informative. Here's some:

1. Switch the direction of the x-axis, so that later in time appears on the right. Here's an example.
2. Remove the seconds on the x-axis -- less data is less confusing.
3. Remove the year on the x-axis.
4. For U.S. Americans, the most common date format is MM-DD (e.g., Mar. 20). Time format is almost always 12-hour (with AM and PM, e.g., 10:30pm). Having the ability to change the date/time format to "American" would be ideal...but I'm not sure that make sense.
5. Separate temperature and humidity onto different charts -- overlapping the data, as currently is the case, makes it difficult to read because there are 2 y-axis labels. I'd put temperature above and humidity below. Here's an example.
6. Reduce the vertical size of the charts to about 3/5 of the current height.
7. Add additional charts (maybe with a checkbox to select the relevant ones):
   -- soil moisture over time just like temp and humidity
   -- off and on status change of fans (e.g. Fan turned on at 10am, was off at noon, was back on at 5pm and is currently on).
   -- same for lights
   -- same for pump
8. Add the ability to select a historical date range (for example, March 1 thru March 7) -- (and even a future date range to see the schedule for the lights, fans, and pumps).

If there is a desire to make some of these changes, I'm not sure the best technical approach. I'm familiar with a couple packages that could do the above with stock features (e.g., Google Data Studios, Shiny/R). Those products are free and allow embedding...and Google Data Studios may be the easiest...but would require setting up an account and sending data from the Pi to a third-party website. Python also has a ggplot library that I could probably make work on the Pi. I'm not familiar with Chart.js, but a quick glance at what they offer suggests it would be difficult to create a super interactive "dashboard" with it. But since that's already working, it may be best!

Lastly, my chart still isn't updating, so that may be a priority.

I think the following line in the instructions come too early:

sudo mysql -u frxpi -p frx_db < /var/www/html/db/frx_db.sql

As is, the file (frx_db.sql) being used to populate the database is not on the local system until something like the following is complete:

cd ~ wget https://github.com/fruxefarms/FruxePi/archive/master.zip sudo unzip master.zip sudo mv -v ~/FruxePi-master/* /var/www/html/ sudo rm -rf FruxePi-master master.zip /var/www/html/index.html

Currently, have Fan that kicks in for humidity and a High temp.

Another relay control to turn on a heater at a min temp and turn off at a max temp.

After clicking the Save Schedule button on the Technical » Pump page, the Manual Controls slider changes to the ON position. I don't think that should happen.

At the top of the dashboard page, Fahrenheit reads to two decimal places, e.g., 72.43. I think rounding to 0 decimal places is better.

Also, in the Fans page, the temp setting reads to 8 or 9 decimal places (e.g., 69.9999999) after I type in, e.g., 70.

After 0.3 update I saw the new camera button. And it worked beautifully. Then, I added a new user — with an email address as a username and a password. The camera button was then not present. Can you replicate that issue?

I'm still having problems getting the website to load. When I go to the relevant IP I now get this error:

A PHP Error was encountered
Severity: Warning

Message: mysqli::real_connect(): (HY000/2002): Connection refused

Filename: mysqli/mysqli_driver.php

Line Number: 201

Backtrace:

File: /var/www/html/application/controllers/Dashboard.php
Line: 14
Function: __construct

File: /var/www/html/index.php
Line: 315
Function: require_once

FruxePi » A Database Error Occurred
Unable to connect to your database server using the provided settings.

Filename: controllers/Dashboard.php

Line Number: 14

Also, when I went to check the mysql installation, by entering sudo mysql -u root -p, I got this:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

Any help is much appreciated!

I was wondering if it was possible to use Si7021 sensor instead of the dht22 sensor.

To prevent confusion (including my own!), here's some suggested updates to the text within the Settings tab on the Dashboard page:

1. Change "Climate Threshold" to:

"Climate Thresholds: These values determine the CONDITIONS metric on the dashboard. For example, if the last hours' conditions were all within the ranges set here, then CONDITIONS would display as 100%." [This assumes that the CONDITIONS metric is calculated based on values from the last hour]

2.Change "Fans" to:

"Fans: The fans will turn on if the temperature or humidity rises above these values. The fans will remain on until the temperature and humidity falls below these values. Run Duration is..."

This is kind of a feature request/change in the UI:

The "__ hours, __ minutes until dark" at the top of the page is a bit confusing to me. I was thinking this had to do with sunrise and sunset (and was connected to the timezone bug I was trying to test)...but that assumption was wrong. The "until dark" is supposed to be a countdown to when the lights will be turned on (or off). This is based on the schedule settings for the lights.

I think a change in the wording of the UI would be helpful. Something like this:

"__ hours, __ minutes until lights turn on" (or "off")

It is GREAT that this text only shows up when the light "sensor" is enabled. In my case, we don't have grow lights...so I think it may make sense for the "Enable / Disable Probe" default status to be "off." The same goes for all other sensors...except the temperature/humidity sensor.

LIghts do not turn on and off with the schedule. schedule script doesn't seem to write to cron

I'm not exactly sure how this the fan "scheduler" is supposed to work, but...

I enabled the fans. The fans go on and off with Manual Controls. Great!

But the fans either: 1) don't turn on, or 2) turn on each minute for about 17 seconds and then turn off. Whether 1 or 2 happens depends on my settings... I realize this is vague... I plan to troubleshoot more, but I'm out of time at the moment.

Great work!

I have a feature request - would it be possible to add Xiaomi MiFlora sensor support? The sensor itself seems significantly better that the typical chinese soil moisture sensors both in the amount of information reported and in the quality of the readings.
There are several libraries that already exist, e.g.:
https://loads.pickle.me.uk/2017/03/19/raspberry-pi-zero-w-and-mi-flora-plant-monitor/
https://github.com/barnybug/miflora
And many more like:
https://github.com/open-homeautomation/miflora
https://github.com/ThomDietrich/miflora-mqtt-daemon
https://tutorials-raspberrypi.de/raspberry-pi-miflora-xiaomi-pflanzensensor-openhab/

Especially the first library basically returns formatted sensor data as "Sensors: {Temperature:11.9 Moisture:38 Light:0 Conductivity:114}".

I completely understand this might be quite difficult, especially if you do not own the sensor.

I have one more question - are there any plans to make the 3d plans for the cool looking electric plug + relay board + RPi enclosure as shown on the website available? Or will the actual product be sold at a some point in near future?

To prevent head scratching, it may be useful to add this to the instructions under the Change Timezone section:

sudo nano docker/Dockerfile

After installing, I pointed my browser to the relevant IP and it returned the text of a PHP file, which began:

<?php
/**
 * CodeIgniter
 *
`

It ended with:

/*
 * --------------------------------------------------------------------
 * LOAD THE BOOTSTRAP FILE
 * --------------------------------------------------------------------
 *
 * And away we go...
 */
require_once BASEPATH.'core/CodeIgniter.php';

So the Login page didn't appear.

This COULD be a problem with the fact that doing a "clean" install of everything was difficult and I may not have done it cleanly enough!

A PHP Error was encountered
Severity: Notice

Message: Undefined offset: 0

Filename: models/Crop_model.php

Line Number: 96

Backtrace:

File: /var/www/html/application/models/Crop_model.php
Line: 96
Function: _error_handler

File: /var/www/html/application/models/Crop_model.php
Line: 45
Function: getCrop

File: /var/www/html/application/controllers/Dashboard.php
Line: 48
Function: cropInfo

File: /var/www/html/index.php
Line: 315
Function: require_once

When opening and modifying the lights settings. I get the following errors. The Relay never fires. I have tested the relay and GPIO config manually and it works.

A PHP Error was encountered
Severity: Notice

Message: Undefined offset: 0

Filename: models/Lights_model.php

Line Number: 161

Backtrace:

File: /var/www/html/application/models/Lights_model.php
Line: 161
Function: _error_handler

File: /var/www/html/application/controllers/Sensors.php
Line: 171
Function: getLightsStatus

File: /var/www/html/index.php
Line: 315
Function: require_once

Sometimes, the countdown on the dashboard page seems to count up, instead of down.

For example, I set the timer to turn on at 12:00 and off at 12:01 (i.e., a duration of 1 minute). The lights functioned as expected (Yay!!!). Then, at 12:03, the message on the banner of the dashboard reads, "3 minutes until lights on." And then that value increases.

I would expect, that given that schedule, at 12:03, the message would be, "23 hours, 57 minutes until lights on."

The interesting part is that the message is correct for some schedule settings. I think the problem may arise when both the ON and OFF times are in the "future"...but I haven't exactly figured it out.

On the Dashboard, there used to be a button that said, I think, "View." Clicking on that would produce a current image from the camera. I found that feature very helpful. I could check whether the irrigation timer is working...although a slightly higher rez photo would make it more clear ;-).

Was it the intent to remove that button? Can it be added back?

I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while running the bash install script. Here's the full terminal output:

pi@raspberrypi:~/FruxePi $ sudo bash install.sh
Starting FruxePi Installation
Getting Latest Updates...
Installing required packages..
Building Docker containers... This will take several minutes.
Creating network "docker_web" with driver "bridge"
Creating volume "docker_db_data" with local driver
Creating frxpi-MYSQL ... done
Creating frxpi-APACHE     ... done
Creating frxpi-PHPMYADMIN ... done
Configuring Docker containers...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[ ok ] Starting periodic command scheduler: cron.
Checking installation...
-----
Installation complete!
Visit http://192.168.2.169 on your local network to access the FruxePi Dashboard.

I just wanted to say thanks for creating this...even in the beta phase (and although I've yet to make it work), it has given me some great ideas.

Let me know if you'd like some specific help. Otherwise, I'll just keep chugging away and trying to make it work and suggesting what I think are improvements.

Salud, Jay-yeo, and the rest of the good folks!

[Sorry to put this as an "Issue," but I don't know where this kind of thing should go.]

Clicking Take Photo does not result in a photo -- instead, the small icon for a broken image appears.

Clicking Test Sensor results in the grey bar appearing, but no text displays.

When I type pi@raspberrypi:~ $ raspistill -o cam.jpg on the command line a photo is saved...so the camera appears to work on my machine.

The below pops up in the web browser, after I enter the default username and password in the login screen. This happened just after a fresh (re)installation that just finished minutes ago -- presumably after the latest commit.

FruxePi » A Database Error Occurred
Error Number: 1146

Table 'frx_db.users' doesn't exist

SELECT `email`, `email`, `id`, `password`, `active`, `last_login` FROM `users` WHERE `email` = '[email protected]' ORDER BY `id` DESC LIMIT 1

Filename: models/Ion_auth_model.php

Line Number: 1038

I believe I followed the complete installation instructions correctly and saw no errors throughout the process. However, when I opened a web browser on the PI and went to http://my-raspi-ip-address:8080/ I received the following error:

my-raspi-ip-address refused to connect

I've done a quick search for how to solve this, but I've found nothing yet.

Any ideas?

[I entered the IP address given by ip add for my-raspi-ip-address...something like 192.168.2.19]