Installing phpMyAdmin using a virtual host

Report · Dec 31, 2006

The situation:
Apache services are running (Windows XP SP2).
Virtual host has been successfully created and works both
with Dreamweaver php pages and pages entered directly in the
browser address bar (e.g. http://mysite/folder/foo.php.
Server root is d:\htdocs.
Sites stored in this server root: d:\htdocs\mysite.
phpMyAdmin folder stored in the server root
d:\htdocs\phpMyAdmin.

My problem:
I have successfully installed MySql and try to configure
phpMyAdmin according to the reccomendations in David Powers
book "PHP solutions". When I start to load the setup php
using the address: http://phpmyadmin/scripts/setup.php I am
automatically connected to the internet and this page is
loaded http://www.phpmyadmin.net/home_page/index.php
I have then manually modified the config.inc.php and stored
in the phpMyAdmin root. If I try to launch phpMyAdmin by
entering http://phpmyadmin/ the same page is loaded from the
internet but not phpMyAdmin.

What have I missed and how can I get phpMyAdmin to work
properly?

Paul

Report · Dec 31, 2006

Paul Westrich wrote:
> I have then manually modified the config.inc.php and stored
> in the phpMyAdmin root. If I try to launch phpMyAdmin by
> entering http://phpmyadmin/ the same page is loaded from the
> internet but not phpMyAdmin.

What happens, if you try:
http://localhost/phpmyadmin/ (assumed the server hostname is "localhost")?

Martin

Report · Dec 31, 2006

Martin Lang schrieb:
> What happens, if you try:
> http://localhost/phpmyadmin/ (assumed the server hostname is "localhost")?

this only works if you don't have a virtual host installed
(see my posting and following replies in this forum on Dec
27). When I test my php pages and includes I also have to
enter http://mysite/index.php

Thanks for your tip
Paul

Report · Dec 31, 2006

Paul Westrich wrote:
> If I try to launch phpMyAdmin by
> entering http://phpmyadmin/ the same page is loaded from the
> internet but not phpMyAdmin.

Have you added phpmyadmin 127.0.0.1 to your hosts file?
Have you set up the virtual host definition for phpmyadmin in httpd.conf?

Quite honestly, though, I don't see any value in creating a virtual host
for phpmyadmin in your testing environment. The value of virtual hosts
is mainly to enable the use of site-root-relative links. You don't need
that for phpmyadmin.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Report · Dec 31, 2006

David Powers schrieb:
> Have you added phpmyadmin 127.0.0.1 to your hosts file?

Oh no, I should known better 😉 Didn't think of that.

> Have you set up the virtual host definition for phpmyadmin in httpd.conf?

No, but have done it now. Now I can load phpMyAdmin into my
browser but I am getting the error "Cannot load mysqli
although this extension is in my php5/ext folder and it is
added to config.inc.php
$cfg['Servers'][$i]['extension'] = 'mysqli'; // The
php MySQL extension to use ('mysql' or 'mysqli')

> Quite honestly, though, I don't see any value in creating a virtual host
> for phpmyadmin in your testing environment. The value of virtual hosts
> is mainly to enable the use of site-root-relative links. You don't need
> that for phpmyadmin.

Ok. So having installed the virtual host for phpMyAdmin just
lets me test if its running on my PC? Withougt a virtual
host how can I see if phpMyAdmin works?

Thanks for your help.
Paul

Report · Dec 31, 2006

Paul Westrich schrieb:

> No, but have done it now. Now I can load phpMyAdmin into my
> browser but I am getting the error "Cannot load mysqli
> although this extension is in my php5/ext folder and it is
> added to config.inc.php
> $cfg['Servers'][$i]['extension'] = 'mysqli'; // The
> php MySQL extension to use ('mysql' or 'mysqli')

I have solved this. My bad, I had forgotten to add the
quotes in the path.
But now I am getting a read error from Apache.exe when
trying to load phpMyAdmin and when I check the Apache icon
in the task bar I see that it is not running.

Thanks for your patience.
Paul

Report · Jan 01, 2007

Paul Westrich schrieb:
> But now I am getting a read error from Apache.exe when
> trying to load phpMyAdmin and when I check the Apache icon
> in the task bar I see that it is not running.

Solved this, too, by reinstalling everything and editing the
php.ini und http.conf.
Now everything seems to work fine (php, apache, mysql
server) except that I cannot run phpMyAdmin because due to
my having installed a virtual host for my php site with
relative links my browser does not accept the address
http://localhost/phpMyAdmin.
Entering http://phpMyAdmin/ would only work if I had a
virtual host for phpMyAdmin which now I don't.
So what can I do to leave my virtual host for my php site
and to be able to start phpMyAdmin along with this?

Thanks for any help.
Paul

Report · Jan 01, 2007

Paul Westrich schrieb:

> Now everything seems to work fine (php, apache, mysql
> server) except that I cannot run phpMyAdmin because due to
> my having installed a virtual host for my php site with
> relative links my browser does not accept the address
> http://localhost/phpMyAdmin.
> Entering http://phpMyAdmin/ would only work if I had a
> virtual host for phpMyAdmin which now I don't.
> So what can I do to leave my virtual host for my php site
> and to be able to start phpMyAdmin along with this?

Seem to have solved this, too, by moving the folder
phpMyAdmin into the folder of d:/htdocs/mySite which is my
local server. Now I can start phpMyAdmin und have already
created the first database :-)

Paul