Hydroponics Level Sensor Stays at 100%

Thanks for getting back to me. Which particular table are you needing data from? Is it Hydroponics/Level? Hydroponics/RawLevel?

Also, when you add the Empty and Full values in SG3Configure where is that data stored?

glenn

Thank you.

The data is indeed there:

1. "Tank_Pump_Level_Full": "414", "Tank_Pump_Level_Empty": "919",
2. "hydroponics_level": "true"},
3. "id": "77BD", "name": "", "ipaddress": "10.0.4.106", "hardware": "esp32", "hydroponicsmode": "false", "return_string": "77BD,1,1,1,1,0,1,1,0,0,061", "connected": true, "hydroponics_temperature": "false", "hydroponics_tds": "false", "hydroponics_ph": "false", "hydroponics_turbidity": "false", "hydroponics_level": "false"}]}

I bought a Gikfun capacitive soil moisture sensor to try and there was no change in the 100% reading. The above readings are using the capacitive soil moisture sensor that came with the kit.

glenn

SGS.JSON
{"key": "value", "ProgramName": "SmartGarden3", "ConfigVersion": "001", "SWDEBUG": true, "enable_MySQL_Logging": true, "English_Metric": false, "MySQL_Password": "password", "mailUser": "[email protected]", "mailPassword": "Bass@spinner8", "notifyAddress": "[email protected]", "fromAddress": "[email protected]", "enableText": true, "textnotifyAddress": "[email protected]", "INTERVAL_CAM_PICS__SECONDS": "60", "REST_Enable": false, "Camera_Night_Enable": false, "MQTT_Enable": false, "MQTT_Server_URL": "", "MQTT_Port_Number": "1883", "MQTT_Send_Seconds": "500", "manual_water": true, "Send_Status_Email": false, "Status_Send_Email_Minutes": "300", "Send_Status_Text": false, "Status_Send_Text_Minutes": "300", "Tank_Pump_Level_Full": "359", "Tank_Pump_Level_Empty": "917", "Infrared_High_Auto_Gain": true, "Infrared_Low_Auto_Gain": true, "Infrared_Low_Temp": "17.0", "Infrared_High_Temp": "23.3", "WirelessDeviceJSON": [{"return_value": 0, "id": "6B95", "name": "Hydro", "ipaddress": "10.0.4.24", "hardware": "esp32", "hydroponicsmode": "true", "return_string": "6B95,1,1,1,1,0,1,1,0,0,061", "connected": true, "hydroponics_temperature": "true", "hydroponics_tds": "true", "hydroponics_ph": "false", "hydroponics_turbidity": "false", "hydroponics_level": "true"}, {"return_value": 0, "id": "77BD", "name": "", "ipaddress": "10.0.4.106", "hardware": "esp32", "hydroponicsmode": "false", "return_string": "77BD,1,1,1,1,0,1,1,0,0,061", "connected": true, "hydroponics_temperature": "false", "hydroponics_tds": "false", "hydroponics_ph": "false", "hydroponics_turbidity": "false", "hydroponics_level": "false"}]}

********************

SG3.py Startup
pi@SmartGarden:~/SDL_Pi_SmartGarden3 $ sudo python3 SG3.py
SGS.JSON File exists
SGSConfiguration.JSON File exists
mmal: mmal_vc_component_create: failed to create component 'vc.ril.camera' (1:ENOMEM)
mmal: mmal_component_create_core: could not create component 'vc.ril.camera' (1)
###############################################
SG3 Version 051 - SwitchDoc Labs
###############################################

Program Started at:2023-01-22 15:45:26

SGS.JSON File exists
SGSConfiguration.JSON File exists
Traceback (most recent call last):
File "/home/pi/SDL_Pi_SmartGarden3/sendemail.py", line 51, in sendEmail
s.login(config.mailUser, config.mailPassword)
File "/usr/lib/python3.7/smtplib.py", line 730, in login
raise last_exception
File "/usr/lib/python3.7/smtplib.py", line 721, in login
initial_response_ok=initial_response_ok)
File "/usr/lib/python3.7/smtplib.py", line 642, in auth
raise SMTPAuthenticationError(code, resp)
smtplib.SMTPAuthenticationError: (535, b'5.7.8 Username and Password not accepted. Learn more at\n5.7.8 support.google.com/mail/?p=BadCredentials t5-20020a05620a450500b006fa8299b4d5sm30456567qkp.100 - gsmtp')

