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. Moodle
  3. I need to migrate an old Moodle to my new Cloudron Moodle--what are the DB details?

I need to migrate an old Moodle to my new Cloudron Moodle--what are the DB details?

Scheduled Pinned Locked Moved Moodle
12 Posts 6 Posters 2.2k Views 6 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.
  • jordanurbsJ Offline
    jordanurbsJ Offline
    jordanurbs
    wrote on last edited by
    #1

    Here are the details I need in order to migrate:
    Screen Shot 2020-11-23 at 1.47.21 PM.png

    M 1 Reply Last reply
    0
    • jordanurbsJ jordanurbs

      Here are the details I need in order to migrate:
      Screen Shot 2020-11-23 at 1.47.21 PM.png

      M Offline
      M Offline
      msbt
      App Dev
      wrote on last edited by
      #2

      you can jump on a terminal and enter env | grep MYSQL, this will give you the database details.

      jordanurbsJ 1 Reply Last reply
      0
      • M msbt

        you can jump on a terminal and enter env | grep MYSQL, this will give you the database details.

        jordanurbsJ Offline
        jordanurbsJ Offline
        jordanurbs
        wrote on last edited by
        #3

        @msbt said in I need to migrate an old Moodle to my new Cloudron Moodle--what are the DB details?:

        env | grep MYSQL

        Thanks but that doesn't give me anything in the cloudron terminal. Nothing happens

        girishG 1 Reply Last reply
        0
        • jordanurbsJ jordanurbs

          @msbt said in I need to migrate an old Moodle to my new Cloudron Moodle--what are the DB details?:

          env | grep MYSQL

          Thanks but that doesn't give me anything in the cloudron terminal. Nothing happens

          girishG Offline
          girishG Offline
          girish
          Staff
          wrote on last edited by girish
          #4

          @jordanurbs the cloudron package uses postgres. So try env | grep POSTGRESQL

          M BrutalBirdieB jordanurbsJ 3 Replies Last reply
          0
          • girishG girish

            @jordanurbs the cloudron package uses postgres. So try env | grep POSTGRESQL

            M Offline
            M Offline
            msbt
            App Dev
            wrote on last edited by
            #5

            ah my bad, should have omitted the MY from MYSQL 😄

            1 Reply Last reply
            0
            • girishG girish

              @jordanurbs the cloudron package uses postgres. So try env | grep POSTGRESQL

              BrutalBirdieB Offline
              BrutalBirdieB Offline
              BrutalBirdie
              Partner
              wrote on last edited by BrutalBirdie
              #6

              @girish said in I need to migrate an old Moodle to my new Cloudron Moodle--what are the DB details?:

              @jordanurbs the cloudron package uses postgres. So try env | grep POSTGRESQL

              @jordanurbs
              You can find out what addons being used for a cloudron app by checking the repo

              https://git.cloudron.io/cloudron/moodle-app

              and the CloudronManifest.json

              https://git.cloudron.io/cloudron/moodle-app/-/blob/master/CloudronManifest.json

              {
                "id": "org.moodle.cloudronapp",
                "title": "Moodle",
                "author": "Moodle developers",
                "description": "file://DESCRIPTION.md",
                "tagline": "The world's most popular learning management system",
                "version": "1.0.0",
                "healthCheckPath": "/",
                "httpPort": 8000,
                "memoryLimit": 524288000,
                "manifestVersion": 2,
                "website": "https://moodle.org/",
                "contactEmail": "support@cloudron.io",
                "icon": "logo.png",
                "addons": {
                  "postgresql": {},
                  "localstorage": {},
                  "sendmail": {},
                  "ldap": {},
                  "scheduler": {
                    "periodic": {
                        "schedule": "*/1 * * * *",
                        "command": "/usr/bin/php  /app/code/admin/cli/cron.php >/dev/null"
                    }
                  }
                },
                "tags": [ "moodle", "learning", "lms", "canvas", "blackboard", "edutech" ],
                "changelog": "file://CHANGELOG",
                "postInstallMessage": "file://POSTINSTALL.md",
                "mediaLinks": [
                  "https://screenshots.cloudron.io/org.moodle.cloudronapp/1.png",
                  "https://screenshots.cloudron.io/org.moodle.cloudronapp/2.png",
                  "https://screenshots.cloudron.io/org.moodle.cloudronapp/3.jpg"
                ],
                "minBoxVersion": "5.3.0",
                "forumUrl": "https://forum.cloudron.io/category/102/moodle",
                "documentationUrl": "https://docs.cloudron.io/apps/moodle/"
              }
              

              Or when you open the logs you should have a button for Postgres or MySQL
              😄

              Like my work? Consider donating a drink. Cheers!

              1 Reply Last reply
              2
              • girishG girish

                @jordanurbs the cloudron package uses postgres. So try env | grep POSTGRESQL

                jordanurbsJ Offline
                jordanurbsJ Offline
                jordanurbs
                wrote on last edited by
                #7

                @girish said in I need to migrate an old Moodle to my new Cloudron Moodle--what are the DB details?:

                env | grep POSTGRESQL

                Thanks, that gives me the details.

                Now I've got a second issue though: the old Moodle only lets me choose between MariaDB or Improved MySQL. Any thoughts?

                fbartelsF 1 Reply Last reply
                0
                • jordanurbsJ jordanurbs

                  @girish said in I need to migrate an old Moodle to my new Cloudron Moodle--what are the DB details?:

                  env | grep POSTGRESQL

                  Thanks, that gives me the details.

                  Now I've got a second issue though: the old Moodle only lets me choose between MariaDB or Improved MySQL. Any thoughts?

                  fbartelsF Offline
                  fbartelsF Offline
                  fbartels
                  App Dev
                  wrote on last edited by
                  #8

                  @jordanurbs this is probably relevant to you https://docs.moodle.org/310/en/Database_transfer

                  1 Reply Last reply
                  0
                  • martinkbsM Offline
                    martinkbsM Offline
                    martinkbs
                    wrote on last edited by
                    #9

                    The query

                    env | grep POSTGRESQL
                    

                    in the terminal returns the following values:

                    CLOUDRON_POSTGRESQL_URL=postgres://...
                    CLOUDRON_POSTGRESQL_DATABASE=
                    CLOUDRON_POSTGRESQL_PASSWORD=
                    CLOUDRON_POSTGRESQL_USERNAME=
                    CLOUDRON_POSTGRESQL_HOST=postgresql
                    CLOUDRON_POSTGRESQL_PORT=5432
                    

                    But what is the value to be entered in the 'Server' field? The IP of the server? Socket IP? Domain?

                    Captura de pantalla 2021-03-15 a las 18.08.48.png

                    Thanks for the help guys! 🙏

                    girishG 1 Reply Last reply
                    0
                    • martinkbsM martinkbs

                      The query

                      env | grep POSTGRESQL
                      

                      in the terminal returns the following values:

                      CLOUDRON_POSTGRESQL_URL=postgres://...
                      CLOUDRON_POSTGRESQL_DATABASE=
                      CLOUDRON_POSTGRESQL_PASSWORD=
                      CLOUDRON_POSTGRESQL_USERNAME=
                      CLOUDRON_POSTGRESQL_HOST=postgresql
                      CLOUDRON_POSTGRESQL_PORT=5432
                      

                      But what is the value to be entered in the 'Server' field? The IP of the server? Socket IP? Domain?

                      Captura de pantalla 2021-03-15 a las 18.08.48.png

                      Thanks for the help guys! 🙏

                      girishG Offline
                      girishG Offline
                      girish
                      Staff
                      wrote on last edited by girish
                      #10

                      @martinkbs I guess "servidor de la base de datos" means database server ? If so, that is just postgresql (i.e the value of CLOUDRON_POSTGRESQL_HOST). The hostname of the postgres server is posgresql (I know confusing 🙂 ).

                      martinkbsM 1 Reply Last reply
                      0
                      • girishG girish

                        @martinkbs I guess "servidor de la base de datos" means database server ? If so, that is just postgresql (i.e the value of CLOUDRON_POSTGRESQL_HOST). The hostname of the postgres server is posgresql (I know confusing 🙂 ).

                        martinkbsM Offline
                        martinkbsM Offline
                        martinkbs
                        wrote on last edited by
                        #11

                        Thanks @girish. But I have a question. The source Moodle is on a different server than Cloudron's Moodle ... it's a server with a Plesk panel 😞

                        In that case, how can the source installation identify which server to send the data to? Wouldn't it be necessary to indicate the IP of the destination server? Or the socket? If I only indicate postgresql, I don't think the data can be migrated from one server to another ... right?

                        girishG 1 Reply Last reply
                        0
                        • martinkbsM martinkbs

                          Thanks @girish. But I have a question. The source Moodle is on a different server than Cloudron's Moodle ... it's a server with a Plesk panel 😞

                          In that case, how can the source installation identify which server to send the data to? Wouldn't it be necessary to indicate the IP of the destination server? Or the socket? If I only indicate postgresql, I don't think the data can be migrated from one server to another ... right?

                          girishG Offline
                          girishG Offline
                          girish
                          Staff
                          wrote on last edited by
                          #12

                          @martinkbs Ah, I missed it that it's trying to transfer the database. Indeed, postgresql is the internal name. There is no public endpoint. What you have to do is to export the postgresql dump from the old instance and import it into Cloudron by hand. Please see https://docs.cloudron.io/guides/import-postgresql/

                          1 Reply Last reply
                          1
                          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