Hi there, I am new to Raspberry PI and I am looking for a way in which I can turn on and off a light using MySQL and a web interface which will be hosted on a separate machine since I eventually want to use more than one RPI. I have searched online and can only find servers being run on the same RPI or not using MYSQL at all. Is there any tutorials out there that could send me in the right direction? If so could someone point me to them or give me some information regarding this?
Looks like you are looking for MySQL server on one RPI and web interface (Apache most likely) on another.
I would go with Apache and php + MySQL libraries
Mysqli_connect and mysqli_query is what you are looking for from php side of things.
Setup Mysql account on one pi, grant all applicable permissions for 'user'@'2nd-pi-ip' (select + insert / update look like all you might need for 'web-interface' user)
Add Mysql port pass on firewall if applicable.
Write php website on another RPI and use mysqli_connnect and mysqli_query to operate on Mysql.
Google for LAMP install (Linux Apache Mysql Php) package for guidance.
You can get whole package to be installed in one run or guide to install one by one - install as required on one pi or the other
Related
1) Can someone produce some Javascript which adds xda-developer's search engine to Firefox's pull down list of search engines.
Javascript gurus, go here for help
http://66.102.9.104/search?q=cache:...fox&hl=en&gl=uk&ct=clnk&cd=9&client=firefox-a
2) Is there any proxy server software for PocketPC...It'd be great to be able to view barred websites on my work PC and impress my work mates...NO! I don't mean Porno :lol: and no I cannot use my phone as a GPRS modem because of the severe user profile restrictions my work are running in Windows XP.
Thanks...By the way, the phone is a Universal.
Search plugin
Here's a firefox search plugin I knocked up. I don't really use firefox so no use to me!
Note: due to the fact that xda forums uses "post" instead of "get" form submission, and firefox search plugins don't currently support "post" it defaults to only returning results in "post" form, not "topic", PITA and not my limitation, but the browser's. There may be a way around it, but it's also a PITA
Unzip the attached files and drop into your firefox \searchplugins\ subfolder.
V
You're a legend vijay...Nice one :mrgreen:
Now can anyone help with the proxy server software.....I would like to get a proxy server running off my Universal.
Hi,
I need a software which will help me project Nexus One Screen onto my PC. I used a Java based software Droid(at)Screen for G1. It is not working for nexus One.
Can anyone help plz.
Thanks in Advance
If you have root, then search for droid VNC server on the market.
even without root, it might work for viewing purposes (i.e you likely won't be able to type or click).
Works well with most VNC client / viewer applications - in fact, you could view it through a http link in your browser without a VNC client if java is installed / working ok on your machine.
Thanks Sd00 for the response. Actually, I am new to these devices, so couldnt understand what you had mentioned. (actually its too much of hightech for me). Can you please let me know what I need to install on the phone or check?
Thanks
Install droid vnc server app from the market, run the app, press start button on the app, read the http it shows you on the screen & type it in to the address bar of your internet browse, waa laa.
I want to set up a Pi as a Tor Proxy Server. I know Adafruit are selling complete kits (and include a tutorial) - but interested to know if anyone has tried setting one up.
Since Tor is open source, maybe you can build it by yourself.
Adafruit only recommends you use one of their wifi adapters, doesn't mean you can't try it out with another.
http://learn.adafruit.com/onion-pi?view=all
Now I won't say you can't but, you'll need to find a good Linux distro that is light weight, then from there you would need to figure out how to set up a normal TOR node on it, then from there find a RaspPi based Distro off the one you tested it on, from there you want to set it up on there, be warned unless you HDMI or VNC into the RasPI you will need to do it from terminal.
i think its a pre built distro at the moment, you should be able to get a capable adapter and let it run.
Yea it's pretty easy to do if your familiar with linux. But the adafruit instructions look like a good guide for anyone to follow, you don't need anything from them but you obviously need what they state which are pretty much the essentials anyone would have laying around.
Sent from my SAMSUNG-SGH-I337 using Tapatalk
The guy that's doing arkOS is touting it's (future?) ability to act Tor node. Might want to look into that?
I was doing my first raspberry pi electronic project. I choosed the adafruits Google docs logging project for a start. The project was a success and I obtained a complete output. My problem is , when I looked into the python program provided by adafruit (got it from github) it is calling other small programs. So I looked one of the called programs and it again calls other program.
I want to write a complete program that includes all the necessary things ie a stand alone version.
I want to write it in python 2. Also use a gpio pin 5. My model of pi is raspberry pi 2 model b.
I don't know whether I can include driver in my program. But if it is possible , I also want to include the driver too, please help me.
I am trying to figure out how I can light an LED with my NodeMCU V2 via the use of WiFi and a phone application I create via Android Studio but I don't know where to start nor can I find any information on how I can do it, I've seen tutorials where they make me use their 3rd party tools to achieve this and I've seen it done on a web server but I'd like it to be on a phone application. Is there any way this can be done? Bluetooth is not an option because I want it to be accessed from anywhere as I plan to port-forward the IP in the future.
This is a very interesting idea. I do not have a specific answer. I did some programming of 68HC11 about 20 years ago. The chip was mounted on a system board and connected to my desktop computer using a serial cable. I would develop the program on the desktop then download to the `11 over the serial cable. There was a small program in the `11 that would receive the program and load it into the `11 memory.
Structurally you need similar components: a software development system that run in your phone [a small Android Studio], an electronic communication link [Bluetooth, http, whatever], a system board, and software in the system board to receive commands and a data stream from the phone and load the stream of machine language into the 68HC11.
I still have the system board: CME11E9-EVBU AXM-0199 REV.C Axiom Manufacturing. For more info do a Google search for that ID, or just click here...
https://canada.newark.com/axiom/cme-11e9-evbu-ed/spi-sci-rs232-lcd-dev-board/dp/13C2791
I am not familiar with what is going on in that section of technology these days, but much of what you need should be available and findable. If such a system does not yet exist then it is a business opportunity waiting for someone like yourself.
All the best to you