The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

EasyApache and "mysqlnd"

Discussion in 'EasyApache' started by Reado, Dec 25, 2009.

  1. Reado

    Reado Well-Known Member

    Joined:
    Sep 8, 2009
    Messages:
    161
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    United Kingdom
    cPanel Access Level:
    DataCenter Provider
    Glad to see PHP 5.3.1 is now featured in EasyApache, thanks cPanel!

    However there isn't an option to enable mysqlnd with the PHP build via EA. I have checked the configure options via phpinfo() and cannot see mysqlnd being compiled with PHP.

    Any ideas?
     
  2. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    Well, I am not sure if the mysqlnd option is provided in EA but just wanted to inform you that PHP 5.3 was quite buggy so make sure all bugs are cleared up before compiling it.
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    The mysqlnd extension does not handle the full authentication schemes that the regular mysql PHP extension handles. In particular mysqlnd has issues supporting the short passwords used by older versions of MySQL. Until mysqlnd is a drop-in replacement for the mysql extension in this aspect support for this newer extension is not provided.
     
  4. tandyuk

    tandyuk Active Member

    Joined:
    Dec 18, 2003
    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    8
    Is there a way to manually enable this?

    For systems where we *know* that there are no short passwords in use, and are specifically trying to take advantage of php 5.3's enhanced features this would be a BIG benefit.

    You could easily add a checkbox to easyapache's exhaustive options list, unchecked by default, with a big fat warning next to it about potentially breaking on older systems.
    Then a server admin can decide whether to enable it or not.
     
  5. Reado

    Reado Well-Known Member

    Joined:
    Sep 8, 2009
    Messages:
    161
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    United Kingdom
    cPanel Access Level:
    DataCenter Provider
    You can easily enable this - I've done it across all my servers and have never encountered a problem.

    To do so, in SSH, create of edit the following file:

    /var/cpanel/easy/apache/rawopts/all_php5

    Add the following line to that file:

    --with-mysqli=mysqlnd

    Save the file, launch EasyApache and recompile as normal. I'm assuming you're using mysqli, else I think you'll need to use "--with-mysql=mysqlnd" instead.

    Once done, run a PHP file with phpinfo() as the code to check the extension has been enabled.
     
Loading...

Share This Page