8000 🐛 Bug Report: Unable to connect to Remote Database · Issue #4643 · appwrite/appwrite · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

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

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
2 tasks done
kennethmakjw opened this issue Nov 6, 2022 · 2 comments
Closed
2 tasks done

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

kennethmakjw opened this issue Nov 6, 2022 · 2 comments
Assignees
@stnguyen90
Labels
bug Something isn't working product / databases Fixes and upgrades for the Appwrite Database.

Comments

@kennethmakjw
Copy link

👟 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?
@kennethmakjw kennethmakjw added the bug Something isn't working label Nov 6, 2022
@stnguyen90
Copy link
Contributor

@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).

@kennethmakjw
Copy link
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.

@stnguyen90 stnguyen90 self-assigned this Nov 6, 2022
@stnguyen90 stnguyen90 added the product / databases Fixes and upgrades for the Appwrite Database. label Nov 6, 2022
@appwrite appwrite locked and limited conversation to collaborators Nov 6, 2022
@stnguyen90 stnguyen90 converted this issue into discussion #4644 Nov 6, 2022

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Assignees

@stnguyen90 stnguyen90

Labels
bug Something isn't working product / databases Fixes and upgrades for the Appwrite Database.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@stnguyen90 @kennethmakjw
0