cant log in after upgrade to 2011.4

Author Message

Erland Flaten

Wednesday 18 May 2011 10:44:22 am

I have done an upgrade from 4.1.3 to 2011.4 

When I try to login on siteadmin on www.fabrikken.no/siteadmin/ the admin password, and other user/passwords doesent work anymore.

How can this be solved? I have the database backed up in 4.1.3 version so I guess I could start all over, but I am pretty shure I run all the sql's

Is there a way to check if a database is correctly upgraded?

The database has now 118 tables. The php extension is mysql and not mysqli. Is that a problem?

Erland Flaten
Lilllehammer, Norway

Damien Pobel

Wednesday 18 May 2011 11:31:46 am

Hi,

you should probably try to enable the DebugOutput, it should contain some useful tips on what is going wrong.

Cheers

Damien
Planet eZ Publish.fr : http://www.planet-ezpublish.fr
Certification : http://auth.ez.no/certification/verify/372448
Publications about eZ Publish : http://pwet.fr/tags/keywords/weblog/ez_publish

Erland Flaten

Wednesday 18 May 2011 12:36:26 pm

Thanks :)

Here is sqldebug on the loginpage after I flushed the cache and loged in with the admin account and right password.

&nbsp;<table title="Table for actual debug output, shows notices, warnings and errors."><tr><td class="debugheader"><strong><span>Timing:</span></strong></td><td class="debugheader">May 18 2011 21:22:28</td></tr><tr><td colspan="2">

Script start

Warning: PHP: E_WARNING

May 18 2011 21:22:28

session_start(): open(/home/sites/ezfabrikke.ezpublish15.no.ezdeal.no/tmp/sess_vb0tgjcr3i3v49c7kaobls08b9sg704o, O_RDWR) failed: No such file or directory (2) in /home/sites/ezfabrikke.ezpublish15.no.ezdeal.no/www/lib/ezsession/classes/ezsession.php on line 361

Debug: eZMySQLDB::query(0.000 ms) query number per page:0

May 18 2011 21:22:28

SET NAMES 'utf8'

Notice: eZMySQLDB::query(0 rows, 0.252 ms) query number per page:1

May 18 2011 21:22:28

SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.action AS e1_action, e1.alias_redirects AS e1_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1 WHERE e0.parent = 0 AND (e0.lang_mask & 7 > 0) AND e0.text_md5 =  MD5( 'setup' )  AND e1.parent = e0.link AND (e1.lang_mask & 7 > 0) AND e1.text_md5 =  MD5( 'settingstoolbar' ) LIMIT 0, 1

Timing:

May 18 2011 21:22:28

Module start 'user'

Notice: eZMySQLDB::query(1 rows, 1.466 ms) query number per page:2

May 18 2011 21:22:28

SELECT contentobject_id, login, email, password_hash, password_hash_type                    FROM   ezuser WHERE  contentobject_id='10'

Notice: eZMySQLDB::query(1 rows, 1.064 ms) query number per page:3

May 18 2011 21:22:28

SELECT  c.contentobject_id as id,c.path_string                                        FROM ezcontentobject_tree  b,                                             ezcontentobject_tree  c                                        WHERE b.contentobject_id='10' AND                                              b.parent_node_id = c.node_id                                        ORDER BY c.contentobject_id

Notice: eZMySQLDB::query(1 rows, 0.064 ms) query number per page:4

May 18 2011 21:22:28

SELECT c.contentobject_id as id                                            FROM ezcontentobject_tree  c,                                                 ezcontentobject d                                            WHERE c.node_id in ( 5 ) AND                                                  d.id = c.contentobject_id                                            ORDER BY c.contentobject_id

Notice: eZMySQLDB::query(1 rows, 1.940 ms) query number per page:5

May 18 2011 21:22:28

SELECT DISTINCT ezrole.id AS id                  FROM ezrole,                       ezuser_role                  WHERE ezuser_role.contentobject_id IN ( 42, 4, 10 ) AND                        ezuser_role.role_id = ezrole.id ORDER BY ezrole.id

Notice: eZMySQLDB::query(1 rows, 0.105 ms) query number per page:6

May 18 2011 21:22:28

