+ Post New Thread
Results 1 to 11 of 11
How do you do....it? Thread, Joomla Site - logon details stored where? in Technical; Can anyone point me toward where the log on details are stored within a Joomla site please. One of my ...
  1. #1

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,624
    Thank Post
    3,561
    Thanked 301 Times in 229 Posts
    Blog Entries
    3
    Rep Power
    124

    Joomla Site - logon details stored where?

    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.

  2. #2

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,867
    Thank Post
    412
    Thanked 778 Times in 651 Posts
    Rep Power
    182
    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).

  3. Thanks to powdarrmonkey from:

    speckytecky (15th March 2010)

  4. #3

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,624
    Thank Post
    3,561
    Thanked 301 Times in 229 Posts
    Blog Entries
    3
    Rep Power
    124
    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?

    Quote Originally Posted by powdarrmonkey View Post
    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).

  5. #4

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,867
    Thank Post
    412
    Thanked 778 Times in 651 Posts
    Rep Power
    182
    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).

  6. Thanks to powdarrmonkey from:

    speckytecky (17th March 2010)

  7. #5

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,427
    Thank Post
    112
    Thanked 269 Times in 202 Posts
    Rep Power
    195
    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.

  8. Thanks to rush_tech from:

    speckytecky (17th March 2010)

  9. #6

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,624
    Thank Post
    3,561
    Thanked 301 Times in 229 Posts
    Blog Entries
    3
    Rep Power
    124
    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.

  10. #7

    SimpleSi's Avatar
    Join Date
    Jun 2005
    Location
    Lancashire
    Posts
    5,829
    Thank Post
    1,476
    Thanked 595 Times in 446 Posts
    Rep Power
    170
    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

  11. Thanks to SimpleSi from:

    speckytecky (17th March 2010)

  12. #8

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,427
    Thank Post
    112
    Thanked 269 Times in 202 Posts
    Rep Power
    195
    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
    Last edited by rush_tech; 17th March 2010 at 09:33 PM.

  13. Thanks to rush_tech from:

    speckytecky (17th March 2010)

  14. #9

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,624
    Thank Post
    3,561
    Thanked 301 Times in 229 Posts
    Blog Entries
    3
    Rep Power
    124
    Thanks SimpleSi - this is a whole new crate of eggs to me so any pointers are taking me to unclimbed heights

    Quote Originally Posted by SimpleSi View Post
    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

  15. #10
    moobsuk's Avatar
    Join Date
    Mar 2010
    Location
    Yeovil
    Posts
    32
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    10
    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.

    Last edited by moobsuk; 24th March 2010 at 03:06 PM.

  16. Thanks to moobsuk from:

    speckytecky (24th March 2010)

  17. #11

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,624
    Thank Post
    3,561
    Thanked 301 Times in 229 Posts
    Blog Entries
    3
    Rep Power
    124

    Now Solved

    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!



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 17
    Last Post: 18th June 2010, 01:48 PM
  2. Joomla Site Hacked
    By drewinc in forum EduGeek Joomla 1.5 Package
    Replies: 9
    Last Post: 1st December 2008, 03:24 PM
  3. My joomla site 1.5 has been done over as well!
    By reggiep in forum EduGeek Joomla 1.5 Package
    Replies: 9
    Last Post: 7th October 2008, 11:27 AM
  4. Joomla Download Site Down !!!
    By ICTNUT in forum Web Development
    Replies: 0
    Last Post: 6th September 2008, 05:28 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •