ASのおもちゃ箱開発ブログ

5.7が入っていた環境に8.0をインストールした場合に発生するらしい

2019-09-15T08:27:16.967577Z 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.17) starting as process 33650

2019-09-15T08:27:16.973105Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive

2019-09-15T08:27:17.111260Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.10. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html

2019-09-15T08:27:16.984522Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.

一旦、すべて削除する。
必要ならバックアップを取ること。

$ brew uninstall mysql

brew uninstall mysql　では削除できないファイル群を削除します。
$ sudo rm -rf /usr/local/Cellar/mysql*
$ sudo rm -rf /usr/local/bin/mysql*
$ sudo rm -rf /usr/local/var/mysql*
$ sudo rm -rf /usr/local/etc/my.cnf
$ sudo rm -rf /usr/local/share/mysql*
$ sudo rm -rf /usr/local/opt/mysql
$ sudo rm -rf /usr/local/mysql
$ sudo rm -rf /Library/StartupItems/MYSQL
$ sudo rm -rf /Library/PreferencePanes/MySQL.prefPane
$ sudo rm -rf /Library/Receipts/mysql-.pkg
$ sudo rm -rf /usr/local/Library/LinkedKegs/mysql 

必要なバージョンをインストールし直す。
$ brew install mysql@5.7

パスを通す
$ echo ‘export PATH=”/usr/local/opt/mysql@5.7/bin:$PATH”‘ >> ~/.bash_profile
$ source ~/.bash_profile
$ mysql.server start

サボって、EC2のサーバーにいちいちファイルをアップロード動かしてましたが、エラーが解決できず面倒になってきたので、ローカルで動かすことにする。
でも、さぼって、vagrant は使わずに、直にnginxを動かす。

$ brew install nginx
$ mkdir -p ~/Library/LaunchAgents
$ cp /usr/local/opt/php@7.2/homebrew.mxcl.php@7.2.plist ~/Library/LaunchAgents/
$ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.php@7.2.plist

$ sudo vi /usr/local/etc/nginx/nginx.conf

        listen       8080;
        server_name  localhost;

        location / {
            #root   html;
            root   ドキュメントルート;
            index  index.php index.html index.htm;
        }
        location ~ \.php$ {
            root ドキュメントルート;
            fastcgi_pass   127.0.0.1:9000;
            fastcgi_index  index.php;
            fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
            include        fastcgi_params;
        }

$ sudo nginx -s reload

nginx.confのlistenとserver_nameの通りにブラウザで開く。

http://localhost:8080/index.php

なぜか、index.php付けないと動かず

mysqlもインストールします。
$ brew install mysql
$ brew services start mysql

ec2上で、laravelプロジェクト作ろうとしたら、メモリエラー？

$ sudo composer create-project –prefer-dist laravel/laravel sitename 5.8
Installing laravel/laravel (v5.8.0)

• Installing laravel/laravel (v5.8.0): Loading from cache
  Created project in companylist

@php -r “file_exists(‘.env’) || copy(‘.env.example’, ‘.env’);”
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 80 installs, 0 updates, 0 removals

• Installing symfony/polyfill-ctype (v1.12.0): Downloading (100%)
  The following exception is caused by a lack of memory or swap, or not having swap configured
  Check https://getcomposer.org/doc/articles/troubleshooting.md#proc-open-fork-failed-errors for details

PHP Warning: proc_open(): fork failed – Cannot allocate memory in phar:///usr/bin/composer/vendor/symfony/console/Application.php on line 952

Warning: proc_open(): fork failed – Cannot allocate memory in phar:///usr/bin/composer/vendor/symfony/console/Application.php on line 952

[ErrorException]
proc_open(): fork failed – Cannot allocate memory

create-project [-s|–stability STABILITY] [–prefer-source] [–prefer-dist] [–repository REPOSITORY] [–repository-url REPOSITORY-URL] [–dev] [–no-dev] [–no-custom-installers] [–no-scripts] [–no-progress] [–no-secure-http] [–keep-vcs] [–remove-vcs] [–no-install] [–ignore-platform-reqs] [–] [] [] []

swapがない？

$free -m

              total        used        free      shared  buff/cache   available

Mem:            983         272         624           0          86         588

Swap:             0           0           0

$ sudo /bin/dd if=/dev/zero of=/var/swap.1 bs=1M count=1024
$ sudo /sbin/mkswap /var/swap.1
$ sudo /sbin/swapon /var/swap.1