Admin login returns to login page

Tuesday 12 October 2004 3:33:18 am

I have just installed my first ezp, and it seemed to be working fine. I installed 3.4.1 and followed the case-tutorial in "Building a site" from the documentation. Even this worked fine :)

I have purchased and installed the Online Editor. Fine.

But now I can't login to the admin interface. When I click login, it simply returns to the login page without any errors. If I use a bad username, I get an error.

As I don't quite have the full overview of ezp yet (!), I don't know where to start on this problem.

<b>Anyone</b> who can help me out? I will respond quickly here if you need more info...

:)

Tuesday 12 October 2004 4:09:34 am

Thanks for responding - here's the debug output from the blank login page I was looped back to. I've replace my root folder structure in this dump with ###EZ_ROOT_FOLDER_HERE###:

Warning: PHP Oct 12 2004 13:05:33
session_start(): Cannot send session cookie - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/lib/ezutils/classes/ezsession.php on line 223
Warning: PHP Oct 12 2004 13:05:33
session_start(): Cannot send session cache limiter - headers already sent (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/lib/ezutils/classes/ezsession.php on line 223
Warning: PHP Oct 12 2004 13:05:33
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 363
Warning: PHP Oct 12 2004 13:05:33
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 364
Warning: PHP Oct 12 2004 13:05:33
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 365
Warning: PHP Oct 12 2004 13:05:33
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 366
Warning: PHP Oct 12 2004 13:05:33
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 367
Warning: PHP Oct 12 2004 13:05:33
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 369
Warning: PHP Oct 12 2004 13:05:33
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 370
Timing: Oct 12 2004 13:05:33
Module start 'user'
Notice: Oct 12 2004 13:05:33
eZTemplate: Loading template "user/login.tpl" with resource "design"
Timing: Oct 12 2004 13:05:33
Module end 'user'
Notice: Oct 12 2004 13:05:33
eZTemplate: Loading template "loginpagelayout.tpl" with resource "design"

Tuesday 12 October 2004 4:21:12 am

Hmmm... silly me. What do you mean "replace the sources" and how do I get the sql output?

:) Morten

Tuesday 12 October 2004 4:57:11 am

I should have been more detailed...

Please get me the info from the redirect page after you tried to login.

[DebugSettings]
DebugOutput=enabled
DebugRedirection=enabled

[DatabaseSettings]
SQLOutput=enabled
---- text on that page----
Redirecting to /
[button]
--------------------------

Sorry...

Currently it seems like that the session cannot be persistent.
I think I can tell you with your next reply.

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Tuesday 12 October 2004 5:00:20 am

Here's the whole thing again, this time with DebugRedirect=enabled :)