sendmail exception raised
----------------------
Local Devices
----------------------
----------------------
Checking Wireless SGS Devices
----------------------
myCommand= assignBluetoothSensors?params=admin,C4:7C::6D:3E:8F,C4:7C::6D:35:E3
myURL= 10.0.4.24/assignBluetoothSensors?params=admin,C4:7C::6D:3E:8F,C4:7C::6D:35:E3
myCommand= assignBluetoothSensors?params=admin,C4:7C::6D:3C:81,C4:7C::6D:4C:8E,C4:7C::6D:7A:30
myURL= 10.0.4.106/assignBluetoothSensors?params=admin,C4:7C::6D:3C:81,C4:7C::6D:4C:8E,C4:7C::6D:7A:30
myURL= 10.0.4.24/setValves?params=admin,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
return= {'return_value': 0, 'id': '6B95', 'name': '', 'ipaddress': '10.0.4.24', 'hardware': 'esp32', 'hydroponicsmode': 'true', 'return_string': '', 'connected': True}
myURL= 10.0.4.106/setValves?params=admin,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
return= {}
Hydro - 6B95: Present
- 77BD: Not Present
MQTT: Sending CONNECT (u0, p0, wr0, wq0, wf0, c1, k60) client_id=b'SG3'
MQTT: Received CONNACK (0, 0)
myCommand=enableHydroponicsMode?params=admin,1,0 myIP=10.0.4.24
myURL= 10.0.4.24/enableHydroponicsMode?params=admin,1,0
UpdateStateLock Releasing - initializeOneExtender
myCommand=enableHydroponicsMode?params=admin,0,0 myIP=10.0.4.106
myURL= 10.0.4.106/enableHydroponicsMode?params=admin,0,0
UpdateStateLock Releasing - initializeOneExtender
subscribing to SGS/6B95
MQTT: Sending SUBSCRIBE (d0, m1) [(b'SGS/6B95', 0)]
MQTT: Received SUBACK
subscribing to SGS/77BD
MQTT: Sending SUBSCRIBE (d0, m2) [(b'SGS/77BD', 0)]
MQTT: Received SUBACK


----------------------
Plant / Sensor Counts
----------------------
Wireless Unit Count: 2
Valve Count: 16
Bluetooth Sensor Count: 5

----------------------
Other Smart Garden System Expansions
----------------------
GardenCam: Not Present
Lightning Mode: Not Present
MySQL Logging Mode: Present

