#126 

Excellent - glad you got it running - there are some changes coming to the script very soon - keep looking in. It will only get better.

2 years old but still relevant. Thank you Andreas! And Peter Scargil

Andreas, 48hrs ago I didn't have a clue about any of this stuff. Words like MQTT and Node-red meant nothing to me. I've had some time off work to learn a new skill. From your image I now have everything working. Well done to you and Peter Scargill for such great work. I really have the bug to learn more. It just goes to show that you are NEVER too old to learn a new skill. Happy New Year !!

Amazing! Communities are really pushing the entire IT industry forward with an unprecedented pace! Thanks (both of you) for sharing! Big LIKE

Yesterday, I was just thinking about how I could do this. What a delight to find your presentation on this very topic! Thank you very much, Andreas.

Amazing Andreas how much value you bring in 10 minutes .. each and every time ...

For those who are interested in using Peter Scargill's script in 2020, please be aware that he no longer supports its use on both the Raspberry Pi Zero AND using DietPi. Checkout his site for more info before descending down that rabbit hole. tech.scargill.net/the-script/

I currently hacking a Atari 2600 to host a PiZero for an RetroPie console. I love the PiZero! My next project will include multiple ESPs for temperature sensores, event counters and number transmissions for displays. So your work saved me from hassle even before it has started. You are THE BEST!

Im really happy to see he is still updating his script even today

Fantastic work. Many thanks to you Mr. Spiess and ofcourse to Mr. Scargill

Thank you very much for creating the pi zero img file.

Big thank you (and to all who made this possible). I did not actually knew the wifi-version of this existed, and this is exactly what i've have wanted. Will buy a Zero W tomorrow :)

I wish I had this script when I installed all these manually on my Pi3 last year. It was a painful process that took me days to setup and configure. I can now use the script to do a clean install of everything on my Pi2 and Pi3 ( don't have a PiZ). Didn't know about the DietPi. Looks amazing. Thanks Andres

I already have a couple of Pi Zeros (v1.2 & 1.3) so I've been putting off getting a Pi Zero W, since the previous Zeros work OK with a USB hub and USB Wi-Fi dongle. I was hoping that would work for this project. Then I read on Pete Scargill's Tech Blog that he already tried that, and it works great. Thanks again for both the SD card download, and this video.

Wow! Mr Spiess you're a great teacher👍

I had great success with this on both a Pi-Zero with a WiFi dongle, and with a Pi-3. Thanks to both you and Peter for this contribution. But seeing that Peter added comments in the Christmas script in March about successful testing with a NanoPi M1 & M3, coupled with the fact that I've been looking (waiting) for a beefier alternative to a Pi-Zero, I thought I'd look into getting this working on a NanoPi. Well, looking no further than ArmWorks selling a NanoPi2 (only slightly larger than a Pi-ZeroW, but with a 1.4GHz Quad Core Cortex A9 processor) for $15-shipped, I experimented a little. Here are my findings: Well, all did not go too well. The first stickler was that the closest DietPi SD image available to a NanoPi2 was one on the DietPi website for a NanoPi M2. Outwardly, it seemed that the most significant difference was the lacking of an ethernet port on the NanoPi2--shouldn't be too significant, so I installed it. Everything seemed to be okay, except for two things. 1) upon booting and displaying the normal information before allowing user logon on terminal 1, the input was blocked. However, an Alt-F2 switch to terminal 2 got around that. Eh... not perfect, but workable. 2) when installing either LXDE or XFce, neither would work--seemed to be failing during X. But having gotten that far, the Christmas script seemed like halfway-good idea. Well, it did run... but with a generous amount of errors; mostly having to do with file-system access or something missing from the internet. It was minimally successful; Mosquitto broker worked, but the web server did not. So..... no ability to test further. Anyway, would you be willing to take a shot at this? I would gladly provide the NanoP2. Thanks.

Andreas I'm stuck. I've got so far thanks to you and Peter Scargill. 3 weeks ago I didn't know anything about this stuff. I've now got everything working and ready to flash a Sonoff device. I'm going to use Tasmoda. This is probably a really simple question but my inexperience is showing. Tasmoda has many language options and I need to choose English. The Tasmoda config asks this question "Uncomment one of the lines below to build/upload only one environment" I don't know what to do. This isn't an intuitive question for a novice. Sorry for my ignorance. Kind regards Douglas

Andreas, how do I become a paid subscriber? You have given so much, it is time to support you for your tireless efforts. I really don't know how you achieve so much and deliver it so eloquently and clearly.. Without you, I am lost. Many thanks to you and Peter Scargill, what a wonderful collaboration. 👍😀

Great.... just doing some idle Sunday morning cruising the RU-vid channels and when I see one of your videos. I will take some time to view it because your content is great. Now I'm fully down the rabbit hole fully learning about MQTT and NodeRed. Thank you for introducing some "to me" new technology. GeekMustHave

Great video. Love the information. I'm setting up my PI as a headless server. I was unfortunately unable to user your image for some reason, but, following your directions, I'm able to get my pi setup. Took a little over three hours. Thanks for the details.

Hi Andreas, I love your videos and they have been a great source of inspiration for many of my projects!!! Thanks so much for sharing your image file for this. It has come in very handy!!! Keep up the great work!

Really enjoyed this video Andreas. I'm new to this subject and struggling to get my head round the logic. Thanks for an informative video

Worked a treat, many thanks for the image file.

The image is really great work and it's an even greater idea to distribute it freely... Thanks!!!

Bravo!!!! Amazing! Looks like you are reading my mind! It's what I was going to make by myself next week as I got my Zero W. I already tested MQTT and Node-red with psf b85 (ESP8285) (Thanks to your mailbox post) but it was on my Laptop. Now I even do not need to install mqtt and nodered as you made an image! And even with sqlite! Thank you thank you thank you! It will save a lot of my time! I'd like to hug you very tight!

Awsome as usual Andreas your efforts are priceless!

I just finished to install OpenHab on a new PI 3 with OpenHabian script. I think I will add Node Red too, looks nice! Please continue with this kind of videos, they are great!

I had a couple of thoughts since you're using DietPi (my personal favourite). You can enter a hostname in dietpi-config and then you don't need to worry about the IP address so much. Also, Dietpi supports external USB memory/drives so you can configure a USB drive for all your user data. Its faster and less risky than writing to your SD card :)

Congratulations Andreas, that is superb. Almost too easy if one's goal is to learn but like a bait for a $10 Pi Zero W fishing hook. Thanks again!

I personally wouldn't send the 'timeStamp' column in the SQL INSERT. I prefer to config the column as 'CURRENT_TIMESTAMP' in the PhpAdmin, and it will write the timestamp by itself. I prefer doing this because it's easier, and pretty useful for iot applications where using less code can also be trivial. I have to say that I really like your content and this video made me learn more things :). Life's about learning.

Andreas this was an excellent tutorial. I got it working on a Pi3 but it took quite a bit more than the 30 minutes. Perhaps a few days of tweaking the sql code. I particularly like the date note for node red so it displays the last update. I will use that on everything from now on. thankyou.

Very nice Mr Spiess! Looking forward to the next one (as always...)

Great, Great Work! I am a fan of your videos, great source of knowledge and inspiration. Can one find the MQTT Test Flow and MQTT Logger Flow in the SD or do you have to build them? Thank you

Very nice LE SUISSE !!! very interesting and sharp in the description, swiss style!!!!

Another fantastic video! I just achieved a milestone that I think you'll enjoy… Over the past week I have watched all of your videos from number 1 to this one! The information and knowledge was great! I also made sure to press "Like" on each one ;-) Watching Andreas TV is much better than normal garbage TV we have in USA!!! Many thanks… I will continue to watch and also "Like". One closing note: I was so disappointed when I checked TNN mapper and found only three gateways for LoRa in the entire United States with one of the three due to be decommissioned :-( ... why? Thanks & Keep up the great work !!!

