Administrator account is missing

Need help with the Administration of your Joomla! 1.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
jbeiter2
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Sat Feb 16, 2008 9:27 pm

Administrator account is missing

Post by jbeiter2 » Sat Feb 07, 2009 9:24 pm

I haven't logged into the "admin" account in months, but went to log in today and discover it is gone. I looked in the database and it is still there (gid 25)

Any tips on what the hell happened and how I can fix this without reinstalling the entire site?

This is very disturbing.

I tried upgrading from 1.5.6 -> 1.5.9, still no admin account.

User avatar
airton
Joomla! Ace
Joomla! Ace
Posts: 1369
Joined: Sun Nov 04, 2007 1:12 am
Location: Brazil
Contact:

Re: Administrator account is missing

Post by airton » Sat Feb 07, 2009 11:46 pm

What are the symptoms? Are there any error messages?
Airton Torres
Joomla Bug Squad http://groups.google.com/group/joomlabugsquad
Community website - http://community.joomla.org
Unsolicited support PMs will be deleted and the user added to the foes list.

jbeiter2
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Sat Feb 16, 2008 9:27 pm

Re: Administrator account is missing

Post by jbeiter2 » Sun Feb 08, 2009 12:17 am

airton wrote:What are the symptoms? Are there any error messages?
None that I have been able to see. I tried restoring my last backup (using Joomlapack) from october to a dev system and the admin account isn't there either; which is strange because you need superadmin access to use joomlapack.

Is there perhaps a way to create a new account and grant that account superadministrator access directly in the database?

I have around 50 registered users on this site. It would be very difficult to reinstall clean.

User avatar
airton
Joomla! Ace
Joomla! Ace
Posts: 1369
Joined: Sun Nov 04, 2007 1:12 am
Location: Brazil
Contact:

Re: Administrator account is missing

Post by airton » Sun Feb 08, 2009 1:37 am

Ok,
Check your tables according to the screenshots attached.

1- jos_users: must have at least one row
image1.png
2- jos_core_acl_aro_groups: must have all the rows
image2.png
3- jos_core_acl_groups_aro_map: must have at least one row
4- jos_core_acl_aro_sections: must have at least one row
image3.png
Report if you see something different.
Airton Torres
Joomla Bug Squad http://groups.google.com/group/joomlabugsquad
Community website - http://community.joomla.org
Unsolicited support PMs will be deleted and the user added to the foes list.

jbeiter2
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Sat Feb 16, 2008 9:27 pm

Re: Administrator account is missing

Post by jbeiter2 » Sun Feb 08, 2009 3:21 am

As far as I can tell, they look the same. The only difference is the core_acl_aro_groups (attached) where I think I may have attempted to add a group sometime in the past, before I knew it would not work like I thought. I'm pretty sure this was more than a year before the admin account vanished but it is different than what you posted.

The other ones look identical.
jos_core_acl_aro_groups.png
You do not have the required permissions to view the files attached to this post.

User avatar
airton
Joomla! Ace
Joomla! Ace
Posts: 1369
Joined: Sun Nov 04, 2007 1:12 am
Location: Brazil
Contact:

Re: Administrator account is missing

Post by airton » Sun Feb 08, 2009 3:46 am

Let's try something,

Add a new row to the jos_users table with the following info:
-Id: one number higher than the highest id in your table (e.g. 75)
-Name: whatever you want;
-Username: the username you want;
-Email: any email address still not entered in the table for other user (can be a fake one);
-Password: change the function to MD5 and type the password you want for the user;
-UserType: Super Administrator;
-Block: 0;
-Gid: 25;
-RegisterDate: change function to NOW

Now add a new row to the jos_core_acl_aro table with the following info:
-Id: Last ID in the table plus 1 (e.g. 11);
-Section Value: users;
-Value: The same ID you created in jos_users (e.g. 75);
-Name: The Name you gave in jos_users

Now add a new row to the jos_cores_acl_groups_aro_map table with the following info:
-Group Id: 25;
-Aro Id: The same Id you gave in the jos_core_acl_aro table (e.g. 11).

Try to login with that new user in backend.
Airton Torres
Joomla Bug Squad http://groups.google.com/group/joomlabugsquad
Community website - http://community.joomla.org
Unsolicited support PMs will be deleted and the user added to the foes list.