----------------------
-----------------
Scheduled Jobs
-----------------
Jobstore default:
checkForButtons (trigger: interval[0:00:10], next run at: 2023-01-22 15:45:53 EST)
manualCheck (trigger: interval[0:00:15], next run at: 2023-01-22 15:45:58 EST)
valveCheck (trigger: interval[0:01:00], next run at: 2023-01-22 15:46:43 EST)
tick (trigger: interval[0:05:00], next run at: 2023-01-22 15:50:43 EST)
checkForAlarms (trigger: interval[0:05:00], next run at: 2023-01-22 15:50:43 EST)
updateDeviceStatus (trigger: interval[0:12:00], next run at: 2023-01-22 15:57:43 EST)
cleanPictures (trigger: cron[day='*', hour='3', minute='4'], next run at: 2023-01-23 03:04:00 EST)
cleanTimeLapses (trigger: cron[day='*', hour='3', minute='10'], next run at: 2023-01-23 03:10:00 EST)
buildTimeLapse (trigger: cron[day='*', hour='5', minute='30'], next run at: 2023-01-23 05:30:00 EST)
-----------------
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
newValve= {'id': '6B95', 'ValveNumber': 1, 'NextTime': datetime.datetime(2023, 1, 23, 15, 30), 'LengthTurnOn': '300'}
newValve= {'id': '6B95', 'ValveNumber': 5, 'NextTime': datetime.datetime(2023, 1, 22, 5, 30), 'LengthTurnOn': '900'}
newValve= {'id': '6B95', 'ValveNumber': 6, 'NextTime': datetime.datetime(2023, 1, 22, 8, 0), 'LengthTurnOn': '50000'}
nextMoistureValveSensorCheck = 2023-01-22 15:15:00
nextMoistureValveSensorCheck = 2023-01-22 15:30:00
nextMoistureValveSensorCheck = 2023-01-22 15:45:00
nextMoistureValveSensorCheck = 2023-01-22 16:00:00
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
valveState Found for 6B95 1
valveState Found for 6B95 5
MQTT: Sending PUBLISH (d0, q0, r0, m3), 'b'SGS/6B95/Valves'', ... (114 bytes)
MQTT: Received PUBLISH (d0, q0, r0, m0), 'SGS/6B95', ... (97 bytes)
Wireless MQTT Message received: b'{"id": "6B95", "messagetype": "1", "timestamp": "01/22/2023 20:47:43", "valvestate": "V00001000"}'
Valve Change Received
Timer Fired! Next Fire= 2023-01-22 16:00:00
valveState Found for 6B95 6
MQTT: Sending PUBLISH (d0, q0, r0, m4), 'b'SGS/6B95/Valves'', ... (116 bytes)
MQTT: Received PUBLISH (d0, q0, r0, m0), 'SGS/6B95', ... (97 bytes)
Wireless MQTT Message received: b'{"id": "6B95", "messagetype": "1", "timestamp": "01/22/2023 20:47:44", "valvestate": "V00001100"}'
Valve Change Received
Timer Fired! Next Fire= 2023-01-22 16:00:00
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
valveState Found for 6B95 1
valveState Found for 6B95 5
valveState Found for 6B95 6
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
valveState Found for 6B95 1
valveState Found for 6B95 5
valveState Found for 6B95 6
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
Tick! The time is: 2023-01-22 15:50:43.724930
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
valveState Found for 6B95 1
valveState Found for 6B95 5
valveState Found for 6B95 6
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
valveState Found for 6B95 1
valveState Found for 6B95 5
valveState Found for 6B95 6
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
MQTT: Received PUBLISH (d0, q0, r0, m0), 'SGS/6B95', ... (246 bytes)
Wireless MQTT Message received: b'{"id": "6B95", "messagetype": "5", "timestamp": "2023-01-22 20:52:40", "macaddress": "C4:7C::6D:3E:8F", "temperature": "181", "brightness": "591", "moisture": "16", "conductivity": "113", "battery": "5", "readCount": "131", "sensorType": "BT1"}'
Bluetooth Sensor Message Recieved
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
valveState Found for 6B95 1
valveState Found for 6B95 5
valveState Found for 6B95 6
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
MQTT: Received PUBLISH (d0, q0, r0, m0), 'SGS/6B95', ... (247 bytes)
Wireless MQTT Message received: b'{"id": "6B95", "messagetype": "5", "timestamp": "2023-01-22 20:52:47", "macaddress": "C4:7C::6D:35:E3", "temperature": "183", "brightness": "1277", "moisture": "13", "conductivity": "18", "battery": "35", "readCount": "132", "sensorType": "BT1"}'
Bluetooth Sensor Message Recieved
MQTT: Received PUBLISH (d0, q0, r0, m0), 'SGS/6B95', ... (207 bytes)
Wireless MQTT Message received: b'{"id": "6B95", "messagetype": "7", "timestamp": "01/22/2023 20:53:25", "temperature": "19.62", "rawlevel": "357", "rawturbidity": "183", "rawtds": "187", "rawph": "183", "sensortypes": "TDS1 TUR1 PH1 LFS1 "}'
Hydroponics Message Recieved
Processing HydroponicsSensorMessage
rawLeve= 357.0
myScale = 0.3893129770992366
Level= 100
voltage= 0.549
slope:
-0.016903313049357674
,intercept:
7.0
query= INSERT INTO Hydroponics(DeviceID, Temperature, Turbidity, RawTurbidity, TDS, RawTDS, Level, RawLevel, Ph, RawPH) VALUES('6B95', ' 19.62', -1.00, '183', '237.66',187, 100.00, 357.00, -1.00, 183)
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
valveState Found for 6B95 1
valveState Found for 6B95 5
valveState Found for 6B95 6
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
>>>>>>Valve Check<<<<<<
Inactive Wireless Device 77BD / Valve 1
Inactive Wireless Device 77BD / Valve 2
Inactive Wireless Device 77BD / Valve 3
Inactive Wireless Device 77BD / Valve 4
Inactive Wireless Device 77BD / Valve 5
Inactive Wireless Device 77BD / Valve 6
Inactive Wireless Device 77BD / Valve 7
Inactive Wireless Device 77BD / Valve 8
valveState Found for 6B95 1
valveState Found for 6B95 5
valveState Found for 6B95 6
MQTT: Sending PINGREQ
MQTT: Received PINGRESP
^Cexiting program
myURL= 10.0.4.24/setValves?params=admin,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
return= {}
myURL= 10.0.4.106/setValves?params=admin,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
return= {}
MQTT: Sending DISCONNECT
done
pi@SmartGarden:~/SDL_Pi_SmartGarden3 $


