#!/bin/bashset-e# Remove a potentially pre-existing server.pid for Rails.rm-f /myapp/tmp/pids/server.pid
# Then exec the container's main process (what's set as CMD in the Dockerfile).exec"$@"
docker-compose run web rails new .--force--no-deps--database=mysql
--database=mysqlでDB設定をMySQLにした状態でプロジェクト作成。
docker-compose build
DB接続設定
database.yml
development:<<:*defaultdatabase:myapp_developmenthost:dbusername:rootpassword:password# Warning: The database defined as "test" will be erased and# re-generated from your development database when you run "rake".# Do not set this db to the same as development or production.test:<<:*defaultdatabase:myapp_testhost:dbusername:rootpassword:password
$cfg['Servers'][$i]['auth_type']='config';// Authentication method (config, http or cookie based)?$cfg['Servers'][$i]['user']='root';// MySQL user$cfg['Servers'][$i]['password']='';// MySQL password (only needed$cfg['Servers'][$i]['AllowNoPassword']=true;// パスワード無しを許可
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Query\Expression;
use Illuminate\Support\Facades\Schema;
class CreateChatRoomsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('chat_rooms', function (Blueprint $table) {
$table->id();
$table->text('user_info_json')->default(new Expression('(JSON_ARRAY())'));
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('chat_rooms');
}
}
エラーが出現。
エラーの内容
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(JSON_ARRAY()),
`created_at` timestamp null, `updated_at` timestamp null) defaul' at line 1 (SQL: create table `chat_rooms` (`id` bigint unsigned not null auto_increment primary key, `user_info_json` text not null default (
JSON_ARRAY()), `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(JSON_ARRAY()),
`created_at` timestamp null, `updated_at` timestamp null) defaul' at line 1
Access denied for user 'root'@'localhost' (using password: YES)のエラー
状況
Ruby on Rails 6.0.3.2
EC2へのデプロイ作業中のエラー
MySQLへのログインはできるので正しいパスワードは把握できている。
DBの作成時にエラーが出る
本番環境で以下のコマンドでDB作成を試みる。
rails db:create RAILS_ENV=production
しかし以下のようなエラーが発生。
rails aborted!
Mysql2::Error::ConnectionError: Access denied for user 'root'@'localhost' (using password: YES)
/var/www/<アプリ名>/bin/rails:9:in `<top (required)>'
/var/www/<アプリ名>/bin/spring:15:in `<top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Tasks: TOP => db:create
(See full trace by running task with --trace)
何が問題なのか
MySQLへ接続時のパスワードが間違っている。
Access denied for user 'root'@'localhost' (using password: YES)
