INFO: 192.168.1.103:42758 - "POST /api/login HTTP/1.1" 500 Internal Server Error
ERROR: Exception in ASGI application
Traceback (most recent call last):
File "/var/www/html/.venv/lib/python3.11/site-packages/mysql/connector/connection_cext.py", line 354, in _open_connection
self._cmysql.connect(**cnx_kwargs)
_mysql_connector.MySQLInterfaceError: Access denied for user 'serveurweb'@'localhost' (using password: YES)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/www/html/API/main.py", line 51, in connexion
connexion = get_db_connection()
^^^^^^^^^^^^^^^^^^^
File "/var/www/html/API/database.py", line 8, in get_db_connection
return mysql.connector.connect(
^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/mysql/connector/pooling.py", line 322, in connect
return CMySQLConnection(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/mysql/connector/connection_cext.py", line 142, in __init__
self.connect(**kwargs)
File "/var/www/html/.venv/lib/python3.11/site-packages/mysql/connector/abstracts.py", line 1604, in connect
self._open_connection()
File "/var/www/html/.venv/lib/python3.11/site-packages/mysql/connector/connection_cext.py", line 360, in _open_connection
raise get_mysql_exception(
mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'serveurweb'@'localhost' (using password: YES)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/var/www/html/API/main.py", line 63, in connexion
raise HTTPException(status_code=500, detail="Erreur interne du serveur")
fastapi.exceptions.HTTPException: 500: Erreur interne du serveur
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/var/www/html/.venv/lib/python3.11/site-packages/uvicorn/protocols/http/httptools_impl.py", line 416, in run_asgi
result = await app( # type: ignore[func-returns-value]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
return await self.app(scope, receive, send)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/fastapi/applications.py", line 1160, in __call__
await super().__call__(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/applications.py", line 90, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 186, in __call__
raise exc
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 164, in __call__
await self.app(scope, receive, _send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/middleware/cors.py", line 96, in __call__
await self.simple_response(scope, receive, send, request_headers=headers)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/middleware/cors.py", line 154, in simple_response
await self.app(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 63, in __call__
await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/www/html/.venv/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in __call__
await self.app(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/routing.py", line 660, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/routing.py", line 680, in app
await route.handle(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/routing.py", line 276, in handle
await self.app(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/fastapi/routing.py", line 130, in app
await wrap_app_handling_exceptions(app, request)(scope, receive, send)
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/www/html/.venv/lib/python3.11/site-packages/fastapi/routing.py", line 116, in app
response = await f(request)
^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/fastapi/routing.py", line 670, in app
raw_response = await run_endpoint_function(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/fastapi/routing.py", line 326, in run_endpoint_function
return await run_in_threadpool(dependant.call, **values)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/starlette/concurrency.py", line 32, in run_in_threadpool
return await anyio.to_thread.run_sync(func)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/anyio/to_thread.py", line 63, in run_sync
return await get_async_backend().run_sync_in_worker_thread(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 2502, in run_sync_in_worker_thread
return await future
^^^^^^^^^^^^
File "/var/www/html/.venv/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 986, in run
result = context.run(func, *args)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/API/main.py", line 65, in connexion
if cursor:
^^^^^^
UnboundLocalError: cannot access local variable 'cursor' where it is not associated with a value
To embed this project on your website, copy the following code and paste it into your website's HTML: