使用openssl版本
[root@myhostname ssl]# openssl version
OpenSSL 1.0.2k-fips 26 Jan 2017
脚本程序
#!/bin/bash
scrip=$0 #获取当前脚本名称
function GetInfo(){
function ModifyInfo(){
for yuming in `ls ` #读取存储了需要监测的域名的文件
do
if [ $yuming == ${scrip} ];then
continue
fi
echo -n "("$yuming ",\""
echo -n `openssl x509 -in $yuming -noout -dates | sed -n '2p' | awk '{print $4"-"}'`
echo -n `openssl x509 -in $yuming -noout -dates | sed -n '2p' | awk '{print $1}' | awk -F'=' '{print $2}'`
openssl x509 -in $yuming -noout -dates | sed -n '2p' | awk '{print "-" $2 " "$3 "\")"}'
done
}
ModifyInfo | sed 's/Jan/01/g' | sed 's/Feb/02/g'| sed 's/Mar/03/g'| sed 's/Apr/04/g'| sed 's/May/05/g'| sed 's/Jun/06/g'| sed 's/Jul/07/g'| sed 's/Aug/08/g'| sed 's/Sep/09/g'| sed 's/Oct/10/g'| sed 's/Nov/11/g'| sed 's/Dec/12/g' #将英文月份转成阿拉伯数字
}
GetInfo #返回元组格式
##写入数据库
dbname="xxx" #定义数据库名
tbname="xxx" #表名
mysql="mysql -uroot -p123456 -h 192.168.1.1 " #定义数据库用户
for i in `GetInfo`
do
sql="insert into $dbname.$tbname values $i"
echo $sql | $mysql
done