🐛 Bug Report: Unable to connect to Remote Database #4644

kennethmakjw · 2022-11-06T18:48:09Z

kennethmakjw
Nov 6, 2022

👟 Reproduction steps

I am trying to connect my remote DB from DigitalOcean Managed Database and I'm not able to connect to it because Appwrite failed to established a connection.

👍 Expected behavior

It should connect to the database and Appwrite should operate normally.

👎 Actual Behavior

Appwrite did not work, it failed to connect, the logs shows:

Fatal error: Uncaught Exception: Failed to connect to database: SQLSTATE[HY000] [1105] unknown error: Code: UNAVAILABLE
server does not allow insecure connections, client must use SSL/TLS
 in /usr/src/code/app/http.php:77
Stack trace:
#0 {main}
  thrown in /usr/src/code/app/http.php on line 77
[2022-11-06 18:42:13 #1.2]      ERROR   php_swoole_server_rshutdown() (ERRNO 503): Fatal error: Uncaught Exception: Failed to connect to database: SQLSTATE[HY000] [1105] unknown error: Code: UNAVAILABLE
server does not allow insecure connections, client must use SSL/TLS
 in /usr/src/code/app/http.php:77
Stack trace:
#0 {main}
  thrown in /usr/src/code/app/http.php on line 77
Database not ready. Retrying connection (10)...

🎲 Appwrite version

Version 1.0.x

💻 Operating system

Linux

🧱 Your Environment

I am trying to use a remote database, I have modified the .env and ran docker compose up -d

👀 Have you spent some time to check if this issue has been raised before?

I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

I have read the Code of Conduct

stnguyen90 · 2022-11-06T19:06:51Z

stnguyen90
Nov 6, 2022
Maintainer

@kennethmakjw is digital ocean's managed database MySQL? If so, that may be the problem. Appwrite uses mariadb and since Mariadb and MySQL are slightly different it won't work. Would you be able to use a mariadb database? Otherwise, you may need to tweak some of the Appwrite code (we can advise on that if needed).

1 reply

stnguyen90 Nov 7, 2022
Maintainer

In short, you need to modify the code before Appwrite starts in all containers. There are ~7 places in the code with this line:

appwrite/app/init.php

Line 55 in 44ca7d9

use Utopia\Database\Adapter\MariaDB;

That needs to be replaced with:

use Utopia\Database\Adapter\MySQL as MariaDB;

I think that should be it, but I didn't get a chance to fully test it.

kennethmakjw · 2022-11-06T19:10:42Z

kennethmakjw
Nov 6, 2022
Author

@kennethmakjw is digital ocean's managed database MySQL? If so, that may be the problem. Appwrite uses mariadb and since Mariadb and MySQL are slightly different it won't work. Would you be able to use a mariadb database? Otherwise, you may need to tweak some of the Appwrite code (we can advise on that if needed).

Yes, it is indeed a MySQL server.

Could you share the steps to tweak the code?

Thanks in advance.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

🐛 Bug Report: Unable to connect to Remote Database #4644

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 2 comments 1 reply

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

🐛 Bug Report: Unable to connect to Remote Database #4644

Uh oh!

Uh oh!

kennethmakjw Nov 6, 2022

👟 Reproduction steps

👍 Expected behavior

👎 Actual Behavior

🎲 Appwrite version

💻 Operating system

🧱 Your Environment

👀 Have you spent some time to check if this issue has been raised before?

🏢 Have you read the Code of Conduct?

Replies: 2 comments · 1 reply

Uh oh!

stnguyen90 Nov 6, 2022 Maintainer

Uh oh!

stnguyen90 Nov 7, 2022 Maintainer

Uh oh!

kennethmakjw Nov 6, 2022 Author

kennethmakjw
Nov 6, 2022

Replies: 2 comments 1 reply

stnguyen90
Nov 6, 2022
Maintainer

stnguyen90 Nov 7, 2022
Maintainer

kennethmakjw
Nov 6, 2022
Author