Upgrade SQLAlchemy to >= 2.0.22 #20443

GGP1 · 2023-11-27T15:39:37Z

Wazuh version	Component
4.9.0	Wazuh embedded Python interpreter

Description

During the investigation of a warning in the RBAC unit tests in #20260, I've found that the reason behind it was a bug in SQLAlchemy's source code.

There's an issue where under some garbage collection/exception scenarios the connection pool's cleanup routine would fail because of an unexpected state. This was fixed in the following commit which was introduced in the 2.0.22 version.

We are currently using 2.0.0, so we should upgrade to that version or a newer one.

Checks

The following elements have been updated or reviewed (should also be checked if no modification is required):

Tests (unit tests, API integration tests).
Changelog.
Documentation.
Integration test mapping (using api/test/integration/mapping/_test_mapping.py).

The text was updated successfully, but these errors were encountered:

fdalmaup · 2023-12-04T16:47:59Z

Issue Update

The latest SQLAlchemy version is 2.0.23. The upgrade will aim to said release.

UTs Execution

When installing SQLAlchemy==2.0.23 and running the API and Framework unit tests, no errors or warnings were found:

SQLAlchemy version used

(unittest-env-3.10) fdalmau@wazuhFW:~/git/wazuh(enhancement/20443-sqlalchemy-update)$ pip3 show sqlalchemy
Name: SQLAlchemy
Version: 2.0.23
Summary: Database Abstraction Library
Home-page: https://www.sqlalchemy.org
Author: Mike Bayer
Author-email: mike_mp@zzzcomputing.com
License: MIT
Location: /home/fdalmau/venv/unittest-env-3.10/lib/python3.10/site-packages
Requires: greenlet, typing-extensions
Required-by:

API

$ pytest api/api/
====================================================================== test session starts ======================================================================
platform linux -- Python 3.10.13, pytest-7.3.1, pluggy-1.0.0
rootdir: /home/fdalmau/git/wazuh/api/api
configfile: pytest.ini
plugins: cov-3.0.0, aiohttp-1.0.4, trio-0.7.0, anyio-3.6.2, metadata-2.0.2, tavern-1.23.5, asyncio-0.18.1, html-2.1.1
asyncio: mode=auto
collected 560 items                                                                                                                                             

api/api/controllers/test/test_active_response_controller.py .                                                                                             [  0%]
api/api/controllers/test/test_agent_controller.py ............................................                                                            [  8%]
api/api/controllers/test/test_cdb_list_controller.py ......                                                                                               [  9%]
api/api/controllers/test/test_ciscat_controller.py .                                                                                                      [  9%]
api/api/controllers/test/test_cluster_controller.py ........................                                                                              [ 13%]
api/api/controllers/test/test_decoder_controller.py .......                                                                                               [ 14%]
api/api/controllers/test/test_default_controller.py .                                                                                                     [ 15%]
api/api/controllers/test/test_event_controller.py .                                                                                                       [ 15%]
api/api/controllers/test/test_experimental_controller.py ...............                                                                                  [ 17%]
api/api/controllers/test/test_manager_controller.py ..................                                                                                    [ 21%]
api/api/controllers/test/test_mitre_controller.py .......                                                                                                 [ 22%]
api/api/controllers/test/test_overview_controller.py .                                                                                                    [ 22%]
api/api/controllers/test/test_rootcheck_controller.py ....                                                                                                [ 23%]
api/api/controllers/test/test_rule_controller.py ........                                                                                                 [ 24%]
api/api/controllers/test/test_sca_controller.py ..                                                                                                        [ 25%]
api/api/controllers/test/test_security_controller.py ...................................................                                                  [ 34%]
api/api/controllers/test/test_syscheck_controller.py ....                                                                                                 [ 34%]
api/api/controllers/test/test_syscollector_controller.py .........                                                                                        [ 36%]
api/api/controllers/test/test_task_controller.py .                                                                                                        [ 36%]
api/api/controllers/test/test_vulnerability_controller.py ....                                                                                            [ 37%]
api/api/models/test/test_model.py ..............................                                                                                          [ 42%]
api/api/test/test_alogging.py ......................                                                                                                      [ 46%]
api/api/test/test_authentication.py ...........                                                                                                           [ 48%]
api/api/test/test_configuration.py .............................................                                                                          [ 56%]
api/api/test/test_encoder.py ...                                                                                                                          [ 57%]
api/api/test/test_middlewares.py ...............                                                                                                          [ 59%]
api/api/test/test_uri_parser.py ...                                                                                                                       [ 60%]
api/api/test/test_util.py ..............................................                                                                                  [ 68%]
api/api/test/test_validator.py .......................................................................................................................... [ 90%]
......................................................                                                                                                    [100%]

===================================================================== 560 passed in 13.97s ======================================================================

Framework

$ pytest framework/
====================================================================== test session starts ======================================================================
platform linux -- Python 3.10.13, pytest-7.3.1, pluggy-1.0.0
rootdir: /home/fdalmau/git/wazuh/framework
configfile: pytest.ini
plugins: cov-3.0.0, aiohttp-1.0.4, trio-0.7.0, anyio-3.6.2, metadata-2.0.2, tavern-1.23.5, asyncio-0.18.1, html-2.1.1
asyncio: mode=auto
collected 2194 items                                                                                                                                            

framework/scripts/tests/test_agent_groups.py ..............                                                                                               [  0%]
framework/scripts/tests/test_agent_upgrade.py ...............                                                                                             [  1%]
framework/scripts/tests/test_cluster_control.py ......                                                                                                    [  1%]
framework/scripts/tests/test_rbac_control.py .........                                                                                                    [  2%]
framework/scripts/tests/test_wazuh_clusterd.py .......                                                                                                    [  2%]
framework/scripts/tests/test_wazuh_logtest.py ......................                                                                                      [  3%]
framework/wazuh/core/cluster/dapi/tests/test_dapi.py ................................                                                                     [  4%]
framework/wazuh/core/cluster/tests/test_client.py ................                                                                                        [  5%]
framework/wazuh/core/cluster/tests/test_cluster.py ...................................                                                                    [  7%]
framework/wazuh/core/cluster/tests/test_common.py ....................................................................................                    [ 10%]
framework/wazuh/core/cluster/tests/test_control.py ......                                                                                                 [ 11%]
framework/wazuh/core/cluster/tests/test_local_client.py ..............                                                                                    [ 11%]
framework/wazuh/core/cluster/tests/test_local_server.py ........................                                                                          [ 12%]
framework/wazuh/core/cluster/tests/test_master.py ...............................................                                                         [ 15%]
framework/wazuh/core/cluster/tests/test_server.py .............................                                                                           [ 16%]
framework/wazuh/core/cluster/tests/test_utils.py ............                                                                                             [ 16%]
framework/wazuh/core/cluster/tests/test_worker.py ..................................                                                                      [ 18%]
framework/wazuh/core/tests/test_active_response.py ....................                                                                                   [ 19%]
framework/wazuh/core/tests/test_agent.py ................................................................................................................ [ 24%]
.....................................                                                                                                                     [ 26%]
framework/wazuh/core/tests/test_cdb_list.py ......................................                                                                        [ 27%]
framework/wazuh/core/tests/test_common.py .........                                                                                                       [ 28%]
framework/wazuh/core/tests/test_configuration.py .......................................................................                                  [ 31%]
framework/wazuh/core/tests/test_decoder.py ................                                                                                               [ 32%]
framework/wazuh/core/tests/test_exception.py ..........                                                                                                   [ 32%]
framework/wazuh/core/tests/test_input_validator.py ...                                                                                                    [ 32%]
framework/wazuh/core/tests/test_logtest.py ..                                                                                                             [ 32%]
framework/wazuh/core/tests/test_manager.py ................                                                                                               [ 33%]
framework/wazuh/core/tests/test_mitre.py .............                                                                                                    [ 34%]
framework/wazuh/core/tests/test_pyDaemonModule.py .....                                                                                                   [ 34%]
framework/wazuh/core/tests/test_results.py ........................................                                                                       [ 36%]
framework/wazuh/core/tests/test_rootcheck.py .............                                                                                                [ 36%]
framework/wazuh/core/tests/test_rule.py .......................                                                                                           [ 38%]
framework/wazuh/core/tests/test_sca.py .............................                                                                                      [ 39%]
framework/wazuh/core/tests/test_security.py .............                                                                                                 [ 39%]
framework/wazuh/core/tests/test_stats.py .................                                                                                                [ 40%]
framework/wazuh/core/tests/test_syscheck.py .......                                                                                                       [ 41%]
framework/wazuh/core/tests/test_syscollector.py ...                                                                                                       [ 41%]
framework/wazuh/core/tests/test_task.py ........                                                                                                          [ 41%]
framework/wazuh/core/tests/test_utils.py ................................................................................................................ [ 46%]
......................................................................................................................................................... [ 53%]
...............                                                                                                                                           [ 54%]
framework/wazuh/core/tests/test_vulnerability.py ..                                                                                                       [ 54%]
framework/wazuh/core/tests/test_wazuh_queue.py .......................                                                                                    [ 55%]
framework/wazuh/core/tests/test_wazuh_socket.py ....................                                                                                      [ 56%]
framework/wazuh/core/tests/test_wdb.py ...............................                                                                                    [ 57%]
framework/wazuh/core/tests/test_wlogging.py ............                                                                                                  [ 58%]
framework/wazuh/rbac/tests/test_auth_context.py ..                                                                                                        [ 58%]
framework/wazuh/rbac/tests/test_decorators.py ........................................................................................................... [ 63%]
..                                                                                                                                                        [ 63%]
framework/wazuh/rbac/tests/test_default_configuration.py .........................................................                                        [ 65%]
framework/wazuh/rbac/tests/test_orm.py ..............................................................                                                     [ 68%]
framework/wazuh/rbac/tests/test_preprocessor.py ...........                                                                                               [ 69%]
framework/wazuh/tests/test_active_response.py ............                                                                                                [ 69%]
framework/wazuh/tests/test_agent.py ..................................................................................................................... [ 75%]
............                                                                                                                                              [ 75%]
framework/wazuh/tests/test_cdb_list.py .....................................................                                                              [ 78%]
framework/wazuh/tests/test_ciscat.py .................................                                                                                    [ 79%]
framework/wazuh/tests/test_cluster.py ..........                                                                                                          [ 80%]
framework/wazuh/tests/test_decoder.py ..........................................................                                                          [ 82%]
framework/wazuh/tests/test_event.py ....                                                                                                                  [ 82%]
framework/wazuh/tests/test_logtest.py ......                                                                                                              [ 83%]
framework/wazuh/tests/test_manager.py ....................................                                                                                [ 84%]
framework/wazuh/tests/test_mitre.py .......                                                                                                               [ 85%]
framework/wazuh/tests/test_rootcheck.py ..................................................                                                                [ 87%]
framework/wazuh/tests/test_rule.py ..........................................................................                                             [ 90%]
framework/wazuh/tests/test_sca.py ...........                                                                                                             [ 91%]
framework/wazuh/tests/test_security.py .......................................................................                                            [ 94%]
framework/wazuh/tests/test_stats.py ...............                                                                                                       [ 95%]
framework/wazuh/tests/test_syscheck.py .........................                                                                                          [ 96%]
framework/wazuh/tests/test_syscollector.py ............                                                                                                   [ 96%]
framework/wazuh/tests/test_task.py ............................                                                                                           [ 98%]
framework/wazuh/tests/test_vulnerability.py ........................................                                                                      [100%]

