By phicarre on

User login block gives me always access denied whatever the users.
Any ideas for repairing ?
Note that i can login by www.mysite/?q=user
But it's not a solution for the users of my site

⋅ Categories: Drupal 4.7.x

Comments

VM’s picture

VM commented

using php 5.2 ?

if so use php 5.2 as the search term, you will find a patch with regards to this issue.

phicarre’s picture

phicarre commented

My provider is using PHP 4.4.4

VM’s picture

VM commented

ok. your going to have to supply more information in order for anyone to help you.
what version of drupal are you using? 4.7.4? any contrib modules running? that would affect login?
is this a fresh site? one thats been installed for awhile?

have you tried clearing your browsers cookies ?

you're going to have to help us, help you.

phicarre’s picture

phicarre commented

I am using Drupal 4.7.4
The PHP version of my provider is 4.4.4
The Mysql version is 5.0.26
It is not a fresh site. My site was running correctly since 8 months.
I upgraded it each time with the new versions
About login: when i log out, i have the message access denied instead of a page for anonymous people.
when i try to log in, in the login block, i have the same message for another page (authentificated people).
I can log in by typing www.mysite.com/?q=user
I think that my database is corrupted after the installation of a module or after the installation of the specific module poormanscron.
I have many modules downloaded from this site.
Is it possible to clean a database by keeping the main data (nodes, ...) ?
About cookies: no i didn't clear cookies and the users of my site cannot access from their computer to it.

In the blocks list i have two invisible blocks ! their name is "block when i click configure !!!!!

phicarre’s picture

phicarre commented

Complement of information:
I imported my database on my pc and I used it with the new drupal version 5.x
The "access denied" messages disappeared !
Then I decided to upload the version 5.x on the ISP server. I updated the database but thr "access denied" messages are always here !!

I hope this could help you in order to help me ;-)

phicarre’s picture

phicarre commented

Really no ideas to help me ;-)

phicarre’s picture

phicarre commented

Only the Anonymous users don't see the first page ?
Can a specialist give a trick for checking the database ?

shekhar’s picture

shekhar commented

Hi phicarre ..

Did u try clean url ...??

Since u are having prob of url
www.mysite.com/?q=user This is not a clean url..
change it in the admin..

Enjoy..

phicarre’s picture

phicarre commented

I changed as you suggested it ...
This solved partially my problem. After a log out, the admin can log in with the login block.
But I always have "access denied" as main page for anonymous users.

shekhar’s picture

shekhar commented

Hi..phicarre

Did u set right permission for anonymous users ???

In admin>>access control..

Hope this solves the prob..

:)

phicarre’s picture

phicarre commented

yes, the access rights are correct, that was running before (what ?)

coreb’s picture

coreb commented

I'm having the same problem as you, and I don't know what is causing this.

Since this was an upgrade rather than a regular install, do you think one of the modules from the old site may still be affecting things? I'm thinking maybe simple access, because I did have it. I also seem to remember having to click a few more buttons than normal to get it to work.

Could it have been altering the db structure in some way that keeps our nodes from being viewable?

EDIT: My guesses were right. I had simple_access installed on the last site. I went into the code (simple_access_initialize) and found these database queries.

DELETE FROM `node_access` WHERE `realm` = 'simple_access';
INSERT INTO `node_access` ( `nid` , `gid` , `realm` , `grant_view` , `grant_update` , `grant_delete` )
VALUES (
'0', '0', 'all', '1', '0', '0'
);

Try to also set the variable "simple_access active" to FALSE. If you're using the development module, run this code. variable_set('simple_access_active', FALSE); (There's a way to do it by looking in the variable table, but I don't recommend it).

After running them, that fixed it for me.

Even if you didn't have simple_access installed, check to see what you have in the node_access table.

Hope this helps.