Unabled to login in admin panel Joomla 3.x

[ocupado]

I have been working without problems with my site in Joomla 3.x & Gantry framework until yesterday . Today, when I try to enter the admin panel in the backend with the correct username and password , the system shows me the login screen again.

If I try login in admin panel with wrong user and/or password, Joomla shows me an error which is OK, But if try with right user and password the system does nothing and returns to the login screen again.

Joomla 3.x
PHP 5.4.4

The site has been running fine until yesterday. There has been no changes on the server as it is a dedicated server that is managed by us. The parameters of connection to the database is correct. Configuration.php is OK with no blank lines at the end.

The last change made in joomla was the installation of rsmediagallery component but it was unninstalled later.

if anyone has any idea about what I should check , I appreciate it

Thanks

[jackrabbit]

Could be a case with sessions or cookies

1. clear your browser's cache
2. clear the sessions table of the database via your database manager ie: phpmyadmin

[ocupado]

Hi jackrabbit, Yes i did it. Truncate table of session and clear cache. Same results.

The problem looks not be related to the browser.

Additional info:

If I put error_reporting = "maximun" or "development" Joomla does not show any error.

If I put debug = 1 in configuration.php the system shows me the following:

Code: Select all

Sessions:

_default

Profile Information:

Application 0.001 seconds (+0.001); 0.78 MB (+0.785) - afterLoad
Application 0.091 seconds (+0.091); 6.45 MB (+5.662) - afterInitialise
Application 0.099 seconds (+0.007); 6.86 MB (+0.414) - afterRoute
Application 0.110 seconds (+0.011); 7.56 MB (+0.703) - beforeRenderModule mod_login (Login)
Application 0.122 seconds (+0.013); 7.89 MB (+0.327) - afterRenderModule mod_login (Login)
Application 0.131 seconds (+0.008); 8.18 MB (+0.293) - afterDispatch
Application 0.136 seconds (+0.005); 8.43 MB (+0.246) - afterRender

Memory usage:

8.43 MB (8,843,480 Bytes)

Database queries:

26 Queries Logged

    SELECT `data`
      FROM `cv3_session`
      WHERE `session_id` = 'rn7csaga50he286dgjlv30ja07'
    DELETE
      FROM `cv3_session`
      WHERE `time` < '1414527423'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM cv3_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM cv3_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    SELECT folder AS type, element AS name, params
      FROM cv3_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,5)
      ORDER BY ordering
    SELECT template
      FROM cv3_template_styles as s
      WHERE s.client_id = 0
      AND s.home = 1
    SELECT template
      FROM cv3_template_styles as s
      WHERE s.client_id = 0
      AND s.home = 1
    SELECT extension, file, type
      FROM cv3_rokcommon_configs
      ORDER BY priority
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM cv3_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_widgetkit'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM cv3_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_k2'
    SHOW FULL COLUMNS
      FROM `cv3_extensions`
    SELECT `extension_id`
      FROM `cv3_extensions`
      WHERE type = 'component'
      AND element = 'com_roksprocket'
    SELECT *
      FROM cv3_extensions
      WHERE `extension_id` = '10025'
    SELECT `extension_id`
      FROM `cv3_extensions`
      WHERE type = 'module'
      AND element = 'mod_roksprocket'
    SELECT *
      FROM cv3_extensions
      WHERE `extension_id` = '10025'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM cv3_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_rokcandy'
    SELECT *
      FROM cv3_rokcandy
      WHERE published=1
    SELECT id, home, template, params
      FROM cv3_template_styles
      WHERE client_id = 0
    SELECT template, s.params
      FROM cv3_template_styles as s
      LEFT JOIN cv3_extensions as e
      ON e.type='template'
      AND e.element=s.template
      AND e.client_id=s.client_id
      WHERE s.client_id = 1
      AND home = '1'
      ORDER BY home
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM cv3_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_login'
    SELECT m.id, m.title, m.module, m.position, m.showtitle, m.params
      FROM cv3_modules AS m
      LEFT JOIN cv3_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.module ='mod_login'
      AND m.client_id = 1
      AND e.enabled = 1
      ORDER BY m.position, m.ordering
    SELECT element
      FROM cv3_extensions
      WHERE type='language'
      AND state=0
      AND enabled=1
      AND client_id=1
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM cv3_modules AS m
      LEFT JOIN cv3_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN cv3_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-10-28 20:32:03')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-10-28 20:32:03')
      AND m.access IN (1,1,5)
      AND m.client_id = 1
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    SELECT params
      FROM cv3_extensions AS e
      WHERE e.element='com_widgetkit'
    SELECT extension_id AS id, element AS "option", params, enabled
      FROM cv3_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_media'
    UPDATE `cv3_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1414528315;s:18:\"session.timer.last\";i:1414528322;s:17:\"session.timer.now\";i:1414528323;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5aab3bb1b3a5665926fd2e3c9849957f\";}' , `time` = '1414528323'
      WHERE `session_id` = 'rn7csaga50he286dgjlv30ja07'

17 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

    7 × SELECT extension_id AS id, element AS "option", params, enabled
      FROM cv3_extensions
    2 × SELECT `extension_id`
      FROM `cv3_extensions`
    2 × SELECT template
      FROM cv3_template_styles as s
    2 × SELECT *
      FROM cv3_extensions
    1 × SELECT m.id, m.title, m.module, m.position, m.showtitle, m.params
      FROM cv3_modules AS m
      LEFT JOIN cv3_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
    1 × SELECT element
      FROM cv3_extensions
    1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM cv3_modules AS m
      LEFT JOIN cv3_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN cv3_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
    1 × SELECT params
      FROM cv3_extensions AS e
    1 × SELECT template, s.params
      FROM cv3_template_styles as s
      LEFT JOIN cv3_extensions as e
      ON e.type='template'
      AND e.element=s.template
      AND e.client_id=s.client_id
    1 × SELECT id, home, template, params
      FROM cv3_template_styles
    1 × SELECT folder AS type, element AS name, params
      FROM cv3_extensions
    1 × SELECT `data`
      FROM `cv3_session`
    1 × SELECT *
      FROM cv3_rokcandy
    1 × SELECT extension, file, type
      FROM cv3_rokcommon_configs

OTHER Tables:

    1 × UPDATE `cv3_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1414528315;s:18:\"session.timer.last\";i:1414528322;s:17:\"session.timer.now\";i:1414528323;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5aab3bb1b3a5665926fd2e3c9849957f\";}' , `time` = '1414528323'
    1 × SHOW FULL COLUMNS
      FROM `cv3_extensions
    1 × DELETE
      FROM `cv3_session

[jackrabbit]

Try changing the admin password via phpmyadmin.

Edit the row for the admin and change the password to any plain text word then from the function drop list beside the field, select MD5 then save

[ocupado]

I created a new user with identical privileges of admin user but there is something wrong with the pwd generated via phpadmin & md5. The final pwd generated by joomla uses they keyword introduced by user + $secret variable in configuration.php. I dont know details about this but is something like that.

The point is that in this case, with this new user, joomla said that "Username and password do not match or you do not have an account yet.". With this user the msg is ok.

The problem is when user & pwd are Ok, Joomla shows the login form again.

[jackrabbit]

There are other user related tables which needs data for it to work so you cannot just add a user via the db manager to table #__user

Run the repair function on the database and just change the password for the existing super admin

[ocupado]

Thanks for your response . After I changed the password in _user table the problem is the same. The cause of the problem must be something else.

[exlemor]

Hi there Ocupado,

I'd love to find a solution as this is affecting one of my sites as well and so far I have not found an answer and it's becoming critical as I just launched this site for a client and need to make an update on something...

Cheers,

E.

[jackrabbit]

Thanks for your response . After I changed the password in _user table the problem is the same. The cause of the problem must be something else.

At this point you will need to get the attention of a 'Joomla Ace' with moderation level (those with names in red). Try sending a PM asking them to post a solution in this thread. Or try the forum at StackExchange http://joomla.stackexchange.com/

[ocupado]

Ok. Thanks. I'll do it.

[exlemor]

In my case, it was the easily fixable once I found it of course, the configuration.php file had a file cookie set and once I removed the cookie and the path to the cookie to blanks =''; everything worked great again...

[ocupado]

Good luck for you exlemor.
In my case this two variables related to cookies in configuration.php are = "".

[AMurray]

@ocupado,

Thread is a little old (but apparently no solution).

The way you say you set these in configuration.php

In my case this two variables related to cookies in configuration.php are = "".

It appears that is incorrect, it should be two single quotes not two double-quotes as @exlemor had posted in his reply.

I think the code should be:

Code: Select all

 
public $cookie_domain = '';
public $cookie_path = '';

rather than the incorrect Code (as you apparently have it although it could be a typo/mistake in your post(?).

Code: Select all

 
public $cookie_domain = "";
public $cookie_path = ""; 

Please try the correct one above and see if it makes the difference.

[rido21]

I had a similar problem, but the difference was that I got a 404 error.
I disabled opcache parameter on php settings (from cpanel) and all work great again!