Answered by:
XAMPP Install On WHS

Question
-
Hello:
I have been using WHS for 6 months, and it is very Smooth!! All functions are working correctly, including my 6 workstation backups. I have a new client that requires that I install XAMPP on my WHS server so that I can test linkage from Microsoft Access to MySQL. I wondered if anyone has any words of wisdom regarding both installing XAMPP on WHS and any negative effect it might have on performance or functionality, and in the worst case scenario, how to uninstall XAMPP and remove all traces in case there is an issue with WHS.
Regards,
Rich Locus
Logicwurks, LLC
Thursday, August 26, 2010 9:14 PM
Answers
-
On 8/26/2010 4:14 PM, RichLocus wrote:
Hello:
I have been using WHS for 6 months, and it is very Smooth!! All functions are working correctly, including my 6 workstation backups. I have a new client that requires that I install XAMPP on my WHS server so that I can test linkage from Microsoft Access to MySQL. I wondered if anyone has any words of wisdom regarding both installing XAMPP on WHS and any negative effect it might have on performance or functionality, and in the worst case scenario, how to uninstall XAMPP and remove all traces in case there is an issue with WHS.
Regards,
Rich Locus
Logicwurks, LLCI don't think you can install XAMPP on WHS (as you would have to use Remote Administration, and that's not supported). Also it would potentially conflict with IIS (which is the web server used by WHS). Could you install it on a workstation, and connect to that instead? If you're simply testing connection between Access and MySQL, then it shouldn't matter where the MySQL database/webserver is installed. Currently I have Glassfish/MySQL installed as part of my Java course study (on my laptop).
Hope this helps, and have a great day:)
Patrick.
-- Smile... Someone out there cares deeply for you.
Have you updated today?
http://update.microsoft.com
Smile.. Someone out there cares deeply for you.- Marked as answer by RichLocus Friday, August 27, 2010 3:36 PM
Friday, August 27, 2010 2:39 AM -
As Patrick has said, technically installing XAMPP on your server isn't supported, and if you're concerned about the stability of your server you should probably install elsewhere. Perhaps you could install it in a virtual machine? Virtualization tools are a great help for development; you can set up a dedicated environment for testing with no risk to the host platform.
For questions like "how to uninstall XAMPP and remove all traces" you'll have to go to a forum for XAMPP, I'm afraid.
I'm not on the WHS team, I just post a lot. :)- Proposed as answer by Ken WarrenModerator Friday, August 27, 2010 12:22 PM
- Marked as answer by RichLocus Friday, August 27, 2010 3:36 PM
Friday, August 27, 2010 12:22 PMModerator
All replies
-
On 8/26/2010 4:14 PM, RichLocus wrote:
Hello:
I have been using WHS for 6 months, and it is very Smooth!! All functions are working correctly, including my 6 workstation backups. I have a new client that requires that I install XAMPP on my WHS server so that I can test linkage from Microsoft Access to MySQL. I wondered if anyone has any words of wisdom regarding both installing XAMPP on WHS and any negative effect it might have on performance or functionality, and in the worst case scenario, how to uninstall XAMPP and remove all traces in case there is an issue with WHS.
Regards,
Rich Locus
Logicwurks, LLCI don't think you can install XAMPP on WHS (as you would have to use Remote Administration, and that's not supported). Also it would potentially conflict with IIS (which is the web server used by WHS). Could you install it on a workstation, and connect to that instead? If you're simply testing connection between Access and MySQL, then it shouldn't matter where the MySQL database/webserver is installed. Currently I have Glassfish/MySQL installed as part of my Java course study (on my laptop).
Hope this helps, and have a great day:)
Patrick.
-- Smile... Someone out there cares deeply for you.
Have you updated today?
http://update.microsoft.com
Smile.. Someone out there cares deeply for you.- Marked as answer by RichLocus Friday, August 27, 2010 3:36 PM
Friday, August 27, 2010 2:39 AM -
As Patrick has said, technically installing XAMPP on your server isn't supported, and if you're concerned about the stability of your server you should probably install elsewhere. Perhaps you could install it in a virtual machine? Virtualization tools are a great help for development; you can set up a dedicated environment for testing with no risk to the host platform.
For questions like "how to uninstall XAMPP and remove all traces" you'll have to go to a forum for XAMPP, I'm afraid.
I'm not on the WHS team, I just post a lot. :)- Proposed as answer by Ken WarrenModerator Friday, August 27, 2010 12:22 PM
- Marked as answer by RichLocus Friday, August 27, 2010 3:36 PM
Friday, August 27, 2010 12:22 PMModerator -
Thanks for the reply... you probably saved me a nightmare :)
OK... no install of XAMPP on WHS!!!
I will install it on one of my 6 workstations that are connected to WHS. Since I have 6 actual workstations, one of them is my experiment platform and I will use it. I will assume that I can somehow connect to it using Windows pier to pier networking.... or just put the Access DB on the same workstation as the MySQL DB and then connect to it in that manner... now all I have to do is get the Connect String to attach a MySQL database to Access... probably have to jump through a few hoops as usual :)
Regards,
Rich Locus
Logicwurks, LLC
Friday, August 27, 2010 3:42 PM -
On 8/27/2010 10:42 AM, RichLocus wrote:
Thanks for the reply... you probably saved me a nightmare :)
OK... no install of XAMPP on WHS!!!
I will install it on one of my 6 workstations that are connected to WHS. Since I have 6 actual workstations, one of them is my experiment platform and I will use it. I will assume that I can somehow connect to it using Windows pier to pier networking.... or just put the Access DB on the same workstation as the MySQL DB and then connect to it in that manner... now all I have to do is get the Connect String to attach a MySQL database to Access... probably have to jump through a few hoops as usual :)
Regards,
Rich Locus
Logicwurks, LLC
As far as connecting to the XAMPP server, it should open the proper ports on your firewall (3306 is the default for MySQL and 80 is the default for Apache's HTTP, but the rest I'm not sure about). You most likely won't have remote (read that as outside of your local network) access to the Apache webpages, unless you port forwarding from a different external port (8080 for example) to port 80 on the XAMPP computer--because WHS is using Port 80, 443, and 4125.
Above and beyond that, you'll want to go to the XAMPP forums or look for information online about configuring it with Access. http://www.connectionstrings.com/ may help you with the connection strings.
Have a great day:)
Patrick.
Smile... Someone out there cares deeply for you.
Have you updated today?
http://update.microsoft.com
Smile.. Someone out there cares deeply for you.Saturday, August 28, 2010 8:15 PM