By woods70 on

Ok i got my Drupal page set up I do have an STMP server and I have comcast as the default, and I am just wondering how to a set up the admin@localhost[mail function] as a user. I created a username and and gave my outlook email, did not get the mail but it took me to the welcome page. I had to leave for work and did not remember the password they gave me, and I didn't get an email, so I need to create a new first user, and hopefully configure my admin@local host so I get my email back to my drupal site. But how do I reset my password and user name if i can't access to any of my email providers?

warning: mail(): SMTP server response: 550 Relay denied in C:\apache2triad\htdocs\drupal-4.7.5\modules\user.module on line 431.

This is what I got...help...

Thanks!!!

⋅ Categories: Drupal 4.7.x

Comments

vm’s picture

vm commented

Create a new user. make sure you can log in.
logout.
go into your database and find the newly created user. Exchange the newly created users UID with the first created users UID. This now makes the newly created user the superadmin.

Sign back into Drupal and delete the name you no longer need (The first one).

You could try changing the password manually in the database, but its protected and you can't read it. you would need to convert it to MD5? i believe.

There is no one button fix for this.

your other options is to drop all datbase tables, then reimport the .mysql file and now you can create the first user again. This method may be far easier for you if you have no content, on the site.

tm’s picture

tm commented

Hi! Only been at this for 6 months, and ran into the same issue installing 4.7. I found the posting at http://drupal.org/node/32650 to be helpful. I have also done the "delete/reimport" when doing a clean installation, which works well when I "forget".

However, the "swap user" method above looks interesting, and I will have to try it out; always good to have options.

Good luck!

woods70’s picture

woods70 commented

I just reinstalled and got my login password and changed it to my liking. I am just still wondering on how to set up my STMP for the admin@localhost, so that I can send and receive email from my Drupal site...

Thanks again

vm’s picture

vm commented

unless you have a mailserver setup on your local machine i don't see how you will get mail @ localhost

woods70’s picture

woods70 commented

Well just a noob, going to keep on learning, and I'll figure it all out. Back to the book.

Thanks again

Christefano-oldaccount’s picture

Christefano-oldaccount commented

This is the easiest way, in my opinion:

  UPDATE `users` SET pass = MD5('password') WHERE uid=1;

Replace password with the password you want.

woods70’s picture

woods70 commented

Thanks, got everything working again, but I'll keep this for future reference!!!

mountainash’s picture

mountainash commented

The easiest way I found is to just replace the password directly in the DB (accessed through a GUI) and encrpyt it using http://www.md5encrypter.com/

Or if it's not a vital password, you could try the Decrypter http://www.md5decrypter.com/

Mountain/\Ash

wesley_corn’s picture

wesley_corn commented

This last method worked well for me. Thanks

peterbeauclerk’s picture

peterbeauclerk commented

This was on an initial (I think- with 4 sites I may have lost track) login on a multisite with single codebase setup. The other sites came up OK
I have changed the password, but still cannot login.
I was able to create another account and log in with virtually no permissions.
As suggested,
I swapped my new user name into the user1 UID ("placeholder"-for-uid-1) using phpMyAdmin
and tried to login with the reset password
Got this message:
"The username (my new username) has not been activated or is blocked."- the same message I got when
I tried to login as admin with the new password
I'm stumped and ready to try your option3: "to drop all database tables, then reimport the .mysql file and now you can create the first user again. " but I'm at the far reaches of my competence- can you walk me through the steps?
Thanks so much,
Pete

peterbeauclerk’s picture

peterbeauclerk commented

I am using Drupal 6.12, cPanel, MYSQL, phpMyAdmin

tryitonce’s picture

tryitonce commented

I just imported a full database back to my localhost for one of my sites.

I can login as authenticated user - but not as one of the two administrators (user1 and another admin user).

Well, investigating and more soon I hope - so far:

I reimported just the users from the hosted site
I changed the roles in MySQL auth. user to admin role - it didn't change when logging in
I checked the password with http://drupal.org/node/113179#comment-208306 and they are correct - decrypted = encrypted password

Probably I need to try setting up a new DB and importing all in fresh - luckly I have all the data on the life site.

...

tryitonce’s picture

tryitonce commented

... but the truth has to be told as it will help others to find similar errors quickly.

When I transferred the MySQL data from the life site to my local host I was "flogging" the wrong horse.
As might happen with testing sites - I had more than one MySQL database to test different things. I imported the life site data to the wrong MySQL db on localhost and then of course had no success in changing anything.

Once this was sorted all worked okay.

You can check and change the passwords as described above in this thread under "user" and you can change a user's role under "user-role" to admin and login that way.

So, I hope this might help someone else to see their errors more quickly - good luck