users or admin cannot login to user area, all locked out

[NetSpace]

All uses are locked out of membership areas, both admins and registered users cannot access any member areas. Does anyone know of a fix? I have created a new admin account in mysql but that new user cant log in either. I have access thru cPanel but do not know where the problem lies. I have spent this PM trying to search out a fix on the web and will continue, hope you can help with this. I made one small change and after that the lockout occured, I am not sure this was the cause, but... I check the box to not allow create account where the login asks for a password reminder. BTW, can't login to the backend either. I tried root user backdoor but still can't get in

northgacern.org

[Webdongle]

What error message are you getting ?

[NetSpace]

error logging in to backend - Use a valid username and password to gain access to the administrator backend. Also tried the emergency login but doesn't work either.

[Webdongle]

Please see http://forum.joomla.org/viewtopic.php?f ... n#p2587248

[NetSpace]

How do I determine if it is disabled? It is there and since I am not a PHP guy I do not see any overt indication that is is not working. I do not have a file called jauthentication. Only have files in the administration/plugins/authentication/joomla folder called joomla.php and Joomla.xml

I can't get into joomla to do anything, this is only thru the file manager.

[Webdongle]

http://forum.joomla.org/viewtopic.php?f ... n#p2587248 shows a screenshot of the database. Under Enabled ... 1 = yes and 0=no. Make sure it is 1

[NetSpace]

I do not see an image, a link but not an image. There is no jauthentication that I can find, searched for it.

[Webdongle]

I do not see an image, a link but not an image. ....

Perhaps if you click the link that I posted then it may take you to a post that has an image ?

[NetSpace]

ok, it appears sometimes and others not.

[NetSpace]

it appears I do not have that line in the database, can I use the values in you picture to creat one?

[Webdongle]

Keep looking and you will find it

[sovainfo]

Try: SELECT * FROM `j341_extensions` WHERE folder LIKE "auth%"

Should return 4 rows: cookie and joomla should be enabled ( 1 )

See installation/sql/mysql/joomla.sql for inserting them with correct values.

[NetSpace]

I do appreciate all the help but I am not advanced enough to understand all you have told me to do.

Try: SELECT * FROM `j341_extensions` WHERE folder LIKE "auth%"
Should return 4 rows: cookie and joomla should be enabled ( 1 )

How do I change the "select"? can't find how to modify it. I have searched but can find no jauth in extensions. j341? I am kinda lost.

[Webdongle]

Try

search database 01.png

[sovainfo]

- Open phpMyAdmin
- Select database on the left
- Select table j341_extenions on the left (replace j341 with whatever prefix you use).
- Select tab SQL in the center
- Replace statement with the one suggested
- Press go

Or try suggestion of @webdongle
- Select tab Search from center (next to SQL)
- Enter auth% in value column for Folder
- Press Go

[NetSpace]

AH! Ok, I found it, BUT it appears that all is enabled.

[Webdongle]

Nice work ... now we can rule that out. Now please http://forum.joomla.org/viewtopic.php?f=621&t=582860 ... it gives instructions how to collect data to post in this thread.

Also please send me a login so I can see exactly what happens.

[Webdongle]

#8 /home/northgac/public_html/libraries/joomla/application/app in /home/northgac/public_html/libraries/joomla/environment/uri.php on line 194

Joomla! Instance :: Joomla! 2.5.14-Stable (Ember) 01-August-2013
Joomla! Platform :: Joomla Platform 11.4.0-Stable (Brian Kernighan) 03-Jan-2012
Joomla! Configured :: Yes | Writable (644) | Owner: northgac (uid: 1/gid: 1) | Group: northgac (gid: 1) | Valid For: 2.5
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 0 | .htaccess/web.config: Yes | 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: Linux | OS Version: 3.12.39-69.ELK6.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: /home/northgac/public_html | System TMP Writable: Yes

PHP Configuration :: Version: 5.4.38 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: 22519 | Log Errors To: error_log | Last Known Error: 04th February 2015 07:21:49. | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 64M | Max. POST Size: 64M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 256M

MySQL Configuration :: Version: 5.5.40-36.1 (Client:5.5.40-36.1) | Host: --protected-- (--protected--) | Collation: utf8_unicode_ci (Character Set: utf8) | Database Size: 3.31 MiB | #of Tables: 94

