getting error
atulkundaria opened this issue · 1 comments
atulkundaria commented
I am using the python to connect with MongoDB Atlas with mongoengine. the codes are as below.
import datetime as dt
import mongoengine as me
import shoonya_details as kd
today = dt.date.today().strftime('%d-%m-%Y')
me.connect(
alias="core", db="algo_trading",
host=f"mongodb+srv://{kd.MONGO_ID}:{kd.MONGO_PWD}@akcluster0.lw3clrm.mongodb.net/algo_trading"
)
class AccessToken(me.Document):
date = me.StringField(default=today, unique=True)
access_token = me.StringField(unique=True, required=True)
meta = {
"db_alias": "core",
"collection": "accesstoken",
"indexes": ["date"]
}
and I am getting error as below:
pymongo.errors.ServerSelectionTimeoutError: ac-sa1chw2-shard-00-01.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997),ac-sa1chw2-shard-00-00.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997),ac-sa1chw2-shard-00-02.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997), Timeout: 30s, Topology Description: <TopologyDescription id: 63f49e3534051c1e57bb1c20, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-sa1chw2-shard-00-00.lw3clrm.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-sa1chw2-shard-00-00.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>, <ServerDescription ('ac-sa1chw2-shard-00-01.lw3clrm.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-sa1chw2-shard-00-01.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>, <ServerDescription ('ac-sa1chw2-shard-00-02.lw3clrm.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-sa1chw2-shard-00-02.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>]>
I am using the Mac M1 chip.
Traceback (most recent call last):
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/finvasia_login.py", line 47, in <module>
_getting_login(shoonya)
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/finvasia_login.py", line 32, in _getting_login
UserToken(date=today, user_token=ret["susertoken"]).save()
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/venv/lib/python3.10/site-packages/mongoengine/document.py", line 417, in save
_ = self._get_collection()
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/venv/lib/python3.10/site-packages/mongoengine/document.py", line 231, in _get_collection
if cls._meta.get("auto_create_index", True) and db.client.is_primary:
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/venv/lib/python3.10/site-packages/pymongo/mongo_client.py", line 1115, in is_primary
return self._server_property("is_writable")
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/venv/lib/python3.10/site-packages/pymongo/mongo_client.py", line 881, in _server_property
server = self._topology.select_server(writable_server_selector)
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/venv/lib/python3.10/site-packages/pymongo/topology.py", line 272, in select_server
server = self._select_server(selector, server_selection_timeout, address)
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/venv/lib/python3.10/site-packages/pymongo/topology.py", line 261, in _select_server
servers = self.select_servers(selector, server_selection_timeout, address)
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/venv/lib/python3.10/site-packages/pymongo/topology.py", line 223, in select_servers
server_descriptions = self._select_servers_loop(selector, server_timeout, address)
File "/Users/atulkundaria/PycharmProjects/pythonProject/pythonProject/finvasia/venv/lib/python3.10/site-packages/pymongo/topology.py", line 238, in _select_servers_loop
raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-sa1chw2-shard-00-01.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997),ac-sa1chw2-shard-00-02.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997),ac-sa1chw2-shard-00-00.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997), Timeout: 30s, Topology Description: <TopologyDescription id: 63f4a22a63c014d86b971aa2, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-sa1chw2-shard-00-00.lw3clrm.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-sa1chw2-shard-00-00.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>, <ServerDescription ('ac-sa1chw2-shard-00-01.lw3clrm.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-sa1chw2-shard-00-01.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>, <ServerDescription ('ac-sa1chw2-shard-00-02.lw3clrm.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-sa1chw2-shard-00-02.lw3clrm.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>]>
bagerard commented
The error you get is not from MongoEngine, it's from the underlying driver Pymongo. This should help you https://stackoverflow.com/questions/69397039/pymongo-ssl-certificate-verify-failed-certificate-has-expired-on-mongo-atlas