1 Topic by Burnsy86 (edited by Burnsy86 2007-07-17 03:36)

  • Registered: 2006-12-20
  • Posts: 107

Topic: Where are passwords stored?

I had to switch web hosts and was unsuccessful at transferring the database.  I was able to extract all of the data but couldn't import it.

So, my main concern was losing all of the users.  I have all of the usernames in the database file I extracted, but where can I find the passwords?  That way I can just re-signup all of the members with their original email and password.

I notice next to each username in the sql file there is a code such as "4dbn839fhf921b47bpn3" or whatever.  Is that some type of password encryption?

Thanks for any help!

  • Registered: 2006-10-19
  • Posts: 5

Re: Where are passwords stored?

Yes these are the MD5 hash encrypted passwords. That's what you need.

3 Reply by Frank H (edited by Frank H 2007-07-17 07:07)

  • Frank H
  • Former PunBB Developer
  • Offline
  • Registered: 2003-03-16
  • Posts: 1,423

Re: Where are passwords stored?

PunBB uses SHA1 hashing if possible. (MD5 is only a fallback, if it cannot find SHA1)

  • Registered: 2006-12-20
  • Posts: 107

Re: Where are passwords stored?

Ok so how do I decrypt them?  Or is that something we shouldn't talk about in public?

  • Frank H
  • Former PunBB Developer
  • Offline
  • Registered: 2003-03-16
  • Posts: 1,423

Re: Where are passwords stored?

hashes are a destructive method, so you cannot decrypt them.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Where are passwords stored?

If you have an SQL dump and are having issues with it, I could take a look at it and try to fix it

  • From: France
  • Registered: 2004-11-06
  • Posts: 695

Re: Where are passwords stored?

Usually, password don't matter. An user can request a new one.

If you have issue with it after a bad dump, you can randomize the passwords to fill the database.

Jeu de rôle en ligne sur table virtuelle ⁂ Shadowrun France ⁂ Chez Blacky

Jérémie's Website