Eric_Erb

Please forgive me if this is a arduino networking noob question but I can't find an answer. I have a couple years experience with simple arduino projects but this is my first networking one. I find all kinds of examples of people controlling an arduino by hosting a website on the device itself, my question is can I host the site elsewhere and have the arduino monitor a mySQL database (or something similar) for changes. Why would I want to do this?.. I'm a web designer for a company that hosts its own sites. We have 5 static IPs. At home (where the arduino is) I don't have a static IP and I'd prefer not to use a service to mimic one. Thanks Guys.

Yes, and it's a far better way of doing things than putting "server" on an Arduino.

Basically What you need is an application on your PC/real server which will talk to the Arduino over the coms port/Ethernet/WiFi or what ever. I can't see why you would want an Arduino to Monitor an R-DB.

Mark

Eric_Erb

I didn't know there was a way to send information to the arduino without it having a static IP. The idea was a website with a simple interface that would change the values of a database then whenever the arduino queried the DB it would turn on a light or adjust the thermostat. (Yes this is another home automation project) If I can send an arduino a command directly that's perfect. How would I do that. If it changes your answer, I am talking about an arduino with an Ethernet shield connected to a router not an arduino connected to a computer.

Eric_Erb

I found the answer... I've been looking for four days and finally found something I can build off of. Thank you for your guidance it helped me find my answer. Anyone else looking for the method for the same approach I found it here... http://bildr.org/2011/06/arduino-ethernet-client/

Eric_Erb

Sure PerterH,"Do what with them?" This is a home automation project so trip relays for the most part.

The Problem: I don't have a static IP to serve a website from the arduino at home nor do I want to use a service to simulate having a static IP. I do have Static IPs at work I can use. So, I wanted to know how to use it as a client to access a DB instead of serving a website from it.

but wouldnt the Arduino need an Ethernet shield then? in any fashion? to be able to 'connect' to this web service/site that is remotely hosted?

On the opposite side.. (and Windows based only) which is a bit different than your scenario as you have/want your web servers t be in another location form the Arduino..

but I have installed WAMP server locally on a PC.....created a FLASH based GUI/interface that allows me to send RGB values to a PHP script.. that in turn dumps the data to a com port that Arduino is listening to....

works great normally anywhere inside the LAN.. if I wanted to open it up the public.. I only need ot log-into my router...and forward any HTTP traffic to the machine with the WAMP (web) server running control the Arduino from the 'net'..