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 PHP5 failing mysql tests

Discussion in 'EasyApache' started by n3tph4t, Nov 25, 2007.

  1. n3tph4t

    n3tph4t Active Member

    Joined:
    Jan 31, 2004
    Messages:
    39
    Likes Received:
    0
    Trophy Points:
    6
    I have been running PHP4, MySQL4 and Apache 1 successfully for a number of years. I am now having a problem after deciding to update apache and PHP:

    /scripts/easyapache
    Php 5.2.3
    apache 2.0
    GD,TTF,exif,mysql,mysqlsystem,mysqli,etc etc

    Taken from /usr/local/cpanel/logs/easy/apache/build.1195986691
    Code:
    -- Begin opt 'Mysql' --
            -- Begin dryrun test 'mysql compilation test' --
            dryrun test 'mysql compilation test' did not return true
    
            !! Dry run failed for 'Cpanel::Easy::PHP5::Mysql' skipping option !!
    
    -- Begin opt 'Mysql of the system' --
            -- Begin dryrun test 'mysql compilation test' --
            dryrun test 'mysql compilation test' did not return true
    
            !! Dry run failed for 'Cpanel::Easy::PHP5::MysqlOfSystem' skipping option !!
    
    -- Begin opt 'MySQL "Improved" extension.' --
            -- Begin dryrun test 'mysql compilation test' --
            dryrun test 'mysql compilation test' did not return true
    
            !! Dry run failed for 'Cpanel::Easy::PHP5::Mysqli' skipping option !!
    

    For various reasons based on reading different posts I have:
    /scripts/mysqlup - success
    /scripts/installzendopt - success (the original reason for updating was that zend didn't seem to function correctly)
    tail -10 /var/log/mysqld.log - nothing interesting in the log
    /scripts/realperlinstaller --force DBD::mysql - success
    I have recompiled apache 4 or 5 times without success

    Currently none of my sites are able to connect to mysql databases (phpmyadmin, all blogs, billing systems etc)

    Any help would be greatly appreciated
     
  2. n3tph4t

    n3tph4t Active Member

    Joined:
    Jan 31, 2004
    Messages:
    39
    Likes Received:
    0
    Trophy Points:
    6
    Ok, I have obviously been trying to continue my investigations into this.

    mysql -u root -p -Bse 'show databases' shows that all the databases are still there and that mysql is running.

    It looks to me (the completely uninitiated) that the php modules?! required during the apache build for php files to hoot into db's are missing.

    Based on what I have provided above it seems they were not installed because the files failed a pre-build test.

    So, has anyone experienced this and can provide some advice? If not, can you recommend a way of finding out the reason for the dry-run fails (i.e missing modules/files/configs) si that I can try to work around them.

    Thanks muchly :)
     
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    How about going a bit slower, upgrading 1 thing at a time instead of going from Apache 1, PHP 4 and MySQL 4 to Apache 2.0, PHP 5.2.x and MySQL 5 all at once.

    First, try the upgrade from MySQL 4 to MySQL 5. Be sure to have a database backup in case things don't work out as you can't readily convert back to MySQL 4.

    Next, just Upgrade Apache from Apache 1 to Apache 2.0

    Then upgrade PHP with just the bare essentials (without exif, GD, mysqli etc.). See if that works.

    If so, then you can add more modules to PHP as you see fit.

    At the very least, this should help you more easily determine what is causing the build to fail at the moment since you're doing fewer things simultaneously.
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    It's failing on this:

    Code:
    dryrun test 'mysql compilation test' did not return true
    
    which means EA3 was unable to compile a small test program. Possibly a problem with the MySQL headers. What is your operating system? Are you using the MySQL RPMs provided by cPanel (not relevant if using FreeBSD)?
     
  5. n3tph4t

    n3tph4t Active Member

    Joined:
    Jan 31, 2004
    Messages:
    39
    Likes Received:
    0
    Trophy Points:
    6
    Hey David,
    I probably didn't explain myself very well, i tried combinations. Starting with an upgrade of all three and on each fail I worked back until I was simply making configuration changes.

    It's now resolved, see next post.
     
  6. n3tph4t

    n3tph4t Active Member

    Joined:
    Jan 31, 2004
    Messages:
    39
    Likes Received:
    0
    Trophy Points:
    6
    Thanks Kenneth, I picked up on that but didn't know how to see what the compilation test consisted of?!

    I was running an EOL RH OS and have now upgraded to CentOS Enterprise and have updated and recompiled with ease.

    Moral of the story: update your OS lol

    Thanks very much for the input guys.
     
Loading...

Share This Page