The Joomla! Forum ™



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.



Post new topic Reply to topic  [ 12 posts ] 
Author Message
PostPosted: Thu Apr 12, 2012 6:23 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Wed Jan 03, 2007 3:16 am
Posts: 90
Location: Boston, MA USA
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


Top
 Profile  
 
PostPosted: Thu Apr 12, 2012 9:01 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Wed Jan 03, 2007 3:16 am
Posts: 90
Location: Boston, MA USA
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


Top
 Profile  
 
PostPosted: Thu Apr 12, 2012 9:09 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Wed Jan 03, 2007 3:16 am
Posts: 90
Location: Boston, MA USA
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


Top
 Profile  
 
PostPosted: Fri Apr 13, 2012 2:42 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun May 08, 2011 12:39 pm
Posts: 16
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.

Top
 Profile  
 
PostPosted: Fri Apr 13, 2012 3:22 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun May 08, 2011 12:39 pm
Posts: 16
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) |


Top
 Profile  
 
PostPosted: Thu May 10, 2012 9:04 am 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Fri Oct 19, 2007 10:34 pm
Posts: 1041
Location: Australia
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/


Top
 Profile  
 
PostPosted: Thu May 10, 2012 11:39 am 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Fri Oct 19, 2007 10:34 pm
Posts: 1041
Location: Australia
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/


Top
 Profile  
 
PostPosted: Thu May 10, 2012 12:09 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Wed Jan 03, 2007 3:16 am
Posts: 90
Location: Boston, MA USA
Good information. For me it turned out to be the illegal character. The pipe "|" was the culprit.

_________________
Next Generation Solutions | http://www.nxgnsol.com


Top
 Profile  
 
PostPosted: Thu May 10, 2012 12:53 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Fri Oct 19, 2007 10:34 pm
Posts: 1041
Location: Australia
was that in a password duanemitchell?

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


Top
 Profile  
 
PostPosted: Fri May 11, 2012 11:06 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Wed Jan 03, 2007 3:16 am
Posts: 90
Location: Boston, MA USA
yes, in the password.

_________________
Next Generation Solutions | http://www.nxgnsol.com


Top
 Profile  
 
PostPosted: Fri May 11, 2012 12:53 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Fri Oct 19, 2007 10:34 pm
Posts: 1041
Location: Australia
thanks - good to know

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


Top
 Profile  
 
PostPosted: Mon Aug 27, 2012 3:05 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Oct 23, 2008 12:27 pm
Posts: 2
Location: Djursland, Denmark
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 



Who is online

Users browsing this forum: No registered users and 17 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group