Andrew NugrohoThis is life, it's a test, it's a game…

Today i have error report form faculty site administrator in our university, he was reporting about error in login process, the error message is

"Access denied You are not authorized to access this page"

firstly i thought that he forgot about the password or somebody change the access content configuration under /admin/user/access and made some inappropriate access list. I am also try to login with my personal account on that Drupal stuff, unfortunately the result is same with admin. the error message still appear and we cannot access the administrator pages. I try to nonactive some moduls authorization (chaptcha, mollom) and update the database tables using default update script. The admin still cannot login.

I asking to google and found some articles related, the problem’s relatively same but the way to solve the problem is varies, patch the moduls, includes and update the databases. I found the good articles based on the last option in my list. this is the articles. i will write step by step that i am doing to activate the website again.

1. Login to cpanel system, with type http://your-site/cpanel
2. Choose the database menu, phpmyadmin, the system will call the default database management
3. I press on button MySql, and the next is we will repair our table session in drupal “REPAIR table drupal_sessions” (without quotes), change the table with your table name.
4. Go..to execute the sql command.
5. Check the result, please login with the username:password
6. It’s working for me

Thanks to Drupal community for  sharing knowledge and experience.

This entry was posted on Thursday, August 5th, 2010 at 10:02 pm and is filed under desain, web. You can follow any comments to this entry through the RSS 2.0 feed. You can leave a comment, or trackback from your own site.