AppSheet Connection Error with MySQL on Debian Server (TaskCanceledException and Authentication Issu

[JuanCruzCookdat]

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

1. Verified server resources (RAM, CPU) are not the issue
2. Confirmed database credentials are correct (working in MySQL Workbench)
3. Checked database user permissions
4. Verified network connectivity
5. Investigated MySQL authentication methods

Questions

1. Is this a known issue with AppSheet connecting to self-hosted MySQL databases?
2. Are there specific configuration requirements for AppSheet-MySQL connections that we might be missing?
3. Could this be related to authentication methods or connection timeouts?
4. 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

[Steve]

Please contact AppSheet Support for help with this.

[JuanCruzCookdat]

Will do that, thanks Steve