Bug 353872 - Forum login page displays blank
Summary: Forum login page displays blank
Status: RESOLVED FIXED
Alias: None
Product: Community
Classification: Eclipse Foundation
Component: Forums and Newsgroups (show other bugs)
Version: unspecified   Edit
Hardware: PC Mac OS X - Carbon (unsup.)
: P3 normal with 1 vote (vote)
Target Milestone: ---   Edit
Assignee: Forums and Newsgroups inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-08-04 07:37 EDT by Alex Panchenko CLA
Modified: 2012-07-05 10:29 EDT (History)
4 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Panchenko CLA 2011-08-04 07:37:06 EDT
Forum Login link navigates to http://www.eclipse.org/forums/index.php/l/ 
but the page just displays nothing.
Mac OS X, Safari & Chrome
Comment 1 Eric Rizzo CLA 2011-08-04 08:53:15 EDT
I suspect this was a temporary connectivity issue or server hiccup. The Login link and the URL above both work correctly for me right now.
OS X 10.6.8, Safari 5.1, Firefox 5.0.1
Alex, please try again and close this if it's working for you now.
Comment 2 Alex Panchenko CLA 2011-08-04 08:58:55 EDT
I tried again and it was able to display login page *once*.
But when I was redirect to forum I still wasn't authenticated.
And it doesn't work for me quite often during the last 1-2 months.
Comment 3 Laurent Goubet CLA 2012-06-18 03:14:47 EDT
This was raised a good while ago ... and still holds true to this day. The login page of the Eclipse forum is highly unreliable, and has been for several months now. Sometimes it just refuses to log us in (redirects us to the page where we just were), sometimes it throws us a time out, sometimes a 404... But a constant is that we cannot get logged in. It usually works after a few tries, but today I cannot get connected whatever I do.

From http://www.eclipse.org/forums/ I click on "login" and get redirected there : https://dev.eclipse.org/site_login/?takemeback=http://www.eclipse.org/forums/index.php?t=login

Where firefox simply tells me that the connection was reinitialized.
Comment 4 Denis Roy CLA 2012-07-03 16:08:53 EDT
I can't seem to reproduce this  :(
Comment 5 Alex Panchenko CLA 2012-07-03 16:25:22 EDT
I've tried it again: after I authenticated and pressed the Continue button I see 500 error on http://www.eclipse.org/forums/index.php?t=login page.

Refresh doesn't help.

Login link from the forum (http://www.eclipse.org/forums/index.php/l/) now also displays 500 error.

Using Chromium on Ubuntu 12.04.

curl works fine, so the problem must be caused by the browser cookies.
I don't know how we can debug it - can you see 500 errors in the log? (my public IP at the moment should be 178.49.155.37).

Request URL:http://www.eclipse.org/forums/index.php?t=login
Request Method:GET
Status Code:500 Internal Server Error

Response Headers:
Connection:close
Content-Encoding:gzip
Content-Length:20
Content-Type:text/html
Date:Tue, 03 Jul 2012 20:14:52 GMT
P3P:CP="ALL CUR OUR IND UNI ONL INT CNT STA"
Server:Apache
Vary:Accept-Encoding
X-NodeID:www-vm2
Comment 6 Denis Roy CLA 2012-07-03 16:41:14 EDT
Alex,

I can see the 500 codes, but I get no explanation.

Do you mind if tomorrow (in the Eastern timezone) I change your password and attempt to log in as you?  If I can at least reproduce the error I'd have something to work with.
Comment 7 Alex Panchenko CLA 2012-07-03 16:59:04 EDT
I believe php reports the problems to the erorr log, if enabled.
You can try to log in as me, hopefully it helps to debug the problem.
Comment 8 Denis Roy CLA 2012-07-04 09:23:54 EDT
Thanks.  I changed your password, logged in as you and found the problem.  This is leftover artifacts from the time when Bugzilla accounts were separate from LDAP accounts.  You have two Bugzilla accounts: id 47447 and 47448 so when you'd log in with your current email address, 47448 was found.  It then tries to sync your email address with fud_forum, but 47447 was already using that email address, hence the silent failure.

So I've fixed your account (47448) -- I'll have to investigate to ensure email address changes in LDAP are properly reflected into the forum database.

Alex, I'm done with your account -- feel free to reset your password.  Thanks  :)

https://dev.eclipse.org/site_login/createaccount.php
Comment 9 Alex Panchenko CLA 2012-07-04 09:28:30 EDT
It works now.
Thanks :)
Comment 10 Denis Roy CLA 2012-07-04 09:52:32 EDT
For my own notes, I was able to sync the forum table with Bugzilla like this:

/* check to see if there are mismatches  */
mysql> select b.userid, b.login_name, f.email from bugs.profiles b inner join fudforum.fud_users f on f.id = b.userid where b.login_name <> f.email collate utf8_unicode_ci;
590 rows in set (0.31 sec)

/* drop unique key on email */
mysql> alter table fud_users drop KEY `fud_users_i_e`;

mysql> update fudforum.fud_users, bugs.profiles set fudforum.fud_users.email = bugs.profiles.login_name where bugs.profiles.userid = fudforum.fud_users.id;
Query OK, 710 rows affected, 3 warnings (1.16 sec)


mysql> alter table fud_users add unique KEY `fud_users_i_e` (`email`);

/* recheck for mismatches */
mysql> select b.userid, b.login_name, f.email from bugs.profiles b inner join fudforum.fud_users f on f.id = b.userid where b.login_name <> f.email collate utf8_unicode_ci;
Empty set (0.24 sec)
Comment 11 Laurent Goubet CLA 2012-07-05 09:10:45 EDT
This also seems to have resolved the issue on our side.
Comment 12 Denis Roy CLA 2012-07-05 10:29:13 EDT
I re-ran the query to compare bugzilla email addresses to the forum's, and sure enough, there was one mismatch -- someone changed their email address on the Eclipse Account page, and that didn't update in the forum.  I've fixed that.

I guess that is one item done from the list in bug 376910