Great work Andreas, looking forward to see more from you.

Big thumbs up ! used your image, ok on pi-zero with usb-wifi and usb-ethernet, same config also worked on rpi3 with onboard networkdevices, only 1 problem in piZero/pi3 : need to restart mosquitto first, nice surprise to find webmin on port 10000. Installed mqtt.fx 1.3.1 on windows 10, good for load testing to send many messages very fast (see script option). Using putty to see htop on rpi + another session to see network load using iftop.

I am half swiss and I can confirm this man's accent is aggressively Swiss.

Andreas - thanks for another great video. I watched last night and thought “interesting but what could I possibly need this for?This morning I woke up & realized this is the MISSING LINK to datlogging the esp8266 and esp32 based automotive test equipment I built for my shop. Now my fuel injector tester and my air flow bench will be able to automatically log the test points as mqtt messages!

Hello Andreas, Do you have a video that is more current for setting up an MQTT broker? This is all new to me and I really enjoy your videos. I searched but couldn't find anything on your channel. Thank you.

Thanks, Mr. Spiess. You earned another subscriber. (August 2020) I tried your image onmy Raspberry 3 B, but it didn't boot. Tried several SD cards, but no success. Then I went directly to the DietPi download page and tried their images there (both the 32 bit and the experimental 64 one) but those didn't work either. Maybe I'm missing something? Luckily I could run Pete Scargill's script on a Raspbian image.

Great video, as usual... Congrats! You always anticipate the work we must done giving ready-to-use lot of experienced hours in few minutes. I red few comments: in my opinion 10 minutes of video are the best way to stay concentrated and to capture almost all we need. Bye

Yes, wery usefull. thanks for your time in explanating and showing how to get thou to Matt and node Red, AND YOUR OWN COPY OFF THIS COMPILATION TO A SD CARD. Thanks 👍😀🇨🇭

Thank you for the image file. It really saves me a lot of time.

Absolut tolle Videos, die mich dazu inspiriert haben, mein Appartement als Probelauf für das künftige Haus zu automatisieren. Danke dafür und bitte genauso weitermachen:)

Nice video I will try DietPi for sure. One note you can enter the wifi password without a monitor. Solder headers to the Pi Zero and connect a FTDI adapter.

Great work Andreas, thank you. Will your image work on Pi2/3 also?

Great work !! This is very helpful. I really appreciate your work here !!

Great work as always! Thank you so much for sharing it with us.

Re: Video #126 Years ago I'd dl's and used the sdcard image you'd made from peter scargills christmas script. Thank you. I used the web interface with node-red and mosquitto to monitor and control a basement sump system. Hardware was a pi zero w and an ESP8266 with several sensors. Now, while starting with the same sdcard image for a different but similar project, I find the Diet-Pi version used is too old to upgrade and there were a few nodes I needed that wouldn't install without the upgrades. My Node-Red interface used live gauges, historical graphs, buttons and switches... All viewed on my browser. While looking at the script contents I'm guessing I don't need all of the many included programs. To save space, given the limited info I've provided, can you suggest which packages I will likely need for this project? The project is to monitor and display live and historical data of current flow through individual breakers in my house. My recent electric bills have gotten my attention. This seems to be a good place to start. Thank you for all you do. redisette

Just be careful with sqlite. Only one process should be writing to it at a time or you can get corruption. In this situation I doubt it will happen but it's just something to look out for. If you have the option you might switch over to MySQL as it's faster and doesn't have the issue of only being available to one process at a time. Thanks for doing what you do and keep up the great work!

Great video. Do you think this Pi needs a heatsink for this application when it is in a case?

There is one dislike? Who can possibly dislike your videos? I dare him/her to do better

