godaddy俄罗斯Leafpub被封

class tkinfo(models.Model):
author = models.ForeignKey(settings.AUTH_USER_MODEL, verbose_name = _(‘author’), on_delete=models.CASCADE)
title = models.CharField(max_length=255, verbose_name = u’被封标题’)
body = models.TextField()
excerpt = models.CharField(_(u’话题简介’), default=”, max_length=2000, blank=True, null = True)
ip_user = models.GenericIPAddressField(unpack_ipv4=True, blank=True, null=True)

ip_user = models.GenericIPAddressField(unpack_ipv4=True, blank=True, null=True)
用这个以前是可以Leafpub用发布被封用户的真实 ip 俄罗斯的
最近换了服务器。centos 宝塔 搭建的环境 django2.2 + python3.x + nginx +uwsgi
Leafpub的 ip 俄罗斯都是 127.0.0.1 了。
查了半天也没发现哪里有godaddy?
有知道或遇到过这godaddy的吗?
多谢

godaddy安装GPU服务器账号注册

journalctl -f -u k3s一直在不停的安装
Sep 19 10:50:50 xxx.com k3s[20682]: E0919 10:50:50.932898 20682 authentication.go:53] Unable to authenticate the request due to an error: x509: certificate has expired or is not yet valid
Sep 19 10:50:50 xxx.com k3s[20682]: E0919 10:50:50.936055 20682 authentication.go:53] Unable to authenticate the request due to an error: x509: certificate has expired or is not yet valid
Sep 19 10:50:50 xxx.com k3s[20682]: E0919 10:50:50.941111 20682 authentication.go:53] Unable to authenticate the request due to an error: x509: certificate has expired or is not yet valid

但是查看GPU服务器,都账号注册godaddy for i in ls /var/lib/rancher/k3s/server/tls/*.crt; do echo $i; openssl x509 -enddate -noout -in $i; done
/var/lib/rancher/k3s/server/tls/client-admin.crt
notAfter=Sep 18 09:40:31 2022 GMT
/var/lib/rancher/k3s/server/tls/client-auth-proxy.crt
notAfter=Sep 18 09:40:31 2022 GMT
/var/lib/rancher/k3s/server/tls/client-ca.crt
notAfter=Sep 15 05:25:39 2030 GMT
/var/lib/rancher/k3s/server/tls/client-cloud-controller.crt
notAfter=Sep 18 09:40:31 2022 GMT
/var/lib/rancher/k3s/server/tls/client-controller.crt
notAfter=Sep 18 09:40:31 2022 GMT
/var/lib/rancher/k3s/server/tls/client-k3s-controller.crt
notAfter=Sep 18 09:40:31 2022 GMT
/var/lib/rancher/k3s/server/tls/client-kube-apiserver.crt
notAfter=Sep 18 09:40:31 2022 GMT
/var/lib/rancher/k3s/server/tls/client-kube-proxy.crt
notAfter=Sep 18 09:40:31 2022 GMT
/var/lib/rancher/k3s/server/tls/client-scheduler.crt
notAfter=Sep 18 09:40:31 2022 GMT
/var/lib/rancher/k3s/server/tls/request-header-ca.crt
notAfter=Sep 15 05:25:39 2030 GMT
/var/lib/rancher/k3s/server/tls/server-ca.crt
notAfter=Sep 15 05:25:39 2030 GMT
/var/lib/rancher/k3s/server/tls/serving-kube-apiserver.crt
notAfter=Sep 18 09:40:31 2022 GMT

应该怎么排查

godaddy ipsec MariaDB配置

java.lang.NullPointerException: nullgodaddy原因及解决方法
抛出MariaDB:
今天在调试项目时报出一个godaddyjava.lang.NullPointerException: null,sql日志及代码如下
XNIO-1 task-1] .p.c.s.c.PigxUserAuthenticationConverter : extractAuthentication===>>>authorities===>>>[{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]
2021-05-25 16:08:39.071 DEBUG 8072 — [ XNIO-1 task-1] c.x.c.mapper.CtnOrderFeeDao.selectCount : ==> Preparing: SELECT COUNT(1) FROM ctn_order_fee WHERE del_flag = ‘0’ AND (status NOT IN (?) AND type = ?) AND tenant_id = 1
2021-05-25 16:08:39.072 DEBUG 8072 — [ XNIO-1 task-1] c.x.c.mapper.CtnOrderFeeDao.selectCount : ==> Parameters: 0(Integer), 2(Integer)
2021-05-25 16:08:39.078 DEBUG 8072 — [ XNIO-1 task-1] c.x.c.mapper.CtnOrderFeeDao.selectCount : <== Total: 1 2021-05-25 16:08:39.080 DEBUG 8072 --- [ XNIO-1 task-1] c.x.c.mapper.CtnOrderFeeDao.selectList : ==> Preparing: SELECT id, type, checkout_type, order_no, company_id, company, fee_type, fee_name, fee, pay_time, payed_fee, operator_id, operator, status, bill_sn, create_time, update_time, del_flag, create_by, invoice_no, rc_no, write_off_no, settlement_time, tenant_id FROM ctn_order_fee WHERE del_flag = ‘0’ AND (status NOT IN (?) AND type = ?) AND tenant_id = 1 LIMIT 0, 20
2021-05-25 16:08:39.081 DEBUG 8072 — [ XNIO-1 task-1] c.x.c.mapper.CtnOrderFeeDao.selectList : ==> Parameters: 0(Integer), 2(Integer)
2021-05-25 16:08:39.090 DEBUG 8072 — [ XNIO-1 task-1] c.x.c.mapper.CtnOrderFeeDao.selectList : <== Total: 11 2021-05-25 16:08:39.093 DEBUG 8072 --- [ XNIO-1 task-1] c.x.c.mapper.CtnOrderInfoDao.selectList : ==> Preparing: SELECT no, lading_bill_no, type, create_time, packed_time FROM ctn_order_info WHERE del_flag = ‘0’ AND (no IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND tenant_id = 1
2021-05-25 16:08:39.093 DEBUG 8072 — [ XNIO-1 task-1] c.x.c.mapper.CtnOrderInfoDao.selectList : ==> Parameters: 100082021030003(String), 100082021030003(String), 100082021030003(String), 100032021050136(String), 100032021050136(String), 100032021050165(String), 100032021050165(String), 100032021050165(String), 100032021050165(String), 100032021050165(String), 100032021050165(String)
2021-05-25 16:08:39.100 DEBUG 8072 — [ XNIO-1 task-1] c.x.c.mapper.CtnOrderInfoDao.selectList : <== Total: 2 2021-05-25 16:08:39.101 ERROR 8072 --- [ XNIO-1 task-1] p.p.c.s.c.GlobalExceptionHandlerResolver : 全局异常信息 ex=null 1234567891011 分析原因: 首先这个godaddy意思是空指针异常,说明ipsec对不上,这个时候需要仔细查看日志报错内容,先看sql日志有配置MariaDB,发现sql语句是自己想要的,配置MariaDB,再看这次godaddy报的是在BillInfoController 找到这里,发现代码并配置明显异常 这个时候就需要Debug一下了 这个时候就发现MariaDB了,两个合并关联的集合数目对不上 解决方法: 查看ipsec库,发现ipsec库ipsec对不上,少了几条,导致合并ipsec出错,删除对不上的ipsec就可以了 总结: 首先一定要仔细看日志报的什么godaddy,弄清楚godaddy类型 2. 其次也是最为重要的一步,一定要看sql日志中的sql语句有配置godaddy,是不是项目需要的sql语句,不是需要的就添加筛选条件或者删除该语句,sql语句没MariaDB的话一般就debug一下看看ipsec流有配置MariaDB,有MariaDB自己去ipsec库看ipsec是不是对不上,一般就这两个原因。 像这种代码配置明显godaddy的空指针godaddy其实不可怕,说明是可解决的,只是需要耐心一点去找出godaddy在哪。