Live data from Hacker News

PhpMyAdmin Project Successfully Completes Security Audit

phpmyadmin.net

91–100 of 112 posts

Re: PhpMyAdmin Project Successfully Completes Security Audit

#91

Earlier quoted context omitted.

A theoretical security vulnerability isn't really a think - it's just a bug. Either it's exploitable, and thus a security vulnerability, or it's a bug and isn't,

Yes it is. It is a bug, that may be exploitable. There's no contradiction there.

Global variables are not bugs -- at worse they are bad style and can cause bugs.

As for your other comments, there's this "burden of proof" thing.

Re: PhpMyAdmin Project Successfully Completes Security Audit

#92

I encourage people to google how to run phpMyAdmin, MySQL Workbench, or Sequel Pro locally, and use port forwarding over SSH. It's super simple. Here is a command that forwards all traffic to localhost:3306 across the ssh tunnel to example.com:3306 (the mysql default port). ssh user@example.com -L 3306:localhost:3306 I would never run a DB admin application on the live server because it's just one more piece that mig…

Take it a step further. Set up a locked down bastion server that can only be reached from your IP address, and disable all access to your DB from anything but your application and the bastion server. Then tunnel your local queries through your bastion server.

  ssh -fNg -L 3306:my-secure-db.com:3306 user@bastion-server.com

Re: PhpMyAdmin Project Successfully Completes Security Audit

#93
post #77

I encourage people to google how to run phpMyAdmin, MySQL Workbench, or Sequel Pro locally, and use port forwarding over SSH. It's super simple. Here is a command that forwards all traffic to localhost:3306 across the ssh tunnel to example.com:3306 (the mysql default port). ssh user@example.com -L 3306:localhost:3306 I would never run a DB admin application on the live server because it's just one more piece that mig…

On Windows, I recommend using HeidiSQL, which handles SSH tunnels for you using PuTTY's plink.exe.

Be wary of Heidi and SSH tunnelling on windows - I'm sure the bugs have been fixed but I first hand realised that it re-used the tunnel for subsequent connections meaning you were not making changes on the database you thought you were - definitely caused some problems! However it is such a good client that I now use it on Linux under Wine :)

Re: PhpMyAdmin Project Successfully Completes Security Audit

#94
post #93
post #77

Earlier quoted context omitted.

On Windows, I recommend using HeidiSQL, which handles SSH tunnels for you using PuTTY's plink.exe.

Be wary of Heidi and SSH tunnelling on windows - I'm sure the bugs have been fixed but I first hand realised that it re-used the tunnel for subsequent connections meaning you were not making changes on the database you thought you were - definitely caused some problems! However it is such a good client that I now use it on Linux under Wine :)

https://sourceforge.net/p/heidisql/tickets/2832/

Found my original ticket! And yes, I truncated a few production tables :(

Re: PhpMyAdmin Project Successfully Completes Security Audit

#95

I encourage people to google how to run phpMyAdmin, MySQL Workbench, or Sequel Pro locally, and use port forwarding over SSH. It's super simple. Here is a command that forwards all traffic to localhost:3306 across the ssh tunnel to example.com:3306 (the mysql default port). ssh user@example.com -L 3306:localhost:3306 I would never run a DB admin application on the live server because it's just one more piece that mig…

In that case I would add HeidiSQL to that list.

I use it with Wine in Ubuntu.

Re: PhpMyAdmin Project Successfully Completes Security Audit

#96
post #42
post #33

Earlier quoted context omitted.

Given that the assessment occupied two weeks with two consultants, between $25,000 - $35,000. I don't have intimate knowledge of NCC Group's pricing structure because I don't work there. But I have friends who do, and similarly situated consultancies that I've worked for are in the $10,000/week range for a one-off assessment with non-senior staff. This is also somewhat close to what I charge through my own smaller co…

$10,000/week range seems low for a week long audit, but depends on time charged. Most audits I've worked on, while a week long, have a 2 week pre-audit familiarization period for the audit team, and a 1 week long post-audit report-writing period. This means a 1 week audit is an actual week of investigation, and for $10,000 this sounds low. Via the article, it seems like a leading client / lead of future potential cli…

As a former employee of a penetration testing firm, and a current purchaser of such services, this contrary to my expectations.

I expect any competent firm to be able, in an afternoon, to look at the overall documentation of the web site, chat with me for an hour or so, and come up with a multi-point threat model that will guide the testing. I expect to pay for the actual week or weeks that the team is actually testing the system, and that the report after is a day or two and part of the price.

Re: PhpMyAdmin Project Successfully Completes Security Audit

#97
I encourage everyone to use MySQL Workbench over SSH. For whatever reason people seem to not understand the concept of SSH and the inherent security it provides. But, once you explain to folks how to use it effectively it really is a good balance of security and usability.

Re: PhpMyAdmin Project Successfully Completes Security Audit

#98
post #7
post #3

> A lack of filtering on user CSV output that could allow an attacker to run arbitrary code on an administrator's computer. > Improper cookie invalidation that could allow an attacker to unset internal global variables. Those don't count as serious issues? Props to them for making the report public though.

> > A lack of filtering on user CSV output that could allow an attacker to run arbitrary code on an administrator's computer. Iff the user has Excel, and explicitly allows it to run macros in a CSV file. It's already a stretch to call this a phpMyAdmin vulnerability, much less a "medium severity" one. > > Improper cookie invalidation that could allow an attacker to unset internal global variables. From the PDF report…

I would venture that to do so would devolve into a full source audit, which seriously increases the scope of the test. Full source audits are likely to consume ten times or more calendar effort.

Performing a full source audit is going to result in sticker shock for all but the most well-funded.

Re: PhpMyAdmin Project Successfully Completes Security Audit

#99
post #89

I encourage people to google how to run phpMyAdmin, MySQL Workbench, or Sequel Pro locally, and use port forwarding over SSH. It's super simple. Here is a command that forwards all traffic to localhost:3306 across the ssh tunnel to example.com:3306 (the mysql default port). ssh user@example.com -L 3306:localhost:3306 I would never run a DB admin application on the live server because it's just one more piece that mig…

Or learn how to use the CLI client to connect. No need to install a awkward wrapper software layer.

You seem to be a software developer who is advocating that people not automate something that's tedious (writing and running SELECT and UPDATE queries). Weird.
Post reply on HN