[ENH]: Test SecureChat Application with MySQL and Fix Compatibility Issues

[pravin-bansod]

Contact Details

[email protected]

Feature Description

The SecureChat application supports RDS databases but has only been tested with SQLite. We need to:

• Test the application with MySQL.
• Identify and resolve any compatibility issues.

Quick attempt results below errors on startup -
root@24c1a05ee031:/# paig_securechat run --port 2535 --host 0.0.0.0 INFO [alembic.runtime.migration] Context impl MySQLImpl. INFO [alembic.runtime.migration] Will assume non-transactional DDL. INFO [alembic.runtime.migration] Context impl MySQLImpl. INFO [alembic.runtime.migration] Will assume non-transactional DDL. INFO [alembic.runtime.migration] Running upgrade -> 3f8e6786bde9, Initial migration An error occurred during tables creation on database: (in table 'conversations', column 'client_app_id'): VARCHAR requires a length on dialect mysql An error occurred during tables creation on database: (in table 'conversations', column 'client_app_id'): VARCHAR requires a length on dialect mysql

Tasks:

• Set up a MySQL database for testing.
• Update configuration as needed for MySQL.
• Run tests and identify compatibility issues.
• Fix identified issues to ensure MySQL compatibility.
• Document the steps for using MySQL with SecureChat.

Acceptance Criteria:

• Application works seamlessly with MySQL.
• No critical errors or data inconsistencies.
• Documentation updated for MySQL configuration.

Code of Conduct

• I agree to follow this project's Code of Conduct

[amrakshay]

I was able to get the SecureChat up and running with MySQL database, though I have not evaluated through all the use cases. Whoever taking this issue to work on can refer below.

• Patch for the changes - These changes include data type changes, so it should support both SQLite and MySQL
  paig-securechat-mysql-support.patch
• Dependencies - Also you will need to install below libraries as mysql driver for connection

pip install mysql-connector-python
pip install asyncmy