Thank you for responding. I rebooted our server and re-ran the service from the command line.
Confession: I can follow instructions but am not understanding the python environment creation. The venv seems unaware of python modules installed on our server and require them to be installed within the virtual environment before the service will run.
That said, here is the output produced when I tried using the Find matching faces function.
INFO: Started server process [6240]
INFO: Waiting for application startup.
INFO: Application startup complete.
INFO:
127.0.0.1:37196 - "POST /find_similar_faces HTTP/1.1" 500 Internal Server Error
ERROR: Exception in ASGI application
Traceback (most recent call last):
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/uvicorn/protocols/http/h11_impl.py", line 403, in run_asgi
result = await app( # type: ignore[func-returns-value]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
return await
self.app(scope, receive, send)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/fastapi/applications.py", line 1054, in __call__
await super().__call__(scope, receive, send)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/applications.py", line 112, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
raise exc
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 85, in __call__
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
await wrap_app_handling_exceptions(
self.app, conn)(scope, receive, send)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/routing.py", line 714, in __call__
await self.middleware_stack(scope, receive, send)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/routing.py", line 734, in app
await route.handle(scope, receive, send)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/routing.py", line 288, in handle
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/routing.py", line 76, in app
await wrap_app_handling_exceptions(app, request)(scope, receive, send)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app(scope, receive, sender)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/starlette/routing.py", line 73, in app
response = await f(request)
^^^^^^^^^^^^^^^^
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/fastapi/routing.py", line 301, in app
raw_response = await run_endpoint_function(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/fastapi/routing.py", line 212, in run_endpoint_function
return await dependant.call(**values)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/resourcespace/plugins/faces/scripts/faces_service.py", line 143, in find_similar_faces
load_vectors(db_name)
File "/var/www/html/resourcespace/plugins/faces/scripts/faces_service.py", line 52, in load_vectors
conn = get_mysql_connection(db_name)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/resourcespace/plugins/faces/scripts/faces_service.py", line 43, in get_mysql_connection
return mysql.connector.connect(
^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/mysql/connector/pooling.py", line 323, in connect
return MySQLConnection(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/mysql/connector/connection.py", line 185, in __init__
self.connect(**kwargs)
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/mysql/connector/abstracts.py", line 1605, in connect
self._open_connection()
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/mysql/connector/connection.py", line 411, in _open_connection
raise err
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/mysql/connector/connection.py", line 388, in _open_connection
self._do_auth(
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/mysql/connector/connection.py", line 320, in _do_auth
ok_pkt = self._authenticator.authenticate(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/mysql/connector/authentication.py", line 381, in authenticate
ok_pkt = self._handle_server_response(sock, pkt)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/html/RS_AI/facenv/lib/python3.12/site-packages/mysql/connector/authentication.py", line 287, in _handle_server_response
raise get_exception(pkt)
mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'resourcespace_rw'@'localhost' (using password: YES)