LAMP 7.3 multidb app package - Multi-user?

[robi]

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

[murgero]

@robi Different user per db

[robi]

@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

[murgero]

@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?

[robi]

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?

[murgero]

@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.

[robi]

Then you make another custom_credentials.txt for unmanaged DBs.

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

[murgero]

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

[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]

@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]

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

[andirahmat]

@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.