admin user gone after update

Author Message

Marko Žmak

Sunday 08 January 2006 5:07:25 am

I've updated my eZ installatin from 3.5 to 3.7.2. After update I couldn't log in as admin. I looked into the databae and found out that the admin user was missing in the ezuser table. What happened? How do I fix it?

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

Brian Gambill

Sunday 08 January 2006 1:55:45 pm

I had a the same problem going from 3.5 to 3.6.4. If I remember correctly I lost the admin user with the upgrade to 3.5.2. One method I have sen recently to correct this is create a new user with publish (or whatever you password is). Dig into the database and manually create one their using that encrypted password. The 'Admin' user is user 14. Also be sure to create a entry in ezuser_setting to show user 14 as enabled ('1').

BTW, I also lost my anonymous user and <b>all</b> of my links.

Kåre Køhler Høvik

Sunday 08 January 2006 2:19:47 pm

Do you know where in the upgrade procedure this happend ?

Kåre Høvik

Brian Gambill

Sunday 08 January 2006 2:49:54 pm

Like I said< Ibelieve I lost them in the upgrade from 3.5.0 to 3.5.2, a necessary step according to the 3.6.0 docs. What was unclear was which upgrade scripts were required to be run. I ran them all and Lost all URLs and admin and anonymous user. No other users were lost as far as I can tell.

Kåre Køhler Høvik

Sunday 08 January 2006 3:00:55 pm

Thanks. We'll take a look at what could have gone wrong here.

Kåre Høvik

Marko Žmak

Sunday 08 January 2006 4:30:31 pm

I lost only the admin user, not the anonymous. I also ran all the update scripts, but I don't know after which one the problrm occured.

And yes, inserting apropriate records into ezuser and azuser_setting did the trick. I figure it out by myself, but thanks for the tip anyway.

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

john polo

Monday 09 January 2006 11:09:43 pm

can you tell us that what exactly you changed in those tables ? I lost all of my users except anon...

i dont know whats going on with this

Marko Žmak

Tuesday 10 January 2006 12:02:39 am

I did a backup of my database before upgrading so I just inserted the records from the backup into these tables:

ezuser
ezuser_setting

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

john polo

Tuesday 10 January 2006 12:18:36 am

yes thanks...i did my backup before too..thanks god

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