ethanlolomg•3w ago

If I opt in to using self hosted Convex with PostSQL/MySQL database connection, it is possible for m

If I opt in to using self hosted Convex with PostSQL/MySQL database connection, it is possible for me to create a separate microservice write to the Convex database without using Convex. My current usecase has something that is very heavy on the write operation, currently using Clickhouse, we want to use Convex as the client side to read from these real time data, which Convex is already using Websocket between FE and BE which is perfect, but the thing we are concern is if external service can directly write to the self hosted Convex database using SQL mutation, it seems like Convex only has one single table for SQL?

14 Replies

ethanlolomgOP•3w ago

Not sure if it is just related to this thread too: https://github.com/get-convex/convex-backend/blob/main/self-hosted/README.md

GitHub

convex-backend/self-hosted/README.md at main · get-convex/convex-b...

The open-source reactive database for app developers - get-convex/convex-backend

Alienwarez•3w ago

It says in the self hosted read me about auth

bastianwegge•3w ago

Hey @Alienwarez, cool can you point me toward it?

Alienwarez•3w ago

https://github.com/get-convex/convex-backend/blob/main/self-hosted/README.md#convex-auth

GitHub

convex-backend/self-hosted/README.md at main · get-convex/convex-b...

The open-source reactive database for app developers - get-convex/convex-backend

bastianwegge•3w ago

Thank you for following up, where exactly is the „This is how you manage users“ part 😅 ? I have setup convex auth completely with password auth and I‘m looking for a way to manage my users.

Alienwarez•3w ago

Once you follow the manual setup go to custom schema https://labs.convex.dev/auth/setup/schema and define a custom schema for users copy and paste it and add any additional fields you need, then do to the convex dashboard and go to data all the tables are there

Customizing Schema - Convex Auth

Authentication library for your Convex backend

Alienwarez•3w ago

Has anyone had any issues with R2 and convex self hosted using S3 as the storage where if I delete a file from convex it doesnt get deleted on R2 also R2 requires all non-trailing parts to have the same length, if I try to upload a big file on the dashboard of convex it shows this error

INFO convex-cloud-http: [] 10.0.11.4:35506 "OPTIONS /api/storage/upload
INFO file_storage::core: Uploading with content length Some(ContentLength(20782000))
ERROR common::errors: Caught error (RUST_BACKTRACE=1 RUST_LOG=info,common::errors=debug for full trace): service error: unhandled error (InvalidPart): Error { code: "InvalidPart", message: "All non-trailing parts must have the same length." }

INFO convex-cloud-http: [] 10.0.11.4:35506 "OPTIONS /api/storage/upload
INFO file_storage::core: Uploading with content length Some(ContentLength(20782000))
ERROR common::errors: Caught error (RUST_BACKTRACE=1 RUST_LOG=info,common::errors=debug for full trace): service error: unhandled error (InvalidPart): Error { code: "InvalidPart", message: "All non-trailing parts must have the same length." }

Vexoa•3w ago

I'd recommend using the API

bastianwegge•3w ago

With convex self-hosted, I have a problem generating the Upload URLs. Convex is trying to use 127.0.0.1/api as an endpoint, but the server has a valid DNS. How can I set the DNS for the upload endpoint? /e: Okay problem solved, we changed the CONVEX_CLOUD_ORIGIN to be the convex endpoint behind nginx (basically my.url.com/convex).

Sandeep•2w ago

Hello Team. I have self-hosted it in my VPS and setup the .local.env in by convex app like this

CONVEX_SELF_HOSTED_URL='http://xx.xx.xx.123:3210/' 
CONVEX_SELF_HOSTED_ADMIN_KEY='convex-self-hosted|014c9bed0e04df4fa531d2491ef26acc76d4422dd13f004e59ed2fc4bb2dd21d2084f0856b7c1c00461e873c03ab5c3a32'

CONVEX_SELF_HOSTED_URL='http://xx.xx.xx.123:3210/' 
CONVEX_SELF_HOSTED_ADMIN_KEY='convex-self-hosted|014c9bed0e04df4fa531d2491ef26acc76d4422dd13f004e59ed2fc4bb2dd21d2084f0856b7c1c00461e873c03ab5c3a32'

Now when i am running npx convex dev , its pointing me to my logged in account and asks to create/choose project. I am not able to setup my project with selfhosted convex. Please help. What can be wrong?

Sandeep•2w ago

if i run npx convex deploy

Sandeep•2w ago

anyone ??

Analyzing and deploying source code...
✖ Error: Unable to push deployment config to https://convex.domaon.in
✖ Error fetching POST  https://convex.domain.in/api/push_config 400 Bad Request: InvalidAuthConfig: Hit an error while pushing:
The pushed auth config is invalid: auth config file must include a list of provider credentials: must use HTTPS

Analyzing and deploying source code...
✖ Error: Unable to push deployment config to https://convex.domaon.in
✖ Error fetching POST  https://convex.domain.in/api/push_config 400 Bad Request: InvalidAuthConfig: Hit an error while pushing:
The pushed auth config is invalid: auth config file must include a list of provider credentials: must use HTTPS

What can be the issue? help much needed

Manchuwook•2w ago

Hi gang - I've got MCP up on VS Code (mostly) but I'm having a problem using it in tandem with Docker. I'm getting {"error":"Not Authorized: Run npx convex dev to login to your Convex project."} Even though I can get to it because I have my .env.local file configured when I run the TanStack app just fine. VITE_CONVEX_URL=http://xx.xx.xx.123:3210 Need to set that too Also, name it .env.local, not .local.env

Manchuwook•2w ago

If I opt in to using self hosted Convex with PostSQL/MySQL database connection, it is possible for m

Did you find this page helpful?