XAMPP and Drupal again (sorry)

harrisben - November 6, 2006 - 09:06

I'm trying to set up a local test server for Drupal and have followed the instructions provided on the many forum topics and handbook covering this combination of software, but I can't seem to get past the point of attempting to create the admin account.

As many others have described, after enter the username and email address of the intended admin account it returns an access denied message in drupal, not an apache 'access denied' message.

I'm running XAMPP under PHP4 and both Drupal 4.7.4 and 5.0 beta 1 exhibit the same problem. Obviously it's not Drupal, so does anyone have any idea where I may have gone wrong?

I should probably add that the web server and the pc I use to connect to it are seperate entities (of course, connected through the network).

Xampp on windows or macs

MySchizoBuddy - November 6, 2006 - 12:13

Xampp on windows or macs

Windows it is

harrisben - November 7, 2006 - 01:46

I've installed it on Windows. I only wish I had a mac here...

That's Drupal...

Max Bell - November 7, 2006 - 02:44

Not XAMPP/Apache -- Apache doesn't care about your Drupal password/account for admin at all -- that's all managed by Drupal. From your description, it sounds like you either A) haven't set up databases for each Drupal installation (5.0 will add it's own tables; 4.7 requires you to browse to the database folder in the Drupal directory and import the file from there) or B) might be trying to reinstall Drupal after databases had already been created and populated.

Regardless, don't feel bad about it if XAMPP seems tricky; I tried to install it, once, discovered I had to configure it by hand and went back to using Apache2Triad, which does all that for you. If you're out of ideas and not married to the XAMPP thing, you might try Apache2Triad instead; they're the same software, largely, just in a different package. I wrote a tutorial about how to do this that may or may not simplify or complicate the process further, if you're so inclined.

The database existed

harrisben - November 7, 2006 - 04:36

The database existed correctly for both 4.7.4 (after I imported the database) and 5.0b1 (after it populated the database), because I'm able to get the first page telling me to create the admin account and they are fresh and clean databases, not from a previous incarnation of anything.

I'll check out Apache2Triad, but XAMPP also worked fine out of the box (only this single problem). I should probably point out that I tried WAMP before this and ran into the exact same problem, so it's probably something really simple.

Ok, Test failed

harrisben - November 8, 2006 - 05:34

I followed your example exactly, but it refuses to work. So now WAMP, XAMPP and Apache2Triad all give me exactly the same problem. I'm really stumped as to what it might be.

Well...

Max Bell - November 8, 2006 - 06:45

Unfortunately, all I can really do is guess, never having run into this, myself. It'd make sense if it was rejecting the username and password for the database (since this would mean either the ones being used were wrong or the settings file was wrong), but clicking on the "create first user" link takes one to a form for a username and email address and then to the profile created for the username provided at which time you can change the password for that account. From what you're saying, you've already created the account and set the password and simply can't log back in for some reason.

If you still have a2t installed, it'd be worth checking the apache log and the mysql log on your machine and see if there are any clues there.

Failing that, you might uninstall all three and then double-check to make sure the actual directories they were installed to were deleted, deleting them yourself if not, double-check to make sure the my.ini and php.ini files in the Windows directory were removed and delete them too otherwise, then reinstall a2t (and, of course, back up anything you need to save that might be in those directories before actually trashing them). It seems like it might be something in your installation since I've gone through various installations of a2t, Xampp and so on over the last few years and not seen anything similar (a2t's installer is pretty brute force and generally overwrites or deletes anything that might conflict with a different apache configuration when it's installed or removed).

I dug around on google and found similar issues for different CMS' with XAMPP (wordpress, etc.) but there doesn't seem to be a common cause among them. You might check to make sure Windows' firewall or whatever you use is not blocking it and check to make sure that, once all the lamp stacks are uninstalled, that if you hit crtl alt delete you don't see mysql or apache services still running in the background (httpd.exe, mysqld.exe).

If it's something like a corrupt registration of the mysql files, they can be troubleshot as such, but you should also have errors or warnings to that effect in your logs, too.

Did you remember to assign a

ladycentaur - November 14, 2006 - 05:14

Did you remember to assign a db user for the databases you created and allow them full priveleges on the databases? And also check to make sure you are using the correct mysql host.

Yep

harrisben - November 14, 2006 - 05:21

This is a very confusing and frustrating problem isn't it? What exactly do you mean by the correct mysql host?

I'm used to using hosts and

ladycentaur - November 14, 2006 - 05:27

I'm used to using hosts and it didn't click in my girly brain that you were hosting it on your own machine until after I posted, lol.

Could it be that your config.php file isn't writeable? If I recall correctly when I install Drupal the config.php files are usually not set to write. If you haven't checked that you might want to because that would potentially cause the issue you're having.

Success!

harrisben - November 14, 2006 - 05:52

Your girly brain is very useful. Amazing that something so simple could be a show stopper (or I'm just stupid). Thanks to all and especially the female centaur.

Yay! That makes two XAMPP users tonight that I helped..WOOT!

ladycentaur - November 14, 2006 - 06:01

I just helped someone get CiviCRM installed into Drupal 4.7 a few minutes ago, lol.

Darn...a productive day. I figured out how to make CiviCRM 1.5 work in Drupal 5.0 and helped two people.

My head's gonna swell so much I tip over...and all this from a teeny little chicky who darn near wets herself at the site of a command line...who'd of guessed it, lol.

config.php

vizje - December 12, 2006 - 21:46

Hello,

I have the same problem.
I looked for de config.php file but there is none.

not in the installation on linux en under xampp?
So any suggestions????

thanks

are you running zonealarm?

delatx - November 12, 2006 - 05:54

are you running zonealarm? zonealarm causes this problem on my pc. i have to shut it down when working on drupal on my local machine. I have tried allowing localhost and 127.0.0.1 with no luck.

If only I were running Zonealarm...

harrisben - November 13, 2006 - 08:18

I don't have any firewall running on either my pc or the webserver, but if it meant it would work I'd happily install one!

 
 

Drupal is a registered trademark of Dries Buytaert.