SELECT  c.contentobject_id as id,c.path_string                                        FROM ezcontentobject_tree  b,                                             ezcontentobject_tree  c                                        WHERE b.contentobject_id='10' AND                                              b.parent_node_id = c.node_id                                        ORDER BY c.contentobject_id

Notice: eZMySQLDB::query(1 rows, 0.071 ms) query number per page:7

May 18 2011 21:22:28

SELECT c.contentobject_id as id                                            FROM ezcontentobject_tree  c,                                                 ezcontentobject d                                            WHERE c.node_id in ( 5 ) AND                                                  d.id = c.contentobject_id                                            ORDER BY c.contentobject_id

Notice: eZMySQLDB::query(1 rows, 0.754 ms) query number per page:8

May 18 2011 21:22:28

SELECT DISTINCT limit_identifier, limit_value                                              FROM ezuser_role                                              WHERE contentobject_id IN ( 42, 4, 10 )

Notice: eZMySQLDB::query(1 rows, 0.064 ms) query number per page:9

May 18 2011 21:22:28

SELECT  c.contentobject_id as id,c.path_string                                        FROM ezcontentobject_tree  b,                                             ezcontentobject_tree  c                                        WHERE b.contentobject_id='10' AND                                              b.parent_node_id = c.node_id                                        ORDER BY c.contentobject_id

Notice: eZMySQLDB::query(1 rows, 0.140 ms) query number per page:10

May 18 2011 21:22:28

SELECT c.contentobject_id as id                                            FROM ezcontentobject_tree  c,                                                 ezcontentobject d                                            WHERE c.node_id in ( 5 ) AND                                                  d.id = c.contentobject_id                                            ORDER BY c.contentobject_id

Notice: eZMySQLDB::query(1 rows, 1.661 ms) query number per page:11

May 18 2011 21:22:28

SELECT DISTINCT ezrole.id,                                      ezrole.name,                                      ezuser_role.limit_identifier,                                      ezuser_role.limit_value,                                      ezuser_role.id as user_role_id                      FROM ezrole,                           ezuser_role                      WHERE ezuser_role.contentobject_id IN ( 42, 4, 10 ) AND                            ezuser_role.role_id = ezrole.id

Notice: eZMySQLDB::query(6 rows, 0.244 ms) query number per page:12

May 18 2011 21:22:28

SELECT id, role_id, module_name, function_name, original_id                    FROM   ezpolicy WHERE  role_id='1' AND original_id='0' ORDER BY module_name ASC, function_name ASC

Notice: eZMySQLDB::query(1 rows, 0.075 ms) query number per page:13

May 18 2011 21:22:28

SELECT id, policy_id, identifier                    FROM   ezpolicy_limitation WHERE  policy_id='772' ORDER BY id ASC

Notice: eZMySQLDB::query(1 rows, 0.278 ms) query number per page:14

May 18 2011 21:22:28

SELECT id, limitation_id, value                    FROM   ezpolicy_limitation_value WHERE  limitation_id='851' ORDER BY value ASC

Notice: eZMySQLDB::query(1 rows, 0.060 ms) query number per page:15

May 18 2011 21:22:28

SELECT id, policy_id, identifier                    FROM   ezpolicy_limitation WHERE  policy_id='771' ORDER BY id ASC

Notice: eZMySQLDB::query(1 rows, 0.051 ms) query number per page:16

May 18 2011 21:22:28

SELECT id, limitation_id, value                    FROM   ezpolicy_limitation_value WHERE  limitation_id='850' ORDER BY value ASC

Notice: eZMySQLDB::query(2 rows, 0.046 ms) query number per page:17

May 18 2011 21:22:28

SELECT id, policy_id, identifier                    FROM   ezpolicy_limitation WHERE  policy_id='776' ORDER BY id ASC

Notice: eZMySQLDB::query(6 rows, 0.047 ms) query number per page:18

May 18 2011 21:22:28

SELECT id, limitation_id, value                    FROM   ezpolicy_limitation_value WHERE  limitation_id='854' ORDER BY value ASC

Notice: eZMySQLDB::query(1 rows, 0.047 ms) query number per page:19

May 18 2011 21:22:28

SELECT id, limitation_id, value                    FROM   ezpolicy_limitation_value WHERE  limitation_id='855' ORDER BY value ASC

Notice: eZMySQLDB::query(0 rows, 0.047 ms) query number per page:20

