容器添加开启自启

昨天重启完NAS后，明天早上发现NAS又死机了。只能再次强制关机，重启。

启动docker容器之前，我把mysql容器的内存调整了一下，调整成了512M。 而后就喜剧的发现启动不了了。起初发现，启动不了不是我调内存的关系。

查看日志，显示如下:

2020-12-27T02:43:53.375776Z 0 mysqld: [Warning] World-writable config file ‘/etc/mysql/my.cnf’ is ignored.

2020-12-27T02:43:53.375776Z 0 mysqld: Error on realpath() on ‘/var/lib/mysql-files’ (Error 2 – No such file or directory)

2020-12-27T02:43:53.375776Z 0 [ERROR] [MY-010095] [Server] Failed to access directory for –secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files

2020-12-27T02:43:53.376005Z 0 [ERROR] [MY-010119] [Server] Aborting

百度了下，解决办法是从新run一个mysql容器，并且在之前的配置上加上-v /mnt/md0/User/wzp/home/www/mysql-files:/var/lib/mysql-files/。

当初问题来了，之前run mysql容器时，我并没有记录下残缺的run 命令。还好，通过rekcod工具能够查看。更喜的是，这个工具能够通过docker来运行。因为我的NAS的零碎不是发行版的linux，npm，yum好多工具都没法装置。

对于rekcod的应用能够参考linuxea:如何复现查看docker run参数命令

简略来说，用法如下：

1 docker 装置rekcod

$ docker pull nexdrew/rekcod

$ alias rekcod="docker run --rm -v /var/run/docker.sock:/var/run/docker.sock nexdrew/rekcod"

2 应用办法：

[root@TNAS-012664 ~]# rekcod mysql ==>mysql是我的容器名

docker run --name mysql --runtime runc -v /mnt/md0/User/wzp/home/www/mysql/:/var/lib/mysql -p 3306:3306/tcp --net bridge --restart no -h 39964e9e508a --expose 3306/tcp --expose 33060/tcp -e 'MYSQL_ROOT_PASSWORD=123456' -e 'PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' -e 'GOSU_VERSION=1.12' -e 'MYSQL_MAJOR=5.7' -e 'MYSQL_VERSION=5.7.30-1debian10' -d -t -i --entrypoint "docker-entrypoint.sh" mysql 'mysqld'

能够看到我的数据库文件都是放在/mnt/md0/User/wzp/home/www/mysql/目录下，我查看了下该目录文件，数据应该是没有失落的。

于是，我新建了mysql2 容器，命令如下

docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 --name mysql2 -v /mnt/md0/User/wzp/home/www/mysql/:/var/lib/mysql -v /mnt/md0/User/wzp/home/www/mysql-files:/var/lib/mysql-files/ mysql

而后，进入mysql2，发现没法连贯数据库

docker exec -it mysql2 /bin/bash

查看mysql 状态

root@0e83698acbfb:/# mysqld status

mysqld: [Warning] World-writable config file '/etc/mysql/conf.d/docker.cnf' is ignored.

mysqld: [Warning] World-writable config file '/etc/mysql/conf.d/mysql.cnf' is ignored.

2020-12-27T02:39:41.865252Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.

2020-12-27T02:39:41.865455Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20) starting as process 105

2020-12-27T02:39:41.871715Z 0 [ERROR] [MY-010123] [Server] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2020-12-27T02:39:41.872541Z 0 [ERROR] [MY-010119] [Server] Aborting

2020-12-27T02:39:41.872776Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.

root@0e83698acbfb:/# Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!^C

用以下办法以root形式启动mysqld

root@0e83698acbfb:/# mysqld --user=root

mysqld: [Warning] World-writable config file '/etc/mysql/conf.d/docker.cnf' is ignored.

mysqld: [Warning] World-writable config file '/etc/mysql/conf.d/mysql.cnf' is ignored.

2020-12-27T02:40:57.169719Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.

2020-12-27T02:40:57.169896Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20) starting as process 116

2020-12-27T02:40:57.184807Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2020-12-27T02:40:57.241048Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11

2020-12-27T02:40:58.241783Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11

2020-12-27T02:40:59.242983Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11

2020-12-27T02:41:00.244290Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11

2020-12-27T02:41:01.245762Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11

2020-12-27T02:41:02.247539Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11

屏幕始终打印Unable to lock ./ibdata1 error: 11，只能CTRL-C强制中断。百度了下，有两个形式来解决该问题

1 参考mysql之 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11

该文章剖析，导致该error次要是以下两个起因，很惋惜，文章中的办法并不能解决我的问题。

磁盘空间目录有余

ibdata1 文件被其余的过程占用

2 参考mysqld报InnoDB: Unable to lock ./ibdata1 error: 11这篇文章完满解决了我的问题。次要进行了以下操作。

2.1 首先，进入我的mysql数据库所在目录

cd /mnt/md0/User/wzp/home/www/mysql

2.2 而后将ibdata1等文件重命名后，再cp回来。具体为什么要这么做，我也不太明确。

[root@TNAS-012664 www]# cd /mnt/md0/User/wzp/home/www/mysql/

[root@TNAS-012664 mysql]# ls

auto.cnf binlog.index client-key.pem dci '#ib_16384_0.dblwr' ib_logfile0 mautic nianbao performance_schema robot shangbiao undo_001 zeng

baike ca-key.pem company_works dianzicaipiao '#ib_16384_1.dblwr' ib_logfile1 mysql niuwan private_key.pem sara_wiki sjzt_ry6 undo_002

bigdatapaltfrom ca.pem copyrightdata gs_data ib_buffer_pool '#innodb_temp' mysql.ibd pachong public_key.pem server-cert.pem sys wenshu

binlog.000001 client-cert.pem db_huayun hy_dci_admin ibdata1 integrate mysql_upgrade_info pachong2 qianliu_wiki server-key.pem ucenter_huayunyy yuanqixiaoshuo

[root@TNAS-012664 mysql]# mv ibdata1 ibdata1.bak

[root@TNAS-012664 mysql]# mv ib_logfile0 ib_logfile0.bak

[root@TNAS-012664 mysql]# mv ib_logfile1 ib_logfile1.bak

[root@TNAS-012664 mysql]# cp -a ibdata1.bak ibdata1

[root@TNAS-012664 mysql]# cp -a ib_logfile0.bak ib_logfile0

[root@TNAS-012664 mysql]# cp -a ib_logfile1.bak ib_logfile1

2.3 而后我删除之前的mysql2 container，用上面的命令再次run一个mysql2容器，发现就能够连贯mysql数据库了。

[root@TNAS-012664 ~]# docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 --name mysql2 -v /mnt/md0/User/wzp/home/www/mysql/:/var/lib/mysql -v /mnt/md0/User/wzp/home/www/mysql-files:/var/lib/mysql-files/ mysql

1e031247ea46e82f6205db68e7fb1b55389c87e5e2cb13517f9e1ac17d514509

[root@TNAS-012664 ~]# docker exec -it mysql2 /bin/bash

root@1e031247ea46:/# mysql -uroot -p

mysql: [Warning] World-writable config file '/etc/mysql/my.cnf' is ignored.

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 8.0.20 MySQL Community Server - GPL

Copyright (c) 2000, 2020, 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.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

认为mysql容器好了就高枕无忧了？ No，too naive! 还有一个小插曲等着我呢。这边刚把mysql容器解决好，忽然又发现我的wiki容器莫名其妙没了。不过好在，数据库文件在，所有还能复原如初。

1 用以下的命令新建两个wiki

docker run --name sarawiki --link mysql2:mysql -p 8086:80 -d sarawang85/mediawiki:1.0.0

docker run --name qianliuwiki --link mysql2:mysql -p 8083:80 -d sarawang85/mediawiki:1.0.0

2 而后把备份好的LocalSettings.php 文件和Logo图片copy 进容器，搞定。

PS，如果在docker gui界面编辑stop状态的容器，比方设置内存限度，理论是会新建一个同名的容器。因为我发现我这样做了后，拜访我的wiki，又提醒我重新安装。

再次PS，mysql 备份得立刻提上日程。mysql 内存限度不能单单通过容器来限度，my.cnf也得做响应更改。