Closed Bug 518734 Opened 15 years ago Closed 15 years ago

(PHPMyAdmin) Can't login with username/password. Claims Invalid Password.

Categories

(Core :: Networking: Cookies, defect)

1.9.2 Branch
x86
macOS
defect
Not set
normal

Tracking

()

RESOLVED INCOMPLETE

People

(Reporter: omnichad, Unassigned)

References

()

Details

(Keywords: relnote, Whiteboard: [need someone to repro with logging, see comment 14][3.6.x])

Attachments

(1 file)

User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2a1) Gecko/20090806 Namoroka/3.6a1 Build Identifier: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2a1) Gecko/20090806 Namoroka/3.6a1 When I try to log in to my own install of PHPMyAdmin, I get a error message: #1045 - Access denied for user 'root'@'localhost' (using password: YES) If I try to log in with another browser (Omniweb, Firefox 3.5, etc.) it works just fine. I'm afraid I don't know why it only happens in Firefox. But this is a standard install of PHPMyAdmin, using MySQL credentials for session authentication. I'm not giving away my credentials, but hoping you will be able to reproduce elsewhere. I'm sure this bug goes beyond PHPMyAdmin, but I don't have any other examples. I have another server running the same version, but has an all-lowercase password. I can install just fine. Reproducible: Couldn't Reproduce Steps to Reproduce: 1. Visit a PHPMyAdmin installation (Version 3.1.3.2) 2. Log in with a mixed-case password 3. Receive password error. Actual Results: #1045 - Access denied for user 'root'@'localhost' (using password: YES) Expected Results: accepted my password and logged me in.
Attached image Screenshot of this occurring. (deleted) —
Using mixed-case password.
Version: unspecified → 3.6 Branch
I can confirm this on Windows as well. Seems it's not just a Mac bug.
Confirming Myself - Me too, Windows XP Client SP2, Firefox 3.6 Beta2, Tested 20 times or so then tried from the command line and then from IE (both other methods worked)
(In reply to comment #3) > Confirming Myself - Me too, Windows XP Client SP2, Firefox 3.6 Beta2, Tested 20 > times or so then tried from the command line and then from IE (both other > methods worked) --> clearing the cache via "clear recent history" allowed me to login. --> I reproduced the error accidentally by not making any changes in phpmyadmin for some time and so I got timed out; When I tried to login again I got the same error however clicking the LOGOUT link on phpmyadmin allowed me to later re-log in again.
Flags: blocking-firefox3.6?
This is either cookies, password manager or form fill; comment 4 makes me think it's something more to do with the form fill, really. Anyone got a PHPMyAdmin install we can use to get solid STR?
Or if the reporters could find us a regression window, that would also be helpful. Shaver mentions that some JS changes might also have caused this. (For more on how to find a regression window, check https://wiki.mozilla.org/QA#What_We_Use )
I sure doubt this is JS. The only code on the page is to change focus to the input field. That would be one serious JS issue. Username appears to be stored in a cookie that is reset on logout. But that username still displays correctly in the field when the error occurs.
Connor indicates it doesn't happen with HTTP auth, and comment 5 indicates that it might be a cookie or caching problem. Reporter: if you clear the cookie for the site, or look at that cookie, can you confirm if the user name is being stored correctly?
Component: General → Networking: Cookies
Flags: blocking-firefox3.6?
Product: Firefox → Core
QA Contact: general → networking.cookies
Version: 3.6 Branch → 1.9.2 Branch
--> Core::Networking:Cookies for now; really need to be able to get a confirmation and, ideally, a testcase.
Flags: blocking1.9.2?
A cookie log might also help here, see https://developer.mozilla.org/en/Creating_a_Cookie_Log
Would be great to get to the bottom of this. We have at least one other bug on file (bug 523737) which might be cookie related. So there might be some problem on our end here.
I think you might be seeing bug 530220. It is fixed in 3.6 beta 4 which is due to be released soon. In that release FileReader is also correctly named. If you don't want to wait for 3.6beta4 to be released, you can download a nightly release from the same branch from here: http://ftp.mozilla.org/pub/mozilla.org/firefox/nightly/latest-mozilla-1.9.2/ Thanks a ton for experimenting with this! Definitely let us know if you see any more problems, or if the above builds doesn't fix the problems you're seeing.
Please ignore comment 13. That was meant for another bug
(In reply to comment #10) > A cookie log might also help here, see > https://developer.mozilla.org/en/Creating_a_Cookie_Log It also might be interesting to have a password manger log, see: https://wiki.mozilla.org/Firefox:Password_Manager_Debugging
Status: UNCONFIRMED → NEW
Ever confirmed: true
Chad: would v=be great if you could help out by following the directions in comment 10. It's unlikely that this will be fixed in Firefox 3.6 otherwise.
It appears that recreating your profile on the latest nightly works. My old profile (created 10th November) still fails to work. Regression window is between 10th Nov and today as far as I can tell.
(In reply to comment #16) > It appears that recreating your profile on the latest nightly works. > > My old profile (created 10th November) still fails to work. Regression window > is between 10th Nov and today as far as I can tell. Actually, no, scrap that. It only works on a clean profile still.
So if you create a clean profile, you can access the site? What about if you find the site in history with your existing profile, then use the "Forget This Site" to clear all cookies and stored data?
Keywords: relnote
Whiteboard: [workaround in comment 17]
I'll try that later. The issue seems to now be intermittent. If I create a brand new profile, it works. Quit Minefield, restart it into the same profile, broken again. Restarting into my normal nightly profile, it then worked..... for about 5 minutes, then broke. I'll try and get a full cookie log in the next week once I get some time.
Not blocking on this until we can get a clear understanding of what the cause is; I might relnote it and list the workaround in comment 17.
Flags: blocking1.9.2? → blocking1.9.2-
Whiteboard: [workaround in comment 17] → [workaround in comment 17][3.6.x]
Got this problem too with Firefox 3.6, I can't login in my phpMyAdmin (invalid login is says). But with the same login using Internet Explorer everything works OK.
Got this problem too with Firefox 3.6, I can't login in my phpMyAdmin (invalid login is says). But with the same login using Internet Explorer everything works OK.
Without a cookie and password manager log (see comment 14), it's unlikely any progress will be made on this bug. A regression window would also be useful (see comment 6). Please attach said logging and reopen.
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → INCOMPLETE
Whiteboard: [workaround in comment 17][3.6.x] → [need someone to repro with logging, see comment 14][3.6.x]
(In reply to comment #23) > Without a cookie and password manager log (see comment 14), it's unlikely any > progress will be made on this bug. A regression window would also be useful > (see comment 6). Please attach said logging and reopen. Sure... http://img714.imageshack.us/img714/3861/screen1k.png http://img35.imageshack.us/img35/1666/screen2nx.png http://img687.imageshack.us/img687/4562/screen3fn.png
I don't see anything wrong in the password manager output; other than it being slightly unusual that you apparently have 9 logins stored for http://localhost.
yea I tried over & over again without succes. There is seriously something very neasty with the new Firefox 3.6 Cookies.
Melroy, can you follow the instructions at https://developer.mozilla.org/en/Creating_a_Cookie_Log to create a cookie log as well? It's probably best to do this on a clean profile.
0[82c140]: Read(): 10 cookies read 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.com/firefox?client=firefox-a&rls=org.mozilla:nl:official 0[82c140]: cookie string: PREF=ID=a853a8750bbeba94:TM=1265050550:LM=1265050550:S=J2qcuebXnCggSLMD; NID=31=biDtM_qnMzhf7R6gbbVxNSDIGO0dbGQB7h4mnzJLeCQBrKIiKMwsCDZb0G0UWrfXirOSpSAxe2HBtDl9FmhjTyCSzvDjEDbBeqyx2Tm5N2OqLXpBe6XUDyUUk0hgVlao 0[82c140]: current time: Mon Feb 01 18:57:32 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://www.google.com/firefox?client=firefox-a&rls=org.mozilla:nl:official 0[82c140]: cookie string: PREF=ID=a853a8750bbeba94:U=9fa961be8a0de195:TM=1265050550:LM=1265050640:S=xam8f0eiigxrl3xH; expires=Wed, 01-Feb-2012 18:57:20 GMT; path=/; domain=.google.com 0[82c140]: replaces existing cookie: true 0[82c140]: current time: Mon Feb 01 18:57:32 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: PREF 0[82c140]: value: ID=a853a8750bbeba94:U=9fa961be8a0de195:TM=1265050550:LM=1265050640:S=xam8f0eiigxrl3xH 0[82c140]: domain: .google.com 0[82c140]: path: / 0[82c140]: expires: Wed Feb 01 18:57:32 2012 GMT 0[82c140]: created: Mon Feb 01 18:56:02 2010 GMT (id 1265050562577000) 0[82c140]: is secure: false 0[82c140]: is httpOnly: false 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.nl/firefox?client=firefox-a&rls=org.mozilla:nl:official 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:TM=1265050550:LM=1265050550:S=TCd7m_pAksgHWwde; NID=31=NO9dsrlqLXLRvZPm8hGOZNl2zSxvlA18bwyvMAWAUHJJI6aLNJYYMwZzg-i8kBwrS5-ro1b6sJaId-_Ff2dFH1TgsiWHD2fGK9rkhJ7ql6UN7WvoDn5i7OKLD9WDvye6 0[82c140]: current time: Mon Feb 01 18:57:32 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://www.google.nl/firefox?client=firefox-a&rls=org.mozilla:nl:official 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI; expires=Wed, 01-Feb-2012 18:57:20 GMT; path=/; domain=.google.nl 0[82c140]: replaces existing cookie: true 0[82c140]: current time: Mon Feb 01 18:57:32 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: PREF 0[82c140]: value: ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI 0[82c140]: domain: .google.nl 0[82c140]: path: / 0[82c140]: expires: Wed Feb 01 18:57:32 2012 GMT 0[82c140]: created: Mon Feb 01 18:56:02 2010 GMT (id 1265050562789000) 0[82c140]: is secure: false 0[82c140]: is httpOnly: false 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.nl/images/firefox/sprite2.png 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI; NID=31=NO9dsrlqLXLRvZPm8hGOZNl2zSxvlA18bwyvMAWAUHJJI6aLNJYYMwZzg-i8kBwrS5-ro1b6sJaId-_Ff2dFH1TgsiWHD2fGK9rkhJ7ql6UN7WvoDn5i7OKLD9WDvye6 0[82c140]: current time: Mon Feb 01 18:57:32 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.nl/images/firefox/gradsprite2.png 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI; NID=31=NO9dsrlqLXLRvZPm8hGOZNl2zSxvlA18bwyvMAWAUHJJI6aLNJYYMwZzg-i8kBwrS5-ro1b6sJaId-_Ff2dFH1TgsiWHD2fGK9rkhJ7ql6UN7WvoDn5i7OKLD9WDvye6 0[82c140]: current time: Mon Feb 01 18:57:32 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.nl/images/firefox/firefox35_v1.png 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI; NID=31=NO9dsrlqLXLRvZPm8hGOZNl2zSxvlA18bwyvMAWAUHJJI6aLNJYYMwZzg-i8kBwrS5-ro1b6sJaId-_Ff2dFH1TgsiWHD2fGK9rkhJ7ql6UN7WvoDn5i7OKLD9WDvye6 0[82c140]: current time: Mon Feb 01 18:57:32 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.nl/extern_js/f/CgJubBICbmwrMAo4UEAdLCswDjgLLCswFjgVLCswFzgFLCswGDgFLCswGTgSLCswJTjJiAEsKzAnOAQsKzAqOAMsKzArOAosKzA8OAIs/Zg8DpchUoes.js 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI; NID=31=NO9dsrlqLXLRvZPm8hGOZNl2zSxvlA18bwyvMAWAUHJJI6aLNJYYMwZzg-i8kBwrS5-ro1b6sJaId-_Ff2dFH1TgsiWHD2fGK9rkhJ7ql6UN7WvoDn5i7OKLD9WDvye6 0[82c140]: current time: Mon Feb 01 18:57:32 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.nl/images/nav_logo4.png 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI; NID=31=NO9dsrlqLXLRvZPm8hGOZNl2zSxvlA18bwyvMAWAUHJJI6aLNJYYMwZzg-i8kBwrS5-ro1b6sJaId-_Ff2dFH1TgsiWHD2fGK9rkhJ7ql6UN7WvoDn5i7OKLD9WDvye6 0[82c140]: current time: Mon Feb 01 18:57:33 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.nl/favicon.ico 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI; NID=31=NO9dsrlqLXLRvZPm8hGOZNl2zSxvlA18bwyvMAWAUHJJI6aLNJYYMwZzg-i8kBwrS5-ro1b6sJaId-_Ff2dFH1TgsiWHD2fGK9rkhJ7ql6UN7WvoDn5i7OKLD9WDvye6 0[82c140]: current time: Mon Feb 01 18:57:33 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://www.google.nl/favicon.ico 0[82c140]: cookie string: PREF=ID=e477e261018fd07d:U=7da223aef8ba9cfc:TM=1265050550:LM=1265050640:S=SxCWCyDOGJHlIxUI; NID=31=NO9dsrlqLXLRvZPm8hGOZNl2zSxvlA18bwyvMAWAUHJJI6aLNJYYMwZzg-i8kBwrS5-ro1b6sJaId-_Ff2dFH1TgsiWHD2fGK9rkhJ7ql6UN7WvoDn5i7OKLD9WDvye6 0[82c140]: current time: Mon Feb 01 18:57:33 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/ 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=jH2BH6TzwFc%3D 0[82c140]: current time: Mon Feb 01 18:57:36 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/ 0[82c140]: cookie string: phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; path=/phpmyadmin/; HttpOnly pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:37 GMT; path=/phpmyadmin/; httponly pma_theme=original; expires=Wed, 03-Mar-2010 18:57:37 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: false 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: phpMyAdmin 0[82c140]: value: be289418d6c3ce227015ce33df02a3132b40f3d8 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Dec 31 23:59:59 1969 GMT (at end of session) 0[82c140]: created: Mon Feb 01 18:57:37 2010 GMT (id 1265050657562000) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/ 0[82c140]: cookie string: pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:37 GMT; path=/phpmyadmin/; httponly pma_theme=original; expires=Wed, 03-Mar-2010 18:57:37 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: false 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pma_fontsize 0[82c140]: value: 82%25 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:37 2010 GMT 0[82c140]: created: Mon Feb 01 18:57:37 2010 GMT (id 1265050657562001) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/ 0[82c140]: cookie string: pma_theme=original; expires=Wed, 03-Mar-2010 18:57:37 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: false 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pma_theme 0[82c140]: value: original 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:37 2010 GMT 0[82c140]: created: Mon Feb 01 18:57:37 2010 GMT (id 1265050657562002) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/phpmyadmin.css.php?token=383c8d4a1d8ada8346365a6aee2fef82&js_frame=right&nocache=3732699936 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=jH2BH6TzwFc%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_fontsize=82%25; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/print.css 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=jH2BH6TzwFc%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_fontsize=82%25; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/favicon.ico 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=jH2BH6TzwFc%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_fontsize=82%25; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/favicon.ico 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=jH2BH6TzwFc%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_fontsize=82%25; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/favicon.ico 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=jH2BH6TzwFc%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_fontsize=82%25; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/themes/original/img/logo_right.png 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=jH2BH6TzwFc%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_fontsize=82%25; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE NOT ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/phpmyadmin.css.php?token=383c8d4a1d8ada8346365a6aee2fef82&js_frame=right&nocache=3732699936 0[82c140]: cookie string: pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:36 GMT; path=/phpmyadmin/ pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:36 GMT; path=/phpmyadmin/ 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: rejected because previously stored cookie was deleted 0[82c140]: 0[82c140]: ===== COOKIE NOT ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/phpmyadmin.css.php?token=383c8d4a1d8ada8346365a6aee2fef82&js_frame=right&nocache=3732699936 0[82c140]: cookie string: pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:36 GMT; path=/phpmyadmin/ 0[82c140]: current time: Mon Feb 01 18:57:37 2010 GMT 0[82c140]: rejected because cookie has already expired 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=jH2BH6TzwFc%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:39 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php 0[82c140]: cookie string: pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pma_theme=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pmaPass-1=PKRo%2FPoESu4%3D; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: false 0[82c140]: current time: Mon Feb 01 18:57:39 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pma_fontsize 0[82c140]: value: 82%25 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:39 2010 GMT 0[82c140]: created: Mon Feb 01 18:57:39 2010 GMT (id 1265050659947000) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php 0[82c140]: cookie string: pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pma_theme=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pmaPass-1=PKRo%2FPoESu4%3D; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: true 0[82c140]: current time: Mon Feb 01 18:57:39 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pma_fontsize 0[82c140]: value: 82%25 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:39 2010 GMT 0[82c140]: created: Mon Feb 01 18:57:39 2010 GMT (id 1265050659947000) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php 0[82c140]: cookie string: pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pma_theme=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pmaPass-1=PKRo%2FPoESu4%3D; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: true 0[82c140]: current time: Mon Feb 01 18:57:39 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pma_fontsize 0[82c140]: value: 82%25 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:39 2010 GMT 0[82c140]: created: Mon Feb 01 18:57:39 2010 GMT (id 1265050659947000) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE NOT ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php 0[82c140]: cookie string: pma_theme=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pmaPass-1=PKRo%2FPoESu4%3D; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly 0[82c140]: current time: Mon Feb 01 18:57:39 2010 GMT 0[82c140]: rejected because previously stored cookie was deleted 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php 0[82c140]: cookie string: pmaPass-1=PKRo%2FPoESu4%3D; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: true 0[82c140]: current time: Mon Feb 01 18:57:39 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pmaPass-1 0[82c140]: value: PKRo%2FPoESu4%3D 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:39 2010 GMT 0[82c140]: created: Mon Feb 01 18:56:18 2010 GMT (id 1265050578674004) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php?token=383c8d4a1d8ada8346365a6aee2fef82 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; pmaPass-1=PKRo%2FPoESu4%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_fontsize=82%25 0[82c140]: current time: Mon Feb 01 18:57:39 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE NOT ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php?token=383c8d4a1d8ada8346365a6aee2fef82 0[82c140]: cookie string: pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_theme=original; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pmaPass-1=deleted; expires=Sun, 01-Feb-2009 18:57:40 GMT; path=/phpmyadmin/ 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: rejected because previously stored cookie was deleted 0[82c140]: 0[82c140]: ===== COOKIE NOT ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php?token=383c8d4a1d8ada8346365a6aee2fef82 0[82c140]: cookie string: pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_theme=original; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pmaPass-1=deleted; expires=Sun, 01-Feb-2009 18:57:40 GMT; path=/phpmyadmin/ 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: rejected because cookie has already expired 0[82c140]: 0[82c140]: ===== COOKIE NOT ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php?token=383c8d4a1d8ada8346365a6aee2fef82 0[82c140]: cookie string: pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_theme=original; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pmaPass-1=deleted; expires=Sun, 01-Feb-2009 18:57:40 GMT; path=/phpmyadmin/ 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: rejected because cookie has already expired 0[82c140]: 0[82c140]: ===== COOKIE NOT ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php?token=383c8d4a1d8ada8346365a6aee2fef82 0[82c140]: cookie string: pma_fontsize=deleted; expires=Sun, 01-Feb-2009 18:57:38 GMT; path=/phpmyadmin/ pma_theme=original; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pmaPass-1=deleted; expires=Sun, 01-Feb-2009 18:57:40 GMT; path=/phpmyadmin/ 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: rejected because cookie has already expired 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php?token=383c8d4a1d8ada8346365a6aee2fef82 0[82c140]: cookie string: pma_theme=original; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly pmaPass-1=deleted; expires=Sun, 01-Feb-2009 18:57:40 GMT; path=/phpmyadmin/ 0[82c140]: replaces existing cookie: false 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pma_theme 0[82c140]: value: original 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:41 2010 GMT 0[82c140]: created: Mon Feb 01 18:57:41 2010 GMT (id 1265050661017004) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE NOT ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/index.php?token=383c8d4a1d8ada8346365a6aee2fef82 0[82c140]: cookie string: pmaPass-1=deleted; expires=Sun, 01-Feb-2009 18:57:40 GMT; path=/phpmyadmin/ 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: rejected because previously stored cookie was deleted 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/phpmyadmin.css.php?token=383c8d4a1d8ada8346365a6aee2fef82&js_frame=right&nocache=3732699936 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/print.css 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/favicon.ico 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/favicon.ico 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_theme=original 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/phpmyadmin.css.php?token=383c8d4a1d8ada8346365a6aee2fef82&js_frame=right&nocache=3732699936 0[82c140]: cookie string: pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:41 GMT; path=/phpmyadmin/; httponly pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:41 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: false 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pma_fontsize 0[82c140]: value: 82%25 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:41 2010 GMT 0[82c140]: created: Mon Feb 01 18:57:41 2010 GMT (id 1265050661081000) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE ACCEPTED ===== 0[82c140]: request URL: http://localhost/phpmyadmin/phpmyadmin.css.php?token=383c8d4a1d8ada8346365a6aee2fef82&js_frame=right&nocache=3732699936 0[82c140]: cookie string: pma_fontsize=82%25; expires=Wed, 03-Mar-2010 18:57:41 GMT; path=/phpmyadmin/; httponly 0[82c140]: replaces existing cookie: true 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: ---------------- 0[82c140]: name: pma_fontsize 0[82c140]: value: 82%25 0[82c140]: host: localhost 0[82c140]: path: /phpmyadmin/ 0[82c140]: expires: Wed Mar 03 18:57:41 2010 GMT 0[82c140]: created: Mon Feb 01 18:57:41 2010 GMT (id 1265050661081000) 0[82c140]: is secure: false 0[82c140]: is httpOnly: true 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/themes/original/img/logo_right.png 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_theme=original; pma_fontsize=82%25 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]: 0[82c140]: ===== COOKIE SENT ===== 0[82c140]: request URL: http://localhost/phpmyadmin/themes/original/img/s_error.png 0[82c140]: cookie string: pma_lang=nl-utf-8; pma_charset=utf-8; pma_collation_connection=utf8_general_ci; pma_mcrypt_iv=SmluavHGVGQ%3D; pmaUser-1=FpqJqloKNTI%3D; phpMyAdmin=be289418d6c3ce227015ce33df02a3132b40f3d8; pma_theme=original; pma_fontsize=82%25 0[82c140]: current time: Mon Feb 01 18:57:41 2010 GMT 0[82c140]:
Maybe somthing to do with "COOKIE NOT ACCEPTED"?
Doesn't look like it; "COOKIE NOT ACCEPTED" is a strawman here, because that gets logged when a cookie is deleted by being overwritten with an expired cookie. (This is a normal process.) It is odd that the server tries to set/delete the same cookie multiple times in a row, though. In the same Set-Cookie header, no less. I suspect the problem has to do with this cookie, which is set: cookie string: pmaPass-1=PKRo%2FPoESu4%3D; expires=Wed, 03-Mar-2010 18:57:39 GMT; path=/phpmyadmin/; httponly ... and then immediately deleted in the next Set-Cookie header. Which sounds like PHPMyAdmin is unhappy with it. There's insufficient information to determine whether this is a bug in PHPMyAdmin or Firefox, though. The transactions in the log look fine to me.
OK, its not a PHPMyAdmin problem. Because I using the PHPMyAdmin (on my localhost) with Firefox 3.5 without any problems. Also Internet Explorer (I know you all hate IE, same as me) login without any problems.
In that case, I think we need more information here. The log you gave is a start, but I also need a log of the original cookie transactions. (It says "10 cookies read" at the top of the log, and then Firefox sends a bunch of cookies with the first transaction.) Please do this: 1) Clear all your cookies. 2) Start Firefox with logging enabled, and log in. 3) Close Firefox. Copy the log somewhere and delete the original. (Otherwise the log will get overwritten in 4.) 4) Start Firefox as before, and reproduce the login problem. 5) Attach both logs here (as attachments please, not pasted as comments - use the "Add an attachment" link near the top of the page.)
Uhm, strange enough I DID clear all cookies. I clear even *all* history also (Cookies,buffer,nav.,forms, active logins etc.)...
If PHPMyAdmin has logging of its own, it would probably be useful to turn that one and see what *it* thinks the problem is.
How can I turn it on & how can I see the log from PHPMyAdmin?
There is a recurring error (all kinds of posts regarding a phpMyAdmin error that reads "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.") that has a common denominator: virtually every one of the posts about this error list the browser they're using as Firefox. I'm using Firefox 3.6, and everything was working fine up until yesterday. Then I started getting the above error ONLY in Firefox; Safari & IE (various flavors) all worked fine. After clearing recent history, the error disappeared.
I think I found the problem too. Clearing the history, navigation, form, cookies, buffer, active logins etc. was NOT enough. I think I've some problem with the long list of "Saved Passwords", so i just deleted ALL saved passwords. Tools->Options->Security->Passwords->Saved Passwords->Clear all And I think this fixed my problem for so far.
Since this (the original problem at least) involved problems logging into phpMyAdmin and seems to have appeared in 3.6 / 1.9.2, it may be a duplicate of bug 618835 (Cannot login to phpmyadmin if I made a typo during my first login attempt). This turned out to be a problem not with cookies but with a cached page being fetched, when FF 3.5 and other browsers revalidate the cache. There are patches at bug 618835 for both phpMyAdmin and Firefox. Please try one or both of these and see if the problem remains.
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: