Hey all! First of all, if anyone thinks I look like a total tool for posting a question that's likely very simple to answer, just know that I'm feeling like one too. :) That's said, here's my problem.
I'm trying out Drupal to see if it'll work for the website of the small business I'm starting. I installed Apache, MySQL, PHP and Drupal 5.x, all with no problems. I created the database successfully and ran the INSTALL.PHP script with no problems. Here's the issue: In the post-install screen, it lists the first task as creating my admin account. I go to this screen and due to Drupal's design, I have to enter the username and my e-mail address. The problem is that Drupal hasn't yet given me the ability to configure my e-mail server settings so I never get the e-mail and thus can't complete the account creation. The name does register because when I try to login to it, it says the password is wrong.
This site isn't going to use forums and there will be no accounts beyond the admin account so all I need to do is get this account created. I do have an SMTP server on my local network but on a different machine. Does anyone know how I can get this step completed? Thanks!
Comments
Hey there, Don't feel like a
Hey there, Don't feel like a tool :)
I'm not really sure why that's happening for you... Usually when you create the first account, it goes directly to a password change screen, thus bypassing the email registration.
One thing you can do, is if you have phpMyAdmin installed, you can log in and reset the admin user's password like this:
UPDATE `users` SET pass = MD5('password') WHERE uid=1;
Replace password with the password you want.
(Thanks to: drupal.org/node/113179)
BTW: Is drupal.org really really slow for anyone else this evening?
I don't have that tool, but
I don't have that tool, but do have SQLyog which should allow me to do something similar. I will try it out. Thank you very much!
UPDATE: OK, I tried that out but I still can't login. I checked the database and indeed it did create a new hash of the password I gave it but when I try to login with the credentials I now have, it just redraws the current page and prompts again.
Parallax Abstraction
Ottawa, Ontario, Canada
Help Fix The Broken Xbox Live Marketplace
Hang in there
I'm facing the exact same issue at this very moment. I have a feeling it has to do with file permissions. I'm troubleshooting it right now and I'll let you know if I find the problem. Please let me know if you find your problem.
Actually...
It isn't EXACTLY the same. My email server is on the same box so I got my registration email, but it still does not work. If I enter a valid username/password, I get the 403 error. If I enter a bogus username/password, I get a message in the browser telling me that I have given the wrong info. There is no 403 error in the log for this.
I'm going to keep plugging
I'm going to keep plugging at it. I agree that it could be a permissions issue. I don't even get an error when the authentication fails, it literally just redraws the page as if I just came to it for the first time. I'm going to keep at this tonight too and I will definitely let you know if I figure it out. I know it's something simple. It has to be.
EDIT: If I try with the "good" credentials, it just redraws the page. But like you, if I enter fake credentials, it says it can't recognize the information. The thing I don't understand is why when I click on "create your first account", it just takes me to the normal page where it prompts for a username and e-mail address. If it's apparently supposed to just ask for a password for the first user, why doesn't it?
Parallax Abstraction
Ottawa, Ontario, Canada
Help Fix The Broken Xbox Live Marketplace
First account is different
Just want to double check that you are following the link in the text that says "make first account" when you are doing this. (I don't have it in front of me, so I'm trying to do this from memory.) But read that text carefully. You should click on the link in the text rather than try to create a new account like any other new user would. That ought to work for you. You don't need email set up for that.
Steve
--
http://etmeli.us/ - photos, commentary, occasional sarcasm
That is precisely what I'm
That is precisely what I'm doing and it's bringing up the standard account creation dialogue, not a first-time dialogue. There has to be something triggering this but I don't know what.
EDIT: When I hover over the "first time register link", the link reports as http://127.0.0.1:8080/drupal/?q=user/register. That's the same location that the standard "register new user" link shows as which means that it doesn't appear to be taking me to the right place. Does that help at all?
Parallax Abstraction
Ottawa, Ontario, Canada
Help Fix The Broken Xbox Live Marketplace
If I remember right, when
If I remember right, when you click the 'create first account' link, it takes you to the page where you enter the username and password, but when you click on submit, the system logs you in directly to the admin page and you can immediately change the password for the first account and save the changes. In other words, you don't need to look at that first email at all.
I think this change was introduced in 4.7 or so, so if you aren't able to see this sequence, something else is wrong.
----
Previously user Ramdak.
ARGH
I'm still completely stumped by this. I spent several more hours last night trying to figure it out and got no further. Does anyone know what could be causing this?
Parallax Abstraction
Ottawa, Ontario, Canada
Help Fix The Broken Xbox Live Marketplace
It sounds like your database
It sounds like your database has gotten screwed up somehow... Since you don't have anything on the site yet, why don't you either try wiping out your database and visiting:
http://www.example.com/index.php
If you have a blank database, Drupal 5 will reinstall the database and site. Alternatively, you could create a new empty database (or at least void of Drupal) and change the reference to it in sites/default/settings.php... it's the mysql://user:password@localhost/databasename line.
Then go back and try hitting the create first user link on the main page (not the menu bar).
Maybe this is a fool's errand, but it's probably worth a try just since you never really had a functional site and it sounds like something got "jumbled" in there somwhere.
Hope to hear good news!
I have actually tried a
I have actually tried a number of times to start the whole thing over, right down to uninstalling and reinstalling MySQL. I always create a blank database and let Drupal fill it in which is says completed successfully. I even tried moving over to PostgreSQL as well but couldn't as its installer always fails. If I look at the database, there is tons of entries which indicates that Drupal is properly creating it, yet this still happens. I really have no idea.
Parallax Abstraction
Ottawa, Ontario, Canada
Help Fix The Broken Xbox Live Marketplace
I am about to lose my mind
I am about to lose my mind over this one. I noticed when re-installing all the services for the fifteenth or so time that PHP has a mysql module that doesn't install by default. I turned this on but it seems to have made no difference. I have checked with the administrators of several Drupal based sites and none of them understand this either. The database gets created and it functioning because it takes me to the initial setup pages but it refuses to let me create the first account the way its supposed to and even when I manually create one in the database, it refuses to login with it. I really don't know what to do.
Parallax Abstraction
Ottawa, Ontario, Canada
Help Fix The Broken Xbox Live Marketplace
I'm losing my mind right along with you
Scenario:
1 OS X machine running MAMP
1 client OS X machine
1) I created a drupal database and gave the local user all rights to it.
2) I put drupal in the htdocs folder of MAMP
3) I went to http://localhost:8888/drupal/ and created the very first user. All works just fine, and we can log into drupal.
4) if however we try to connect from a client machine to that very server, we actually get to see the first login page. Unfortunately, when we try to log in with the first user credentials, nothing happens.
if we locally log into drupal, we see errors in the logs like:
type: access denied, user anonymous.
I knwo Drupal is great, and I really, really want to use this CMS, so if anyone could help us out here.
it's happening to me, too
My 5.1 installation was working fine for a while, then suddenly stopped letting me in -- I couldn't even create new user accounts when I set the first line of user_access() to return TRUE.
Completely clean 5.1 installs don't work either, now. Could it be a cookie issue? My first attempts to clear them selectively hasn't worked, but I'll give it another shot.
My Solution
I had the exact same problem, and I was able to fix it by doing the following:
In the settings.php file for the site (sites/default/settings.php for most), near the bottom, there is an ini_set('session.cookie_domain') call, surrounded by some fancy parsing of $_SERVER['HTTP_HOST'] ...
I commented out this entire block (use /* to start comment and */ to end it), and just manually set session.cookie_domain to my domain name (WITHOUT port #):
ini_set('session.cookie_domain', 'example.zapto.org'); // no http://, no :port#Once you do this, I would recommend closing your browser if it is already open, just to make sure a new session is established next time you visit your site.
I have seen a bunch of threads about this problem, and the consensus always seems to be that it is a problem with cookies or sessions, but I have never seen anyone mention this setting. While other solutions work for some people, the problem seems to still be unsolved for many, and I hope this will help those folks like it helped me. I think the main issue is that the $_SERVER['HTTP_HOST'] variable contains the port number when it is non-standard (not port 80, like example.zapto.org:8000 or my.drupal.site:8080) and browsers don't like that in the domain attribute of the cookie that is sent to them. At least Firefox did not seem to be registering these cookies at all when PHP's session.cookie_domain attribute contained the port number. Changing it to include only the host name seems to do the trick.
If this doesn't work for you, I would at least recommend checking out your cookies (in Firefox, Tools...Options...Privacy...Show Cookies) and verifying that there is a cookie (for me, named "PHPSESSID") coming from the domain your Drupal site is on. That way, you can likely narrow it down to a cookies problem (or not).
-John
user_password
I had the exact same problem. Restarted a couple of times.
Last solution: I changed the function user_password(...) in /modules/user/user.module to return a constant value like this (end of function):
After that, dropping the database, recreating it with install.php, it worked - the function determines a password for a new user, which is now always 'pw'. Of course you have to reverse this change, otherwise all users will get the password 'pw'!
Funny enough, the behaviour of "create first user" changed as well - I think that should not be the case...
- Martin