Comments on: ESP8266 Publishing DHT22 Readings to SQLite Database https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/ Learn ESP8266, ESP32, Arduino, and Raspberry Pi Sat, 13 Jul 2024 14:25:17 +0000 hourly 1 https://wordpress.org/?v=6.8.2 By: Agum Muldani https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-937010 Sat, 13 Jul 2024 14:25:17 +0000 http://randomnerdtutorials.com/?p=35947#comment-937010 Hi Rui,

That was great! But if i want to use Django as web server framework, where i write the code for MQTT?

Thanks

]]>
By: Peter Lutz https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-884029 Sun, 14 Jan 2024 23:02:41 +0000 http://randomnerdtutorials.com/?p=35947#comment-884029 Installing Flask in a virtual environment is different than these instructions.
But following the Flask install website worked.

]]>
By: Ian Mawdsley https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-878937 Wed, 20 Dec 2023 17:55:47 +0000 http://randomnerdtutorials.com/?p=35947#comment-878937 I have two esp8266’s connected this way and date is flowing into the .db and onto the web page, how can I get the “device name” to identify each controller rather than just having a static device name of “esp8266” any help would be greatly received . thanks

]]>
By: Thomas https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-859140 Fri, 08 Sep 2023 06:19:54 +0000 http://randomnerdtutorials.com/?p=35947#comment-859140 Hello,
i have also the problem:
“Attempting MQTT connection…failed, rc=5 try again in 5 seconds”
Mosquitto Broker is active, and the details is look like your tutorial, any ideas?
Thank you, your tutorial was really helpful!!

]]>
By: Terry https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-796290 Sun, 06 Nov 2022 23:40:40 +0000 http://randomnerdtutorials.com/?p=35947#comment-796290 Excellent tutorial, thanks for your always great subjects. I did find a typo in the code where you translate the values to Fahrenheit, hic should be hif if I’m correct.
// Uncomment to compute temperature values in Fahrenheit
// float hif = dht.computeHeatIndex(f, h);
// static char temperatureTemp[7];
// dtostrf(hic, 6, 2, temperatureTemp);
should be this
// Uncomment to compute temperature values in Fahrenheit
// float hif = dht.computeHeatIndex(f, h);
// static char temperatureTemp[7];
// dtostrf(hif, 6, 2, temperatureTemp);

]]>
By: Sara Santos https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-768230 Mon, 11 Jul 2022 08:47:32 +0000 http://randomnerdtutorials.com/?p=35947#comment-768230 In reply to hoang Phi.

Hi.
Double-check your MQTT broker details and make sure your MQTT broker is running.
Regards,
Sara

]]>
By: hoang Phi https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-767545 Fri, 08 Jul 2022 05:11:32 +0000 http://randomnerdtutorials.com/?p=35947#comment-767545 I have followed your instructions. You have very detailed instructions. Thank you. But I got a small error, can you point it out to me. Thanks, again.
“Attempting MQTT connection…failed, rc=5 try again in 5 seconds”

]]>
By: dave https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-754711 Tue, 31 May 2022 09:57:10 +0000 http://randomnerdtutorials.com/?p=35947#comment-754711 Having loaded Mosquitto and Node-Red and having nothing but compatibility problems with software, cannot install sqlite for node-red for some reason….
please do two things.
#1, list the version of the software you are using.
#2, list how to find the version before installing.

]]>
By: miyu https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-667284 Tue, 07 Sep 2021 08:22:06 +0000 http://randomnerdtutorials.com/?p=35947#comment-667284 Hi guys,
I have two problems with arduino and mqtt, that is “Attempting MQTT connection… Failed. rc=-4…” and “code 400, message Bad HTTP/0.9 request type…”
How can I fix it?

]]>
By: JONAH OKPE https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/#comment-664253 Fri, 27 Aug 2021 23:52:11 +0000 http://randomnerdtutorials.com/?p=35947#comment-664253 Great work, thank you so much.
Just one question, what if the DHT sensor is connected directly to the raspberry pi?
or another example is if you have to connect a GPS modeule directly to the Raspberry pi?

What will it look like? Does one have to go through all these processes or you will skip since you are not using the ESP8266?

Thanks once again for your great efforts

]]>