PHP Extensions :: Core (5.4.38) | date (5.4.38) | ereg () | libxml () | openssl () | pcre () | sqlite3 (0.7) | zlib (2.0) | bcmath () | bz2 () | calendar () | ctype () | curl () | dom (20031129) | hash (1.0) | fileinfo (1.0.5) | filter (0.11.0) | ftp () | gd () | gettext () | gmp () | SPL (0.2) | iconv () | session () | intl (1.1.0) | json (1.2.1) | mbstring () | mcrypt () | mssql () | mysql (1.0) | mysqli (0.1) | odbc (1.0) | standard (5.4.38) | PDO (1.0.4dev) | pdo_mysql (1.0.2) | pdo_sqlite (1.0.1) | Phar (2.0.1) | posix () | pspell () | Reflection ($Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $) | imap () | SimpleXML (0.1) | soap () | sockets () | exif (1.4 $Id: 7f95ff43ea7cc9a2c41a912863ed70069c0e34c5 $) | tidy (2.0) | tokenizer (0.1) | wddx () | xml () | xmlreader (0.1) | xmlrpc (0.51) | xmlwriter (0.1) | xsl (0.1) | zip (1.11.0) | cgi-fcgi () | imagick (3.1.0RC2) | SourceGuardian (10.1.4) | mhash () | ionCube Loader () | Zend Guard Loader () | Zend Engine (2.4.0) |
Potential Missing Extensions :: suhosin |

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

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

Elevated Permissions (First 10) ::

Components :: SITE :: com_wrapper (2.5.0) | WF_SPELLCHECKER_TITLE (2.3.1) | WF_ARTICLE_TITLE (2.3.1) | WF_INLINEPOPUPS_TITLE (2.3.1) | WF_VISUALCHARS_TITLE (2.3.1) | WF_XHTMLXTRAS_TITLE (2.3.1) | WF_STYLE_TITLE (2.3.1) | WF_VISUALBLOCKS_TITLE (2.3.1) | WF_CONTEXTMENU_TITLE (2.3.1) | WF_IMGMANAGER_TITLE (2.3.1) | WF_CLEANUP_TITLE (2.3.1) | WF_KITCHENSINK_TITLE (2.3.1) | WF_MEDIA_TITLE (2.3.1) | WF_ANCHOR_TITLE (2.3.1) | WF_DIRECTIONALITY_TITLE (2.3.1) | WF_LAYER_TITLE (2.3.1) | WF_LISTS_TITLE (2.3.1) | WF_NONBREAKING_TITLE (2.3.1) | WF_TEXTCASE_TITLE (2.3.1) | WF_PREVIEW_TITLE (2.3.1) | WF_BROWSER_TITLE (2.3.1) | WF_SEARCHREPLACE_TITLE (2.3.1) | WF_SOURCE_TITLE (2.3.1) | WF_AUTOSAVE_TITLE (2.3.1) | WF_CLIPBOARD_TITLE (2.3.1) | WF_LINK_TITLE (2.3.1) | WF_TABLE_TITLE (2.3.1) | WF_PRINT_TITLE (2.3.1) | WF_FULLSCREEN_TITLE (2.3.1) | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.3.1) | WF_LINKS_JOOMLALINKS_TITLE (2.3.1) | WF_LINK_SEARCH_TITLE (2.3.1) | WF_AGGREGATOR_[youtube]_TITLE (2.3.1) | WF_AGGREGATOR_VIMEO_TITLE (2.3.1) | WF_AGGREGATOR_GOOGLEMAPS_TITLE (2.3.1) | WF_POPUPS_JCEMEDIABOX_TITLE (2.3.1) | WF_POPUPS_WINDOW_TITLE (2.3.1) | WF_FILESYSTEM_JOOMLA_TITLE (2.3.1) | com_mailto (2.5.0) |
Components :: ADMIN :: form (0.6.2) | com_modules (2.5.0) | com_menus (2.5.0) | com_config (2.5.0) | com_installer (2.5.0) | com_weblinks (2.5.0) | com_finder (2.5.0) | com_plugins (2.5.0) | com_login (2.5.0) | com_templates (2.5.0) | com_redirect (2.5.0) | com_categories (2.5.0) | com_languages (2.5.0) | com_checkin (2.5.0) | com_admin (2.5.0) | Unknown (-) | JCE (2.3.1) | Editor - JCE (2.3.1) | Editor - JCE (2.3.1) | JCE File Browser (2.3.1) | plg_quickicon_jcefilebrowser (2.5.0) | com_media (2.5.0) | com_search (2.5.0) | FlexiContact (6.01.01) | com_newsfeeds (2.5.0) | com_banners (2.5.0) | com_cache (2.5.0) | com_joomlaupdate (2.5.0) | UniForm (3.1.2) | com_content (2.5.0) | com_users (2.5.0) | com_cpanel (2.5.0) | com_messages (2.5.0) |

Modules :: SITE :: mod_articles_latest (2.5.0) | mod_articles_popular (2.5.0) | mod_form (1.0) | mod_articles_categories (2.5.0) | mod_weblinks (2.5.0) | mod_random_image (2.5.0) | mod_breadcrumbs (2.5.0) | mod_search (2.5.0) | mod_menu (2.5.0) | mod_articles_category (2.5.0) | mod_feed (2.5.0) | mod_banners (2.5.0) | mod_users_latest (2.5.0) | mod_footer (2.5.0) | JSN UniForm (3.1.2) | mod_login (2.5.0) | mod_syndicate (2.5.0) | mod_languages (2.5.0) | mod_articles_archive (2.5.0) | mod_stats (2.5.0) | mod_related_items (2.5.0) | mod_finder (2.5.0) | mod_articles_news (2.5.0) | mod_whosonline (2.5.0) | mod_custom (2.5.0) | mod_wrapper (2.5.0) |
Modules :: ADMIN :: mod_status (2.5.0) | mod_submenu (2.5.0) | mod_popular (2.5.0) | mod_multilangstatus (2.5.0) | mod_menu (2.5.0) | mod_feed (2.5.0) | mod_latest (2.5.0) | mod_quickicon (2.5.0) | mod_login (2.5.0) | mod_toolbar (2.5.0) | mod_title (2.5.0) | mod_logged (2.5.0) | mod_version (2.5.0) | mod_custom (2.5.0) |

Plugins :: SITE :: plg_user_contactcreator (2.5.0) | plg_user_profile (2.5.0) | plg_user_joomla (2.5.0) | plg_captcha_recaptcha (2.5.0) | plg_system_languagefilter (2.5.0) | plg_system_redirect (2.5.0) | plg_system_logout (2.5.0) | plg_system_p3p (2.5.0) | Unknown (2.0) | plg_system_debug (2.5.0) | plg_system_highlight (2.5.0) | plg_system_log (2.5.0) | plg_system_sef (2.5.0) | Jom Social Registration Redire (3.0.4) | plg_system_languagecode (2.5.0) | plg_system_remember (2.5.0) | plg_system_jsnframework (1.5.2) | plg_system_cache (2.5.0) | plg_authentication_joomla (2.5.0) | plg_authentication_ldap (2.5.0) | plg_authentication_gmail (2.5.0) | plg_editors_tinymce (3.5.4.1) | Editor - JCE (2.3.1) | plg_editors_codemirror (1.0) | plg_extension_joomla (2.5.0) | plg_search_contacts (2.5.0) | plg_search_content (2.5.0) | plg_search_categories (2.5.0) | plg_search_newsfeeds (2.5.0) | plg_search_weblinks (2.5.0) | plg_content_vote (2.5.0) | plg_content_joomla (2.5.0) | plg_content_pagebreak (2.5.0) | plg_content_pagenavigation (2.5.0) | plg_content_loadmodule (2.5.0) | JSN_UNIFORM_PLUGIN_CONTENT_TIT (3.1.2) | plg_content_geshi (2.5.0) | plg_content_finder (2.5.0) | plg_content_emailcloak (2.5.0) | plg-uniform - Mailchimp (@version) | plg_quickicon_joomlaupdate (2.5.0) | plg_quickicon_extensionupdate (2.5.0) | plg_quickicon_jcefilebrowser (2.5.0) | plg_editors-xtd_article (2.5.0) | plg_editors-xtd_pagebreak (2.5.0) | plg_editors-xtd_readmore (2.5.0) | JSN_UNIFORM_PLUGIN_BUTTON_TITL (3.1.2) | plg_editors-xtd_image (2.5.0) | plg_finder_contacts (2.5.0) | plg_finder_content (2.5.0) | plg_finder_categories (2.5.0) | plg_finder_newsfeeds (2.5.0) | plg_finder_weblinks (2.5.0) |

Templates :: SITE :: cern6 (2.0) | cern2 (1.0) | cern4 (1.0) | cern (1.0) | cern3 (1.0) | cern5 (1.0) | atomic (2.5.0) | beez5 (2.5.0) | beez_20 (2.5.0) |
Templates :: ADMIN :: bluestork (2.5.0) | hathor (2.5.0) |

[Webdongle]

You are running an old version of Joomla. Install the same version in a subfolder to a different database then edit the configuration.php to connect to the new database and visa versa ... see if the old files will work with a fresh database and the new files with the original database.

[NetSpace]

I am lost... I can't even think how to get this done. If I blow away the db can I re-install it and import the users to fix that? OR is there someone who can fix it for a fee, not to much since this is a free site I am doing for a 501 c3 organisation.

[Webdongle]

http://forum.joomla.org/viewforum.php?f=177