Unable to login to Administrator Panel

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.
Locked
loungeLizard
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jul 19, 2012 2:58 pm
Location: Berkshire, UK

Unable to login to Administrator Panel

Post by loungeLizard » Thu Jul 19, 2012 3:15 pm

Hi, I am new to Joomla. Have a development site on localhost. See attached forum post assistant printout. Everything was going along swimmingly, suddenly I am unable to login via the administrator panel. There is no error message. Tried changing the password via phpmyadmin, still not working. Front end seems to be fine. I may have installed a rogue component/plugin? Not sure what to try next.

I have been using Dreamweaver to change css. Also updated the TCPDF library yesterday which generates PDF files. Not sure if this could have been the problem?? But the frontend site seems to be fine except the login doesn't work for admin or user acc.

I have a backup from before yesterday but unfortunately did not get another one before the problem occurred and installed a lot of articles. I need to know why this happened because I don't want it occurring again.

Thanks in advance for any advice!

MA
Problem Description :: Forum Post Assistant (v1.2.1) : 19th July 2012 wrote:Cannot login to administrator panel
Log/Error Message :: Forum Post Assistant (v1.2.1) : 19th July 2012 wrote:No error messages
Forum Post Assistant (v1.2.1) : 19th July 2012 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 2.5.6-Stable (Ember) 19-June-2012
Joomla! Platform :: Joomla Platform 11.4.0-Stable (Brian Kernighan) 03-Jan-2012
Joomla! Configured :: Yes | Writable (666) | Owner: 0 (uid: /gid: ) | Group: 0 (gid: ) | Valid For: 2.5 and above
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 0 | .htaccess/web.config: No | GZip: 0 | 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: Windows NT | OS Version: 6.0 | Technology: i586 | Web Server: Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 | Encoding: gzip, deflate | Doc Root: C:/xampp/htdocs | System TMP Writable: Yes

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

MySQL Configuration :: Version: 5.1.41 (Client:5.1.41) | Host: --protected-- (--protected--) | Collation: utf8_general_ci (Character Set: utf8) | Database Size: 6.05 MiB | #of _FPA_TABLE: 153
Detailed Environment :: wrote:PHP Extensions :: Core (5.3.1) | bcmath () | calendar () | com_dotnet (0.1) | ctype () | date (5.3.1) | ereg () | filter (0.11.0) | ftp () | hash (1.0) | iconv () | json (1.2.1) | mysqlnd (mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $) | odbc (1.0) | openssl () | pcre () | Reflection ($Revision: 287991 $) | session () | SPL (0.2) | standard (5.3.1) | tokenizer (0.1) | zlib (1.1) | libxml () | dom (20031129) | Phar (2.0.1) | SimpleXML (0.1) | wddx () | xml () | xmlreader (0.1) | xmlwriter (0.1) | xsl (0.1) | apache2handler () | curl () | mbstring () | exif (1.4 $Id: exif.c 287372 2009-08-16 14:32:32Z iliaa $) | fileinfo (1.0.5-dev) | gd () | gettext () | imap () | mcrypt () | mysql (1.0) | mysqli (0.1) | PDO (1.0.4dev) | pdo_mysql (1.0.2) | PDO_ODBC (1.0.1) | pdo_sqlite (1.0.1) | soap () | sockets () | SQLite (2.0-dev) | sqlite3 (0.7-dev) | xmlrpc (0.51) | zip (1.9.1) | ming () | pdf (2.1.6) | 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): Yes
Potential Ownership Issues: No

Apache Modules :: core | mod_win32 | mpm_winnt | http_core | mod_so | mod_actions | mod_alias | mod_asis | mod_auth_basic | mod_auth_digest | mod_authn_default | mod_authn_file | mod_authz_default | mod_authz_groupfile | mod_authz_host | mod_authz_user | mod_cgi | mod_dav | mod_dav_fs | mod_dav_lock | mod_dir | mod_env | mod_headers | mod_include | mod_info | mod_isapi | mod_log_config | mod_mime | mod_negotiation | mod_rewrite | mod_setenvif | mod_ssl | mod_status | mod_autoindex_color | mod_php5 | mod_perl | mod_apreq2 | Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 |
Potential Missing Modules :: mod_expires | mod_deflate | mod_security | mod_evasive | mod_dosevasive | mod_qos | mod_userdir |
Folder Permissions :: wrote:Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (777) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) |

