cant log in after upgrade to 2011.4

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

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

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

Thursday 19 May 2011 1:18:05 am

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

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