Join the community today
Become a Member

Install PHP-FPM Can't install centmin mod with custom config

Discussion in 'Install & Upgrades or Pre-Install Questions' started by rc112, Mar 2, 2018.

  1. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
    Hi @eva2000 I cannot find /root/centminlogs/etc-centminmod-custom-config-settings_${DT}.log either. I used the persistent custom file as below.
    Code:
    mkdir /etc/centminmod/
    vi /etc/centminmod/custom_config.inc
    Code:
    ZONEINFO=Asia/Taipei  # Set Timezone
    LETSENCRYPT_DETECT='y' # Use acmetool.sh
    ZOPCACHEDFT='y'
    PHP_VERSION=‘7.1.3’
    NGINX_IPV='y'
    PHP_PGO='y'  # Use PHP 7.x with Profile Guide Optimizations (PGO)
    NGXDYNAMIC_BROTLI='y'
    NGINX_LIBBROTLI='y'
    CLOUDFLARE_ZLIBPHP='y' # use Cloudflare optimised zlib fork for PHP-FPM zlib instead of system zlib
    CLOUDFLARE_PATCHSSL=‘y’ # set 'y' to implement Cloudflare's chacha20 patch https://github.com/cloudflare/sslconfig
    NGINX_DYNAMICTLS=‘y’       # set 'y' and recompile nginx https://blog.cloudflare.com/optimizing-tls-over-tcp-to-reduce-latency/
    OPENSSLECDSA_PATCH=‘y’       # https://community.centminmod.com/posts/57725/
    OPENSSLECDHX_PATCH=‘y’       # https://community.centminmod.com/posts/57726/
    Code:
    nano /etc/centminmod/acmetool-config.ini
    PUSHALERT=’n’
    pushover_email=''
    # options for KEYLENGTH
    # 2048, 3072, 4096, 8192, ec-256, ec-384
    KEYLENGTH='ec-256' #ECC 256 bit ECDSA SSL
    And run installing the command below
    Code:
    yum -y update; curl -O https://centminmod.com/betainstaller.sh && chmod 0700 betainstaller.sh && bash betainstaller.sh
    In addition, after installation, I run php -v. It respond there is such php command. :( Where did I do wrong? Thank you.

     
  2. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    ${DT} is that is a datetimestamp variable not literal file name so search for it
    Code (Text):
    ls -lahrt /root/centminlogs/ | grep 'etc-centminmod-custom-config-settings'
    

    You'll need to post on the forums with the following info
    • Server or VPS details ? XEN, KVM, OpenVZ, VMWare or dedicated server ? OS ? CentOS 6.9 or 7.4 ? 32bit or 64bit ?
    • What version of Centmin Mod ? .07 stable or 08 stable or .09 beta01 or another branch version ?
    • Was it fresh install or upgrade ?
    • Method of install ? Via centmin.sh menu option 1, Git install or curl one liner install as outlined at centminmod.com/download.html ?
    • How long ago did you install Centmin Mod ?
    • There's numerous code changes, bug fixes over time, so ensure you have latest Centmin Mod code installed by upgrading your Centmin Mod code as instructed below.

    Troubleshooting Initial Install



    To troubleshoot initial installation, you need to check the initial install log at /root/centminlogs and instructions under Sharing logs and errors heading for using Pastebin.com or Gists to share a sanitised version of the contents of the initial install log. You can see full details at How to troubleshoot Centmin Mod initial install issues

    Example list /root/centminlogs files in date ascending order and grep for install.log
    Code (Text):
    ls -lahrt /root/centminlogs | grep install.log
    

    example output returns install log at /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    Code (Text):
    ls -lahrt /root/centminlogs | grep install.log
    -rw-r--r--  1 root root 2.2M Oct 11 01:40 centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    

    in SSH use cat to ouput contents of /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log. Clear your SSH client window/buffer so only output is the contents of the file
    Code (Text):
    cat /root/centminlogs/centminmod_1.2.3-eva2000.09.001_111016-112321_install.log
    

    Then copy and paste into Pastebin.com or Gists entry. If your SSH window scroll buffer isn't that large to get the whole contents of the install log, you can download file manually and copy and paste contents. But makes sure it's sanitised version of the contents of the initial install log as outlined at How to troubleshoot Centmin Mod initial install issues
     
  3. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    FYI, latest PHP 7.1 version is 7.1.15 now
     
  4. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
    Hi @eva2000 Thanks for the advices. Here is the output and question.

    I think this may cause some issue. I can find the log file such etc-centminmod-custom-config-settings_010318-225930.log. It means the custom setting is read. But it somehow didnt take effect. What I mean by that is:
    1) When I install WP with option 22, it prompt me with self-signed SSL instaed of Lets encrypt SSL.
    2) php -v command didnt work.

    I will practice again. Thank you so much.
     
  5. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
    One question. Should I restart from a clean server or I can modify the persistent config file and run 21). Update - Nginx + PHP-FPM + Siege ? Thank you.
     
  6. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    start from clean server

    but getting that initial log will allow me to help you figure out what caused install to fail

     
  7. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
  8. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yup part of problem you specified an invalid PHP version = 7.1.3 - latest is 7.1.15
    Code (Text):
    US server detected
    HTTP/1.1 404 Not Found
    Download php-‘7.1.3’.tar.gz ...
    axel http://php.net/get/php-‘7.1.3’.tar.gz/from/this/mirror -o php-‘7.1.3’.tar.gz
    Initializing download: http://php.net/get/php-‘7.1.3’.tar.gz/from/this/mirror
    HTTP/1.1 400 Bad Request
    Error: php-‘7.1.3’.tar.gz download failed.

    next problem is your openssl 1.1.0g tarball download failed to download so nginx failed to compile
    Code (Text):
    Compiling OpenSSL...
    tar (child): openssl-1.1.0g.tar.gz: Cannot open: No such file or directory
    tar (child): Error is not recoverable: exiting now
    tar: Child returned status 2
    tar: Error is not recoverable: exiting now
    inc/openssl_install.inc: line 440: cd: /svr-setup/openssl-1.1.0g: No such file or directory

    So yes try reinstall fresh CentOS 7.4 os and fresh centmin mod install

    edit: ah not just invalid PHP version it seems character set of your single quote marks is off
    Code (Text):
    PHP_VERSION=‘7.1.3’
    

    how did you edit persistent config file /etc/centminmod/custom_config.inc ? use linux text editor only i.e. vim or nano instead as it should be
    Code (Text):
    PHP_VERSION='7.1.3'
    

    probably have other custom edited text with same characterset issues so double check

    in case your pc can't see the difference

    upload_2018-3-2_16-40-16.png
     
    Last edited: Mar 2, 2018
  9. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
    @eva2000 Thank you and working on it now. Since the final out of the cnetminmod installation looks good and output all the admin and pw info, how can people to check if the installation is errorless? Thank you as always. :D
     
  10. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    at end of initial install, there's a post install check list of software versions and output that you can check

    example
    Code (Text):
    *************************************************
    * Post-Install Check List....
    *************************************************
    
    --------------------------------------------------------
    Check ccache Version:
    --------------------------------------------------------
    ccache version 3.4.1
    
    Copyright (C) 2002-2007 Andrew Tridgell
    Copyright (C) 2009-2018 Joel Rosdahl
    
    This program is free software; you can redistribute it and/or modify it under
    the terms of the GNU General Public License as published by the Free Software
    Foundation; either version 3 of the License, or (at your option) any later
    version.
    
    --------------------------------------------------------
    Check Nginx Version:
    --------------------------------------------------------
    nginx version: nginx/1.13.9
    built by gcc 7.2.1 20170829 (Red Hat 7.2.1-1) (GCC)
    built with OpenSSL 1.1.0g  2 Nov 2017
    TLS SNI support enabled
    configure arguments: --with-ld-opt='-ljemalloc -Wl,-z,relro -Wl,-rpath,/usr/local/lib' --with-cc-opt='-m64 -march=native -DTCP_FASTOPEN=23 -g -O3 -fstack-protector-strong -flto -fuse-ld=gold --param=ssp-buffer-size=4 -Wformat -Werror=format-security -Wimplicit-fallthrough=0 -fcode-hoisting -Wp,-D_FORTIFY_SOURCE=2 -gsplit-dwarf' --sbin-path=/usr/local/sbin/nginx --conf-path=/usr/local/nginx/conf/nginx.conf --with-compat --with-http_stub_status_module --with-http_secure_link_module --with-libatomic --with-http_gzip_static_module --with-http_sub_module --with-http_addition_module --with-http_image_filter_module=dynamic --with-http_geoip_module --with-stream_geoip_module --with-stream_realip_module --with-stream_ssl_preread_module --with-threads --with-stream=dynamic --with-stream_ssl_module --with-http_realip_module --add-dynamic-module=../ngx-fancyindex-0.4.2 --add-module=../ngx_cache_purge-2.4.2 --add-module=../ngx_devel_kit-0.3.0 --add-dynamic-module=../set-misc-nginx-module-0.31 --add-dynamic-module=../echo-nginx-module-0.61 --add-module=../redis2-nginx-module-0.14 --add-module=../ngx_http_redis-0.3.7 --add-module=../memc-nginx-module-0.18 --add-module=../srcache-nginx-module-0.31 --add-dynamic-module=../headers-more-nginx-module-0.33 --with-pcre=../pcre-8.41 --with-pcre-jit --with-zlib=../zlib-cloudflare-1.3.0 --with-http_ssl_module --with-http_v2_module --with-openssl=../openssl-1.1.0g --with-openssl-opt='enable-ec_nistp_64_gcc_128'
    
    --------------------------------------------------------
    Check PHP-FPM Version:
    --------------------------------------------------------
    PHP 5.6.33 (cli) (built: Feb 25 2018 19:39:56)
    Copyright (c) 1997-2016 The PHP Group
    Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
       with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
    
    --------------------------------------------------------
    Check MariaDB installed RPM Versions:
    --------------------------------------------------------
    MariaDB-devel-10.1.31-1.el7.centos.x86_64
    MariaDB-client-10.1.31-1.el7.centos.x86_64
    MariaDB-server-10.1.31-1.el7.centos.x86_64
    MariaDB-shared-10.1.31-1.el7.centos.x86_64
    MariaDB-common-10.1.31-1.el7.centos.x86_64
    MariaDB-compat-10.1.31-1.el7.centos.x86_64
    
    --------------------------------------------------------
    Check Memcached Server Version:
    --------------------------------------------------------
    memcached 1.5.5
    
    --------------------------------------------------------
    Check CSF Firewall Version:
    --------------------------------------------------------
    csf: v11.07 (generic)
    
    --------------------------------------------------------
    Check Siege Benchmark Version:
    --------------------------------------------------------
    SIEGE 4.0.4
    
    Copyright (C) 2017 by Jeffrey Fulmer, et al.
    This is free software; see the source for copying conditions.
    There is NO warranty; not even for MERCHANTABILITY or FITNESS
    FOR A PARTICULAR PURPOSE.
    
    
    --------------------------------------------------------
    Check mysqlreport version:
    --------------------------------------------------------
    mysqlreport v3.5-maria11 Jul 4 2013
    
    --------------------------------------------------------
    Check pure-ftpd Version:
    --------------------------------------------------------
    pure-ftpd v1.0.42
    
    --------------------------------------------------------
    Check YUM Repo List
    --------------------------------------------------------
    Loaded plugins: fastestmirror, priorities, versionlock
    Loading mirror speeds from cached hostfile
     * base: mirror.fileplanet.com
     * epel: mirrors.develooper.com
     * extras: mirror.fileplanet.com
     * rpmforge: mirror.hmc.edu
     * updates: mirror.fileplanet.com
    228 packages excluded due to repository priority protections
    repo id                        repo name                             status
    base/7/x86_64                  CentOS-7 - Base                       7,420+2,171
    centos-sclo-rh/x86_64          CentOS-7 - SCLo rh                       6,546+94
    centos-sclo-sclo/x86_64        CentOS-7 - SCLo sclo                          500
    epel/x86_64                    Extra Packages for Enterprise Linux 7  11,376+923
    extras/7/x86_64                CentOS-7 - Extras                             388
    mariadb                        MariaDB                                      15+2
    rpmforge                       RHEL 7 - RPMforge.net - dag               139+106
    updates/7/x86_64               CentOS-7 - Updates                      1,499+430
    !varnishcache_varnish41/x86_64 varnishcache_varnish41                         46
    !varnishcache_varnish41-source varnishcache_varnish41-source                   0
    repolist: 27,929
    
    --------------------------------------------------------
    mytimes check:
    /usr/bin/mytimes
    --------------------------------------------------------
    Sun Feb 25 19:42:44 UTC 2018    [UTC]
    Mon Feb 26 05:42:44 AEST 2018   [Australia/Brisbane]
    Sun Feb 25 11:42:44 PST 2018    [America/Los_Angeles]
    Sun Feb 25 13:42:44 CST 2018    [America/Chicago]
    Sun Feb 25 14:42:44 EST 2018    [America/New_York]
    Sun Feb 25 14:42:44 EST 2018    [America/Montreal]
    Sun Feb 25 19:42:44 GMT 2018    [Europe/London]
    Sun Feb 25 20:42:44 CET 2018    [Europe/Berlin]
    Mon Feb 26 02:42:44 +07 2018    [Asia/Bangkok]
    Mon Feb 26 02:42:44 +07 2018    [Asia/Ho_Chi_Minh]
    Mon Feb 26 02:42:44 WIB 2018    [Asia/Jakarta]
    Mon Feb 26 03:42:44 +08 2018    [Asia/Kuala_Lumpur]
    Mon Feb 26 03:42:44 +08 2018    [Asia/Singapore]
    --------------------------------------------------------
    
     
  11. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
    Hi It seems not good. :(
    Code:
    *************************************************
    * Post-Install Check List....
    *************************************************
    
    --------------------------------------------------------
    Check ccache Version:
    --------------------------------------------------------
    ccache version 3.4.1
    
    Copyright (C) 2002-2007 Andrew Tridgell
    Copyright (C) 2009-2018 Joel Rosdahl
    
    This program is free software; you can redistribute it and/or modify it under
    the terms of the GNU General Public License as published by the Free Software
    Foundation; either version 3 of the License, or (at your option) any later
    version.
    
    --------------------------------------------------------
    Check Nginx Version:
    --------------------------------------------------------
    which: no nginx in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
    can not find nginx binary.. install failed
    
    --------------------------------------------------------
    Check PHP-FPM Version:
    --------------------------------------------------------
    which: no php in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
    inc/centminfinish.inc: line 77: -v: command not found
    
    --------------------------------------------------------
    Check MariaDB installed RPM Versions:
    --------------------------------------------------------
    MariaDB-server-10.1.31-1.el7.centos.x86_64
    MariaDB-common-10.1.31-1.el7.centos.x86_64
    MariaDB-compat-10.1.31-1.el7.centos.x86_64
    MariaDB-devel-10.1.31-1.el7.centos.x86_64
    MariaDB-client-10.1.31-1.el7.centos.x86_64
    MariaDB-shared-10.1.31-1.el7.centos.x86_64
    
    --------------------------------------------------------
    Check Memcached Server Version:
    --------------------------------------------------------
    memcached 1.5.6
    
    --------------------------------------------------------
    Check CSF Firewall Version:
    --------------------------------------------------------
    csf: v11.07 (generic)
    
    --------------------------------------------------------
    Check Siege Benchmark Version:
    --------------------------------------------------------
    which: no siege in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
    inc/centminfinish.inc: line 144: -V: command not found
    
    --------------------------------------------------------
    Check mysqlreport version:
    --------------------------------------------------------
    chmod: cannot access ‘/root/mysqlreport’: No such file or directory
    inc/centminfinish.inc: line 168: /root/mysqlreport: No such file or directory
    
    --------------------------------------------------------
    Check pure-ftpd Version:
    --------------------------------------------------------
    pure-ftpd v1.0.42
    
    --------------------------------------------------------
    Check YUM Repo List
    --------------------------------------------------------
    Loaded plugins: fastestmirror, priorities, versionlock
    Loading mirror speeds from cached hostfile
     * base: mirror.0x.sg
     * epel: mirror.smartmedia.net.id
     * extras: mirror.0x.sg
     * rpmforge: mirror.smartmedia.net.id
     * updates: mirror.0x.sg
    228 packages excluded due to repository priority protections
    repo id                        repo name                             status
    base/7/x86_64                  CentOS-7 - Base                       7,420+2,171
    centos-sclo-rh/x86_64          CentOS-7 - SCLo rh                       6,546+94
    centos-sclo-sclo/x86_64        CentOS-7 - SCLo sclo                          500
    digitalocean-agent/x86_64      DigitalOcean agent                              1
    *epel/x86_64                   Extra Packages for Enterprise Linux 7  11,430+923
    extras/7/x86_64                CentOS-7 - Extras                             390
    mariadb                        MariaDB                                      15+2
    rpmforge                       RHEL 7 - RPMforge.net - dag               139+106
    updates/7/x86_64               CentOS-7 - Updates                      1,509+432
    !varnishcache_varnish41/x86_64 varnishcache_varnish41                         46
    !varnishcache_varnish41-source varnishcache_varnish41-source                   0
    repolist: 27,996
    
    --------------------------------------------------------
    mytimes check:
    /usr/bin/mytimes
    --------------------------------------------------------
    Fri Mar  2 06:44:05 UTC 2018    [UTC]
    Fri Mar  2 16:44:05 AEST 2018    [Australia/Brisbane]
    Thu Mar  1 22:44:05 PST 2018    [America/Los_Angeles]
    Fri Mar  2 00:44:05 CST 2018    [America/Chicago]
    Fri Mar  2 01:44:05 EST 2018    [America/New_York]
    Fri Mar  2 01:44:05 EST 2018    [America/Montreal]
    Fri Mar  2 06:44:05 GMT 2018    [Europe/London]
    Fri Mar  2 07:44:05 CET 2018    [Europe/Berlin]
    Fri Mar  2 13:44:05 +07 2018    [Asia/Bangkok]
    Fri Mar  2 13:44:05 +07 2018    [Asia/Ho_Chi_Minh]
    Fri Mar  2 13:44:05 WIB 2018    [Asia/Jakarta]
    Fri Mar  2 14:44:05 +08 2018    [Asia/Kuala_Lumpur]
    Fri Mar  2 14:44:05 +08 2018    [Asia/Singapore]
    --------------------------------------------------------
    *************************************************
    I fix the persistent config file as below.
    Code:
    [root@centmin centminmod]# cat /etc/centminmod/custom_config.inc
    ZONEINFO=Asia/Taipei  # Set Timezone
    LETSENCRYPT_DETECT='y' # Use acmetool.sh
    ZOPCACHEDFT='y'
    PHP_VERSION=‘7.1.15’
    NGINX_IPV='y'
    PHP_PGO='y'  # Use PHP 7.x with Profile Guide Optimizations (PGO)
    NGXDYNAMIC_BROTLI='y'
    NGINX_LIBBROTLI='y'
    CLOUDFLARE_ZLIBPHP='y' # use Cloudflare optimised zlib fork for PHP-FPM zlib instead of system zlib
    CLOUDFLARE_PATCHSSL=‘y’ # set 'y' to implement Cloudflare's chacha20 patch https://github.com/cloudflare/sslconfig
    NGINX_DYNAMICTLS=‘y’       # set 'y' and recompile nginx https://blog.cloudflare.com/optimizing-tls-over-tcp-to-reduce-latency/
    OPENSSLECDSA_PATCH=‘y’       # https://community.centminmod.com/posts/57725/
    OPENSSLECDHX_PATCH=‘y’       # https://community.centminmod.com/posts/57726/
    And complet log output. [root@centmin centminmod]# cat /root/centminlogs/centminmod_123.09beta01.b016_02 - Pastebin.com

    Server or VPS details ?KVM CentO7.4 64bit
    What version of Centmin Mod ?.09 beta01
    Was it fresh install or upgrade ? install
    Method of install ? curl one liner install
    How long ago did you install Centmin Mod ?

    Thank you.
     
  12. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    still see character set issues with your single quotes

    i'd double check your SSH client is set to character set UTF-8 as well when you re-edit and fix your /etc/centminmod/custom_config.inc persistent config file.

    causing PHP to fail

    upload_2018-3-2_17-9-23.png

    look at single quotes that wrap 7.1.15

    same on openssl wrapping of /opt/openssl/certs directory

    upload_2018-3-2_17-10-42.png

    you can verify if this is the issue by doing standard 123.09beta01 install without any custom /etc/centminmod/custom_config.inc persistent config file
     
  13. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  14. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    FYI is this what i see in 1st post text notice some of your single quotes are using ASCII U+0060 GRAVE ACCENT and U+00B4 ACUTE ACCENT ASCII and Unicode quotation marks

    upload_2018-3-2_17-22-7.png
     
  15. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
    @eva2000
    1. So which character set should I use?
    2. Should I change on my terminal too? (attached)
    3. And I paste the custom config content on my local notebook. Is it okay?
    Thank you so much.
     

    Attached Files:

  16. eva2000

    eva2000 Administrator Staff Member

    54,535
    12,219
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,788
    Local Time:
    8:56 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    character encoding = UTF-8 should be ok

    make sure you save the text file on local PC as Unix UTF-8 as well before copy and pasting

    upload_2018-3-2_17-39-30.png
     
  17. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
    @eva2000 Thank you so much. A great lesson to me.
     
  18. rc112

    rc112 Member

    126
    14
    18
    Sep 22, 2017
    Ratings:
    +15
    Local Time:
    6:56 PM
    It works. Thank you.