Cannot login

Previous topic

Next topic

Author	Message
Massimiliano Rossi	Thursday 23 June 2005 3:57:18 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 ?

Author

Message

Thursday 23 June 2005 3:57:18 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 ?

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0068	589.0234	152.6094
Module start 'layout'	0.0068	0.0036	741.6328	39.3984
Module start 'content'	0.0104	0.6708	781.0313	399.2813
Module end 'content'	0.6811	0.0016	1,180.3125	8.2031
Script end	0.6827		1,188.5156

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.4821	16	0.0002
Check MTime	0.0014	0.2021	16	0.0001
Mysql Total
Database connection	0.0010	0.1400	1	0.0010
Mysqli_queries	0.6414	93.9482	46	0.0139
Looping result	0.0005	0.0713	44	0.0000
Template Total	0.6439	94.3	2	0.3220
Template load	0.0020	0.2968	2	0.0010
Template processing	0.6419	94.0174	2	0.3209
Template load and register function	0.0003	0.0445	1	0.0003
states
state_id_array	0.0008	0.1137	1	0.0008
state_identifier_array	0.0021	0.3149	2	0.0011
Override
Cache load	0.0016	0.2405	15	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0014	0.2001	1	0.0014
Fetch class attribute name	0.0009	0.1315	1	0.0009
XML
Image XML parsing	0.0001	0.0182	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0012	1	0.0000
General
dbfile	0.0006	0.0925	10	0.0001
String conversion	0.0000	0.0018	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 4 Number of unique templates used: 4

Time used to render debug report: 0.0002 secs