The users can't login anymore, I don't know if this is a users module problem or a database module problem, but it only affects users.

All I get is username/password incorrect when MySQL is upgraded from 5.1 to 5.5.

Comments

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
CreditAttribution: webchick commented
Category: bug » support
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

Can anyone else re-produce?

jfha73’s picture

jfha73 CreditAttribution: jfha73 commented

I tried it in two environments, moving Drupal from Windows with MySQL 5.1 to Linux with MySQL 5.5 and from Linux to Linux and also empty site and site with nodes in it and I got the same result.

The way I'm doing to move is exporting the database to a .sql file and then importing it to the new server, but no luck, I can't get my users to login, not even user1.

jfha73’s picture

jfha73 CreditAttribution: jfha73 commented

Here is more info:

http://drupal.org/node/1580704

jfha73’s picture

jfha73 CreditAttribution: jfha73 commented
Title: When MySQL is upgraded from 5.1 to 5.5 » When site is moved from MySQL 5.1 to 5.5

This is weird, the problem is not when MySQL is upgraded, but when the site is moved from a MySQL 5.1 to MySQL 5.5

I just tried regular upgrade on Linux and it worked, but this doesn't happen when the site is moved, so let me change the title for something more realistic.

BTMash’s picture

BTMash CreditAttribution: BTMash commented

Hmm, would you be able to check the difference in the password column for the users (once for before it is moved to 5.5 and once for after it is moved to 5.5)? Also, did any other credentials change when you upgraded the db? I'm wondering if there was a salt change and that is what causes this issue to occur.

jfha73’s picture

jfha73 CreditAttribution: jfha73 commented

I did check and there was no difference, but just in case I did try an update using the password type for mysql, that did change it, but still no login.

mauz0’s picture

mauz0 CreditAttribution: mauz0 commented

hi,

stumbled upon the same Problem: old server with mysql 5.1, then new one with fresh Linux and mysql 5.5. Just imported the old tables with phpmyadmin, but not any service with mysql authentication was responding.

This worked like a charm: On the 5.5 server execute:

mysql_upgrade -uroot -pMySecret --force

--force because the mysql is already 5.5, so it does nothing. but the tables need fixing

for reference

cheers.

chansw’s picture

chansw CreditAttribution: chansw commented
Version: 7.14 » 7.19

I have a different problem after moving a site from a MySQL 5.1 to MySQL 5.5 database (Drupal 7.14 to Drupal 7.19). No problem to login as the admin but the content cannot be updated. No error was returned on the page. I have run that mysql_upgrade command as suggested but that did not solve the problem. Any suggestion is appreciated. Thanks.

Cheers

Wing

DanChadwick’s picture

DanChadwick CreditAttribution: DanChadwick commented

@chansw - I had exactly the same problem, but it wasn't actually MySQL that was the problem. I also upgraded Apache2 at the same time and mod_rewrite wasn't enabled and the Drupal site had Clean URLs enabled. The result is that no forms will get data because $_POST will be empty.

You can try installing a brand new Drupal installation. In my case it worked fine because Clean URLS wasn't on yet. When I switched to a site that was working with the previous stack, it stopped work. Hpoe this helps.

Version: 7.19 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.

vineetkumar03’s picture

vineetkumar03 CreditAttribution: vineetkumar03 commented
Issue summary: View changes

fisrt case, if you change password in mysql, dont forget to modify password in file settings.php.
second case, maybe user of Drupal is blocked