=============================================================== 2194 passed in 652.36s (0:10:52) ================================================================

fdalmaup · 2023-12-04T16:48:21Z

Wazuh embedded Python interpreter

The SQLAlchemy dependency has been updated in the embedded interpreter, not showing any errors during the installation both in the amd64 and aarch64 architectures.

`amd64`

[root@8317efcade0d /]# uname -m
x86_64
[root@8317efcade0d /]# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)

Wazuh installation and SQLAlchemy version

[root@8317efcade0d wazuh]# ./install.sh
...
Done building server

Wait for success...
success
Removing old SCA policies...
Installing SCA policies...
Installing additional SCA policies...
Makefile:2531: warning: overriding recipe for target `win32/ui_resource.o'
Makefile:2471: warning: ignoring old recipe for target `win32/ui_resource.o'
Makefile:2534: warning: overriding recipe for target `win32/auth_resource.o'
Makefile:2474: warning: ignoring old recipe for target `win32/auth_resource.o'
mkdir -p /var/ossec/framework/python
cp external/cpython.tar.gz /var/ossec/framework/python/cpython.tar.gz && tar -xf /var/ossec/framework/python/cpython.tar.gz -C /var/ossec/framework/python && rm -rf /var/ossec/framework/python/cpython.tar.gz
find /var/ossec/framework/python -name "*libpython3.10.so.1.0" -exec ln -f {} /var/ossec/lib/libpython3.10.so.1.0 \;
cd ../framework && /var/ossec/framework/python/bin/python3 -m pip install . --use-pep517 --prefix=/var/ossec/framework/python && rm -rf build/
Processing /wazuh/framework
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: wazuh
  Building wheel for wazuh (pyproject.toml) ... done
  Created wheel for wazuh: filename=wazuh-4.9.0-py3-none-any.whl size=295753 sha256=4576a32483876cf2a8f6ad54cad1050f1e30b6e655dabcd42c43e8cbcf82179c
  Stored in directory: /tmp/pip-ephem-wheel-cache-u7nuu7al/wheels/fe/47/7c/2c289aea2e8a5cc5ac8936e5cecbbfc0bdd996d57bb70da19a
