Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Pierre
On 1/11/07, Pierre [EMAIL PROTECTED] wrote: Hi Stefan, On 1/11/07, Stefan Esser [EMAIL PROTECTED] wrote: For your information, zip is not enabled by default. If you have a bug/issue about the specific zip:// URL, please let me know. Ilia and Tony already fixed some paths fixes and the

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Mathieu CARBONNEAUX
_ From: Brian Moon [mailto:[EMAIL PROTECTED] We really need to stop spreading this myth that prepared statements are a security measure. Prepared statements only allow passing of the value parts of where clauses and a couple of other parts of the query. Limit values would be the most

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Mathieu CARBONNEAUX
_ From: Vlad Bosinceanu [mailto:[EMAIL PROTECTED] What might help is pushing (via the manual) for the adoption of tools that prevent common problems, with pdo's prepared statements being one such tool.ok, documenting is what i say... but not all use php5 pdo... not all use php5... many

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Pierre
Hello Andi, On 1/11/07, Andi Gutmans [EMAIL PROTECTED] wrote: Do we need to provide better tools for our developers? Definitely! This is why we are working on ext/filter (I agree the first pass wasn't very successful), a filter extension in Zend Framework, and other best practices. What do

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Tim Starling
Brian Moon wrote: Mathieu CARBONNEAUX wrote: but i think some good security idea have been said, for exemple using prepare statement to avoid sql injection... We really need to stop spreading this myth that prepared statements are a security measure. Prepared statements only allow passing

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Robert Cummings
On Fri, 2007-01-12 at 15:57 +, Tim Starling wrote: Limits, table names, and several other query parts are protected by MediaWiki's query builder. A complex select query might look like this: $result = $db-select( # Tables array( 'user', 'revision' ), # Fields array(

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Tim Starling
Robert Cummings wrote: Wow, that's hideous! Only because I chose a complex example, to demonstrate its capabilities. It's a great deal easier than the equivalent string wrangling. SQL is meant to be human readable. It's not particularly well-suited to construction from PHP data types, or to

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Brian Moon
And using prepare statement to pass variable by binding variable is simple good programming (and must be used with many other good practice...input check...) And effectively is the variable binding and not the prepare statement that add real security again sql injection... but actualy i've

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Michael B Allen
On Fri, 12 Jan 2007 11:40:32 -0500 Robert Cummings [EMAIL PROTECTED] wrote: On Fri, 2007-01-12 at 15:57 +, Tim Starling wrote: Limits, table names, and several other query parts are protected by MediaWiki's query builder. A complex select query might look like this: $result =

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Michael Walter
On 1/12/07, Michael B Allen [EMAIL PROTECTED] wrote: On Fri, 12 Jan 2007 11:40:32 -0500 Robert Cummings [EMAIL PROTECTED] wrote: On Fri, 2007-01-12 at 15:57 +, Tim Starling wrote: Limits, table names, and several other query parts are protected by MediaWiki's query builder. A complex

Re: [PHP-DEV] Windows build

2007-01-12 Thread Stanislav Malyshev
The big one is the HTTP Authentication (?) because, errr, it would have to pass the password in cleartext through a process that would be visible to `ps auxwww` ??? So while it's not technically impossible, FCGI operates by use of pipes, so any data sent back and forth are not accessible

Re: [PHP-DEV] Windows build

2007-01-12 Thread Ilia Alshanetsky
On 12-Jan-07, at 4:12 PM, Stanislav Malyshev wrote: That said, if my Production environment is mod_php, I want my dev environment to be mod_php, because I'd rather not find out the hard way that it makes some subtle but important difference when I get to QA/staging. Well, if you develop on

Re: [PHP-DEV] Windows build

2007-01-12 Thread Stanislav Malyshev
The $_SERVER vars maybe not quite the same as well when comparing mod_php and fcgi. I think the vital ones should be the same, though you indeed might lose some ones like REMOTE_PORT or REMOTE_ADDR - though I checked in my FCGI setup they seem to be ok. -- Stanislav Malyshev, Zend Products

Re: [PHP-DEV] Windows build

2007-01-12 Thread Ilia Alshanetsky
I don't believe you'd lose REMOTE_ADDR in FCGI setup, at least I have never seen it be lost. It is fairly important for many applications and I'd imagine we would've heard it is missing. The ones missing often are DOCUMENT_ROOT, PHP_SELF not being quite the same, PATH_INFO missing or

[PHP-DEV] CVS server downtime

2007-01-12 Thread Rasmus Lerdorf
There will be a short downtime of the cvs server this afternoon. I need to move it to another data center. The IP address will be changing as well. I lowered the TTL of the dns zone file yesterday, so it should be pretty quick to catch up once the machine is hooked back up. I expect about

Re: [PHP-DEV] Comments on PHP security

2007-01-12 Thread Wez Furlong
On 1/12/07, Brian Moon [EMAIL PROTECTED] wrote: The PHP manual nor the MySQL manual mentions sql injection when talking about prepared statements. I don't think you've read the section on prepared statements in the PDO documentation, because it does mention it there, although it doesn't beat

Re: [PHP-DEV] OpenSSL integration

2007-01-12 Thread Wez Furlong
Hi Thomas, I think Marcus gave you all the right pointers. I just wanted to let you know that I have a pending patch for DH kex and some bignum functions, and that Pierre mentioned that he's been working on a few other bits recently. If you think that we'll be overlapping, we can try harder to

Re: [PHP-DEV] OpenSSL integration

2007-01-12 Thread Pierre
Hi Thomas, Wez, On 1/13/07, Wez Furlong [EMAIL PROTECTED] wrote: Hi Thomas, I think Marcus gave you all the right pointers. I just wanted to let you know that I have a pending patch for DH kex and some bignum functions, and that Pierre mentioned that he's been working on a few other bits

Re: [PHP-DEV] OpenSSL integration

2007-01-12 Thread Thomas J. Hruska
Pierre wrote: Hi Thomas, Wez, On 1/13/07, Wez Furlong [EMAIL PROTECTED] wrote: Hi Thomas, I think Marcus gave you all the right pointers. I just wanted to let you know that I have a pending patch for DH kex and some bignum functions, and that Pierre mentioned that he's been working on a few