jbeiter2
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Sat Feb 16, 2008 9:27 pm

Re: Administrator account is missing

Post by jbeiter2 » Sun Feb 08, 2009 8:46 pm

It worked! Thank you very much for your help. At least I can do the backups now and do anything I need to as super admin.

Do I need that original Administrator account for anything or am I okay now?

Thank you again.

User avatar
airton
Joomla! Ace
Joomla! Ace
Posts: 1369
Joined: Sun Nov 04, 2007 1:12 am
Location: Brazil
Contact:

Re: Administrator account is missing

Post by airton » Sun Feb 08, 2009 10:06 pm

Glad it worked! :)

I think you are OK now, but it could be that some 3P extensions might look for the original super-admin user (hard coded) so, if you can see it in your users list, try changing it's username and password, then try to log in with it. If it works, you can delete the new account, otherwise I don't see why you shouldn't keep the original one and forget about it.

Regards,
Airton Torres
Joomla Bug Squad http://groups.google.com/group/joomlabugsquad
Community website - http://community.joomla.org
Unsolicited support PMs will be deleted and the user added to the foes list.

jbeiter2
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 104
Joined: Sat Feb 16, 2008 9:27 pm

Re: Administrator account is missing

Post by jbeiter2 » Mon Feb 09, 2009 1:58 pm

I was wondering, can you reset the administrator password by editing the jos_users table, changing the password type to MD5 and typing in the new password like you indicated above?

Thanks again, this thread is a keeper!

User avatar
airton
Joomla! Ace
Joomla! Ace
Posts: 1369
Joined: Sun Nov 04, 2007 1:12 am
Location: Brazil
Contact:

Re: Administrator account is missing

Post by airton » Mon Feb 09, 2009 3:32 pm

jbeiter2 wrote:I was wondering, can you reset the administrator password by editing the jos_users table, changing the password type to MD5 and typing in the new password like you indicated above?

Thanks again, this thread is a keeper!
Yes, you can! I have done that many times. ;)
Airton Torres
Joomla Bug Squad http://groups.google.com/group/joomlabugsquad
Community website - http://community.joomla.org
Unsolicited support PMs will be deleted and the user added to the foes list.

kaye10
Joomla! Apprentice
Joomla! Apprentice
Posts: 25
Joined: Mon May 04, 2009 9:27 pm

Re: Administrator account is missing

Post by kaye10 » Fri Aug 28, 2009 4:47 am

Airton, thx for sharing ur knowledge with us newbies..i tried the 1st step with ease..the second one with jos_core_acl_aro table, i could see where to insert a row..

I thought i got hacked cos i couldnt get in the back end of my Joomla 1.5.6 but when i checked my phpadmin, my email was still there..all the password recovery solutions dont work for me..been getting pass/username dont match...im trying this other step but the Jos_core_acl got me stuck..please help...Thx man.
airton wrote:Let's try something,

Add a new row to the jos_users table with the following info:
-Id: one number higher than the highest id in your table (e.g. 75)
-Name: whatever you want;
-Username: the username you want;
-Email: any email address still not entered in the table for other user (can be a fake one);
-Password: change the function to MD5 and type the password you want for the user;
-UserType: Super Administrator;
-Block: 0;
-Gid: 25;
-RegisterDate: change function to NOW

Now add a new row to the jos_core_acl_aro table with the following info:
-Id: Last ID in the table plus 1 (e.g. 11);
-Section Value: users;
-Value: The same ID you created in jos_users (e.g. 75);
-Name: The Name you gave in jos_users

Now add a new row to the jos_cores_acl_groups_aro_map table with the following info:
-Group Id: 25;
-Aro Id: The same Id you gave in the jos_core_acl_aro table (e.g. 11).

Try to login with that new user in backend.

kaye10
Joomla! Apprentice
Joomla! Apprentice
Posts: 25
Joined: Mon May 04, 2009 9:27 pm

Re: Administrator account is missing

Post by kaye10 » Fri Aug 28, 2009 2:34 pm

Airton i sent you my details to ur email..im at work at the moment till 8p...thx for the support..if any questions, please let me know..i sent you my email via msn messenger.
kaye10 wrote:Airton, thx for sharing ur knowledge with us newbies..i tried the 1st step with ease..the second one with jos_core_acl_aro table, i could see where to insert a row..

I thought i got hacked cos i couldnt get in the back end of my Joomla 1.5.6 but when i checked my phpadmin, my email was still there..all the password recovery solutions dont work for me..been getting pass/username dont match...im trying this other step but the Jos_core_acl got me stuck..please help...Thx man.
airton wrote:Let's try something,

Add a new row to the jos_users table with the following info:
-Id: one number higher than the highest id in your table (e.g. 75)
-Name: whatever you want;
-Username: the username you want;
-Email: any email address still not entered in the table for other user (can be a fake one);
-Password: change the function to MD5 and type the password you want for the user;
-UserType: Super Administrator;
-Block: 0;
-Gid: 25;
-RegisterDate: change function to NOW

Now add a new row to the jos_core_acl_aro table with the following info:
-Id: Last ID in the table plus 1 (e.g. 11);
-Section Value: users;
-Value: The same ID you created in jos_users (e.g. 75);
-Name: The Name you gave in jos_users

Now add a new row to the jos_cores_acl_groups_aro_map table with the following info:
-Group Id: 25;
-Aro Id: The same Id you gave in the jos_core_acl_aro table (e.g. 11).

Try to login with that new user in backend.

mooersrealty
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jul 23, 2009 7:31 pm

Re: Administrator account is missing

Post by mooersrealty » Sun Nov 08, 2009 10:32 pm

Kinda following along on this thread. My problem is I can log on to site administration area but not preview the site to see results of the tweaking. Always could..until today. Went back to host to see if they could help and they resent the original user name and pass word. But those don't work so any ideas? Thanks very much (launching another flare..sharks circling boat..tiny boat that is being nibbled on slowly) No pressure. (tick tick tick)

User avatar
ooffick
Joomla! Master
Joomla! Master
Posts: 11483
Joined: Thu Jul 17, 2008 3:10 pm
Location: Ireland
Contact:

Re: Administrator account is missing

Post by ooffick » Mon Nov 09, 2009 9:20 am

mooersrealty wrote:Kinda following along on this thread. My problem is I can log on to site administration area but not preview the site to see results of the tweaking. Always could..until today. Went back to host to see if they could help and they resent the original user name and pass word. But those don't work so any ideas? Thanks very much (launching another flare..sharks circling boat..tiny boat that is being nibbled on slowly) No pressure. (tick tick tick)
Which Joomla version do you have?

to learn how to reset the password, have a look here:
http://docs.joomla.org/How_you_reset_an ... assword%3F
http://docs.joomla.org/How_do_you_recov ... assword%3F

Olaf
Olaf Offick - Global Moderator
learnskills.org

mooersrealty
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jul 23, 2009 7:31 pm

Re: Administrator account is missing

Post by mooersrealty » Mon Nov 09, 2009 8:13 pm

Version 1.5 Olaf. Can log in to site maintenance but when preview the site, have to intially log in to unlock site. Have a front page "curtain" to shelter progress on site under construction. Should I be upgrading to 1.6?

User avatar
ooffick
Joomla! Master
Joomla! Master
Posts: 11483
Joined: Thu Jul 17, 2008 3:10 pm
Location: Ireland
Contact:

Re: Administrator account is missing

Post by ooffick » Mon Nov 09, 2009 8:32 pm

Which Joomla 1.5 version do you have?

I would not recommend to use Joomla 1.6 alpha 2 in your production site.

Olaf
Olaf Offick - Global Moderator
learnskills.org

User avatar
airton
Joomla! Ace
Joomla! Ace
Posts: 1369
Joined: Sun Nov 04, 2007 1:12 am
Location: Brazil
Contact:

Re: Administrator account is missing

Post by airton » Mon Nov 09, 2009 8:58 pm

mooersrealty wrote:Version 1.5 Olaf. Can log in to site maintenance but when preview the site, have to intially log in to unlock site. Have a front page "curtain" to shelter progress on site under construction. Should I be upgrading to 1.6?
Looks like your site is in off-line state. If so, it's standard behavior to ask for an admin username/password to access the front-end. Was it intentional to put the site in off-line state? If not, go to Global Configuration and set Site is Off-Line to No.

Hope it helps.

Sorry, Olaf, for jumping in this issue like this :D
Airton Torres
Joomla Bug Squad http://groups.google.com/group/joomlabugsquad
Community website - http://community.joomla.org
Unsolicited support PMs will be deleted and the user added to the foes list.

mooersrealty
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jul 23, 2009 7:31 pm

Re: Administrator account is missing

Post by mooersrealty » Tue Nov 10, 2009 10:31 pm

Sounds reasonable but now logging in to back end login not working. (Reaching under dash) I think I can hot wire to get it going) No seriously...wonder why the iron door dropped on access. I know to check the global setting if I ever get access to the back end of site again. Geesh. Thank for jumping in!

mooersrealty
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jul 23, 2009 7:31 pm

Re:Log in to rear end and front end disabled.

Post by mooersrealty » Tue Nov 10, 2009 10:48 pm

Read the instructions to go into MySQL and look for pass word and change. Got that done, back in to the back and front site. Global setting was my problem on not being able to preview due to lack of successful log in. Thanks much. I have a feeling I will be back to haunt the eyeballs roaming the halls in here. Thanks for helping.

User avatar
airton
Joomla! Ace
Joomla! Ace
Posts: 1369
Joined: Sun Nov 04, 2007 1:12 am
Location: Brazil
Contact:

Re: Administrator account is missing

Post by airton » Wed Nov 11, 2009 1:48 am

Glad you sorted it out :)
Airton Torres
Joomla Bug Squad http://groups.google.com/group/joomlabugsquad
Community website - http://community.joomla.org
Unsolicited support PMs will be deleted and the user added to the foes list.

judemacd
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Fri Aug 01, 2008 12:11 pm

Re: Administrator account is missing

Post by judemacd » Tue Nov 24, 2009 5:54 pm

I tried everything else and finally followed the instructions below and BINGO it worked! Thank you so much, I can now breathe again.

Once I got access back I went into user manager and updated my original entry, but couldn't remove the 'new one' - but hey it's always a back up.

J :)
airton wrote:Let's try something,

Add a new row to the jos_users table with the following info:
-Id: one number higher than the highest id in your table (e.g. 75)
-Name: whatever you want;
-Username: the username you want;
-Email: any email address still not entered in the table for other user (can be a fake one);
-Password: change the function to MD5 and type the password you want for the user;
-UserType: Super Administrator;
-Block: 0;
-Gid: 25;
-RegisterDate: change function to NOW

Now add a new row to the jos_core_acl_aro table with the following info:
-Id: Last ID in the table plus 1 (e.g. 11);
-Section Value: users;
-Value: The same ID you created in jos_users (e.g. 75);
-Name: The Name you gave in jos_users

Now add a new row to the jos_cores_acl_groups_aro_map table with the following info:
-Group Id: 25;
-Aro Id: The same Id you gave in the jos_core_acl_aro table (e.g. 11).

Try to login with that new user in backend.
Let's try something,

Add a new row to the jos_users table with the following info:
-Id: one number higher than the highest id in your table (e.g. 75)
-Name: whatever you want;
-Username: the username you want;
-Email: any email address still not entered in the table for other user (can be a fake one);
-Password: change the function to MD5 and type the password you want for the user;
-UserType: Super Administrator;
-Block: 0;
-Gid: 25;
-RegisterDate: change function to NOW

Now add a new row to the jos_core_acl_aro table with the following info:
-Id: Last ID in the table plus 1 (e.g. 11);
-Section Value: users;
-Value: The same ID you created in jos_users (e.g. 75);
-Name: The Name you gave in jos_users

Now add a new row to the jos_cores_acl_groups_aro_map table with the following info:
-Group Id: 25;
-Aro Id: The same Id you gave in the jos_core_acl_aro table (e.g. 11).

Try to login with that new user in backend.

jumbles
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 30, 2009 1:02 am
Location: Dublin

Re: Administrator account is missing

Post by jumbles » Mon Nov 30, 2009 1:42 am

I've been having a similar problem. My super administrator account disappeared when I transfered my site to a new host. I followed all of the above, but still I can't access the backend of my site.

I've tried several times to create a new super administrator, editing jos_users, jos_core_acl_aro and jos_core_acl_groups_aro_map.

I've to use the site for a job interview on Tuesday morning. It's quite late where I am, and I'm getting a bit frustrated by the whole thing! Any help would be much appreciated!

Can you think of any more suggestions?

User avatar
ooffick
Joomla! Master
Joomla! Master
Posts: 11483
Joined: Thu Jul 17, 2008 3:10 pm
Location: Ireland
Contact:

Re: Administrator account is missing

Post by ooffick » Mon Nov 30, 2009 10:36 am

Do you get any error message?
Are you sure you are manipulating the correct database tables?

Olaf
Olaf Offick - Global Moderator
learnskills.org

jumbles
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 30, 2009 1:02 am
Location: Dublin

Re: Administrator account is missing

Post by jumbles » Mon Nov 30, 2009 11:15 am

I only received a "404 Authorization Required" error message, the one that comes up when you can't login to a site because of incorrect username or password. I double checked the 3 tables jos_uses, jos_core_acl_aro and jos_core_acl_groups_aro_map. They all seem to be in order.

Is there another table that could have an effect on logins?

I didn't set up the site originally, it was given to me to transfer to my hosting. I'm thinking that the easiest way to get it up and running again is to reinstall Joomla 1.5.

Unless anyone else has any other ideas?

User avatar
ooffick
Joomla! Master
Joomla! Master
Posts: 11483
Joined: Thu Jul 17, 2008 3:10 pm
Location: Ireland
Contact:

Re: Administrator account is missing

Post by ooffick » Mon Nov 30, 2009 11:27 am

And do you see the login form at all in http://www.yousite.com/administrator ?
And the login form looks like this one: http://demo.joomla.org/1.5/administrator

Moreover, please go to the jos_plugins table and check if you have the Joomla - User Plugin and the Joomla - Authentification plugin.

If you do, please check if those plugins are published (there needs to be 1 in the published column.)

Which Joomla! version do you have?

Olaf
Olaf Offick - Global Moderator
learnskills.org

jumbles
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 30, 2009 1:02 am
Location: Dublin

Re: Administrator account is missing

Post by jumbles » Mon Nov 30, 2009 11:48 am

No, the login form doesn't come up. I just get a pop up authentication required box with the text : "A user name and password are being requested by http://quickcms.ie. The site says: "admin""

I checked the plugins again, and they are both set to "1" for published.

User avatar
ooffick
Joomla! Master
Joomla! Master
Posts: 11483
Joined: Thu Jul 17, 2008 3:10 pm
Location: Ireland
Contact:

Re: Administrator account is missing

Post by ooffick » Mon Nov 30, 2009 11:57 am

well, in that case you probably have a .htaccess file in the administrator folder which requires some additional authentication. By default that folder doesn't have a .htaccess file.

Olaf
Olaf Offick - Global Moderator
learnskills.org

jumbles
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 30, 2009 1:02 am
Location: Dublin

Re: Administrator account is missing

Post by jumbles » Mon Nov 30, 2009 12:14 pm

Yeah! There's one in there alright, that could be it! Currently it's pointing to the previous location of the site (on my friend's hosting). Can I just delete this file, or are there changes that I need to make?

Thanks for your help! I'd say that's where the problem is!

User avatar
ooffick
Joomla! Master
Joomla! Master
Posts: 11483
Joined: Thu Jul 17, 2008 3:10 pm
Location: Ireland
Contact:

Re: Administrator account is missing

Post by ooffick » Mon Nov 30, 2009 12:15 pm

Try to rename it to htaccess.txt

Olaf
Olaf Offick - Global Moderator
learnskills.org

jumbles
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Mon Nov 30, 2009 1:02 am
Location: Dublin

Re: Administrator account is missing

Post by jumbles » Mon Nov 30, 2009 1:54 pm

Thanks Olaf! That worked! The site is up and running. I had to edit the administrator folder locally for some reason, and then upload it in its entirety to my remote folder, but it worked in the end!

Keep up the good work!


Locked

Return to “Administration 1.5”