Want more timely Centmin Mod News Updates?
Become a Member

PHP-FPM PHP stopped working after yum update

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Sos, Dec 5, 2018.

  1. Sos

    Sos New Member

    8
    2
    3
    Dec 4, 2018
    Ratings:
    +2
    Local Time:
    3:44 PM
    1.15.7
    Hey community I just updated with yum and now when I access the site afarockymountain.com I get a 500 error that the item is not available. I have a different url that uses only html and it works so I’m thinking something happened to where the update broke php some how.

    Any thoughts/ideas that would be appreciated
     
  2. eva2000

    eva2000 Administrator Staff Member

    37,261
    8,140
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,532
    Local Time:
    8:44 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Please fill in any relevant information that applies to you:
    • CentOS Version: i.e. CentOS 6 32bit or 64bit / CentOS 7 64bit ?
    • Centmin Mod Version Installed: i.e. 123.08stable or 123.09beta01
    • Nginx Version Installed: i.e. 1.15.3
    • PHP Version Installed: i.e. 5.6.37, 7.0.31, 7.1.21, 7.2.9
    • MariaDB MySQL Version Installed: i.e. 10.0.x or 10.1.xx or 10.2.xx
    • When was last time updated Centmin Mod code base ? : i.e. run centmin.sh menu option 23 submenu option 2 or cmupdate command
    • Persistent Config: Do you have any persistent config file options set in /etc/centminmod/custom_config.inc ? You can check via this command:
      Code (Text):
      cat /etc/centminmod/custom_config.inc
      

      Post output in CODE tags.
     
  3. Sos

    Sos New Member

    8
    2
    3
    Dec 4, 2018
    Ratings:
    +2
    Local Time:
    3:44 PM
    1.15.7
    Please fill in any relevant information that applies to you:
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed:123.09beta01
    • Nginx Version Installed: 1.15.7
    • PHP Version Installed: 7.2.10
    • MariaDB MySQL Version? (Not sure)
    • When was last time updated Centmin Mod code base ? : 12/5/18
    • Persistent code?:
    Code:
    LETSENCRYPT_DETECT='y'
    DISABLE_TLSONEZERO_PROTOCOL='y'
    NGINX_UPDATEMAINTENANCE='y'
    PHP_UPDATEMAINTENANCE='y'
    MARIADB_UPDATEMAINTENANCE='y'
    So when trying to get the database version I get this:

    Code:
    Dec 05 05:33:27 main.printsos.com mysqld[8439]: 2018-12-05  5:33:27 140063325821184 [Note] InnoDB: 128 rollback segment(s) are active.
    Dec 05 05:33:27 main.printsos.com mysqld[8439]: 2018-12-05  5:33:27 140063325821184 [Note] InnoDB: Waiting for purge to start
    Dec 05 05:33:28 main.printsos.com mysqld[8439]: 2018-12-05  5:33:28 140063325821184 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.41-84.1 started; log sequence number 1261435289
    Dec 05 05:33:28 main.printsos.com mysqld[8439]: 2018-12-05  5:33:28 140063325821184 [Note] Plugin 'FEEDBACK' is disabled.
    Dec 05 05:33:28 main.printsos.com mysqld[8439]: 2018-12-05  5:33:28 140063325821184 [ERROR] /usr/sbin/mysqld: unknown variable 'server_audit_logging=1'
    Dec 05 05:33:28 main.printsos.com mysqld[8439]: 2018-12-05  5:33:28 140063325821184 [ERROR] Aborting
    Dec 05 05:33:31 main.printsos.com systemd[1]: mariadb.service: main process exited, code=exited, status=7/NOTRUNNING
    Dec 05 05:33:31 main.printsos.com systemd[1]: Failed to start MariaDB 10.1.37 database server.
    Dec 05 05:33:31 main.printsos.com systemd[1]: Unit mariadb.service entered failed state.
    Dec 05 05:33:31 main.printsos.com systemd[1]: mariadb.service failed.
    Which is probably one of the many other issues that may have taken place.
     
  4. eva2000

    eva2000 Administrator Staff Member

    37,261
    8,140
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,532
    Local Time:
    8:44 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    that's the problem - did you install/run tools/audit.sh mariadb audit logging from Centmin Mod Auditd Support Added In Latest 123.09beta01 at any time ?

    might want to remove those settings from /etc/my.cnf seems not compatible anymore ??
    Code (Text):
    server_audit_logging=1
    server_audit_events=connect,query_dml
    

    you can do that manually

    strangely, i have no problems with those settinsg in /etc/my.cnf on MariaDB 10.1.37
     
    • Like Like x 1
  5. Sos

    Sos New Member

    8
    2
    3
    Dec 4, 2018
    Ratings:
    +2
    Local Time:
    3:44 PM
    1.15.7
    Bravo thank you for the help. Site is back up and working.
     
    • Like Like x 1
..