By stathisx on

i set my site status to offline....but when i type in browser http://sitename.com/?q=my_login_name i get the same page (site offline)...what should i do to administer my site again?

[moved to support]

⋅ Categories: Drupal 4.7.x

Comments

anner’s picture

anner commented

http://sitename.com/?q=user should take you to a login screen. If you login as the admin user, you should be able to bring the site back online.

stathisx’s picture

stathisx commented

thats what i do and i get the site offline again....is there any other way to do so?it should work....i don't know why it does so..

anner’s picture

anner commented

not my_login_name...the actual word user. That link doesn't give you a login?

glofalcon’s picture

glofalcon commented

I took the site offline temporarily using the site offline option and was shocked to see that I could not access my login page again. This saved me a lot of trouble. I replaced initially with the user name but then realized the mistake.

so, just replace the site name in http://sitename.com/?q=user not the user.

Thanks a lot to anner.

Michael M’s picture

Michael M commented

The problem seems to be that you logged out after you set the site to offline. Once you log out, drupal doesn't know you are the admin and will treat you as an anonymous user. I am not too familiar with 4.7, but, I believe that you might have to go and change this setting in the database.

----
http://PointHomes.com

heine’s picture

heine commented

The url ?q=user should give access to the login page just fine.
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.

sepeck’s picture

sepeck commented

How to login once you have turned your site off-line

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

hsans’s picture

hsans commented

I had the same situation. but I used http://sitename.com/?q=user and I get to log back to my site.

chad smith’s picture

chad smith commented

Yep, I currently have the same issue. I type in http://sitename.com/?q=user but it just keeps giving me the Offline screen. I can't get to the login form.

Ed: Sorry this was supposed to be in reply to stathisx's comment above.

omid_sakhi’s picture

omid_sakhi commented

I had the same problem. In http://sitename.com/?q=user do not put your user name instead of user for example :

your site name is xyz and your administrator user name is admin, then write :

http://xyz.com/?q=user

as you see the "user" is a phrase and is not a variable to be changed by your username.

rovera’s picture

rovera commented

You need connect to your database to bring site online ....

mysql --user my_db_user --password=my_password my_drupal_db << EOF

or

su postgres

psql my_drupal_db

And execute this SQL command

UPDATE variable SET value='s:1:"0";' WHERE name = 'site_offline';
DELETE FROM cache WHERE CID = 'variables';
EOF

chad smith’s picture

chad smith commented

I should probably update why this wasn't working for me. I finally remembered that I am using a masked domain, and when I used the actual domain it worked 8^P

hansneha’s picture

hansneha commented

Hi,

I am facing the same problem. I donot see the login page after using the URL with q=user. Also Im not able to find an entry in the DB with name=site_offline in variable table.

I am using a subdomain currently.
Please let me know what u did so that it worked on the main domain?

Carus’s picture

Carus commented

ive used
www.mysitename.com/user to get it when its in offiline mode, with safe urls enabled, but the q=user should work souldnt it?

hansneha’s picture

hansneha commented

No its not working. Is there any other way to do it.

Also I cannot find the name = 'site_offline' in variable table. So I am not able to get it online from DB too.

heine’s picture

heine commented

Did you set your site offline? You'll also get an offline page when the database is down / not accessable. The page should contain an error messsage though.

If you did set your site offline, delete cookies then try again. From How to log in once you have turned your site off-line for maintenance:

If you attempted to log in with a username that does not have the "administer site configuration" permission you will be stuck in that user account until you clear the browser's cookies. Simply instruct your browser to delete cookies for the site and visit the referenced URL above again. You can also use another browser to access the URL.

hansneha’s picture

hansneha commented

Hi,

No, I didnt set my site to offline mode. Suddenly, it started giving this message.
I get the following message,

"Site off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding."

I am not sure what is going wrong with it.

Seneschall’s picture

Seneschall commented

Check to make sure your database is running. I've gotten that message before when the server the database is on isn't responding. Check your host providers or perhaps try to login to your db (phpmyadmin maybe).

hansneha’s picture

hansneha commented

Hi,

I checked the DB. Tried to run some select queries and they were working. So i thin kthe DB is working. Am I missing something? is there something else I can check?