Hello Andreas, Thanks for sharing this very interesting project and providing the pre-installed image. It's really amazing! I tried to upgrade the node red software and also some nodes (e.g. openweathermap) - but struggled. Any chance that you can provide an image of this project with the latest software versions (also dietpi os)?

exactly what I needed! already ordered my pi 0 w

Thanks for providing the package on github. Will try out when I get my Pi Zero.

Thanks Andreas for bringing Peter's script to my attention. I just wanted to give my feedback on the sd image, I was able to get it up and running and resized successfully but for some reason apache (though it is running) simply serves up a blank webpage. I investigated /var/www/html and found an empty index.html file and a folder for phpliteadmin (going to the IP/phpliteadmin successfully loaded the phpadmin but Peter's launcher page is not there. I'm on the new pi zero W and I'll probably do the whole thing from scratch in a little bit but I wanted to see if anyone else experienced this.

Thanks Andreas , I think SD card image needs to be updates , dietpi update services says "Your version of DietPi is now obsolete and cannot be updated ".

Hi Andreas Another great video and also many thanks to Mr. Scargill ! I did everything per instruction but can't install anything as I realized there is no disk space. So I followed the instructions for expanding the SD partition but with no luck. I downloaded the newly instruction from your GDrive but they don't work for me for the following reasons: 1) using the easy instructions, I can't do this as I am unable to add login into any desktop as I can't install anything due to limited disk space 2) using the "hard method", I can't sudo umount as I get an error "target is busy" error any help is greatly appreciated... Many thanks in advance, MG

Great eye-opener Andreas, thank you. To put this into context for myself, what you are saying is that you could set up your IoT home with as many wifi enabled devices as you like, and, as long as they can talk MQTT, for $20 and the price of a wifi adapter you can have this device log every possible event. It is stand-alone. It does not have any effect on how any given device behaves or reacts with its immediate controller, eg smartphone. Have I properly understood the context? is there another benefit? Cheers.

superb timing. And really a good idea. TU

Great help as usual. Except I do not find your GitHub image for the SD card. Do you have a link please.

Great video, just a question where did you get the pi zero from?

I asked and you delivered👍👍👍 thank you thank you thank you I know what I'm doing today

Great time saver, thanks Andreas. Pi Zero on order

Hi Andreas Spiess ! first I thank you for your great job why you can't make a video about mqtt and lorawan (iot) ?

just downloaded ... and I'll try to install it an a RasPi3 thanks again for your great work

Awesome video! Thanks for sharing

Very helpful indeed

Great video thanks a lot, really looking forward for some ESP32 videos

Hi Andreas, can you please tell me where I can find the image for this, sorry but I have only statred using node red in the last two days, have already spent many hours on the journey, thanks for your fantastic video classes !

It would be a good practice to add SHA1SUM of the image (or any other binary files) next to their download link.

Thanks Andreas, again and again!

Hi Andreas My pi zero should arrive this week sept 2017 very excited. i have a couple of sonoff 10A units. I am sure that i have seen a video by you showing how to reflash these and get them working with node red i have been looking but have been unable to find it. Are you are to point me to it. My first project will be Peters big timer and set up two lights in the house I thought i would start with something simple. BTW many thanks for the Pi zero image

The node libraries which Peter Scargill installed with his script made me curious, so I run it on a Rpi 1B last night. The script ran insanly slow on that hardware, but surprisingly the Node-RED server is running better than I expected. It takes of course longer than on RPi 3 to initialize the web frontend, but once it is down, the performance is enough to create flows and deploy them. I did not figure out why, but with the testinstallation done via Peter Scargill's script I was unable to add further node libraries. I think something went wrong with the npm setup.

great video and informative for a newbie - but the address of the image file seems to be broken - help!

Andreas, once again fantastic work and thanks for sharing...

Loaded your image fine. Great work. I am stuck getting into Node Red Control Panel from PETE'S UTILITIES. I have run out of ideas for the Username/Password.

Thanks for your video! Would your image also run on a Pi1? I still have a lot of them around and barely use them.

Thanks for your service to the hobbyist community. I have an issue with your image file installation i.e., when I add these lines, editorTheme: { projects: { enabled: true } } in settings.js file I can add Projects option in the Menu of regular Node-red. But it is not working in Node-red of your image file installation. Please advice me, how do I get the "Project option" in Node-red Menu if I use your image file. Thank you again.

Very nice! I have been logging my solar data to Adafruit.io and now easily I can set up my own broker.

Hi andreas...I'm a big fan of your work....does you SD card image for the raspberry pi zero works for the raspberry pi 1 ( I've read that is basically the same processor but I don't Kwon if the SD card image is compatible)...

Ill have to get me a Raspberry pi zero as you make it so easy by providing the SD card image. While i wait for the zero to ship ill mess about with with Scargils script on my orange pi.. thanks

This is worth a 16G card and may need one for some of the updates.

Hi Andreas, i used your dietpi image.. thanks a lot.. however, i got a small question.. what is the default username/passw for the node-red dashboard? (or probably guide me if there is a link where to get this info?) i figure out already what are the default username/pass for others (dietpi, node-red, sqllite, webmin),, its just the node-red dashboard which i cannot find.. thanks again for a very wonderful video.

I finally made it running. One final question, i want to copy your function sabing mqtt to sd card. Is it possible to make the code available? The code you posted is a diffrent one. Thank you for your great tutorials

Perfect! Thank you so much.

INCREDIBLE

Be carefull with these insert sql statements. The data comes from a string that allows any publisher to inject sql commands. I just had a look at the node red related sqlite tutorials and did not directly found a solution. A proper sql parameter fuctionality (to pass these parameters: www.tutorialspoint.com/sqlite/sqlite_injection.htm) takes care of these issues. I am unsure if there exists one, but I assume. (primalcortex.wordpress.com/2016/05/13/esp8266-logging-data/)

Great video, thanks for providing the image... however running out of storage space... 1.8GB fixed space.... 6.2GB used on my SDCard. Getting out of storage space errors.

Wieder etwas gelernt. Danke!

BANGOOD no longer displays “exact” components needed. Please help. I want to buy and SUPPORT YOU!

A bit late for the party, but: Thanks for the excellent tutorial. I've got it set up and appears to be working OK, but how do I use it to do something useful eg: I've got a light that I've 'tasmotised' and can control using the Node Red in Home Assistant. How do I (say) turn it on using this set up? I've tried injecting 'on' with the topic of the bulb (Lohas_Bulb2) and subscribed to the same topic, but nothing happens. Maybe it's a lot more involved than this! I'd be grateful for some help, please. Jim

..very nice, thank you for sharing

Hi Andreas, thanks for sharing your excellent work , I am not able to follow your video for running Peter script after flashing dietpi image into SD card and enabling WiFi Could you please help me to run the Peter script to install all the required installations , thanks in advance for your support

I use Raspbian Lite in a similar matter and I found out that the HDMI output is switched on, even if there is no screen attached. Switching this off saves power and reduces the CPU temp, I read somewhere that it can reduce 20% power. To switch off the HDMI output type "/usr/bin/tvservice -o" and add this line to "/etc/rc.local" at the end, before "exit 0". I don't now how this is set up in DietPi.

Hi, thank you for this great video. It is still relevant in 2020 ? Can i run it trough putty only ? Don't want to connect to a display. Thank you very much for the answer.

Andreas, I'm not having good luck with getting mosquitto to work properly. I built it using your image, configured wifi, but when I try "mosquitto_sub -v -t '#'" I get the error "Connection refused: not authorised" or I use MQTT.fx and I get "Not authorized to connect". I've tried it using both accounts. Node-RED also won't connect. What am I doing wrong? Thanks, I love your channel!

What about corruption of SD card because of writes to the database? Would be nice if you could make a video on how to temporarly save values into RAM for a few hours, and then flush them into the database, so it would write only twice or 3 times a day to the sd card.