Welcome to Centmin Mod Community
Register Now

phpmyadmin down after ioncube installation

Discussion in 'Add Ons' started by noly, Dec 6, 2017.

  1. noly

    noly Member

    106
    16
    18
    Jul 24, 2017
    Germany
    Ratings:
    +28
    Local Time:
    3:53 AM
    1.18.x
    10.2.x
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 123.09beta01
    • Nginx Version Installed: i.e. 1.13.7
    • PHP Version Installed: 7.0.26
    • MariaDB MySQL Version Installed: 10.1.29
    • When was last time updated Centmin Mod code base ? : fresh installation
    • Persistent Config:

      cat /etc/centminmod/custom_config.inc


      PHP:
      AUTO_GITUPDATE='y'        # (default=n)
      NGINX_VERSION='1.13.7'        # Use this version of Nginx
      NGINX_PAGESPEED='y'            # (default=n)
      NGXDYNAMIC_NGXPAGESPEED='y'    # (default=n)
      NGXDYNAMIC_BROTLI='y'        # (default=n)
      NGINX_LIBBROTLI='y'            # (default=n)
      NGINX_HTTP2='y'                # (default=y)
      NGINX_MP4='y'                # Nginx MP4 Module http://nginx.org/en/docs/http/ngx_http_mp4_module.html (default=n)
      NGINX_MAXERRBYTELIMIT='4096'    # https://goo.gl/Poijr4 (default=2048)
      LETSENCRYPT_DETECT='y'        # (default=n)
      AUDITD_ENABLE='y' # log commands
      AUDIT_MARIADB='y' #
      PHP_VERSION='7.0.26'
      AUTODETECPHP_OVERRIDE='n'    # when enabled, php updates will always reinstall all php extensions even if minor php version
      PHPIMAGICK_ALWAYS='y'        # imagick php extension is always reinstalled on php recompiles
      PHP_PGO='y'                    # boost php performance: https://software.intel.com/en-us/blogs/2015/10/09/pgo-let-it-go-php (default=n)
      PHPDEBUGMODE='n'            # --enable-debug PHP compile flag
      PHPFINFO='y'                 # Disable or Enable PHP File Info extension ## modx dont like if n
      PHPIONCUBE='y'              # Disable or Enable Ioncube Loader via addons/ioncube.sh
      NGINX_UPDATEMAINTENANCE=y
      PHP_UPDATEMAINTENANCE
      =y
      MARIADB_UPDATEMAINTENANCE
      =y
      8h of debugging before i came here to look for help. -_-

      After a fresh install of centmin and phpmyadmin everything runs smooth but after installing ioncube via:

      Code:
      cd /usr/local/src/centminmod/addons/
      chmod 0700 ioncube.sh
      ./ioncube.sh

      checking if ioncube is installed:

      Code:
      php --ri 'ionCube Loader'
      output:

      After that when trying to access phpmyadmin all i see after a very long loading time is a blank screen:

      PMA blank screen

      Output of /var/log/messages lists these errors:

      var log messages ยท GitHub

      Can someone please help me? :-(
     
  2. wmtech

    wmtech Active Member

    167
    44
    28
    Jul 22, 2017
    Ratings:
    +125
    Local Time:
    3:53 AM
    Ioncube is PHP, so it would help to look into the PHP/Webserver error log files ...
     
  3. noly

    noly Member

    106
    16
    18
    Jul 24, 2017
    Germany
    Ratings:
    +28
    Local Time:
    3:53 AM
    1.18.x
    10.2.x
    Thank you @wmtech for pointing me to the right direction.

    After checking all log files i found the reason for pma being so slow here: /usr/local/nginx/logs/error.log

    Code:
    2017/12/06 13:17:21 [error] 11011#11653: [ngx_pagespeed 1.13.35.1-0] PageSpeed Serf fetch failure rate extremely high; only 0 of 18 recent fetches fully successful; is fetching working?
    2017/12/06 13:18:11 [alert] 10549#10549: worker process 11011 exited on signal 9
    2017/12/06 13:19:14 [alert] 10549#10549: worker process 10805 exited on signal 9
    2017/12/06 13:41:06 [alert] 22733#22733: worker process 22735 exited on signal 9
    2017/12/06 13:41:46 [alert] 22733#22733: worker process 22734 exited on signal 9
    2017/12/06 13:42:46 [alert] 22733#22733: worker process 22868 exited on signal 9
    
    Turns out that pagespeed was handling pma as well. I have then added

    PHP:
    pagespeed unplugged;
    to .. /conf.d/phpmyadmin_ssl.conf and that solved the issue.

    The title of this thread should there for be changed to an pagespeed 1.13.5.1 issue since ioncube obviously wasn't the matter.

    Even that the reason is now isolated i still have no absolutely no clue why this didn't happen on another server whith the same exact setup on a fresh installation and pscontrol on & pagespeed on with version 1.13.35.1-0.

    EDIT:
    That was because on one server pscontrol wasn't activated with pcontrol on;

    Anyway....since pagespeed 1.13.35.1. is still in beta i guess it might make sense to change back to the release 1.12.34.3-stable.

    I added these lines to my custom_config.inc

    PHP:
    NGXPGSPEED_VER='1.12.34.3-stable'
    NGINX_PAGESPEEDPSOL_VER='1.12.34.3'
    ..but that didn't change the installed pagespeed version after recompiling nginx & php.

    How can i downgrade pagespeed back to the stable version?
     
  4. eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,672
    Local Time:
    11:53 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    12
    123.09beta01 had an update to update pscontrol for 1.13.35.1 changes and to support downgrading back to previous version of ngx_pagespeed. But update for pscontrol doesn't happen until you first update centmin mod code via centmin.sh menu option 23 submenu option 2 or via new cmupdate ssh command and then second, re-run centmin.sh to auto apply pscontrol changes
     
  5. eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,672
    Local Time:
    11:53 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    it should of make sure you add the persistent config versions to custom_config.inc BEFORE you run centmin.sh menu option 4. Adding persistent config versions/variables AFTER centmin.sh runs won't allow centmin.sh to pick up the persistent config changes
     
  6. noly

    noly Member

    106
    16
    18
    Jul 24, 2017
    Germany
    Ratings:
    +28
    Local Time:
    3:53 AM
    1.18.x
    10.2.x
    Thank you @eva2000 but i can confirm that uploading the persistent config is always the first thing i do after a fresh centminmod installation.

    The problem is neither related to ionCube nor pagespeed version 1.13.35.1.
    Since i have discovered another thread on centminmod which my topic relates to i will continue this thread there:

    Nginx uses all resources and then crashes when pagespeed is enabled