Nairaland Forum

Welcome, Guest: Join Nairaland / Login / Trending / Recent / New
Stats: 1259898 members, 1702593 topics. Date: Saturday, 25 October 2014 at 10:09 PM

Setting Up Wamp Server To Run On Local Area Network - Webmasters - Nairaland

Nairaland Forum / Science/Technology / Webmasters / Setting Up Wamp Server To Run On Local Area Network (52675 Views)

How To Successfully Upgrade Mysql Of Wamp Server / Help I Need A Local Server To Test Some Joomla 2.5 Template On My Computer / Wamp Installation Error. (1) (2) (3) (4)

(0) (Reply) (Go Down)

Setting Up Wamp Server To Run On Local Area Network by tundewoods(m): 11:46pm On Apr 12, 2008
About a month ago i decided to set up a wireless area network in my office using a netgear wireless router basically to share my broadband internet access and some minor file sharing.

However i also would love to have my WAMP server to run from a paricular system which is the server work station and be able to access it on other machines via my wireless network.I have done the basic stuff like creating a work group and assigning ip addresses like 192.168.1.1 and so on.

However i notice that the HTTPS Config file in the apache of WAMP need to be configured to map the ip address of the particular work station as well the rights of the mysql database needs to granted to enable changes from other systems.

Where i am kinda confused is the area of the ip address that will be used to access the local host across the network.On the local system i guess one can use http://127.0.0.1/ to access local host but in the case of a network whats the mapping parameters ?

Really appreciate help on steps to guide me through just in case you have configured the latest WAMP 2.0 server across a network to enable other systems or machines to be able run websites locally on the network or intranet
Re: Setting Up Wamp Server To Run On Local Area Network by uspry1(f): 1:02am On Apr 13, 2008
If you develop multiple websites from hosting server, all you need is to add a virtual host to httpd.conf and let windows HOSTS file know about it. It is found at Apache httpd.conf somewhere. The code like this:


<VirtualHost *>
ServerName yourdomain
DocumentRoot /home/yourdomain/public_html/
ScriptAlias /cgi-bin/ /home/yourdomain/public_html/cgi-bin/
</VirtualHost>


Google to find more info about Virtual host configuration on Apache server.

So I believe that your WAMP control manager has its own built-in Virtual Host configuration the day you were first time installed them on your computer or laptop. I did that which it prompted asking me what my virtual host is, nice manager configuration. Be sure that your WAMP version updated.
Re: Setting Up Wamp Server To Run On Local Area Network by tundewoods(m): 12:16pm On Apr 13, 2008
@ uspry1

Thanks for the info regarding virtual host set up.I have actually attached a copy of my httpd.config file.can you kindly download it and see if you can locate where i need to modify.

Re: Setting Up Wamp Server To Run On Local Area Network by uspry1(f): 4:44pm On Apr 13, 2008
tundewoods:

@ uspry1

Thanks for the info regarding virtual host set up.I have actually attached a copy of my httpd.config file.can you kindly download it and see if you can locate where i need to modify.


@tundewoods

You're welcome. No need for me to download your copied httpd.config, because i am very familiar finding where you need to modify the easy way as follow below:

1.) Open your Apache httpd.config

2.) Search for Virtual Host section, using text editor toolbar menu, "EDIT" to select "FIND", then it will prompts you a FIND dialog box entering the blank"FIND WHAT" field box the exact wording>>>: "Section 3: Virtual Hosts" without a quote.

3.) It will search pointing the highlight text of "Section 3: Virtual Hosts", then scroll down reading the following configuration instruction and Virtual host example VERY CAREFUL.

4.) Create your own multiple virtual host placing in the between of the end of the Virtual host example and "INCLUDE" tag. Your example multiple virtual hosts like this below: [please check your Apache2 documentation if you are doubt]

Create the file-first domain:

#
# Example.com (/etc/apache2/sites-available/www.example.com)
#
<VirtualHost *>
ServerAdmin webmaster@example.com
ServerName www.example.com
ServerAlias example.com

# Indexes + Directory Root.
DirectoryIndex index.html
DocumentRoot /home/www/www.example.com/htdocs/

# CGI Directory
ScriptAlias /cgi-bin/ /home/www/www.example.com/cgi-bin/
<Location /cgi-bin>
Options +ExecCGI
</Location>


# Logfiles
ErrorLog /home/www/www.example.com/logs/error.log
CustomLog /home/www/www.example.com/logs/access.log combined
</VirtualHost>



Next create the file-second domain:

#
# Example.net (/etc/apache2/sites-available/www.example.net)
#
<VirtualHost *>
ServerAdmin webmaster@example.net
ServerName www.example.net
ServerAlias example.net

# Indexes + Directory Root.
DirectoryIndex index.html
DocumentRoot /home/www/www.example.net/htdocs/

# CGI Directory
ScriptAlias /cgi-bin/ /home/www/www.example.net/cgi-bin/
<Location /cgi-bin>
Options +ExecCGI
</Location>


# Logfiles
ErrorLog /home/www/www.example.net/logs/error.log
CustomLog /home/www/www.example.net/logs/access.log combined
</VirtualHost>



Finally create the file - third domain:

#
# Example.org (/etc/apache2/sites-available/www.example.org)
#
<VirtualHost *>
ServerAdmin webmaster@example.org
ServerName www.example.org
ServerAlias example.org

# Indexes + Directory Root.
DirectoryIndex index.html
DocumentRoot /home/www/www.example.org/htdocs/