Successfully built wazuh
Installing collected packages: wazuh
Successfully installed wazuh-4.9.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

[notice] A new release of pip is available: 23.0.1 -> 23.3.1
[notice] To update, run: /var/ossec/framework/python/bin/python3 -m pip install --upgrade pip
chown -R root:wazuh /var/ossec/framework/python
chmod -R o=- /var/ossec/framework/python
cd ../api && /var/ossec/framework/python/bin/python3 -m pip install . --use-pep517 --prefix=/var/ossec/framework/python && rm -rf build/
Processing /wazuh/api
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: api
  Building wheel for api (pyproject.toml) ... done
  Created wheel for api: filename=api-4.9.0-py3-none-any.whl size=159569 sha256=5db9d38915a4d9645c561ef90d61a812f090c860cf7c6eb8a8accef9f11c710a
  Stored in directory: /tmp/pip-ephem-wheel-cache-nrxrypan/wheels/2c/ed/d5/5358cdcfa6f68fc41b8ca02118521c75da82e9ec6d16f50822
Successfully built api
Installing collected packages: api
Successfully installed api-4.9.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

[notice] A new release of pip is available: 23.0.1 -> 23.3.1
[notice] To update, run: /var/ossec/framework/python/bin/python3 -m pip install --upgrade pip
cd ../tools/mitre && /var/ossec/framework/python/bin/python3 mitredb.py -d /var/ossec/var/db/mitre.db
chcon: can't apply partial context to unlabeled file ‘/var/ossec/lib/libjemalloc.so.2’
Generating self-signed certificate for wazuh-authd...


 - System is Redhat Linux.
 - Init script modified to start Wazuh during boot.
Starting Wazuh...
server
Starting Wazuh v4.9.0...
/var/ossec/api/scripts/wazuh-apid.py:305: DeprecationWarning: ssl.PROTOCOL_TLSv1_2 is deprecated
  ssl_context = ssl.SSLContext(protocol=ssl_protocol)
Started wazuh-apid...
Started wazuh-csyslogd...
Started wazuh-dbd...
2023/12/04 18:31:30 wazuh-integratord: INFO: Remote integrations not configured. Clean exit.
Started wazuh-integratord...
Started wazuh-agentlessd...
Started wazuh-authd...
Started wazuh-db...
Started wazuh-execd...
Started wazuh-analysisd...
Started wazuh-syscheckd...
Started wazuh-remoted...
Started wazuh-logcollector...
Started wazuh-monitord...
Started wazuh-modulesd...
Completed.

 - Configuration finished properly.

 - To start Wazuh:
      /var/ossec/bin/wazuh-control start

 - To stop Wazuh:
      /var/ossec/bin/wazuh-control stop

 - The configuration can be viewed or modified at /var/ossec/etc/ossec.conf


   Thanks for using Wazuh.
   Please don't hesitate to contact us if you need help or find
   any bugs.

   Use our public Mailing List at:
          https://groups.google.com/forum/#!forum/wazuh

   More information can be found at:
          - http://www.wazuh.com

    ---  Press ENTER to finish (maybe more information below). ---

 - In order to connect agent and server, you need to add each agent to the server.

   More information at: 
   https://documentation.wazuh.com/

[root@8317efcade0d wazuh]# /var/ossec/framework/python/bin/pip3 show sqlalchemy
Name: SQLAlchemy
Version: 2.0.23
Summary: Database Abstraction Library
Home-page: https://www.sqlalchemy.org
Author: Mike Bayer
Author-email: mike_mp@zzzcomputing.com
License: MIT
Location: /var/ossec/framework/python/lib/python3.10/site-packages
Requires: greenlet, typing-extensions
Required-by:

`aarch64`

[root@5b6b5de5bbb0 wazuh]# uname -m
aarch64
[root@5b6b5de5bbb0 wazuh]# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (AltArch)

Wazuh installation and SQLAlchemy version

[root@5b6b5de5bbb0 wazuh]# ./install.sh
...
Done building server

Wait for success...
success
Removing old SCA policies...
Installing SCA policies...
Installing additional SCA policies...
Makefile:2531: warning: overriding recipe for target `win32/ui_resource.o'
Makefile:2471: warning: ignoring old recipe for target `win32/ui_resource.o'
Makefile:2534: warning: overriding recipe for target `win32/auth_resource.o'
Makefile:2474: warning: ignoring old recipe for target `win32/auth_resource.o'
mkdir -p /var/ossec/framework/python
cp external/cpython.tar.gz /var/ossec/framework/python/cpython.tar.gz && tar -xf /var/ossec/framework/python/cpython.tar.gz -C /var/ossec/framework/python && rm -rf /var/ossec/framework/python/cpython.tar.gz
find /var/ossec/framework/python -name "*libpython3.10.so.1.0" -exec ln -f {} /var/ossec/lib/libpython3.10.so.1.0 \;
cd ../framework && /var/ossec/framework/python/bin/python3 -m pip install . --use-pep517 --prefix=/var/ossec/framework/python && rm -rf build/
Processing /wazuh/framework
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: wazuh
  Building wheel for wazuh (pyproject.toml) ... done
  Created wheel for wazuh: filename=wazuh-4.9.0-py3-none-any.whl size=295753 sha256=0bef8c30cc1b85b3d1b98ab28996e32d1d4adc65bb74ef34b438d77ea3076056
  Stored in directory: /tmp/pip-ephem-wheel-cache-h1d2l85k/wheels/fe/47/7c/2c289aea2e8a5cc5ac8936e5cecbbfc0bdd996d57bb70da19a
