Typora 实现自动上传图片

• 阿里云accessKey和token设置

• 拷贝生成好的AccessKey ID, AccessKey Secret , 用于下面的配置

下载PicGo https://molunerfinn.com/PicGo/

https://github.com/Molunerfinn/PicGo/releases/download/v2.3.0/PicGo-Setup-2.3.0-x64.exe

• 安装后配置阿里云oss

• 勾选时间戳重命名, 把其余用不到的图床给移除勾选

• 修改Typora设置

• 测试图片上传

• 文件名优化办法 在插件设置里面搜索 super-prefix 并安装配置

需要关闭PicGo里面的时间戳重命名功能才能正常使用

• sql语句

SELECT * FROM (
SELECT 日期, 人数, (@csum := @csum + 人数) AS 累计人数
FROM (
SELECT DATE_FORMAT(complete_at,'%Y-%m-%d') AS '日期',COUNT(1) AS '人数' FROM `course_order_items` 
WHERE pid=1 AND state=1 AND course_id=235 GROUP BY 日期 ORDER BY 日期 ASC)daily_pnl_view,(SELECT @csum:=0) AS it
) xx
ORDER BY 日期 DESC

• 返回结果

日期      人数  累计人数  
----------  ------  --------------
2020-06-26      16              42
2020-06-25      21              26
2020-06-24       5               5

• SQLSTATE[HY000] [2002] Host is unreachable

shell进入redis容器

• 进入reids容器并清空db0的数据库

#!/bin/bash
docker exec -i redis_redis_1 redis-cli <<'EOF'
auth xxxxxx
select 0
flushdb
exit
EOF

• 进入reids容器并清空所有数据库

#!/bin/bash
docker exec -i redis_redis_1 redis-cli <<'EOF'
auth xxxxxx
flushall
exit
EOF

ERROR: Version in "./docker-compose.yml" is invalid. Either specify a version of "2" (or "2.0") and place your service definitions under the services key, or omit the version key and place your service definitions at the root of the file to use version 1.

• For more on the Compose file format versions, see https://docs.docker.com/compose/compose-file/

[root@localhost course2]# docker-compose -v
docker-compose version 1.7.0, build 0d7bf73
[root@localhost course2]# docker-compose down && docker-compose up -d
ERROR: Version in "./docker-compose.yml" is invalid. Either specify a version of "2" (or "2.0") and place your service definitions under the `services` key, or omit the `version` key and place your service definitions at the root of the file to use version 1.
For more on the Compose file format versions, see https://docs.docker.com/compose/compose-file/
[root@localhost course2]# curl -L "https://github.com/docker/compose/releases/download/1.23.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   638  100   638    0     0    400      0  0:00:01  0:00:01 --:--:--   400
 34 11.2M   34 3943k    0     0   5294      0  0:36:59  0:12:42  0:24:17     0
curl: (56) OpenSSL SSL_read: SSL_ERROR_SYSCALL, errno 104
[root@localhost course2]# docker-compose down && docker-compose up -d --build 2.0
[30751] Cannot open self /usr/local/bin/docker-compose or archive /usr/local/bin/docker-compose.pkg
[root@localhost course2]# curl -L "https://github.com/docker/compose/releases/download/1.23.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   638  100   638    0     0    425      0  0:00:01  0:00:01 --:--:--   425
100 11.2M  100 11.2M    0     0  15073      0  0:12:59  0:12:59 --:--:-- 17374
[root@localhost course2]# docker-compose -v
docker-compose version 1.23.2, build 1110ad01

阿里云的LINUX中安装办法

[root@xgblog ~]# yum install docker-compose -y
. . . 
Complete!
[root@xgblog ~]# docker-compose -v
bash: /usr/local/bin/docker-compose: Permission denied
[root@xgblog ~]# chmod +x /usr/local/bin/docker-compose
[root@xgblog ~]# docker-compose -v
docker-compose version 1.23.2, build 1110ad01

不行的话再加软链
ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose