Tag Archives: mysql

Raspberry Pi Trouble & Python Network Messages

Well, I spent what time I had last night and tonight troubleshooting one of my Raspberry Pis. I couldn’t connect in via my VNC client so did a hard boot on it. I ended up with just a solid red PWR light. After investigating I determined the SD card is bad or corrupted. I ordered a new SD card from Amazon last night, received it today, and loaded a fresh Raspbian image. The Pi then booted and I was able to get x11vnc going again. I’ll have to do some further investigation on my other SD card to determine if the OS was just corrupted or if the SD card is truly bad. In any case, I lost several of the python programs I had created on there. Lesson learned, BACKUP!

On a side note, I did determine a method to trigger a Raspberry Pi to download updated data from a Mysql database. I followed the guide found here to send messages over the network using python. My plan is to utilize a PHP form to run a separate python script which will send a message to the remote Raspberry Pi which will essentially trigger it to go query the mysql database to download any changes the user makes in the Home Intelligence Management System I’m working on. This will eliminate me from having to constantly query the database looking at a flag indicating the data has changed. Next step, put together a functioning python program to control my water heater then be able to control it via a WordPress Plugin.