Successfully built wazuh
Installing collected packages: wazuh
Successfully installed wazuh-4.9.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

[notice] A new release of pip is available: 23.0.1 -> 23.3.1
[notice] To update, run: /var/ossec/framework/python/bin/python3 -m pip install --upgrade pip
chown -R root:wazuh /var/ossec/framework/python
chmod -R o=- /var/ossec/framework/python
cd ../api && /var/ossec/framework/python/bin/python3 -m pip install . --use-pep517 --prefix=/var/ossec/framework/python && rm -rf build/
Processing /wazuh/api
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: api
  Building wheel for api (pyproject.toml) ... done
  Created wheel for api: filename=api-4.9.0-py3-none-any.whl size=159569 sha256=eb5c0b8bda57b7520835c596e481e5eecee4182b1c0351e42c88f293ca90ee0d
  Stored in directory: /tmp/pip-ephem-wheel-cache-ke6p4vve/wheels/2c/ed/d5/5358cdcfa6f68fc41b8ca02118521c75da82e9ec6d16f50822
Successfully built api
Installing collected packages: api
Successfully installed api-4.9.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

[notice] A new release of pip is available: 23.0.1 -> 23.3.1
[notice] To update, run: /var/ossec/framework/python/bin/python3 -m pip install --upgrade pip
cd ../tools/mitre && /var/ossec/framework/python/bin/python3 mitredb.py -d /var/ossec/var/db/mitre.db
/usr/bin/chcon: can't apply partial context to unlabeled file '/var/ossec/lib/libjemalloc.so.2'
Generating self-signed certificate for wazuh-authd...


 - System is Redhat Linux.
 - Init script modified to start Wazuh during boot.
Starting Wazuh...
server
Starting Wazuh v4.9.0...
/var/ossec/api/scripts/wazuh-apid.py:305: DeprecationWarning: ssl.PROTOCOL_TLSv1_2 is deprecated
  ssl_context = ssl.SSLContext(protocol=ssl_protocol)
Started wazuh-apid...
Started wazuh-csyslogd...
Started wazuh-dbd...
2023/12/04 16:49:06 wazuh-integratord: INFO: Remote integrations not configured. Clean exit.
Started wazuh-integratord...
Started wazuh-agentlessd...
Started wazuh-authd...
Started wazuh-db...
Started wazuh-execd...
Started wazuh-analysisd...
Started wazuh-syscheckd...
Started wazuh-remoted...
Started wazuh-logcollector...
Started wazuh-monitord...
Started wazuh-modulesd...
Completed.

 - Configuration finished properly.

 - To start Wazuh:
      /var/ossec/bin/wazuh-control start

 - To stop Wazuh:
      /var/ossec/bin/wazuh-control stop

 - The configuration can be viewed or modified at /var/ossec/etc/ossec.conf


   Thanks for using Wazuh.
   Please don't hesitate to contact us if you need help or find
   any bugs.

   Use our public Mailing List at:
          https://groups.google.com/forum/#!forum/wazuh

   More information can be found at:
          - http://www.wazuh.com

    ---  Press ENTER to finish (maybe more information below). ---

 - In order to connect agent and server, you need to add each agent to the server.

   More information at: 
   https://documentation.wazuh.com/

[root@5b6b5de5bbb0 wazuh]# /var/ossec/framework/python/bin/pip3 show sqlalchemy
Name: SQLAlchemy
Version: 2.0.23
Summary: Database Abstraction Library
Home-page: https://www.sqlalchemy.org
Author: Mike Bayer
Author-email: mike_mp@zzzcomputing.com
License: MIT
Location: /var/ossec/framework/python/lib/python3.10/site-packages
Requires: greenlet, typing-extensions
Required-by:

Next Steps

The update showed that no modification is needed in files that make use of the SQLAlchemy dependency. Currently, there is an update of the urllib3 dependency being carried out in #20001 that will point to the release 4.8.1. The present issue is put On Hold until the latest changes related to the embedded interpreter dependencies are brought up to the master branch.

fdalmaup · 2023-12-11T20:37:11Z

API Integration Tests

Test report

AITs.zip

Test results

Test name	Pass	Fail	Issues Ref.	Status
test_active_response_endpoints.tavern.yaml	2	0		🟢
test_agent_DELETE_endpoints.tavern.yaml	6	0		🟢
test_agent_GET_endpoints.tavern.yaml	96	0		🟢
test_agent_POST_endpoints.tavern.yaml	6	0		🟢
test_agent_PUT_endpoints.tavern.yaml	10	0		🟢
test_cdb_list_endpoints.tavern.yaml	5	0		🟢
test_cluster_endpoints.tavern.yaml	49	0		🟢
test_decoder_endpoints.tavern.yaml	25	0		🟢
test_default_endpoints.tavern.yaml	1	0		🟢
test_experimental_endpoints.tavern.yaml	12	0		🟢
test_logtest_endpoints.tavern.yaml	2	0		🟢
test_manager_endpoints.tavern.yaml	32	0		🟢
test_mitre_endpoints.tavern.yaml	7	0		🟢
test_overview_endpoints.tavern.yaml	1	0		🟢
test_rbac_black_active_response_endpoints.tavern.yaml	2	0		🟢
test_rbac_black_agent_endpoints.tavern.yaml	42	0		🟢
test_rbac_black_cdb_list_endpoints.tavern.yaml	5	0		🟢
test_rbac_black_cluster_endpoints.tavern.yaml	19	0		🟢
test_rbac_black_decoder_endpoints.tavern.yaml	6	0		🟢
test_rbac_black_experimental_endpoints.tavern.yaml	12	0		🟢
test_rbac_black_logtest_endpoints.tavern.yaml	2	0		🟢
test_rbac_black_manager_endpoints.tavern.yaml	16	0		🟢
test_rbac_black_mitre_endpoints.tavern.yaml	7	0		🟢
test_rbac_black_overview_endpoints.tavern.yaml	1	0		🟢
test_rbac_black_rootcheck_endpoints.tavern.yaml	4	0		🟢
test_rbac_black_rule_endpoints.tavern.yaml	8	0		🟢
test_rbac_black_sca_endpoints.tavern.yaml	2	0		🟢
test_rbac_black_security_endpoints.tavern.yaml	25	0		🟢
test_rbac_black_syscheck_endpoints.tavern.yaml	4	0		🟢
test_rbac_black_syscollector_endpoints.tavern.yaml	9	0		🟢
test_rbac_black_task_endpoints.tavern.yaml	1	0		🟢
test_rbac_black_vulnerability_endpoints.tavern.yaml	4	0		🟢
test_rbac_black_webhook_endpoints.tavern.yaml	1	0		🟢
test_rbac_white_active_response_endpoints.tavern.yaml	2	0		🟢
test_rbac_white_agent_endpoints.tavern.yaml	42	0		🟢
test_rbac_white_all_endpoints.tavern.yaml	167	0		🟢
test_rbac_white_cdb_list_endpoints.tavern.yaml	5	0		🟢
test_rbac_white_cluster_endpoints.tavern.yaml	19	0		🟢
test_rbac_white_decoder_endpoints.tavern.yaml	6	0		🟢
test_rbac_white_experimental_endpoints.tavern.yaml	12	0		🟢
test_rbac_white_logtest_endpoints.tavern.yaml	2	0		🟢
test_rbac_white_manager_endpoints.tavern.yaml	16	0		🟢
test_rbac_white_mitre_endpoints.tavern.yaml	7	0		🟢
test_rbac_white_overview_endpoints.tavern.yaml	1	0		🟢
test_rbac_white_rootcheck_endpoints.tavern.yaml	4	0		🟢
test_rbac_white_rule_endpoints.tavern.yaml	8	0		🟢
test_rbac_white_sca_endpoints.tavern.yaml	2	0		🟢
test_rbac_white_security_endpoints.tavern.yaml	25	0		🟢
test_rbac_white_syscheck_endpoints.tavern.yaml	4	0		🟢
test_rbac_white_syscollector_endpoints.tavern.yaml	9	0		🟢
test_rbac_white_task_endpoints.tavern.yaml	1	0		🟢
test_rbac_white_vulnerability_endpoints.tavern.yaml	4	0		🟢
test_rbac_white_webhook_endpoints.tavern.yaml	1	0		🟢
test_rootcheck_endpoints.tavern.yaml	4	0		🟢
test_rule_endpoints.tavern.yaml	15	0		🟢
test_sca_endpoints.tavern.yaml	45	0		🟢
test_security_DELETE_endpoints.tavern.yaml	15	0		🟢
test_security_GET_endpoints.tavern.yaml	11	0		🟢
test_security_POST_endpoints.tavern.yaml	8	0		🟢
test_security_PUT_endpoints.tavern.yaml	9	0		🟢
test_syscheck_endpoints.tavern.yaml	34	0		🟢
test_syscollector_endpoints.tavern.yaml	159	0		🟢
test_task_endpoints.tavern.yaml	2	0		🟢
test_vulnerability_endpoints.tavern.yaml	3	1	#20116	🔴
test_webhook_endpoints.tavern.yaml	5	0		🟢

GGP1 added type/bug Something isn't working level/task labels Nov 27, 2023

GGP1 mentioned this issue Nov 27, 2023

Fix warning in wazuh/rbac/tests/test_orm.py::test_get_all_roles_from_user unit test #20260

Closed

4 tasks

fdalmaup self-assigned this Dec 4, 2023

fdalmaup mentioned this issue Dec 12, 2023

Update SQLAlchemy to 2.0.23 #20741

Merged

fdalmaup linked a pull request Dec 12, 2023 that will close this issue

Update SQLAlchemy to 2.0.23 #20741

Merged

fdalmaup mentioned this issue Dec 12, 2023

Update SQLAlchemy and urllib3 versions in Azure docs wazuh/wazuh-documentation#6842

Merged

7 tasks

fdalmaup linked a pull request Dec 12, 2023 that will close this issue

Update SQLAlchemy and urllib3 versions in Azure docs wazuh/wazuh-documentation#6842

Merged

7 tasks

Selutario closed this as completed Dec 13, 2023

EduLeon12 mentioned this issue Dec 13, 2023

Release 4.8.0 - Alpha 1 - External Integration Modules #20722

Closed

2 tasks

mhamra mentioned this issue Jan 12, 2024

Release 4.8.0 - Alpha 2 - External Integration Modules #21416

Closed

2 tasks

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Upgrade SQLAlchemy to >= 2.0.22 #20443

Upgrade SQLAlchemy to >= 2.0.22 #20443

GGP1 commented Nov 27, 2023 •

edited by fdalmaup

Loading

fdalmaup commented Dec 4, 2023

fdalmaup commented Dec 4, 2023 •

edited

Loading

fdalmaup commented Dec 11, 2023

Upgrade SQLAlchemy to >= 2.0.22 #20443

Upgrade SQLAlchemy to >= 2.0.22 #20443

Comments

GGP1 commented Nov 27, 2023 • edited by fdalmaup Loading

Description

Checks

fdalmaup commented Dec 4, 2023

Issue Update

UTs Execution

fdalmaup commented Dec 4, 2023 • edited Loading

Wazuh embedded Python interpreter

amd64

aarch64

Next Steps

fdalmaup commented Dec 11, 2023

API Integration Tests

Test report

Test results

GGP1 commented Nov 27, 2023 •

edited by fdalmaup

Loading

fdalmaup commented Dec 4, 2023 •

edited

Loading

`amd64`

`aarch64`