Elevated Permissions (First 10) :: None administrator/ (777) | administrator/cache/ (777) | administrator/components/ (777) | administrator/components/com_admin/ (777) | administrator/components/com_admin/controllers/ (777) | administrator/components/com_admin/helpers/ (777) | administrator/components/com_admin/helpers/html/ (777) | administrator/components/com_admin/models/ (777) | administrator/components/com_admin/models/forms/ (777) |
Extensions Discovered :: wrote:Components :: SITE :: com_mailto (2.5.0) | com_wrapper (2.5.0) |
Components :: ADMIN :: com_admin (2.5.0) | Admintools (2.2.9) | Akeeba (3.5.2) | com_banners (2.5.0) | com_cache (2.5.0) | com_categories (2.5.0) | com_checkin (2.5.0) | com_config (2.5.0) | com_content (2.5.0) | com_cpanel (2.5.0) | com_finder (2.5.0) | com_installer (2.5.0) | com_joomlaupdate (2.5.0) | com_languages (2.5.0) | com_login (2.5.0) | com_media (2.5.0) | com_menus (2.5.0) | com_messages (2.5.0) | com_modules (2.5.0) | com_newsfeeds (2.5.0) | com_plugins (2.5.0) | Quick Logout (1.7.1) | com_redirect (2.5.0) | RSForm (1.4.0 R43) | rsinstaller (1.3.0) | com_search (2.5.0) | com_templates (2.5.0) | COM_TERMSOFSERVICE (1.6) | com_users (2.5.0) | com_weblinks (2.5.0) | com_xmap (2.2.1) |

Modules :: SITE :: mod_articles_archive (2.5.0) | mod_articles_categories (2.5.0) | mod_articles_category (2.5.0) | mod_articles_latest (2.5.0) | mod_articles_news (2.5.0) | mod_articles_popular (2.5.0) | mod_banners (2.5.0) | mod_breadcrumbs (2.5.0) | mod_custom (2.5.0) | mod_eprivacy (2.3) | mod_feed (2.5.0) | mod_finder (2.5.0) | mod_footer (2.5.0) | mod_languages (2.5.0) | mod_login (2.5.0) | mod_menu (2.5.0) | Qlue Accordion (2.5.0) | mod_random_image (2.5.0) | mod_related_items (2.5.0) | RSForm! Pro Module (1.3.0) | RSForm! Pro Feedback Module (1.3.0) | RSForm! Pro Module Frontend Li (1.3.0) | S5 Register (1.6.0) | mod_search (2.5.0) | mod_stats (2.5.0) | mod_syndicate (2.5.0) | mod_users_latest (2.5.0) | mod_weblinks (2.5.0) | mod_whosonline (2.5.0) | mod_wrapper (2.5.0) |
Modules :: ADMIN :: Admin Tools Joomla! Upgrade No (revAE48DBE) | mod_custom (2.5.0) | mod_feed (2.5.0) | mod_latest (2.5.0) | mod_logged (2.5.0) | mod_login (2.5.0) | mod_menu (2.5.0) | mod_multilangstatus (2.5.0) | mod_online (1.6.0) | mod_popular (2.5.0) | mod_quickicon (2.5.0) | mod_status (2.5.0) | mod_submenu (2.5.0) | mod_title (2.5.0) | mod_toolbar (2.5.0) | mod_unread (1.6.0) | mod_version (2.5.0) |

Plugins :: SITE :: plg_authentication_gmail (2.5.0) | plg_authentication_joomla (2.5.0) | plg_authentication_ldap (2.5.0) | plg_captcha_recaptcha (2.5.0) | plg_content_emailcloak (2.5.0) | plg_content_finder (2.5.0) | plg_content_geshi (2.5.0) | plg_content_joomla (2.5.0) | plg_content_loadmodule (2.5.0) | plg_content_pagebreak (2.5.0) | plg_content_pagenavigation (2.5.0) | Content - RSForm! Pro (1.3.0) | plg_content_vote (2.5.0) | plg_editors_codemirror (1.0) | plg_editors_tinymce (3.5.2) | plg_editors-xtd_article (2.5.0) | plg_editors-xtd_image (2.5.0) | plg_editors-xtd_pagebreak (2.5.0) | plg_editors-xtd_readmore (2.5.0) | PLG_EDITORS-XTD_TOOLTIPS (2.1.0FREE) | plg_extension_joomla (2.5.0) | plg_finder_categories (2.5.0) | plg_finder_contacts (2.5.0) | plg_finder_content (2.5.0) | plg_finder_newsfeeds (2.5.0) | plg_finder_weblinks (2.5.0) | PLG_JMONITORING_AKEEBABACKUP_T (1.0) | plg_quickicon_extensionupdate (2.5.0) | plg_quickicon_joomlaupdate (2.5.0) | plg_search_categories (2.5.0) | plg_search_contacts (2.5.0) | plg_search_content (2.5.0) | plg_search_newsfeeds (2.5.0) | plg_search_weblinks (2.5.0) | System - Admin Tools (2.2.9) | plg_system_cache (2.5.0) | plg_system_debug (2.5.0) | PLG_SYS_EPRIVACY (2.3) | plg_system_highlight (2.5.0) | System - jQuery Easy (1.2.0) | plg_system_languagecode (2.5.0) | plg_system_languagefilter (2.5.0) | plg_system_log (2.5.0) | plg_system_logout (2.5.0) | PLG_SYSTEM_NNFRAMEWORK (12.5.1) | plg_system_p3p (2.5.0) | plg_system_redirect (2.5.0) | plg_system_remember (2.5.0) | System - RSForm! Pro (1.3.0) | System - RSForm! Pro Feedback (1.3.0) | System - RSForm! Pro Paypal (1.3.0) | System - RSForm! Pro reCAPTCHA (1.3.0) | System - RSForm! Pro Registrat (1.0.0) | System - S5 Flex Menu (1.0) | plg_system_sef (2.5.0) | System - SEOSimple (2.1) | plg_sys_termsofservice (1.6) | PLG_SYSTEM_TOOLTIPS (2.1.0FREE) | plg_user_contactcreator (2.5.0) | plg_user_joomla (2.5.0) | plg_user_profile (2.5.0) | plg_user_termsofservice (1.6) | Xmap - Content Plugin (2.0.3) | Xmap - Kunena Plugin (2.0.2) | Xmap - Mosets Tree Plugin (2.0.2) | Xmap - SobiPro Plugin (2.0.1) | Xmap - Virtuemart Plugin (2.0.0) | Xmap - WebLinks Plugin (2.0) |
Templates Discovered :: wrote:Templates :: SITE :: atomic (2.5.0) | beez5 (2.5.0) | beez_20 (2.5.0) | shape5_vertex (2.0) |
Templates :: ADMIN :: bluestork (2.5.0) | hathor (2.5.0) |

bbolli
Joomla! Explorer
Joomla! Explorer
Posts: 455
Joined: Fri Nov 11, 2011 9:43 pm
Location: Chicago, IL

Re: Unable to login to Administrator Panel

Post by bbolli » Thu Jul 19, 2012 3:33 pm

Tried changing the password via phpmyadmin, still not working.
Did you enter your encrypted password into the database or use your regular password? If you didn't encrypt before putting into DB, this should be added to list of things.

1) What are you using to host your development environment?
2) What errors does your apache2 log display when you try and log in?
3) Did you recently enable SEF or URL Rewrite in global configuration?

