Super User Deprecated, can't login as super user

Need help with the Administration of your Joomla! 2.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.
User avatar
duanemitchell
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 100
Joined: Wed Jan 03, 2007 3:16 am
Location: Boston, MA USA
Contact:

Super User Deprecated, can't login as super user

Postby duanemitchell » Thu Apr 12, 2012 6:23 pm

There's a number of people experiencing this problem and I cannot find a solution to it.

Working on MAMP I cannot login as the super user. So I went into phpMyAdmin and reset the password to "secret" by changing the MD5 hash. That works fine but I don't want that on the live site. I cannot change it. I can create a new super user and that works fine.

I'm wondering how the user got to be "deprecated" and what does that mean? Is it possible that it's something on the MAMP server.

Also, since "secret" is only a 5 character password might that have caused the user to be deprecated.

If I use Joomla Admin to change the password it appears to work fine but nothing changes. If I reset the password to "secret" using phpMyAdmin it works fine.

I suppose I can delete this user and create it anew but I hate it when stuff like this happens and like to figure it out.

Duane Mitchell
Next Generation Solutions | http://www.nxgnsol.com

User avatar
duanemitchell
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 100
Joined: Wed Jan 03, 2007 3:16 am
Location: Boston, MA USA
Contact:

Re: Super User Deprecated, can't login as super user

Postby duanemitchell » Thu Apr 12, 2012 9:01 pm

I don't think a 5 character password has anything to do with it.

I deleted the Super User account and created a new account with all the same data as the previous except I used a different password. It would not work. I tried changing each of the fields in the user one at a time to figure what the problem was. Nothing worked. I changed the password back to "secret" using the admin panel and it worked. Now however the user is NOT marked as deprecated.

I wonder if I have an illegal character in the password?
Next Generation Solutions | http://www.nxgnsol.com

User avatar
duanemitchell
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 100
Joined: Wed Jan 03, 2007 3:16 am
Location: Boston, MA USA
Contact:

Re: Super User Deprecated, can't login as super user

Postby duanemitchell » Thu Apr 12, 2012 9:09 pm

I changed the password to another complex password and it worked. Must have been an illegal character. Here's the old password: e#iKJ*f+Ol^Q

I tried to find a list of illegal characters but could not. I'd suspect the pipe...3rd from right.
Next Generation Solutions | http://www.nxgnsol.com

n4rky
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun May 08, 2011 12:39 pm

Re: Super User Deprecated, can't login as super user

Postby n4rky » Fri Apr 13, 2012 2:42 am

