Hi, I have one thing to ask regarding HTTPS post method. I used httpclient community library to send sensor data from Photon to mySQL hosted on localhost (http) using Apache and phpmyadmin. But I am concerning about security because Photon sends sensor data in plain text just like other HTTP post…

Hello, I’ve actually solved my own question here and forgot to reply with my answer in case it will help anyone in the future. In my case, I am reading three different sensors, collecting the values from all three sensors on the cloud and inserting them into a mysql table containing all three in di…

Let me know if this older post helps you. Ping me if it doesn't and I'll see what else I can find. [image] Will Photon support outbound HTTPS? Firmware Been using Cores for a year - love 'em in my projects. Waiting for my Photons to ship (hope that’s soon!). In the Core,…

Doing https requests from a microcontroller isn’t an easy task. That’s why Particle implemented webhooks in the cloud api. Everything there is encrypted and can post to your server using https. I would recommend that route if you can. https://docs.particle.io/guide/tools-and-features/webhooks/

[image] Put data to my own database Using webhooks, you'd have to have an API on the server which can be reached. This is what I have read[ here][1] that webhooks needs api. Is webhooks only specifically meant to publish data to other 3rd party servers such as ubidots & thingspeak? I cannot…

Thank you @KyleG . I have read the whole thread and I found this. [image] Will Photon support outbound HTTPS? It's our intent that the photon will eventually support outbound HTTPS. That's why, I assume the native HTTPS support in Photon is not coming any time soon. I saw about HTTPS client …

[image] phyo_tz: Is webhooks only specifically meant to publish data to other 3rd party servers such as ubidots & thingspeak? As far as webhooks are concerned, you're a third party as well. Webhooks are being sent from the Particle cloud, and as such have to access your server from the outsi…

As long as the amount of data you have to store is less than about 256 bytes per second, and you have the ability to run node.js on a computer somewhere, it could be a regular Windows, Mac, or Linux computer, or even a Raspberry Pi, you can easily do this. Here’s a quick sample I wrote that shows ho…

@rickkas7 Thanks for your help. I have followed all the comments, however I ran into this problem. Random data are successfully published from Photon according to this photo. [image] But all the data input into mySQL database are happened to be null. :disappointed_relieved: [image] Is there…

The thing is that I have no clue how to set up api for localhost assuming that external network can ping to apache local server that I established. :grin:

Sorry, there was a bug in my code. The github is updated, but the call to storeData should looks like this instead: storeData(JSON.parse(data.data));

@rickkas7 Appreciate your help, Sir. :blush: I changed that line and it is now working. [image] Can you please explain the general flow of the mysqlsample-master? I get the part where Photon is publishing the random using Particle.publish. But normally when we use Particle.publish, it directl…

HTTPS POST to mySQL on localhost

Getting Started

KyleG September 2, 2016, 6:05pm 2

Let me know if this older post helps you. Ping me if it doesn't and I'll see what else I can find.

Topic		Replies	Views
Add JSON message from web-hook to MySQL Cloud electron	5	1110	February 9, 2019
Help novice with photon Cloud	27	3391	December 18, 2018
Put data to my own database Cloud	11	11627	March 22, 2017
Photon to mySQL DB Getting Started	12	8189	January 4, 2018
Cant get photon code,webhook,php to log data to mysql General photon	5	1574	January 10, 2019

HTTPS POST to mySQL on localhost

Related topics