博文

MySQL8.0 on RHEL7

用了很久的mysql5.7,终于也要升级到mysql8.0了。升级之后的安装配置步骤有些不同,记录一下 mysql5.7的安装步骤: https://cbzhan.blogspot.com/2018/01/linuxel7-mysql5720-jira738.html mysql8.0的官网安装文档: https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html 1. 首先还是下载yum源: 1) 访问 https://dev.mysql.com/downloads/repo/yum/ ,找到对应的OS和mysql版本的yum源包 2)  下载yum源包: # wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm 3)  安装: # rpm -ivh mysql80-community-release-el7-3.noarch.rpm 4) 确认一下: # yum repolist all | grep mysql 2. 和5.7时一样,卸掉系统自带的mariadb的包 1) 先查询一下: # rpm -qa|grep mariadb mariadb-libs-5.5.64-1.el7.x86_64 2) 卸载: # yum remove mariadb-libs-5.5.64-1.el7.x86_64 3) 再确认一下已经没有了: # rpm -qa|grep mariadb 3. 安装mysql8.0: 1) yum安装: # yum -y install mysql-community-server 2) 确认一下: # rpm -qa | grep mysql mysql-community-common-8.0.17-1.el7.x86_64 mysql-community-server-8.0.17-1.el7.x86_64 mysql80-community-release-el7-3.noarch mysql-community-client-8.0.17-1.el7.x86_64 mysql...

远程连接Windows虚机登录失败:An authentication error has occurred

图片
This could be due to CredSSP encryption oracle remediation 这是由于Windows的安全补丁引起的。简单来说就是连接的双方有一方没有打全补丁。所以解决的方法就是用自动更新打补丁...

docker for windows的问题:error during connect

在win10上安装了docker for windows后,执行docker命令报错: PS C:\Users\u6079532> docker ps error during connect: Get http://%2F%2F.%2Fpipe%2Fdocker_engine/v1.39/containers/json: open //./pipe/docker_engine: The system cannot find the file specified. In the default daemon configuration on Windows, the docker client must be run elevated to connect. This error may also indicate that the docker daemon is not running. 解决方法: https://github.com/docker/for-win/issues/1825 PS C:\Users\u6079532> cd "C:\Program Files\Docker\Docker" PS C:\Program Files\Docker\Docker> ./DockerCli.exe -SwitchDaemon 再检查,成功 PS C:\Program Files\Docker\Docker> docker ps CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS      ...

mysql快速登录配置

mysql login-path mysql_config_editor set --login-path=name --host=hostname --user=user_name mysql_config_editor print --all

IDE的python模板

#!/usr/bin/env python # encoding: utf-8 """ @author: zcb @license: (c) Copytright 2017-2019, zcb @contact: cbzhan@outlook.com @software: ${PRODUCT_NAME} @file: ${NAME}.py @time: ${DATE} ${TIME} @desc: """ import logging import os import socket import mysql.connector FILE_NAME = os.path.basename(__file__) FILENAME = os.path.splitext(FILE_NAME)[0] LOG_NAME = FILENAME + '.log' log_dir = os.getcwd() + '/log' if not os.path.exists(log_dir):     os.makedirs(log_dir) logging.basicConfig(level=logging.DEBUG,                     format='[%(asctime)s] %(filename)s[line:%(lineno)d] %(levelname)s: %(message)s',                     datefmt='%Y-%b-%d %H:%M:%S %a',                 ...

docker创建固定network ip

步骤1:创建一个network,如:名称为:wafnetwork; subnet视机器网络情况而定 docker network ls docker network create   --subnet=170.18.0.0/16    wafnetwork   docker network ls 步骤2:docker启动的时候用,指定使用上述创建的net,如:wafnetwork docker run -itd   --name lblet-jfe-wafcore-bamboo   --net wafnetwork   --ip 170.18.18.4   hub.ark.jcloud.com/pid/centos7.2.base   /bin/bash docker ps | grep jfe docker run -itd   --name lblet-jfe-wafcore-bamboo1   --net wafnetwork   --ip 170.18.18.5   hub.ark.jcloud.com/pid/centos7.2.base   /bin/bash docker ps | grep jfe 步骤3:查看对应容器ip:(可随意start,stop容器,ip都不会变化。如果docker容器被rm掉了,则:返回执行步骤2即可) docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}'   lblet-jfe-wafcore-bamboo1 docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}'   lblet-jfe-wafcore-bamboo docker stop lblet-jfe-wafcore-bamboo docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' ...

docxgen给没有类定义的python项目生成文档时的配置

图片
    docxgen默认是按照class的定义去生成类的层级关系、继承关系、成员变量和函数的     但是有的时候,比如用flask开发python项目时,flask的写法就是没有类定义的。当然如果硬要搞的话,也可以把flask的app封装到一个类里,但这样的搞法与flask的思想背道而驰,既无必要,又增加了代码阅读和维护难度。     好在docxgen提供了一些特殊字符和自定义的配置。比如用"""!来标识docstring的开头。对于本文这个问题,找到配置文件中EXTRACT_ALL的选项,设为YES,再执行docxgen,即可按文件的维度生成文档