I, too, find myself suddenly locked out. I found advice on the web about enabling the authentication plugin (not that I have any idea how it got disabled) and fixed that with this mysql command (my phpmyadmin is also on the fritz and I can't even find where its errors are being logged):

UPDATE `joomla`.`jml_extensions` SET `enabled` = '1' WHERE `jml_extensions`.`name` = 'plg_authentication_joomla' limit 1;

I tried resetting the password, following instructions I also found on the web, something like:

update `jml_users` set `password` = MD5('elided') where `jml_users`.`username` = 'benfell';

But it just loops back to the login screen, saying "Username and password do not match or you do not have an account yet." As I also have this my admin user (which is 'benfell') set up as a user, I tried going to the regular login screen (which also looped back) and asking for a password reset, whereupon it failed to supply a ReCaptcha problem and then complained that I hadn't entered the solution.

I seem to all of a sudden have a really screwed up Joomla. And I have no idea why. How do I fix it?

Thanks!
Last edited by n4rky on Fri Apr 13, 2012 3:40 am, edited 1 time in total.

n4rky
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun May 08, 2011 12:39 pm

Re: Super User Deprecated, can't login as super user

Postby n4rky » Fri Apr 13, 2012 3:22 am

Regarding the above, I have found the forum post assistant. Note that this was a working installation until recently:

Forum Post Assistant (v1.2.0) : 12th April 2012 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 2.5.4-Stable (Ember) 2-April-2012
Joomla! Platform :: Joomla Platform 11.4.0-Stable (Brian Kernighan) 03-Jan-2012
Joomla! Configured :: Yes | Read-Only (444) | Owner: 33 (uid: /gid: ) | Group: 33 (gid: ) | Valid For: 2.5 and above
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 0 | .htaccess/web.config: Yes | GZip: 1 | Cache: 0 | FTP Layer: 0 | SSL: 0 | Error Reporting: default | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 3.0.18-x86_64-linode24 | Technology: x86_64 | Web Server: Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/1.0.1 DAV/2 PHP/5.3.10 with Suhosin-Patch | Encoding: gzip, deflate | Doc Root: /home/www/parts-unknown.org/ | System TMP Writable: Yes

PHP Configuration :: Version: 5.3.10 | PHP API: apache2handler | Session Path Writable: Unknown | Display Errors: | Error Reporting: 22527 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 8M | Max. POST Size: 16M | Max. Input Time: 60 | Max. Execution Time: 600 | Memory Limit: 256M

MySQL Configuration :: Version: 5.5.22 (Client:mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $) | Host: --protected-- (--protected--) | Collation: utf8_general_ci (Character Set: utf8) | Database Size: 18.11 MiB | #of _FPA_TABLE: 202
Detailed Environment :: wrote:PHP Extensions :: Core (5.3.10) | date (5.3.10) | ereg () | libxml () | pcre () | zlib (1.1) | ctype () | dom (20031129) | fileinfo (1.0.5-dev) | filter (0.11.0) | hash (1.0) | mbstring () | SPL (0.2) | PDO (1.0.4dev) | Reflection ($Revision: 321634 $) | session () | SimpleXML (0.1) | standard (5.3.10) | tokenizer (0.1) | xml () | xmlreader (0.1) | xmlwriter (0.1) | mysqlnd (mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $) | apache2handler () | iconv () | uploadprogress (1.0.3.1) | mysqli (0.1) | mysql (1.0) | json (1.2.1) | pdo_mysql (1.0.2) | curl () | gd () | gettext () | mcrypt () | tidy (2.0) | xmlrpc (0.51) | zip (1.9.1) | openssl () | http (1.7.1) | bz2 () | imap () | gmp () | bcmath () | memcache (3.0.6) | mailparse (2.1.5) | imagick (3.0.1) | lzf (1.5.2) | pam (1.0.3) | geoip (1.0.8) | apc (3.1.9) | ssh2 (0.11.3-dev) | gnupg (1.3.2-dev) | eAccelerator (0.9.6.1) | mhash () | Zend Engine (2.3.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: No | Server SU: No | PHP SU: No | Custom SU (LiteSpeed/Cloud/Grid): No
Potential Ownership Issues: Maybe

Apache Modules :: core | prefork | http_core | mod_so | mod_authn_file | mod_authn_dbm | mod_authn_anon | mod_authn_dbd | mod_authn_default | mod_authz_host | mod_authz_groupfile | mod_authz_user | mod_authz_dbm | mod_authz_owner | mod_authnz_ldap | mod_authz_default | mod_auth_basic | mod_auth_digest | mod_file_cache | mod_cache | mod_disk_cache | mod_mem_cache | mod_dbd | mod_dumpio | mod_reqtimeout | mod_ext_filter | mod_include | mod_filter | mod_substitute | mod_deflate | util_ldap | mod_log_config | mod_log_forensic | mod_logio | mod_env | mod_mime_magic | mod_cern_meta | mod_expires | mod_headers | mod_ident | mod_usertrack | mod_unique_id | mod_setenvif | mod_version | mod_proxy | mod_proxy_connect | mod_proxy_ftp | mod_proxy_http | mod_proxy_scgi | mod_proxy_ajp | mod_proxy_balancer | mod_ssl | mod_mime | mod_dav | mod_status | mod_autoindex | mod_asis | mod_info | mod_suexec | mod_cgi | mod_cgid | mod_dav_fs | mod_vhost_alias | mod_negotiation | mod_dir | mod_imagemap | mod_actions | mod_speling | mod_userdir | mod_alias | mod_rewrite | mod_php5 | Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/1.0.1 DAV/2 PHP/5.3.10 with Suhosin-Patch |
Potential Missing Modules :: mod_security | mod_evasive | mod_dosevasive | mod_qos | mod_userdir |
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) |
Templates Discovered :: wrote:Templates :: SITE :: atomic (2.5.0) | beez5 (2.5.0) | beez_20 (2.5.0) | beez_20 (2.5.0) | fjt002_j25 (2.5.0) |
Templates :: ADMIN :: bluestork (2.5.0) | hathor (2.5.0) |

User avatar
Jay44
Joomla! Ace
Joomla! Ace
Posts: 1116
Joined: Fri Oct 19, 2007 10:34 pm
Location: Australia

Re: Super User Deprecated, can't login as super user

Postby Jay44 » Thu May 10, 2012 9:04 am

Me too.

All was good - then I deleted the sub-folder that I originally used to set up the 2.5 version of the site - it had already been moved to the root and was working there -

I went into phpMyadmin to check plg_authentication_joomla
- sure enough it was NOT enabled, so I enabled it.

Makes no difference.

I am running admin tools so I have gone into plugins/system/admintools and disabled the plugin

- still can't get in

I want to so the SQL thing where you add the user and all the other tables to get a new super user in there that is clean - but I can only find the sql relating to a j1.5 database, not a 2.5

Can anyone help with that please?

J
"Things not being necessary is what makes life interesting" -- Stephen Fry
This is necessary - http://docs.joomla.org/

User avatar
Jay44
Joomla! Ace
Joomla! Ace
Posts: 1116
Joined: Fri Oct 19, 2007 10:34 pm
Location: Australia

Re: Super User Deprecated, can't login as super user

Postby Jay44 » Thu May 10, 2012 11:39 am

Ok - this is how I solved it:

in phpMyadmin
step1
FIRST THING YOU ALWAYS DO IS EXPORT THE DATABASE SO IF YOU STUFF UP YOU CAN IMPORT IT AGAIN

Then:
step 2
find your sessions table - delete all sessions

Step 3
find extensions table - and the plugin:

plg_authentication_joomla

(mine was on page 3) - and make sure client_id, enabled, access, protected are all set to 1



J
"Things not being necessary is what makes life interesting" -- Stephen Fry
This is necessary - http://docs.joomla.org/

User avatar
duanemitchell
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 100
Joined: Wed Jan 03, 2007 3:16 am
Location: Boston, MA USA
Contact:

Re: Super User Deprecated, can't login as super user

Postby duanemitchell » Thu May 10, 2012 12:09 pm

Good information. For me it turned out to be the illegal character. The pipe "|" was the culprit.
Next Generation Solutions | http://www.nxgnsol.com

User avatar
Jay44
Joomla! Ace
Joomla! Ace
Posts: 1116
Joined: Fri Oct 19, 2007 10:34 pm
Location: Australia

Re: Super User Deprecated, can't login as super user

Postby Jay44 » Thu May 10, 2012 12:53 pm

was that in a password duanemitchell?
"Things not being necessary is what makes life interesting" -- Stephen Fry
This is necessary - http://docs.joomla.org/

User avatar
duanemitchell
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 100
Joined: Wed Jan 03, 2007 3:16 am
Location: Boston, MA USA
Contact:

Re: Super User Deprecated, can't login as super user

Postby duanemitchell » Fri May 11, 2012 11:06 am

yes, in the password.
Next Generation Solutions | http://www.nxgnsol.com

User avatar
Jay44
Joomla! Ace
Joomla! Ace
Posts: 1116
Joined: Fri Oct 19, 2007 10:34 pm
Location: Australia

Re: Super User Deprecated, can't login as super user

Postby Jay44 » Fri May 11, 2012 12:53 pm

thanks - good to know
"Things not being necessary is what makes life interesting" -- Stephen Fry
This is necessary - http://docs.joomla.org/

finnpetersen
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Oct 23, 2008 12:27 pm
Location: Djursland, Denmark

Re: Super User Deprecated, can't login as super user

Postby finnpetersen » Mon Aug 27, 2012 3:05 pm

I can add that I could not login as super_admin after moving website (Joomla 2.5.6) from local XAMPP server to public webserver.
(db-table superadmin was "deprecated").
Then I changed password so it did NOT contain _ (underscore), then exported database and imported on public server.
Then succesful login.


Return to “Administration Joomla! 2.5”

Who is online

Users browsing this forum: No registered users and 6 guests