$> sudo apt-get install php php-apcu php-intl php-mbstring php-xml php-pgsql apache2
[sudo] password for ubuntu:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
apache2-bin apache2-data apache2-utils libapache2-mod-php7.4 libapr1
libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap libjansson4 liblua5.2-0
libonig5 libpq5 php-apcu-bc php-common php7.4 php7.4-cli php7.4-common
php7.4-intl php7.4-json php7.4-mbstring php7.4-opcache php7.4-pgsql
php7.4-readline php7.4-xml ssl-cert
Suggested packages:
apache2-doc apache2-suexec-pristine | apache2-suexec-custom www-browser
php-pear php-gd openssl-blacklist
The following NEW packages will be installed:
apache2 apache2-bin apache2-data apache2-utils libapache2-mod-php7.4 libapr1
libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap libjansson4 liblua5.2-0
libonig5 libpq5 php php-apcu php-apcu-bc php-common php-intl php-mbstring
php-pgsql php-xml php7.4 php7.4-cli php7.4-common php7.4-intl php7.4-json
php7.4-mbstring php7.4-opcache php7.4-pgsql php7.4-readline php7.4-xml
ssl-cert
0 upgraded, 32 newly installed, 0 to remove and 86 not upgraded.
Need to get 6880 kB of archives.
After this operation, 29.7 MB of additional disk space will be used.
Do you want to continue? [Y/n]Y
・・・・・・・・省略・・・・・・・・・
$> sudo apt-get install postgresql
[sudo] password for ubuntu:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libllvm10 libpq5 postgresql-12 postgresql-client-12
postgresql-client-common postgresql-common sysstat
Suggested packages:
postgresql-doc postgresql-doc-12 libjson-perl isag
The following NEW packages will be installed:
libllvm10 libpq5 postgresql postgresql-12 postgresql-client-12
postgresql-client-common postgresql-common sysstat
0 upgraded, 8 newly installed, 0 to remove and 55 not upgraded.
Need to get 30.6 MB of archives.
After this operation, 121 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
・・・・・・・省略・・・・・・・
Success. You can now start the database server using:
pg_ctlcluster 12 main start
Ver Cluster Port Status Owner Data directory Log file
12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log
update-alternatives: using /usr/share/postgresql/12/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
Setting up sysstat (12.2.0-2ubuntu0.1) ...
Creating config file /etc/default/sysstat with new version
update-alternatives: using /usr/bin/sar.sysstat to provide /usr/bin/sar (sar) in auto mode
Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /lib/systemd/system/sysstat.service.
Setting up postgresql (12+214ubuntu0.1) ...
Processing triggers for systemd (245.4-4ubuntu3.15) ...
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for libc-bin (2.31-0ubuntu9.2) ...
$>
$> sudo apt-get install imagemagick
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
gsfonts imagemagick-6-common imagemagick-6.q16 libfftw3-double3
libilmbase24 liblqr-1-0 libmagickcore-6.q16-6 libmagickcore-6.q16-6-extra
libmagickwand-6.q16-6 libnetpbm10 libopenexr24 netpbm
Suggested packages:
imagemagick-doc autotrace enscript ffmpeg gimp gnuplot grads graphviz hp2xx
html2ps libwmf-bin mplayer povray radiance texlive-base-bin transfig
ufraw-batch libfftw3-bin libfftw3-dev inkscape libjxr-tools
The following NEW packages will be installed:
gsfonts imagemagick imagemagick-6-common imagemagick-6.q16 libfftw3-double3
libilmbase24 liblqr-1-0 libmagickcore-6.q16-6 libmagickcore-6.q16-6-extra
libmagickwand-6.q16-6 libnetpbm10 libopenexr24 netpbm
0 upgraded, 13 newly installed, 0 to remove and 46 not upgraded.
Need to get 8135 kB of archives.
After this operation, 25.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
・・・・・以下省略・・・・・
$> su - postgres
Password: ********
postgres$>
postgres$> which createuser
/usr/bin/createuser
postgres$>
postgres$> createuser -S -D -R -P -E wikidbusr
Enter password for new role: *******
Enter it again:
postgres$> echo $?
0
postgres$> which createdb
/usr/bin/createdb
postgres$> createdb -O wikidbusr WIKIDB00
postgres$> echo $?
0
postgres$> echo $?
注)上記作業を”postgres”ユーザ以外で実行してしまうと、下記エラーとなる。
ubuntu$> sudo createuser -S -D -R -P -E wikidbusr
[sudo] password for ubuntu:
Enter password for new role:
Enter it again:
createuser: error: could not connect to database template1: FATAL: role "root" does not exist
ところで、これから使用するドライバは、MSやUSBメモリといったメーカからの提供ではなく、フリーソフト(USB Flash Drive driver for Windows 95 OSR/2.1)である。このダウンロードページw95usbflash11.zipか95usbflash11.exeをダウンロードして展開する。