admin – Page 6 – My Projects & Live

Yii2

Ref: https://www.yiiframework.com/
https://www.yiiframework.com/doc/guide/2.0/en/start-installation

How to install Yii PHP Framework on Debian 9 and Ubuntu 18.04?

Create a Yii2 project ‘yii2-kickstart’ via composer:

composer create-project --prefer-dist --no-dev yiisoft/yii2-app-basic yii2-kickstart

1	composer create-project --prefer-dist --no-dev yiisoft/yii2-app-basic yii2-kickstart

Go to the project dir then modify composer.json to add ‘replace’ like this:

{
    "name": "yiisoft/yii2-app-basic",
    ...
    "replace": {
	"bower-asset/jquery": ">=1.11.0",
	"bower-asset/inputmask": ">=3.2.0",
	"bower-asset/punycode": ">=1.3.0",
	"bower-asset/yii2-pjax": ">=2.0.0"
    },
    "repositories": [
        ...
    ]
}

{

"name": "yiisoft/yii2-app-basic",

...

"replace": {

"bower-asset/jquery": ">=1.11.0",

"bower-asset/inputmask": ">=3.2.0",

"bower-asset/punycode": ">=1.3.0",

"bower-asset/yii2-pjax": ">=2.0.0"

"repositories": [

...

]

}

If I don’t do this, i’ll get this error:

Exception 'yii\base\InvalidConfigException' with message 'Failed to instantiate component or class "yii\gii\Module".'

in /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/di/Container.php:433

Stack trace:
#0 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/di/Container.php(365): yii\di\Container->getDependencies('yii\\gii\\Module')
#1 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/di/Container.php(156): yii\di\Container->build('yii\\gii\\Module', Array, Array)
#2 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/BaseYii.php(349): yii\di\Container->get('yii\\gii\\Module', Array, Array)
#3 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/Module.php(427): yii\BaseYii::createObject(Array, Array)
#4 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/Application.php(315): yii\base\Module->getModule('gii')
#5 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/Application.php(273): yii\base\Application->bootstrap()
#6 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/console/Application.php(124): yii\base\Application->init()
#7 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/BaseObject.php(109): yii\console\Application->init()
#8 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/Application.php(206): yii\base\BaseObject->__construct(Array)
#9 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/console/Application.php(89): yii\base\Application->__construct(Array)
#10 /home/teddy/Documents/works/yii2-kickstart/yii(19): yii\console\Application->__construct(Array)
#11 {main}

Exception 'yii\base\InvalidConfigException' with message 'Failed to instantiate component or class "yii\gii\Module".'

in /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/di/Container.php:433

Stack trace:

#0 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/di/Container.php(365): yii\di\Container->getDependencies('yii\\gii\\Module')

#1 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/di/Container.php(156): yii\di\Container->build('yii\\gii\\Module', Array, Array)

#2 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/BaseYii.php(349): yii\di\Container->get('yii\\gii\\Module', Array, Array)

#3 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/Module.php(427): yii\BaseYii::createObject(Array, Array)

#4 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/Application.php(315): yii\base\Module->getModule('gii')

#5 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/Application.php(273): yii\base\Application->bootstrap()

#6 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/console/Application.php(124): yii\base\Application->init()

#7 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/BaseObject.php(109): yii\console\Application->init()

#8 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/base/Application.php(206): yii\base\BaseObject->__construct(Array)

#9 /home/teddy/Documents/works/yii2-kickstart/vendor/yiisoft/yii2/console/Application.php(89): yii\base\Application->__construct(Array)

#10 /home/teddy/Documents/works/yii2-kickstart/yii(19): yii\console\Application->__construct(Array)

#11 {main}

Then run ‘composer update’
Then run ‘php yii serve’. it’ll use port 8080
If the port 8080 is already used, you can use another port like 888:

php yii serve --port=8888

1	php yii serve --port=8888

Then open it on your browser: http://localhost:8888/
BUT I GOT THIS ERROR ON THE PAGE

Invalid Argument – yii\base\InvalidArgumentException
The file or directory to be published does not exist: {ROOT}/vendor/bower-asset/jquery/dist

1 2	Invalid Argument – yii\base\InvalidArgumentException The file or directory to be published does not exist: {ROOT}/vendor/bower-asset/jquery/dist

SO I REMOVE ‘replace’ AND THE VALUES IN {} IN composer.json
Then run ‘composer update’ again.
Start the server again: php yii serve –port=8888
Open it on the browser: http://localhost:8888/
NOW IT’S WORKING FINE!

WordPress and Woocommerce

Download the latest from wordpress.org. I got version 5.2.3

SETUP LOCAL WITH NGINX

sudo gedit /etc/nginx/sites-available/wp523_commerce.test

1	sudo gedit /etc/nginx/sites-available/wp523_commerce.test

content:

server {
    listen 80; 
    listen [::]:80;
    root /home/teddy/Documents/works/wp523_commerce; #your document root
    server_name www.wp523_commerce.test wp523_commerce.test ;  # Your server name
    index index.php index.html index.htm ;

    # Webfonts,fonts
    location ~* \.(?:ttf|ttc|otf|eot|woff|woff2)$ {
        add_header "Access-Control-Allow-Origin" "*";
        expires 1y;
        access_log off;
        add_header Cache-Control "public";
    }

    # Media: images, icons, video, audio, HTC
    location ~* \.(?:jpg|jpeg|gif|png|ico|cur|gz|svg|svgz|mp4|ogg|ogv|webm|htc)$ {
        expires 1y;
        access_log off;
        add_header Cache-Control "public";
    }

    # Js, Css
    location ~* \.(?:css|js)$ {
        expires 1y;
        access_log off;
        add_header Cache-Control "public";
    }

    # Serve static files without touching php
    location / {
        try_files $uri $uri/ /index.php?$args;
    } 
    # pass requests for dynamic content to site
    location ~ [^/]\.php(/|$) {
        try_files $uri /index.php; 
        fastcgi_pass unix:/run/php/php7.3-fpm.sock;
        
        fastcgi_buffers 1024 4k;

        fastcgi_read_timeout 600s;
        fastcgi_connect_timeout 600s;

        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        #include fastcgi_params;
        #FOR DEVELOPMENT MODE ONLY - BEGIN
        fastcgi_param MAGE_IS_DEVELOPER_MODE true;
        fastcgi_param PHP_VALUE  display_startup_errors=on;
        fastcgi_param PHP_VALUE  display_errors=on;
        fastcgi_param PHP_VALUE  html_errors=on;
        fastcgi_param PHP_VALUE  log_errors=on;
        fastcgi_param PHP_VALUE  error_log=/home/teddy/Documents/works/wp523_commerce/var/log/system.log;
        #FOR DEVELOPMENT MODE ONLY - END
        include fastcgi_params;
    }

    gzip on;
    gzip_disable "msie6";

    gzip_comp_level 6;
    gzip_min_length 1100;
    gzip_buffers 16 8k;
    gzip_proxied any;
    gzip_types
    text/plain
    text/css
    text/js
    text/xml
    text/javascript
    application/javascript
    application/x-javascript
    application/json
    application/xml
    application/xml+rss
    image/svg+xml;
    gzip_vary on;

    # Banned locations (only reached if the earlier PHP entry point regexes don't match)
    location ~* (\.php$|\.htaccess$|\.git) {
        deny all;
    }
}

server {

listen 80;

listen [::]:80;

root /home/teddy/Documents/works/wp523_commerce; #your document root

server_name www.wp523_commerce.test wp523_commerce.test ; # Your server name

index index.php index.html index.htm ;

# Webfonts,fonts

location ~* \.(?:ttf|ttc|otf|eot|woff|woff2)$ {

add_header "Access-Control-Allow-Origin" "*";

expires 1y;

access_log off;

add_header Cache-Control "public";

}

# Media: images, icons, video, audio, HTC

location ~* \.(?:jpg|jpeg|gif|png|ico|cur|gz|svg|svgz|mp4|ogg|ogv|webm|htc)$ {

expires 1y;

access_log off;

add_header Cache-Control "public";

}

# Js, Css

location ~* \.(?:css|js)$ {

expires 1y;

access_log off;

add_header Cache-Control "public";

}

# Serve static files without touching php

location / {

try_files $uri $uri/ /index.php?$args;

}

# pass requests for dynamic content to site

location ~ [^/]\.php(/|$) {

try_files $uri /index.php;

fastcgi_pass unix:/run/php/php7.3-fpm.sock;

fastcgi_buffers 1024 4k;

fastcgi_read_timeout 600s;

fastcgi_connect_timeout 600s;

fastcgi_index index.php;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

#include fastcgi_params;

#FOR DEVELOPMENT MODE ONLY - BEGIN

fastcgi_param MAGE_IS_DEVELOPER_MODE true;

fastcgi_param PHP_VALUE display_startup_errors=on;

fastcgi_param PHP_VALUE display_errors=on;

fastcgi_param PHP_VALUE html_errors=on;

fastcgi_param PHP_VALUE log_errors=on;

fastcgi_param PHP_VALUE error_log=/home/teddy/Documents/works/wp523_commerce/var/log/system.log;

#FOR DEVELOPMENT MODE ONLY - END

include fastcgi_params;

}

gzip on;

gzip_disable "msie6";

gzip_comp_level 6;

gzip_min_length 1100;

gzip_buffers 16 8k;

gzip_proxied any;

gzip_types

text/plain

text/css

text/js

text/xml

text/javascript

application/javascript

application/x-javascript

application/json

application/xml

application/xml+rss

image/svg+xml;

gzip_vary on;

# Banned locations (only reached if the earlier PHP entry point regexes don't match)

location ~* (\.php$|\.htaccess$|\.git) {

deny all;

}

Enable file config

sudo ln -s /etc/nginx/sites-available/wp523_commerce.test /etc/nginx/sites-enabled/wp523_commerce.test

1

sudo ln -s /etc/nginx/sites-available/wp523_commerce.test /etc/nginx/sites-enabled/wp523_commerce.test
Register the host on my system

sudo gedit /etc/hosts

1

sudo gedit /etc/hosts

Like this:

... 127.0.0.1 wp523_commerce.test ...

1
2
3

...
127.0.0.1 wp523_commerce.test
...

CHECK THE NGINX SETTING AND RESTART IT:

teddy@teddy:~$ sudo nginx -t
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful

teddy@teddy:~$ sudo nginx -t

nginx: the configuration file /etc/nginx/nginx.conf syntax is ok

nginx: configuration file /etc/nginx/nginx.conf test is successful

sudo service nginx restart

1	sudo service nginx restart

CREATE A NEW DATABASE: wp523_commerce COLLATION utf8_general_ci
Open it on your browser and install : http://wp523_commerce.test
setting:
username: admin
password: xA**EbXJ4UNw96u0wI

Download theme ‘futurio’ from https://futuriowp.com/free-woocommerce-theme/
then extract and put it in theme dir. install
Then download plugin futurio extra from https://wordpress.org/plugins/futurio-extra/
Then download plugin wordpress-importer from https://wordpress.org/plugins/wordpress-importer/
Then download plugin elementor from https://wordpress.org/plugins/elementor/
Then download plugin WooCommerce
from https://wordpress.org/plugins/woocommerce/
Then download plugin Ajax Search for WooCommerce
from https://wordpress.org/plugins/ajax-search-for-woocommerce/
extract and put these plugins into plugins dir then install

Then download the sample data from https://futuriowp.com/docs/futurio/importing-the-sample-data/. Follow the instructions to import the sample data. NOTE: I can’t import the data from the local site. I have to import it manually!

TEST: http://wp523_commerce.test
ADMIN: http://wp523_commerce.test/wp-admin
WOOCOMMERCE SHOP: http://wp523_commerce.test/shop

Laravel and Swoole

Ref: https://github.com/huang-yi/laravel-swoole-http
My setting:

php version: PHP 7.3.9-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Sep  2 2019 12:54:04) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.9, Copyright (c) 1998-2018 Zend Technologies

Swoole version: 4.4.5

php version: PHP 7.3.9-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Sep 2 2019 12:54:04) ( NTS )

Swoole version: 4.4.5

Create a laravel project. I tried version 6.x but I can’t use ‘laravel-swoole-http’ so I installed version 5.6.x

composer create-project --prefer-dist laravel/laravel laravel-swoole "5.6.*"

1	composer create-project --prefer-dist laravel/laravel laravel-swoole "5.6.*"

Then go to the dir ‘laravel-swoole’ then install laravel-swoole-http’ with ‘composer require huang-yi/laravel-swoole-http’

composer require huang-yi/laravel-swoole-http

Using version ^3.1 for huang-yi/laravel-swoole-http
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 2 installs, 0 updates, 0 removals
  - Installing huang-yi/swoole-watcher (0.0.2): Downloading (100%)         
  - Installing huang-yi/laravel-swoole-http (3.1.7):Downloading (100%)         )
Writing lock file
Generating optimized autoload files
Carbon 1 is deprecated, see how to migrate to Carbon 2.
https://carbon.nesbot.com/docs/#api-carbon-2
    You can run './vendor/bin/upgrade-carbon' to get help in updating carbon and other frameworks and libraries that depend on it.
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover
Discovered Package: fideloper/proxy
Discovered Package: huang-yi/laravel-swoole-http
Discovered Package: laravel/tinker
Discovered Package: nunomaduro/collision
Package manifest generated successfully.

composer require huang-yi/laravel-swoole-http

Using version ^3.1 for huang-yi/laravel-swoole-http

./composer.json has been updated

Loading composer repositories with package information

Updating dependencies (including require-dev)

Package operations: 2 installs, 0 updates, 0 removals

- Installing huang-yi/swoole-watcher (0.0.2): Downloading (100%)

