SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Addict
    Join Date
    Nov 2004
    Location
    New Jersey
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Should I fear upgrading from 4.0.27 to 4.1?

    Are there any reasons that I should not upgrade from 4.0.27 to 4.1? (on a Linux server)

    For instance, any known issues regarding existing PHP code getting broken, or character encoding issues, SQL backwards compatibility, and so forth.

    I will do a backup first as something can always go wrong, but I have many dozens of sites on the server in question, and if there are any problems caused by the upgrade I might not even find out about them.

    Are there any known issues that I should be aware of, or any reasons to decide against upgrading?

  2. #2
    SitePoint Zealot
    Join Date
    Oct 2004
    Location
    Sydney, Australia
    Posts
    175
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    http://dev.mysql.com/doc/refman/5.0/en/old-client.html

    This deals with a specific client issue that you will face when updating pre 4.1

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    the only major issue is the password encryption scheme. this is in contrast to mysql 5 where the SQL parser takes your SQL a bit more literally, making certain combinations of JOIN's no longer valid. there were also come changes to the DECIMAL and TIMESTAMP data types.

  4. #4
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    longneck didn't they make significant changes to character sets and collations too? or was that from 3.x to 4?

  5. #5
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Why don't you just try it, test, and find if *you* will have any problems?

    It's not like you have a single box license. Copy your data, install it on your computer or a spare dev box, and test your site.

  6. #6
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by guelphdad View Post
    longneck didn't they make significant changes to character sets and collations too? or was that from 3.x to 4?
    yes, there were LOTS of changes i didn't mention. however, only the ones i've mentioned are the ones that typically affect users who upgrade.

    the collation support doesn't really come in to play because most people don't change the collation in 3.x or 4.0, and the default collation in 4.1+ is compatible with the earlier defaults.

  7. #7
    SitePoint Addict
    Join Date
    Nov 2004
    Location
    New Jersey
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks all.

    So what exactly should I do to update the passwords for all users on the server? Do I need to know their current passwords?

    And I have to do this after the upgrade, right?

  8. #8
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    you don't have to upgrade the passwords right away. the mysql server knows which are stored in the old format, and which are stored in the new format. therefore, you can keep using the user accounts without updating the password.

    note that you will need to upgrade your mysql client if you want to use the new passwords. otherwise, when you set up a new user, after you create the user you'll have to reset the password using the old_password() function.

  9. #9
    SitePoint Addict
    Join Date
    Nov 2004
    Location
    New Jersey
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by longneck View Post
    you don't have to upgrade the passwords right away. the mysql server knows which are stored in the old format, and which are stored in the new format. therefore, you can keep using the user accounts without updating the password.

    note that you will need to upgrade your mysql client if you want to use the new passwords. otherwise, when you set up a new user, after you create the user you'll have to reset the password using the old_password() function.
    Thanks, let me see if I understand this correctly - nothing needs to be done for existing users, but any new users (if they want to be compatible with external 4.0 clients) need to reset the password?

  10. #10
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    correct.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •