Cannot login with admin user
Cannot login with admin user
Thursday 23 June 2005 12:57:53 pm - 1 reply
I can't login to the admin of an ez installation (in production) .
i tried to backup the mysql db to work locally but i got this error:
mysqldump: Can't get CREATE TABLE for table `ezsession` (Can't open file: 'ezsession.MYI'. (errno: 145))
It seems the ezsession table was damaged at file system level.
The only backup availables were lost because the server hard disk was defective.
i made a backup of the other tables except for ezsession and recreated all the db.
then i've created an empty ezsession table from another installation of the same version.
then i tried login but it says :
can't login, you need a valid username and password to login.
i tried different users, the only one i could login is a user with no admin permission.
any suggestion would be appreciated.
thx in advance ?
Thursday 23 June 2005 2:10:33 pm
Hi,
it looks like more than just the single table was damaged in your db.
You can get admin-rights back by forcing access to the role module, login with the user you still can and the accessing /index.php/SITEACCESS/role/list. There you can choose the role your user uses and add the role * * * rights. This will give you back the admin rights. Before you can do this you need to add this to your /settings/override/site.ini:
[RoleSettings] PolicyOmitList[]=role
Hope this helps and you get at least anything back from your database. To avoid data lost in future, I suggest a backup-soltuion like bacula ( http://www.bacula.org ) and a redudant storage of your produktive database.
Modified on Thursday 23 June 2005 2:11:53 pm by Daniel Beyer
You must be logged in to post messages in this topic!