phpMyAdmin / Aliases / VHosts
Posted by: alebald (---.dl.dl.cox.net)
Date: April 21, 2006 07:21AM

I'm having a bit of a problem and I cannot seem to figure out what I'm overlooking. I will state upfront that I am using it in a production environment, however the sites that are hosted are all mine and won't hurt me if they go down a couple of days. So here we go.....I installed WAMP with all the defaults and then modified my httpd.conf as such:

NameVirtualHost *:80

#
#### localhost ####
#

<VirtualHost *:80>
ServerAdmin root@localhost
DocumentRoot C:/wamp/www
ServerName localhost
ErrorLog C:/wamp/logs/error.log
CustomLog C:/wamp/logs/access.log common
<Directory "C:/wamp/www">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/wamp/www/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
</VirtualHost>

#
#### www.domain1.net ####
#

<VirtualHost *:80>
ServerAdmin admin@domain1.net
DocumentRoot C:/wamp/users/www.domain1.net/public_html
ServerName www.domain1.net
ServerAlias domain1.net
ErrorLog C:/wamp/users/www.domain1.net/logs/error.log
CustomLog C:/wamp/users/www.domain1.net/logs/access.log common
<Directory "C:/wamp/users/www.domain1.net/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain1.net/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
</VirtualHost>

#
#### www.domain2.com ####
#

<VirtualHost *:80>
ServerAdmin admin@domain2.com
DocumentRoot C:/wamp/users/www.domain2.com/public_html
ServerName www.domain2.com
ServerAlias domain2.com
ErrorLog C:/wamp/users/www.domain2.com/logs/error.log
CustomLog C:/wamp/users/www.domain2.com/logs/access.log common
<Directory "C:/wamp/users/www.domain2.com/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain2.com/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
</VirtualHost>

#
#### www.domain3.com ####
#

<VirtualHost *:80>
ServerAdmin admin@domain3.com
DocumentRoot C:/wamp/users/www.domain3.com/public_html
ServerName www.domain3.com
ServerAlias domain3.com
ErrorLog C:/wamp/users/www.domain3.com/logs/error.log
CustomLog C:/wamp/users/www.domain3.com/logs/access.log common
<Directory "C:/wamp/users/www.domain3.com/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain3.com/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
</VirtualHost>

#
#### www.domain4.com ####
#

<VirtualHost *:80>
ServerAdmin admin@domain4.com
DocumentRoot C:/wamp/users/www.domain4.com/public_html
ServerName www.domain4.com
ServerAlias domain4.com
ErrorLog C:/wamp/users/www.domain4.com/logs/error.log
CustomLog C:/wamp/users/www.domain4.com/logs/access.log common
<Directory "C:/wamp/users/www.domain4.com/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain4.com/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
</VirtualHost>

#
#### www.domain5.us ####
#

<VirtualHost *:80>
ServerAdmin admin@domain5.us
DocumentRoot C:/wamp/users/www.domain5.us/public_html
ServerName www.domain5.us
ServerAlias domain5.us
ErrorLog C:/wamp/users/www.domain5.us/logs/error.log
CustomLog C:/wamp/users/www.domain5.us/logs/access.log common
<Directory "C:/wamp/users/www.domain5.us/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain5.us/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
</VirtualHost>

As you can see all of the VHosts are setup correctly, although I did add the following options to protect webalizer through .htaccess/.htpasswd

<Directory "C:/users/www.domain5.us/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>

So far so good this is all working great, however I want to be able to allow access to the phpMyAdmin from not just localhost but also to these other domains 1-5 through aliasing I would assume. I have made a control user within MySQL and setup phpMyAdmin to use HTTP authentication. However how do I allow this to be accessed not just from localhost but also all the domains, that way it can be used as a central phpMyAdmin installation.

Thanks in advance,
RBrantley


Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: CyberSpatium (---.hsd1.or.comcast.net)
Date: April 21, 2006 07:38AM

phpmyadmin is just a script that helps you admin and and use mysql. You can use the same mysql user with all your domains\websites with no problems, so there is no reason to allow phpmyadmin access for each domain.

Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: alebald (---.dl.dl.cox.net)
Date: April 21, 2006 01:52PM

I realize that it is just a script and can be used in a centralized manner. However that is also my problem I don't know how to make it accessible from anything other than localhost. I assumed it was an alias type setting but I really don't know overall.

Thanks in advance,
RBrantley

Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: TwistedChaos (---.rochester.res.rr.com)
Date: April 21, 2006 03:22PM

nothing should be stopping your access from each domain....

try calling it from [your.domain.com]



A Massive Heart Attack = Computer Crash sad smiley

I am a member of CAF -&gt; Computer Addicts Forever smiling smiley

Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: alebald (---.lu.dl.cox.net)
Date: April 21, 2006 04:48PM

Tried with all domains other than localhost and no go. On localhost it works correctly. Also tried by IP address and no such luck either. Doesn't make a whole lot of sense why it's not working but I've tried just about everything I can think of. If needed I can post alias files etc....

Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: TwistedChaos (---.rochester.res.rr.com)
Date: April 21, 2006 05:12PM

OK i found the biggest difference in your files and mine... i dont use server alias

in order to use the alias add this line to the end of each <virtual host> container:

Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"


so it should look like:

Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
</VirtualHost>



A Massive Heart Attack = Computer Crash sad smiley

I am a member of CAF -&gt; Computer Addicts Forever smiling smiley

Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: alebald (---.lu.dl.cox.net)
Date: April 21, 2006 10:53PM

Thanks a ton TwistedChaos,

I will try this as soon as I get near a computer and let you know the results smiling smiley

Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: alebald (---.dl.dl.cox.net)
Date: April 21, 2006 11:43PM

Ok added the alias include statement in the http.conf as follows:


NameVirtualHost *:80

#
#### localhost ####
#

<VirtualHost *:80>
ServerAdmin root@localhost
DocumentRoot C:/wamp/www
ServerName localhost
ErrorLog C:/wamp/logs/error.log
CustomLog C:/wamp/logs/access.log common
<Directory "C:/wamp/www">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/wamp/www/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
</VirtualHost>

#
#### www.domain1.net ####
#

<VirtualHost *:80>
ServerAdmin admin@domain1.net
DocumentRoot C:/wamp/users/www.domain1.net/public_html
ServerName www.domain1.net
ServerAlias domain1.net
ErrorLog C:/wamp/users/www.domain1.net/logs/error.log
CustomLog C:/wamp/users/www.domain1.net/logs/access.log common
<Directory "C:/wamp/users/www.domain1.net/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain1.net/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
</VirtualHost>

#
#### www.domain2.com ####
#

<VirtualHost *:80>
ServerAdmin admin@domain2.com
DocumentRoot C:/wamp/users/www.domain2.com/public_html
ServerName www.domain2.com
ServerAlias domain2.com
ErrorLog C:/wamp/users/www.domain2.com/logs/error.log
CustomLog C:/wamp/users/www.domain2.com/logs/access.log common
<Directory "C:/wamp/users/www.domain2.com/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain2.com/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
</VirtualHost>

#
#### www.domain3.com ####
#

<VirtualHost *:80>
ServerAdmin admin@domain3.com
DocumentRoot C:/wamp/users/www.domain3.com/public_html
ServerName www.domain3.com
ServerAlias domain3.com
ErrorLog C:/wamp/users/www.domain3.com/logs/error.log
CustomLog C:/wamp/users/www.domain3.com/logs/access.log common
<Directory "C:/wamp/users/www.domain3.com/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain3.com/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
</VirtualHost>

#
#### www.domain4.com ####
#

<VirtualHost *:80>
ServerAdmin admin@domain4.com
DocumentRoot C:/wamp/users/www.domain4.com/public_html
ServerName www.domain4.com
ServerAlias domain4.com
ErrorLog C:/wamp/users/www.domain4.com/logs/error.log
CustomLog C:/wamp/users/www.domain4.com/logs/access.log common
<Directory "C:/wamp/users/www.domain4.com/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain4.com/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
</VirtualHost>

#
#### www.domain5.us ####
#

<VirtualHost *:80>
ServerAdmin admin@domain5.us
DocumentRoot C:/wamp/users/www.domain5.us/public_html
ServerName www.domain5.us
ServerAlias domain5.us
ErrorLog C:/wamp/users/www.domain5.us/logs/error.log
CustomLog C:/wamp/users/www.domain5.us/logs/access.log common
<Directory "C:/wamp/users/www.domain5.us/public_html">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/users/www.domain5.us/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
</VirtualHost>

After saving the http.conf and restarting Apache, I still receive the 404 not found page. Would it be a good idea to change mine to something more similar to yours TwistedChaos, as a test to see if it works? If so would you kindly post your httpd.conf section on vhosts and any other necessary information. Thanks again smiling smiley

RBrantley

Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: CyberSpatium (---.hsd1.or.comcast.net)
Date: April 22, 2006 06:02AM

you put the include in the wrong spot. you need to make sure that include is in the correct directory directive for it to work. you did:

<VirtualHost *:80>
ServerAdmin root@localhost
DocumentRoot C:/wamp/www
ServerName localhost
ErrorLog C:/wamp/logs/error.log
CustomLog C:/wamp/logs/access.log common
<Directory "C:/wamp/www">
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/wamp/www/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
</VirtualHost>

Change this to:

<VirtualHost *:80>
ServerAdmin root@localhost
DocumentRoot C:/wamp/www
ServerName localhost
ErrorLog C:/wamp/logs/error.log
CustomLog C:/wamp/logs/access.log common
<Directory "C:/wamp/www">
Include "c:/wamp/apache2/conf/alias/phpmyadmin.conf"
Options Indexes FollowSymLinks Includes +ExecCGI
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<Directory "C:/wamp/www/stats">
AllowOverride All
Options None
Order deny,allow
</Directory>
</VirtualHost>

now do the same thing for all your domains, save the file, and restar apache.



Post Edited (04-23-06 09:20)

CyberSpatium
----------------------
WAMP Forum Admin

Web Development for Newbie's Blog - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in “geek speak”, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.

Options: ReplyQuote
Re: phpMyAdmin / Aliases / VHosts
Posted by: TwistedChaos (---.rochester.res.rr.com)
Date: April 23, 2006 01:16AM

opps sorry wrong spot...thanx for saving me...lol



A Massive Heart Attack = Computer Crash sad smiley

I am a member of CAF -&gt; Computer Addicts Forever smiling smiley

Options: ReplyQuote


Sorry, only registered users may post in this forum.