*********************
I have screenshots from SG3Configure and Dash Hydroponics-they will not paste into this reply. If you want them I will need an email to send to.

Anything else you want to see?

glenn

Thanks Dave,

I got it. I am using:

1. The "Part M – 3D Printed Hydroponics Sensor Mount"
1a.The sensor is bottomed out in the mount.
2. The water level in the hydroponic unit is at "Max" line.
3. The water level is at the white line on the sensor.

Q1: How is the raw reading taken?
Q1a: I need to see if I can find the raw reading I got while using the Gikfun capacitive soil moisture sensor, but I do remember the reading being very close to the full reading.
Q1b: Same results for two different capacitive soil moisture sensors from two different manufacturers. It would appear at this early stage of testing that the sensors could be eliminated from troubleshooting steps.

Q2: What did you mean with your above response: "Slightly interested in this as seeing similar but yet to put in hydroponics and recalibrate.

glenn

Okay so I ran into the same problem integrating the level staying at 100% when it was around 90% . The problem is related to pclogging.py, and the myScale figure which was lower than the last 'if ' statement of 0.61, because of this it reverts to 100%. Check if you have the same problem

Eventually the slope will change when the level gets low enough and start reporting less than 100%.

I decided to rewrite this section to split level calc into 3 parts related to each of the 3 straight-line graphs of different slopes seen when I measured at 0, 1L, 1.5L,2L, and full. This is pretty much how it's done in the code but mine is linear across each of the straight line parts and I believe the original code does this across the whole min /max level as a single calc.. So for example at 50% level the original code read 72% mine reads 53%.

I think the problem, at least for me ,is that my sensor is reading slightly different response than perhaps the norm but happy with this now for my sensor

Dave.

See below for code but it comes with the health warning that this is good for my characterised sensor/tank, and it may work well with others. I believe the tank is the same as the one SwitchDocLabs has used , but mine was sourced separately. Would be good id you proved the code works well with your sensor before implementation Some notes to help read it. I have tested it and it seems to work quite well across the range.

1. I changed the definition of 0% as in my mind the hydroponics tank is empty when the pump is only just working properly , with just enough water to stop the green light flashing -this became my empty count and equivalent to 0%. It was just above the 1L mark. The SG3Config python programme would need to change to implement this method - but only the instructions.
2. After that I added 0.5L water from a measuring jug and took another reading -1.5L. Again for 2L, and again measured the remaining amount to hit the max mark-2.15L and taking the final reading. The scale is slightly off as seen on the tank but it matters not using this method.
3.Sensor readings:
1.0L - 702
1.5L - 518
2.0L - 468
2.15L- 458
4. Using the above data it actually lined up with the curves pretty well and gave me 3 slopes each representing % per count within each band:
(i) Slope1 702-518 has approx 43.5% of the water
(ii) Slope 2 517-463 has approx 43.5% of water
(iii) Slope 3 467-458 has approx 13% of water

each slope is % of water /delta count for each range.

5. code
def convertRawLevelToLevel(rawLevel):

# piecewise linear

Scale1=43.5/(float(config.Tank_Pump_Level_Empty)-518)
Scale2=43.5/(517-468)
Scale3=13/(467-float(config.Tank_Pump_Level_Full))

print("rawLevel=", rawLevel)
print("Scale1=", Scale1)
print("Scale2=", Scale2)
print("Scale3=", Scale3)
print ("Empty=",float(config.Tank_Pump_Level_Empty))
print ("Full=",float(config.Tank_Pump_Level_Full))

if (rawLevel >= 518):
Level = (float(config.Tank_Pump_Level_Empty)-rawLevel)*Scale1
else:
if (rawLevel >= 468):
Level =43.5+(517-rawLevel)*Scale2
else:
Level = 87+ (467-rawLevel)*Scale3
if (Level > 100):
Level = 100
if (Level < 0):
Level = 0
print("Level=", Level)
return Level