May 18 2011 21:22:28

SELECT id, policy_id, identifier                    FROM   ezpolicy_limitation WHERE  policy_id='773' ORDER BY id ASC

Notice: eZMySQLDB::query(1 rows, 0.051 ms) query number per page:21

Erland Flaten
Lilllehammer, Norway

Erland Flaten

Wednesday 18 May 2011 1:29:18 pm

If I use a wrong password I get warning that the password is indeed wrong or the username is wrong. There is also another sql debug statment 

&nbsp;<table title="Table for actual debug output, shows notices, warnings and errors."><tr><td class="debugheader"><strong><span>Notice:</span>&nbsp;eZMySQLDB::query(1 rows, 3.592 ms) query number per page:2</strong></td><td class="debugheader">May 18 2011 22:18:33</td></tr><tr><td colspan="2">

SELECT contentobject_id, password_hash, password_hash_type, email, login                      FROM ezuser, ezcontentobject                      WHERE ( login='admin' ) AND                        ezcontentobject.status='1' AND                        ezcontentobject.id=contentobject_id AND                        ( ( password_hash_type!=4 ) OR                          ( password_hash_type=4 AND                              ( login='admin' ) AND                          password_hash=PASSWORD('thewrongpasswordwashere') ) )

Notice: eZMySQLDB::query(1 rows, 0.057 ms) query number per page:3

May 18 2011 22:18:33

SELECT contentobject_id, login, email, password_hash, password_hash_type                    FROM   ezuser WHERE  contentobject_id='14'

Erland Flaten
Lilllehammer, Norway

Damien Pobel

Thursday 19 May 2011 12:31:53 am

Hi,

at the very beginning of the debug output, you have the following warning :

session_start(): open(/home/sites/ezfabrikke.ezpublish15.no.ezdeal.no/tmp/sess_vb0tgjcr3i3v49c7kaobls08b9sg704o, O_RDWR) failed: No such file or directory (2) in /home/sites/ezfabrikke.ezpublish15.no.ezdeal.no/www/lib/ezsession/classes/ezsession.php on line 361

it seems that PHP is unable to store the files created for the session. It's probably a permission issue on the file system. You have to allow the user used to run the web server to write in the /home/sites/ezfabrikke.ezpublish15.no.ezdeal.no/tmp/

Cheers

Damien
Planet eZ Publish.fr : http://www.planet-ezpublish.fr
Certification : http://auth.ez.no/certification/verify/372448
Publications about eZ Publish : http://pwet.fr/tags/keywords/weblog/ez_publish

Erland Flaten

Thursday 19 May 2011 12:52:16 am

Looks like the loginpage doesent move on to the right stuff after it gets the right username and password. The debug for this is my second post. The long one.

When incorrect user or password are entred the correct errormessage are displayed. The debug for that is in the second one. 

Any tips on what to do? 

My websiteinterface is version 1.4 Maybe thats a problem? ( But hold on, you cant upgrade webin without login)

Erland Flaten
Lilllehammer, Norway

Erland Flaten

Thursday 19 May 2011 1:18:05 am

"

Hi,

at the very beginning of the debug output, you have the following warning :

session_start(): open(/home/sites/ezfabrikke.ezpublish15.no.ezdeal.no/tmp/sess_vb0tgjcr3i3v49c7kaobls08b9sg704o, O_RDWR) failed: No such file or directory (2) in /home/sites/ezfabrikke.ezpublish15.no.ezdeal.no/www/lib/ezsession/classes/ezsession.php on line 361

it seems that PHP is unable to store the files created for the session. It's probably a permission issue on the file system. You have to allow the user used to run the web server to write in the /home/sites/ezfabrikke.ezpublish15.no.ezdeal.no/tmp/

Cheers

"

I am going to ask webdeal about that. When I look in the directory with the upgraded site there is no tmp-folder now. I will make the folder.  Many thanks for helping with this :)

Erland Flaten
Lilllehammer, Norway

Erland Flaten

Thursday 19 May 2011 2:43:32 am

I have now put the folder "tmp" in the folder where both the new and old ez-root folder are. Then I had to set permission 777 on the tmp folder to make it work. I have now the new admin page up.

I will contiue the upgrade steps for webin. 

Erland Flaten
Lilllehammer, Norway

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.