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


Navigation

    Cloudron Forum

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

    LAMP 7.3 multidb app package - Multi-user?

    App Packaging & Development
    4
    13
    41
    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.
    • M
      murgero App Dev last edited by

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

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

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

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

          @robi Different user per db

          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 😜

            M 1 Reply Last reply Reply Quote 0
            • M
              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?

              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?

                M 1 Reply Last reply Reply Quote 0
                • M
                  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.

                  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.

                    M 1 Reply Last reply Reply Quote 0
                    • M
                      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.

                      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.

                        M 1 Reply Last reply Reply Quote 0
                        • M
                          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?

                          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