jpuyy的网志

Author: jpuyy

  • openssl shell 检验 ssl 证书过期时间

    语法如下

    site=www.youqiantu.com
echo | openssl s_client -servername $site -connect $site:443 2>/dev/null | openssl x509 -noout -dates

    添加很多域名的 check

    #!/bin/bash

domains='
sentry.google.com
console.google.com
www.google.com
m.google.com
api.google.com
'

for domain in $domains
do
  check_result=$(echo | openssl s_client -servername $domain -connect $domain:443 2>/dev/null | openssl x509 -noout -dates | grep After)
  echo "$domain\t $check_result" | awk -F"\t" '{sub(/^ /,"",$2);printf "%-40s%s\n",$1,$2}'
done

    对于自己签发的证书

    openssl x509 -enddate -noout -in apiserver.pem 
notAfter=Mar  5 13:23:40 2018 GMT

    或者通过第三方工具检查
    https://www.ssllabs.com/ssltest/analyze.html
    https://whatsmychaincert.com/?jpuyy.com

    证书信息 certificate/intermediate/root ca

    openssl x509 -in example.com.crt -text -noout

    key 信息

    openssl rsa -in example.com.key -check

    检查 p12 证书过期时间
    https://stackoverflow.com/questions/28373771/how-to-determine-ssl-cert-expire-date-from-the-cert-file-itself-p12/28374749

    You can use openssl to extract the certificate from the .p12 file to a .pem file using the following command:

openssl pkcs12 -in certificate.p12 -out certificate.pem -nodes
Then, you can extract the expiration date from the certificate in the .pem file using the following command:

cat certificate.pem | openssl x509 -noout -enddate

  • cassandra 操作记录

    查看状态

    bin/nodetool status

    查看所有的 keyspaces

    DESCRIBE KEYSPACES

    查看网络状态

    bin/nodetool netstats

    查看 gossipinfo

    bin/nodetool gossipinfo

    修改 replication factor 之后进行 repair

    bin/nodetool repair

    踢除一个活的节点

    bin/nodetool decommision

    导出一个 keyspace 的结构

    cqlsh -e "DESC KEYSPACE test" > db_schema_test.cql;

    导出所有 keyspace 的结构

    cqlsh -e "DESC SCHEMA" > db_schema.cql

    导出表至 csv 文件

    COPY table_name ( column , ... )
TO  'file_name' | STDOUT 
WITH option = 'value' AND ...

    当需要维护一个结点时

    cd /opt/platform/cassandra/
    bin/nodetool drain
    # stop
    pgrep -u ops -f cassandra | xargs kill -9

    # start
    nohup ./bin/cassandra &

    变更后 Check
    /opt/platform/cassandra/bin/nodetool status
    关注

    Status – U (up) or D (down)
    Indicates whether the node is functioning or not.

    State – N (normal), L (leaving), J (joining), M (moving)
    The state of the node in relation to the cluster.

  • less 查找忽略大小写

    平时使用

    cat config.json | less

    如果有大小区分的时候搜索时不太方便

    现在只使用小写搜索

    cat config.json | less -i

  • mysqldump 加 where 条件

    导出表，时间大于 2017-05-17

    mysqldump -u root -p dw tracking --where 'stm > 2017-05-17' > dw.tracking.2017-05-17.sql

  • 《荒野求生》金句

    荒野虽险，身体+头脑依然能够生存，在社会上行走，也是行走在荒野

    Survival can be summed up in three words – never give up. That’s the heart of it really. Just keep trying.
    The line between life or death is determined by what we are willing to do.
    If you risk nothing you gain nothing
    If you can find a path with no obstacles, it probably doesn’t lead anywhere.
    There is little faith involved in setting out on a journey where the destination is certain and every step in between has been mapped in detail. Bravery, trust, is about leaving camp in the dark, when we do not know the route ahead and cannot be certain we will ever return.
    When you find yourself thinking about someone or something in the same old negative way, just stop yourself. Think. Check. Change. Refresh. Job done. Smile. Move on. Do this enough times and you will change. For the better; for the stronger.
    And if you give your heart to a goal, it will repay you. It’s the law of the universe.
    Stick to the fight when you’re hardest hit, It’s when things seem worst that you must not quit.
    There is no education like adversity.
    Tentative is no power.

  • git diff 换行

    git --no-pager diff

    or

    git diff --color | less -R

    显示改动过的文件

    git diff --staged --name-only  | cat

    比较 feature 分支和 master 分支具体一个文件的变动

    git diff feature/sftp-server master -- .gitlab-ci.yml

    https://stackoverflow.com/questions/4099742/how-to-compare-files-from-two-different-branches