[Suggestion] Server-Wide Database Manager and File Browser
-
wrote on Jul 21, 2020, 4:17 PM last edited by marcusquinn Jul 21, 2020, 4:39 PM
@girish And very nice work too!
Just in case you didn't note, Adminer I've tried before in WP stacks and it's covered all I could imagine needing for DB Admin and seems designed for this kind of embedded use. Not sure what other options there are in this space but it might save you re-inventing.
-
wrote on Sep 26, 2020, 7:34 PM last edited by
I edit my WP databases with PHPMyAdmin a lot. I wonder if I can add it to those apps...unless Remote SQL is a feature on Cloudron (then I'll just locally run Sequel Pro).
-
I edit my WP databases with PHPMyAdmin a lot. I wonder if I can add it to those apps...unless Remote SQL is a feature on Cloudron (then I'll just locally run Sequel Pro).
wrote on Sep 26, 2020, 8:22 PM last edited by@Lonk Add
/phpmyadmin/to the URL and PhPMyAdmin should be there: -
wrote on Sep 26, 2020, 9:37 PM last edited by
Your link says in it's first sentence: "Cloudron does not support PHPMyAdmin" - but I'll try it out.
️ -
@Lonk Add
/phpmyadmin/to the URL and PhPMyAdmin should be there:wrote on Sep 26, 2020, 9:38 PM last edited by@marcusquinn I tried it and it didn't work. I'll just see if I can get Sequel Pro working via Remote SQL.
️ -
@marcusquinn I tried it and it didn't work. I'll just see if I can get Sequel Pro working via Remote SQL.
️wrote on Sep 26, 2020, 9:53 PM last edited by@Lonk Ahh, maybe it was just the LAMP app and I'm thinking of FTP for Wordpress. Sometimes things change before Docs updates though.
-
@Lonk Ahh, maybe it was just the LAMP app and I'm thinking of FTP for Wordpress. Sometimes things change before Docs updates though.
wrote on Sep 26, 2020, 10:16 PM last edited by@marcusquinn Ah, so it is possible to maybe get that working with Wordpress but I'd rather get Remote SQL working instead like you said you managed to do on another post. My attempts haven't worked up till now.
-
@marcusquinn Ah, so it is possible to maybe get that working with Wordpress but I'd rather get Remote SQL working instead like you said you managed to do on another post. My attempts haven't worked up till now.
wrote on Sep 26, 2020, 11:06 PM last edited by@Lonk Old guy memory here, I think I only used phpmyadmin with the LAMP app and was thinking of FTP. Agree though, it'd be handy.
I've recommended https://www.adminer.org before as a handy way to make it part or Cloudron.
-
wrote on Sep 26, 2020, 11:11 PM last edited by
Do you like Adminer better than PHPMyAdmin? Tbh, I don't really love PHPMyAdmin.
-
@gabrielcossette Thanks for the suggestion! We actually investigated this a couple of releases back and it's not simple to add. For the file browser, the UI parts are actually straight forward but the complication is with accessing the docker volumes. Accessing the data inside docker volumes will require the box code to somehow know the container user (to get the right permissions for files) and will also require the box code to run as root. This requires quite some engineering work.
Just giving some background on why this has not been done yet.
wrote on Sep 26, 2020, 11:14 PM last edited by@girish I have a solution to this if we can add a new container type to use for this. It's called sysbox from nestybox. You have an email from me about this.
It allows for running full machine images in sysbox container managed by docker. No root required, but you get root inside + full OS mount options for storage, etc..
Also should look at mayadata.com and OpenEBS which is flexible storage attachment for containers.
Friends of both
-
wrote on Sep 26, 2020, 11:19 PM last edited by
@Lonk I got what I needed done with it as a WP plugin, although it was removed from wordpress.org:
-
@Lonk I got what I needed done with it as a WP plugin, although it was removed from wordpress.org:
wrote on Sep 26, 2020, 11:23 PM last edited by@marcusquinn Thanks, I'll check those out, but I usually like database management to be detached from the Wordpress backend for security reasons.
-
@marcusquinn Thanks, I'll check those out, but I usually like database management to be detached from the Wordpress backend for security reasons.
wrote on Sep 26, 2020, 11:34 PM last edited by marcusquinn Sep 26, 2020, 11:35 PM@Lonk Yeah, of course - but it's a way to get DB access when it's not otherwise available externally. I tend to delete them after use just to be sure.
-
@Lonk @marcusquinn This is part of https://forum.cloudron.io/topic/2760/what-s-coming-in-6-0. The "unify PHPMyAdmin across apps" part. We haven't really investigated what is the best way to implement it.
-
@Lonk @marcusquinn This is part of https://forum.cloudron.io/topic/2760/what-s-coming-in-6-0. The "unify PHPMyAdmin across apps" part. We haven't really investigated what is the best way to implement it.
-
@Lonk @marcusquinn This is part of https://forum.cloudron.io/topic/2760/what-s-coming-in-6-0. The "unify PHPMyAdmin across apps" part. We haven't really investigated what is the best way to implement it.
wrote on Sep 27, 2020, 5:48 PM last edited by Lonkle Sep 27, 2020, 5:49 PM@girish I missed that, thanks for pointing it out for me. You just showed me, today, how to get Sequel Pro working so I don't have any use for PHPMyAdmin anymore. But, I do think having a way into PHPMyAdmin would be useful if an urgent db change needed to be made and I only had my phone (it's happened before).
Does "unify PHPMyAdmin across apps" across apps mean you would log into a single PHPMyAdmin instance and see all applicable subcontainer's tables?
-
wrote on Sep 27, 2020, 6:02 PM last edited by
Oh, wanted to mention - despite PHPMyAdmin being worked on rn; if anyone has an interest in connecting a remote SQL client app (like Sequel Pro) to Cloudron apps on an app-per-app basis. Here are instructions to do so here: https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis
In my experience this is a much better, faster way to work with databases than PHPMyAdmin could ever dream to be.
