修改为 https 后,不能导入导出excel

费了好长时间,终于改成了https,整体功能正常,但 没法导入导出excel了

导入时错误日志:

[ERROR] seahub.api2.endpoints.dtable_io[332] - upload excel error: HTTPSConnectionPool(host='xxx.xx.xx', port=xxxxx): Max retries exceeded with url: /seafhttp/upload-api/00e2c837-fab6-4fd7-ae2e-a5f489993dfb?replace=1 (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1131)')))

导出时错误日志:

[ERROR] django.request[241] - Internal Server Error: /api/v2.1/workspace/1/import-dtable/
 [WARNING] django.request[241] - Not Found: /api/v2.1/workspace/1/dtable/xxxxxxxxxxxx/export-table-to-excel/

【dtable_events_io.log 】

2024-05-10 10:18:27,785 [INFO] Run task: 5b54a241-0472-44ef-95a6-9209f0c7a506 <function convert_table_to_execl at 0x7f82cb45d700>
2024-05-10 10:18:27,824 [ERROR] get nicknames. ERROR: HTTPSConnectionPool(host='xxxx.xxx.xx', port=xx): Max retries exceeded with url: /api/v2.1/dtables/c904593e-78cf-458f-bb09-b82e5ceb4b5e/related-users/ (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1131)')))
2024-05-10 10:18:27,827 [INFO] Run task success: 5b54a241-0472-44ef-95a6-9209f0c7a506 <function convert_table_to_execl at 0x7f82cb45d700> cost 0s

因为你用的是自签名证书 自签名证书的CA不在seatable 信任列表(cacert.pem文件)

那具体该如何解决证书问题呢

确实是这个问题,解决了,改成了另一个域名的SSL证书