Forums / General / Cannot login with admin user

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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
____________________________________