Join the community today
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

    14
    2
    3
    Dec 4, 2018
    Ratings:
    +3
    Local Time:
    11:07 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

    40,661
    9,034
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,908
    Local Time:
    3:07 PM
    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

    14
    2
    3
    Dec 4, 2018
    Ratings:
    +3
    Local Time:
    11:07 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.
     
    style="display:inline-block;min-width:400px;max-width:970px;width:95%;height:90px" data-ad-client="ca-pub-6669518204467592" data-ad-slot="4024536743" data-ad-format="auto">
  4. eva2000

    eva2000 Administrator Staff Member

    40,661
    9,034
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,908
    Local Time:
    3:07 PM
    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

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