1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Can't Login Or Retreive Password? PHPBB3

Discussion in 'HTML & Website Design' started by gobbly2100, Dec 22, 2007.

0
  1. #1
    Oh man, I can't seem to login and when I use the lost password feature it don't send an email, it tells me it was sent succesfully but I never get anything.

    What do I need to do because I have not been able to login for weeks now and I could really do with logging in now.

    APB Forum

    Any help on this?
     
    gobbly2100, Dec 22, 2007 IP
  2. Tobias

    Tobias Peon

    Messages:
    20
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Are you the administrator, or do you otherwise have access to the MySQL database (No, not in a dodgy way :S)

    If you are, edit the MySQL database and md5-hash a password of which you can replace the existing one of yours in the database.

    Otherwise, you'd need to contact an administrator, somehow. :S
     
    Tobias, Dec 22, 2007 IP
  3. gobbly2100

    gobbly2100 Banned

    Messages:
    906
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yeah I do have full access to the database, I looked at changing the password in the database but will it actually be the password I set as it is in hash?
     
    gobbly2100, Dec 23, 2007 IP
  4. Meth_

    Meth_ Well-Known Member

    Messages:
    1,063
    Likes Received:
    72
    Best Answers:
    0
    Trophy Points:
    140
    #4
    set the password to 
    e10adc3949ba59abbe56e057f20f883e
    Code (markup):
    in the database, and your new password will be "123456" without the quotes

    go change it right away then
     
    Meth_, Dec 23, 2007 IP
  5. gobbly2100

    gobbly2100 Banned

    Messages:
    906
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Still no luck :( I can get any help on the official PHPBB forums either, I am so lost.

    I have tried uploading all the files again also with no luck.

    I assume it is databases related, I don't see what else it could be, I just don't get why it wont email me my password or whatever.
     
    gobbly2100, Dec 23, 2007 IP
  6. Tobias

    Tobias Peon

    Messages:
    20
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Sign up as a new user, then make that user an admin by editing the admin flag in the phpBB3 user table. Then use that to change your password.

    Otherwise, it could be possible to change your email to whatever you want from phpmyadmin, then just use the forgot password tool.
     
    Tobias, Dec 23, 2007 IP
  7. Meth_

    Meth_ Well-Known Member

    Messages:
    1,063
    Likes Received:
    72
    Best Answers:
    0
    Trophy Points:
    140
    #7
    a lot of web servers disable mail sending due to spam
    but umm
    the only other option is to do what tobias said
    sorry
     
    Meth_, Dec 23, 2007 IP
  8. FotoZone

    FotoZone Well-Known Member

    Messages:
    363
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    145
    #8
    Are you the administrator,, and if not, you go to FTP and edit archives config.php
     
    FotoZone, Dec 23, 2007 IP
  9. joebert

    joebert Well-Known Member

    Messages:
    2,150
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    145
    #9
    phpBB3 no longer uses md5 for hashing passwords in the database.

    Use the following hash, without the quotes.
    "$H$9Ae3Uk.ECdWW5ya13M4ErWhr4c.761/"

    Your password is now "password", without the quotes.
     
    joebert, Dec 23, 2007 IP
  10. gobbly2100

    gobbly2100 Banned

    Messages:
    906
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Well the only thing that seemed to work was making a new user and adjusting it to an admin in PHPMyAdmin.

    I am really not sure wha happened to mess my original admin account up but it happened after I upgraded, anyway it is ok now.

    Thanks all for the help!
     
    gobbly2100, Dec 24, 2007 IP
  11. joebert

    joebert Well-Known Member

    Messages:
    2,150
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    145
    #11
    There appears to be some sort of bug in the mailer.
    I'm testing this on a system that doesn't even have a mailer installed & I'm being told the message was sent successfully.

    You should probably bring this up at phpbb.com.
     
    joebert, Dec 24, 2007 IP
  12. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #12
    it can happen because u must have a long mail queue on server

    Or your server is on RBL spam list and that email is rejected by yahoo or hotmail(admin email)

    Regards

    Alex
     
    kmap, Dec 24, 2007 IP
  13. deepak38

    deepak38 Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #13
    Hi,

    After updating the password in database also update user_login_attempts to zero.
    `user_login_attempts` = '0'

    Thanks
     
    deepak38, Sep 21, 2008 IP
  14. codegotbugs

    codegotbugs Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #14
    Thanks Joebert. It worked for me !
     
    codegotbugs, Jun 5, 2011 IP
  15. KoolDesign2

    KoolDesign2 Peon

    Messages:
    64
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #15
    can we write `user_login_attempts` = '1' instead of '0'?
     
    KoolDesign2, Jun 6, 2011 IP