Description
Contact Details
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