AppSheet MySQL Connection Issues on Debian Server
Hi,
We’re experiencing connection issues between AppSheet and our MySQL database hosted on a Debian server (jotelulu). None of our apps can connect to any database, regardless of the user credentials used.
Error Messages
We’re encountering two different errors:
1. Task Cancellation Error:
System.Threading.Tasks.TaskCanceledException: A task was canceled.at ServerHandler.SyncRequestHandler.ReadTablesWithParallelForEach(IPerfCollector perfCollector, Context context, IReadOnlyDictionary`2 perTableParamsFromClient, String appTemplateName, AppTemplate appTemplate, DataFormat desiredFormat, IList`1 appTables, AppErrors appErrors, ConcurrentDictionary`2 tableDataOut, CancellationToken cancellationToken) in /src/ControllerHandler/ServerHandler/SyncRequestHandler.cs:line 837[...]
2. Authentication Method Error:
Error: Data table 'TM_AccountingSubaccount' is not accessible due to: Authentication method 'caching_sha2_password' failed. Either use a secure connection, specify the server's RSA public key with ServerRSAPublicKeyFile, or set AllowPublicKeyRetrieval=True.
Environment Details
- Server OS: Debian
- Database: MySQL
- Host: Self-hosted server (jotelulu)
- Connection Type: Direct connection from AppSheet to MySQL
Important Notes
- We can successfully connect and view all data through MySQL Workbench
- The issue affects all apps and all database users
- We didn’t change anything of ssl or something like that in the past few days
- The authentication error suggests possible MySQL 8.0 authentication method incompatibility
What We’ve Tried
- Verified server resources (RAM, CPU) are not the issue
- Confirmed database credentials are correct (working in MySQL Workbench)
- Checked database user permissions
- Verified network connectivity
- Investigated MySQL authentication methods
Questions
- Is this a known issue with AppSheet connecting to self-hosted MySQL databases?
- Are there specific configuration requirements for AppSheet-MySQL connections that we might be missing?
- Could this be related to authentication methods or connection timeouts?
- Is there a recommended way to handle the ‘caching_sha2_password’ authentication method when connecting from AppSheet?
Additional Context
We’re seeing these errors consistently across all attempts to access our apps, suggesting it might be a configuration or authentication issue rather than a resource or connectivity problem. The authentication error specifically points to MySQL’s security configuration, but we’re unsure of the best way to resolve this.
Thanks for your time