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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
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

Cloudron Forum

Apps | Demo | Docs | Install

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 591 Views
    • 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
  • M Offline
    M Offline
    msbt App Dev
    replied to jordanurbs 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
  • jordanurbsJ Offline
    jordanurbsJ Offline
    jordanurbs
    replied to msbt 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
  • girishG Offline
    girishG Offline
    girish Staff
    replied to jordanurbs 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
  • M Offline
    M Offline
    msbt App Dev
    replied to girish on last edited by
    #5

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

    1 Reply Last reply
    0
  • BrutalBirdieB Online
    BrutalBirdieB Online
    BrutalBirdie Staff
    replied to girish 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 drink. Cheers!

    1 Reply Last reply
    2
  • jordanurbsJ Offline
    jordanurbsJ Offline
    jordanurbs
    replied to girish 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
  • fbartelsF Offline
    fbartelsF Offline
    fbartels App Dev
    replied to jordanurbs 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
  • girishG Offline
    girishG Offline
    girish Staff
    replied to martinkbs 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
  • martinkbsM Offline
    martinkbsM Offline
    martinkbs
    replied to girish 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
  • girishG Offline
    girishG Offline
    girish Staff
    replied to martinkbs 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

  • Login

  • Don't have an account? Register

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

  • Don't have an account? Register

  • Login or register to search.