Super User Deprecated, can't login as super user
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.
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.
- duanemitchell
- 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
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
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
- 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
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?
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
- 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
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.
I tried to find a list of illegal characters but could not. I'd suspect the pipe...3rd from right.
-
- Joomla! Apprentice
- Posts: 16
- Joined: Sun May 08, 2011 12:39 pm
Re: Super User Deprecated, can't login as super user
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!
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.
-
- Joomla! Apprentice
- Posts: 16
- Joined: Sun May 08, 2011 12:39 pm
Re: Super User Deprecated, can't login as super user
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: 202Detailed 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. | 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) |
- Jay44
- Joomla! Ace
- Posts: 1142
- Joined: Fri Oct 19, 2007 10:34 pm
- Location: Australia
Re: Super User Deprecated, can't login as super user
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
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/
This is necessary - http://docs.joomla.org/
- Jay44
- Joomla! Ace
- Posts: 1142
- Joined: Fri Oct 19, 2007 10:34 pm
- Location: Australia
Re: Super User Deprecated, can't login as super user
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
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/
This is necessary - http://docs.joomla.org/
- duanemitchell
- 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
Good information. For me it turned out to be the illegal character. The pipe "|" was the culprit.
- Jay44
- Joomla! Ace
- Posts: 1142
- Joined: Fri Oct 19, 2007 10:34 pm
- Location: Australia
Re: Super User Deprecated, can't login as super user
was that in a password duanemitchell?
"Things not being necessary is what makes life interesting" -- Stephen Fry
This is necessary - http://docs.joomla.org/
This is necessary - http://docs.joomla.org/
- duanemitchell
- 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
yes, in the password.
- Jay44
- Joomla! Ace
- Posts: 1142
- Joined: Fri Oct 19, 2007 10:34 pm
- Location: Australia
Re: Super User Deprecated, can't login as super user
thanks - good to know
"Things not being necessary is what makes life interesting" -- Stephen Fry
This is necessary - http://docs.joomla.org/
This is necessary - http://docs.joomla.org/
-
- 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
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.
(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
- Joomla! Apprentice
- Posts: 14
- Joined: Fri Dec 18, 2009 3:25 am
- Location: Canada
- Contact:
Re: Super User Deprecated, can't login as super user
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 :-(
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 :-(