Super User Deprecated, can't login as super user

[duanemitchell]

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

[duanemitchell]

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?

[duanemitchell]

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.

[n4rky]

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!

[n4rky]

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

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

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. | 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 |

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 :: 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) |

[Jay44]

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

[Jay44]

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

[duanemitchell]

Good information. For me it turned out to be the illegal character. The pipe "|" was the culprit.

[Jay44]

was that in a password duanemitchell?

[duanemitchell]

yes, in the password.

[Jay44]

thanks - good to know

[finnpetersen]

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.

[naseemj2]

Hi although this post very old, but landed here to find answer for my issue.
But here is what worked for me, might it can help someone else if similar issue.

I Changed Host provider & newer host have PHP 7
Simply i switched back to old version of php 5.6 = joomla 2.5

Second see in your Configuration.php file Somewhere line 56 and 57
public $log_path = 'F:\xampp\htdocs\homeprix\logs';
public $tmp_path = 'F:\xampp\htdocs\homeprix\tmp';

Directory permission has correct path?

Yes I tried from phpMyAdmin all option change password etc. nope that did not worked :-(