sql-mode="NO_ENGINE_SUBSTITUTION"

Discussion in 'Installation/Configuration' started by carpman, Oct 22, 2016.

  1. carpman

    carpman Member

    Hi, have done a install and setup using following guide:
    https://www.howtoforge.com/perfect-server-debian-wheezy-apache2-bind-dovecot-ispconfig-3-p5

    though changed mysql for mariadb, now when i try and do an install for ISPconfig i get error:

    MySQL database to create [dbispconfig]:
    MySQL charset [utf8]:
    PHP Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50550 Library:100118 in /home/admin/tmp/ispconfig3_install/install/install.php on line 235
    PHP Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50550 Library:100118 in /home/admin/tmp/ispconfig3_install/install/lib/mysql.lib.php on line 79
    Wrong SQL-mode. You should use NO_ENGINE_SUBSTITUTION. Add
    sql-mode="NO_ENGINE_SUBSTITUTION"
    to the mysqld-section in your mysql-config and restart mysqld afterwards


    any ideas?

    thanks
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    "You should use NO_ENGINE_SUBSTITUTION. Add sql-mode="NO_ENGINE_SUBSTITUTION" to the mysqld-section in your mysql-config and restart mysqld afterwards"

    apt-get install php5-mysqlnd
     
  3. LotNoMore

    LotNoMore Member

    I use the automated install script to do the installation on a server running Ubuntu 16.10 Server x86_64
    https://www.howtoforge.com/tutorial/ispconfig-automated-install-script/
    At the end I got the following messages.... should I worry about anything?
     
  4. LotNoMore

    LotNoMore Member

    The real problem is... I cannot connect to your ISPConfig installation at https :// server1.angelright.com:8080 or https :// IP_ADDRESS:8080

    Hmmm... I could be the static IP problem... I skipped that :-(
     
    Last edited: Apr 8, 2017
  5. LotNoMore

    LotNoMore Member

    Well, I have set up the static IP and run the automated install script again. Same problem. Does that mean I should do the install MANUALLY? :-(
     

Share This Page