Skip to content

Instantly share code, notes, and snippets.

View koheyamada's full-sized avatar

Kohei Yamada koheyamada

1 follower · 2 following
View GitHub Profile
@koheyamada
koheyamada / MySQLログイン
Last active September 27, 2017 04:09
Amazon RDS for MySQL で OLD_PASSWORD を設定する。 ref: http://qiita.com/kooohei/items/1012e776899faa798062
$ mysql -hrdstest.cemnknnpakxg.ap-northeast-1.rds.amazonaws.com -umysql -phogehoge
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1599
Server version: 5.6.35-log MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
@koheyamada
koheyamada / file0.txt
Last active May 1, 2018 01:54
Amazon Linux にアタッチされている EBS rootボリュームサイズをオンラインで拡張する。 ref: https://qiita.com/kooohei/items/f5ff696f57e10683806f
$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
xvda 202:0 0 20G 0 disk
└─xvda1 202:1 0 20G 0 part /
@koheyamada
koheyamada / apache再起動
Last active August 22, 2017 05:25
Redmineにプラグインを追加する。 ref: http://qiita.com/kooohei/items/3c86554af93d12ad9322
$ sudo service httpd restart
@koheyamada
koheyamada / エラー
Created August 3, 2017 06:41
Error 'Table 'mysql.rds_heartbeat2' doesn't exist' on query. Default database: 'mysql'. Query: 'INSERT INTO mysql.rds_heartbeat2(id, value) values (1,1493274809584) ON DUPLICATE KEY UPDATE value = 1493274809584' ref: http://qiita.com/kooohei/items/34beab9db6951938d6fd
Error 'Table 'mysql.rds_heartbeat2' doesn't exist' on query. Default database: 'mysql'. Query: 'INSERT INTO mysql.rds_heartbeat2(id, value) values (1,1493274809584) ON DUPLICATE KEY UPDATE value = 1493274809584'
@koheyamada
koheyamada / apache停止
Created July 13, 2017 05:24
Route53 でDNSフェイルオーバーを設定する。 ref: http://qiita.com/kooohei/items/c24dd3bab57552127886
$ sudo service httpd stop
Stopping httpd: [ OK ]
@koheyamada
koheyamada / log
Last active July 5, 2017 14:36
Could not open output pipe '/dev/xconsole' [try http://www.rsyslog.com/e/2039 ] ref: http://qiita.com/kooohei/items/fc92d338c45be87aeff8
Jun 10 13:02:34 hogehoge kernel: imklog 5.8.10, log source = /proc/kmsg started.
Jun 10 13:02:34 hogehoge rsyslogd: [origin software="rsyslogd" swVersion="5.8.10" x-pid="8842" x-info="http://www.rsyslog.com"] start
Jun 10 13:02:34 hogehoge rsyslogd-2039: Could not open output pipe '/dev/xconsole' [try http://www.rsyslog.com/e/2039 ]
@koheyamada
koheyamada / file0.txt
Last active June 27, 2017 13:48
mysqldump: Got errno 28 on write ref: http://qiita.com/kooohei/items/47224dfca9531149f029
$ df -h
Filesystem サイズ 使用 残り 使用% マウント位置
/dev/mapper/mysqlvg-sysmte
30G 30G 0 100% /
@koheyamada
koheyamada / エラー
Last active June 19, 2017 09:29
[Thread-3] FATAL stacktrace_log - Cannot load JDBC driver class 'com.mysql.jdbc.Driver' org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' ref: http://qiita.com/kooohei/items/6119150e6d44030f2fe4
[Thread-3] FATAL stacktrace_log - Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
@koheyamada
koheyamada / チェック
Last active May 17, 2017 13:42
AIDEの戻り値について。 ref: http://qiita.com/kooohei/items/f1f4288b23cd89bece19
$ sudo aide --check
AIDE found differences between database and filesystem!!
Start timestamp: 2017-05-09 12:37:04
Summary:
Total number of files: 60777
Added files: 0
Removed files: 0
Changed files: 2
@koheyamada
koheyamada / インストール
Last active May 8, 2017 06:54
AIDEを使ってファイルの改竄検知を行う。 ref: http://qiita.com/kooohei/items/bcf34fd82c2f98b0b559
$ sudo yum install aide