- Installing huang-yi/laravel-swoole-http (3.1.7):Downloading (100%) )

Writing lock file

Generating optimized autoload files

Carbon 1 is deprecated, see how to migrate to Carbon 2.

https://carbon.nesbot.com/docs/#api-carbon-2

You can run './vendor/bin/upgrade-carbon' to get help in updating carbon and other frameworks and libraries that depend on it.

> Illuminate\Foundation\ComposerScripts::postAutoloadDump

> @php artisan package:discover

Discovered Package: fideloper/proxy

Discovered Package: huang-yi/laravel-swoole-http

Discovered Package: laravel/tinker

Discovered Package: nunomaduro/collision

Package manifest generated successfully.

then register/publish the swoole service

php artisan vendor:publish --provider="HuangYi\Swoole\SwooleServiceProvider"

Copied File [/vendor/huang-yi/laravel-swoole-http/config/swoole.php] To [/config/swoole.php]
Publishing complete.

php artisan vendor:publish --provider="HuangYi\Swoole\SwooleServiceProvider"

Copied File [/vendor/huang-yi/laravel-swoole-http/config/swoole.php] To [/config/swoole.php]

Publishing complete.

then start swoole server

php artisan swoole:server

Starting server...
> (Run this command to ensure the server process is running: ps -ef|grep "{app.name}")

php artisan swoole:server

Starting server...

> (Run this command to ensure the server process is running: ps -ef|grep "{app.name}")

open it on your browser: http://127.0.0.1:1215/
the setting in laravel-swoole/config/swoole.php like host (localhost), port (1215), etc
TO stop the swoole server:

php artisan swoole:server stop

Stopping server...
> success

php artisan swoole:server stop

Stopping server...

> success

ANOTHER ACTIVE LARAVEL SWOOLE (laravel-swooletw)
https://github.com/swooletw/laravel-swoole
PLS READ https://github.com/swooletw/laravel-swoole/wiki
Create a laravel project. I installed version 5.6.x

composer create-project --prefer-dist laravel/laravel laravel-swooletw "5.6.*"

1	composer create-project --prefer-dist laravel/laravel laravel-swooletw "5.6.*"

Then go to the dir ‘laravel-swooletw’ then install laravel-swoole’ with ‘composer require swooletw/laravel-swoole’

composer require swooletw/laravel-swoole

Using version ^2.6 for swooletw/laravel-swoole
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 2 installs, 0 updates, 0 removals
  - Installing predis/predis (v1.1.1): Downloading (100%)         
  - Installing swooletw/laravel-swoole (v2.6.64): Downloading (100%)         
predis/predis suggests installing ext-phpiredis (Allows faster serialization and deserialization of the Redis protocol)
Writing lock file
Generating optimized autoload files
Carbon 1 is deprecated, see how to migrate to Carbon 2.
https://carbon.nesbot.com/docs/#api-carbon-2
    You can run './vendor/bin/upgrade-carbon' to get help in updating carbon and other frameworks and libraries that depend on it.
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover
Discovered Package: fideloper/proxy
Discovered Package: laravel/tinker
Discovered Package: nunomaduro/collision
Discovered Package: swooletw/laravel-swoole
Package manifest generated successfully.

composer require swooletw/laravel-swoole

Using version ^2.6 for swooletw/laravel-swoole

./composer.json has been updated

Loading composer repositories with package information

Updating dependencies (including require-dev)

Package operations: 2 installs, 0 updates, 0 removals

- Installing predis/predis (v1.1.1): Downloading (100%)

- Installing swooletw/laravel-swoole (v2.6.64): Downloading (100%)

predis/predis suggests installing ext-phpiredis (Allows faster serialization and deserialization of the Redis protocol)

Writing lock file

Generating optimized autoload files

Carbon 1 is deprecated, see how to migrate to Carbon 2.

https://carbon.nesbot.com/docs/#api-carbon-2

You can run './vendor/bin/upgrade-carbon' to get help in updating carbon and other frameworks and libraries that depend on it.

> Illuminate\Foundation\ComposerScripts::postAutoloadDump

> @php artisan package:discover

Discovered Package: fideloper/proxy

Discovered Package: laravel/tinker

Discovered Package: nunomaduro/collision

Discovered Package: swooletw/laravel-swoole

Package manifest generated successfully.

from https://github.com/swooletw/laravel-swoole/wiki/4.-Installation,I need to register the swoole service provider in config/app.php

    ...
    'providers' => [

       ...
       SwooleTW\Http\LaravelServiceProvider::class,

    ],

...

'providers' => [

...

SwooleTW\Http\LaravelServiceProvider::class,

Then need to publish the configuration

php artisan vendor:publish --tag=laravel-swoole

Copied File [/vendor/swooletw/laravel-swoole/config/swoole_http.php] To [/config/swoole_http.php]
Copied File [/vendor/swooletw/laravel-swoole/config/swoole_websocket.php] To [/config/swoole_websocket.php]
Copied File [/vendor/swooletw/laravel-swoole/routes/websocket.php] To [/routes/websocket.php]
Publishing complete.

php artisan vendor:publish --tag=laravel-swoole

Copied File [/vendor/swooletw/laravel-swoole/config/swoole_http.php] To [/config/swoole_http.php]

Copied File [/vendor/swooletw/laravel-swoole/config/swoole_websocket.php] To [/config/swoole_websocket.php]

Copied File [/vendor/swooletw/laravel-swoole/routes/websocket.php] To [/routes/websocket.php]

Publishing complete.

Then run the server :

php artisan swoole:http start

1	php artisan swoole:http start

open it on your browser: http://localhost:1215/

ANOTHER LARAVEL – SWOOLE IS
https://github.com/hhxsv5/laravel-s
I download for auction app from https://github.com/GallopYD/domain-spider
STEPS:

git clone https://github.com/GallopYD/domain-spider laravel-auction

cd laravel-auction

composer install

git clone https://github.com/GallopYD/domain-spider laravel-auction

cd laravel-auction

composer install

CREATE A .env file:

APP_ENV=local
APP_DEBUG=true
APP_KEY=base64:CVSEtDyAtoBbQbZ5udq3vbrM8+URejsZSOFwqA7dBAE=

DB_HOST=localhost
DB_DATABASE=laravel_auction_swoole
DB_USERNAME=root
DB_PASSWORD=teddy

CACHE_DRIVER=file
SESSION_DRIVER=file

APP_ENV=local

APP_DEBUG=true

APP_KEY=base64:CVSEtDyAtoBbQbZ5udq3vbrM8+URejsZSOFwqA7dBAE=

DB_HOST=localhost

DB_DATABASE=laravel_auction_swoole

DB_USERNAME=root

DB_PASSWORD=teddy

CACHE_DRIVER=file

SESSION_DRIVER=file

CREATE A NEW DATABASE ‘laravel_auction_swoole’ COLLATION : utf8mb4_unicode_ci
RUN

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php artisan help -V
Laravel Framework 5.6.39

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php artisan key:generate
Application key [base64:CVSEtDyAtoBbQbZ5udq3vbrM8+URejsZSOFwqA7dBAE=] set successfully.

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php artisan migrate --seedMigration table created successfully.
Migrating: 2019_08_11_111354_create_domains_table
Migrated:  2019_08_11_111354_create_domains_table

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php artisan help -V

Laravel Framework 5.6.39

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php artisan key:generate

Application key [base64:CVSEtDyAtoBbQbZ5udq3vbrM8+URejsZSOFwqA7dBAE=] set successfully.

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php artisan migrate --seedMigration table created successfully.

Migrating: 2019_08_11_111354_create_domains_table

Migrated: 2019_08_11_111354_create_domains_table

READ https://github.com/hhxsv5/laravel-s
PUBLISH

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php artisan laravels publish

 /home/teddy/Documents/works/swoole/laravel-auction/config/laravels.php already exists, do you want to override it ? Y/N [N]:
 > Y

Copied file [/home/teddy/Documents/works/swoole/laravel-auction/vendor/hhxsv5/laravel-s/config/laravels.php] To [/home/teddy/Documents/works/swoole/laravel-auction/config/laravels.php]
Linked file [/home/teddy/Documents/works/swoole/laravel-auction/vendor/hhxsv5/laravel-s/bin/laravels] To [/home/teddy/Documents/works/swoole/laravel-auction/bin/laravels]
Linked file [/home/teddy/Documents/works/swoole/laravel-auction/vendor/hhxsv5/laravel-s/bin/fswatch] To [/home/teddy/Documents/works/swoole/laravel-auction/bin/fswatch]
Linked file [/home/teddy/Documents/works/swoole/laravel-auction/vendor/hhxsv5/laravel-s/bin/inotify] To [/home/teddy/Documents/works/swoole/laravel-auction/bin/inotify]

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php artisan laravels publish

/home/teddy/Documents/works/swoole/laravel-auction/config/laravels.php already exists, do you want to override it ? Y/N [N]:

> Y

Copied file [/home/teddy/Documents/works/swoole/laravel-auction/vendor/hhxsv5/laravel-s/config/laravels.php] To [/home/teddy/Documents/works/swoole/laravel-auction/config/laravels.php]

Linked file [/home/teddy/Documents/works/swoole/laravel-auction/vendor/hhxsv5/laravel-s/bin/laravels] To [/home/teddy/Documents/works/swoole/laravel-auction/bin/laravels]

Linked file [/home/teddy/Documents/works/swoole/laravel-auction/vendor/hhxsv5/laravel-s/bin/fswatch] To [/home/teddy/Documents/works/swoole/laravel-auction/bin/fswatch]

Linked file [/home/teddy/Documents/works/swoole/laravel-auction/vendor/hhxsv5/laravel-s/bin/inotify] To [/home/teddy/Documents/works/swoole/laravel-auction/bin/inotify]

START SERVER

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php bin/laravels start
 _                               _  _____ 
| |                             | |/ ____|
| |     __ _ _ __ __ ___   _____| | (___  
| |    / _` | '__/ _` \ \ / / _ \ |\___ \ 
| |___| (_| | | | (_| |\ V /  __/ |____) |
|______\__,_|_|  \__,_| \_/ \___|_|_____/ 
                                           
Speed up your Laravel/Lumen
>>> Components
+---------------------------+--------------------------------------+
| Component                 | Version                              |
+---------------------------+--------------------------------------+
| PHP                       | 7.3.9-1+ubuntu16.04.1+deb.sury.org+1 |
| Swoole                    | 4.4.5                                |
| LaravelS                  | 3.5.10                               |
| Laravel Framework [local] | 5.6.39                               |
+---------------------------+--------------------------------------+
>>> Protocols
+-----------+--------+-------------------+----------------+
| Protocol  | Status | Handler           | Listen At      |
+-----------+--------+-------------------+----------------+
| Main HTTP | On     | Laravel Framework | 127.0.0.1:5200 |
+-----------+--------+-------------------+----------------+
>>> Feedback: https://github.com/hhxsv5/laravel-s
[2019-09-21 16:54:46] [TRACE] Swoole is running, press Ctrl+C to quit.

teddy@teddy:~/Documents/works/swoole/laravel-auction$ php bin/laravels start

_ _ _____

| | | |/ ____|

| | __ _ _ __ __ ___ _____| | (___

| | / _` | '__/ _` \ \ / / _ \ |\___ \

| |___| (_| | | | (_| |\ V / __/ |____) |

|______\__,_|_| \__,_| \_/ \___|_|_____/

Speed up your Laravel/Lumen

>>> Components

+---------------------------+--------------------------------------+

| Component | Version |

+---------------------------+--------------------------------------+

| PHP | 7.3.9-1+ubuntu16.04.1+deb.sury.org+1 |

| Swoole | 4.4.5 |

| LaravelS | 3.5.10 |

| Laravel Framework [local] | 5.6.39 |

+---------------------------+--------------------------------------+

>>> Protocols

+-----------+--------+-------------------+----------------+

+-----------+--------+-------------------+----------------+

| Main HTTP | On | Laravel Framework | 127.0.0.1:5200 |

+-----------+--------+-------------------+----------------+

>>> Feedback: https://github.com/hhxsv5/laravel-s

[2019-09-21 16:54:46] [TRACE] Swoole is running, press Ctrl+C to quit.

OPEN IT ON THE BROWSER : http://localhost:5200/

Swoolec Loader

Use PHP7.3
Install it if not exist

sudo apt-get install php7.3 php7.3-fpm php7.3-mysql php7.3-curl php7.3-cgi php7.3-mbstring php-mcrypt php7.3-zip php7.3-xml php7.3-xmlrpc php-xdebug php7.3-intl php7.3-bcmath php7.3-soap php7.3-gd

1	sudo apt-get install php7.3 php7.3-fpm php7.3-mysql php7.3-curl php7.3-cgi php7.3-mbstring php-mcrypt php7.3-zip php7.3-xml php7.3-xmlrpc php-xdebug php7.3-intl php7.3-bcmath php7.3-soap php7.3-gd

Use php7.3 as default php

sudo ln -sfn /usr/bin/php7.3 /etc/alternatives/php

1	sudo ln -sfn /usr/bin/php7.3 /etc/alternatives/php

Check

php -v
PHP 7.3.9-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Sep  2 2019 12:54:04) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.9, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.3.9-1+ubuntu16.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies
    with Xdebug v2.7.2, Copyright (c) 2002-2019, by Derick Rethans

php -v

PHP 7.3.9-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Sep 2 2019 12:54:04) ( NTS )

TO ENABLE PHP 7.3 ON NGINX SERVER, PLS DO (MAKE SURE APACHE2 IS STOPPED IF IT’S RUNNING AND START NGINX):

IMPORTANT! ALSO NEED TO INSTALL php7.3-dev. THIS IS NEEDED WHEN I NEED TO COMPILE swoole SOURCE

sudo apt install php7.3-dev

1	sudo apt install php7.3-dev

CHECK php-config SOULD POINT TO php7.3

teddy@teddy:~/Documents/swoole-src$ php-config
Usage: /usr/bin/php-config [OPTION]
Options:
  --prefix            [/usr]
  --includes          [-I/usr/include/php/20180731 -I/usr/include/php/20180731/main -I/usr/include/php/20180731/TSRM -I/usr/include/php/20180731/Zend -I/usr/include/php/20180731/ext -I/usr/include/php/20180731/ext/date/lib ]
  --ldflags           [-L/usr/lib/php/20180731 ]
  --libs              [-lcrypt   -largon2 -lresolv -lcrypt -lz -lrt -lm -ldl -lnsl  -lxml2 -lssl -lcrypto -lpcre2-8 -lsodium -lcrypt -largon2 -lcrypt ]
  --extension-dir     [/usr/lib/php/20180731]
  --include-dir       [/usr/include/php/20180731]
  --man-dir           [/usr/share/man]
  --php-binary        [/usr/bin/php7.3]
  --php-sapis         [apache2handler cgi cli fpm ]
  --phpapi            [20180731]
  --configure-options [--includedir=/usr/include --mandir=/usr/share/man --infodir=/usr/share/info --disable-silent-rules --libdir=/usr/lib/x86_64-linux-gnu --libexecdir=/usr/lib/x86_64-linux-gnu --disable-maintainer-mode --disable-dependency-tracking --prefix=/usr --enable-cli --disable-cgi --disable-phpdbg --with-config-file-path=/etc/php/7.3/cli --with-config-file-scan-dir=/etc/php/7.3/cli/conf.d --build=x86_64-linux-gnu --host=x86_64-linux-gnu --config-cache --cache-file=/build/php7.3-MkRzm_/php7.3-7.3.9/config.cache --libdir=${prefix}/lib/php --libexecdir=${prefix}/lib/php --datadir=${prefix}/share/php/7.3 --program-suffix=7.3 --sysconfdir=/etc --localstatedir=/var --mandir=/usr/share/man --disable-all --disable-debug --disable-rpath --disable-static --with-pic --with-layout=GNU --without-pear --enable-filter --with-openssl=yes --with-password-argon2=/usr --with-pcre-regex=/usr --enable-hash --with-mhash=/usr --enable-libxml --enable-session --with-sodium --with-system-tzdata --with-zlib=/usr --with-zlib-dir=/usr --enable-dtrace --enable-pcntl --with-libedit=shared,/usr build_alias=x86_64-linux-gnu host_alias=x86_64-linux-gnu CFLAGS=-g -O2 -fPIE -fstack-protector-strong -Wformat -Werror=format-security -O2 -Wall -pedantic -fsigned-char -fno-strict-aliasing -g]
  --version           [7.3.9-1+ubuntu16.04.1+deb.sury.org+1]
  --vernum            [70309]

teddy@teddy:~/Documents/swoole-src$ php-config

Usage: /usr/bin/php-config [OPTION]

Options:

--prefix [/usr]

--includes [-I/usr/include/php/20180731 -I/usr/include/php/20180731/main -I/usr/include/php/20180731/TSRM -I/usr/include/php/20180731/Zend -I/usr/include/php/20180731/ext -I/usr/include/php/20180731/ext/date/lib ]

--ldflags [-L/usr/lib/php/20180731 ]

--libs [-lcrypt -largon2 -lresolv -lcrypt -lz -lrt -lm -ldl -lnsl -lxml2 -lssl -lcrypto -lpcre2-8 -lsodium -lcrypt -largon2 -lcrypt ]

--extension-dir [/usr/lib/php/20180731]

--include-dir [/usr/include/php/20180731]

--man-dir [/usr/share/man]

--php-binary [/usr/bin/php7.3]

--php-sapis [apache2handler cgi cli fpm ]

--phpapi [20180731]

--configure-options [--includedir=/usr/include --mandir=/usr/share/man --infodir=/usr/share/info --disable-silent-rules --libdir=/usr/lib/x86_64-linux-gnu --libexecdir=/usr/lib/x86_64-linux-gnu --disable-maintainer-mode --disable-dependency-tracking --prefix=/usr --enable-cli --disable-cgi --disable-phpdbg --with-config-file-path=/etc/php/7.3/cli --with-config-file-scan-dir=/etc/php/7.3/cli/conf.d --build=x86_64-linux-gnu --host=x86_64-linux-gnu --config-cache --cache-file=/build/php7.3-MkRzm_/php7.3-7.3.9/config.cache --libdir=${prefix}/lib/php --libexecdir=${prefix}/lib/php --datadir=${prefix}/share/php/7.3 --program-suffix=7.3 --sysconfdir=/etc --localstatedir=/var --mandir=/usr/share/man --disable-all --disable-debug --disable-rpath --disable-static --with-pic --with-layout=GNU --without-pear --enable-filter --with-openssl=yes --with-password-argon2=/usr --with-pcre-regex=/usr --enable-hash --with-mhash=/usr --enable-libxml --enable-session --with-sodium --with-system-tzdata --with-zlib=/usr --with-zlib-dir=/usr --enable-dtrace --enable-pcntl --with-libedit=shared,/usr build_alias=x86_64-linux-gnu host_alias=x86_64-linux-gnu CFLAGS=-g -O2 -fPIE -fstack-protector-strong -Wformat -Werror=format-security -O2 -Wall -pedantic -fsigned-char -fno-strict-aliasing -g]

--version [7.3.9-1+ubuntu16.04.1+deb.sury.org+1]

--vernum [70309]

THE NGINX MAIN CONFIG IN /etc/nginx/nginx.conf
THE DEFAULT VIRTUALHOST IN /etc/nginx/sites-available/default
EDIT IT TO ENABLE PARSING PHP FILE:

sudo gedit /etc/nginx/sites-available/default

1	sudo gedit /etc/nginx/sites-available/default

Use php7.3-fpm for fastcgi_pass

...
server {
        ...
        # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
	#
	location ~ \.php$ {
		include snippets/fastcgi-php.conf;
	...
		fastcgi_pass unix:/run/php/php7.3-fpm.sock;
	#	fastcgi_pass unix:/run/php/php7.2-fpm.sock;
	#	fastcgi_pass unix:/run/php/php7.0-fpm.sock;
	#	fastcgi_pass unix:/run/php/php5.6-fpm.sock;
	}

	...
}
...

...

server {

...

# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000

location ~ \.php$ {

include snippets/fastcgi-php.conf;

...

fastcgi_pass unix:/run/php/php7.3-fpm.sock;

# fastcgi_pass unix:/run/php/php7.2-fpm.sock;

# fastcgi_pass unix:/run/php/php7.0-fpm.sock;

# fastcgi_pass unix:/run/php/php5.6-fpm.sock;

}

...

}

...

THEN CHANGE PHP7.3-FPM SETTING:

sudo gedit /etc/php/7.3/fpm/php.ini

1	sudo gedit /etc/php/7.3/fpm/php.ini

CHANGE THE CONTENT:

cgi.fix_pathinfo=0
upload_max_filesize = 2000M -> (default 2M)
max_file_uploads = 2000 -> (default 20)
post_max_size = 2000M -> (default 8M)
max_execution_time = 6000 -> (default 30) in second
max_input_time = 600 -> (default 60) in second
memory_limit = 2560M -> (default 128M)

cgi.fix_pathinfo=0

upload_max_filesize = 2000M -> (default 2M)

max_file_uploads = 2000 -> (default 20)

post_max_size = 2000M -> (default 8M)

max_execution_time = 6000 -> (default 30) in second

max_input_time = 600 -> (default 60) in second

memory_limit = 2560M -> (default 128M)

THEN RESTART PHP7.3-FPM SERVICE:

sudo service php7.3-fpm restart

1	sudo service php7.3-fpm restart

CHECK NGINX SYNTAX: sudo nginx -t
RESTART NGINX: sudo service nginx restart
OPEN IT: http://localhost:8080/phpinfo.php (NEED TO CLEAR THE BROWSER CACHE FIRST)

INSTALL swoole FOR PHP7.3
IF YOU ALREADY INSTALLED IT FOR PHP7.2, YOU NEED TO REMOVE/UNINSTALL IT.
NOTE: TO UNINSTAL IT, USE PHP7.2 VERSION ON TERMINAL NOT PHP7.3
FIRST COMMENT IT from the cli php.ini and php-fpm php.ini files.

sudo gedit /etc/php/7.2/cli/php.ini

1	sudo gedit /etc/php/7.2/cli/php.ini

THEN

;extension=swoole.so

1	;extension=swoole.so

THEN DO THE SAME FOR php-fpm php.ini file (sudo gedit /etc/php/7.2/fpm/php.ini).
USE pecl TO UNINSTALL IT

sudo pecl uninstall swoole
Unable to remove "extension=swoole.so" from php.ini
uninstall ok: channel://pecl.php.net/swoole-4.4.5

sudo pecl uninstall swoole

Unable to remove "extension=swoole.so" from php.ini

uninstall ok: channel://pecl.php.net/swoole-4.4.5

NOTE: IT’S ALSO IMPORTANT TO DELETE/REMOVE swoole.so FILE IN /usr/lib/php/20170718/swoole.so MANUALLY. BECAUSE PHP7.3 USE EXTENSION DIR IN /usr/lib/php/20180731, MAKE SURE IF ALREADY EXIST swoole.so IN IT. REMOVE IT MANUALLY AS WELL!
NOTE: I TRIED TO INSTALL swoole 4.4.5 FROM SOURCE & COMPILE IT (READ: https://github.com/swoole/swoole-src) BUT ALWAYS FAILED AND GOT THIS ERROR

PHP Warning:  PHP Startup: Unable to load dynamic library 'swoole.so' (tried: /usr/lib/php/20180731/swoole.so (/usr/lib/php/20180731/swoole.so: undefined symbol: _zval_ptr_dtor), /usr/lib/php/20180731/swoole.so.so (/usr/lib/php/20180731/swoole.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

PHP Warning: PHP Startup: Unable to load dynamic library 'swoole.so' (tried: /usr/lib/php/20180731/swoole.so (/usr/lib/php/20180731/swoole.so: undefined symbol: _zval_ptr_dtor), /usr/lib/php/20180731/swoole.so.so (/usr/lib/php/20180731/swoole.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

I THINK THIS IS BECAUSE I MIXED THE INSTALLATION (FROM pecl AND FROM SOURCE) THEN FORGOT TO INSTALL php7.3-dev AND FORGOT TO REMOVE swoole.so MANUALLY IN /usr/lib/php/20180731/swoole.so

THEN INSTALL SWOOLE ON PHP7.3 TERMINAL
MAKE SURE THE PHP API VERSION FOR PHP7.3 IS ‘20180731’ NOT ‘20170718’

sudo pecl install swoole

WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update
downloading swoole-4.4.5.tgz ...
Starting to download swoole-4.4.5.tgz (1,426,083 bytes)
.........................................................................................................................................................................................................................................................................................done: 1,426,083 bytes
391 source files, building
running: phpize
Configuring for:
PHP Api Version:         20180731
Zend Module Api No:      20180731
Zend Extension Api No:   320180731
enable sockets supports? [no] : yes
enable openssl support? [no] : yes
enable http2 support? [no] : yes
enable mysqlnd support? [no] : yes
building in /tmp/pear/temp/pear-build-rootdBmsXg/swoole-4.4.5
...
Build process completed successfully
Installing '/usr/include/php/20180731/ext/swoole/config.h'
Installing '/usr/lib/php/20180731/swoole.so'
install ok: channel://pecl.php.net/swoole-4.4.5
configuration option "php_ini" is not set to php.ini location
You should add "extension=swoole.so" to php.ini

sudo pecl install swoole

WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update

downloading swoole-4.4.5.tgz ...

Starting to download swoole-4.4.5.tgz (1,426,083 bytes)

.........................................................................................................................................................................................................................................................................................done: 1,426,083 bytes

391 source files, building

running: phpize

Configuring for:

PHP Api Version: 20180731

Zend Module Api No: 20180731

Zend Extension Api No: 320180731

enable sockets supports? [no] : yes

enable openssl support? [no] : yes

enable http2 support? [no] : yes

enable mysqlnd support? [no] : yes

building in /tmp/pear/temp/pear-build-rootdBmsXg/swoole-4.4.5

...

Build process completed successfully

Installing '/usr/include/php/20180731/ext/swoole/config.h'

Installing '/usr/lib/php/20180731/swoole.so'

install ok: channel://pecl.php.net/swoole-4.4.5

configuration option "php_ini" is not set to php.ini location

You should add "extension=swoole.so" to php.ini

Then include the extension “extension=swoole.so” in php.ini file. For php-fpm, the php.ini file in “/etc/php/7.3/fpm/php.ini”

sudo gedit /etc/php/7.3/fpm/php.ini

1	sudo gedit /etc/php/7.3/fpm/php.ini

then add this new line:

...
extension=swoole.so
...

...

extension=swoole.so

...

Save then restart php7.3-fpm service

sudo service php7.3-fpm restart

1	sudo service php7.3-fpm restart

look it up phpinfo() result. It should show like this:THEN IN CLI

teddy@teddy:~/Documents/swoole-src$ php -m | grep swoole
swoole

1 2	teddy@teddy:~/Documents/swoole-src$ php -m \| grep swoole swoole

ADD loader73.so FILE.
Copy it manually (USE SUDO) TO php7.3 EXTENSION DIR (IN /usr/lib/php/20180731)

teddy@teddy:~/Documents/swoole-src$ sudo cp /home/teddy/Downloads/Ptcms_V4.2.8/loader73.so /usr/lib/php/20180731

1	teddy@teddy:~/Documents/swoole-src$ sudo cp /home/teddy/Downloads/Ptcms_V4.2.8/loader73.so /usr/lib/php/20180731

THEN ADD THE EXTENSION ‘loader73.so’ IN php.ini FILE. For php-fpm, the php.ini file in “/etc/php/7.3/fpm/php.ini”

sudo gedit /etc/php/7.3/fpm/php.ini

1	sudo gedit /etc/php/7.3/fpm/php.ini

THEN ADD:

...
extension=loader73.so
...

...

extension=loader73.so

...

PLS DO THE SAME IN php.ini FOR CLI IN /etc/php/7.3/cli/php.ini
THEN RESTART php7.3-fpm SERVICE

sudo service php7.3-fpm restart

1	sudo service php7.3-fpm restart

CHECK THE EXTENSION IN phpinfo (http://localhost:8080/phpinfo.php)
IT SHOULD SHOW LIKE THISCHECK IN CLI

teddy@teddy:~/Documents/swoole-src$ php -m | grep loader
you must remove the xdebug extension before use swoole_loader
swoole_loader

teddy@teddy:~/Documents/swoole-src$ php -m | grep loader

you must remove the xdebug extension before use swoole_loader

swoole_loader

WE ALSO NEED TO DISABLE xdebug EXTENSION. CHECK IF xdebug IS ENABLED

teddy@teddy:~/Documents/swoole-src$ php -i | grep xdebug
you must remove the xdebug extension before use swoole_loader
/etc/php/7.3/cli/conf.d/20-xdebug.ini,
xdebug
xdebug support => enabled
...

teddy@teddy:~/Documents/swoole-src$ php -i | grep xdebug

you must remove the xdebug extension before use swoole_loader

/etc/php/7.3/cli/conf.d/20-xdebug.ini,

xdebug

xdebug support => enabled

...

THEN I NEED TO DISABLE IT.

sudo gedit /etc/php/7.3/cli/conf.d/20-xdebug.ini

1	sudo gedit /etc/php/7.3/cli/conf.d/20-xdebug.ini

THEN DISABLE xdebug BY ADDING ‘;’ IN FRONT OF THE LINE LIKE THIS:

;zend_extension=xdebug.so

1	;zend_extension=xdebug.so

THEN RESTART php7.3-fpm SERVICE

sudo service php7.3-fpm restart

1	sudo service php7.3-fpm restart

MAKE THERE IS NO MORE WARNING ABOUT xdebug

teddy@teddy:~/Documents/swoole-src$ php -m | grep loader
swoole_loader

1 2	teddy@teddy:~/Documents/swoole-src$ php -m \| grep loader swoole_loader

SAMPLE FILES IN /home/teddy/Downloads/Ptcms_V4.2.8 DIR
IN THE DIR, COPY ‘env.example.php’ TO ‘env.php’ FILE
RUN FROM TERMINAL

teddy@teddy:~/Downloads/Ptcms_V4.2.8/public$ php index.php

1	teddy@teddy:~/Downloads/Ptcms_V4.2.8/public$ php index.php

THEN I GOT ERROR ABOUT MEMCACHE

#0  Kuxin\Response::error() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/kuxin.php:179]
#1  Kuxin\Kuxin::error()
#2  trigger_error() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/cache/memcached.php:25]
#3  Kuxin\Cache\Memcached->__construct()
#4  ReflectionClass->newInstanceArgs() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/loader.php:55]
#5  Kuxin\Loader::instance() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/cache.php:34]
#6  Kuxin\Cache->__construct()
#7  ReflectionClass->newInstanceArgs() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/loader.php:55]
#8  Kuxin\Loader::instance() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/di.php:24]
#9  Kuxin\DI::Cache() called at [/home/teddy/Downloads/Ptcms_V4.2.8/app/plugin/configcache/configcache.php:18]
#10 App\Plugin\ConfigCache\ConfigCache->handle() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/plugin.php:27]
#11 Kuxin\Plugin::call() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/kuxin.php:72]
#12 Kuxin\Kuxin::start() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/kuxin.php:193]
#13 include(/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/kuxin.php) called at [/home/teddy/Downloads/Ptcms_V4.2.8/public/index.php:5]

您尚未安装memcached扩展[/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/cache/memcached.php:25]

#0 Kuxin\Response::error() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/kuxin.php:179]

#1 Kuxin\Kuxin::error()

#2 trigger_error() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/cache/memcached.php:25]

#3 Kuxin\Cache\Memcached->__construct()

#4 ReflectionClass->newInstanceArgs() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/loader.php:55]

#5 Kuxin\Loader::instance() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/cache.php:34]

#6 Kuxin\Cache->__construct()

#7 ReflectionClass->newInstanceArgs() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/loader.php:55]

#8 Kuxin\Loader::instance() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/di.php:24]

#9 Kuxin\DI::Cache() called at [/home/teddy/Downloads/Ptcms_V4.2.8/app/plugin/configcache/configcache.php:18]

#10 App\Plugin\ConfigCache\ConfigCache->handle() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/plugin.php:27]

#11 Kuxin\Plugin::call() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/kuxin.php:72]

#12 Kuxin\Kuxin::start() called at [/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/kuxin.php:193]

#13 include(/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/kuxin.php) called at [/home/teddy/Downloads/Ptcms_V4.2.8/public/index.php:5]

您尚未安装memcached扩展[/home/teddy/Downloads/Ptcms_V4.2.8/kuxin/cache/memcached.php:25]

MAKE SURE memcached SERVICE IS RUNNING

sudo service --status-all

1	sudo service --status-all

teddy@teddy:~$ sudo service memcached status
● memcached.service - memcached daemon
   Loaded: loaded (/lib/systemd/system/memcached.service; enabled; vendor preset
   Active: active (running) since Rab 2019-09-18 08:36:16 WIB; 5h 40min ago
 Main PID: 1314 (memcached)
    Tasks: 6
   Memory: 2.0M
      CPU: 792ms
   CGroup: /system.slice/memcached.service
           └─1314 /usr/bin/memcached -m 64 -p 11211 -u memcache -l 127.0.0.1

Sep 18 08:36:16 teddy systemd[1]: Started memcached daemon.

teddy@teddy:~$ sudo service memcached status

● memcached.service - memcached daemon

Loaded: loaded (/lib/systemd/system/memcached.service; enabled; vendor preset

Active: active (running) since Rab 2019-09-18 08:36:16 WIB; 5h 40min ago

Main PID: 1314 (memcached)

Tasks: 6

Memory: 2.0M

CPU: 792ms

CGroup: /system.slice/memcached.service

└─1314 /usr/bin/memcached -m 64 -p 11211 -u memcache -l 127.0.0.1

Sep 18 08:36:16 teddy systemd[1]: Started memcached daemon.

ALSO CHECK IF memcached EXTENSION IS INSTALLED

teddy@teddy:~$ php -i | grep memcached

1	teddy@teddy:~$ php -i \| grep memcached

IF THERE IS NO OUTPUT, THEN INSTALL IT (REF: https://serverpilot.io/docs/how-to-install-the-php-memcache-extension)

sudo apt-get -y install gcc make autoconf libc-dev pkg-config
sudo apt-get -y install zlib1g-dev
sudo apt-get -y install libmemcached-dev
sudo pecl install memcached

sudo apt-get -y install gcc make autoconf libc-dev pkg-config

sudo apt-get -y install zlib1g-dev

sudo apt-get -y install libmemcached-dev

sudo pecl install memcached

HERE IS THE PROCESS

teddy@teddy:~$ sudo pecl install memcached
WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update
pecl/memcached can optionally use PHP extension "igbinary" (version >= 2.0)
pecl/memcached can optionally use PHP extension "msgpack" (version >= 2.0)
downloading memcached-3.1.3.tgz ...
Starting to download memcached-3.1.3.tgz (82,673 bytes)
....................done: 82,673 bytes
15 source files, building
running: phpize
Configuring for:
PHP Api Version:         20180731
Zend Module Api No:      20180731
Zend Extension Api No:   320180731
libmemcached directory [no] : no --disable-memcached-sasl
zlib directory [no] : 
use system fastlz [no] : 
enable igbinary serializer [no] : 
enable msgpack serializer [no] : 
enable json serializer [no] : 
enable server protocol [no] : 
enable sasl [yes] : 
enable sessions [yes] : 
building in /tmp/pear/temp/pear-build-rootNVsfwe/memcached-3.1.3
...
Build process completed successfully
Installing '/usr/lib/php/20180731/memcached.so'
install ok: channel://pecl.php.net/memcached-3.1.3
configuration option "php_ini" is not set to php.ini location
You should add "extension=memcached.so" to php.ini

teddy@teddy:~$ sudo pecl install memcached

WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update

pecl/memcached can optionally use PHP extension "igbinary" (version >= 2.0)

pecl/memcached can optionally use PHP extension "msgpack" (version >= 2.0)

downloading memcached-3.1.3.tgz ...

Starting to download memcached-3.1.3.tgz (82,673 bytes)

....................done: 82,673 bytes

15 source files, building

running: phpize

Configuring for:

PHP Api Version: 20180731

Zend Module Api No: 20180731

Zend Extension Api No: 320180731

libmemcached directory [no] : no --disable-memcached-sasl

zlib directory [no] :

use system fastlz [no] :

enable igbinary serializer [no] :

enable msgpack serializer [no] :

enable json serializer [no] :

enable server protocol [no] :

enable sasl [yes] :

enable sessions [yes] :

building in /tmp/pear/temp/pear-build-rootNVsfwe/memcached-3.1.3

...

Build process completed successfully

Installing '/usr/lib/php/20180731/memcached.so'

install ok: channel://pecl.php.net/memcached-3.1.3

configuration option "php_ini" is not set to php.ini location

You should add "extension=memcached.so" to php.ini

THEN MODIFY /etc/php/7.3/fpm/php.ini AND /etc/php/7.3/cli/php.ini FILE THEN ADD THE EXTENSION extension=memcached.so
THEN RESTART THE SERVICES

teddy@teddy:~$ sudo service php7.3-fpm restart
teddy@teddy:~$ sudo service nginx restart

1 2	teddy@teddy:~$ sudo service php7.3-fpm restart teddy@teddy:~$ sudo service nginx restart

Install Swoole on Ubuntu 16.04

Ref: https://github.com/swoole/swoole-docs/blob/master/get-started/installation.md
Install from pecl

teddy@teddy:~$ sudo pecl install swoole
[sudo] password for teddy: 
WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update
downloading swoole-4.4.5.tgz ...
Starting to download swoole-4.4.5.tgz (1,426,083 bytes)
.........................................................................................................................................................................................................................................................................................done: 1,426,083 bytes
391 source files, building
running: phpize
Configuring for:
PHP Api Version:         20170718
Zend Module Api No:      20170718
Zend Extension Api No:   320170718
enable sockets supports? [no] : yes
enable openssl support? [no] : yes
enable http2 support? [no] : yes
enable mysqlnd support? [no] : yes
building in /tmp/pear/temp/pear-build-rootIVbbu7/swoole-4.4.5
...
Build process completed successfully
Installing '/usr/include/php/20170718/ext/swoole/config.h'
Installing '/usr/lib/php/20170718/swoole.so'
install ok: channel://pecl.php.net/swoole-4.4.5
configuration option "php_ini" is not set to php.ini location
You should add "extension=swoole.so" to php.ini

teddy@teddy:~$ sudo pecl install swoole

[sudo] password for teddy:

WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update

downloading swoole-4.4.5.tgz ...

Starting to download swoole-4.4.5.tgz (1,426,083 bytes)

391 source files, building

running: phpize

Configuring for:

PHP Api Version: 20170718

Zend Module Api No: 20170718

Zend Extension Api No: 320170718

enable sockets supports? [no] : yes

enable openssl support? [no] : yes

enable http2 support? [no] : yes

enable mysqlnd support? [no] : yes

building in /tmp/pear/temp/pear-build-rootIVbbu7/swoole-4.4.5

...

Build process completed successfully

Installing '/usr/include/php/20170718/ext/swoole/config.h'

Installing '/usr/lib/php/20170718/swoole.so'

install ok: channel://pecl.php.net/swoole-4.4.5

configuration option "php_ini" is not set to php.ini location

You should add "extension=swoole.so" to php.ini

Then include the extension “extension=swoole.so” in php.ini file. For php-fpm, the php.ini file in “/etc/php/7.2/fpm/php.ini”

sudo gedit /etc/php/7.2/fpm/php.ini

1	sudo gedit /etc/php/7.2/fpm/php.ini

then add this new line:

...
extension=swoole.so
...

...

extension=swoole.so

...

Save then restart php7.2-fpm service

sudo service php7.2-fpm restart

1	sudo service php7.2-fpm restart

look it up phpinfo() result. It should show like this:Pls do the same thing for php cli. the php.ini file for php cli in “/etc/php/7.2/cli/php.ini”. So edit the file and add a new line for the extension “extension=swoole.so”. Check the extension is loaded on the terminal:

teddy@teddy:~$ php -m | grep swoole
swoole

1 2	teddy@teddy:~$ php -m \| grep swoole swoole

Note: I tried to do this via terminal

php -i | grep php.ini                      # check the php.ini file location
sudo echo "extension=swoole.so" > php.ini  # add the extension=swoole.so to the end of php.ini
php -m | grep swoole                       # check if the swoole extension has been enabled

php -i | grep php.ini # check the php.ini file location

sudo echo "extension=swoole.so" > php.ini # add the extension=swoole.so to the end of php.ini

php -m | grep swoole # check if the swoole extension has been enabled

But it didn’t work. The extension is not loaded so I put it manually in the php.ini for cli.
NOTE: IT NEED TO DISABLE ‘xdebug’ EXTENSION. CHECK IF xdebug IS ACTIVE/ENABLED:

teddy@teddy:~$ php -i | grep xdebug
/etc/php/7.2/cli/conf.d/20-xdebug.ini,
extension 'xdebug' detected
xdebug
xdebug support => enabled
...

teddy@teddy:~$ php -i | grep xdebug

/etc/php/7.2/cli/conf.d/20-xdebug.ini,

extension 'xdebug' detected

xdebug

xdebug support => enabled

...

IF IT IS ENABLED, THEN MODIFY ‘/etc/php/7.2/cli/conf.d/20-xdebug.ini’ FILE TO DISABLE xdebug BY ADDING ‘;’ IN FRONT OF THE LINE LIKE THIS:

;zend_extension=xdebug.so

1	;zend_extension=xdebug.so

IF xdebug IS ENABLED WHEN THE SERVER IS RUNNING, IT’D SPIT THIS WARNING:

teddy@teddy:~/Documents/works/swoole$ php server.php 
PHP Warning:  Swoole\Server::start(): Using Xdebug in coroutines is extremely dangerous, please notice that it may lead to coredump! in /home/teddy/Documents/works/swoole/server.php on line 21
PHP Stack trace:
PHP   1. {main}() /home/teddy/Documents/works/swoole/server.php:0
PHP   2. Swoole\Server->start() /home/teddy/Documents/works/swoole/server.php:21
...

teddy@teddy:~/Documents/works/swoole$ php server.php

PHP Warning: Swoole\Server::start(): Using Xdebug in coroutines is extremely dangerous, please notice that it may lead to coredump! in /home/teddy/Documents/works/swoole/server.php on line 21

PHP Stack trace:

PHP 1. {main}() /home/teddy/Documents/works/swoole/server.php:0

PHP 2. Swoole\Server->start() /home/teddy/Documents/works/swoole/server.php:21

...

TEST SWOOLE
ref: https://github.com/swoole/swoole-docs/blob/master/get-started/examples/tcp_server.md
Create a new file server.php

<?php
// Create the server object and listen 127.0.0.1:9501
$server = new swoole_server("127.0.0.1", 9501);

// Register the function for the event `connect`
$server->on('connect', function($server, $fd){
    echo "Client : Connect.\n";
});

// Register the function for the event `receive`
$server->on('receive', function($server, $fd, $from_id, $data){
    $server->send($fd, "Server: " . $data);
});

// Register the function for the event `close`
$server->on('close', function($server, $fd){
    echo "Client: {$fd} close.\n";
});

// Start the server
$server->start();

<?php

// Create the server object and listen 127.0.0.1:9501

$server = new swoole_server("127.0.0.1", 9501);

// Register the function for the event `connect`

$server->on('connect', function($server, $fd){

echo "Client : Connect.\n";

});

// Register the function for the event `receive`

$server->on('receive', function($server, $fd, $from_id, $data){

$server->send($fd, "Server: " . $data);

});

// Register the function for the event `close`

$server->on('close', function($server, $fd){

echo "Client: {$fd} close.\n";

});

// Start the server

$server->start();

Run the php in a terminal

teddy@teddy:~/Documents/works/swoole$ php server.php

1	teddy@teddy:~/Documents/works/swoole$ php server.php

then open another terminal and type ‘telnet 127.0.0.1 9501’

teddy@teddy:~$ telnet 127.0.0.1 9501
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.

teddy@teddy:~$ telnet 127.0.0.1 9501

Trying 127.0.0.1...

Connected to 127.0.0.1.

Escape character is '^]'.

The first terminal would print ‘Client : Connect’

teddy@teddy:~/Documents/works/swoole$ php server.php 
Client : Connect.

1 2	teddy@teddy:~/Documents/works/swoole$ php server.php Client : Connect.

You can connect with another new terminal.
To close the connection in the second terminal, press Ctrl + ] then type close in telnet>

teddy@teddy:~$ telnet 127.0.0.1 9501
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.

Server: 
hello
Server: hello
^]
telnet> close
Connection closed.

teddy@teddy:~$ telnet 127.0.0.1 9501

Trying 127.0.0.1...

Connected to 127.0.0.1.

Escape character is '^]'.

Server:

hello

Server: hello

telnet> close

Connection closed.

The first terminal would give response like this:

teddy@teddy:~/Documents/works/swoole$ php server.php 
Client : Connect.
Client : Connect.
Client: 1 close.

teddy@teddy:~/Documents/works/swoole$ php server.php

Client : Connect.

Client: 1 close.

Create web server
ref: https://github.com/swoole/swoole-docs/blob/master/get-started/examples/http_server.md
create a new file ‘http_server.php’

<?php
// Create the http server object 
$http_server = new swoole_http_server("127.0.0.1", 9503);

// Register the event of request
$http_server->on('request', function($request, $response){
    var_dump($request->get, $request->post);
    $response->header("Content-Type", "text/html;charset=utf-8");
    $response->end("<h1>Hello Swoole " . rand(1000, 9999) . "</h1>");
});

// Start the server
$http_server->start();

<?php

// Create the http server object

$http_server = new swoole_http_server("127.0.0.1", 9503);

// Register the event of request

$http_server->on('request', function($request, $response){

var_dump($request->get, $request->post);

$response->header("Content-Type", "text/html;charset=utf-8");

$response->end("<h1>Hello Swoole " . rand(1000, 9999) . "</h1>");

});

// Start the server

$http_server->start();

then run the server via terminal

teddy@teddy:~/Documents/works/swoole$ php http_server.php

1	teddy@teddy:~/Documents/works/swoole$ php http_server.php

Open it via web browser: http://127.0.0.1:9503/
It should show this message:

Hello Swoole 8267

1	Hello Swoole 8267

Install Microsoft Sql Server 2017 And The PHP Extension On Ubuntu 16.04

Ref: https://www.microsoft.com/en-us/sql-server/developer-get-started/php/ubuntu

1. Register the Microsoft Linux repositories and add their keys.
Note: it’d be better to use ‘sudo su’ first!

teddy@teddy:~$ curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   983  100   983    0     0   2323      0 --:--:-- --:--:-- --:--:--  2329
OK

teddy@teddy:~$ curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list | sudo tee /etc/apt/sources.list.d/mssql-server-2017.list
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    91  100    91    0     0    102      0 --:--:-- --:--:-- --:--:--   102
deb [arch=amd64] https://packages.microsoft.com/ubuntu/16.04/mssql-server-2017 xenial main

teddy@teddy:~$ curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

% Total % Received % Xferd Average Speed Time Time Time Current

Dload Upload Total Spent Left Speed

100 983 100 983 0 0 2323 0 --:--:-- --:--:-- --:--:-- 2329

teddy@teddy:~$ curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list | sudo tee /etc/apt/sources.list.d/mssql-server-2017.list

% Total % Received % Xferd Average Speed Time Time Time Current

Dload Upload Total Spent Left Speed

100 91 100 91 0 0 102 0 --:--:-- --:--:-- --:--:-- 102

deb [arch=amd64] https://packages.microsoft.com/ubuntu/16.04/mssql-server-2017 xenial main

2. Install SQL Server.
NOTE: I USE ‘sudo apt-get install mssql-server=14.0.3192.2-2’ INSTEAD OF ‘sudo apt-get install mssql-server’ BECAUSE I GOT AN ERROR FOR SQLCMD ‘Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.’
REF: https://stackoverflow.com/questions/57265913/error-tcp-provider-error-code-0x2746-during-the-sql-setup-in-linux-through-te

sudo apt-get update

sudo apt-get install mssql-server=14.0.3192.2-2
...
Setting up mssql-server (14.0.3223.3-15) ...

+--------------------------------------------------------------+
Please run 'sudo /opt/mssql/bin/mssql-conf setup'
to complete the setup of Microsoft SQL Server
+--------------------------------------------------------------+

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.
Processing triggers for libc-bin (2.23-0ubuntu10) ...

sudo apt-get update

sudo apt-get install mssql-server=14.0.3192.2-2

...

Setting up mssql-server (14.0.3223.3-15) ...

+--------------------------------------------------------------+

Please run 'sudo /opt/mssql/bin/mssql-conf setup'

to complete the setup of Microsoft SQL Server

+--------------------------------------------------------------+

SQL Server needs to be restarted in order to apply this setting. Please run

'systemctl restart mssql-server.service'.

Processing triggers for libc-bin (2.23-0ubuntu10) ...

3. Setup your SQL Server.
Note: I choose ‘Developer’ edition.

teddy@teddy:~$ sudo /opt/mssql/bin/mssql-conf setup
Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID)
  7) Enterprise Core (PAID)
  8) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.

Enter your edition(1-8): 2
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

Do you accept the license terms? [Yes/No]:yes

Enter the SQL Server system administrator password: 
The specified password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters
Enter the SQL Server system administrator password: 
Confirm the SQL Server system administrator password: 
Configuring SQL Server...

ForceFlush is enabled for this instance. 
ForceFlush feature is enabled for log durability.
Created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /lib/systemd/system/mssql-server.service.
Setup has completed successfully. SQL Server is now starting.

teddy@teddy:~$ sudo /opt/mssql/bin/mssql-conf setup

Choose an edition of SQL Server:

1) Evaluation (free, no production use rights, 180-day limit)

2) Developer (free, no production use rights)

3) Express (free)

4) Web (PAID)

5) Standard (PAID)

6) Enterprise (PAID)

7) Enterprise Core (PAID)

8) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at

https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409

Use of PAID editions of this software requires separate licensing through a

Microsoft Volume Licensing program.

By choosing a PAID edition, you are verifying that you have the appropriate

number of licenses in place to install and run this software.

Enter your edition(1-8): 2

The license terms for this product can be found in

/usr/share/doc/mssql-server or downloaded from:

https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409

The privacy statement can be viewed at:

https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

Do you accept the license terms? [Yes/No]:yes

Enter the SQL Server system administrator password:

The specified password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters

Enter the SQL Server system administrator password:

Confirm the SQL Server system administrator password:

Configuring SQL Server...

ForceFlush is enabled for this instance.

ForceFlush feature is enabled for log durability.

Created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /lib/systemd/system/mssql-server.service.

Setup has completed successfully. SQL Server is now starting.

SORRY, ONLY ADMIN CAN SHOW THIS!
Check the mssql-server service status

teddy@teddy:~$ sudo service mssql-server status
● mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor pre
   Active: active (running) since Kam 2019-09-05 10:37:58 WIB; 2min 40s ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
 Main PID: 21988 (sqlservr)
    Tasks: 142
   Memory: 665.3M
      CPU: 5.910s
   CGroup: /system.slice/mssql-server.service
           ├─21988 /opt/mssql/bin/sqlservr
           └─22018 /opt/mssql/bin/sqlservr

Sep 05 10:38:00 teddy sqlservr[21988]: [78B blob data]
Sep 05 10:38:00 teddy sqlservr[21988]: [84B blob data]
Sep 05 10:38:00 teddy sqlservr[21988]: [122B blob data]
Sep 05 10:38:00 teddy sqlservr[21988]: [145B blob data]
Sep 05 10:38:01 teddy sqlservr[21988]: [66B blob data]
Sep 05 10:38:01 teddy sqlservr[21988]: [75B blob data]
Sep 05 10:38:01 teddy sqlservr[21988]: [96B blob data]
Sep 05 10:38:01 teddy sqlservr[21988]: [100B blob data]
Sep 05 10:38:01 teddy sqlservr[21988]: [71B blob data]
Sep 05 10:38:01 teddy sqlservr[21988]: [124B blob data]

teddy@teddy:~$ sudo service mssql-server status

● mssql-server.service - Microsoft SQL Server Database Engine

Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor pre

Active: active (running) since Kam 2019-09-05 10:37:58 WIB; 2min 40s ago

Docs: https://docs.microsoft.com/en-us/sql/linux

Main PID: 21988 (sqlservr)

Tasks: 142

Memory: 665.3M

CPU: 5.910s

CGroup: /system.slice/mssql-server.service

├─21988 /opt/mssql/bin/sqlservr

└─22018 /opt/mssql/bin/sqlservr

Sep 05 10:38:00 teddy sqlservr[21988]: [78B blob data]

Sep 05 10:38:00 teddy sqlservr[21988]: [84B blob data]

Sep 05 10:38:00 teddy sqlservr[21988]: [122B blob data]

Sep 05 10:38:00 teddy sqlservr[21988]: [145B blob data]

Sep 05 10:38:01 teddy sqlservr[21988]: [66B blob data]

Sep 05 10:38:01 teddy sqlservr[21988]: [75B blob data]

Sep 05 10:38:01 teddy sqlservr[21988]: [96B blob data]

Sep 05 10:38:01 teddy sqlservr[21988]: [100B blob data]

Sep 05 10:38:01 teddy sqlservr[21988]: [71B blob data]

Sep 05 10:38:01 teddy sqlservr[21988]: [124B blob data]

NOTE: ERROR LOG IN /var/opt/mssql/log/error
MUST OPEN THE DIR WITH ‘sudo su’
4. Install the ODBC Driver and SQL Command Line Utility for SQL Server (SQLCMD)

teddy@teddy:~$ sudo su
root@teddy:/home/teddy# curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    79  100    79    0     0     89      0 --:--:-- --:--:-- --:--:--    89
root@teddy:/home/teddy# exit
exit

sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql17 mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sudo apt-get install unixodbc-dev

teddy@teddy:~$ sudo su

root@teddy:/home/teddy# curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

% Total % Received % Xferd Average Speed Time Time Time Current

Dload Upload Total Spent Left Speed

