iPhone Home Controller 2.1 Release and XAMPP Lite Tutorial

The 2.1 iPHC release is here. Not too much as far as styling changes but I have fixed some of the html and css. The application now uses jQuery at its core for event handling. This allowed me to, as is the jQuery way, “write less and do more.” The iPHC package should work a little faster now as jQuery can speed things up a bit. If you already have the iPHC system running, you can simply delete the old files and copy in the new ones (leave your connect.php file intact – there is no need to change it). The database settings have not changed so the switchover should be seamless.

For iPHC newbies, here is a step by step guide of how I got the system up and running at my house using Windows XP, XAMPP Lite, iPHC v2.1, the x10 cm15a, and an x10 module for testing.

1. Purchase the cm15a x10 transmitter. You will need at least one x10 module to control as well (also available from x10.com).

2. Install the cm15a driver/ActiveHome interface. (you should be able to download it here or) A link to download it comes in an email after you purchase the cm15a. Plug the cm15a into a usb port that is on the computer you will be installing the iPHC system on. Then plug the cm15a into the wall.

3. Download XAMPP lite. There is a zip file or an exe file to grab. Either one is fine. I placed the main xampp folder in my “program files” folder.

4. Open the xampplite folder and click setup_xampp.bat. After you see the success message you can close the window.

5. Download and unzip iPHC2.1. Copy the iPHC2.1 folder and paste it into the xampplite\htdocs folder.

6. Go back into the xampplite folder and click xampp_start. This should start mysql and apache. Leave the window that opens, open. Only use xampp_stop to stop mysql and apache. (Note: When I tried to start mysql and apache I got error messages with apache. In my case I had to add the file “msvcr71.dll” to the xampplite/apache/bin folder.)

7. Open a browser and type localhost into the address bar.

8. You should see the XAMPP welcome screen. Choose your language.

9. You can check the status of the install by clicking on status. Then click security.

10. Setup name and password for mysql and to secure your htdocs folder. This is essential if you are going to connect your system to the internet.

11. Copy the xampplite\phpMyAdmin folder and paste it into the xampplite\htdocs floder.

12. Go to localhost/phpMyAdmin in your browser and log in using the mysql name and password you had set up earlier. If you see a mcrypt error you can ignore it or follow the instructions here to get rid of it. You will have to restart xampp and log back in to see that it has been fixed.

13. Create a database called fonhome in phpMyAdmin.

14. Select the database you created and click import. Select the fonhome.sql file that is in the iPHC2.1 folder and upload it.

15. Locate the connect.php file in your xampplite\htdocs\iPHC2.1 folder and open it using a text editor or html editor. I use PSPad. Change the user name and password to the ones you had set up for mysql earlier and save the file.

16. In your web browser go to localhost/iPHC2.1.

17. If everything went well you should be able to see the interface and utilize its functions. Select admin at the top of the screen and use the form to add a new module. Name and enter the address of your test module and click add. Go to the modules screen and try turning on and off the module you have just added.

18. To get this going on your iPhone you need to find out your IP address. If you don’t have a router with a firewall or anything else in the way like an internal firewall then you should be able to paste this IP into your browser address window and get to the main XAMPP page. In my case I do have a router and have to open up port 80 on it as well as set my computer’s firewall to allow apache and mysql. You will have to search on how to do this for your specific router and firewall setup.

19. If everything works out you should be able to enter your IP address/iPHC2.1 in your iPhone browser (or any other web enabled mobile device) and access your system.

If there are any questions or comments let me know. I’ll add more as I keep testing.

Download iPHC2.1 here.

Leave a Reply

Your email address will not be published. Required fields are marked *

Reload the CAPTCHA codeSpeak the CAPTCHA code

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>