Drupal 'Access Denied' on all pages

By Sean McKeon, Web Developer, April 10, 2009

Ran into an interesting little snag this morning - a client's Drupal site was spitting out "Access Denied" errors for all page loads by anonymous users. It didn't appear to be a permissions problem - the nodes just wouldn't let anyone look at them.

A bit of Googling found a bunch of posts like this that say that, for some mysterious reason, Drupal can lose the contents of the node_access table and you need to repopulate them.

INSERT  INTO  node_access
  (nid ,gid ,realm ,grant_view, grant_update , grant_delete)
  VALUES ( '0',  '0',  'all',  '1',  '0',  '0')

Unfortunately, I didn't exactly have access to the client's database. A bit of poking around in the source showed me that visiting /admin/content/node-settings/rebuild would fire off an internal process to do the same thing.

Crisis averted, fix discovered. I just hope I don't need to use it again in the future.

Filed under:

drupal

Comments

JBB

Thu, 06/04/2009 - 15:31

Thanks for this! After

Thanks for this! After unsuccessfully trying multiple other fixes, this was the one that saved our site!

Much appreciated.

Anonymous

Fri, 06/12/2009 - 08:20

Awesome! Thank you. Yet

Awesome! Thank you. Yet another entry into my massive little Drupal quirks file. I really start to wonder at times how much time I'm saving with Drupal when you take into account the hours scouring the interweb to try and find solutions to its... features. Yawn.

vmu

Fri, 09/18/2009 - 13:11

Many thanks. It solved time

Many thanks. It solved time of frustration.

zeno

Sat, 10/10/2009 - 16:17

Thank you Dude...! I am just

Thank you Dude...! I am just angry I didn't find you 6hours earlier....I lost that hours, but finally I google you and fixed it in 2minutes.... You are a MAN ! Zeno

VladRM

Tue, 11/10/2009 - 11:18

Thank you!

webalchemist

Fri, 01/01/2010 - 05:01

Thank you so much this made

Thank you so much this made my day! Worked great for me in 30 seconds or less! Drupal 5.21

Webalchemist

Conscious Web Solutions
http://www.consciouswebsolutions.com

Rafael

Wed, 01/06/2010 - 05:25

Simply perfect! God bless you

Simply perfect!

God bless you my friend!
Thank you.

Zak Greant

Thu, 01/07/2010 - 21:31

Thanks. We've been wrestling

Thanks. We've been wrestling with intermittent permissions issues for a few weeks now (and rebuilding permissions would lead to all anonymous users being denied access to all pages). This fixed it. I hope it sticks. :)

shekhar

Wed, 01/20/2010 - 02:26

hey you just saved me from a

hey you just saved me from a loss. Today morning i ran into similar problem. Thank god your solution was there to save me. You are just an angel to me.

Nancy

Fri, 05/07/2010 - 19:00

Thank you thank you thank

Thank you thank you thank you....I nearly cried before I found this post.

Elhu

Thu, 05/20/2010 - 13:10

Thank you so much, I think I

Thank you so much, I think I just fell in love with you xD!

Larry

Fri, 09/10/2010 - 19:51

Worked Like a Charm

I implemented your solution by visiting /admin/content/node-settings/rebuild as you suggested. The result, which took about five seconds, repopulated the contents of the node_access table.

Tim

Sun, 10/10/2010 - 01:17

Thank you, thank you, thank

Thank you, thank you, thank you, thank you, thank you..... You get the point.

Mon, 03/07/2011 - 05:45

Thanks

Thank you for solution. Helped ALOT. Now I can soon go to sleep :]

guillaume

Sun, 10/09/2011 - 17:02

Thank you so much, this

Thank you so much, this solved my problem.
If you had a paypal donation button, I would have paid you a beer.
Thanks mate

dave

Tue, 03/20/2012 - 08:31

thanx for this post, you

thanx for this post, you saved my life, btw for me it happend when the quota of database was exeeded

Ryan Bayona

Fri, 03/23/2012 - 13:08

Many thanks!

I did this after pulling my hair out for several ! Thanks a lot!

Chris Smith

Wed, 05/23/2012 - 09:43

Thank you SO much for posting

Thank you SO much for posting this solution..... you saved our skin! So happy now. :)

Ben W

Tue, 10/30/2012 - 19:23

Thanks a bunch!

I ran into this exact issue and got everything working again thanks to your assistance!

John

Tue, 04/09/2013 - 13:39

Success!

Thx! Saved the day!

mattheoh

Mon, 04/15/2013 - 15:39

Perfect !

Was searching for a day... I lost my contents after using cache....
Didn't see thois ioption in the back office.
your tips solved everything.
just a word, thanks a lot.

Tomas

Thu, 07/17/2014 - 10:34

My Hero!!

Like all before me, a GIANT THANK YOU, You saved my day from becoming shitty with this strange darn issue. I already saw the hours that I'm going to spend on this, but now I'm not, thanks to you! :)

Elegant and quick solution!