100 79 100 79 0 0 89 0 --:--:-- --:--:-- --:--:-- 89

root@teddy:/home/teddy# exit

exit

sudo apt-get update

sudo ACCEPT_EULA=Y apt-get install msodbcsql17 mssql-tools

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

source ~/.bashrc

sudo apt-get install unixodbc-dev

After installing SQLCMD, you can connect to SQL Server using the following command: sqlcmd -S localhost -U sa -P Yourpassword
SORRY, ONLY ADMIN CAN SHOW THIS!

Install the PHP Driver for SQL Server

teddy@teddy:~$ sudo pecl install sqlsrv
...
Build process completed successfully
Installing '/usr/lib/php/20170718/sqlsrv.so'
install ok: channel://pecl.php.net/sqlsrv-5.6.1
configuration option "php_ini" is not set to php.ini location
You should add "extension=sqlsrv.so" to php.ini

teddy@teddy:~$ sudo pecl install sqlsrv

...

Build process completed successfully

Installing '/usr/lib/php/20170718/sqlsrv.so'

install ok: channel://pecl.php.net/sqlsrv-5.6.1

configuration option "php_ini" is not set to php.ini location

You should add "extension=sqlsrv.so" to php.ini

THEN

teddy@teddy:~$ sudo pecl install pdo_sqlsrv
...
Build process completed successfully
Installing '/usr/lib/php/20170718/pdo_sqlsrv.so'
install ok: channel://pecl.php.net/pdo_sqlsrv-5.6.1
configuration option "php_ini" is not set to php.ini location
You should add "extension=pdo_sqlsrv.so" to php.ini

teddy@teddy:~$ sudo pecl install pdo_sqlsrv

...

Build process completed successfully

Installing '/usr/lib/php/20170718/pdo_sqlsrv.so'

install ok: channel://pecl.php.net/pdo_sqlsrv-5.6.1

configuration option "php_ini" is not set to php.ini location

You should add "extension=pdo_sqlsrv.so" to php.ini

THEN

teddy@teddy:~$ sudo su
root@teddy:/home/teddy# echo extension=pdo_sqlsrv.so >> `php --ini | grep "Scan for additional .ini files" | sed -e "s|.*:\s*||"`/30-pdo_sqlsrv.ini
root@teddy:/home/teddy# echo extension=sqlsrv.so >> `php --ini | grep "Scan for additional .ini files" | sed -e "s|.*:\s*||"`/20-sqlsrv.ini
root@teddy:/home/teddy# exit
exit

teddy@teddy:~$ sudo su

root@teddy:/home/teddy# echo extension=pdo_sqlsrv.so >> `php --ini | grep "Scan for additional .ini files" | sed -e "s|.*:\s*||"`/30-pdo_sqlsrv.ini

root@teddy:/home/teddy# echo extension=sqlsrv.so >> `php --ini | grep "Scan for additional .ini files" | sed -e "s|.*:\s*||"`/20-sqlsrv.ini

root@teddy:/home/teddy# exit

exit

NOTE: IT’D COPY THE FILES ’20-sqlsrv.ini’ AND ’30-pdo_sqlsrv.ini’ TO DIR /etc/php/7.2/cli/conf.d/
THEN
MODIFY ‘php.ini’ file for php7.2 fpm and (cli NO NEED???)

sudo gedit /etc/php/7.2/fpm/php.ini

1	sudo gedit /etc/php/7.2/fpm/php.ini

THEN INSERT THESE TWO LINES:

extension=sqlsrv.so
extension=pdo_sqlsrv.so

1 2	extension=sqlsrv.so extension=pdo_sqlsrv.so

NO NEED –>PLS DO THE SAME FOR ‘cli’: sudo gedit /etc/php/7.2/cli/php.ini

THEN COPY THE TWO INI FILES FROM ‘cli’ TO ‘fpm’

sudo cp /etc/php/7.2/cli/conf.d/20-sqlsrv.ini /etc/php/7.2/fpm/conf.d/
sudo cp /etc/php/7.2/cli/conf.d/30-pdo_sqlsrv.ini /etc/php/7.2/fpm/conf.d/

1 2	sudo cp /etc/php/7.2/cli/conf.d/20-sqlsrv.ini /etc/php/7.2/fpm/conf.d/ sudo cp /etc/php/7.2/cli/conf.d/30-pdo_sqlsrv.ini /etc/php/7.2/fpm/conf.d/

THEN RESTART PHP FPM

sudo service php7.2-fpm restart

1	sudo service php7.2-fpm restart

CHECK THEM IN phpinfo: http://localhost:8080/phpinfo.php

Create a database ‘SampleDB’ for your application

sqlcmd -S localhost -U sa -P Teddy@234 -Q "CREATE DATABASE SampleDB;"

1	sqlcmd -S localhost -U sa -P Teddy@234 -Q "CREATE DATABASE SampleDB;"

The DB will be exist in /var/opt/mssql/data/SampleDB.mdf and the log file.

Create a PHP app that connects to SQL Server and executes queries

teddy@teddy:~/Documents/works$ mkdir SqlServerSample
teddy@teddy:~/Documents/works$ cd SqlServerSample/

1 2	teddy@teddy:~/Documents/works$ mkdir SqlServerSample teddy@teddy:~/Documents/works$ cd SqlServerSample/

Create a new file ‘connect.php’

<?php
    ini_set('display_errors', 1);
    error_reporting(E_ALL);

    $serverName = "localhost";
    $connectionOptions = array(
        "Database" => "SampleDB",
        "Uid" => "sa",
        "PWD" => "Teddy@234"
    );
    //Establishes the connection
    $conn = sqlsrv_connect($serverName, $connectionOptions);
    if($conn)
        echo "OKAY, Connected again!\n";
?>

<?php

ini_set('display_errors', 1);

error_reporting(E_ALL);

$serverName = "localhost";

$connectionOptions = array(

"Database" => "SampleDB",

"Uid" => "sa",

"PWD" => "Teddy@234"

);

//Establishes the connection

$conn = sqlsrv_connect($serverName, $connectionOptions);

if($conn)

echo "OKAY, Connected again!\n";

RUN ON CLI:

teddy@teddy:~/Documents/works/SqlServerSample$ php connect.php 
OKAY, Connected again!

1 2	teddy@teddy:~/Documents/works/SqlServerSample$ php connect.php OKAY, Connected again!

NOTE: ON CLI I GOT THIS WARNING:

PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_sqlsrv' (tried: /usr/lib/php/20170718/pdo_sqlsrv (/usr/lib/php/20170718/pdo_sqlsrv: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/pdo_sqlsrv.so (/usr/lib/php/20170718/pdo_sqlsrv.so: undefined symbol: php_pdo_unregister_driver)) in Unknown on line 0
PHP Warning:  Module 'sqlsrv' already loaded in Unknown on line 0
OKAY, Connected!

PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlsrv' (tried: /usr/lib/php/20170718/pdo_sqlsrv (/usr/lib/php/20170718/pdo_sqlsrv: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/pdo_sqlsrv.so (/usr/lib/php/20170718/pdo_sqlsrv.so: undefined symbol: php_pdo_unregister_driver)) in Unknown on line 0

PHP Warning: Module 'sqlsrv' already loaded in Unknown on line 0

OKAY, Connected!

SOLUTION: REMOVE/COMMENT THE EXTENSIONS ‘sqlsvr’ AND ‘pdo_sqlsvr’ IN /etc/php/7.2/cli/php.ini FILES!
CHECK THE LOADED MODULE WITH: php -m
IT SHOULD BE ALREADY LOADED FOR CLI SO NO NEED TO INCLUDE THEM IN CLI php.ini BUT IT NEED TO INCLUDE FOR FPM php.ini !

ALSO RUN VIA WEB: http://localhost:8080/works/SqlServerSample/connect.php

UNINSTALL MS SQL SERVER
REF: https://dba.stackexchange.com/questions/174175/how-do-i-totally-remove-sql-server-2017-on-ubuntu

Uninstalling SQL Server on Ubuntu

sudo service mssql-server stop

sudo add-apt-repository --remove "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

# Remove those packages from the system.
sudo apt-get --purge remove mssql-server mssql-server-fts mssql-tools msodbcsql unixodbc-dev
sudo apt-get remove mssql-server msodbcsql unixodbc-dev

# Delete the SQL Server repositories
sudo rm /etc/apt/sources.list.d/mssql-* /etc/apt/sources.list.d/msprod*

# Remove the Microsoft keys.
sudo apt-key del "BC52 8686 B50D 79E3 39D3  721C EB3E 94AD BE12 29CF"

# Delete the Microsoft created directories
sudo rm -rf /var/opt/mssql/ /opt/{microsoft,mssql-tools,mssql}/ /usr/share/doc/{msodbcsql,mssql-server,mssql-tools}

sudo service mssql-server stop

sudo add-apt-repository --remove "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

# Remove those packages from the system.

sudo apt-get --purge remove mssql-server mssql-server-fts mssql-tools msodbcsql unixodbc-dev

sudo apt-get remove mssql-server msodbcsql unixodbc-dev

# Delete the SQL Server repositories

sudo rm /etc/apt/sources.list.d/mssql-* /etc/apt/sources.list.d/msprod*

# Remove the Microsoft keys.

sudo apt-key del "BC52 8686 B50D 79E3 39D3 721C EB3E 94AD BE12 29CF"

# Delete the Microsoft created directories

sudo rm -rf /var/opt/mssql/ /opt/{microsoft,mssql-tools,mssql}/ /usr/share/doc/{msodbcsql,mssql-server,mssql-tools}

Moodle

Download opencart from https://www.moodle.org
Then extract it in your root web directory
Read INSTALL.txt file to setup and install moodle

Setup with Nginx

teddy@teddy:~/Documents/works/moodle/upload$ sudo gedit /etc/nginx/sites-available/moodle.test

1	teddy@teddy:~/Documents/works/moodle/upload$ sudo gedit /etc/nginx/sites-available/moodle.test

Here is the content

server {
    listen 80;
    listen [::]:80;
    root /home/teddy/Documents/works/moodle;
    index  index.php index.html index.htm;
    server_name www.moodle.test moodle.test;

    error_log /home/teddy/Documents/works/moodle/var/log/moodle_errors.log; 
    access_log /home/teddy/Documents/works/moodle/var/log/moodle_access.log;

    location / {
        try_files $uri $uri/ =404;        
    }
 
    location /dataroot/ {
        internal;
        alias /home/teddy/Documents/works/moodledata/;
    }

    location ~ [^/]\.php(/|$) {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/run/php/php7.2-fpm.sock;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }

    gzip on;
    gzip_disable "msie6";

    gzip_comp_level 6;
    gzip_min_length 1100;
    gzip_buffers 16 8k;
    gzip_proxied any;
    gzip_types
    text/plain
    text/css
    text/js
    text/xml
    text/javascript
    application/javascript
    application/x-javascript
    application/json
    application/xml
    application/xml+rss
    image/svg+xml;
    gzip_vary on;
}

server {

listen 80;

listen [::]:80;

root /home/teddy/Documents/works/moodle;

index index.php index.html index.htm;

server_name www.moodle.test moodle.test;

error_log /home/teddy/Documents/works/moodle/var/log/moodle_errors.log;

access_log /home/teddy/Documents/works/moodle/var/log/moodle_access.log;

location / {

try_files $uri $uri/ =404;

}

location /dataroot/ {

internal;

alias /home/teddy/Documents/works/moodledata/;

}

location ~ [^/]\.php(/|$) {

include snippets/fastcgi-php.conf;

fastcgi_pass unix:/run/php/php7.2-fpm.sock;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

include fastcgi_params;

}

gzip on;

gzip_disable "msie6";

gzip_comp_level 6;

gzip_min_length 1100;

gzip_buffers 16 8k;

gzip_proxied any;

gzip_types

text/plain

text/css

text/js

text/xml

text/javascript

application/javascript

application/x-javascript

application/json

application/xml

application/xml+rss

image/svg+xml;

gzip_vary on;

}

NOTE: Pay attention on these lines

    location /dataroot/ {
        internal;
        alias /home/teddy/Documents/works/moodledata/;
    }

location /dataroot/ {

internal;

alias /home/teddy/Documents/works/moodledata/;

}

I HAVE TO PUT THEM THERE. IF NOT, I’D GET SESSION PROBLEM AND THE STATIC FILES (JS AND CSS) PATH WOULD NOT BE RECOGNIZED
REF: https://www.sudutbaca.com/cara-install-moodle-di-debian-9-menggunakan-nginx-mariadb-php7-2-fpm/

XXXdon’t forget to create the log file in var/log/system.log
Then

teddy@teddy:~/Documents/works/moodle$ sudo ln -s /etc/nginx/sites-available/moodle.test /etc/nginx/sites-enabled/moodle.test

1	teddy@teddy:~/Documents/works/moodle$ sudo ln -s /etc/nginx/sites-available/moodle.test /etc/nginx/sites-enabled/moodle.test

Then

teddy@teddy:~/Documents/works/moodle$ sudo gedit /etc/hosts

1	teddy@teddy:~/Documents/works/moodle$ sudo gedit /etc/hosts

Insert this line:

...
127.0.0.1 	moodle.test
...

...

127.0.0.1 moodle.test

...

Then check the nginx config and restart nginx

teddy@teddy:~/Documents/works/moodle$ sudo nginx -t
nginx: [warn] conflicting server name "" on 0.0.0.0:80, ignored
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
teddy@teddy:~/Documents/works/moodle$ sudo service nginx restart

teddy@teddy:~/Documents/works/moodle$ sudo nginx -t

nginx: [warn] conflicting server name "" on 0.0.0.0:80, ignored