eZ debug
Notice: eZMySQLDB::query(0 rows, 0.265 ms) query number per page:0 Oct 12 2004 13:58:49
SELECT data, user_id FROM ezsession WHERE session_key='878b6fb0e63f304328e7c32bbbe32963'
Warning: PHP Oct 12 2004 13:58:49
session_start(): Cannot send session cookie - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/lib/ezutils/classes/ezsession.php on line 223
Warning: PHP Oct 12 2004 13:58:49
session_start(): Cannot send session cache limiter - headers already sent (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/lib/ezutils/classes/ezsession.php on line 223
Warning: PHP Oct 12 2004 13:58:49
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 363
Warning: PHP Oct 12 2004 13:58:49
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 364
Warning: PHP Oct 12 2004 13:58:49
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 365
Warning: PHP Oct 12 2004 13:58:49
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 366
Warning: PHP Oct 12 2004 13:58:49
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 367
Warning: PHP Oct 12 2004 13:58:49
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 369
Warning: PHP Oct 12 2004 13:58:49
Cannot modify header information - headers already sent by (output started at /###EZ_ROOT_FOLDER_HERE###/index.php:2) in /###EZ_ROOT_FOLDER_HERE###/index.php on line 370
Timing: Oct 12 2004 13:58:49
Module start 'user'
Notice: Oct 12 2004 13:58:49
eZTemplate: Loading template "user/login.tpl" with resource "design"
Timing: Oct 12 2004 13:58:49
Module end 'user'
Notice: eZMySQLDB::query(1 rows, 0.339 ms) query number per page:1 Oct 12 2004 13:58:49
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser
WHERE contentobject_id='10'
Notice: Oct 12 2004 13:58:49
eZTemplate: Loading template "loginpagelayout.tpl" with resource "design"
Timing: Oct 12 2004 13:58:49
End

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory
Module start 'user' 0.0000 sec 0.4674 sec 0.0000KB 0.0000KB
Module end 'user' 0.4674 sec 0.0860 sec 0.0000KB 0.0000KB
End 0.5534 sec 0.0000KB 0.0000KB
Total runtime: 0.5537 sec

Time accumulators:
Accumulator Elapsed Percent Count Average
ini_load
Load cache 0.0314 sec 4.8979% 5 0.0063 sec
Mysql Total
Mysql_queries 0.0025 sec 0.3957% 2 0.0013 sec
Looping result 0.0001 sec 0.0120% 1 0.0001 sec
Template Total 0.1721 sec 26.9% 2 0.0860 sec
Template load 0.0971 sec 15.1686% 2 0.0486 sec
Template processing 0.0742 sec 11.5913% 2 0.0371 sec
override
Cache load 0.0405 sec 6.3307% 2 0.0203 sec
TS translator
TS init 0.0680 sec 10.6219% 1 0.0680 sec
TS cache load 0.0100 sec 1.5620% 1 0.0100 sec
TS context load 0.0086 sec 1.3427% 1 0.0086 sec
Total script time: 0.6404 sec

Tuesday 12 October 2004 5:16:23 am

You can just override everything
but make sure you run this sql queryies too

UPDATE ezsite_data SET value='3.4.2' WHERE name='ezpublish-version';
UPDATE ezsite_data SET value='9' WHERE name='ezpublish-release';

-- Fix typos in the indexes creation queries.
DROP   INDEX ezproductcollection_item_contentobject_id ON
             ezproductcollection_item;                 
CREATE INDEX ezproductcollection_item_contentobject_id ON
             ezproductcollection_item (contentobject_id);

DROP INDEX ezsubtree_notification_rule_id ON ezsubtree_notification_rule;

-- Fix faulty index on ezurl_object_link
ALTER TABLE ezurl_object_link DROP PRIMARY KEY;
CREATE INDEX ezurl_ol_url_id ON ezurl_object_link (url_id);
CREATE INDEX ezurl_ol_coa_id ON ezurl_object_link (contentobject_attribute_id);
CREATE INDEX ezurl_ol_coa_version ON ezurl_object_link (contentobject_attribute_version);

-- Fix bug in cache-block, ezsubtree_exipry
DELETE FROM ezsubtree_expiry;
ALTER TABLE ezsubtree_expiry CHANGE subtree subtree INT(11);

-- Create index for path_identification_string
CREATE INDEX ezcontentobject_tree_path_ident ON ezcontentobject_tree (path_identification_string(50));

Besides the last output it was not the output I meant. I need to output from the actual redirect page

Timing:  Oct 12 2004 14:11:07 
Module start 'user' 
Notice: eZMySQLDB::query(0 rows, 0.444 ms) query number per page:2 Oct 12 2004 14:11:07 
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM   ezuser
WHERE  contentobject_id='0' 
Notice: eZMySQLDB::query(1 rows, 0.732 ms) query number per page:3 Oct 12 2004 14:11:07 
SELECT contentobject_id, password_hash, password_hash_type, email, login
                      FROM ezuser, ezcontentobject
                      WHERE ( login='xrow' ) AND
                        ezcontentobject.status='1' AND
                        ezcontentobject.id=contentobject_id AND
                        ( ( password_hash_type!=4 ) OR
                          ( password_hash_type=4 AND ( login='xrow' ) AND password_hash=PASSWORD('donnottell') ) ) 
Notice: eZMySQLDB::query(1 rows, 0.483 ms) query number per page:4 Oct 12 2004 14:11:07 
SELECT user_id, is_enabled, max_login
FROM   ezuser_setting
WHERE  user_id='1209' 
Debug: userid Oct 12 2004 14:11:07 
1209 

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Tuesday 12 October 2004 6:29:13 am

Updating to 3.4.2 worked - thanks million for your help!!!

:) Morten