How can you say it doesn't scale when you have now idea how i'm set up. I had to add 5 users yesterday, took 5-10 (mostly talking to people) minutes. Using a config mgmt system i set up ssh and mysql in the same single call to multiple database servers some users will have multiple logins based on the ability to read and the ability to write, which based on the configured security group. It scales quite well indeed and i don't have to worry about a php application were security risks are more prone to come with each update. Also http-auth takes admin as well. aside from that, i'm done here. We obviously disagree, i'm strictly offering another view point and i happen to have the infrastructure in place to make it quick and simple (both additions and deletions) and why would i let external people access my database, in all the jobs i've had this has never been a requirement, and i'm old, but that doesn't mean it's not a requirement for some. You do what works for you and i'll do the same. Best, Jeff On Wed, Apr 17, 2019 at 2:46 PM Reindl Harald <h.reindl@thelounge.net> wrote:
i yet need to see the difference between SSH tunnels and all the administrative burden versus phpMyAdmin behind http-auth long before it's native login
your stuff don't scale on a setup with external users which for sure don't get ssh-tunnels or much worser vpn access and without external users the whole issue don't exist
I appreciate your points, but i don't give them out to 'every random monkey', that would completely against the setup I've chosen. Showing someone how to ssh-tunnel via putty is not hard, and is only once and can be documented. The people that i give ssh access to are managed centrally via a config mgmt system and they only have access to the bastion host, and are not users on any other host. Also they can only connect to mysql from that host(which really doesn't matter since they can't get to another host). And my point really mainly is for cloud infrastructures; if you're on a corporate network, hopefully the sysadmin has installed a VPN which can be used and then you can VPN to the network and connect like you're local, which you could also do in the cloud.
So IMHO it is much more secure, perhaps the way it's set up here and again it's just my 2 cents. SSH Tunnels to a bastion host that is not allowed to talk to another host will always be more secure than any phpMyAdmin configuration.
Again, i appreciate your point of view, but wanted to qualify some of my answers.
On Wed, Apr 17, 2019 at 1:18 PM Reindl Harald <h.reindl@thelounge.net <mailto:h.reindl@thelounge.net>> wrote:
Am 17.04.19 um 18:55 schrieb Jeff Dyke: > Reindl's (funny) comments aside. Why still use phpMyAdmin in this day > and age. Nearly every maria/percona/mysql client supports ssh > tunneling. SequelPro on Mac, Heidi (or others) on Windows, and any > windows client running through wine if your desktop/laptop is
Am 17.04.19 um 19:30 schrieb Jeff Dyke: linux.
> Also developers can just use intellij or similar IDE's that have a > database pane. > > Trusting administration to an exposed phpMyAdmin in this day and
age
> frightens me greatly. Also if you had an HIDS server running to
track
> bad phpMyAdmin logins i bet there would be a ton of alerts. I've > blocked all such attempts in my IPS even though i don't have phpMyAdmin. > > I realize this does not answer your question, but if this fits into your > architecture i'd say good by to that web interface.
because it's nonsense to believe that you can manage to handle
everybody
which probably needs to access mysql with his restricted account to learn how to use ssh-tunnles
and that you are plain wrong when you believe hand out ssh tunnels
into
your network for every random monkey increases security
not talking about that he is obviously a 3rd party to a customer
where
you have no say in that context
the problem is *exposing* phpMyAdmin for the whole world and asking stupid questions like which version before the latest one instead
just
update it and when you are too dumb building packages for the target
OS
hire some one which is capable to do so or unpack that dmaned folder ph hand
> On Wed, Apr 17, 2019 at 10:54 AM Reindl Harald <h.reindl@thelounge.net <mailto:h.reindl@thelounge.net> > <mailto:h.reindl@thelounge.net <mailto:h.reindl@thelounge.net>>> wrote: > > > > Am 17.04.19 um 16:50 schrieb Turritopsis Dohrnii Teo En Ming: > > Subject/Topic: How do I determine if versions of phpMyAdmin before > 4.8.5 is SQL Injectable using sqlmap? > > frankly are you drunken? > > you posted this exactly same message to > > * phpmyadmin list TWICE > * oracle mysql list > * now mariadb list > > i seriously looked if my mailserver has a problem - stop it damned!
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp