I took my drupal site off-line and now cannot reach the site-maintenance page to bring it back on-line.
When I go to

mysite.com/admin/settings/site-maintenance

I see the "operating in offline mode"

and below a message

"There are security updates available for one or more of your modules or themes..." I would appreciate anyone's assistance as my site has been off-line for a few days and I cant seem to understand what the issue is.

Comments

vm’s picture

this post belongs in the post installation forum. Please edit the opening post and move it. Thanks.

MurrMo’s picture

Post Moved thanks for the heads up mate

vm’s picture

make sure you are logged in to the site first, yoursite.com/?q=user/login

MurrMo’s picture

yes i am logged in, and still cannot reach the site-maintenance page. As well, when i select some of the admin menus it says "you do not have any administrative items"

vm’s picture

are you sure you are logged in as user 1?

else you will have to do this manually in the db in the variables table by settings the row site_offline to a status of 0.

back up the DB first.

MurrMo’s picture

I am user 3, but do have administrative access.

vm’s picture

evidently not enough administration access. Log in as UID 1 and test.

MurrMo’s picture

I appreciate your assistance. But is there a way to retrieve UID 1 login info? We could continue this convo on skype?

vm’s picture

from the user table of the database. may need to alter the email address, note the username and request a new password as the password in the DB is salted.

MurrMo’s picture

I got into the Database, Altered the email, and noted the USER, but how do I reset User1 password?
*at mysite.com/user when I click "request new password" it takes me to the "Site Off-Line" Page.*

vm’s picture

makes sense totally forgot about the site being offline. see: http://drupal.org/node/1023428 for resetting admin password

MurrMo’s picture

Ive successfully attained UID login info, I am logged in as UID 1 but still cannot reach mysite.com/admin/settings/site-maintenance.
The "Site Configuration" page just pops up and displays the same page with the following message:

"Operating in off-line mode." <--- clicking this just refreshes page*
"There are security updates available for one or more of your modules or themes. To ensure the security of your server, you should update immediately! See the available updates page for more information."

Actions
.....
ImageAPI
.....
JStats
Logging and alerts
......

vm’s picture

edit settings.php are you forcing the site offline through a conf setting?

http://drupal.org/node/264476

MurrMo’s picture

thank you for your continued help, I managed to get into the database and set site_offline to s:1'0' but don't understand what it means to "drop row variables in 'cache' table" could you please explain how I can do that or if it is even necessary ?

vm’s picture

clear the cache, it will regenerate