Crazy login problem: my site won,t let anyone login or even create new users!
Hi,
My server runs php 4.4.4 and mysql 4.0.27...
I've had this problem coming and going on my machine since the last couple of weeks (it's 4.7.5 install) where I could not login with my admin account. Sometimes it worked with FF (2) and sometimes, I had to go to IE 6 to login.
Now as of today, I can't login on the site with FF or IE, and actually I can't create new accounts.
When I try to create a new account, it just redirects to the front page, without any 'email as been sent' message.
The welcome message is still sent, but the login link in the mail leads to an "access denied" page.
When I try to login, nothing happens really, it just stays the same and refreshes the home page.
I've done the following things as of now just to test and maybe try to help the community by identifying what could have happened:
1) I installed the test site on my localhost and the login does not work
2)I rolled back to a previous db version, from a couple of days when it still worked, and now it does not work at all on the local site and on the site on the server...so it's a maybe a browser issue?
3) I updated the current site with current database to 4.7.6 by updating the drupal files, still no login, on either ff or IE or Opera...as well..
I rolled back to a previous version and even with that previous db it won't login wither on the web server or the local setup.
Just to complete the test, I also upgraded the site to 4.7.6 on the local server and does not login. Ijust can't access the site anymore!
I cannot create new users as well, it won,t let me.
Any ideas what I could do?
-I tried clearing the cache
-clearing sessions table
-clearning cookies, cache from browsers, no success.
- installing opera, does not login
- adding drupal_page_footer();
$GLOBALS['tempUser'] = $user; no success
I will post here both my .htaccess and settings.php so you can maybe help locate the problem...
* Database URL format:
* $db_url = 'mysql://username:password@localhost/databasename';
* $db_url = 'mysqli://username:password@localhost/databasename';
* $db_url = 'pgsql://username:password@localhost/databasename';
*/
$db_url = 'mysql://dbname:pass@server/tablename';
$db_prefix = '';
/**
* Base URL (optional).
*
* If you are experiencing issues with different site domains,
* uncomment the Base URL statement below (remove the leading hash sign)
* and fill in the URL to your Drupal installation.
*
* You might also want to force users to use a given domain.
* See the .htaccess file for more information.
*
* Examples:
* $base_url = 'http://www.example.com';
* $base_url = 'http://www.example.com:8888';
* $base_url = 'http://www.example.com/drupal';
* $base_url = 'https://www.example.com:8888/drupal';
*
* It is not allowed to have a trailing slash; Drupal will add it
* for you.
*/
$base_url = 'http://www.geekmenow.com/geek2'; // NO trailing slash!
/**
* PHP settings:
*
* To see what PHP settings are possible, including whether they can
* be set at runtime (ie., when ini_set() occurs), read the PHP
* documentation at http://www.php.net/manual/en/ini.php#ini.list
* and take a look at the .htaccess file to see which non-runtime
* settings are used there. Settings defined here should not be
* duplicated there so as to avoid conflict issues.
*/
ini_set('arg_separator.output', '&');
ini_set('magic_quotes_runtime', 0);
ini_set('magic_quotes_sybase', 0);
ini_set('session.cache_expire', 200000);
ini_set('session.cache_limiter', 'none');
ini_set('session.cookie_lifetime', 2000000);
ini_set('session.gc_maxlifetime', 200000);
ini_set('session.save_handler', 'user');
ini_set('session.use_only_cookies', 1);
ini_set('session.use_trans_sid', 0);
ini_set('session.cookie_domain', 'geekmenow.com/geek2');
ini_set('session.auto_start', 0);
ini_set('url_rewriter.tags', '');
ini_set('register_long_arrays', 1);and here is the .htaccess:
#
# Apache/PHP/Drupal settings:
#
# Protect files and directories from prying eyes.
<FilesMatch "(\.(engine|inc|install|module|sh|.*sql|theme|tpl(\.php)?|xtmpl)|code-style\.pl|Entries.*|Repository|Root|Tag|Template)$">
Order deny,allow
Deny from all
</FilesMatch>
# Set some options.
Options -Indexes
Options +FollowSymLinks
# Customized error messages.
ErrorDocument 404 /index.php
# Set the default handler.
DirectoryIndex index.php
# Override PHP settings. More in sites/default/settings.php
# but the following cannot be changed at runtime.
# PHP 4, Apache 1
<IfModule mod_php4.c>
php_value magic_quotes_gpc 0
php_value register_globals 0
php_value session.auto_start 0
</IfModule>
# PHP 4, Apache 2
<IfModule sapi_apache2.c>
php_value magic_quotes_gpc 0
php_value register_globals 0
php_value session.auto_start 0
</IfModule>
# PHP 5, Apache 1 and 2
<IfModule mod_php5.c>
php_value magic_quotes_gpc 0
php_value register_globals 0
php_value session.auto_start 0
</IfModule>
# Reduce the time dynamically generated pages are cache-able.
<IfModule mod_expires.c>
ExpiresByType text/html A1
</IfModule>
# Various rewrite rules.
<IfModule mod_rewrite.c>
RewriteEngine on
# If your site can be accessed both with and without the prefix www.
# you can use one of the following settings to force user to use only one option:
#
# If you want the site to be accessed WITH the www. only, adapt and uncomment the following:
RewriteCond %{HTTP_HOST} !^www\.geekmenow\.com$ [NC]
RewriteRule .* http://www.geekmenow.com/ [L,R=301]
#
# If you want the site to be accessed only WITHOUT the www. , adapt and uncomment the following:
# RewriteCond %{HTTP_HOST} !^example\.com$ [NC]
# RewriteRule .* http://example.com/ [L,R=301]
# Modify the RewriteBase if you are using Drupal in a subdirectory and
# the rewrite rules are not working properly.
RewriteBase /geek2
# Rewrite old-style URLs of the form 'node.php?id=x'.
#RewriteCond %{REQUEST_FILENAME} !-f
#RewriteCond %{REQUEST_FILENAME} !-d
#RewriteCond %{QUERY_STRING} ^id=([^&]+)$
#RewriteRule node.php index.php?q=node/view/%1 [L]
# Rewrite old-style URLs of the form 'module.php?mod=x'.
#RewriteCond %{REQUEST_FILENAME} !-f
#RewriteCond %{REQUEST_FILENAME} !-d
#RewriteCond %{QUERY_STRING} ^mod=([^&]+)$
#RewriteRule module.php index.php?q=%1 [L]
Rewrite current-style URLs of the form 'index.php?q=x'.
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]
</IfModule>
# $Id: .htaccess,v 1.73.2.1 2007/01/01 17:47:24 killes Exp $It is really weird!!!!!
Please help me as I would prefer not have to rebuild that site completely!
ps. Just to add:
I have a lot of drupal sites running on the same servers and this is really the first time I see something like that! I tried
Hope someone could give me some advices?
Patchak