WampServer

Hi there,

Myself and our IT guy are currently trying to install WAMP to use phpMyAdmin.

We're almost there - have WAMP installed, Apache running OK, and the WAMP homepage appearing with [servername]

But the link to the phpmyadmin alias is coming up with a forbidden : You don't have permission to access /phpmyadmin/ on this server error message.

Any clues as to what permissions need to be set up where?

Cheers,
Iain

have you changed anything in your httpd.conf file or phpmyadmins config file?

Not that I'm aware of - I've basically used it all before, but through a web host, whereas now I'm trying to get it set up on a small network at my office. So I have some knowledge, and the IT guy has a bit more knowledge from setting up stuff on a server, although this is new to him - so we're trying to get there between us.

It seems to be installed OK, and Apache is running, and online - so we can see the WAMP main page at [servername] - but the link through to phpMyAdmin is forbidden.

Presumably it's almost there, and just a rights / permissions issue - but we're just not sure of what exactly.

Iain

what error code do you get when you try to access phpmyadmin?

It's just a standard 404 style page saying :

Forbidden
You don't have permission to access / on this server.
Apache/2.0.59 (Win32) PHP/5.1.6 Server at servername Port 80

We have Apache and MySQL running, we have it online, we can see the WAMP homepage at [localhost], and have editid the config.inc.php file to include 'localhost' and the password details, the domain users on the network have rights to the WAMP folder, but the phpMyAdmin link is still forbidden on any remote machine - although is fine on the server box.



Post Edited (11-02-06 11:17)

you do not need to edit anything in the phpmyadmin config file. the only thing you should change is the password for the password for the root user if you have changed the password for the root user in the mysql users privileges table.

what lines did you change?

CyberSpatium
WAMP English Forum Admin

Hi,

I'm back home now, bit if I recall correctly, one was adding in the password here :

$cfg['Servers'][$i]['password'] = 'Your_new_password_here';

There was something else, to do with 'localhost' I think - I'll need to check in the morning. But it was from some WAMP documentation - putting in the name of the server or something along those lines.

Before this we couldn't get phpMyAdmin up on the server box tho', and when we did we could - so we thought that was progress - but we just couldn't get it on any other machine on the network. So it didn't make anything worse at least.

EDIT - found what we did from the FAQs here :

First, replace this line :

$cfg['PmaAbsoluteUri'] = '';

by

$cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin/';

This is to make disappear one of the error messages on phpmyadmin's homepage.

Now you just need to add your new password :

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'your new password'; // MySQL password (only needed with 'config' auth_type)

Save your file and it's done...

From :

FAQ page

Iain



Post Edited (11-02-06 21:44)

change:
$cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin/';

to
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';

when you install wamp, the mysql user root does not have any password set. you only need to edit the $cfg['Servers'][$i]['password'] setting if you have changed the root user's password in the mysql users table. if you have not change the mysql root user's password then change your password setting to this:
$cfg['Servers'][$i]['password'] = '';

I recently posted a detailed phpmyadmin tutorial here. I explain how to add a password for the root user, and even how to add new users:
[forum.wampserver.com]

CyberSpatium
WAMP English Forum Admin

Cheers for that - the full URL was one of the things I scribbled down to check when I was searching the forum for clues earlier, but didn't get a chance to see IT blokey to change it on the server box.

The IT guy had added a password in to phpMyAdmin, so it did need to go in there too.

Hopefully the full URL will fix it - will post back tomorrow and let you know.

Iain



Post Edited (11-03-06 01:20)

Do you have the same error message when accessing SQLiteManager?

Iain wrote:

> We're almost there - have WAMP installed, Apache running OK,
> and the WAMP homepage appearing with [servername]
>
> But the link to the phpmyadmin alias is coming up with a
> forbidden : You don't have permission to access /phpmyadmin/
> on this server error message.
>
> Any clues as to what permissions need to be set up where?

I assume that perhaps you are accessing from a different PC on the network (ie. not the localhost)?

If this is the case, what you describe would occur if you had allowed access rights to the server iself in httpd.conf, but had not enabled access in the phpmyadmin.conf and sqlitemanager.conf.

ie. Access appears to default to only allow from localhost (127.0.0.1).

These .conf files are normally located in the alias subfolder of the apache conf folder, but are referred to as includes in the main httpd.conf if ou can't find them.

Hope this is of assistance.

Yes - the developement work will be done on a PC on the network rather than the local host. What exactly needs changing in these files?

We'll try the full [localhost] URL first and see if that does anything.

Iain

Changing the that hasn't fixed it unfortunately, even after restarting apache and mySQL.

I saw somethinbg else about :

'check the permissions to the phpmyadmin directory are correct - it does look like the web server permissions are denying access to the PHPmyadmin folders. I usually just drop the PHPmyAdmin files in a web site folder and it has always worked that way. The PHpmyAdmin folder will need to have the same permissions as a normal web page as it will need access to the web server to operate'

But am not sure where exactly these web server permissions are set?

Same error with the SQLiteManager BTW.

Iain

Koolkiwi already mentioned "how to"

He posted something about permissions in phpmyadmin.conf and httpd.conf files, and where they should be - but not how to do anything?

I'm coming to this from a design background after all, not an administrator/techie background.

Iain

[forum.wampserver.com]

CyberSpatium
WAMP English Forum Admin

Iain wrote:
> He posted something about permissions in phpmyadmin.conf and
> httpd.conf files, and where they should be - but not how to do
> anything?
> Iain

Apologies. If you look inside the .conf files I mentioned, hopefully it is self explanatory.

eg. sqlitemanager.conf looks like this:
---
Alias /sqlitemanager/ "c:/wamp/sqlitemanager/"

# to give access to sqlitemanager from outside
# replace the lines
#
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#
# by
#
# Order Allow,Deny
# Allow from all
#

<Directory "c:/wamp/sqlitemanager/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
</Directory>
---

The key part you are looking for is:
---
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
---

This default setting only allows access from the localhost ie. 127.0.0.1 (no one else on your network)!

As per the comments, the quick fix is to "allow all", as per:
---
Order Allow,Deny
Allow from all
---

These 2 .conf files are just "Includes" to the main apache httpd.conf file.

Hope this clarifies.



Post Edited (11-03-06 22:05)

Thanks guys - I'm usually OK when I get started with things, but always seem to have trouble with the little things like this - there always seem to be little things you have to do that are obvious if you know what you're doing, but not if you don't.

It's all appreciated.

Iain

Thanks again - it was the permissions thing as you said Koolkiwi - so that side of it is sorted.

Just need to get Dreamweaver to connec to it now - which is coming up with an error message, but I think it's a permissions thing for me on the server.

Iain

This probably isn't still a WAMP issue, but I'll ask anyway to check.

We're now having an issue setting permissions to for a network user to save files to the WAMP directory / folders, even tho' the required permissions have been assigned to the user (myself) on the network for that drive / lolcation.

Is there anything else in the WAMP settings that might be causing this?

Iain