Discover Centmin Mod today
Register Now

Xenforo Xenforo 2.1 Beta 1 Install On Centmin Mod 123.09beta01 LEMP Stack

Discussion in 'Forum software usage' started by eva2000, Nov 21, 2018.

Thread Status:
Not open for further replies.
  1. eva2000

    eva2000 Administrator Staff Member

    37,261
    8,140
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,532
    Local Time:
    9:42 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Xenforo 2.1 Beta 1 has been publicly released and this is my first attempt at installing it on Centmin Mod 123.09beta01 with default PHP 7.2 installer and with optional PHP 7.2+ Argon2 password hash algorithm support.

    Xenforo 2.1 Related Info Links


    Centmin Mod Related Info & Reading Links


    Centmin Mod 123.09beta01 LEMP Fresh Install Steps



    Steps to setup persistent config file /etc/centminmod/custom_config.inc to setup variables which enable Nginx Brotli compression, if you want PHP Argon2/libsodium, PHP PGO, MariaDB 10.3 default install for MySQL server, and enable free Letsencrypt SSL certificates with dual RSA + ECC SSL certificate support.
    Code (Text):
    # create initial persistent config file to override centmin.sh defaults
    # https://centminmod.com/upgrade.html#persistent
    mkdir -p /etc/centminmod
    touch /etc/centminmod/custom_config.inc
    
    # enable PHP Argon2 support
    # https://community.centminmod.com/threads/14933/
    echo "PHP_ARGON='y'" >> /etc/centminmod/custom_config.inc
    
    # enable brotli compression https://community.centminmod.com/threads/10688/
    echo "NGINX_LIBBROTLI='y'" >> /etc/centminmod/custom_config.inc
    echo "NGXDYNAMIC_BROTLI='y'" >> /etc/centminmod/custom_config.inc
    
    # boost PHP 7 performance by enabling Profile Guided Optimisation flag
    # https://centminmod.com/perf/
    # echo "PHP_PGO='y'" >> /etc/centminmod/custom_config.inc
    
    # mariadb 10.3 default install for private test server testing
    echo "MARIADB_INSTALLTENTHREE='y'" >> /etc/centminmod/custom_config.inc
    
    # install centmin mod latest beta with php-fpm 7.2 default
    # https://community.centminmod.com/threads/centmin-mod-09-beta-branch-testing.4128/
    yum -y update; curl -O https://centminmod.com/betainstaller72.sh && chmod 0700 betainstaller72.sh && bash betainstaller72.sh
    
    # enable letsencrypt ssl certificate + dual RSA+ECDSA ssl certs https://centminmod.com/acmetool/
    echo "LETSENCRYPT_DETECT='y'" >> /etc/centminmod/custom_config.inc
    echo "DUALCERTS='y'" >> /etc/centminmod/custom_config.inc
    


    Create MySQL database name, database username and password via addons/mysqladmin_shell.sh script
    Code (Text):
    cmdir
    cd addons
    ./mysqladmin_shell.sh createuserdb YOURDBNAME YOURDBUSERNAME YOURDBPASSWORD
    

    Code (Text):
    ./mysqladmin_shell.sh createuserdb YOURDBNAME YOURDBUSERNAME YOURDBPASSWORD
    --------------------------------------------------------------
    Basic MySQL Admin - create mysql user & databases
    --------------------------------------------------------------
    --------------------------------------------------------------
    
    Grants for [email protected]
    GRANT USAGE ON *.* TO 'YOURDBUSERNAME'@'localhost' IDENTIFIED BY PASSWORD '*A70F5C74427B819DA658D6B519B1A6949139ED4A'
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `YOURDBNAME`.* TO 'YOURDBUSERNAME'@'localhost'
    
    Ok: MySQL user: YOURDBUSERNAME MySQL database: YOURDBNAME created successfully
    


    Create Nginx Site Vhost Account



    You can use centmin.sh menu option 2 or nv command line to create. I usually use nv command line.

    nv command line options
    Code (Text):
    nv
    
    Usage: /usr/bin/nv [-d yourdomain.com] [-s y|n|yd|le|led|lelive|lelived] [-u ftpusername]
    
      -d  yourdomain.com or subdomain.yourdomain.com
      -s  ssl self-signed create = y or n or https only vhost = yd
      -s  le - letsencrypt test cert or led test cert with https default
      -s  lelive - letsencrypt live cert or lelived live cert with https default
      -u  your FTP username
    
      example:
    
      /usr/bin/nv -d yourdomain.com -s y -u ftpusername
      /usr/bin/nv -d yourdomain.com -s n -u ftpusername
      /usr/bin/nv -d yourdomain.com -s yd -u ftpusername
      /usr/bin/nv -d yourdomain.com -s le -u ftpusername
      /usr/bin/nv -d yourdomain.com -s led -u ftpusername
      /usr/bin/nv -d yourdomain.com -s lelive -u ftpusername
      /usr/bin/nv -d yourdomain.com -s lelived -u ftpusername
    

    Create yourdomain.com Nginx site vhost account with SSL = lelived for free Letsencrypt SSL cert and default to HTTP/2 HTTPS out of the box and use YOURFTPUSERNAME for desired pure-ftpd virtual FTP user.
    Code (Text):
    nv -d yourdomain.com -s lelived -u YOURFTPUSERNAME
    

    End result is Nginx site vhost created for yourdomain.com where:
    • Upload files to public web root at /usr/local/nginx/conf/conf.d/yourdomain.com.ssl.conf
    • Site log directory for access and error logs at /home/nginx/domains/yourdomain.com/log

    Installing Xenforo 2.1 Beta 1



    Installing Xenforo 2.1 Beta 1 requires uploading zip files to server. I usually upload the entire zip files to a staging directory i.e. created at /home/nginx/domains/yourdomain.com/zips and then extra the zip file on server as it's much faster than uploading individual files via FTP/SFTP.

    Example renaming xenforo 2.1 beta 1 zip file to xenforo_2.1-beta1.zip and uploading to /home/nginx/domains/yourdomain.com/zips, then unzipping zip and change file and directory permissions in upload directory contents to nginx user/group and then going into upload directory and copying all files and directories into your web root at /home/nginx/domains/yourdomain.com/public. Then chmod 077 the appropriate directories.
    Code (Text):
    cd /home/nginx/domains/yourdomain.com/zips
    unzip xenforo_2.1-beta1.zip
    chown -R nginx:nginx upload
    cd upload
    \cp -Rpf * /home/nginx/domains/yourdomain.com/public
    cd /home/nginx/domains/yourdomain.com/public
    chmod 0777 internal_data data
    

    Now all your Xenforo 2.1 beta 1 files from upload are in public web root of the Nginx site you created previously at /home/nginx/domains/yourdomain.com/public.

    Now using the instructions from above Info & Reading links you would create your Xenforo 2.1 nginx vhost site structured rules. Example for yourdomain.com for default HTTP/2 HTTPS Nginx site example like. Remove X-Robots-Tag header if you want search engines to index this site. If it's test site, you want to leave X-Robots-Tag header to prevent search engines from indexing this site.

    You would place this in your Nginx vhost site appropriate in /usr/local/nginx/conf/conf.d/yourdomain.com.ssl.conf or if you have non-HTTPS nginx vhost in /usr/local/nginx/conf/conf.d/yourdomain.com.conf. Replace the allow YOURISP_IPADDR with your ISP IP if you want to protect admin.php and restrict access or if not comment out with hash # in front all the allow/deny lines in admin.php content {}.
    Code (Text):
      add_header X-Robots-Tag "noindex, nofollow";
    
      location / {
      include /usr/local/nginx/conf/503include-only.conf;
    
    # block common exploits, sql injections etc
    #include /usr/local/nginx/conf/block.conf;
    
         index index.php index.html index.htm;
         try_files $uri $uri/ /index.php?$uri&$args;
    
      }
    
    location /admin.php {
    #     auth_basic "Private";
    #     auth_basic_user_file /usr/local/nginx/conf/htpasswd_admin_php;
            include /usr/local/nginx/conf/php.conf;
            allow 127.0.0.1;
            allow YOURISP_IPADDR;
            deny all;
    }
    
    location /install/data/ {
         internal;
    }
    
    location /install/templates/ {
         internal;
    }
    
    location /internal_data/ {
         internal;
    }
    
    location /library/ {
         internal;
    }
    
    # xenforo 2 uncomment / remove hash from next 3 lines
    location /src/ {
         internal;
    }
    


    Full nginx site vhost at /usr/local/nginx/conf/conf.d/yourdomain.com.ssl.conf with the Xenforo 2.1 beta1 rules in place for default HTTP/2 HTTPS Nginx vhost site.
    Code (Text):
    #x# HTTPS-DEFAULT
     server {
     
       server_name yourdomain.com www.yourdomain.com;
       return 302 https://yourdomain.com$request_uri;
       include /usr/local/nginx/conf/staticfiles.conf;
     }
    
    #       listen   80;
    #       server_name yourdomain.com www.yourdomain.com;
    #       return 302 https://$server_name$request_uri;
    
    server {
      listen 443 ssl http2 reuseport;
      server_name yourdomain.com www.yourdomain.com;
    
      include /usr/local/nginx/conf/ssl/yourdomain.com/yourdomain.com.crt.key.conf;
      include /usr/local/nginx/conf/ssl_include.conf;
    
      # cloudflare authenticated origin pull cert community.centminmod.com/threads/13847/
      #ssl_client_certificate /usr/local/nginx/conf/ssl/cloudflare/yourdomain.com/origin.crt;
      #ssl_verify_client on;
      http2_max_field_size 16k;
      http2_max_header_size 32k;
      # mozilla recommended
      ssl_ciphers ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS;
      ssl_prefer_server_ciphers   on;
      #add_header Alternate-Protocol  443:npn-spdy/3;
    
      # before enabling HSTS line below read centminmod.com/nginx_domain_dns_setup.html#hsts
      #add_header Strict-Transport-Security "max-age=31536000; includeSubdomains;";
      #add_header X-Frame-Options SAMEORIGIN;
      add_header X-Xss-Protection "1; mode=block" always;
      #add_header X-Content-Type-Options "nosniff" always;
      #add_header Referrer-Policy "strict-origin-when-cross-origin";
      #spdy_headers_comp 5;
      ssl_buffer_size 1369;
      ssl_session_tickets on;
     
      # enable ocsp stapling
      resolver 8.8.8.8 8.8.4.4 valid=10m;
      resolver_timeout 10s;
      ssl_stapling on;
      ssl_stapling_verify on;
    
    # ngx_pagespeed & ngx_pagespeed handler
    #include /usr/local/nginx/conf/pagespeed.conf;
    #include /usr/local/nginx/conf/pagespeedhandler.conf;
    #include /usr/local/nginx/conf/pagespeedstatslog.conf;
    
      # limit_conn limit_per_ip 16;
      # ssi  on;
    
      access_log /home/nginx/domains/yourdomain.com/log/access.log combined buffer=256k flush=5m;
      error_log /home/nginx/domains/yourdomain.com/log/error.log;
    
    #  include /usr/local/nginx/conf/autoprotect/yourdomain.com/autoprotect-yourdomain.com.conf;
      root /home/nginx/domains/yourdomain.com/public;
      # uncomment cloudflare.conf include if using cloudflare for
      # server and/or vhost site
      #include /usr/local/nginx/conf/cloudflare.conf;
      include /usr/local/nginx/conf/503include-main.conf;
      add_header X-Robots-Tag "noindex, nofollow";
    
      location / {
      include /usr/local/nginx/conf/503include-only.conf;
    
    # block common exploits, sql injections etc
    #include /usr/local/nginx/conf/block.conf;
    
         index index.php index.html index.htm;
         try_files $uri $uri/ /index.php?$uri&$args;
    
      }
    
    location /admin.php {
    #     auth_basic "Private";
    #     auth_basic_user_file /usr/local/nginx/conf/htpasswd_admin_php;
            include /usr/local/nginx/conf/php.conf;
            allow 127.0.0.1;
            allow YOURISP_IPADDR;
            deny all;
    }
    
    location /install/data/ {
         internal;
    }
    
    location /install/templates/ {
         internal;
    }
    
    location /internal_data/ {
         internal;
    }
    
    location /library/ {
         internal;
    }
    
    # xenforo 2 uncomment / remove hash from next 3 lines
    location /src/ {
         internal;
    }
    
      include /usr/local/nginx/conf/pre-staticfiles-local-yourdomain.com.conf;
      include /usr/local/nginx/conf/pre-staticfiles-global.conf;
      include /usr/local/nginx/conf/staticfiles.conf;
      include /usr/local/nginx/conf/php.conf;
     
      include /usr/local/nginx/conf/drop.conf;
      #include /usr/local/nginx/conf/errorpage.conf;
      include /usr/local/nginx/conf/vts_server.conf;
    }
    

    Note, I commented out the security header for 'nosniff' as it seems XF 2.1 serves up that header itself, so you end up with duplicate of that header.
    Code (Text):
      #add_header X-Content-Type-Options "nosniff" always;
    


    Xenforo 2.1 Beta 1 Installation



    Now visit in your web browser yourdomain.com/install page to proceed with install, noting the MySQL database name, database username and password you created with mysqladmin_shell.sh addon.

    xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-01.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-02.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-03.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-04.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-05.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-06.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-07.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-08.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-09.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-10.png

    Xenforo 2.1 Beta 1 src/config.php Changes For Argon2 Support



    You will also have to edit the generated src/config.php with optional settings outlined at Config.php options - XenForo 2 Manual and XF 2.1 - Welcome to XenForo 2.1 / Assorted improvements for enabling PHP Argon2 password hash algorithm support in Xenforo 2.1 beta1. Centmin Mod 123.09beta01 users can enable PHP Argon2 support via outlined steps here - you need to set PHP_ARGON='y' in persistent config file at /etc/centminmod/custom_config.inc and recompile PHP 7.2 to enable argon2 and libsodium support.

    First verify that your PHP 7.2 or 7.3 installation has Argon2 and libsodium support via these commands:

    Check libsodium PHP extension is installed and loaded
    Code (Text):
    php --ri sodium
    

    Output if libsodium is installed and loaded as PHP extension
    Code (Text):
    php --ri sodium
    
    sodium
    
    sodium support => enabled
    libsodium headers version => 1.0.16
    libsodium library version => 1.0.16
    

    Check if PHP 7.2 or 7.3 has argon2 support compiled via command:
    Code (Text):
    php -r 'print_r(get_defined_constants());' | grep -i argon
    

    For PHP 7.2 you will get this output
    Code (Text):
    php -r 'print_r(get_defined_constants());' | grep -i argon
        [PASSWORD_ARGON2I] => 2
        [PASSWORD_ARGON2_DEFAULT_MEMORY_COST] => 1024
        [PASSWORD_ARGON2_DEFAULT_TIME_COST] => 2
        [PASSWORD_ARGON2_DEFAULT_THREADS] => 2
        [SODIUM_CRYPTO_PWHASH_ALG_ARGON2I13] => 1
        [SODIUM_CRYPTO_PWHASH_ALG_ARGON2ID13] => 2
        [SODIUM_CRYPTO_PWHASH_STRPREFIX] => $argon2id$
    

    For PHP 7.3 you will get this output with additional argon2id line
    Code (Text):
    php -r 'print_r(get_defined_constants());' | grep -i argon
       [PASSWORD_ARGON2I] => 2
       [PASSWORD_ARGON2ID] => 3
       [PASSWORD_ARGON2_DEFAULT_MEMORY_COST] => 1024
       [PASSWORD_ARGON2_DEFAULT_TIME_COST] => 2
       [PASSWORD_ARGON2_DEFAULT_THREADS] => 2
       [SODIUM_CRYPTO_PWHASH_ALG_ARGON2I13] => 1
       [SODIUM_CRYPTO_PWHASH_ALG_ARGON2ID13] => 2
       [SODIUM_CRYPTO_PWHASH_STRPREFIX] => $argon2id$
    

    Once verified your PHP 7.2/7.3 install supports argon2, you can edit your /home/nginx/domains/yourdomain.com/public/src/config.php and set the following config options.

    For PHP 7.2
    Code (Text):
    $config['auth'] = [
       'algo' => PASSWORD_ARGON2I
    ];
    

    For PHP 7.3
    Code (Text):
    $config['auth'] = [
       'algo' => PASSWORD_ARGON2ID
    ];
    

    PHP 7.2.12 php-config output to show PHP version, extensions and how PHP was configured
    Code (Text):
    php-config
    Usage: /usr/local/bin/php-config [OPTION]
    Options:
      --prefix            [/usr/local]
      --includes          [-I/usr/local/include/php -I/usr/local/include/php/main -I/usr/local/include/php/TSRM -I/usr/local/include/php/Zend -I/usr/local/include/php/ext -I/usr/local/include/php/ext/date/lib]
      --ldflags           [ -L/usr/local/lib64]
      --libs              [-lcrypt  -lc-client  -lzip -lzip -lz -lexslt -ltidy -largon2 -lresolv -lcrypt -lsodium -ledit -lncurses -laspell -lpspell -lrt -lldap -llber -lstdc++ -lcrypt -lpam -lgmp -lX11 -lXpm -lpng -lz -ljpeg -lwebp -lenchant -lbz2 -lz -lrt -lm -ldl -lnsl  -lxml2 -lz -lm -ldl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lssl -lcrypto -lcurl -lxml2 -lz -lm -ldl -lssl -lcrypto -lfreetype -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lssl -lcrypto -ldl -lm -licui18n -licuuc -licudata -ldl -lm -licuio -lxml2 -lz -lm -ldl -lnetsnmp -lssl -lssl -lcrypto -lm -lxml2 -lz -lm -ldl -lcrypt -largon2 -largon2 -lxml2 -lz -lm -ldl -lxml2 -lz -lm -ldl -lxml2 -lz -lm -ldl -lxml2 -lz -lm -ldl -lxslt -lxml2 -lz -ldl -lm -lssl -lcrypto -lcrypt ]
      --extension-dir     [/usr/local/lib/php/extensions/no-debug-non-zts-20170718]
      --include-dir       [/usr/local/include/php]
      --man-dir           [/usr/local/php/man]
      --php-binary        [/usr/local/bin/php]
      --php-sapis         [ cli embed fpm phpdbg cgi]
      --configure-options [--enable-fpm --enable-opcache --enable-intl --enable-pcntl --with-mcrypt --with-snmp --enable-embed=shared --with-mhash --with-zlib --with-gettext --enable-exif --enable-zip --with-libzip --with-bz2 --enable-soap --enable-sockets --enable-sysvmsg --enable-sysvsem --enable-sysvshm --enable-shmop --with-pear --enable-mbstring --with-openssl --with-mysql=mysqlnd --with-libdir=lib64 --with-mysqli=mysqlnd --with-mysql-sock=/var/lib/mysql/mysql.sock --with-curl --with-gd --with-xmlrpc --enable-bcmath --enable-calendar --enable-ftp --enable-gd-native-ttf --with-freetype-dir=/usr --with-jpeg-dir=/usr --with-png-dir=/usr --with-xpm-dir=/usr --with-webp-dir=/usr --with-t1lib=/usr --enable-pdo --with-pdo-sqlite --with-pdo-mysql=mysqlnd --enable-inline-optimization --with-imap --with-imap-ssl --with-kerberos --with-readline --with-libedit --with-gmp --with-pspell --with-tidy --with-enchant --with-fpm-user=nginx --with-fpm-group=nginx --disable-fileinfo --with-ldap --with-ldap-sasl --with-password-argon2 --with-sodium --with-config-file-scan-dir=/etc/centminmod/php.d --with-xsl]
      --version           [7.2.12]
      --vernum            [70212]
    


    Nginx HTTP/2 HTTPS With TLS 1.3



    Centmin Mod 123.09beta01 with Nginx 1.15.6 + OpenSSL 1.1.1a with TLS 1.3 support

    ssllabs-tls-13-01.png
    ssllabs-tls-13-02.png
     
    Last edited: Nov 21, 2018
    • Informative Informative x 1
  2. eva2000

    eva2000 Administrator Staff Member

    37,261
    8,140
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,532
    Local Time:
    9:42 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x

    Xenforo 2.1 Beta 1 Admin Option Screenshots



    Screenshots from Xenforo 2.1 Beta 1 admin area.

    xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-01.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-02.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-03.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-04.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-05.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-06.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-07.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-08.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-09.png xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-10.png
    xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-11.png
    xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-12.png
    xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-options-01.png
    xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-admin-options-02.png
     
    • Like Like x 1
  3. eva2000

    eva2000 Administrator Staff Member

    37,261
    8,140
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,532
    Local Time:
    9:42 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x

    Xenforo 2.1 Beta 1 Front End



    xenforo21-beta01-centminmod-123.09beta01-install-php7.2.12-mariadb10.3-argon2-frontend-02.png
     
    Last edited: Nov 21, 2018
  4. eva2000

    eva2000 Administrator Staff Member

    37,261
    8,140
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,532
    Local Time:
    9:42 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x

    Xenforo 2.1 Beta 1 MySQL Database Tables



    List of created database tables for Xenforo 2.1 Beta 1 fresh install on MariaDB 10.3.11 MySQL server
    Code (Text):
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.3.11-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.3.11-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 6 hours 9 min 10 sec
    
    Threads: 4  Questions: 330214  Slow queries: 0  Opens: 413  Flush tables: 1  Open tables: 217  Queries per second avg: 14.908
    

    Code (Text):
    +---------------------------------------------+----------------+----------------+-----------+------------+---------+------------+--------------------+
    | Table Name                                  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION    |
    | YOURDB.xf_addon                             | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_addon_install_batch               | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_admin                             | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_admin_log                         | 9 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_admin_navigation                  | 137 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_admin_permission                  | 29 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_admin_permission_entry            | 29 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_advertising                       | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_advertising_position              | 24 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_api_attachment_key                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_api_key                           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_api_key_scope                     | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_api_scope                         | 18 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_approval_queue                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_attachment                        | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_attachment_data                   | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_attachment_view                   | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
    | YOURDB.xf_ban_email                         | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_bb_code                           | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_bb_code_media_site                | 18 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_bookmark_item                     | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_bookmark_label                    | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_bookmark_label_use                | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_captcha_log                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_captcha_question                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_category                          | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_change_log                        | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_class_extension                   | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_code_event                        | 86 Rows        | InnoDB         | 0.08MB    | 0.00MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_code_event_listener               | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_connected_account_provider        | 7 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_content_spam_cache                | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_content_type_field                | 128 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_conversation_master               | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_conversation_message              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_conversation_recipient            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_conversation_user                 | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_cron_entry                        | 17 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_css_cache                         | 18 Rows        | InnoDB         | 1.52MB    | 0.02MB     | 1.53MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_data_registry                     | 44 Rows        | InnoDB         | 0.23MB    | 0.00MB     | 0.23MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_deletion_log                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_draft                             | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_edit_history                      | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_editor_dropdown                   | 2 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_email_bounce_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_email_bounce_soft                 | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_error_log                         | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_feed                              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_feed_log                          | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_file_check                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_find_new                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_find_new_default                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_flood_check                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_forum                             | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_forum_field                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_forum_prefix                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_forum_prompt                      | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_forum_read                        | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_forum_watch                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_help_page                         | 6 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_image_proxy                       | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_image_proxy_referrer              | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_ip                                | 4 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_ip_match                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_job                               | 2 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_language                          | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_link_forum                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_link_proxy                        | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_link_proxy_referrer               | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_login_attempt                     | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_mail_queue                        | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_member_stat                       | 5 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_moderator                         | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_moderator_content                 | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_moderator_log                     | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_navigation                        | 30 Rows        | InnoDB         | 0.05MB    | 0.02MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_navigation_type                   | 3 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_news_feed                         | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_node                              | 2 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_node_type                         | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_notice                            | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_notice_dismissed                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_oembed                            | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_oembed_referrer                   | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_option                            | 184 Rows       | InnoDB         | 0.05MB    | 0.00MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_option_group                      | 28 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_option_group_relation             | 221 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_page                              | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_payment_profile                   | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_payment_provider                  | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_payment_provider_log              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_permission                        | 103 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_permission_cache_content          | 10 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_permission_combination            | 5 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_permission_combination_user_group | 10 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_permission_entry                  | 122 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_permission_entry_content          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_permission_interface_group        | 10 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_phrase                            | 8849 Rows      | InnoDB         | 1.52MB    | 0.56MB     | 2.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_phrase_compiled                   | 18634 Rows     | InnoDB         | 2.52MB    | 0.00MB     | 2.52MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_phrase_map                        | 18041 Rows     | InnoDB         | 2.02MB    | 6.92MB     | 8.94MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_poll                              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_poll_response                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_poll_vote                         | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_post                              | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_profile_post                      | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_profile_post_comment              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_purchasable                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_purchase_request                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_reaction                          | 6 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_reaction_content                  | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_registration_spam_cache           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_report                            | 0 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_report_comment                    | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_route                             | 176 Rows       | InnoDB         | 0.05MB    | 0.02MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_route_filter                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_search                            | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_search_index                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_session                           | 2 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_session_activity                  | 4 Rows         | MEMORY         | 0.06MB    | 0.06MB     | 0.12MB  | Fixed      | utf8mb4_general_ci |
    | YOURDB.xf_session_admin                     | 2 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_session_install                   | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_sitemap                           | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_smilie                            | 31 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_smilie_category                   | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_spam_cleaner_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_spam_trigger_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_stats_daily                       | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_style                             | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_style_property                    | 245 Rows       | InnoDB         | 0.09MB    | 0.02MB     | 0.11MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_style_property_group              | 27 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_style_property_map                | 490 Rows       | InnoDB         | 0.05MB    | 0.03MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_tag                               | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_tag_content                       | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_tag_result_cache                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_template                          | 771 Rows       | InnoDB         | 21.52MB   | 0.08MB     | 21.59MB | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_template_history                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_template_map                      | 2068 Rows      | InnoDB         | 0.19MB    | 0.34MB     | 0.53MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_template_modification             | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_template_modification_log         | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_template_phrase                   | 5307 Rows      | InnoDB         | 0.41MB    | 0.27MB     | 0.67MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_tfa_attempt                       | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_tfa_provider                      | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread                            | 0 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_field                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_field_value                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_prefix                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_prefix_group               | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_prompt                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_prompt_group               | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_read                       | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_redirect                   | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_reply_ban                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_user_post                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_thread_view                       | 0 Rows         | MEMORY         | 0.00MB    | 0.00MB     | 0.00MB  | Fixed      | utf8mb4_general_ci |
    | YOURDB.xf_thread_watch                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_trophy                            | 9 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_unfurl_result                     | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_upgrade_check                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_upgrade_job                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_upgrade_log                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user                              | 1 Rows         | InnoDB         | 0.02MB    | 0.14MB     | 0.16MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_alert                        | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_alert_optout                 | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_authenticate                 | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_ban                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_change_temp                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_confirmation                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_connected_account            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_field                        | 3 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_field_value                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_follow                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_group                        | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_group_change                 | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_group_promotion              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_group_promotion_log          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_group_relation               | 3 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_ignored                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_option                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_privacy                      | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_profile                      | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_push_optout                  | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_push_subscription            | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_reject                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_remember                     | 1 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_tfa                          | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_tfa_trusted                  | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_title_ladder                 | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_trophy                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_upgrade                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_upgrade_active               | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_user_upgrade_expired              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_warning                           | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_warning_action                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_warning_action_trigger            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_warning_definition                | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_widget                            | 10 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_widget_definition                 | 15 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    | YOURDB.xf_widget_position                   | 20 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Dynamic    | utf8mb4_general_ci |
    
     
  5. eva2000

    eva2000 Administrator Staff Member

    37,261
    8,140
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,532
    Local Time:
    9:42 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x

    Xenforo 2.1 Beta 1 Known Issues


    • Bug in XF 1.5 to 2.1 Beta 1 upgrade means, you need to revert to XF 1.5 backup prior to upgrade and re-do upgrades with soon to be released 2.1 Beta 2 which has the fix Fixed - Serialised content array not converted to json. Hence XF 2.1 beta 1 isn't production ready and should be tested on a test copy of your XF 1.5 live forum or on a separate test instance and always backup XF 1.5 files and databases before trying test upgrades !
     
  6. eva2000

    eva2000 Administrator Staff Member

    37,261
    8,140
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,532
    Local Time:
    9:42 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x

    Xenforo 2.1 Beta 2 One Click Upgrades



    Xenforo 2.1 Beta 2 was released and can be upgraded using the new One Click Upgrade system.

    By default upgrades only check for stable versions unless you change that in Options > Basic board information section.

    xf21-beta2-upgrade-check-03.png xf21-beta2-upgrade-check-04.png xf21-beta2-upgrade-check-05.png xf21-beta2-upgrade-check-06.png xf21-beta2-upgrade-check-08.png xf21-beta2-upgrade-check-09.png

    Xenforo 2.1 Command Line Upgrades



    If you want to do manual XF 2.1 upgrade instead, you would use below commands to upload the updated XF zip file, unzip it, change file/directory permissions to nginx user/group for upload directory contents, copy the uploads directory contents to XF web root or where you installed XF php files. Then run the cmd.php xf:upgrade via SSH command line. The last 2 lines to remove zips, you can do or leave as is.
    Code (Text):
    cd /home/nginx/domains/yourdomain.com/zips
    unzip xenforo_xxx.zip
    chown -R nginx:nginx upload
    cd upload
    \cp -Rpf * /home/nginx/domains/yourdomain.com/public
    php /home/nginx/domains/yourdomain.com/public/cmd.php xf:upgrade
    # remove zips optional for last 2 commands
    cd /home/nginx/domains/yourdomain.com/zips
    rm -f /home/nginx/domains/yourdomain.com/zips/*
    
     
    Last edited: Nov 22, 2018
    • Like Like x 1
..
Thread Status:
Not open for further replies.