# cd /etc/pki/tls/private/
# openssl genrsa -aes128 1024 > server.key
Generating RSA private key, 1024 bit long modulus
..................++++++
..........................................++++++
e is 65537 (0x10001)
Enter pass phrase:（パスフレーズ）
Verifying - Enter pass phrase:（同じパスフレーズ）
# cd /etc/pki/tls/private/
# openssl req -new -key server.key > server.csr
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [AU]:JP
State or Province Name (full name) [Some-State]:Tokyo
Locality Name (eg, city) []:空白
Organization Name (eg, company) [Internet Widgits Pty Ltd]:空白
Organizational Unit Name (eg, section) []:空白
Common Name (eg, YOUR name) []:設定したhostname
Email Address []:空白
Please enter the following 'extra' attributes
to be sent with your certificate request
A challenge password []:空白
An optional company name []:空白
# cd /etc/pki/tls/private/
# openssl x509 -in server.csr -days 36500 -req -signkey server.key > /etc/pki/tls/private/server.crt
Signature ok
subject=/C=JP/ST=Tokyo/L=Hoge/O=Hoge Ltd/OU=Hoge/CN=sp.local
Getting Private key
Enter pass phrase for server.key:（上記で指定したパスフレーズ）
# mv server.key server.key.bak
# openssl rsa -in server.key.bak > server.key
Enter pass phrase for server.key.back:（パスフレーズ）
writing RSA key
ここまでで秘密鍵と(オレオレ)証明書ができました。
さらに設定ファイルを編集
# vi /etc/httpd/conf.d/ssl.conf
Listen 443 https
(中略)
<VirtualHost _default_:443>
SetEnv SIMPLESAMLPHP_CONFIG_DIR /var/www/simplesaml/config # 追記
# General setup for the virtual host, inherited from global configuration
DocumentRoot "/var/www/simplesaml/www" # 編集
Alias /simplesaml "/var/www/simplesaml/www" # 追記
ServerName <設定したhostname>:443 # 編集
(中略)
# SSL Protocol support:
# List the enable protocol levels with which clients will be able to
# connect. Disable SSLv2 access by default:
SSLProtocol -all +TLSv1.2 # 編集
(中略)
# Server Certificate:
# Point SSLCertificateFile at a PEM encoded certificate. If
# the certificate is encrypted, then you will be prompted for a
# pass phrase. Note that a kill -HUP will prompt again. A new
# certificate can be generated using the genkey(1) command.
SSLCertificateFile /etc/pki/tls/private/server.crt # 編集
# Server Private Key:
# If the key is not combined with the certificate, use this
# directive to point at the key file. Keep in mind that if
# you've both a RSA and a DSA private key you can configure
# both in parallel (to also allow the use of DSA ciphers, etc.)
SSLCertificateKeyFile /etc/pki/tls/private/server.key
(中略)
# 最後に追記
<Directory /var/www/simplesaml/www>
<IfModule mod_authz_core.c>
Require all granted
</IfModule>
</Directory>
</VirtualHost>
$ bin/console doctrine:migrations:generate
Generated new migration class to "/var/www/html/app/DoctrineMigrations/Version20190529032556.php"
記載されているファイルを編集します。
<?phpdeclare(strict_types=1);namespaceDoctrineMigrations;useDoctrine\DBAL\Schema\Schema;useDoctrine\Migrations\AbstractMigration;/**
* Auto-generated Migration: Please modify to your needs!
*/finalclassVersion20190529063256extendsAbstractMigration{publicfunctionup(Schema$schema):void{// this up() migration is auto-generated, please modify it to your needs}publicfunctiondown(Schema$schema):void{// this down() migration is auto-generated, please modify it to your needs}}
$ bin/console doctrine:migrations:migrate 20190529032556
Application Migrations
WARNING! You are about to execute a database migration that could result in schema changes and data loss. Are you sure you wish to continue? (y/n)y # yを入力
Migrating up to 20190529032556 from 20181109101907
++ migrating 20190529032556
-> INSERT INTO dtb_csv (csv_type_id, entity_name, field_name, reference_field_name, disp_name, sort_no, enabled, create_date, update_date, discriminator_type)
SELECT 4, 'Eccube\Entity\OrderItem', 'Gift', 'name', 'ギフト', max(sort_no) + 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'csv' FROM dtb_csv WHERE csv_type_id = 4;
++ migrated (0.04s)------------------------
++ finished in 0.04s
++ 1 migrations executed
++ 1 sql queries
$ bin/console doctrine:migrations:execute 20190529032556 --down
WARNING! You are about to execute a database migration that could result in schema changes and data lost. Are you sure you wish to continue? (y/n)y # yを入力-- reverting 20190529032556
-> DELETE FROM dtb_csv WHERE disp_name ='ギフト';-- reverted (0.04s)
