Ubuntu – Page 2 – My Projects & Live

Setup Sendmail on Ubuntu 20.04 Localhost and Use Gmail SMTP

READ: https://linuxconfig.org/configuring-gmail-as-sendmail-email-relay

SET APP PASSWORD ON GMAIL:
https://wpmailsmtp.com/gmail-less-secure-apps/#:~:text=What%20Is%20Less%20Secure%20Apps,with%20this%20setting%20turned%20on.

SORRY, ONLY ADMIN CAN SHOW THIS!
Modified php.ini in /etc/php/7.4/apache2

; For Unix only.  You may supply arguments as well (default: "sendmail -t -i").
; http://php.net/sendmail-path
sendmail_path = /usr/sbin/sendmail -t -i

; For Unix only. You may supply arguments as well (default: "sendmail -t -i").

; http://php.net/sendmail-path

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

RESTART APACHE2

satria@teddy:~$ sudo gedit /etc/php/7.4/apache2/php.ini

satria@teddy:~$ sudo systemctl restart apache2

satria@teddy:~$ sudo systemctl stop sendmail
satria@teddy:~$ sudo systemctl status sendmail

satria@teddy:~$ sudo gedit /etc/php/7.4/apache2/php.ini

satria@teddy:~$ sudo systemctl restart apache2

satria@teddy:~$ sudo systemctl stop sendmail

satria@teddy:~$ sudo systemctl status sendmail

THE SEND EMAIL TOOK A LONG TIME ON LOCAL.
STOP SENDMAIL SERVICE IF NEEDED

GRsynch

Before run this software, need to enable read-write mode for the backup directory. if not i’d get the error message: ‘Read-only file system’ and we can’t read and write the files.

SO on the terminal, run this :
sudo mount -o rw,remount /media/satria/Backup/

Then run the backup.
ALSO IF FOUND ANY ERROR ON THE BACKUP. PLS RUN THE ABOVE COMMAND THEN RUN THE BACKUP AGAIN!

Install Magento 2.4.0 on Ubuntu 18.04

Ref: https://www.rosehosting.com/blog/how-to-install-magento-2-4-with-lemp-stack-on-ubuntu-20-04/

Requirements: PHP7.4, Nginx/Apache2, MySQL, ElasticSearch

CHECK PHP VERSION. IF NOT PHP7.4, INSTALL/CHANGE IT TO 7.4

teddy@teddy:~$ php -v
PHP Warning:  Module 'curl' already loaded in Unknown on line 0
PHP 7.2.33-1+ubuntu18.04.1+deb.sury.org+1 (cli) (built: Aug  7 2020 14:44:29) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.2.33-1+ubuntu18.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies
    with blackfire v1.34.3~linux-x64-non_zts72, https://blackfire.io, by Blackfire

teddy@teddy:~$ php -v

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

PHP 7.2.33-1+ubuntu18.04.1+deb.sury.org+1 (cli) (built: Aug 7 2020 14:44:29) ( NTS )

with blackfire v1.34.3~linux-x64-non_zts72, https://blackfire.io, by Blackfire

FIND OUT IF THERE IS PHP7.4 INSTALLED OR NOT

teddy@teddy:~$ sudo update-alternatives --config php
There are 5 choices for the alternative php (providing /usr/bin/php).

  Selection    Path             Priority   Status
------------------------------------------------------------
  0            /usr/bin/php7.3   73        auto mode
  1            /usr/bin/php5.6   56        manual mode
  2            /usr/bin/php7.0   70        manual mode
  3            /usr/bin/php7.1   71        manual mode
* 4            /usr/bin/php7.2   72        manual mode
  5            /usr/bin/php7.3   73        manual mode

Press <enter> to keep the current choice[*], or type selection number:

teddy@teddy:~$ sudo update-alternatives --config php

There are 5 choices for the alternative php (providing /usr/bin/php).

Selection Path Priority Status

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

0 /usr/bin/php7.3 73 auto mode

1 /usr/bin/php5.6 56 manual mode

2 /usr/bin/php7.0 70 manual mode

3 /usr/bin/php7.1 71 manual mode

* 4 /usr/bin/php7.2 72 manual mode

5 /usr/bin/php7.3 73 manual mode

Press <enter> to keep the current choice[*], or type selection number:

IT SEEMS I HAVEN’T INSTALLED PHP7.4 YET (BUT I FOUND IT ON /etc/php/7.4). IT MEANS IT ALREADY INSTALLED BUT IT DIDN’T HAVE THE OTHERS MODULES (PHP-FPM, ETC). SO INSTALL THEM

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

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

NOTE: I HAVE TO INSTALL THEM VIA TELKOMSEL FLASH BECAUSE INDIHOME CAN’T INSTALL THEM!
CHECK AGAIN THE AVAILABLE PHP AND MAKE SURE PHP7.4 IS INSTALLED THEN SELECT IT

teddy@teddy:~$ sudo update-alternatives --config php
[sudo] password for teddy: 
There are 6 choices for the alternative php (providing /usr/bin/php).

  Selection    Path             Priority   Status
------------------------------------------------------------
  0            /usr/bin/php7.4   74        auto mode
  1            /usr/bin/php5.6   56        manual mode
  2            /usr/bin/php7.0   70        manual mode
  3            /usr/bin/php7.1   71        manual mode
* 4            /usr/bin/php7.2   72        manual mode
  5            /usr/bin/php7.3   73        manual mode
  6            /usr/bin/php7.4   74        manual mode

Press <enter> to keep the current choice[*], or type selection number: 6
update-alternatives: using /usr/bin/php7.4 to provide /usr/bin/php (php) in manual mode

teddy@teddy:~$ sudo update-alternatives --config php

[sudo] password for teddy:

There are 6 choices for the alternative php (providing /usr/bin/php).

Selection Path Priority Status

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

0 /usr/bin/php7.4 74 auto mode

1 /usr/bin/php5.6 56 manual mode

2 /usr/bin/php7.0 70 manual mode

3 /usr/bin/php7.1 71 manual mode

* 4 /usr/bin/php7.2 72 manual mode

5 /usr/bin/php7.3 73 manual mode

6 /usr/bin/php7.4 74 manual mode

Press <enter> to keep the current choice[*], or type selection number: 6

update-alternatives: using /usr/bin/php7.4 to provide /usr/bin/php (php) in manual mode

NOW

teddy@teddy:~$ php -v
PHP 7.4.12 (cli) (built: Oct 31 2020 17:04:09) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.12, Copyright (c), by Zend Technologies
    with Xdebug v2.9.8, Copyright (c) 2002-2020, by Derick Rethans

teddy@teddy:~$ php -v

PHP 7.4.12 (cli) (built: Oct 31 2020 17:04:09) ( NTS )

Zend Engine v3.4.0, Copyright (c) Zend Technologies

with Zend OPcache v7.4.12, Copyright (c), by Zend Technologies

THEN CHANGE PHP7.4-FPM SETTING:

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

1	sudo gedit /etc/php/7.4/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.4-FPM SERVICE:

sudo systemctl restart php7.4-fpm

1	sudo systemctl restart php7.4-fpm

CHECK NGINX SYNTAX: sudo nginx -t
RESTART NGINX: sudo systemctl restart nginx
OPEN IT: http://localhost/phpinfo.php (NEED TO CLEAR THE BROWSER CACHE FIRST)
IF YOU CAN’T OPEN http://localhost/phpinfo.php PROPERLY, PLS MAKE SURE THE NGINX CONFIGURATION FILE IS CORRECT

teddy@teddy:~$ sudo gedit /etc/nginx/sites-available/default

1	teddy@teddy:~$ sudo gedit /etc/nginx/sites-available/default

MAKE SURE THE ‘DEFAULT’ PORT IS 80 NOT 8080 AND THE PHP-FPM POINT TO PHP7.4

# Default server configuration
#
server {
	listen 80 default_server;
	listen [::]:80 default_server;

	...

	root /var/www/html;

	# Add index.php to the list if you are using PHP
	index index.html index.htm index.nginx-debian.html;

	server_name _;

	location / {
		# First attempt to serve request as file, then
		# as directory, then fall back to displaying a 404.
		try_files $uri $uri/ =404;
	}

	# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
	#
	location ~ \.php$ {
		include snippets/fastcgi-php.conf;
	#
	#	# With php7.0-cgi alone:
	#	fastcgi_pass 127.0.0.1:9000;
	#	# With php7.0-fpm:
		fastcgi_pass unix:/run/php/php7.4-fpm.sock; #USE PHP7.4-FPM
	#	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;
	}

	# deny access to .htaccess files, if Apache's document root
	# concurs with nginx's one
	#
	location ~ /\.ht {
		deny all;
	}
}

# Default server configuration

server {

listen 80 default_server;

listen [::]:80 default_server;

...

root /var/www/html;

# Add index.php to the list if you are using PHP

index index.html index.htm index.nginx-debian.html;

server_name _;

location / {

# First attempt to serve request as file, then

# as directory, then fall back to displaying a 404.

try_files $uri $uri/ =404;

}

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

location ~ \.php$ {

include snippets/fastcgi-php.conf;

# # With php7.0-cgi alone:

# fastcgi_pass 127.0.0.1:9000;

# # With php7.0-fpm:

fastcgi_pass unix:/run/php/php7.4-fpm.sock; #USE PHP7.4-FPM

# 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;

}

# deny access to .htaccess files, if Apache's document root

# concurs with nginx's one

location ~ /\.ht {

deny all;

}

OKAY. DON’T FORGET TO RESTART NGINX SERVICE

teddy@teddy:~$ sudo systemctl restart nginx

1	teddy@teddy:~$ sudo systemctl restart nginx

THE CURRENT PHP VERSION FOR FPM IS 7.4.12

CHECK STATUS ELASTICSEARCH

teddy@teddy:~$ sudo systemctl status elasticsearch

1	teddy@teddy:~$ sudo systemctl status elasticsearch

IF IT’S NOT ACTIVE OR DISABLED, THE START THE SERVICE

teddy@teddy:~$ sudo systemctl start elasticsearch

1	teddy@teddy:~$ sudo systemctl start elasticsearch

THEN CHECK THE ELASTICSEARCH VERSION BY OPENING THE PORT 9200 ON THE BROWSER: http://localhost:9200/
HERE IS THE FINE RESULT

{
  "name" : "teddy",
  "cluster_name" : "elasticsearch",
  "cluster_uuid" : "naHr_JQ-RaK7dDx1CAdiDw",
  "version" : {
    "number" : "7.8.0",
    "build_flavor" : "default",
    "build_type" : "deb",
    "build_hash" : "757314695644ea9a1dc2fecd26d1a43856725e65",
    "build_date" : "2020-06-14T19:35:50.234439Z",
    "build_snapshot" : false,
    "lucene_version" : "8.5.1",
    "minimum_wire_compatibility_version" : "6.8.0",
    "minimum_index_compatibility_version" : "6.0.0-beta1"
  },
  "tagline" : "You Know, for Search"
}

{

"name" : "teddy",

"cluster_name" : "elasticsearch",

"cluster_uuid" : "naHr_JQ-RaK7dDx1CAdiDw",

"version" : {

"number" : "7.8.0",

"build_flavor" : "default",

"build_type" : "deb",

"build_hash" : "757314695644ea9a1dc2fecd26d1a43856725e65",

"build_date" : "2020-06-14T19:35:50.234439Z",

"build_snapshot" : false,

"lucene_version" : "8.5.1",

"minimum_wire_compatibility_version" : "6.8.0",

"minimum_index_compatibility_version" : "6.0.0-beta1"

"tagline" : "You Know, for Search"

}

INSTALL MAGENTO 2.4 VIA COMMAND LINE — AVOID THIS BECAUSE SOMEHOW I GOT THE ‘DEV’ VERSION NOT STABLE VERSION. SO IT’D BE BETTER TO DOWNLOAD THE ARCHIVE HERE https://magento.com/tech-resources/download
CREATE A NEW DIR ‘magento24’ THEN USE GIT CLONE TO GET THE MAGENTO CODE (NOTE: IT TOOK A WHILE)

teddy@teddy:~$ cd Documents/works/magento24/

teddy@teddy:~/Documents/works/magento24$ git clone https://github.com/magento/magento2.git /home/teddy/Documents/works/magento24/

teddy@teddy:~$ cd Documents/works/magento24/

teddy@teddy:~/Documents/works/magento24$ git clone https://github.com/magento/magento2.git /home/teddy/Documents/works/magento24/

RUN ‘composer install’

teddy@teddy:~/Documents/works/magento24$ composer install

1	teddy@teddy:~/Documents/works/magento24$ composer install

BUT I GOT THIS ERROR

Problem 1
    - The requested PHP extension ext-soap * is missing from your system. Install or enable PHP's soap extension.
  Problem 2
    - Installation request for laminas/laminas-soap 2.8.0 -> satisfiable by laminas/laminas-soap[2.8.0].
    - laminas/laminas-soap 2.8.0 requires ext-soap * -> the requested PHP extension soap is missing from your system.

Problem 1

- The requested PHP extension ext-soap * is missing from your system. Install or enable PHP's soap extension.

Problem 2

- Installation request for laminas/laminas-soap 2.8.0 -> satisfiable by laminas/laminas-soap[2.8.0].

- laminas/laminas-soap 2.8.0 requires ext-soap * -> the requested PHP extension soap is missing from your system.

IT SEEMED I FORGOT TO INSTALL php-soap (THERE IS NO php7.4-soap). INSTALL IT

teddy@teddy:~/Documents/works/magento24$ sudo apt-get install php-soap

1	teddy@teddy:~/Documents/works/magento24$ sudo apt-get install php-soap

THEN ENABLE IT IN ‘/etc/php/7.4/cli/php.ini’ AND ‘/etc/php/7.4/fpm/php.ini’. FOR EXAMPLE

teddy@teddy:~/Documents/works/magento24$ sudo gedit /etc/php/7.4/cli/php.ini

1	teddy@teddy:~/Documents/works/magento24$ sudo gedit /etc/php/7.4/cli/php.ini

THEN UNCOMMENT

extension=soap

1	extension=soap

DON’T FORGET TO RESTART NGINX
CHECK IT

teddy@teddy:~/Documents/works/magento24$ php -i | grep -i soap
PHP Warning:  Module 'soap' already loaded in Unknown on line 0
/etc/php/7.4/cli/conf.d/20-soap.ini,
soap
Soap Client => enabled
Soap Server => enabled
soap.wsdl_cache => 1 => 1
soap.wsdl_cache_dir => /tmp => /tmp
soap.wsdl_cache_enabled => 1 => 1
soap.wsdl_cache_limit => 5 => 5
soap.wsdl_cache_ttl => 86400 => 86400

teddy@teddy:~/Documents/works/magento24$ php -i | grep -i soap

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

/etc/php/7.4/cli/conf.d/20-soap.ini,

soap

Soap Client => enabled

Soap Server => enabled

soap.wsdl_cache => 1 => 1

soap.wsdl_cache_dir => /tmp => /tmp

soap.wsdl_cache_enabled => 1 => 1

soap.wsdl_cache_limit => 5 => 5

soap.wsdl_cache_ttl => 86400 => 86400

ALSO CHECK IT ON http://localhost/phpinfo.php
IF EVERYTHING ALRIGHT, RERUN ‘composer install’
IF EVERYTHING ALRIGHT, THEN CREATE A NEW DATABASE ‘magento24’ WITH COLLATION ‘utf8mb4_unicode_520_ci’ THEN RUN THIS:

teddy@teddy:~/Documents/works/magento24$ php bin/magento setup:install --base-url=http://magento24.test/ --db-host=localhost --db-name=magento24 --db-user=root --db-password=teddy --admin-firstname=Satria --admin-lastname=Faestha --admin-email=advcha@yahoo.com --admin-user=madmin --admin-password=Teddy@222 --language=en_US --currency=USD --timezone=America/Chicago --use-rewrites=1

teddy@teddy:~/Documents/works/magento24$ php bin/magento setup:install --base-url=http://magento24.test/ --db-host=localhost --db-name=magento24 --db-user=root --db-password=teddy --admin-firstname=Satria --admin-lastname=Faestha --admin-email=advcha@yahoo.com --admin-user=madmin --admin-password=Teddy@222 --language=en_US --currency=USD --timezone=America/Chicago --use-rewrites=1

MAKE SURE EVEYTHING IS FINE

Starting Magento installation:
File permissions check...
[Progress: 1 / 834]
Required extensions check...
[Progress: 2 / 834]
Enabling Maintenance Mode...
[Progress: 3 / 834]
Installing deployment configuration...
[Progress: 4 / 834]
Installing database schema:
Schema creation/updates:
Module 'Magento_AdminAnalytics':
[Progress: 5 / 834]
Module 'Magento_Store':
...
[Progress: 832 / 834]
Post installation file permissions check...
For security, remove write permissions from these directories: '/home/teddy/Documents/works/magento24/app/etc'
[Progress: 833 / 834]
Write installation date...
[Progress: 834 / 834]
[SUCCESS]: Magento installation complete.
[SUCCESS]: Magento Admin URI: /admin_h6y3c2
Nothing to import.

Starting Magento installation:

File permissions check...

[Progress: 1 / 834]

Required extensions check...

[Progress: 2 / 834]

Enabling Maintenance Mode...

[Progress: 3 / 834]

Installing deployment configuration...

[Progress: 4 / 834]

Installing database schema:

Schema creation/updates:

Module 'Magento_AdminAnalytics':

[Progress: 5 / 834]

Module 'Magento_Store':

...

[Progress: 832 / 834]

Post installation file permissions check...

For security, remove write permissions from these directories: '/home/teddy/Documents/works/magento24/app/etc'

[Progress: 833 / 834]

Write installation date...

[Progress: 834 / 834]

[SUCCESS]: Magento installation complete.

[SUCCESS]: Magento Admin URI: /admin_h6y3c2

Nothing to import.

Change the ownership of the magento2 directory to www-data with the following command:

teddy@teddy:~/Documents/works/magento24$ sudo chown -R www-data:www-data /home/teddy/Documents/works/magento24/

1	teddy@teddy:~/Documents/works/magento24$ sudo chown -R www-data:www-data /home/teddy/Documents/works/magento24/

THEN CREATE NGINX CONFIG FILE

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

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

The content:

server {
    listen 80;
    server_name magento24.test;
    set $MAGE_ROOT /home/teddy/Documents/works/magento24;

    root $MAGE_ROOT;

    index index.php;
    autoindex off;
    charset UTF-8;
    error_page 404 403 = /errors/404.php;
    #add_header "X-UA-Compatible" "IE=Edge";
    client_max_body_size 100M;

    # PHP entry point for setup application
    location ~* ^/setup($|/) {
        root $MAGE_ROOT;
        location ~ ^/setup/index.php {
            fastcgi_split_path_info ^(.+?\.php)(/.*)$;
            fastcgi_buffers 1024 4k; 
            fastcgi_read_timeout 600s; 
            fastcgi_connect_timeout 600s;
            fastcgi_pass unix:/run/php/php7.4-fpm.sock; #FOR AWS SERVER
            #fastcgi_pass 127.0.0.1:9000;
            #fastcgi_index index.php;
            fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
            include fastcgi_params;
        }

        location ~ ^/setup/(?!pub/). {
            deny all;
        }

        location ~ ^/setup/pub/ {
            add_header X-Frame-Options "SAMEORIGIN";
        }
    }

    # PHP entry point for update application
    location ~* ^/update($|/) {
        root $MAGE_ROOT;

        location ~ ^/update/index.php {
            fastcgi_split_path_info ^(/update/index.php)(/.+)$;
            fastcgi_pass unix:/run/php/php7.4-fpm.sock; #FOR AWS SERVER
            #fastcgi_pass 127.0.0.1:9000;
            fastcgi_index index.php;
            fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
            fastcgi_param PATH_INFO $fastcgi_path_info;
            include fastcgi_params;
        }

        # Deny everything but index.php
        location ~ ^/update/(?!pub/). {
            deny all;
        }

        location ~ ^/update/pub/ {
            add_header X-Frame-Options "SAMEORIGIN";
        }
    }

    location / {
        try_files $uri $uri/ /index.php?$args;
    }

    location /pub/ {
        location ~ ^/pub/media/(downloadable|customer|import|theme_customization/.*\.xml) {
            deny all;
        }
        alias $MAGE_ROOT/pub/;
        add_header X-Frame-Options "SAMEORIGIN";
    }


    location ~ ^/pub/static/version {
        rewrite ^/pub/static/(version\d*/)?(.*)$ /pub/static/$2 last;
    }

    location /static/ {
        # Uncomment the following line in production mode
        # expires max;

        # Remove signature of the static files that is used to overcome the browser cache
        location ~ ^/static/version {
            rewrite ^/static/(version\d*/)?(.*)$ /static/$2 last;
        }

        location ~* \.(ico|jpg|jpeg|png|gif|svg|js|css|swf|eot|ttf|otf|woff|woff2)$ {
            add_header Cache-Control "public";
            add_header X-Frame-Options "SAMEORIGIN";
            expires +1y;

            if (!-f $request_filename) {
                rewrite ^/static/(version\d*/)?(.*)$ /static.php?resource=$2 last;
            }
        }

        location ~* \.(zip|gz|gzip|bz2|csv|xml)$ {
            add_header Cache-Control "no-store";
            add_header X-Frame-Options "SAMEORIGIN";
            expires off;

            if (!-f $request_filename) {
                rewrite ^/static/(version\d*/)?(.*)$ /static.php?resource=$2 last;
            }
        }

        if (!-f $request_filename) {
            rewrite ^/static/(version\d*/)?(.*)$ /static.php?resource=$2 last;
        }

        add_header X-Frame-Options "SAMEORIGIN";
    }

    location /media/ {
        try_files $uri $uri/ /get.php?$args;

        location ~ ^/media/theme_customization/.*\.xml {
            deny all;
        }

        location ~* \.(ico|jpg|jpeg|png|gif|svg|js|css|swf|eot|ttf|otf|woff|woff2)$ {
            add_header Cache-Control "public";
            add_header X-Frame-Options "SAMEORIGIN";
            expires +1y;
            try_files $uri $uri/ /get.php?$args;
        }

        location ~* \.(zip|gz|gzip|bz2|csv|xml)$ {
            add_header Cache-Control "no-store";
            add_header X-Frame-Options "SAMEORIGIN";
            expires off;
            try_files $uri $uri/ /get.php?$args;
        }

        add_header X-Frame-Options "SAMEORIGIN";
    }

    location /media/customer/ {
        deny all;
    }

    location /media/downloadable/ {
        deny all;
    }

    location /media/import/ {
        deny all;
    }

    # PHP entry point for main application
    location ~ (index|get|static|report|404|503)\.php$ {
        try_files $uri =404;
        fastcgi_pass unix:/run/php/php7.4-fpm.sock; #FOR AWS SERVER
        #fastcgi_pass 127.0.0.1:9000;
        fastcgi_buffers 1024 4k;

        fastcgi_read_timeout 600s;
        fastcgi_connect_timeout 600s;
        # to configure profiler in Magento 2
        fastcgi_param  MAGE_PROFILER html;

        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/magento24/var/log/system.log;
        #FOR DEVELOPMENT MODE ONLY - END
        include fastcgi_params;
        #FOR DEBUGGING WITH XDEBUG - BEGIN
        #fastcgi_read_timeout 600;
        #FOR DEBUGGING WITH XDEBUG - END
    }

    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;
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

server {

listen 80;

server_name magento24.test;

set $MAGE_ROOT /home/teddy/Documents/works/magento24;

root $MAGE_ROOT;

index index.php;

autoindex off;

charset UTF-8;

error_page 404 403 = /errors/404.php;

#add_header "X-UA-Compatible" "IE=Edge";

client_max_body_size 100M;

# PHP entry point for setup application

location ~* ^/setup($|/) {

root $MAGE_ROOT;

location ~ ^/setup/index.php {

fastcgi_split_path_info ^(.+?\.php)(/.*)$;

fastcgi_buffers 1024 4k;

fastcgi_read_timeout 600s;

fastcgi_connect_timeout 600s;

fastcgi_pass unix:/run/php/php7.4-fpm.sock; #FOR AWS SERVER

#fastcgi_pass 127.0.0.1:9000;

#fastcgi_index index.php;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

include fastcgi_params;

}

location ~ ^/setup/(?!pub/). {

deny all;

}

location ~ ^/setup/pub/ {

add_header X-Frame-Options "SAMEORIGIN";

}

# PHP entry point for update application

location ~* ^/update($|/) {

root $MAGE_ROOT;

location ~ ^/update/index.php {

fastcgi_split_path_info ^(/update/index.php)(/.+)$;

fastcgi_pass unix:/run/php/php7.4-fpm.sock; #FOR AWS SERVER

#fastcgi_pass 127.0.0.1:9000;

fastcgi_index index.php;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

fastcgi_param PATH_INFO $fastcgi_path_info;

include fastcgi_params;

}

# Deny everything but index.php

location ~ ^/update/(?!pub/). {

deny all;

}

location ~ ^/update/pub/ {

add_header X-Frame-Options "SAMEORIGIN";

}

location / {

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

}

location /pub/ {

location ~ ^/pub/media/(downloadable|customer|import|theme_customization/.*\.xml) {

deny all;

}

alias $MAGE_ROOT/pub/;

add_header X-Frame-Options "SAMEORIGIN";

}

location ~ ^/pub/static/version {

rewrite ^/pub/static/(version\d*/)?(.*)$ /pub/static/$2 last;

}

location /static/ {

# Uncomment the following line in production mode

# expires max;

# Remove signature of the static files that is used to overcome the browser cache

location ~ ^/static/version {

rewrite ^/static/(version\d*/)?(.*)$ /static/$2 last;

}

location ~* \.(ico|jpg|jpeg|png|gif|svg|js|css|swf|eot|ttf|otf|woff|woff2)$ {

add_header Cache-Control "public";

add_header X-Frame-Options "SAMEORIGIN";

expires +1y;

if (!-f $request_filename) {

rewrite ^/static/(version\d*/)?(.*)$ /static.php?resource=$2 last;

}

location ~* \.(zip|gz|gzip|bz2|csv|xml)$ {

add_header Cache-Control "no-store";

add_header X-Frame-Options "SAMEORIGIN";

expires off;

if (!-f $request_filename) {

rewrite ^/static/(version\d*/)?(.*)$ /static.php?resource=$2 last;

}

if (!-f $request_filename) {

rewrite ^/static/(version\d*/)?(.*)$ /static.php?resource=$2 last;

}

add_header X-Frame-Options "SAMEORIGIN";

}

location /media/ {

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

location ~ ^/media/theme_customization/.*\.xml {

deny all;

}

location ~* \.(ico|jpg|jpeg|png|gif|svg|js|css|swf|eot|ttf|otf|woff|woff2)$ {

add_header Cache-Control "public";

add_header X-Frame-Options "SAMEORIGIN";

expires +1y;

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

}

location ~* \.(zip|gz|gzip|bz2|csv|xml)$ {

add_header Cache-Control "no-store";

add_header X-Frame-Options "SAMEORIGIN";

expires off;

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

}

add_header X-Frame-Options "SAMEORIGIN";

}

location /media/customer/ {

deny all;

}

location /media/downloadable/ {

deny all;

}

location /media/import/ {

deny all;

}

# PHP entry point for main application

location ~ (index|get|static|report|404|503)\.php$ {

try_files $uri =404;

fastcgi_pass unix:/run/php/php7.4-fpm.sock; #FOR AWS SERVER

#fastcgi_pass 127.0.0.1:9000;

fastcgi_buffers 1024 4k;

fastcgi_read_timeout 600s;

fastcgi_connect_timeout 600s;

# to configure profiler in Magento 2

fastcgi_param MAGE_PROFILER html;

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/magento24/var/log/system.log;

#FOR DEVELOPMENT MODE ONLY - END

include fastcgi_params;

#FOR DEBUGGING WITH XDEBUG - BEGIN

#fastcgi_read_timeout 600;

#FOR DEBUGGING WITH XDEBUG - END

}

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;

}

Then

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

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

Then

sudo gedit /etc/hosts

1	sudo gedit /etc/hosts

Then insert

127.0.0.1 magento24.test

1	127.0.0.1 magento24.test

CHECK THE NGINX AND RESTART

sudo nginx -t

sudo service nginx restart

sudo nginx -t

sudo service nginx restart

IF NEEDED SET THE FILE PERMISSION and ownership

teddy@teddy:~/Documents/works/magento24$ sudo su
root@teddy:/home/teddy/Documents/works/magento24# find var vendor pub/static pub/media app/etc -type f -exec chmod g+w {} \;
root@teddy:/home/teddy/Documents/works/magento24# find var vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} \;
root@teddy:/home/teddy/Documents/works/magento24# chown -R www-data:www-data .
root@teddy:/home/teddy/Documents/works/magento24# chmod u+x bin/magento
root@teddy:/home/teddy/Documents/works/magento24# chmod -R 777 var/ pub/ app/etc/ setup/ generated/

teddy@teddy:~/Documents/works/magento24$ sudo su

root@teddy:/home/teddy/Documents/works/magento24# find var vendor pub/static pub/media app/etc -type f -exec chmod g+w {} \;

root@teddy:/home/teddy/Documents/works/magento24# find var vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} \;

root@teddy:/home/teddy/Documents/works/magento24# chown -R www-data:www-data .

root@teddy:/home/teddy/Documents/works/magento24# chmod u+x bin/magento

root@teddy:/home/teddy/Documents/works/magento24# chmod -R 777 var/ pub/ app/etc/ setup/ generated/

COMPILE

teddy@teddy:~/Documents/works/magento24$ sudo su -s /bin/bash www-data
www-data@teddy:/home/teddy/Documents/works/beautybeat$ php bin/magento setup:upgrade --keep-generated && php bin/magento setup:di:compile && php bin/magento setup:static-content:deploy -f && php bin/magento indexer:reindex && php bin/magento cache:clean && php bin/magento cache:flush

teddy@teddy:~/Documents/works/magento24$ sudo su -s /bin/bash www-data

www-data@teddy:/home/teddy/Documents/works/beautybeat$ php bin/magento setup:upgrade --keep-generated && php bin/magento setup:di:compile && php bin/magento setup:static-content:deploy -f && php bin/magento indexer:reindex && php bin/magento cache:clean && php bin/magento cache:flush

BUT WHEN I OPENED IT ON THE BROWSER http://magento24.test/
I GOT 404 ERROR.
FROM THE /var/log/nginx/error, I FOUND

2020/11/24 16:47:23 [error] 10247#10247: *15 directory index of "/home/teddy/Documents/works/magento24/" is forbidden, client: 127.0.0.1, server: magento24.test, request: "GET / HTTP/1.1", host: "magento24.test"

1	2020/11/24 16:47:23 [error] 10247#10247: *15 directory index of "/home/teddy/Documents/works/magento24/" is forbidden, client: 127.0.0.1, server: magento24.test, request: "GET / HTTP/1.1", host: "magento24.test"

I TRIED TO COPY index.php FILE INTO THE magento24 DIR. IT’S WORKING BUT IT FAILED TO LOAD THE STATIC FILES (CSS, JS, ETC) SO I THINK I’LL INSTALL IT VIA FILE DOWNLOADED ON https://magento.com/tech-resources/download
IT SEEMS THE COMMAND LINE INSTALLED THE DEV VERSION

teddy@teddy:~/Documents/works/magento24$ sudo su -s /bin/bash www-data
www-data@teddy:/home/teddy/Documents/works/magento24$ php bin/magento --version
PHP Warning:  Module 'soap' already loaded in Unknown on line 0
Magento CLI dev-2.4-develop

teddy@teddy:~/Documents/works/magento24$ sudo su -s /bin/bash www-data

www-data@teddy:/home/teddy/Documents/works/magento24$ php bin/magento --version

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

Magento CLI dev-2.4-develop

—
INSTALL FROM THE DOWNLOADED FILE (ALSO READ http://myprojects.advchaweb.com/index.php/2019/02/26/install-magento-2-3-on-ubuntu-16-04-and-nginx/)
BUT STUCK ON http://magento24.test/setup/#/landing
CAN’T FIND ANY BUTTON TO CONTINUE!!!

Install Printer HP Deskjet 2135 on Ubuntu 16.04

REF: https://martianuswb.com/?p=5378
AT FIRST I TRIED TO USE AUTOMATIC INSTALLATION INSTEAD OF THE CUSTOM ONE AND IT FAILED:

Running ‘sudo apt-get install –assume-yes libcupsimage2-dev’
Please wait, this may take several minutes…
error: Package install command failed with error code 100

error: A required dependency ‘cups (CUPS – Common Unix Printing System)’ is still missing.
error: A required dependency ‘cups-image (CUPS image – CUPS image development files)’ is still missing.
error: Installation cannot continue without these dependencies.
error: Please manually install this dependency and re-run this installer.

sudo apt-get install –reinstall libpng12-0=1.2.54-1ubuntu1.1 libpng-dev libcupsimage2-dev

Running ‘sudo apt-get install –assume-yes libcups2’
Please wait, this may take several minutes…
|Gtk-Message: Failed to load module “topmenu-gtk-module”
error: A required dependency ‘cups (CUPS – Common Unix Printing System)’ is still missing.

error: A required dependency ‘pyqt5 (PyQt 5- Qt interface for Python (for Qt version 4.x))’ is still missing.
error: Installation cannot continue without this dependency.
error: Please manually install this dependency and re-run this installer.

SOLUTION: USE CUSTOM INSTALLATION:
ALSO TRIED TO ENABLE CUPS SERVICE ???
teddy@teddy:~/Documents/HP_deskjet_2135$ sh hplip-3.20.3.run
Creating directory hplip-3.20.3
Verifying archive integrity… All good.
Uncompressing HPLIP 3.20.3 Self Extracting Archive……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

HP Linux Imaging and Printing System (ver. 3.20.3)
HPLIP Installer ver. 5.1

Copyright (c) 2001-18 HP Development Company, LP
This software comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to distribute it
under certain conditions. See COPYING file for more details.

Installer log saved in: hplip-install_Sun-10-May-2020_14:43:23.log

\
note: Defaults for each question are maked with a ‘*’. Press <enter> to accept the default.
/Gtk-Message: Failed to load module “topmenu-gtk-module”
-Gtk-Message: Failed to load module “topmenu-gtk-module”

INSTALLATION MODE
—————–
Automatic mode will install the full HPLIP solution with the most common options.
Custom mode allows you to choose installation options to fit specific requirements.

Please choose the installation mode (a=automatic*, c=custom, q=quit) : c

INTRODUCTION
————
This installer will install HPLIP version 3.20.3 on your computer.
Please close any running package management systems now (YaST, Adept, Synaptic, Up2date, etc).

DISTRO/OS CONFIRMATION
———————-
Distro appears to be Ubuntu 16.04.

Is “Ubuntu 16.04” your correct distro/OS and version (y=yes*, n=no, q=quit) ? y

DRIVER OPTIONS
————–
Would you like to install Custom Discrete Drivers or Class Drivers ( ‘d’= Discrete Drivers*,’c’= Class Drivers,’q’= Quit)? : d

Initializing. Please wait…

SELECT HPLIP OPTIONS
——————–
You can select which HPLIP options to enable. Some options require extra dependencies.

Do you wish to enable ‘Network/JetDirect I/O’ (y=yes*, n=no, q=quit) ? y
Do you wish to enable ‘Graphical User Interfaces (Qt4)’ (y=yes*, n=no, q=quit) ? y
Do you wish to enable ‘Graphical User Interfaces (Qt5)’ (y=yes, n=no*, q=quit) ? n
Do you wish to enable ‘PC Send Fax support’ (y=yes*, n=no, q=quit) ? n
Do you wish to enable ‘Scanning support’ (y=yes*, n=no, q=quit) ? y
Do you wish to enable ‘HPLIP documentation (HTML)’ (y=yes*, n=no, q=quit) ? y

ENTER USER PASSWORD
——————-
Please enter the sudoer (teddy)’s password:

INSTALLATION NOTES
——————
Enable the universe/multiverse repositories. Also be sure you are using the Ubuntu “Main” Repositories. See: https://help.ubuntu.com/community/Repositories/Ubuntu for more information. Disable the CD-ROM/DVD source if you do not have the Ubuntu installation media inserted in the drive.

Please read the installation notes. Press <enter> to continue or ‘q’ to quit:

SECURITY PACKAGES
—————–
AppArmor is installed.
AppArmor protects the application from external intrusion attempts making the application secure

Would you like to have this installer install the hplip specific policy/profile (y=yes*, n=no, q=quit) ? y

RUNNING PRE-INSTALL COMMANDS
—————————-
OK

CHECKING FOR NETWORK CONNECTION
——————————-
Network connection present.

RUNNING PRE-PACKAGE COMMANDS
—————————-
sudo dpkg –configure -a (Pre-depend step 1)
sudo apt-get install –yes –force-yes -f (Pre-depend step 2)
warning: An error occurred running ‘sudo apt-get update’
sudo apt-get update (Pre-depend step 3)
OK

DEPENDENCY AND CONFLICT RESOLUTION
———————————-
\Gtk-Message: Failed to load module “topmenu-gtk-module”
HPLIP-3.16.3 exists, this may conflict with the new one being installed.
Do you want to (‘i’= Remove and Install*, ‘q’= Quit)? :i
Starting uninstallation…
HPLIP uninstallation is completed

RUNNING POST-PACKAGE COMMANDS
—————————–
OK

RE-CHECKING DEPENDENCIES
————————
/Gtk-Message: Failed to load module “topmenu-gtk-module”
OK

RUNNING SCANJET DEPENDENCY COMMANDS
———————————–
sudo apt-get install –assume-yes python-pip (Scanjet-depend step 1)
sudo pip install –upgrade pip (Scanjet-depend step 2)
sudo apt-get install –assume-yes libleptonica-dev (Scanjet-depend step 3)
sudo apt-get install –assume-yes tesseract-ocr (Scanjet-depend step 4)
sudo apt-get install –assume-yes libtesseract-dev (Scanjet-depend step 5)
sudo -H pip install tesserocr (Scanjet-depend step 6)
sudo apt-get install –assume-yes libzbar-dev (Scanjet-depend step 7)
warning: Failed to install this Scanjet dependency package. Some Scanjet features will not work.
sudo apt-get install –assume-yes python-zbar (Scanjet-depend step 8)
sudo apt-get install –assume-yes python-opencv (Scanjet-depend step 9)
sudo apt-get install –assume-yes python-pypdf2 (Scanjet-depend step 10)
sudo -H pip install imutils (Scanjet-depend step 11)
sudo -H pip install pypdfocr (Scanjet-depend step 12)
warning: Failed to install this Scanjet dependency package. Some Scanjet features will not work.
sudo -H pip install scikit-image (Scanjet-depend step 13)
/
sudo -H pip install scipy (Scanjet-depend step 14)
OK

READY TO BUILD AND INSTALL
————————–
Ready to perform build and install. Press <enter> to continue or ‘q’ to quit:

PRE-BUILD COMMANDS
——————
OK

BUILD AND INSTALL
—————–
Running ‘./configure –with-hpppddir=/usr/share/ppd/HP –libdir=/usr/lib –prefix=/usr –enable-qt4 –disable-qt5 –enable-doc-build –disable-cups-ppd-install –disable-foomatic-drv-install –disable-libusb01_build –disable-foomatic-ppd-install –disable-hpijs-install –disable-class-driver –disable-udev_sysfs_rules –disable-policykit –enable-cups-drv-install –enable-hpcups-install –enable-network-build –enable-dbus-build –enable-scan-build –disable-fax-build –enable-apparmor_build’
Please wait, this may take several minutes…
Command completed successfully.

Running ‘make clean’
Please wait, this may take several minutes…
Command completed successfully.

Running ‘make’
Please wait, this may take several minutes…
Command completed successfully.

Running ‘sudo make install’
Please wait, this may take several minutes…
Command completed successfully.

Build complete.

POST-BUILD COMMANDS
——————-

CLOSE HP_SYSTRAY
—————-
Sending close message to hp-systray (if it is currently running)…
OK

HPLIP UPDATE NOTIFICATION
————————-
Do you want to check for HPLIP updates?. (y=yes*, n=no) : y

RESTART OR RE-PLUG IS REQUIRED
——————————
If you are installing a USB connected printer, and the printer was plugged in
when you started this installer, you will need to either restart your PC or
unplug and re-plug in your printer (USB cable only). If you choose to restart,
run this command after restarting: hp-setup (Note: If you are using a parallel
connection, you will have to restart your PC. If you are using network/wireless,
you can ignore and continue).

Restart or re-plug in your printer (r=restart, p=re-plug in*, i=ignore/continue, q=quit) : i

PRINTER SETUP
————-
Would you like to setup a printer now (y=yes*, n=no, q=quit) ? y
Please make sure your printer is connected and powered on at this time.
Do you want to setup printer in GUI mode? (u=GUI mode*, i=Interactive mode) : u

HP Linux Imaging and Printing System (ver. 3.20.3)
Printer/Fax Setup Utility ver. 9.0

warning: Fax setup disabled – Python 2.3+ required.
Gtk-Message: Failed to load module “topmenu-gtk-module”
Searching… (bus=usb, search=(None), desc=0)

Done.

RE-STARTING HP_SYSTRAY
———————-

HP Linux Imaging and Printing System (ver. 3.20.3)
System Tray Status Service ver. 2.0

Gtk-Message: Failed to load module “topmenu-gtk-module”
/usr/lib/python2.7/dist-packages/gtk-2.0/gtk/__init__.py:127: RuntimeWarning: PyOS_InputHook is not available for interactive use of PyGTK
set_interactive(1)
“sni-qt/11952” WARN 15:11:38.490 void StatusNotifierItemFactory::connectToSnw() Invalid interface to SNW_SERVICE
teddy@teddy:~/Documents/HP_deskjet_2135$
HP Linux Imaging and Printing System (ver. 3.20.3)
HP Device Manager ver. 15.0

warning: Fax disabled.
warning: Fax disabled.
warning: Please install version 2.0+ of Reportlab for coverpage support.
error: Fax address book disabled – Python 2.3+ required.
Gtk-Message: Failed to load module “topmenu-gtk-module”
\warning: Supplies information not available for this device.
warning: Supplies information not available for this device.
Gtk-Message: Failed to load module “topmenu-gtk-module”
Gtk-Message: Failed to load module “topmenu-gtk-module”

WHEN COMPUTER IS RESTARTED, I NEED TO START CUPS SERVICE

teddy@teddy:~$ sudo /etc/init.d/cups start
[ ok ] Starting cups (via systemctl): cups.service.

1 2	teddy@teddy:~$ sudo /etc/init.d/cups start [ ok ] Starting cups (via systemctl): cups.service.

SO COMPUTER CAN RECOGNIZE THE PRINTER!!!

Install VTiger 7 Open Source On Ubuntu 16.04

Download from https://sourceforge.net/projects/vtigercrm/
Extract the downloaded file.

My environment: PHP 7.3 FPM, MySQL 5.7, Nginx

SETUP LOCAL WITH NGINX

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

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

content:

server {
    listen 80; 
    listen [::]:80;
    root /home/teddy/Documents/works/vtigercrm; #your document root
    server_name www.vtigercrm.test vtigercrm.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/vtigercrm/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/vtigercrm; #your document root

server_name www.vtigercrm.test vtigercrm.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/vtigercrm/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/vtigercrm.test /etc/nginx/sites-enabled/vtigercrm.test

1

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

sudo gedit /etc/hosts

1

sudo gedit /etc/hosts

Like this:

... 127.0.0.1 vtigercrm.test ...

1
2
3

...
127.0.0.1 vtigercrm.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

Set file permission and owner:

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

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

CREATE A NEW DATABASE: vtigercrm COLLATION utf8mb4_general_ci

Test: http://vtigercrm.test/ –> INSTALLATION WORKING. THE INSTALLATION TOOK SAME TIME

Admin
username: admin
password: Admtiger

BUT I GOT THIS ERROR:

MySQL Server should be configured with:
sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

1 2	MySQL Server should be configured with: sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

DEBUG STEP:
/vtigercrm/languages/en_us/Install.php:

'ERR_DB_SQLMODE_NOTFRIENDLY' => 'MySQL Server should be configured with:<br> sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION',

1	'ERR_DB_SQLMODE_NOTFRIENDLY' => 'MySQL Server should be configured with:<br> sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION',

/vtigercrm/modules/Install/models/Utils.php:

...
public static function checkDbConnection($db_type, $db_hostname, $db_username, $db_password, $db_name, $create_db=false, $create_utf8_db=true, $root_user='', $root_password='') {
    ...
    $db_sqlmode_support = false; // does the database having friendly sql_mode?

    //Checking for database connection parameters
    if($db_type) {
        ...
        if(@$conn->Connect($db_hostname,$db_username,$db_password)) {
            ...
            $db_sqlmode_support = self::isMySQLSqlModeFriendly($conn);
            if($create_db && $db_sqlmode_support) {
                ...
            }

            ...
        }
    }
    ...

    if(!$db_type_status || !$db_server_status) {
        ...
    } elseif(!$db_sqlmode_support) {
        $error_msg = getTranslatedString('ERR_DB_SQLMODE_NOTFRIENDLY', 'Install');
    } elseif($db_creation_failed) {
        ...
    }
    ...
}
...
public static function isMySQLSqlModeFriendly($conn) {
    $rs = $conn->Execute("SHOW VARIABLES LIKE 'sql_mode'");
    if ($rs && ($row = $rs->fetchRow())) {
        $values = explode(',', strtoupper($row['Value']));
        $unsupported = array('ONLY_FULL_GROUP_BY', 'STRICT_TRANS_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE');
        foreach ($unsupported as $check) {
            if (in_array($check, $values)) {
                return false;
            }
        }
    }
    return true;
}
...

...

public static function checkDbConnection($db_type, $db_hostname, $db_username, $db_password, $db_name, $create_db=false, $create_utf8_db=true, $root_user='', $root_password='') {

...

$db_sqlmode_support = false; // does the database having friendly sql_mode?

//Checking for database connection parameters

if($db_type) {

...

if(@$conn->Connect($db_hostname,$db_username,$db_password)) {

...

$db_sqlmode_support = self::isMySQLSqlModeFriendly($conn);

if($create_db && $db_sqlmode_support) {

...

}

...

}

...

if(!$db_type_status || !$db_server_status) {

...

} elseif(!$db_sqlmode_support) {

$error_msg = getTranslatedString('ERR_DB_SQLMODE_NOTFRIENDLY', 'Install');

} elseif($db_creation_failed) {

...

}

...

}

...

public static function isMySQLSqlModeFriendly($conn) {

$rs = $conn->Execute("SHOW VARIABLES LIKE 'sql_mode'");

if ($rs && ($row = $rs->fetchRow())) {

$values = explode(',', strtoupper($row['Value']));

$unsupported = array('ONLY_FULL_GROUP_BY', 'STRICT_TRANS_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE');

foreach ($unsupported as $check) {

if (in_array($check, $values)) {

return false;

}

return true;

}

...

SOLUTION: MODIFY THE MYSQL SETTING IN /etc/mysql/my.cnf

sudo gedit /etc/mysql/my.cnf

1	sudo gedit /etc/mysql/my.cnf

MODIFY THE ‘sql_mode’ VALUES: –> PLS READ: https://www.percona.com/blog/2016/10/18/upgrading-to-mysql-5-7-beware-of-the-new-strict-mode/

...
#sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
...

...

#sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

...

SAVE AND THE RESTART MYSQL SERVICE

sudo service mysql restart

1	sudo service mysql restart

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}

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.

Category: Ubuntu

Setup Sendmail on Ubuntu 20.04 Localhost and Use Gmail SMTP

Mate Ubuntu Tips and Tricks

GRsynch

Install Magento 2.4.0 on Ubuntu 18.04

Install Printer HP Deskjet 2135 on Ubuntu 16.04

Install VTiger 7 Open Source On Ubuntu 16.04

Swoolec Loader

Install Swoole on Ubuntu 16.04

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

Setup Postfix on Ubuntu 16.04 Localhost and Use Gmail SMTP