Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Directus
  3. Want to Connect to an existing MS-SQL

Want to Connect to an existing MS-SQL

Scheduled Pinned Locked Moved Directus
7 Posts 5 Posters 329 Views 5 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D Offline
    D Offline
    DualOSWinWiz
    wrote on last edited by james
    #1

    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
    
    1 Reply Last reply
    0
    • J Online
      J Online
      joseph
      Staff
      wrote on last edited by
      #2

      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.

      1 Reply Last reply
      0
      • andreasduerenA Offline
        andreasduerenA Offline
        andreasdueren
        wrote last edited by
        #3

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

        1 Reply Last reply
        0
        • J Online
          J Online
          joseph
          Staff
          wrote last edited by
          #4

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

          andreasduerenA 1 Reply Last reply
          2
          • J 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 .

            andreasduerenA Offline
            andreasduerenA Offline
            andreasdueren
            wrote last edited by
            #5

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

            robiR 1 Reply Last reply
            0
            • andreasduerenA 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.

              robiR Offline
              robiR Offline
              robi
              wrote last edited by
              #6

              @andreasdueren Have you tried it in recovery mode?

              Conscious tech

              1 Reply Last reply
              0
              • E Offline
                E Offline
                EvanCole
                wrote last edited by
                #7

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

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • Bookmarks
                • Search