Forums / Setup & design / Admin login problem

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.