[support] access denied when upgrading from 4.6.3 to 4.7.3

John Angelmo john at veidit.net
Sun Oct 15 21:42:01 UTC 2006


Hello

I have upgraded from 4.6.3 to 4.7.3 with no errors.
But now when I am logged in everything works fine, but as anonymous I 
get 403 errors.
I have run chmod -R 777 on the drupal directory just to be certain, and 
I can't find any other message then access denied in the drupal log.

mysql logging for the anonymous user:
061015 23:33:27       2 Connect     drupal at localhost on
                       2 Init DB     drupal
                       2 Query       SET NAMES "utf8"
                       2 Query       SELECT sid FROM sessions WHERE sid 
= '5e8d3101220dd9e9629cae2d124a32c7'
                       2 Query       SELECT u.*, s.* FROM users u INNER 
JOIN sessions s ON u.uid = s.uid WHERE s.sid = '5e
8d3101220dd9e9629cae2d124a32c7'
                       2 Query       SELECT * FROM access WHERE status = 
1 AND type = 'host' AND LOWER('85.24.222.68') LIK
E LOWER(mask)
                       2 Query       SELECT * FROM access WHERE status = 
0 AND type = 'host' AND LOWER('85.24.222.68') LIK
E LOWER(mask)
                       2 Query       SELECT data, created, headers, 
expire FROM cache WHERE cid = 'variables'
                       2 Query       SELECT COUNT(pid) FROM url_alias
                       2 Query       SELECT src FROM url_alias WHERE dst 
= 'node/1'
                       2 Query       SELECT name, filename, throttle, 
bootstrap FROM system WHERE type = 'module' AND stat
us = 1 ORDER BY weight ASC, filename ASC
                       2 Query       SELECT data, created, headers, 
expire FROM cache WHERE cid = 'menu:0:en'
                       2 Query       SELECT n.nid, n.vid, n.type, 
n.status, n.created, n.changed, n.comment, n.promote, n.
moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, 
r.teaser, r.log, r.format, u.uid, u.name, u.pictu
re, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN 
node_revisions r ON r.vid = n.vid WHERE n.nid = 1
                       2 Query       SELECT last_comment_timestamp, 
last_comment_name, comment_count FROM node_comment_sta
tistics WHERE nid = 1
                       2 Query       SELECT DISTINCT(p.perm) FROM role r 
INNER JOIN permission p ON p.rid = r.rid WHERE r.
rid IN (1)
                       2 Query       SELECT t.* FROM term_node r INNER 
JOIN term_data t ON r.tid = t.tid INNER JOIN vocabu
lary v ON t.vid = v.vid WHERE r.nid = 1 ORDER BY v.weight, t.weight, t.name
                       2 Query       SELECT * FROM files f INNER JOIN 
file_revisions r ON f.fid = r.fid WHERE r.vid = 1 OR
DER BY f.fid
                       2 Query       SELECT COUNT(*) FROM node_access 
WHERE (nid = 0 OR nid = 1) AND ((gid = 0 AND realm =
  'all')) AND grant_view >= 1
                       2 Query       SELECT COUNT(*) FROM node_access 
WHERE (nid = 0 OR nid = 1) AND ((gid = 0 AND realm =
  'all')) AND grant_update >= 1
                       2 Query       SELECT COUNT(*) FROM node_access 
WHERE (nid = 0 OR nid = 1) AND ((gid = 0 AND realm =
  'all')) AND grant_delete >= 1
                       2 Query       SELECT * FROM system WHERE type = 
'theme'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'node/1'
                       2 Query       INSERT INTO watchdog (uid, type, 
message, severity, link, location, referer, hostname
, timestamp) VALUES (0, 'access denied', '<em>node/1</em> denied 
access.', 1, '<a href=\"/d/stupid/node/1\" class=\"activ
e\">view</a>', 'http://asuka.veidit.net/d/stupid/node/1', '', 
'85.24.222.68', 1160948007)
                       2 Query       SELECT * FROM blocks WHERE theme = 
'paf' AND status = 1 ORDER BY region, weight, module
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'node/4'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'taxonomy/term/10'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'gallery/main.php'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'blog/1'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'taxonomy/term/9'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'tracker'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'admin/logs/referrers'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'admin/logs/pages'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'admin/logs/visitors'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'admin/logs/hits'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'user/register'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'user/password'
                       2 Query       SELECT dst FROM url_alias WHERE src 
= 'node'
                       2 Query       SELECT * FROM system WHERE type = 
'theme' AND name = 'paf'
                       2 Query       INSERT INTO accesslog (title, path, 
url, hostname, uid, sid, timer, timestamp) values
('Access denied', '', '', '85.24.222.68', 0, 
'5e8d3101220dd9e9629cae2d124a32c7', 208, 1160948007)
                       2 Query       SELECT sid FROM sessions WHERE sid 
= '5e8d3101220dd9e9629cae2d124a32c7'
                       2 Query       UPDATE sessions SET uid = 0, cache 
= 0, hostname = '85.24.222.68', session = '', time
stamp = 1160948007 WHERE sid = '5e8d3101220dd9e9629cae2d124a32c7'
                       2 Quit




More information about the support mailing list