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)
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)
(deleted),
image/jpeg
|
Details |
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.
Reporter | ||
Comment 1•15 years ago
|
||
Using mixed-case password.
Reporter | ||
Updated•15 years ago
|
Version: unspecified → 3.6 Branch
Comment 2•15 years ago
|
||
I can confirm this on Windows as well. Seems it's not just a Mac bug.
Comment 3•15 years ago
|
||
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)
Comment 4•15 years ago
|
||
(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.
Updated•15 years ago
|
Flags: blocking-firefox3.6?
Comment 5•15 years ago
|
||
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?
Comment 6•15 years ago
|
||
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 )
Keywords: regressionwindow-wanted
Reporter | ||
Comment 7•15 years ago
|
||
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.
Comment 8•15 years ago
|
||
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
Comment 9•15 years ago
|
||
--> Core::Networking:Cookies for now; really need to be able to get a confirmation and, ideally, a testcase.
Flags: blocking1.9.2?
Comment 10•15 years ago
|
||
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
Comment 14•15 years ago
|
||
(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
Updated•15 years ago
|
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.
Comment 16•15 years ago
|
||
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.
Comment 17•15 years ago
|
||
(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.
Comment 18•15 years ago
|
||
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]
Comment 19•15 years ago
|
||
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.
Comment 20•15 years ago
|
||
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]
Comment 21•15 years ago
|
||
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.
Comment 22•15 years ago
|
||
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.
Comment 23•15 years ago
|
||
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]
Comment 24•15 years ago
|
||
(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
Comment 25•15 years ago
|
||
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.
Comment 26•15 years ago
|
||
yea I tried over & over again without succes. There is seriously something very neasty with the new Firefox 3.6 Cookies.
Comment 27•15 years ago
|
||
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.
Comment 28•15 years ago
|
||
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]:
Comment 29•15 years ago
|
||
Maybe somthing to do with "COOKIE NOT ACCEPTED"?
Comment 30•15 years ago
|
||
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.
Comment 31•15 years ago
|
||
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.
Comment 32•15 years ago
|
||
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.)
Comment 33•15 years ago
|
||
Uhm, strange enough I DID clear all cookies. I clear even *all* history also (Cookies,buffer,nav.,forms, active logins etc.)...
Comment 34•15 years ago
|
||
If PHPMyAdmin has logging of its own, it would probably be useful to turn that one and see what *it* thinks the problem is.
Comment 35•15 years ago
|
||
How can I turn it on & how can I see the log from PHPMyAdmin?
Comment 36•15 years ago
|
||
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.
Comment 37•15 years ago
|
||
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.
Comment 38•14 years ago
|
||
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.
Updated•9 years ago
|
Keywords: regressionwindow-wanted
You need to log in
before you can comment on or make changes to this bug.
Description
•