Admin login problem

Author Message

laurent le cadet

Monday 10 July 2006 10:06:26 am

Hi,

I removed the var directory to make a massive clear cache.
I cannot connect anymore to admin.
I have the standard message when I try a false pass+ID (qdsds +qdqdadadada), normal.
With my admin ID+pass I stay on the login page with no error message. Noway to go further even with i.e .../content/view/full/2

Any idea ?

Laurent

Tim Dickinson

Monday 10 July 2006 3:49:03 pm

Any chance you have the var/storage directort backked up somewhere?
I don't know if it is critical, but that directory doesn't store cache files and looking inside mine, there appears to be some important looking files. They are in

/ var / storage / packages / ez_systems /

Sorry I can't be more help,

Tim

http://www.AdBalance.com - Ad network news and reviews
http://www.DevPublisher.com - Website publisher guides, tools and news
http://www.AudioMelody.com - Make better music

Łukasz Serwatka

Monday 10 July 2006 11:14:18 pm

Hi Laurent

Take a look at this topic, perhaps you will find it useful
http://ez.no/community/forum/general/help_needed_cannot_log_in_to_admin_siteaccess_anymore

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

laurent le cadet

Monday 10 July 2006 11:44:04 pm

Hi,

Yes, I have a backup of the original var dir but I don't know which file is concern.
Lukasz, I tryied your sql queries but no effect. Still stuck on login pagelayout...help...

Laurent

Łukasz Serwatka

Tuesday 11 July 2006 12:11:41 am

Laurent, do you have any errors in debug output? If you want to clear the cache manually you need to remove only files/dirs from var/cache/* and var/(site)/cache/*

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

laurent le cadet

Tuesday 11 July 2006 12:24:00 am

Lukasz,

Debug output :

Query error: Can't open file: 'ezsession.MYD'. (errno: 145). Query: SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='996375942d7ffb4daf6b3f171ac638e0'

laurent le cadet

Tuesday 11 July 2006 12:26:04 am

About the cache directories if I understand only the "log" dir must be perserved (?).

Łukasz Serwatka

Tuesday 11 July 2006 12:27:32 am

ezsession table is corrupted. You need to either repair it or drop it and restore from your distro SQL shema.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

laurent le cadet

Tuesday 11 July 2006 12:32:16 am

yes, I confirm via phpMyAdmin :

Erreur

requête SQL :

SHOW KEYS FROM `ezsession`

MySQL a répondu:

#1016 - Can't open file: 'ezsession.MYD'. (errno: 145) .

Can I repair it with PhpMyAdmin ?

Łukasz Serwatka

Tuesday 11 July 2006 12:39:51 am

Yes, your table type is MyISAM then you can run

REPAIR TABLE `ezsession`

or from shell

myisamchk --recover ezsession

If this will not help, then drop it and re-create it. Should work fine.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

laurent le cadet

Tuesday 11 July 2006 12:46:42 am

yeeeeeeeeeeeeeeHaaaaaa !

At this point (as you see ;) I entered admin.

Many MANY thks Lukasz

Łukasz Serwatka

Tuesday 11 July 2006 12:52:15 am

Hahah, cool ;) You are welcome ;)

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

laurent le cadet

Wednesday 12 July 2006 8:24:10 am

Hi again,

I have yet a similar problem with another site :(
I turn on the debug output but there is no particular warning.
In phpMyAdmin the table ezsession doesn't seems to be corrupted at first.
But there is thousands of lines in it and I can print out them up to a certain page.
Then I have this message :

Erreur

requête SQL:

SELECT *
FROM `ezsession`
LIMIT 1110 , 30

MySQL a répondu:

#1030 - Got error 127 from table handler

What's going on this time ?

Should I run REPAIR TABLE `ezsession` too ?

Laurent

laurent le cadet

Wednesday 12 July 2006 9:25:01 am

That's what I've done, the magic REPAIR TABLE `ezsession`.

Everythings OK.

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 18:38:08
Script start
Timing: Jan 18 2025 18:38:08
Module start 'layout'
Timing: Jan 18 2025 18:38:08
Module start 'content'
Timing: Jan 18 2025 18:38:10
Module end 'content'
Timing: Jan 18 2025 18:38:10
Script end

Main resources:

Total runtime1.7466 sec
Peak memory usage4,096.0000 KB
Database Queries92

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0075 587.9063152.6250
Module start 'layout' 0.00750.0063 740.531339.4453
Module start 'content' 0.01381.7314 779.9766719.5156
Module end 'content' 1.74510.0014 1,499.492228.1719
Script end 1.7465  1,527.6641 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00600.3445160.0004
Check MTime0.00200.1141160.0001
Mysql Total
Database connection0.00140.082610.0014
Mysqli_queries1.633793.5352920.0178
Looping result0.00180.1014900.0000
Template Total1.696397.120.8482
Template load0.00430.247220.0022
Template processing1.692096.875620.8460
Template load and register function0.00010.006010.0001
states
state_id_array0.00110.062910.0011
state_identifier_array0.00120.067620.0006
Override
Cache load0.00420.2405890.0000
Sytem overhead
Fetch class attribute can translate value0.00070.038930.0002
Fetch class attribute name0.00120.0661170.0001
XML
Image XML parsing0.00160.094230.0005
class_abstraction
Instantiating content class attribute0.00010.0035280.0000
General
dbfile0.00130.0725300.0000
String conversion0.00000.000840.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
14content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
14content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
21content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
6content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 59
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs