Welcome to Centmin Mod Community
Become a Member

MariaDB WHMCS and MySQL issues

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Robust, Jun 14, 2015.

Tags:
  1. Robust

    Robust Member

    49
    3
    8
    Jun 14, 2015
    Ratings:
    +5
    Local Time:
    9:02 PM
    1.9.7
    10.1
    Alright.

    @eva2000 Trying to install WHMCS and running into a lot of problems.

    Here's my ticket to WHMCS:
    and

    I'm using PHP 5.6 using the latest ioncube loader which is meant to have support for PHP 5.6 with backwards compatibility. WHMCS is not giving an error saying there are ioncube problems though. ioncube self installed, your script doesn't support 5.6.

    Edit: Tried with PHP 5.4 using PHP 5.4 ioncube loaders and also using Centmin Mod provided ioncube loaders.

    The database gives errors during install until I visit the homepage, which gives an error saying tables are corrupt. Then I can continue the install. Even when I complete the install, I get crit errors that WHMCS can't connect to the database.

     
    Last edited: Jun 15, 2015
  2. eva2000

    eva2000 Administrator Staff Member

    54,868
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    9:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Centmin Mod is provide as is, so short of scripted related bugs or issues, any further optimisation to the web stack components - nginx, php-fpm, mariadb mysql, csf firewall etc or web app specific configurations are left to the Centmin Mod user to deal with. So I do not provide any free support for such. Would help if you provided the exact error messages too.

    However, Centmin Mod users are free to help each other out and ask questions or give answers on this community forum. My hopes are that this community forum evolves so that more veteran long time Centmin Mod users help new Centmin Mod users out :)

    More info would be nice though
    • Server or VPS details ? XEN, KVM, OpenVZ, VMWare or dedicated server ? OS ? CentOS 6.6 or 7.1 ? 32bit or 64bit ?
    • What version of Centmin Mod ? .07 stable or .08 beta03 ?
    • Was it fresh install or upgrade ?
    • How long ago did you install Centmin Mod ?
    • There's numerous code changes, bug fixes over time, so ensure you have latest Centmin Mod code installed by upgrading your Centmin Mod code as instructed below.

    Troubleshooting Initial Install



    To troubleshoot initial installation, you need to check the initial install log at /root/centminlogs. You can see full details at How to troubleshoot Centmin Mod initial install issues | Centmin Mod Community

    MySQL Error Logs



    You can check your mysql error log which is listed along with all other log file locations as per How to troubleshoot Centmin Mod initial install issues (/var/log/mysqld.log) for clues.

    Upgrading Centmin Mod Code to Latest Version



    Upgrading Centmin Mod involves 2 parts.
    1. Upgrading the actual Centmin Mod code which you downloaded via zip file or via github. This is heart of Centmin Mod where the code is the engine that runs centmin.sh shell based menu and all the automation you're accustomed to.
    2. Upgrade software that Centmin Mod installed or manages. For this part following outline at Upgrade - How to upgrade Centmin Mod is best.
    So essentially, you can upgrade from .07 to .08 in place, but not everything is upgraded as some things like server initial environment setup isn't changed i.e. how swap, tmp setup and allocation are created etc. The main parts from part 2 above are what in place upgrades do i.e. Nginx and PHP-FPM compilation and config/settings parameters and MariaDB version from 5.5 to 10.0.x. If you want the full environment changed including tmp and swap setup to .08's configuration, then you would need a fresh OS install and fresh .08 initial install. You can think of it like upgrading Windows 7 to Windows 8. An in place upgrade will upgrade code but won't change your computer environment from when you installed Windows 7 i.e. disk configuration and partition sizes won't change from when you initially installed Windows 7. Only way to change that would be fresh Windows 8 install.

    There's 3 ways you can upgrade your .07 stable or .08 beta02 code you have on your server. They are outlined in respective upgrade sections of the first posts linked below:
    1. For .07 stable 1st post see section on upgrades Install - Centmin Mod 1.2.3-eva2000.07 stable install
    2. For .08 beta 02 1st post see section on upgrade to latest code CentOS 7.x - How to help test .08 CentOS 7 Betas with Github code ?
    3. For either .07 stable or .08 beta02 via github command line Upgrade - Working with git command line for updating Centmin Mod local copies
    Github commit log for
     
  3. Robust

    Robust Member

    49
    3
    8
    Jun 14, 2015
    Ratings:
    +5
    Local Time:
    9:02 PM
    1.9.7
    10.1
    It is the latest version, installed yesterday. No problems in installation, 99% sure.

    • Server or VPS details ? KVM
      OS ? CentOS 6.6 64bit
    • What version of Centmin Mod ? .07 stable or .08 beta03 ? Centmin Mod v1.2.3-eva2000.07
    • Was it fresh install or upgrade ? Fresh
    • How long ago did you install Centmin Mod ? 2 days
    • There's numerous code changes, bug fixes over time, so ensure you have latest Centmin Mod code installed by upgrading your Centmin Mod code as instructed below.
    WHMCS support said:

     
  4. eva2000

    eva2000 Administrator Staff Member

    54,868
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    9:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  5. Robust

    Robust Member

    49
    3
    8
    Jun 14, 2015
    Ratings:
    +5
    Local Time:
    9:02 PM
    1.9.7
    10.1
    @eva2000 As far as errors go

    /var/log/mysqld.log has no errors in it

    Edit: just read new response, will do it
     
  6. Robust

    Robust Member

    49
    3
    8
    Jun 14, 2015
    Ratings:
    +5
    Local Time:
    9:02 PM
    1.9.7
    10.1
    Already tried 5.4, didn't help, and I used your loaders. I already have the PHP 5.4 loaders installed as well, the ioncube wizard has all the loaders. Just need to edit ioncube.ini to choose one.

    Latest ionCube has backwards compatibility (5.0.7). It should work fine. I'm using PHP 5.6 with latest ionCube and it's currently working. Just the way I managed to install it was sketchy, as mentioned above, and perhaps not definitive.
     
  7. Robust

    Robust Member

    49
    3
    8
    Jun 14, 2015
    Ratings:
    +5
    Local Time:
    9:02 PM
    1.9.7
    10.1
    Alright, worked now. Recreated the database, all good. Thank you.
     
  8. eva2000

    eva2000 Administrator Staff Member

    54,868
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    9:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    so what fixed it ? reinstall ioncube after downgrade to PHP 5.4 ?
     
  9. Robust

    Robust Member

    49
    3
    8
    Jun 14, 2015
    Ratings:
    +5
    Local Time:
    9:02 PM
    1.9.7
    10.1
    Nothing, drop database and reinstall just worked. Still using 5.6 with ioncube 5.0.7.
     
  10. eva2000

    eva2000 Administrator Staff Member

    54,868
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    9:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    strange then.. glad it works now :)
     
  11. Steve Tozer

    Steve Tozer Member

    70
    42
    18
    Jul 28, 2014
    South Wales, UK
    Ratings:
    +49
    Local Time:
    11:02 AM
    1.91
    10.0.19
    :confused: Seems odd how WHMCS is working with PHP 5.6 as its not supported, unless the OP is using the beta of whmcs.
     
  12. eva2000

    eva2000 Administrator Staff Member

    54,868
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    9:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yes i thought WHMCS only worked with <= PHP 5.4
     
  13. Robust

    Robust Member

    49
    3
    8
    Jun 14, 2015
    Ratings:
    +5
    Local Time:
    9:02 PM
    1.9.7
    10.1
    ionCube latest version has backwards compatibility support. We're using v5 Stable version, not the v6 Beta.
     
  14. eva2000

    eva2000 Administrator Staff Member

    54,868
    12,239
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,810
    Local Time:
    9:02 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Good to know :)