MySQL 5.1 & PHP 5.2.14

  • Thomas52

    Thomas52 - 2010-10-18

    My server notified me:

    We will be updating some components on the server on October 20th. First, MySQL will be updated from 5.0 to 5.1 series to keep the most currently available version for cPanel for our customers. We have backups on hand for all databases in the event of any issues with the upgrade process.
    Please note MySQL prior to 5.1 has limited usernames to 16 characters. In those versions of MySQL, when a login username longer than 16 characters is sent to the server it is silently truncated to the 16 characters limit. In MySQL 5.1, all characters submitted for the username are checked during authentication. This change means that any user submitting more than 16 characters as their login username will fail to authenticate once the server is upgraded. To ensure the upgrade goes smoothly for you, if your sites use database logins longer than 16 characters, please correct database connection details to only send the first 16 characters of the current login usernames by truncating them.
    Next, if your server have PHP 4 installed, we will be recompiling Apache and PHP to make PHP 5 the default on the server rather than PHP 4. On the servers with PHP 4 where PHP 5 has not been present, it will be added. If your server already runs PHP 5 only, PHP 5 will be just updated to the latest release and no changes will be required from your side.
    This change  on making PHP 5 the default should be unnoticeable other than those who are using the path to PHP for cron jobs on server with PHP 4. If you are, please note that the new path will be the following for PHP 4 binaries (where PHP 4 is installed):
    PHP 5 will be also updated to the 5.2.14 version during this process.

    I certainly can't foresee any problems here; all goods news so far.  Anyone see anything I'm missing?

  • Stephen Arnold

    Stephen Arnold - 2010-10-19

    Not sure about your question. Certainly there will be minor tweak necessary over the long run as the underlying software evolves, and this may prove difficult since there seems to be few developers here - at the moment. I've been using the following server setup for a while, all without significantly troublesome issues: MacOS-X 10.6.4, Apache 2.2.14, PHP 5.3.2, MySQL 5.1.50

  • Thomas52

    Thomas52 - 2010-10-21

    Last yesterday I get this message:

    ERROR 256: PDO/mysql is not installed.

    I can verify there IS a db installed, but I guess pgv can't 'find' it?  Does this mean install everything again?  Create a new db?  How do I "INSTALL" PDO/mqsql?  Th eold brain can't get a handle on this.

  • Lester Caine

    Lester Caine - 2010-10-21

    Message is saying that 'mqsql' PDO drive is not installed. I presume that should be mysql ? You need to check your PHP installation and cneck that pdo and the pdo_mysql are actually enabled in your php.ini file.

  • Thomas52

    Thomas52 - 2010-10-21

    Yes & yes.  Two simples lines to the php.ini & all is well.  Thank you.


Log in to post a comment.