Joomla Site - logon details stored where?

[speckytecky]

Can anyone point me toward where the log on details are stored within a Joomla site please. One of my sites seems to have corrupt log on details so I can't currently access back end. I can FTP it and see it on Plesk though.

[powdarrmonkey]

They're in the jos_users table in the database (it may have a slightly different name if you are or aren't using table prefixes).

[speckytecky]

Thanks powdermonkey - this is a newie to me so any further advice from folk on her would be appreciated.

 

I Googled jos_users and saw about generating a new password. However, I'm a tad stuck on where to go next. My DB is with SWGfL hosted on Linux with Plesk as the interface.

 

Looking round my Plesk page I can't see where it is I need to go to make the change?

 

They're in the jos_users table in the database (it may have a slightly different name if you are or aren't using table prefixes).

[powdarrmonkey]

Well you need some way of editing the database tables directly, and I don't know Plesk well any more. Most commonly, phpMyAdmin, which it might have installed already, or you can install it yourself as a web application (it's just PHP).

[rush_tech]

I can get access to it through plesk>>>select databases from the front screen>>>>click on your database from the list>>>>Webadmin should open up phpMyAdmin.

[speckytecky]

Thanks for the help - so far folks:)

 

OK, so in I went and edited the password bit on the database but still can't get into the site so am I right in thinking that it was my database password I changed? I get the logon box on the mysite\administrator page but just can't access the control panel as none of the logon / password combinations I try work? Changing the password in the database just doesn't seem to have made any difference.

[SimpleSi]

Sorry if teaching grandma but do you know you have to use a prog to generate an encrypted table entry?

 

Can't remember details but google tells you how to do it.

 

Done it myself a few times in the past

 

regards

 

Simon

[rush_tech]

I did this a while ago but I think I needed to generate the password as a MD5 string using something like this and paste that string into the password field Edited March 17, 2010 by rush_tech

[speckytecky]

Thanks SimpleSi - this is a whole new crate of eggs to me so any pointers are taking me to unclimbed heights:o

 

Sorry if teaching grandma but do you know you have to use a prog to generate an encrypted table entry?

 

Can't remember details but google tells you how to do it.

 

Done it myself a few times in the past

 

regards

 

Simon

[moobsuk]

If you are using phpMyAdmin you can run a quick SQL query:

 

UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin" ;

 

Where it has new_password obviously type your new one here.

And make sure that the username who's password you want to change is admin.

 

And you should be good to go.

 

http://i24.photobucket.com/albums/c45/stevovarl/1-1.jpg

Edited March 24, 2010 by moobsuk

[speckytecky]

Thanks for all the excellent replies folks - now back in - I'd mark the original as solved but can't get into advanced edit to do so!