Symfoware

# pkg install php73-pdo_pgsql

<?php
try {
    // ローカルのデータベース「sample」に
    // ユーザー名「pgadmin」、パスワード「password」で接続
    $db = new PDO ('pgsql:dbname=sample;host=localhost', 'pgadmin', 'P@ssw0rd');
    
    echo 'PostgreSQLと接続成功'.PHP_EOL;
    // 切断
    unset($db);
} catch (PDOException $e) {
    echo $e->getMessage();
}

# php sample.php
PostgreSQLと接続成功

<?php
try {
    // ローカルのデータベース「sample」に
    // ユーザー名「pgadmin」、パスワード「password」で接続
    $db = new PDO('pgsql:dbname=sample;host=localhost', 'pgadmin', 'P@ssw0rd');
    
    echo 'PostgreSQLと接続成功'.PHP_EOL;
    // データを追加
    $db->exec("INSERT INTO test (id, value) VALUES (1, 'テスト')");
    // データの検索
    $stmt = $db->query('SELECT * FROM test');
    while($row = $stmt->fetch()) {
        echo $row['id'].':'.$row['value'].PHP_EOL;
    }
    
    // 切断
    unset($db);
} catch (PDOException $e) {
    echo $e->getMessage();
}

# php sample.php
PostgreSQLと接続成功
1:テスト

# pkg install postgresql11-server

# vi /etc/rc.conf

keymap="jp.kbd"
ifconfig_re0="inet 192.168.1.104 netmask 255.255.255.0"
defaultrouter="192.168.1.1"
sshd_enable="YES"
nginx_enable="YES"
php_fpm_enable="YES"
postgresql_enable="YES"

# /usr/local/etc/rc.d/postgresql initdb
# /usr/local/etc/rc.d/postgresql start

# psql -h localhost -U postgres -d postgres
psql (11.1)
Type "help" for help.

postgres=#

# su postgres
$ createuser --pwprompt --interactive pgadmin
Enter password for new role: [パスワード入力]
Enter it again: [パスワード再入力]
Shall the new role be a superuser? (y/n) y

# psql -U pgadmin -d postgres
psql (11.1)
Type "help" for help.

postgres=# create database sample;
CREATE DATABASE

postgres=# create table test (id int, value text);
CREATE TABLE

postgres=# insert into test (id, value) values (1, 'test');
INSERT 0 1

postgres=# select * from test;
id | value
----+-------
1 | test
(1 row)

# vi /var/db/postgres/data11/postgresql.conf

#listen_addresses = 'localhost'
listen_addresses = '*'

# vi /var/db/postgres/data11/pg_hba.conf

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
host    all             all             192.168.1.0/24         md5

# service postgresql restart

# -*- coding:utf-8 -*-
import psycopg2
con = psycopg2.connect(
    host = "192.168.1.104",
    port = 5432,
    database="sample",
    user="pgadmin",
    password="P@ssw0rd")
con.close()
print('ok')

$ python sample.py
ok

# pkg update
# pkg search nginx
nginx-1.14.2_3,2             Robust and small WWW server
nginx-devel-1.15.8_1         Robust and small WWW server
nginx-full-1.14.2_1,2         Robust and small WWW server (full package)
nginx-lite-1.14.2_3,2         Robust and small WWW server (lite package)
nginx-naxsi-1.14.2_3,2         Robust and small WWW server (plus NAXSI)
nginx-prometheus-exporter-0.2.0 Prometheus exporter for NGINX and NGINX Plus stats
p5-Nginx-ReadBody-0.07_1     Nginx embeded perl module to read and evaluate a request body
p5-Nginx-Simple-0.07_1         Perl 5 module for easy to use interface for Nginx Perl Module
p5-Test-Nginx-0.26             Testing modules for Nginx C module development
py27-certbot-nginx-0.29.1     NGINX plugin for Certbot
py36-certbot-nginx-0.29.1     NGINX plugin for Certbot
rubygem-passenger-nginx-6.0.0_1 Modules for running Ruby on Rails and Rack applications

# pkg install nginx-full

# vi /etc/rc.conf

hostname="freebsd12"
keymap="jp.kbd"
ifconfig_re0="inet 192.168.1.104 netmask 255.255.255.0"
defaultrouter="192.168.1.1"
sshd_enable="YES"
nginx_enable="YES"

# service nginx start

Performing sanity check on nginx configuration:
nginx: [emerg] gethostbyname() failed in /usr/local/etc/nginx/nginx.conf:122
nginx: the configuration file /usr/local/etc/nginx/nginx.conf syntax is ok
nginx: configuration file /usr/local/etc/nginx/nginx.conf test is successful
Starting nginx.
nginx: [emerg] gethostbyname() failed in /usr/local/etc/nginx/nginx.conf:122

# vi /etc/hosts

::1                     localhost localhost.my.domain
127.0.0.1             localhost localhost.my.domain

::1                     localhost freebsd12
127.0.0.1             localhost freebsd12

# ping freebsd12
PING localhost (127.0.0.1): 56 data bytes
64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.044 ms
64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.058 ms

# service nginx restart
Performing sanity check on nginx configuration:
nginx: the configuration file /usr/local/etc/nginx/nginx.conf syntax is ok
nginx: configuration file /usr/local/etc/nginx/nginx.conf test is successful
Stopping nginx.
Waiting for PIDS: 2719.
Performing sanity check on nginx configuration:
nginx: the configuration file /usr/local/etc/nginx/nginx.conf syntax is ok
nginx: configuration file /usr/local/etc/nginx/nginx.conf test is successful
Starting nginx.

# pkg install php73

# php -v
PHP 7.3.2 (cli) (built: Feb 10 2019 01:13:38) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.2, Copyright (c) 1998-2018 Zend Technologies

# vi /etc/rc.conf

hostname="freebsd12"
keymap="jp.kbd"
ifconfig_re0="inet 192.168.1.104 netmask 255.255.255.0"
defaultrouter="192.168.1.1"
sshd_enable="YES"
nginx_enable="YES"
php_fpm_enable="YES"

# service php-fpm start

# vi /usr/local/etc/php-fpm.d/www.conf

; The address on which to accept FastCGI requests.
; Valid syntaxes are:
; 'ip.add.re.ss:port'    - to listen on a TCP socket to a specific IPv4 addres
s on
;                            a specific port;
; '[ip:6:addr:ess]:port' - to listen on a TCP socket to a specific IPv6 addres
s on
;                            a specific port;
; 'port'                 - to listen on a TCP socket to all addresses
;                            (IPv6 and IPv4-mapped) on a specific port;
; '/path/to/unix/socket' - to listen on a unix socket.
; Note: This value is mandatory.
listen = 127.0.0.1:9000

# vi /usr/local/etc/nginx/nginx.conf

        location ~ \.php$ {
            root         /usr/local/www/html;
            fastcgi_pass 127.0.0.1:9000;
            fastcgi_index index.php;
            fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
            include        fastcgi_params;
        }

# service nginx restart

# mkdir -p /usr/local/www/html
# echo "<?php phpinfo();" > /usr/local/www/html/info.php

Message from freetype2-2.9.1:

The 2.7.x series now uses the new subpixel hinting mode (V40 port's option) as
the default, emulating a modern version of ClearType. This change inevitably
leads to different rendering results, and you might change port's options to
adapt it to your taste (or use the new "FREETYPE_PROPERTIES" environment
variable).

The environment variable "FREETYPE_PROPERTIES" can be used to control the
driver properties. Example:

FREETYPE_PROPERTIES=truetype:interpreter-version=35 \
    cff:no-stem-darkening=1 \
    autofitter:warping=1

This allows to select, say, the subpixel hinting mode at runtime for a given
application.

The controllable properties are listed in the section "Controlling FreeType
Modules" in the reference's table of contents
(/usr/local/share/doc/freetype2/reference/ft2-toc.html, if documentation was installed).
Message from python27-2.7.15:

===========================================================================

Note that some standard Python modules are provided as separate ports
as they require additional dependencies. They are available as:

bsddb         databases/py-bsddb
gdbm            databases/py-gdbm
sqlite3         databases/py-sqlite3
tkinter         x11-toolkits/py-tkinter

===========================================================================
Message from ca_root_nss-3.42.1:

********************************* WARNING *********************************

FreeBSD does not, and can not warrant that the certification authorities
whose certificates are included in this package have in any way been
audited for trustworthiness or RFC 3647 compliance.

Assessment and verification of trust is the complete responsibility of the
system administrator.

*********************************** NOTE **********************************

This package installs symlinks to support root certificates discovery by
default for software that uses OpenSSL.

This enables SSL Certificate Verification by client software without manual
intervention.

If you prefer to do this manually, replace the following symlinks with
either an empty file or your site-local certificate bundle.

* /etc/ssl/cert.pem
* /usr/local/etc/ssl/cert.pem
* /usr/local/openssl/cert.pem

***************************************************************************
Message from python36-3.6.7:

===========================================================================

Note that some standard Python modules are provided as separate ports
as they require additional dependencies. They are available as:

py36-gdbm     databases/py-gdbm@py36
py36-sqlite3    databases/py-sqlite3@py36
py36-tkinter    x11-toolkits/py-tkinter@py36

===========================================================================
Message from trousers-0.3.14_2:

To run tcsd automatically, add the following line to /etc/rc.conf:

tcsd_enable="YES"

You might want to edit /usr/local/etc/tcsd.conf to reflect your setup.

If you want to use tcsd with software TPM emulator, use the following
configuration in /etc/rc.conf:

tcsd_enable="YES"
tcsd_mode="emulator"
tpmd_enable="YES"

To use TPM, add your_account to '_tss' group like following:

# pw groupmod _tss -m your_account
Message from dejavu-2.37:

Make sure that the freetype module is loaded. If it is not, add the following
line to the "Modules" section of your X Windows configuration file:

    Load "freetype"

Add the following line to the "Files" section of X Windows configuration file:

    FontPath "/usr/local/share/fonts/dejavu/"

Note: your X Windows configuration file is typically /etc/X11/XF86Config
if you are using XFree86, and /etc/X11/xorg.conf if you are using X.Org.
Message from ghostscript9-agpl-base-9.26:

This package installs a script named dvipdf that depends on dvips. If you
want to use this script you need to install print/tex-dvipsk.
Message from perl5-5.28.1:

The /usr/bin/perl symlink has been removed starting with Perl 5.20.
For shebangs, you should either use:

#!/usr/local/bin/perl

or

#!/usr/bin/env perl

The first one will only work if you have a /usr/local/bin/perl,
the second will work as long as perl is in PATH.
Message from apr-1.6.5.1.6.1_1:

/!\ ================================================================== /!\

The Apache Portable Runtime project removed support for FreeTDS with
version 1.6. Users requiring MS-SQL connectivity must migrate
configurations to use the added ODBC driver and FreeTDS' ODBC features.

/!\ ================================================================== /!\
Message from opencv-core-3.4.1_12:

===> NOTICE:

The opencv-core port currently does not have a maintainer. As a result, it is
more likely to have unresolved issues, not be up-to-date, or even be removed in
the future. To volunteer to maintain this port, please create an issue at:

https://bugs.freebsd.org/bugzilla

More information about port maintainership is available at:

https://www.freebsd.org/doc/en/articles/contributing/ports-contributing.html#maintain-port
Message from libinotify-20180201_1:

============================================================================

Libinotify functionality on FreeBSD is missing support for

- detecting a file being moved into or out of a directory within the
    same filesystem
- certain modifications to a symbolic link (rather than the
    file it points to.)

in addition to the known limitations on all platforms using kqueue(2)
where various open and close notifications are unimplemented.

This means the following regression tests will fail:

Directory notifications:
IN_MOVED_FROM
IN_MOVED_TO

Open/close notifications:
IN_OPEN
IN_CLOSE_NOWRITE
IN_CLOSE_WRITE

Symbolic Link notifications:
IN_DONT_FOLLOW
IN_ATTRIB
IN_MOVE_SELF
IN_DELETE_SELF

Kernel patches to address the missing directory and symbolic link
notifications are available from:

https://github.com/libinotify-kqueue/libinotify-kqueue/tree/master/patches

=============================================================================
You might want to consider increasing the kern.maxfiles tunable if you plan
to use this library for applications that need to monitor activity of a lot
of files.
=============================================================================
Message from libwmf-0.2.8.4_15:

===> NOTICE:

The libwmf port currently does not have a maintainer. As a result, it is
more likely to have unresolved issues, not be up-to-date, or even be removed in
the future. To volunteer to maintain this port, please create an issue at:

https://bugs.freebsd.org/bugzilla

More information about port maintainership is available at:

https://www.freebsd.org/doc/en/articles/contributing/ports-contributing.html#maintain-port
Message from liblqr-1-0.4.2:

==========================================================================
NOTE: In order to compile examples for liblqr, you will
also need pngwriter port (/usr/ports/graphics/pngwriter).
Examples are located in /usr/local/share/examples/liblqr-1
==========================================================================
Message from apache24-2.4.38:

To run apache www server from startup, add apache24_enable="yes"
in your /etc/rc.conf. Extra options can be found in startup script.

Your hostname must be resolvable using at least 1 mechanism in
/etc/nsswitch.conf typically DNS or /etc/hosts or apache might
have issues starting depending on the modules you are using.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

- apache24 default build changed from static MPM to modular MPM
- more modules are now enabled per default in the port
- icons and error pages moved from WWWDIR to DATADIR

If build with modular MPM and no MPM is activated in
httpd.conf, then mpm_prefork will be activated as default
MPM in etc/apache24/modules.d to keep compatibility with
existing php/perl/python modules!

Please compare the existing httpd.conf with httpd.conf.sample
and merge missing modules/instructions into httpd.conf!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Message from openldap-client-2.4.47:

************************************************************

The OpenLDAP client package has been successfully installed.

Edit
/usr/local/etc/openldap/ldap.conf
to change the system-wide client defaults.

Try `man ldap.conf' and visit the OpenLDAP FAQ-O-Matic at
http://www.OpenLDAP.org/faq/index.cgi?file=3
for more information.

************************************************************
Message from GeoIP-1.6.12_3:

GeoIP does not ship with the actual data files. You must download
them yourself! To obtain the free database, run:
# /usr/local/bin/geoipupdate.sh

If you are using the free database, you will need to create some
symlinks for the geoiplookup tools, as described in
https://github.com/maxmind/geoip-api-c/blob/master/NEWS.md

===> NOTICE:

This port is deprecated; you may wish to reconsider installing it:

Legacy databases no longer available. Switch to net/libmaxminddb instead.

It is scheduled to be removed on or after 2019-02-15.
Message from ruby-2.4.5_1,1:

====
Some of the standard commands are provided as separate ports for ease
of upgrading:

    devel/ruby-gems:    gem - RubyGems package manager
    devel/rubygem-rake:    rake - Ruby Make

And some of the standard libraries are provided as separate ports
since they require extra dependencies:

    databases/ruby-gdbm:    GDBM module

Install them as occasion demands.
====
Message from openjdk8-8.192.26_3:

======================================================================

This OpenJDK implementation requires fdescfs(5) mounted on /dev/fd and
procfs(5) mounted on /proc.

If you have not done it yet, please do the following:

    mount -t fdescfs fdesc /dev/fd
    mount -t procfs proc /proc

To make it permanent, you need the following lines in /etc/fstab:

    fdesc    /dev/fd        fdescfs        rw    0    0
    proc    /proc        procfs        rw    0    0

======================================================================
Message from postgresql95-client-9.5.15_2:

The PostgreSQL port has a collection of "side orders":

postgresql-docs
For all of the html documentation

p5-Pg
A perl5 API for client access to PostgreSQL databases.

postgresql-tcltk
If you want tcl/tk client support.

postgresql-jdbc
For Java JDBC support.

postgresql-odbc
For client access from unix applications using ODBC as access
method. Not needed to access unix PostgreSQL servers from Win32
using ODBC. See below.

ruby-postgres, py-psycopg2
For client access to PostgreSQL databases using the ruby & python
languages.

postgresql-plperl, postgresql-pltcl & postgresql-plruby
For using perl5, tcl & ruby as procedural languages.

postgresql-contrib
Lots of contributed utilities, postgresql functions and
datatypes. There you find pg_standby, pgcrypto and many other cool
things.

etc...
Message from nginx-full-1.14.2_1,2:

===================================================================
Recent version of the NGINX introduces dynamic modules support. In
FreeBSD ports tree this feature was enabled by default with the DSO
knob. Several vendor's and third-party modules have been converted
to dynamic modules. Unset the DSO knob builds an NGINX without
dynamic modules support.

To load a module at runtime, include the new `load_module'
directive in the main context, specifying the path to the shared
object file for the module, enclosed in quotation marks. When you
reload the configuration or restart NGINX, the module is loaded in.
It is possible to specify a path relative to the source directory,
or a full path, please see
https://www.nginx.com/blog/dynamic-modules-nginx-1-9-11/ and
http://nginx.org/en/docs/ngx_core_module.html#load_module for
details.

Default path for the NGINX dynamic modules is

/usr/local/libexec/nginx.
===================================================================

# vi /etc/ssh/sshd_config

#PermitRootLogin no
PermitRootLogin yes

# /etc/rc.d/sshd restart

$ ssh root@[サーバーのIP]