Cannot login with admin user

Previous topic

General

Next topic

Author	Message
Massimiliano Rossi	Thursday 23 June 2005 3:57:53 am 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 ?
Daniel Beyer	Thursday 23 June 2005 5:10:33 am 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. Daniel Beyer _________________________________ YMC AG Kreuzlingen, Switzerland web: www.ymc.ch ____________________________________

Author

Message

Massimiliano Rossi

Thursday 23 June 2005 3:57:53 am

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 ?

Daniel Beyer

Thursday 23 June 2005 5:10:33 am

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.

Daniel Beyer
_________________________________
YMC AG
Kreuzlingen, Switzerland
web: www.ymc.ch
____________________________________