Want to Connect to an existing MS-SQL

[DualOSWinWiz]

Hi @girish how you are doing, I finally need your help i installed Directus and trying to connect it to existing database hosted out of Coudron but within intranet

i tried to put the bellow setting in env.sh restarted the App and it was giving error on first line of below code. i tried to add same in .initialized but no effect. any idea how could I connect it?

DB_CLIENT=mssql
DB_HOST=your-mssql-host
DB_PORT=1433
DB_DATABASE=your-database-name
DB_USER=your-username
DB_PASSWORD=your-password
DB_SSL=false

[joseph]

Cloudron doesn't support having app's database outside of Cloudron. It will break much functionality like backup/restore/import etc. I think if you want the db outside of Cloudron, you have to host Directus outside Cloudron as well.

[andreasdueren]

I'm interested in conecting to an existing mysql database inside of cloudron. Is this feasable?

[joseph]

@andreasdueren do you mean https://docs.cloudron.io/guides/connect-mysql/ ? But in general, you can always grab the env variables (env | grep MYSQL_ ) in one app and use it in another .

[andreasdueren]

@joseph Yes I know how to get the credentials but I'm curious if anyone has any experience connecting directus with a different database. My quick tests failed so far unfortunately.

[robi]

@andreasdueren Have you tried it in recovery mode?

[EvanCole]

Use the connection string with your MS-SQL server details to connect to the existing database.