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
____________________________________

eZ debug

Timing:	Jan 19 2025 07:26:17
Script start
Timing:	Jan 19 2025 07:26:17
Module start 'layout'
Timing:	Jan 19 2025 07:26:17
Module start 'content'
Timing:	Jan 19 2025 07:26:18
Module end 'content'
Timing:	Jan 19 2025 07:26:18
Script end

Main resources:

Total runtime	1.1794 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0056	589.1484	152.6250
Module start 'layout'	0.0056	0.0039	741.7734	39.4453
Module start 'content'	0.0095	1.1684	781.2188	524.5156
Module end 'content'	1.1779	0.0015	1,305.7344	8.3203
Script end	1.1794		1,314.0547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.2895	16	0.0002
Check MTime	0.0014	0.1162	16	0.0001
Mysql Total
Database connection	0.0008	0.0641	1	0.0008
Mysqli_queries	1.1321	95.9884	54	0.0210
Looping result	0.0006	0.0479	52	0.0000
Template Total	1.1428	96.9	2	0.5714
Template load	0.0024	0.2003	2	0.0012
Template processing	1.1405	96.6953	2	0.5702
Template load and register function	0.0002	0.0204	1	0.0002
states
state_id_array	0.0016	0.1385	1	0.0016
state_identifier_array	0.0022	0.1907	2	0.0011
Override
Cache load	0.0017	0.1483	22	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0465	2	0.0003
Fetch class attribute name	0.0009	0.0727	3	0.0003
XML
Image XML parsing	0.0007	0.0594	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0007	3	0.0000
General
dbfile	0.0009	0.0769	16	0.0001
String conversion	0.0000	0.0008	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 9 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs