質問編集履歴
6
参考サイトを追記しました
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -132,4 +132,6 @@
|
|
|
132
132
|
|
|
133
133
|
[client]
|
|
134
134
|
default-character-set = utf8mb4
|
|
135
|
-
```
|
|
135
|
+
```
|
|
136
|
+
|
|
137
|
+
[※参考サイト](https://mgng.mugbum.info/1393)
|
5
debug.logとmy.cnfの追記をしました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -86,4 +86,50 @@
|
|
|
86
86
|
[Sun Oct 28 03:11:02.094465 2018] [core:notice] [pid 11679] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
|
|
87
87
|
[Sun Oct 28 18:17:00.142714 2018] [cgi:error] [pid 14709] [client 50.232.243.66:62110] AH02811: script not found or unable to stat: /var/www/cgi-bin/getinfo
|
|
88
88
|
pdo_mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
|
|
89
|
+
```
|
|
90
|
+
10/30追記
|
|
91
|
+
wp-content/debug.logの内容
|
|
92
|
+
```
|
|
93
|
+
[29-Oct-2018 16:42:02 UTC] PHP Warning: mysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1531
|
|
94
|
+
[29-Oct-2018 16:42:02 UTC] PHP Warning: mysqli_real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1531
|
|
95
|
+
[29-Oct-2018 16:42:02 UTC] PHP Warning: mysql_connect(): Server sent charset (255) unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1562
|
|
96
|
+
[29-Oct-2018 16:42:02 UTC] PHP Warning: mysql_connect(): Server sent charset unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1562
|
|
97
|
+
```
|
|
98
|
+
|
|
99
|
+
my.cnfの内容
|
|
100
|
+
```
|
|
101
|
+
[mysqld]
|
|
102
|
+
#
|
|
103
|
+
# Remove leading # and set to the amount of RAM for the most important data
|
|
104
|
+
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
|
|
105
|
+
# innodb_buffer_pool_size = 128M
|
|
106
|
+
#
|
|
107
|
+
# Remove the leading "# " to disable binary logging
|
|
108
|
+
# Binary logging captures changes between backups and is enabled by
|
|
109
|
+
# default. It's default setting is log_bin=binlog
|
|
110
|
+
# disable_log_bin
|
|
111
|
+
#
|
|
112
|
+
# Remove leading # to set options mainly useful for reporting servers.
|
|
113
|
+
# The server defaults are faster for transactions and fast SELECTs.
|
|
114
|
+
# Adjust sizes as needed, experiment to find the optimal values.
|
|
115
|
+
# join_buffer_size = 128M
|
|
116
|
+
# sort_buffer_size = 2M
|
|
117
|
+
# read_rnd_buffer_size = 2M
|
|
118
|
+
#
|
|
119
|
+
# Remove leading # to revert to previous value for default_authentication_plugin,
|
|
120
|
+
# this will increase compatibility with older clients. For background, see:
|
|
121
|
+
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
|
|
122
|
+
# default-authentication-plugin=mysql_native_password
|
|
123
|
+
|
|
124
|
+
datadir=/var/lib/mysql
|
|
125
|
+
socket=/var/lib/mysql/mysql.sock
|
|
126
|
+
|
|
127
|
+
log-error=/var/log/mysqld.log
|
|
128
|
+
pid-file=/var/run/mysqld/mysqld.pid
|
|
129
|
+
|
|
130
|
+
collation-server = utf8mb4_general_ci
|
|
131
|
+
character-set-server = utf8mb4
|
|
132
|
+
|
|
133
|
+
[client]
|
|
134
|
+
default-character-set = utf8mb4
|
|
89
135
|
```
|
4
PHPのバージョンを修正しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
OS: Amazon Linux 2 AMI (HVM)
|
|
29
29
|
Apache:2.4.34
|
|
30
30
|
MySQL: 8.0.12
|
|
31
|
-
PHP:
|
|
31
|
+
PHP: 5.4.16 (Zend Engine v2.4.0)
|
|
32
32
|
|
|
33
33
|
不足情報等あればすぐに追記いたします。
|
|
34
34
|
何卒どうかよろしくお願い致します。
|
3
記載誤りの修正（DBサーバーのプライベートアドレス）
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -14,6 +14,9 @@
|
|
|
14
14
|
### 試したこと
|
|
15
15
|
|
|
16
16
|
初期設定画面（setup-config.php）での「データベース名」、「ユーザー名」、「パスワード」、「ホスト名」に間違いはありません。「ホスト名」にはDBサーバーのプライベートIPアドレス「10.0.2.0」を割り当てています。因みにwp-config.phpファイルはまだ生成されていないようでした。
|
|
17
|
+
|
|
18
|
+
※追記：DBサーバーのプライベートアドレス「10.0.2.10」でした。。大変失礼致しました。。。
|
|
19
|
+
|
|
17
20
|
Webサーバーにssh接続して「mysql -h (ホスト名) -u (ユーザー名) -p (パスワード)」とすると問題なく接続ができます。
|
|
18
21
|
MySQLの権限設定の問題かと思い、データベース接続後にテーブル作成や削除等の操作をしてみましたが問題なく実行できました。
|
|
19
22
|
|
2
ログに出てくる情報を追記しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -31,11 +31,56 @@
|
|
|
31
31
|
何卒どうかよろしくお願い致します。
|
|
32
32
|
|
|
33
33
|
10/29追記
|
|
34
|
-
|
|
34
|
+
php -iで出てくる情報
|
|
35
35
|
```
|
|
36
|
+
/etc/php.d/mysqlnd.ini,
|
|
37
|
+
/etc/php.d/mysqlnd_mysql.ini,
|
|
38
|
+
/etc/php.d/mysqlnd_mysqli.ini,
|
|
39
|
+
/etc/php.d/pdo_mysqlnd.ini,
|
|
40
|
+
PHP Warning: Unknown: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in Unknown on line 0
|
|
41
|
+
mysql
|
|
42
|
+
Client API version => mysqlnd 5.0.10 - 20111026 - $Id: ●●●● $
|
|
43
|
+
mysql.allow_local_infile => On => On
|
|
44
|
+
mysql.allow_persistent => On => On
|
|
45
|
+
mysql.connect_timeout => 60 => 60
|
|
46
|
+
mysql.default_host => no value => no value
|
|
47
|
+
mysql.default_password => no value => no value
|
|
48
|
+
mysql.default_port => no value => no value
|
|
49
|
+
mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
|
|
50
|
+
mysql.default_user => no value => no value
|
|
51
|
+
mysql.max_links => Unlimited => Unlimited
|
|
52
|
+
mysql.max_persistent => Unlimited => Unlimited
|
|
53
|
+
mysql.trace_mode => Off => Off
|
|
54
|
+
mysqli
|
|
55
|
+
Client API library version => mysqlnd 5.0.10 - 20111026 - $Id: ●●●● $
|
|
56
|
+
mysqli.allow_local_infile => On => On
|
|
57
|
+
mysqli.allow_persistent => On => On
|
|
58
|
+
mysqli.default_host => no value => no value
|
|
59
|
+
mysqli.default_port => 3306 => 3306
|
|
60
|
+
mysqli.default_pw => no value => no value
|
|
61
|
+
mysqli.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
|
|
62
|
+
mysqli.default_user => no value => no value
|
|
63
|
+
mysqli.max_links => Unlimited => Unlimited
|
|
64
|
+
mysqli.max_persistent => Unlimited => Unlimited
|
|
65
|
+
mysqli.reconnect => Off => Off
|
|
66
|
+
mysqlnd
|
|
67
|
+
mysqlnd => enabled
|
|
68
|
+
Version => mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
|
|
69
|
+
Loaded plugins => mysqlnd,example,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password
|
|
70
|
+
API Extensions => mysql,mysqli,pdo_mysql
|
|
71
|
+
mysqlnd statistics =>
|
|
72
|
+
PDO drivers => mysql, sqlite
|
|
73
|
+
pdo_mysql
|
|
74
|
+
Client API version => mysqlnd 5.0.10 - 20111026 - $Id: ●●●● $
|
|
75
|
+
```
|
|
76
|
+
|
|
77
|
+
/var/log/httpd/error_logの内容
|
|
78
|
+
```
|
|
36
79
|
[Sun Oct 28 03:11:02.081931 2018] [lbmethod_heartbeat:notice] [pid 11679] AH02282: No slotmem from mod_heartmonitor
|
|
37
80
|
[Sun Oct 28 03:11:02.082011 2018] [http2:warn] [pid 11679] AH10034: The mpm module (prefork.c) is not supported by mod_http2. The mpm determines how things are processed in your server. HTTP/2 has more demands in this regard and the currently selected mpm will just not do. This is an advisory warning. Your server will continue to work, but the HTTP/2 protocol will be inactive.
|
|
38
81
|
[Sun Oct 28 03:11:02.082017 2018] [http2:warn] [pid 11679] AH02951: mod_ssl does not seem to be enabled
|
|
39
82
|
[Sun Oct 28 03:11:02.094453 2018] [mpm_prefork:notice] [pid 11679] AH00163: Apache/2.4.34 () PHP/5.4.16 configured -- resuming normal operations
|
|
40
83
|
[Sun Oct 28 03:11:02.094465 2018] [core:notice] [pid 11679] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
|
|
84
|
+
[Sun Oct 28 18:17:00.142714 2018] [cgi:error] [pid 14709] [client 50.232.243.66:62110] AH02811: script not found or unable to stat: /var/www/cgi-bin/getinfo
|
|
85
|
+
pdo_mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
|
|
41
86
|
```
|
1
httpd/error_logの内容を追記しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -28,4 +28,14 @@
|
|
|
28
28
|
PHP: 2.4.0
|
|
29
29
|
|
|
30
30
|
不足情報等あればすぐに追記いたします。
|
|
31
|
-
何卒どうかよろしくお願い致します。
|
|
31
|
+
何卒どうかよろしくお願い致します。
|
|
32
|
+
|
|
33
|
+
10/29追記
|
|
34
|
+
httpd/error_logにはこのようなログが残ってました。
|
|
35
|
+
```
|
|
36
|
+
[Sun Oct 28 03:11:02.081931 2018] [lbmethod_heartbeat:notice] [pid 11679] AH02282: No slotmem from mod_heartmonitor
|
|
37
|
+
[Sun Oct 28 03:11:02.082011 2018] [http2:warn] [pid 11679] AH10034: The mpm module (prefork.c) is not supported by mod_http2. The mpm determines how things are processed in your server. HTTP/2 has more demands in this regard and the currently selected mpm will just not do. This is an advisory warning. Your server will continue to work, but the HTTP/2 protocol will be inactive.
|
|
38
|
+
[Sun Oct 28 03:11:02.082017 2018] [http2:warn] [pid 11679] AH02951: mod_ssl does not seem to be enabled
|
|
39
|
+
[Sun Oct 28 03:11:02.094453 2018] [mpm_prefork:notice] [pid 11679] AH00163: Apache/2.4.34 () PHP/5.4.16 configured -- resuming normal operations
|
|
40
|
+
[Sun Oct 28 03:11:02.094465 2018] [core:notice] [pid 11679] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
|
|
41
|
+
```
|