質問編集履歴
11
test
CHANGED
File without changes
|
test
CHANGED
@@ -181,3 +181,75 @@
|
|
181
181
|
tmpfs 94956 0 94956 0% /run/user/0
|
182
182
|
|
183
183
|
```
|
184
|
+
|
185
|
+
以下、/var/log/messagesの該当箇所です。
|
186
|
+
|
187
|
+
```
|
188
|
+
|
189
|
+
Jan 14 17:43:16 centos-rpi3 systemd: Starting MariaDB database server...
|
190
|
+
|
191
|
+
Jan 14 17:43:16 centos-rpi3 mariadb-prepare-db-dir: Initializing MariaDB database
|
192
|
+
|
193
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: 180114 17:43:17 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDB) starting as process 9775 ...
|
194
|
+
|
195
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: #007/usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
|
196
|
+
|
197
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: 180114 17:43:17 [ERROR] Aborting
|
198
|
+
|
199
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: 180114 17:43:17 [Note] /usr/libexec/mysqld: Shutdown complete
|
200
|
+
|
201
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: Installation of system tables failed! Examine the logs in
|
202
|
+
|
203
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: /var/lib/mysql for more information.
|
204
|
+
|
205
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: The problem could be conflicting information in an external
|
206
|
+
|
207
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: my.cnf files. You can ignore these by doing:
|
208
|
+
|
209
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf
|
210
|
+
|
211
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: You can also try to start the mysqld daemon with:
|
212
|
+
|
213
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: shell> /usr/libexec/mysqld --skip-grant --general-log &
|
214
|
+
|
215
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: and use the command line tool /usr/bin/mysql
|
216
|
+
|
217
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: to connect to the mysql database and look at the grant tables:
|
218
|
+
|
219
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: shell> /usr/bin/mysql -u root mysql
|
220
|
+
|
221
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: mysql> show tables;
|
222
|
+
|
223
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: Try 'mysqld --help' if you have problems with paths. Using
|
224
|
+
|
225
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: --general-log gives you a log in /var/lib/mysql that may be helpful.
|
226
|
+
|
227
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: The latest information about mysql_install_db is available at
|
228
|
+
|
229
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
|
230
|
+
|
231
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: MariaDB is hosted on launchpad; You can find the latest source and
|
232
|
+
|
233
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: email lists at http://launchpad.net/maria
|
234
|
+
|
235
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: Please check all of the above before submitting a bug report
|
236
|
+
|
237
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: at http://mariadb.org/jira
|
238
|
+
|
239
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: Initialization of MariaDB database failed.
|
240
|
+
|
241
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: Perhaps @sysconfdir@/my.cnf is misconfigured or there is some problem with permissions of /var/lib/mysql.
|
242
|
+
|
243
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: Initialization of MariaDB database was not finished successfully.
|
244
|
+
|
245
|
+
Jan 14 17:43:17 centos-rpi3 mariadb-prepare-db-dir: Files created so far will be removed.
|
246
|
+
|
247
|
+
Jan 14 17:43:17 centos-rpi3 systemd: mariadb.service: control process exited, code=exited status=1
|
248
|
+
|
249
|
+
Jan 14 17:43:17 centos-rpi3 systemd: Failed to start MariaDB database server.
|
250
|
+
|
251
|
+
Jan 14 17:43:17 centos-rpi3 systemd: Unit mariadb.service entered failed state.
|
252
|
+
|
253
|
+
Jan 14 17:43:17 centos-rpi3 systemd: mariadb.service failed.
|
254
|
+
|
255
|
+
```
|
10
test
CHANGED
File without changes
|
test
CHANGED
@@ -157,3 +157,27 @@
|
|
157
157
|
[root@centos-rpi3 ~]#
|
158
158
|
|
159
159
|
```
|
160
|
+
|
161
|
+
dfコマンドを実行するとこうなりました。
|
162
|
+
|
163
|
+
```
|
164
|
+
|
165
|
+
[root@centos-rpi3 ~]# df
|
166
|
+
|
167
|
+
ファイルシス 1K-ブロック 使用 使用可 使用% マウント位置
|
168
|
+
|
169
|
+
/dev/root 29723628 1191688 27284044 5% /
|
170
|
+
|
171
|
+
devtmpfs 470168 0 470168 0% /dev
|
172
|
+
|
173
|
+
tmpfs 474776 0 474776 0% /dev/shm
|
174
|
+
|
175
|
+
tmpfs 474776 12180 462596 3% /run
|
176
|
+
|
177
|
+
tmpfs 474776 0 474776 0% /sys/fs/cgroup
|
178
|
+
|
179
|
+
/dev/mmcblk0p1 511720 50672 461048 10% /boot
|
180
|
+
|
181
|
+
tmpfs 94956 0 94956 0% /run/user/0
|
182
|
+
|
183
|
+
```
|
9
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
8
test
CHANGED
File without changes
|
test
CHANGED
@@ -94,64 +94,66 @@
|
|
94
94
|
|
95
95
|
```
|
96
96
|
|
97
|
-
|
97
|
+
Last login: Sun Jan 14 09:20:32 2018 from 192.168.0.161
|
98
98
|
|
99
|
-
|
99
|
+
[root@centos-rpi3 ~]# journalctl -u mariadb.service --no-pager
|
100
100
|
|
101
|
-
1
|
101
|
+
-- Logs begin at 木 1970-01-01 09:00:03 JST, end at 日 2018-01-14 10:21:46 JST. --
|
102
102
|
|
103
|
-
1月 01 09:00:1
|
103
|
+
1月 01 09:00:17 centos-rpi3 systemd[1]: Starting MariaDB database server...
|
104
104
|
|
105
|
-
1月 01 09:00:1
|
105
|
+
1月 01 09:00:17 centos-rpi3 mariadb-prepare-db-dir[414]: Initializing MariaDB database
|
106
106
|
|
107
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [
|
107
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDB) starting as process 582 ...
|
108
108
|
|
109
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
109
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: [146B blob data]
|
110
110
|
|
111
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
111
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [ERROR] Aborting
|
112
112
|
|
113
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: /
|
113
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [Note] /usr/libexec/mysqld: Shutdown complete
|
114
114
|
|
115
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
115
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Installation of system tables failed! Examine the logs in
|
116
116
|
|
117
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: my
|
117
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: /var/lib/mysql for more information.
|
118
118
|
|
119
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
119
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: The problem could be conflicting information in an external
|
120
120
|
|
121
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: You can
|
121
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: my.cnf files. You can ignore these by doing:
|
122
122
|
|
123
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/
|
123
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf
|
124
124
|
|
125
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: an
|
125
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: You can also try to start the mysqld daemon with:
|
126
126
|
|
127
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
127
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/libexec/mysqld --skip-grant --general-log &
|
128
128
|
|
129
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell
|
129
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: and use the command line tool /usr/bin/mysql
|
130
130
|
|
131
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: mysql
|
131
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: to connect to the mysql database and look at the grant tables:
|
132
132
|
|
133
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
133
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/bin/mysql -u root mysql
|
134
134
|
|
135
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
135
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: mysql> show tables;
|
136
136
|
|
137
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: The
|
137
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Try 'mysqld --help' if you have problems with paths. Using
|
138
138
|
|
139
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
139
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: --general-log gives you a log in /var/lib/mysql that may be helpful.
|
140
140
|
|
141
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
141
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: The latest information about mysql_install_db is available at
|
142
142
|
|
143
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
143
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
|
144
144
|
|
145
|
-
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]:
|
145
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: MariaDB is hosted on launchpad; You can find the latest source and
|
146
146
|
|
147
|
-
1月 01 09:00:19 centos-rpi3
|
147
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: email lists at http://launchpad.net/maria
|
148
148
|
|
149
|
-
1月 01 09:00:19 centos-rpi3
|
149
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Please check all of the above before submitting a bug report
|
150
150
|
|
151
|
-
1月 01 09:00:19 centos-rpi3 systemd[1]:
|
151
|
+
1月 01 09:00:19 centos-rpi3 systemd[1]: mariadb.service: control process exited, code=exited status=1
|
152
152
|
|
153
|
-
1月 01 09:00:19 centos-rpi3 systemd[1]:
|
153
|
+
1月 01 09:00:19 centos-rpi3 systemd[1]: Failed to start MariaDB database server.
|
154
154
|
|
155
|
+
1月 01 09:00:19 centos-rpi3 systemd[1]: Unit mariadb.service entered failed state. 1月 01 09:00:19 centos-rpi3 systemd[1]: mariadb.service failed.
|
156
|
+
|
155
|
-
~
|
157
|
+
[root@centos-rpi3 ~]#
|
156
158
|
|
157
159
|
```
|
7
test
CHANGED
File without changes
|
test
CHANGED
@@ -88,7 +88,7 @@
|
|
88
88
|
|
89
89
|
```
|
90
90
|
|
91
|
-
|
91
|
+
journalctl -u mariadb.serviceを実行すると以下のようになりました。
|
92
92
|
|
93
93
|
|
94
94
|
|
6
test
CHANGED
File without changes
|
test
CHANGED
@@ -96,9 +96,61 @@
|
|
96
96
|
|
97
97
|
-- Logs begin at 木 1970-01-01 09:00:03 JST, end at 日 2018-01-14 09:10:55 JST. --
|
98
98
|
|
99
|
-
|
99
|
+
1月 01 09:00:17 centos-rpi3 systemd[1]: Starting MariaDB database server...
|
100
100
|
|
101
|
-
|
101
|
+
1月 01 09:00:17 centos-rpi3 mariadb-prepare-db-dir[414]: Initializing MariaDB data
|
102
|
+
|
103
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [Note] /u
|
104
|
+
|
105
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: [146B blob data]
|
106
|
+
|
107
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [ERROR] A
|
108
|
+
|
109
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [Note] /u
|
110
|
+
|
111
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Installation of system ta
|
112
|
+
|
113
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: /var/lib/mysql for more i
|
114
|
+
|
115
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: The problem could be conf
|
116
|
+
|
117
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: my.cnf files. You can ign
|
118
|
+
|
119
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/bin/scripts/m
|
120
|
+
|
121
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: You can also try to start
|
122
|
+
|
123
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/libexec/mysql
|
124
|
+
|
125
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: and use the command line
|
126
|
+
|
127
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: to connect to the mysql d
|
128
|
+
|
129
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/bin/mysql -u
|
130
|
+
|
131
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: mysql> show tables;
|
132
|
+
|
133
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Try 'mysqld --help' if yo
|
134
|
+
|
135
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: --general-log gives you a
|
136
|
+
|
137
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: The latest information ab
|
138
|
+
|
139
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: https://mariadb.com/kb/en
|
140
|
+
|
141
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: MariaDB is hosted on laun
|
142
|
+
|
143
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: email lists at http://lau
|
144
|
+
|
145
|
+
1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Please check all of the a
|
146
|
+
|
147
|
+
1月 01 09:00:19 centos-rpi3 systemd[1]: mariadb.service: control process exited, c
|
148
|
+
|
149
|
+
1月 01 09:00:19 centos-rpi3 systemd[1]: Failed to start MariaDB database server.
|
150
|
+
|
151
|
+
1月 01 09:00:19 centos-rpi3 systemd[1]: Unit mariadb.service entered failed state.
|
152
|
+
|
153
|
+
1月 01 09:00:19 centos-rpi3 systemd[1]: mariadb.service failed.
|
102
154
|
|
103
155
|
~
|
104
156
|
|
5
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
4
test
CHANGED
File without changes
|
test
CHANGED
@@ -87,3 +87,19 @@
|
|
87
87
|
1月 13 17:34:13 centos-rpi3 systemd[1]: mariadb.service failed.
|
88
88
|
|
89
89
|
```
|
90
|
+
|
91
|
+
|
92
|
+
|
93
|
+
|
94
|
+
|
95
|
+
```
|
96
|
+
|
97
|
+
-- Logs begin at 木 1970-01-01 09:00:03 JST, end at 日 2018-01-14 09:10:55 JST. --
|
98
|
+
|
99
|
+
1月 01 09:00:17 centos-rpi3 systemd[1]: Starting MariaDB database server...
|
100
|
+
|
101
|
+
1月 01 09:00:17 centos-rpi3 mariadb-prepare-db-dir[414]: Initializing MariaDB data 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [Note] /u 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: [146B blob data] 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [ERROR] A 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: 700101 9:00:19 [Note] /u 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Installation of system ta 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: /var/lib/mysql for more i 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: The problem could be conf 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: my.cnf files. You can ign 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/bin/scripts/m 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: You can also try to start 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/libexec/mysql 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: and use the command line 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: to connect to the mysql d 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: shell> /usr/bin/mysql -u 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: mysql> show tables; 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Try 'mysqld --help' if yo 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: --general-log gives you a 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: The latest information ab 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: https://mariadb.com/kb/en 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: MariaDB is hosted on laun 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: email lists at http://lau 1月 01 09:00:19 centos-rpi3 mariadb-prepare-db-dir[414]: Please check all of the a 1月 01 09:00:19 centos-rpi3 systemd[1]: mariadb.service: control process exited, c 1月 01 09:00:19 centos-rpi3 systemd[1]: Failed to start MariaDB database server. 1月 01 09:00:19 centos-rpi3 systemd[1]: Unit mariadb.service entered failed state. 1月 01 09:00:19 centos-rpi3 systemd[1]: mariadb.service failed.
|
102
|
+
|
103
|
+
~
|
104
|
+
|
105
|
+
```
|
3
test
CHANGED
File without changes
|
test
CHANGED
@@ -54,7 +54,7 @@
|
|
54
54
|
|
55
55
|
systemctl status mariadb.serviceを実行すると以下のようになりました.
|
56
56
|
|
57
|
-
|
57
|
+
```
|
58
58
|
|
59
59
|
● mariadb.service - MariaDB database server
|
60
60
|
|
@@ -85,3 +85,5 @@
|
|
85
85
|
1月 13 17:34:13 centos-rpi3 systemd[1]: Unit mariadb.service entered failed state.
|
86
86
|
|
87
87
|
1月 13 17:34:13 centos-rpi3 systemd[1]: mariadb.service failed.
|
88
|
+
|
89
|
+
```
|
2
いくつか隠れているようでしたので修正致しました.
test
CHANGED
File without changes
|
test
CHANGED
@@ -60,7 +60,7 @@
|
|
60
60
|
|
61
61
|
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
|
62
62
|
|
63
|
-
Active: failed (Result: exit-code) since 土 2018-01-13 17:34:13 JST;
|
63
|
+
Active: failed (Result: exit-code) since 土 2018-01-13 17:34:13 JST; 3min 22s ago
|
64
64
|
|
65
65
|
Process: 780 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=1/FAILURE)
|
66
66
|
|
@@ -68,15 +68,15 @@
|
|
68
68
|
|
69
69
|
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: /var/lib/mysql for more information.
|
70
70
|
|
71
|
-
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: The problem could be conflicting information in
|
71
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: The problem could be conflicting information in an external
|
72
72
|
|
73
73
|
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: my.cnf files. You can ignore these by doing:
|
74
74
|
|
75
|
-
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: shell> /usr/bin/scripts/mysql_install_db --defa..
|
75
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf
|
76
76
|
|
77
77
|
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: You can also try to start the mysqld daemon with:
|
78
78
|
|
79
|
-
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: shell> /usr/libexec/mysqld --skip-grant --gener
|
79
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: shell> /usr/libexec/mysqld --skip-grant --general-log &
|
80
80
|
|
81
81
|
1月 13 17:34:13 centos-rpi3 systemd[1]: mariadb.service: control process exited, code=exited status=1
|
82
82
|
|
@@ -85,5 +85,3 @@
|
|
85
85
|
1月 13 17:34:13 centos-rpi3 systemd[1]: Unit mariadb.service entered failed state.
|
86
86
|
|
87
87
|
1月 13 17:34:13 centos-rpi3 systemd[1]: mariadb.service failed.
|
88
|
-
|
89
|
-
Hint: Some lines were ellipsized, use -l to show in full.
|
1
systemctl status mariadb.serviceの実行結果を追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -49,3 +49,41 @@
|
|
49
49
|
###補足
|
50
50
|
|
51
51
|
LAN内のMacより,rootユーザーにSSHでログインしています.
|
52
|
+
|
53
|
+
|
54
|
+
|
55
|
+
systemctl status mariadb.serviceを実行すると以下のようになりました.
|
56
|
+
|
57
|
+
|
58
|
+
|
59
|
+
● mariadb.service - MariaDB database server
|
60
|
+
|
61
|
+
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
|
62
|
+
|
63
|
+
Active: failed (Result: exit-code) since 土 2018-01-13 17:34:13 JST; 59s ago
|
64
|
+
|
65
|
+
Process: 780 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=1/FAILURE)
|
66
|
+
|
67
|
+
|
68
|
+
|
69
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: /var/lib/mysql for more information.
|
70
|
+
|
71
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: The problem could be conflicting information in...nal
|
72
|
+
|
73
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: my.cnf files. You can ignore these by doing:
|
74
|
+
|
75
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: shell> /usr/bin/scripts/mysql_install_db --defa...cnf
|
76
|
+
|
77
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: You can also try to start the mysqld daemon with:
|
78
|
+
|
79
|
+
1月 13 17:34:13 centos-rpi3 mariadb-prepare-db-dir[780]: shell> /usr/libexec/mysqld --skip-grant --gener...g &
|
80
|
+
|
81
|
+
1月 13 17:34:13 centos-rpi3 systemd[1]: mariadb.service: control process exited, code=exited status=1
|
82
|
+
|
83
|
+
1月 13 17:34:13 centos-rpi3 systemd[1]: Failed to start MariaDB database server.
|
84
|
+
|
85
|
+
1月 13 17:34:13 centos-rpi3 systemd[1]: Unit mariadb.service entered failed state.
|
86
|
+
|
87
|
+
1月 13 17:34:13 centos-rpi3 systemd[1]: mariadb.service failed.
|
88
|
+
|
89
|
+
Hint: Some lines were ellipsized, use -l to show in full.
|