nginx: the configuration file /etc/nginx/nginx.conf syntax is ok

nginx: configuration file /etc/nginx/nginx.conf test is successful

teddy@teddy:~/Documents/works/moodle$ sudo service nginx restart

Set the files owner

teddy@teddy:~/Documents/works/moodle$ sudo chown www-data:www-data -R .

1	teddy@teddy:~/Documents/works/moodle$ sudo chown www-data:www-data -R .

Open it on your browser http://moodle.test. For the first time, it’ll install Moodle.

Web address: http://moodle.test
Moodle directory: /home/teddy/Documents/works/moodle
Data directory: /home/teddy/Documents/works/moodledata

Web address: http://moodle.test

Moodle directory: /home/teddy/Documents/works/moodle

Data directory: /home/teddy/Documents/works/moodledata

Note: Create a new database ‘moodle’ with collation ‘utf8mb4_general_ci’
I THINK I ALSO NEED TO CHANGE (NOT SURE) config.php THEN ADD THESE NEW LINES

...
$CFG->xsendfile = 'X-Accel-Redirect';
$CFG->xsendfilealiases = array(
    '/dataroot/' => $CFG->dataroot
);

require_once(__DIR__ . '/lib/setup.php');
...

...

$CFG->xsendfile = 'X-Accel-Redirect';

$CFG->xsendfilealiases = array(

'/dataroot/' => $CFG->dataroot

);

require_once(__DIR__ . '/lib/setup.php');

...

Admin:
SORRY, ONLY ADMIN CAN SHOW THIS!
Admin page: http://moodle.test/my/

OpenCart 3

Download opencart from https://www.opencart.com
Then extract it in your root web directory
Read install.txt file to setup and install opencart

...
2. Rename config-dist.php to config.php and admin/config-dist.php to admin/config.php

3. For Linux/Unix make sure the following folders and files are writable.

		chmod 0755 or 0777 system/storage/cache/
		chmod 0755 or 0777 system/storage/download/
		chmod 0755 or 0777 system/storage/logs/
		chmod 0755 or 0777 system/storage/modification/
		chmod 0755 or 0777 system/storage/session/
		chmod 0755 or 0777 system/storage/upload/
		chmod 0755 or 0777 system/storage/vendor/
		chmod 0755 or 0777 image/
		chmod 0755 or 0777 image/cache/
		chmod 0755 or 0777 image/catalog/
		chmod 0755 or 0777 config.php
		chmod 0755 or 0777 admin/config.php

		If 0755 does not work try 0777.
...

...

2. Rename config-dist.php to config.php and admin/config-dist.php to admin/config.php

3. For Linux/Unix make sure the following folders and files are writable.

chmod 0755 or 0777 system/storage/cache/

chmod 0755 or 0777 system/storage/download/

chmod 0755 or 0777 system/storage/logs/

chmod 0755 or 0777 system/storage/modification/

chmod 0755 or 0777 system/storage/session/

chmod 0755 or 0777 system/storage/upload/

chmod 0755 or 0777 system/storage/vendor/

chmod 0755 or 0777 image/

chmod 0755 or 0777 image/cache/

chmod 0755 or 0777 image/catalog/

chmod 0755 or 0777 config.php

chmod 0755 or 0777 admin/config.php

If 0755 does not work try 0777.

...

