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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    LAMP 7.3 multidb app package - Multi-user?

    App Packaging & Development
    4
    13
    314
    Loading More Posts
    • 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.
    • murgero
      murgero App Dev last edited by

      Does the LAMP 7.3 multidb app package allow multiple mysql users to be used?

      --
      https://urgero.org
      ~ Professional Nerd. Freelance Programmer. ~
      Matrix: @murgero:urgero.org

      1 Reply Last reply Reply Quote 0
      • robi
        robi last edited by

        As in a different user per different db, or same db?

        Life of Advanced Technology

        murgero 1 Reply Last reply Reply Quote 0
        • murgero
          murgero App Dev @robi last edited by

          @robi Different user per db

          --
          https://urgero.org
          ~ Professional Nerd. Freelance Programmer. ~
          Matrix: @murgero:urgero.org

          robi 1 Reply Last reply Reply Quote 0
          • robi
            robi @murgero last edited by

            @murgero I know you know the db is multiuser, so the context here is unclear. Perhaps in how Cloudron would manage it, but it's not managed by Cloudron, so maybe you can elaborate your use case a bit 😜

            Life of Advanced Technology

            murgero 1 Reply Last reply Reply Quote 0
            • murgero
              murgero App Dev @robi last edited by

              @robi of course mysql is multi-user, but each app only gets one set of credentials. I am asking if it's possible this specific app may have the ability otherwise?

              --
              https://urgero.org
              ~ Professional Nerd. Freelance Programmer. ~
              Matrix: @murgero:urgero.org

              1 Reply Last reply Reply Quote 0
              • robi
                robi last edited by

                those credentials are for the Cloudron managed databases no?
                For additional DBs in the package, one would manage those manually in the app config, no?

                Life of Advanced Technology

                murgero 1 Reply Last reply Reply Quote 0
                • murgero
                  murgero App Dev @robi last edited by

                  @robi Yes, the creds in credentials.txt are for the cloudron managed sql server, specifically for the apps database. I need multi-database and the ability to have multiple credentials.

                  --
                  https://urgero.org
                  ~ Professional Nerd. Freelance Programmer. ~
                  Matrix: @murgero:urgero.org

                  1 Reply Last reply Reply Quote 0
                  • robi
                    robi last edited by

                    Then you make another custom_credentials.txt for unmanaged DBs.

                    Otherwise Cloudron will overwrite any changes when rebuilding/repairing the app.

                    Life of Advanced Technology

                    murgero 1 Reply Last reply Reply Quote 0
                    • murgero
                      murgero App Dev @robi last edited by

                      @robi I am not 100% sure that just creating a new file like that will work - but I'll figure something out.

                      --
                      https://urgero.org
                      ~ Professional Nerd. Freelance Programmer. ~
                      Matrix: @murgero:urgero.org

                      1 Reply Last reply Reply Quote 0
                      • girish
                        girish Staff last edited by girish

                        @murgero there is a flag to mysql addon called multipleDatabases. When set to true, you can create as many dbs as you want the prefix. See the phabricator app for an example.

                        murgero 1 Reply Last reply Reply Quote 0
                        • murgero
                          murgero App Dev @girish last edited by

                          @girish Yeah - I have that in the manifest - creating multiple DBs is not a problem I imagine here.

                          My question is, can I have each DB have a unique user and password for access?

                          --
                          https://urgero.org
                          ~ Professional Nerd. Freelance Programmer. ~
                          Matrix: @murgero:urgero.org

                          girish 1 Reply Last reply Reply Quote 0
                          • girish
                            girish Staff @murgero last edited by

                            @murgero There is only a single user/password. Can I ask why an app needs multiple users?

                            A 1 Reply Last reply Reply Quote 0
                            • A
                              andirahmat @girish last edited by

                              @girish I also think about this. The use case is. I need the first db and dbuser for the web app. And the second db and dbuser for view tables from the first db. This second db and db user is used for metabase report so the original db and table structure not shown for the metabase user.

                              Another case i can think of is to make a slave db on the lamp app from external db.

                              1 Reply Last reply Reply Quote 1
                              • First post
                                Last post
                              Powered by NodeBB