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. Nextcloud
  3. Accessing Nextcloud database

Accessing Nextcloud database

Scheduled Pinned Locked Moved Solved Nextcloud
6 Posts 3 Posters 1.9k Views 3 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.
  • andreasduerenA Offline
    andreasduerenA Offline
    andreasdueren
    wrote on last edited by
    #1

    One of the people on a nextcloud instance has a problem where the emails wont show in the dashboard. I found this fix here that I wanted to try but I need access to the Database.

    Does anyone have any idea how I can access the phpmyadmin?

    1 Reply Last reply
    0
    • luckowL Offline
      luckowL Offline
      luckow
      translator
      wrote on last edited by luckow
      #2

      imho there is no phpmyadmin included in the package. As a workaround, install a LAMP app and wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
      In your nextcloud app, call the terminal and copy the postgres credentials into the adminer via env. Voila: You see the nextcloud Postgres database in the LAMP app adminer interface.
      The nerdish approach is to open the terminal inside your nc Cloudron app and click on postgres 🙂 83452fa3-8226-4f5a-8c6b-4eef744b75bf-image.png

      Pronouns: he/him | Primary language: German

      andreasduerenA 2 Replies Last reply
      3
      • girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #3

        Given the fix to try is a simple one, you can click on the PostgreSQL button as @luckow suggested and then press Enter. Then, just put in DELETE FORM oc_mail_accounts WHERE id=1 there.

        andreasduerenA 1 Reply Last reply
        1
        • girishG girish

          Given the fix to try is a simple one, you can click on the PostgreSQL button as @luckow suggested and then press Enter. Then, just put in DELETE FORM oc_mail_accounts WHERE id=1 there.

          andreasduerenA Offline
          andreasduerenA Offline
          andreasdueren
          wrote on last edited by
          #4

          @girish The problem is I don't know which ID this one is and wanted to take a look at the database first

          1 Reply Last reply
          0
          • luckowL luckow

            imho there is no phpmyadmin included in the package. As a workaround, install a LAMP app and wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
            In your nextcloud app, call the terminal and copy the postgres credentials into the adminer via env. Voila: You see the nextcloud Postgres database in the LAMP app adminer interface.
            The nerdish approach is to open the terminal inside your nc Cloudron app and click on postgres 🙂 83452fa3-8226-4f5a-8c6b-4eef744b75bf-image.png

            andreasduerenA Offline
            andreasduerenA Offline
            andreasdueren
            wrote on last edited by
            #5

            @luckow said in Accessing Nextcloud database:

            imho there is no phpmyadmin included in the package. As a workaround, install a LAMP app and wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
            In your nextcloud app, call the terminal and copy the postgres credentials into the adminer via env. Voila: You see the nextcloud Postgres database in the LAMP app adminer interface.
            The nerdish approach is to open the terminal inside your nc Cloudron app and click on postgres 🙂 83452fa3-8226-4f5a-8c6b-4eef744b75bf-image.png

            Thanks I'll try this approach

            1 Reply Last reply
            0
            • luckowL luckow

              imho there is no phpmyadmin included in the package. As a workaround, install a LAMP app and wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
              In your nextcloud app, call the terminal and copy the postgres credentials into the adminer via env. Voila: You see the nextcloud Postgres database in the LAMP app adminer interface.
              The nerdish approach is to open the terminal inside your nc Cloudron app and click on postgres 🙂 83452fa3-8226-4f5a-8c6b-4eef744b75bf-image.png

              andreasduerenA Offline
              andreasduerenA Offline
              andreasdueren
              wrote on last edited by
              #6

              @luckow This was a great hack to find out the ID I needed. Deleting it fixed it, thank you!

              1 Reply Last reply
              2
              • BrutalBirdieB BrutalBirdie referenced this topic on
              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