# CGI Directory
ScriptAlias /cgi-bin/ /home/www/www.example.org/cgi-bin/
<Location /cgi-bin>
Options +ExecCGI
</Location>


# Logfiles
ErrorLog /home/www/www.example.org/logs/error.log
CustomLog /home/www/www.example.org/logs/access.log combined
</VirtualHost>



5.) That's it! Save your Apache httpd.config, then go back to Apache start/stop manager to restart the Apache server in order to refresh the new configuration updating.

6.)If you plan to terminate the domain and open your Apache httpd.config, use EDIT/FIND menu to type the name of domain you want to delete. It will prompt the right place (highlight text) and delete that domain name virtual host. Repeat on number 5 above.

NOTICE: ServerAdmin clause, you don't have to use "webmaster@yourdomain.com", it also can be "yourusername@yourdomain.com", that is fine with me! I hope you did set up your domain email forward or account to your yahoo mail or outlook express if you are too busy to access secured domain webmail checking incoming messages.

I hope it helps! Good day Tundewoods!
Re: Setting Up Wamp Server To Run On Local Area Network by cmon(m): 2:31pm On Apr 16, 2008
@ uspry1
Are you really a female? If yes, then I'm impressed. Most ladies usually look at IT as a man's world. I guess the world is rapidly changing.

Looks like you know so much about these Networking stuffs. I'm just a website developer (well you can say a new one grin). When I get web projects, I usually do the hosting on external servers. Now a client wants to run a database on his system (Connected to the internet) and be able to synchronize the database on his local server (computer system) with the one on his website. How do I accomplish that?

Here's my point:

I'm of fan of the popular XAMPP software. Even if I install the XAMPP on his local system, how do I get to synchronize the database system (MySQL) with that of his website or how do I get the website to use the database on his local system using PHP, enabling real-time contents of the database to reflect on the website?
Re: Setting Up Wamp Server To Run On Local Area Network by uspry1(f): 11:14am On Apr 17, 2008
@cmon

Yes I am really FEMALE to look at IT since my first personal computer started about 20 years ago as technology changed dramatically. Also I am DEAF too!!!

Read my posting on the topic, "DO YOU LOVE COMPUTER" at below:

http://www.nairaland.com/nigeria/topic-120021.0.html#msg2059776

Let's me answer your questions next page.
Re: Setting Up Wamp Server To Run On Local Area Network by uspry1(f): 11:57am On Apr 17, 2008
There are three ways you can do MySQL remote/local synchronization for your client working on your web project at below:

1.) You could use MySQL replication, with your laptop as a replication client. Each time you connect your laptop will pull all changes to your tables since the last time you connected.

The replication is about zero writes on the slave. It is used where you expect a slave to do nothing. Of course, you can use replication to get the source data into one database on your local server, then copy the data to a working schema using INSERT , SELECT queries and only make changes on the working schema.

2.) Under the website development contract where it is shown the agreeing with you and your client to furnish client's hosting server login system (username/password) to access the client's remote MySQL server, you can copy the data from your local server to remoted working schema using INSERT, SELECT queries and modify the working schema.

3.) You register the web-based remote access such as "GoToMyPC" (link: https://www.gotomypc.com/) or set up using Windows XP/Vista's "Remote Assistance" with Windows Live Messenger (formerly MSN Messenger) that allowing you to access remoted client's computer system to open client's local server to replicate source data into client's MySQL using INSERT, SELECT queries and modifying the working schema. Be sure you and your client must have Windows Live Messenger login on. Google how to use Windows' Remote Assistance or check with your Windows XP/Vista Help and Support.

It is usually for remote web developer for foreigner/remote client in the distance without driving or meeting in person.

** If you are LINUX OS, then I am bit rusty to answer MySQL remote/local synchronization with LINUX. . .it would be different LINUX syntax. I used to be familiarized with LINUX debian-based OS in the past. **
Re: Setting Up Wamp Server To Run On Local Area Network by uspry1(f): 12:10pm On Apr 17, 2008
The most of time I deal with my clients working on MySQL database, I do replicate all my source data from my local server (not client's local server) to be copied into my client's remote MySQL server with client's hosting server username/password access according to my/client's website development agreement/contract.

Of course I code INSERT, SELECT on MySQL queries to modify the working schema in quality of database functionally the exactly the same as my local server.

I have no problem with that!

I used to have "GOTOMYPC" remote access to client's computer system in the distance only for COMPUTER REPAIR such as Virus attack, software upgrades, etc. as well as pick up document/pictures/external files need for my design project ONLY WITH CLIENT'S PERMISSION. Because my client is CLUELESS about computer, do not know nothing about it!

I terminated "GOTOMYPC", because it cost money per month!!!
Re: Setting Up Wamp Server To Run On Local Area Network by gbolio4(m): 12:48am On Apr 25, 2008
uspry1:

@cmon

Also I am DEAF too!!!


Must you always stress that point?
Re: Setting Up Wamp Server To Run On Local Area Network by ircguru: 7:00am On Nov 07, 2009
I upright start identical right mailing index archives into unix http://maillistarchives.com can you lend me any other, i constraint some established mailing lean over archivs and usenet archives after unix and/or linux

(0) (Reply)

Is Your Blog Powered By Wordpress? / Eid Mubarak From Seomarts.com / Yookos.com – Christ Embassy’s Social Networking Site.

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (0) (1) (2) (3) (4) (5) (6) (7) (8) (9)

Nairaland - Copyright © 2005 - 2014 Oluwaseun Osewa. All rights reserved. See Nairalist and How To Advertise. 65
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.