Published Dec. 12, 2021, 11:35 a.m. by Ethan Armbruster
• From the previous post I discussed the Arduino being able to send its data to an SQL server and inserting it's data. I found after research that doing so exclusively with an SQL server was not possible and would need to be handled by another server running a web application that was able to insert the data. To test functionality, I created a local MySQL server and Flask Web App that was able to handle incoming requests and POST the data to an SQL server.
• However, when I went to POST these request from the Arduino, I ran into an issue where the Arduino was not able to send to my computer. Then I realized, a device cannot send data to "local host" because localhost does not have an ip address that any device can connect to. In an attempt to have a functioning server that day , I created an instance of MySQL server on my home server with an ip address that I could send data to and I was successful in doing so.
• But alas, I had to become Sys. admin again and setup account permissions, however despite hours of troubleshooting, I wasn't able to send the data to the server. I will continue to to fix these permission issues and once I have data locally inserting on my home server, I will migrate my work to the MySQL server on AWS and a cooresponding EC2 machine running the Flask Web Application.
***Further work on the Kitchen Conversion App will be on hold until I have the other two sensors sending their data, and being able to insert into the database.***
Please View the Previous Post for the last status report here