As far as the articles you entered, even if you need to restore to an older backup you can easily export and insert by ID the articles using PHPMyAdmin.

User avatar
matt777
Joomla! Guru
Joomla! Guru
Posts: 643
Joined: Sun May 06, 2012 8:29 pm
Location: London
Contact:

Re: Unable to login to Administrator Panel

Post by matt777 » Thu Jul 19, 2012 3:37 pm

Just check your comfiguration.php file and check the settings in their. What was the component or plugin you installed. Was it anything like suhosin as this comes up in the report "Potential Missing Extensions :: suhosin". I maybe wrong but i dont think suhosin comes with the standered Joomla installation.
Eastern Odyssey | http://www.easternodyssey.com The Definitive Guide to Asia

loungeLizard
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jul 19, 2012 2:58 pm
Location: Berkshire, UK

Re: Unable to login to Administrator Panel

Post by loungeLizard » Thu Jul 19, 2012 9:03 pm

As far as the articles you entered, even if you need to restore to an older backup you can easily export and insert by ID the articles using PHPMyAdmin.
Think I will have to do that instead of messing about.

Another thing I noticed is that when going to the frontend home page, it just goes to index.php/component/users/?view=login - the message that displays is 'Please login first'. I'm unable to login using the administrator username and password.

I'm now thinking that I could have adjusted the users permissions incorrectly and that is why no login. Now because I'm unable to get back into the admin backend to check users permissions is it possible to do that via phpmyadmin? Maybe just better to get last backup restored and learn my lesson well. Too many late nights working on this, being interrupted by people dropping in and losing concentration on what I'm doing...

bbolli
Joomla! Explorer
Joomla! Explorer
Posts: 455
Joined: Fri Nov 11, 2011 9:43 pm
Location: Chicago, IL

Re: Unable to login to Administrator Panel

Post by bbolli » Thu Jul 19, 2012 9:16 pm

Tried changing the password via phpmyadmin, still not working.
When you changed the password via PHP My Admin and assuming your password is Password; did you enter Password into the DB or the encrypted version?

My guess is you entered just the text version, as Joomla 2.5 uses a MD5 Hash which has been salted and requires a bit of leg work to replicate.

http://stackoverflow.com/questions/1042 ... encryption

If you have another profile which still has the encrypted password and salt for which you know the password, you can simply copy the encrypted password into the admin's password field using PHP My Admin and you should be able to login.

loungeLizard
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jul 19, 2012 2:58 pm
Location: Berkshire, UK

Re: Unable to login to Administrator Panel

Post by loungeLizard » Thu Jul 19, 2012 9:50 pm

I cut and pasted the admin password (same one) from a second Joomla backend superuser account so it wasn't a text version. This still didn't work.

bbolli
Joomla! Explorer
Joomla! Explorer
Posts: 455
Joined: Fri Nov 11, 2011 9:43 pm
Location: Chicago, IL

Re: Unable to login to Administrator Panel

Post by bbolli » Thu Jul 19, 2012 10:39 pm

You mentioned you might have inadvertently changed the admin user permissions. Find the id for the super user in #__users table, it's usually 42 unless you changed it, and verify that value is listed in the #__user_usergroup_map with the proper group_id for the Super User primary key id in the #__usergroups table, which is usually 8. If not, manually change those values to assign to the super user group and test.

If not, back to the drawing board!

loungeLizard
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jul 19, 2012 2:58 pm
Location: Berkshire, UK

Re: Unable to login to Administrator Panel

Post by loungeLizard » Fri Jul 20, 2012 10:32 am

Thanks for all your suggestions and the quick response on this board. Will bear that in mind next time.

I have now restored to the latest version and can login both front and back end.

:-[ Important Lesson No. 1 - B*A*C*K*U*P before touching any settings or installing any new components/plugins/etc. Follow instructions carefully >>>


Locked

Return to “Administration Joomla! 2.5”