Set the file permissions

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chmod -R 0755 system/*
[sudo] password for teddy: 
teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chmod -R 0755 image/*
teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chmod -R 0755 config.php 
teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chmod -R 0755 admin/config.php

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chmod -R 0755 system/*

[sudo] password for teddy:

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chmod -R 0755 image/*

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chmod -R 0755 config.php

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chmod -R 0755 admin/config.php

Setup with Nginx

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo gedit /etc/nginx/sites-available/opencart3.test

1	teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo gedit /etc/nginx/sites-available/opencart3.test

Here is the content

server {
    listen 80; 
    listen [::]:80;
    root /home/teddy/Documents/works/opencart-3.0.3.2/upload; #your document root
    server_name www.opencart3.test opencart3.test ;  # Your server name
    index index.php index.html index.htm ;

    # Webfonts,fonts
    location ~* \.(?:ttf|ttc|otf|eot|woff|woff2)$ {
        add_header "Access-Control-Allow-Origin" "*";
        expires 1y;
        access_log off;
        add_header Cache-Control "public";
    }

    # Media: images, icons, video, audio, HTC
    location ~* \.(?:jpg|jpeg|gif|png|ico|cur|gz|svg|svgz|mp4|ogg|ogv|webm|htc)$ {
        expires 1y;
        access_log off;
        add_header Cache-Control "public";
    }

    # Js, Css
    location ~* \.(?:css|js)$ {
        expires 1y;
        access_log off;
        add_header Cache-Control "public";
    }

    # Serve static files without touching php
    location / {
        try_files $uri $uri/ /index.php?$args;
    } 
    # pass requests for dynamic content to site
    location ~ [^/]\.php(/|$) {
        try_files $uri /index.php; 
        fastcgi_pass unix:/run/php/php7.2-fpm.sock;
        
        fastcgi_buffers 1024 4k;

        fastcgi_read_timeout 600s;
        fastcgi_connect_timeout 600s;

        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        #include fastcgi_params;
        #FOR DEVELOPMENT MODE ONLY - BEGIN
        fastcgi_param MAGE_IS_DEVELOPER_MODE true;
        fastcgi_param PHP_VALUE  display_startup_errors=on;
        fastcgi_param PHP_VALUE  display_errors=on;
        fastcgi_param PHP_VALUE  html_errors=on;
        fastcgi_param PHP_VALUE  log_errors=on;
        fastcgi_param PHP_VALUE  error_log=/home/teddy/Documents/works/opencart-3.0.3.2/upload/var/log/system.log;
        #FOR DEVELOPMENT MODE ONLY - END
        include fastcgi_params;
    }

    gzip on;
    gzip_disable "msie6";

    gzip_comp_level 6;
    gzip_min_length 1100;
    gzip_buffers 16 8k;
    gzip_proxied any;
    gzip_types
    text/plain
    text/css
    text/js
    text/xml
    text/javascript
    application/javascript
    application/x-javascript
    application/json
    application/xml
    application/xml+rss
    image/svg+xml;
    gzip_vary on;

    # Banned locations (only reached if the earlier PHP entry point regexes don't match)
    location ~* (\.php$|\.htaccess$|\.git) {
        deny all;
    }
}

server {

listen 80;

listen [::]:80;

root /home/teddy/Documents/works/opencart-3.0.3.2/upload; #your document root

server_name www.opencart3.test opencart3.test ; # Your server name

index index.php index.html index.htm ;

# Webfonts,fonts

location ~* \.(?:ttf|ttc|otf|eot|woff|woff2)$ {

add_header "Access-Control-Allow-Origin" "*";

expires 1y;

access_log off;

add_header Cache-Control "public";

}

# Media: images, icons, video, audio, HTC

location ~* \.(?:jpg|jpeg|gif|png|ico|cur|gz|svg|svgz|mp4|ogg|ogv|webm|htc)$ {

expires 1y;

access_log off;

add_header Cache-Control "public";

}

# Js, Css

location ~* \.(?:css|js)$ {

expires 1y;

access_log off;

add_header Cache-Control "public";

}

# Serve static files without touching php

location / {

try_files $uri $uri/ /index.php?$args;

}

# pass requests for dynamic content to site

location ~ [^/]\.php(/|$) {

try_files $uri /index.php;

fastcgi_pass unix:/run/php/php7.2-fpm.sock;

fastcgi_buffers 1024 4k;

fastcgi_read_timeout 600s;

fastcgi_connect_timeout 600s;

fastcgi_index index.php;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

#include fastcgi_params;

#FOR DEVELOPMENT MODE ONLY - BEGIN

fastcgi_param MAGE_IS_DEVELOPER_MODE true;

fastcgi_param PHP_VALUE display_startup_errors=on;

fastcgi_param PHP_VALUE display_errors=on;

fastcgi_param PHP_VALUE html_errors=on;

fastcgi_param PHP_VALUE log_errors=on;

fastcgi_param PHP_VALUE error_log=/home/teddy/Documents/works/opencart-3.0.3.2/upload/var/log/system.log;

#FOR DEVELOPMENT MODE ONLY - END

include fastcgi_params;

}

gzip on;

gzip_disable "msie6";

gzip_comp_level 6;

gzip_min_length 1100;

gzip_buffers 16 8k;

gzip_proxied any;

gzip_types

text/plain

text/css

text/js

text/xml

text/javascript

application/javascript

application/x-javascript

application/json

application/xml

application/xml+rss

image/svg+xml;

gzip_vary on;

# Banned locations (only reached if the earlier PHP entry point regexes don't match)

location ~* (\.php$|\.htaccess$|\.git) {

deny all;

}

NOTE: don’t forget to create the log file in var/log/system.log
Then

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo ln -s /etc/nginx/sites-available/opencart3.test /etc/nginx/sites-enabled/opencart3.test

1	teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo ln -s /etc/nginx/sites-available/opencart3.test /etc/nginx/sites-enabled/opencart3.test

Then

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo gedit /etc/hosts

1	teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo gedit /etc/hosts

Insert this line:

...
127.0.0.1 	opencart3.test
...

...

127.0.0.1 opencart3.test

...

Then check the nginx config and restart nginx

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo nginx -t
nginx: [warn] conflicting server name "" on 0.0.0.0:80, ignored
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo service nginx restart

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo nginx -t

nginx: [warn] conflicting server name "" on 0.0.0.0:80, ignored

nginx: the configuration file /etc/nginx/nginx.conf syntax is ok

nginx: configuration file /etc/nginx/nginx.conf test is successful

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo service nginx restart

Set the files owner

teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chown www-data:www-data -R .

1	teddy@teddy:~/Documents/works/opencart-3.0.3.2/upload$ sudo chown www-data:www-data -R .

Open it on your browser http://opencart3.test. For the first time, it’ll install OpenCart.
Note: Create a new database ‘opencart3’ with collation utf8-general-ci
Admin:
SORRY, ONLY ADMIN CAN SHOW THIS!
Then follow the instructions
NOTE: I also need to change the PHP setting in php.ini (IN THE opencart DIR). Change some settings like

...
;memory_limit = 64M
memory_limit = 1280M
...

...

;memory_limit = 64M

memory_limit = 1280M

...

admin url: http://opencart3.test/admin

opencart version 3.0.3.2 (/home/teddy/Documents/works/opencart-3.0.3.2/upload/index.php)

Create Apache2 Setting
CREATE A CONF

sudo gedit /etc/apache2/sites-available/opencart3.test.conf

1	sudo gedit /etc/apache2/sites-available/opencart3.test.conf

CONTENT

<VirtualHost opencart3.test:80>
  ServerName opencart3.test
  DocumentRoot "/home/satria/Documents/projects/opencart-3.0.3.8/upload"
  DirectoryIndex index.php
  <Directory "/home/satria/Documents/projects/opencart-3.0.3.8/upload">
      AllowOverride All
      Allow from All
      Require all granted
  </Directory>
  ErrorLog /var/log/apache2/opencart3.error.log
  CustomLog /var/log/apache2/opencart3.access.log combined
</VirtualHost>

ServerName opencart3.test

DocumentRoot "/home/satria/Documents/projects/opencart-3.0.3.8/upload"

DirectoryIndex index.php

AllowOverride All

Allow from All

Require all granted

</Directory>

ErrorLog /var/log/apache2/opencart3.error.log

CustomLog /var/log/apache2/opencart3.access.log combined

</VirtualHost>

ENABLE THE VIRTUALHOST

sudo a2ensite opencart3.test.conf

1	sudo a2ensite opencart3.test.conf

RELOAD APACHE2

sudo systemctl reload apache2

1	sudo systemctl reload apache2

CREATE THE HOST

sudo gedit /etc/hosts

1	sudo gedit /etc/hosts

127.0.0.1 opencart3.test

1	127.0.0.1 opencart3.test

RELOAD APACHE2

sudo systemctl reload apache2

1	sudo systemctl reload apache2

RENAME config-dist.php AND admin/config-dist.php TO config.php TO admin/config.php
SET THE FILE PERMISSIONS & RELOAD APACHE2

satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod -R 0755 .
satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod -R 0777 system/storage/
satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod 777 config.php
satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod 777 admin/config.php
satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod -R 777 image/

satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod -R 0755 .

satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod -R 0777 system/storage/

satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod 777 config.php

satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod 777 admin/config.php

satria@teddy:~/Documents/projects/opencart-3.0.3.8/upload$ sudo chmod -R 777 image/

Open: http://opencart3.test

SORRY, ONLY ADMIN CAN SHOW THIS!

Sylius Standard Edition

READ: https://sylius.com/download/
Make sure to use PHP 7.2
Download via composer and create a new app ‘sylius-app’

teddy@teddy:~/Documents/works/sylius$ composer create-project sylius/sylius-standard sylius-app

1	teddy@teddy:~/Documents/works/sylius$ composer create-project sylius/sylius-standard sylius-app

go to the app directory

teddy@teddy:~/Documents/works/sylius$ cd sylius-app/

1	teddy@teddy:~/Documents/works/sylius$ cd sylius-app/

Install!
NOTE: make sure the ‘timezone’ variable for PHP is already set! if not, You’d get this error ‘timezone | ERROR!’. Check the variable in /etc/php/7.2/cli/php.ini file. Set like this (for example): date.timezone = Asia/Jakarta
NOTE: Make sure to create a new file for override the default env. the new file is ‘.env.local’. (ref: https://docs.sylius.com/en/1.5/book/installation/installation.html)
I want this app stores file in ‘sylius_app’ database. So here is the file content

DATABASE_URL=mysql://username:password@host/my_sylius_database_name

1	DATABASE_URL=mysql://username:password@host/my_sylius_database_name

Change the parameters like username, password, etc to fit your system.
SORRY, ONLY ADMIN CAN SHOW THIS!
Then run the install command

teddy@teddy:~/Documents/works/sylius/sylius-app$ php bin/console sylius:installInstalling Sylius...
                                                                  
           ,                                                       
         ,;:,                                                      
       `;;;.:`                                                     
      `::;`  :`                                                    
       :::`   `          .'++:           ''.   '.                  
       `:::             :+',;+'          :+;  `+.                  
        ::::            +'   :'          `+;                       
        `:::,           '+`     ++    :+.`+; `++. ;+'    ''  ,++++.
         ,:::`          `++'.   .+:  `+' `+;  .+,  ;+    +'  +;  ''
          ::::`           ,+++.  '+` :+. `+;  `+,  ;+    +'  '+.   
   ,.     .::::             .++` `+: +'  `+;  `+,  ;+    +'  `;++; 
`;;.:::`   :::::             :+.  '+,+.  `+;  `+,  ;+   `+'     .++
 .;;;;;;::`.::::,       +'` `++   `++'   `+;  `+:  :+. `++'  '.  ;+
  ,;;;;;;;;;:::::       .+++++`    ;+,    ++;  ++, `'+++,'+' :++++,
   ,;;;;;;;;;:::`                  ;'                              
    :;;;;;;;;;:,                :.:+,                              
     ;;;;;;;;;:                 ;++,

Step 1 of 4. Checking system requirements.
------------------------------------------

Success! Your system can run Sylius properly.

Step 2 of 4. Setting up the database.
-------------------------------------

Creating Sylius database for environment dev.
 2/2 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 100%

Loading sample data for environment dev from suite default.
Warning! This action will erase your database.
Continue? (y/N) y
 1/1 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 100%


Step 3 of 4. Shop configuration.
--------------------------------

Currency (press enter to use USD): 
Adding US Dollar currency.
Language (press enter to use en_US): 
Adding American English Language.
Adding en_US locale.
Create your administrator account.
E-mail: advcha@yahoo.com
Username (press enter to use email): admin
Choose password:
Confirm password:
Administrator account successfully registered.


Step 4 of 4. Installing assets.
-------------------------------

Installing Sylius assets for environment dev.
Created "/home/teddy/Documents/works/sylius/sylius-app/public/assets" directory.
 1/1 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 100%

                                                                                
 [OK] Sylius has been successfully installed.                                   
                                                                                

You can now open your store at the following path under the website root: /

teddy@teddy:~/Documents/works/sylius/sylius-app$ php bin/console sylius:installInstalling Sylius...

,;:,

`;;;.:`

`::;` :`

:::` ` .'++: ''. '.

`::: :+',;+' :+; `+.

:::: +' :' `+;

`:::, '+` ++ :+.`+; `++. ;+' '' ,++++.

,:::` `++'. .+: `+' `+; .+, ;+ +' +; ''

::::` ,+++. '+` :+. `+; `+, ;+ +' '+.

,. .:::: .++` `+: +' `+; `+, ;+ +' `;++;

`;;.:::` ::::: :+. '+,+. `+; `+, ;+ `+' .++

.;;;;;;::`.::::, +'` `++ `++' `+; `+: :+. `++' '. ;+

,;;;;;;;;;::::: .+++++` ;+, ++; ++, `'+++,'+' :++++,

,;;;;;;;;;:::` ;'

:;;;;;;;;;:, :.:+,

;;;;;;;;;: ;++,

Step 1 of 4. Checking system requirements.

------------------------------------------

Success! Your system can run Sylius properly.

Step 2 of 4. Setting up the database.

-------------------------------------

Creating Sylius database for environment dev.

2/2 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 100%

Loading sample data for environment dev from suite default.

Warning! This action will erase your database.

Continue? (y/N) y

1/1 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 100%

Step 3 of 4. Shop configuration.

--------------------------------

Currency (press enter to use USD):

Adding US Dollar currency.

Language (press enter to use en_US):

Adding American English Language.

Adding en_US locale.

Create your administrator account.

E-mail: advcha@yahoo.com

Username (press enter to use email): admin

Choose password:

Confirm password:

Administrator account successfully registered.

Step 4 of 4. Installing assets.

-------------------------------

Installing Sylius assets for environment dev.

Created "/home/teddy/Documents/works/sylius/sylius-app/public/assets" directory.

1/1 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 100%

[OK] Sylius has been successfully installed.

You can now open your store at the following path under the website root: /

My settings:
SORRY, ONLY ADMIN CAN SHOW THIS!

Install Assets

teddy@teddy:~/Documents/works/sylius/sylius-app$ yarn install
yarn install v1.12.3
[1/4] Resolving packages...
[2/4] Fetching packages...
info fsevents@1.2.9: The platform "linux" is incompatible with this module.
info "fsevents@1.2.9" is an optional dependency and failed compatibility check. Excluding it from installation.
[3/4] Linking dependencies...
[4/4] Building fresh packages...
warning Your current version of Yarn is out of date. The latest version is "1.17.3", while you're on "1.12.3".
info To upgrade, run the following command:
$ curl --compressed -o- -L https://yarnpkg.com/install.sh | bash
Done in 12.45s.

teddy@teddy:~/Documents/works/sylius/sylius-app$ yarn install

yarn install v1.12.3

[1/4] Resolving packages...

[2/4] Fetching packages...

info fsevents@1.2.9: The platform "linux" is incompatible with this module.

info "fsevents@1.2.9" is an optional dependency and failed compatibility check. Excluding it from installation.

[3/4] Linking dependencies...

[4/4] Building fresh packages...

warning Your current version of Yarn is out of date. The latest version is "1.17.3", while you're on "1.12.3".

info To upgrade, run the following command:

$ curl --compressed -o- -L https://yarnpkg.com/install.sh | bash

Done in 12.45s.

Then run gulp to build the frontend

teddy@teddy:~/Documents/works/sylius/sylius-app$ yarn run gulp
yarn run v1.12.3
$ gulp build
[14:05:22] Requiring external module babel-register
[14:05:22] Using gulpfile ~/Documents/works/sylius/sylius-app/gulpfile.babel.js
[14:05:22] Starting 'build'...
[14:05:22] Starting 'buildAdmin'...
[14:05:22] Starting 'buildShop'...
[gulp-chug] Gulpfile, gulpfile.babel.js, contents is empty. Reading directly from disk...

teddy@teddy:~/Documents/works/sylius/sylius-app$ yarn run gulp

yarn run v1.12.3

$ gulp build

[14:05:22] Requiring external module babel-register

[14:05:22] Using gulpfile ~/Documents/works/sylius/sylius-app/gulpfile.babel.js

[14:05:22] Starting 'build'...

[14:05:22] Starting 'buildAdmin'...

[14:05:22] Starting 'buildShop'...

[gulp-chug] Gulpfile, gulpfile.babel.js, contents is empty. Reading directly from disk...

Run the cli server

teddy@teddy:~/Documents/works/sylius/sylius-app$ php bin/console server:start

                                                                                
 [OK] Server listening on http://127.0.0.1:8000

teddy@teddy:~/Documents/works/sylius/sylius-app$ php bin/console server:start

[OK] Server listening on http://127.0.0.1:8000

Open it on your browser: http://localhost:8000
Here is the screenshotsAdmin login: http://localhost:8000/admin/login

SORRY, ONLY ADMIN CAN SHOW THIS!
Here is the admin dashboardMODIFICATION
CREATE A NEW ROUTE AND CONTROLLER
READ: https://alanstorm.com/symfonys-service-container/
MODIFY THE ROUTE IN config/routes.yaml

a_unique_identifier:
    path: /advcha_helloworld
    methods: [GET]
    controller: App\MyControllers\Advcha\HelloWorldController::showHello

a_unique_identifier:

path: /advcha_helloworld

methods: [GET]

controller: App\MyControllers\Advcha\HelloWorldController::showHello

THEN CREATE A CONTROLLER IN src/MyControllers/Advcha/HelloWorldController.php

<?php
namespace App\MyControllers\Advcha;

use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;

class HelloWorldController extends AbstractController{
    public function showHello(){
        echo "Hello World!";
        exit;
    }
}

<?php

namespace App\MyControllers\Advcha;

use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;

class HelloWorldController extends AbstractController{

public function showHello(){

echo "Hello World!";

exit;

}

Setup Postfix on Ubuntu 16.04 Localhost and Use Gmail SMTP

READ: https://devanswers.co/configure-postfix-to-use-gmail-smtp-on-ubuntu-16-04-digitalocean-droplet/

Prerequisites
If your Gmail account uses 2-Step Verification, you must create an application specific password.

If you’re not using 2-Step Verification, please ensure that your Gmail account is configured to allow less secures apps.

Remove sendmail

sudo apt-get remove sendmail

1	sudo apt-get remove sendmail

1. Install Postfix

sudo apt-get update
sudo apt install -y postfix mailutils

1 2	sudo apt-get update sudo apt install -y postfix mailutils

Let’s update the package database first. On the first Postfix configuration screen, select OK by pressing TAB and ENTER. Select Internet Site and press ENTER. System mail name should be your domain name eg. example.com, press ENTER.
My mail name is teddy@teddy.localdomain
<NOTE>
PROBABLY THESE BELOW COMMAND NOT NEEDED:
I also need to install php-mail and php7.2-mail

sudo apt install php-mail and php7.2-mail

1	sudo apt install php-mail and php7.2-mail

modify php ini IN

sudo gedit /etc/php/7.2/fpm/php.ini

1	sudo gedit /etc/php/7.2/fpm/php.ini

OR FOR APACHE2 WEB SERVER

sudo gedit /etc/php/7.2/apache2/php.ini

1	sudo gedit /etc/php/7.2/apache2/php.ini

UNCOMMENT ‘sendmail_path’ THEN CHANGE TO

sendmail_path = /usr/sbin/sendmail -t -i

1	sendmail_path = /usr/sbin/sendmail -t -i

modify

sudo gedit /etc/hosts

1	sudo gedit /etc/hosts

like this:

127.0.0.1	teddy.localdomain teddy localhost
#127.0.0.1	localhost
#127.0.1.1	teddy

127.0.0.1 teddy.localdomain teddy localhost

#127.0.0.1 localhost

#127.0.1.1 teddy

Restart services

sudo service php7.2-fpm restart
sudo service nginx restart

1 2	sudo service php7.2-fpm restart sudo service nginx restart

OR FOR APACHE2 WEB SERVER

sudo service apache2 start

1	sudo service apache2 start

</NOTE>

Configure Postfix
Edit the Postfix configuration file.

sudo gedit /etc/postfix/main.cf

1	sudo gedit /etc/postfix/main.cf

Add the following to the end of the file.

relayhost = [smtp.gmail.com]:587
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
smtp_sasl_security_options = noanonymous
smtp_tls_CAfile = /etc/postfix/cacert.pem
smtp_use_tls = yes

relayhost = [smtp.gmail.com]:587

smtp_sasl_auth_enable = yes

smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd

smtp_sasl_security_options = noanonymous

smtp_tls_CAfile = /etc/postfix/cacert.pem

smtp_use_tls = yes

Save file and exit.

Create Password and DB Files
Create the sasl_passwd file which will store our credentials.

sudo gedit /etc/postfix/sasl_passwd

1	sudo gedit /etc/postfix/sasl_passwd

Insert the following:

[smtp.gmail.com]:587 username@gmail.com:password

1	[smtp.gmail.com]:587 username@gmail.com:password

SORRY, ONLY ADMIN CAN SHOW THIS!
Replace username and password with your own. Save file and exit. (Press CTRL + X, press Y and then press ENTER)

Create a hash database file for Postfix with the postmap command.

sudo postmap /etc/postfix/sasl_passwd

1	sudo postmap /etc/postfix/sasl_passwd

There should now be a file called sasl_passwd.db in the /etc/postfix/ directory.

For added security, we will only allow root user to read and write to sasl_passwd and sasl_passwd.db

sudo chown root:root /etc/postfix/sasl_passwd /etc/postfix/sasl_passwd.db
sudo chmod 0600 /etc/postfix/sasl_passwd /etc/postfix/sasl_passwd.db

1 2	sudo chown root:root /etc/postfix/sasl_passwd /etc/postfix/sasl_passwd.db sudo chmod 0600 /etc/postfix/sasl_passwd /etc/postfix/sasl_passwd.db

Sign Certificate
Now we are going to create the certificate.

cat /etc/ssl/certs/thawte_Primary_Root_CA.pem | sudo tee -a /etc/postfix/cacert.pem

1	cat /etc/ssl/certs/thawte_Primary_Root_CA.pem \| sudo tee -a /etc/postfix/cacert.pem

There should now be a certificate file called cacert.pem in /etc/postfix

Send a Test Mail
We’ll now send a test email message. Make sure to replace test@example.com with your own email address.

echo "Test Email message body" | mail -s "Email test subject" advcha@yahoo.com

1	echo "Test Email message body" \| mail -s "Email test subject" advcha@yahoo.com

Don’t forget to check your spam folder.

If you still haven’t received any mail, check the mail error log.

sudo tail /var/log/mail.log

1	sudo tail /var/log/mail.log

NOTE:
TO USE GMAIL SMPT, YOU NEED TO ACTIVATE (SET IT ON) ‘Less Secure app’ ON YOUR GMAIL ACCOUNT. LOGIN TO YOUR GMAIL THEN OPEN THIS LINK: https://www.google.com/settings/u/2/security/lesssecureapps
IT’D REDIRECT YOU THE ‘Less Secure app’ SETTING.