Menu
▾
▴
chiphpug-discuss — Discussions of PHP-related topics among members of the Chicago PHP User's Group.
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
(9) |
May
(28) |
Jun
(54) |
Jul
(68) |
Aug
(34) |
Sep
(20) |
Oct
(62) |
Nov
(58) |
Dec
(77) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(91) |
Feb
(101) |
Mar
(73) |
Apr
(107) |
May
(56) |
Jun
(43) |
Jul
(68) |
Aug
(31) |
Sep
(35) |
Oct
(50) |
Nov
(20) |
Dec
(37) |
| 2004 |
Jan
(17) |
Feb
(3) |
Mar
(2) |
Apr
(7) |
May
(3) |
Jun
(11) |
Jul
(8) |
Aug
(22) |
Sep
(10) |
Oct
(9) |
Nov
(17) |
Dec
(6) |
| 2005 |
Jan
(14) |
Feb
(11) |
Mar
(6) |
Apr
(30) |
May
(17) |
Jun
(57) |
Jul
(18) |
Aug
(18) |
Sep
(32) |
Oct
(49) |
Nov
(19) |
Dec
(40) |
| 2006 |
Jan
(48) |
Feb
(68) |
Mar
(74) |
Apr
(92) |
May
(90) |
Jun
(60) |
Jul
(25) |
Aug
(47) |
Sep
(36) |
Oct
(64) |
Nov
(57) |
Dec
(21) |
| 2007 |
Jan
(74) |
Feb
(24) |
Mar
(49) |
Apr
(37) |
May
(56) |
Jun
(27) |
Jul
(23) |
Aug
(24) |
Sep
(24) |
Oct
(58) |
Nov
(13) |
Dec
(9) |
| 2008 |
Jan
(41) |
Feb
(16) |
Mar
(53) |
Apr
(19) |
May
(53) |
Jun
(20) |
Jul
(44) |
Aug
(12) |
Sep
(19) |
Oct
(22) |
Nov
(64) |
Dec
(14) |
| 2009 |
Jan
(16) |
Feb
(37) |
Mar
(30) |
Apr
(24) |
May
(3) |
Jun
(14) |
Jul
(39) |
Aug
(30) |
Sep
(38) |
Oct
(10) |
Nov
(9) |
Dec
(30) |
| 2010 |
Jan
(27) |
Feb
(9) |
Mar
(8) |
Apr
(38) |
May
(17) |
Jun
(2) |
Jul
(15) |
Aug
(3) |
Sep
(9) |
Oct
(3) |
Nov
(14) |
Dec
(6) |
| 2011 |
Jan
(1) |
Feb
(14) |
Mar
(18) |
Apr
(7) |
May
(3) |
Jun
(5) |
Jul
(3) |
Aug
|
Sep
(3) |
Oct
(3) |
Nov
(3) |
Dec
(2) |
| 2012 |
Jan
(2) |
Feb
(2) |
Mar
(1) |
Apr
|
May
(2) |
Jun
(1) |
Jul
(2) |
Aug
(2) |
Sep
(1) |
Oct
(4) |
Nov
(5) |
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Kevin W. <KW...@pr...> - 2008-12-08 23:42:23
|
Prestige Staffing is looking for a Mid-Level PHP Developer for a client in the city of Chicago. Our client is a growing company that specializes in marketing management consulting. They are looking for a talented PHP Developer with over 2 years of PHP and MYSQL development experience. Linux platform experience is a plus. If you are looking for a challenging new opportunity with a company on the rise, do not hesitate to contact me. Regards, Kevin Welch Account Manager Prestige Staffing 105 West Adams Street, Suite 1410 - Chicago, IL 60603 Voice 312-443-6157 - Fax 312-345-1941 kw...@pr... <mailto:eg...@pr...> - www.prestigestaffing.com <http://www.prestigestaffing.com/> |
|
From: Richard L. <ce...@l-...> - 2008-12-03 03:32:52
|
Just catching up on email and... First off, it really should be in a database that you search and sort. Using PHP to do that is almost always a sign of a bad architectural decision... You might even toss the data into sqlite just to have sane way to search/sort it. That said, if the array is "small" iterating through is fine But if the array is big, you could probably use some kind of http://php.net/usort on the array and then a binary search on the time frame in question to find the answer quicker than an iteration. On Fri, November 14, 2008 12:18 pm, Steve Gadlin wrote: > Hey there, PHP-folks! > > I have an array question, and I was hoping someone here could point me > in > the right direction. > > So I¹ve got this array, see... > > $arToday[0][³title²] = ³Patty Duke² > $arToday[0][³starttime²] = 12:00:00 > $arToday[1][³title²] = ³Sesame Street² > $arToday[1][³starttime²] = 12:30:00 > ... > ... > Etc. > > Is there an easy way for me to ³query² this array to snag the index of > the > record whose starttime variable is current? Thereby selecting the > name of > the program that may be airing ³now²? > > Thanks so much for your help! If there¹s some other list I should be > posting questions to instead of this one, let me know. > > Steve > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the > world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > -- Some people ask for gifts here. I just want you to buy an Indie CD for yourself: http://cdbaby.com/search/from/lynch |
|
From: Kent G. <ke...@ri...> - 2008-12-03 01:28:47
|
Lead PHP Developer Successful Holland, Michigan based ecommerce retailer seeks a talented senior developer to build and improve our existing customer facing systems. The role is very hands on and PHP intensive but will involve a growing leadership presence as the company expands. A minimum of 5 years prior experience with PHP is required. We strongly desire an individual that has a track record building highly-scalable web applications. Responsibilities * Design new features, both on the back-end (data modeling and management) and front-end using PHP, MySQL, SOLR/Lucerne, AJAX and other open-source technologies. * Experience with the management of large data sets, our environment manages over 700,000 SKU’s. * Develop and evolve website infrastructure and back-end processes that manage business critical tasks. * Continuous improvement of development processes and architectural patterns. Requirements * Experience building high quality, scalable web applications. Emphasis on ecommerce. * Extensive experience programming in PHP 4/5 (5 preferred) * XML, SOAP, cURLl * Experience with JavaScript, JSON, AJAX, CSS, and XHTML * Expert knowledge of SQL and relational database structures. * A good understanding of faceted / guided navigation and search technologies * Ability to develop and document clean, object oriented code. Prior history with the following is not required, but definitely helpful in our environment: * Java * Tomcat * Spring Framework * Pentaho * Authorize.net API integration * Shell scripting * Smarty or related templating systems * JavaScript frameworks such as jQuery |
|
From: Richard L. <ce...@l-...> - 2008-11-30 03:22:50
|
It's not that my personally-hosted webmail won't work, because it does work just fine. It's that they have to snoop on everything all the time anyway, so trying to bypass their policies is just gonna get me burned sooner or later. I don't MIND it, really, it's just a PITA... On Fri, November 28, 2008 10:59 am, Anacreo wrote: > I feel your pain... Try opera mini which proxies the internet > connection off of their servers to check your gmail from your phone... > Also a lot of companies block web access to gmail but not pop/imap > access. > > Alec > > On 11/28/08, Richard Lynch <ce...@l-...> wrote: >> HTTP Upload was a tacked-on after-thought to the Spec, in many ways. >> >> And it was simply not engineered for large files, really... >> >> There's no "retry" nor "continue" >> >> The browser itself has a time limit on how long it will "wait" for >> the >> server to respond or send out data, and even if it's uploading a >> file >> rather than downloading, that MAY be kicking in. If so, there's no >> way to fix that, short of convincing MS and Mozilla to re-write >> their >> code. >> >> As a client, I'd be very unhappy if you expected me to upload 1G >> files >> over HTTP, rather than using something sane like ftp or scp. :-) >> >> I doubt that anybody dealing with a 1G file is too incompetent to >> handle ftp or scp, especially with the nice front-end GUIs out there >> for these. (Though I would just use command-line personally...) >> >> PS >> Sorry I missed the meeting. Not allowed to check email at work is >> killing me... >> >> On Wed, November 19, 2008 2:10 am, Peter Snyder wrote: >>> Hello Everyone, >>> >>> I'm having a problem creating an app for a client who will need to >>> upload very large files, around 1GB. I'm running into problems >>> though >>> with the upload. In an effort to rule out problems, I've boosted >>> all >>> the normal suspects to absurd levels (see below), but am still >>> getting >>> problems. If I just watch the uploads in the temp dir I can see >>> that >>> the server is receiving the uploads correctly, but for some reason >>> the >>> upload stops at around 40 - 50 MB each time. The browser will >>> putter >>> on for a while and then say that the server has timed out. >>> >>> Does anyone have any other ideas for possible problems? I've tried >>> this on two different servers (clients and my staging one), with no >>> luck. Any hints anyone could provide would be greatly appreciated. >>> >>> Thanks! >>> >>> Sincerely, >>> Pete Snyder >>> >>> >>> >>> >>> ----- >>> .htaccess file >>> php_value memory_limit 2G >>> php_value post_max_size 2G >>> php_value upload_max_filesize 2G >>> php_value max_input_time 144000 >>> php_value max_execution_time 144000 >>> >>> >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win >>> great >>> prizes >>> Grand prize is a trip for two to an Open Source event anywhere in >>> the >>> world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> chiPHPug-discuss mailing list >>> chi...@li... >>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >>> >> >> >> -- >> Some people ask for gifts here. >> I just want you to buy an Indie CD for yourself: >> http://cdbaby.com/search/from/lynch >> >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win >> great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in >> the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> > > -- > Sent from my mobile device > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the > world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > -- Some people ask for gifts here. I just want you to buy an Indie CD for yourself: http://cdbaby.com/search/from/lynch |
|
From: matt d. <mm_...@ya...> - 2008-11-28 17:50:54
|
(drifting off topic) Or run your own (squid) proxy server. ________________________________ From: Anacreo <an...@gm...> To: Discussions of PHP-related topics among members of the Chicago PHP User's Group. <chi...@li...> Sent: Friday, November 28, 2008 10:59:23 AM Subject: Re: [chiPHPug-discuss] Very Large Uploads Problem I feel your pain... Try opera mini which proxies the internet connection off of their servers to check your gmail from your phone... Also a lot of companies block web access to gmail but not pop/imap access. Alec On 11/28/08, Richard Lynch <ce...@l-...> wrote: > HTTP Upload was a tacked-on after-thought to the Spec, in many ways. > > And it was simply not engineered for large files, really... > > There's no "retry" nor "continue" > > The browser itself has a time limit on how long it will "wait" for the > server to respond or send out data, and even if it's uploading a file > rather than downloading, that MAY be kicking in. If so, there's no > way to fix that, short of convincing MS and Mozilla to re-write their > code. > > As a client, I'd be very unhappy if you expected me to upload 1G files > over HTTP, rather than using something sane like ftp or scp. :-) > > I doubt that anybody dealing with a 1G file is too incompetent to > handle ftp or scp, especially with the nice front-end GUIs out there > for these. (Though I would just use command-line personally...) > > PS > Sorry I missed the meeting. Not allowed to check email at work is > killing me... > > On Wed, November 19, 2008 2:10 am, Peter Snyder wrote: >> Hello Everyone, >> >> I'm having a problem creating an app for a client who will need to >> upload very large files, around 1GB. I'm running into problems though >> with the upload. In an effort to rule out problems, I've boosted all >> the normal suspects to absurd levels (see below), but am still getting >> problems. If I just watch the uploads in the temp dir I can see that >> the server is receiving the uploads correctly, but for some reason the >> upload stops at around 40 - 50 MB each time. The browser will putter >> on for a while and then say that the server has timed out. >> >> Does anyone have any other ideas for possible problems? I've tried >> this on two different servers (clients and my staging one), with no >> luck. Any hints anyone could provide would be greatly appreciated. >> >> Thanks! >> >> Sincerely, >> Pete Snyder >> >> >> >> >> ----- >> .htaccess file >> php_value memory_limit 2G >> php_value post_max_size 2G >> php_value upload_max_filesize 2G >> php_value max_input_time 144000 >> php_value max_execution_time 144000 >> >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in the >> world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> > > > -- > Some people ask for gifts here. > I just want you to buy an Indie CD for yourself: > http://cdbaby.com/search/from/lynch > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > -- Sent from my mobile device ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ chiPHPug-discuss mailing list chi...@li... https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: Anacreo <an...@gm...> - 2008-11-28 16:59:26
|
I feel your pain... Try opera mini which proxies the internet connection off of their servers to check your gmail from your phone... Also a lot of companies block web access to gmail but not pop/imap access. Alec On 11/28/08, Richard Lynch <ce...@l-...> wrote: > HTTP Upload was a tacked-on after-thought to the Spec, in many ways. > > And it was simply not engineered for large files, really... > > There's no "retry" nor "continue" > > The browser itself has a time limit on how long it will "wait" for the > server to respond or send out data, and even if it's uploading a file > rather than downloading, that MAY be kicking in. If so, there's no > way to fix that, short of convincing MS and Mozilla to re-write their > code. > > As a client, I'd be very unhappy if you expected me to upload 1G files > over HTTP, rather than using something sane like ftp or scp. :-) > > I doubt that anybody dealing with a 1G file is too incompetent to > handle ftp or scp, especially with the nice front-end GUIs out there > for these. (Though I would just use command-line personally...) > > PS > Sorry I missed the meeting. Not allowed to check email at work is > killing me... > > On Wed, November 19, 2008 2:10 am, Peter Snyder wrote: >> Hello Everyone, >> >> I'm having a problem creating an app for a client who will need to >> upload very large files, around 1GB. I'm running into problems though >> with the upload. In an effort to rule out problems, I've boosted all >> the normal suspects to absurd levels (see below), but am still getting >> problems. If I just watch the uploads in the temp dir I can see that >> the server is receiving the uploads correctly, but for some reason the >> upload stops at around 40 - 50 MB each time. The browser will putter >> on for a while and then say that the server has timed out. >> >> Does anyone have any other ideas for possible problems? I've tried >> this on two different servers (clients and my staging one), with no >> luck. Any hints anyone could provide would be greatly appreciated. >> >> Thanks! >> >> Sincerely, >> Pete Snyder >> >> >> >> >> ----- >> .htaccess file >> php_value memory_limit 2G >> php_value post_max_size 2G >> php_value upload_max_filesize 2G >> php_value max_input_time 144000 >> php_value max_execution_time 144000 >> >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in the >> world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> > > > -- > Some people ask for gifts here. > I just want you to buy an Indie CD for yourself: > http://cdbaby.com/search/from/lynch > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > -- Sent from my mobile device |
|
From: Richard L. <ce...@l-...> - 2008-11-28 16:28:41
|
HTTP Upload was a tacked-on after-thought to the Spec, in many ways. And it was simply not engineered for large files, really... There's no "retry" nor "continue" The browser itself has a time limit on how long it will "wait" for the server to respond or send out data, and even if it's uploading a file rather than downloading, that MAY be kicking in. If so, there's no way to fix that, short of convincing MS and Mozilla to re-write their code. As a client, I'd be very unhappy if you expected me to upload 1G files over HTTP, rather than using something sane like ftp or scp. :-) I doubt that anybody dealing with a 1G file is too incompetent to handle ftp or scp, especially with the nice front-end GUIs out there for these. (Though I would just use command-line personally...) PS Sorry I missed the meeting. Not allowed to check email at work is killing me... On Wed, November 19, 2008 2:10 am, Peter Snyder wrote: > Hello Everyone, > > I'm having a problem creating an app for a client who will need to > upload very large files, around 1GB. I'm running into problems though > with the upload. In an effort to rule out problems, I've boosted all > the normal suspects to absurd levels (see below), but am still getting > problems. If I just watch the uploads in the temp dir I can see that > the server is receiving the uploads correctly, but for some reason the > upload stops at around 40 - 50 MB each time. The browser will putter > on for a while and then say that the server has timed out. > > Does anyone have any other ideas for possible problems? I've tried > this on two different servers (clients and my staging one), with no > luck. Any hints anyone could provide would be greatly appreciated. > > Thanks! > > Sincerely, > Pete Snyder > > > > > ----- > .htaccess file > php_value memory_limit 2G > php_value post_max_size 2G > php_value upload_max_filesize 2G > php_value max_input_time 144000 > php_value max_execution_time 144000 > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the > world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > -- Some people ask for gifts here. I just want you to buy an Indie CD for yourself: http://cdbaby.com/search/from/lynch |
|
From: Beau G. <be...@op...> - 2008-11-26 14:16:38
|
* Good knowledge of PHP * Experience with MySQL/SQL * Experience with HTML, CSS and JavaScript * Knowledge of OO programming a plus To be considered, please submit your resume and code sample/s (OO PHP preferred) along with your salary requirements to bg @ capitalmarketsp.com Beau Gould Executive Advisor Capital Markets Placement www.cmp.jobs bg @ capitalmarketsp.com |
|
From: Richard L. <ce...@l-...> - 2008-11-26 05:10:46
|
I don't know anything more than the little that is here. If you have PHP and QA experience, follow up with Brian. -------------------------- Original Message -------------------------- Subject: PHP QA position From: "Crowther, Brian" <bcr...@te...> Date: Fri, November 21, 2008 10:44 am To: Cc: recipient list not shown:; ---------------------------------------------------------------------- Good morning, We've recently spoken about several contract positions that TEKsystems is working on filling. I have a new position that will be open in the middle of December for anyone who has both PHP and QA experience. I am hoping you can pass this on to anyone who has tested your code in the past. Ideally, we will be spending next week lining up interviews for the 1st of December. The economy is pretty rough right now and if you know anyone in the IT field that is looking for a job, please pass along my name and number because TEKsystems can help them. Sincerely, Brian This electronic mail (including any attachments) may contain information that is privileged, confidential, and/or otherwise protected from disclosure to anyone other than its intended recipient(s). Any dissemination or use of this electronic email or its contents (including any attachments) by persons other than the intended recipient(s) is strictly prohibited. If you have received this message in error, please notify us immediately by reply email so that we may correct our internal records. Please then delete the original message (including any attachments) in its entirety. Thank you. -- Some people ask for gifts here. I just want you to buy an Indie CD for yourself: http://cdbaby.com/search/from/lynch |
|
From: Janine S. <jr...@ba...> - 2008-11-21 07:45:14
|
This works! Thank you, I can't believe I couldn't find this through google. Janine Ryan Guthrie wrote: > The < filename.sql syntax only works at the unix command prompt, not > the mysql command prompt. To import a file from there do > mysql> use database_name > mysql> source filename.sql > |
|
From: Ryan G. <sok...@gm...> - 2008-11-21 07:01:00
|
The < filename.sql syntax only works at the unix command prompt, not the mysql command prompt. To import a file from there do mysql> use database_name mysql> source filename.sql On Thu, Nov 20, 2008 at 10:47 PM, Janine Starykowicz <jr...@ba...> wrote: > I'm in Windows. I've tried doing all kinds of variations on what you > posted, and keep getting a syntax error. > > Janine > > Anacreo wrote: >> You want to make sure you're not in the "mysql>" prompt when you're doing >> this... >> >> Try something like: >> >> unix prompt> mysql -u **** -p ****** -h localhost database < filename.sql >> >> If you're in Windows the syntax would be a bit different. >> >> Alec >> >> On Thu, Nov 20, 2008 at 11:56 PM, Janine Starykowicz <jr...@ba... >> >>> wrote: >>> >> >> >>> I am attempting to mirror SMF on my WinXP laptop to test upgrades. I >>> have Apache, PHP, mySQL, and one working install of Drupal all tested >>> and running. Apache, PHP and mySQL are all installed in c:\Program >>> Files. Database is created and empty and I exported the .sql file >>> through phpMyAdmin from my public server. >>> >>> After logging in to mysql and using the database, at the command line >>> mysql> I enter: >>> mysql -u **** -p ****** -h localhost database < filename.sql; >>> where user and password is for mySQL >>> >>> and get: >>> ERROR 1064 (42000): You have an error in your SQL syntax; check the >>> manual that >>> corresponds to your MySQL server version for the right syntax to use >>> near 'mysql >>> -u **** -p ******* -h localhost database < filename.sql' at line 1 >>> >>> I have also tried exiting mysql and changing (with cd) to the MySQL >>> subdirectory (where the .sql file is). That gives me a long list of >>> commands instead of an error message, but the database is still empty >>> and I am not running mysql when the commands finish listing. >>> >>> I have tried taking out the spaces after -u and -p. I've tried leaving >>> the space after -u, no space after -p and no space after < with ./ as >>> the path. >>> >>> I tried installing MySQL Tools and using the MySQL Administrator, it >>> said it can't restore files generated by mysqldump. >>> >>> What am I doing wrong? Where should I put the .sql file and how should >>> I list the path? Which spaces are needed? >>> >>> Thanks! >>> Janine >>> > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > |
|
From: Anacreo <an...@gm...> - 2008-11-21 07:00:14
|
Try doing... mysql -u **** --password=***** -h localhost database < filename.sql Or: type filename.sql | mysql -u **** --password=****** -h localhost database Paste the Syntax error... if it's complaining that the table already exists, you'll need to remove the create table statements in your filename.sql file. Alec On Fri, Nov 21, 2008 at 12:47 AM, Janine Starykowicz <jr...@ba... > wrote: > I'm in Windows. I've tried doing all kinds of variations on what you > posted, and keep getting a syntax error. > > Janine > > Anacreo wrote: > > You want to make sure you're not in the "mysql>" prompt when you're doing > > this... > > > > Try something like: > > > > unix prompt> mysql -u **** -p ****** -h localhost database < filename.sql > > > > If you're in Windows the syntax would be a bit different. > > > > Alec > > > > On Thu, Nov 20, 2008 at 11:56 PM, Janine Starykowicz < > jr...@ba... > > > >> wrote: > >> > > > > > >> I am attempting to mirror SMF on my WinXP laptop to test upgrades. I > >> have Apache, PHP, mySQL, and one working install of Drupal all tested > >> and running. Apache, PHP and mySQL are all installed in c:\Program > >> Files. Database is created and empty and I exported the .sql file > >> through phpMyAdmin from my public server. > >> > >> After logging in to mysql and using the database, at the command line > >> mysql> I enter: > >> mysql -u **** -p ****** -h localhost database < filename.sql; > >> where user and password is for mySQL > >> > >> and get: > >> ERROR 1064 (42000): You have an error in your SQL syntax; check the > >> manual that > >> corresponds to your MySQL server version for the right syntax to use > >> near 'mysql > >> -u **** -p ******* -h localhost database < filename.sql' at line 1 > >> > >> I have also tried exiting mysql and changing (with cd) to the MySQL > >> subdirectory (where the .sql file is). That gives me a long list of > >> commands instead of an error message, but the database is still empty > >> and I am not running mysql when the commands finish listing. > >> > >> I have tried taking out the spaces after -u and -p. I've tried leaving > >> the space after -u, no space after -p and no space after < with ./ as > >> the path. > >> > >> I tried installing MySQL Tools and using the MySQL Administrator, it > >> said it can't restore files generated by mysqldump. > >> > >> What am I doing wrong? Where should I put the .sql file and how should > >> I list the path? Which spaces are needed? > >> > >> Thanks! > >> Janine > >> > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > |
|
From: Janine S. <jr...@ba...> - 2008-11-21 06:47:26
|
I'm in Windows. I've tried doing all kinds of variations on what you posted, and keep getting a syntax error. Janine Anacreo wrote: > You want to make sure you're not in the "mysql>" prompt when you're doing > this... > > Try something like: > > unix prompt> mysql -u **** -p ****** -h localhost database < filename.sql > > If you're in Windows the syntax would be a bit different. > > Alec > > On Thu, Nov 20, 2008 at 11:56 PM, Janine Starykowicz <jr...@ba... > >> wrote: >> > > >> I am attempting to mirror SMF on my WinXP laptop to test upgrades. I >> have Apache, PHP, mySQL, and one working install of Drupal all tested >> and running. Apache, PHP and mySQL are all installed in c:\Program >> Files. Database is created and empty and I exported the .sql file >> through phpMyAdmin from my public server. >> >> After logging in to mysql and using the database, at the command line >> mysql> I enter: >> mysql -u **** -p ****** -h localhost database < filename.sql; >> where user and password is for mySQL >> >> and get: >> ERROR 1064 (42000): You have an error in your SQL syntax; check the >> manual that >> corresponds to your MySQL server version for the right syntax to use >> near 'mysql >> -u **** -p ******* -h localhost database < filename.sql' at line 1 >> >> I have also tried exiting mysql and changing (with cd) to the MySQL >> subdirectory (where the .sql file is). That gives me a long list of >> commands instead of an error message, but the database is still empty >> and I am not running mysql when the commands finish listing. >> >> I have tried taking out the spaces after -u and -p. I've tried leaving >> the space after -u, no space after -p and no space after < with ./ as >> the path. >> >> I tried installing MySQL Tools and using the MySQL Administrator, it >> said it can't restore files generated by mysqldump. >> >> What am I doing wrong? Where should I put the .sql file and how should >> I list the path? Which spaces are needed? >> >> Thanks! >> Janine >> |
|
From: Anacreo <an...@gm...> - 2008-11-21 06:34:01
|
You want to make sure you're not in the "mysql>" prompt when you're doing this... Try something like: unix prompt> mysql -u **** -p ****** -h localhost database < filename.sql If you're in Windows the syntax would be a bit different. Alec On Thu, Nov 20, 2008 at 11:56 PM, Janine Starykowicz <jr...@ba... > wrote: > I am attempting to mirror SMF on my WinXP laptop to test upgrades. I > have Apache, PHP, mySQL, and one working install of Drupal all tested > and running. Apache, PHP and mySQL are all installed in c:\Program > Files. Database is created and empty and I exported the .sql file > through phpMyAdmin from my public server. > > After logging in to mysql and using the database, at the command line > mysql> I enter: > mysql -u **** -p ****** -h localhost database < filename.sql; > where user and password is for mySQL > > and get: > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual that > corresponds to your MySQL server version for the right syntax to use > near 'mysql > -u **** -p ******* -h localhost database < filename.sql' at line 1 > > I have also tried exiting mysql and changing (with cd) to the MySQL > subdirectory (where the .sql file is). That gives me a long list of > commands instead of an error message, but the database is still empty > and I am not running mysql when the commands finish listing. > > I have tried taking out the spaces after -u and -p. I've tried leaving > the space after -u, no space after -p and no space after < with ./ as > the path. > > I tried installing MySQL Tools and using the MySQL Administrator, it > said it can't restore files generated by mysqldump. > > What am I doing wrong? Where should I put the .sql file and how should > I list the path? Which spaces are needed? > > Thanks! > Janine > > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > |
|
From: Janine S. <jr...@ba...> - 2008-11-21 06:23:19
|
I am attempting to mirror SMF on my WinXP laptop to test upgrades. I have Apache, PHP, mySQL, and one working install of Drupal all tested and running. Apache, PHP and mySQL are all installed in c:\Program Files. Database is created and empty and I exported the .sql file through phpMyAdmin from my public server. After logging in to mysql and using the database, at the command line mysql> I enter: mysql -u **** -p ****** -h localhost database < filename.sql; where user and password is for mySQL and get: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u **** -p ******* -h localhost database < filename.sql' at line 1 I have also tried exiting mysql and changing (with cd) to the MySQL subdirectory (where the .sql file is). That gives me a long list of commands instead of an error message, but the database is still empty and I am not running mysql when the commands finish listing. I have tried taking out the spaces after -u and -p. I've tried leaving the space after -u, no space after -p and no space after < with ./ as the path. I tried installing MySQL Tools and using the MySQL Administrator, it said it can't restore files generated by mysqldump. What am I doing wrong? Where should I put the .sql file and how should I list the path? Which spaces are needed? Thanks! Janine |
|
From: matt d. <mm_...@ya...> - 2008-11-20 13:57:32
|
I didn't catch Jason's ini settings but we upload CAD files all the time up to 800MB w/ Apache/Linux. Did you increase form processing time? max_input_time 3600 3600 I would also try and just copy a 1GB file to tmp as a saity check. ________________________________ From: derby <der...@gm...> To: Discussions of PHP-related topics among members of the Chicago PHP User's Group. <chi...@li...> Sent: Thursday, November 20, 2008 12:30:40 AM Subject: Re: [chiPHPug-discuss] Very Large Uploads Problem I am also in need of uploading large files via PHP. I tried a few settings in php.ini to increase time and upload size, but the most I could upload was about 70 MB worth a 200MB file. I saw some example scripts that integrate a ftp client into a PHP script, but I haven't tested it and I am not sure if this would even work since I would still be running the PHP on top of the ftp portion. derby ps thanks Jason for all the details On Nov 19, 2008, at 13:03, Peter Snyder wrote: > Hi Wilfried, > > I agree that HTTP probably (ok, absolutely) isn't the most technically > sound way of doing this, but the client needs a dead-simple way for > his clients to submit large audio files for editing. So, sadly, HTTP > is the best tool for the job. > > I've tried two flash applets (SWFuploader and FancyUpload), and both > work well except they similarly stop sending data after 40 or 50mb. I > think this won't get around the problem since they're still submitting > data via HTTP POST anyway. Can you, or anyone else for that matter, > recommend a flash or java solution that you've had good luck with? > Anyone have any idea what sites like MegaUpload or YouTube or > othersites that allow users to upload mega amounts of data use? > > Thanks for your input Wilfred. Maybe you're right and its time to go > back to the client and say "are you sure this the way you want to > go..." :-) > > Pete > > > On Nov 19, 2008, at 12:50 PM, Wilfried Schobeiri wrote: > >> I sent this to the list but it didnt let me: >> >> You know, part of me wants to say if you're trying to move gigs of >> data around via web form, youre doing something wrong. >> >> Think: >> * tmp or /var space could run out, because its getting written to / >> var/ >> tmp then rebuilt to /tmp >> * PHP could run out of memory rebuilding the 1MB /var/tmp chunks (or >> so I read) >> * You're tying up an httpd instance for who knows how long >> * No Fault Tolerance... process manager might kill the process or the >> client might time out. >> >> Plus, HTTP wasn't designed for large file transfers. >> >> Then again, if its hosted locally, some of this may not apply. >> >> Try a Java or Flash applet instead, perhaps? Yes, i know... *groan*. >> On Nov 19, 2008, at 12:47 , Peter Snyder wrote: >> >>> Thank you Jason and Arlo for your suggestions. >>> >>> I checked to make sure that the php settings were reflected in >>> phpinfo() and they were, so I don't believe that could be the >>> problem. >>> >>> I also tried rewriting the sizes in .htaccess as 1000000000 instead >>> of >>> 1G, and tried adding to session.gc_maxlifetime to 14400. The only >>> difference I've from doing this is that Firefox gives me a >>> "Connection >>> Interrupted' error page instead of a "timed out error message". >>> >>> Both servers I've tested on are linux / apache ones, so thankfully I >>> don't need to worry about IIS issues. And there is no MAX_FILE_SIZE >>> form field, nor >>> >>> The only remaining issue I can think of might be with the >>> LimitRequestBody setting. I've emailed my hosting company to ask >>> them >>> if they have a limit enforced. In the meantime though, is there >>> someway I can test this on my own? >>> >>> Again, thank you both for your comments. They are greatly >>> appreciated! >>> >>> Pete >>> >>> >>> On Nov 19, 2008, at 8:12 AM, Jason Rexilius wrote: >>> >>>> A couple of feedback items from the google (off the top of my >>>> head I >>>> cant see anything obvious): >>>> >>>> 1) are you running newer PHP5? from manual: >>>> "G (for Gigabytes; available since PHP 5.1.0)" >>>> >>>> >>>> 2) IIS has som limits if you are on Windows (why, oh why): >>>> IIS7 has a upload limit of 30000000 (about 30mb) >>>> You can change this with the command (for 250mb): >>>> c:\windows\system32\inetsrv\appcmd set config - >>>> section:requestFiltering >>>> -requestLimits.maxAllowedContentLength:262144000 >>>> Or manual define it in: >>>> %windir%\system32\inetsrv\config\applicationhost.config >>>> Add this rule before the </requestFiltering> tag: >>>> <requestLimits maxAllowedContentLength ="262144000" /> >>>> >>>> >>>> 3) There has been reference to session.gc_maxlifetime default value >>>> 1440 >>>> (24min) causing GC to wack session duriung upload and cause >>>> problems. >>>> Not sure on that one.. >>>> >>>> >>>> 4) Also reported issues of MAX_FILE_SIZE hidden form field, and >>>> zlib.output_compression = On in Apache.. >>>> >>>> >>>> 5) Check Apache LimitRequestBody (max size in bytes) >>>> >>>> >>>> 6) Obscure but possible: >>>> "Because some systems send the packets with the headers last (or >>>> the >>>> header packet may be received after some of the data packets), >>>> firewalls >>>> can't filter this traffic based on destination port and address. >>>> Many >>>> firewalls (including iptables) have to be configured to allow >>>> fragments >>>> separately from standard traffic. Unfortunately, it's an all-or- >>>> nothing >>>> thing in these cases, and exploits based on packet fragmentation >>>> have >>>> been a problem in the past (teardrop, boink, etc.). Note that ICMP >>>> may >>>> be used to notify the host (your server) of oncoming fragmentation, >>>> so >>>> you may need to allow ICMP traffic as well." >>>> >>>> The iptables rules for this are as follows: >>>> # allow all fragments >>>> -A INPUT -f -j ACCEPT >>>> # allow icmp traffic >>>> -A INPUT -p icmp -j ACCEPT >>>> >>>> >>>> Most of the above thanks to manual page: >>>> >>>> http://us3.php.net/features.file-upload >>>> >>>> >>>> >>>> Peter Snyder wrote: >>>>> Hello Everyone, >>>>> >>>>> I'm having a problem creating an app for a client who will need to >>>>> upload very large files, around 1GB. I'm running into problems >>>>> though >>>>> with the upload. In an effort to rule out problems, I've boosted >>>>> all >>>>> the normal suspects to absurd levels (see below), but am still >>>>> getting >>>>> problems. If I just watch the uploads in the temp dir I can see >>>>> that >>>>> the server is receiving the uploads correctly, but for some reason >>>>> the >>>>> upload stops at around 40 - 50 MB each time. The browser will >>>>> putter >>>>> on for a while and then say that the server has timed out. >>>>> >>>>> Does anyone have any other ideas for possible problems? I've >>>>> tried >>>>> this on two different servers (clients and my staging one), >>>>> with no >>>>> luck. Any hints anyone could provide would be greatly >>>>> appreciated. >>>>> >>>>> Thanks! >>>>> >>>>> Sincerely, >>>>> Pete Snyder >>>>> >>>>> >>>>> >>>>> >>>>> ----- >>>>> .htaccess file >>>>> php_value memory_limit 2G >>>>> php_value post_max_size 2G >>>>> php_value upload_max_filesize 2G >>>>> php_value max_input_time 144000 >>>>> php_value max_execution_time 144000 >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------ >>>>> ------- >>>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>>> challenge >>>>> Build the coolest Linux based applications with Moblin SDK & win >>>>> great prizes >>>>> Grand prize is a trip for two to an Open Source event anywhere in >>>>> the world >>>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>>> _______________________________________________ >>>>> chiPHPug-discuss mailing list >>>>> chi...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >>>> >>>> ------------------------------------------------------------------- >>>> ------ >>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>> challenge >>>> Build the coolest Linux based applications with Moblin SDK & win >>>> great prizes >>>> Grand prize is a trip for two to an Open Source event anywhere in >>>> the world >>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>> _______________________________________________ >>>> chiPHPug-discuss mailing list >>>> chi...@li... >>>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >>> >>> >>> -------------------------------------------------------------------- >>> ----- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win >>> great prizes >>> Grand prize is a trip for two to an Open Source event anywhere in >>> the world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> chiPHPug-discuss mailing list >>> chi...@li... >>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> >> >> --------------------------------------------------------------------- >> ---- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win >> great prizes >> Grand prize is a trip for two to an Open Source event anywhere in >> the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > > ---------------------------------------------------------------------- > --- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ chiPHPug-discuss mailing list chi...@li... https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: derby <der...@gm...> - 2008-11-20 06:30:48
|
I am also in need of uploading large files via PHP. I tried a few settings in php.ini to increase time and upload size, but the most I could upload was about 70 MB worth a 200MB file. I saw some example scripts that integrate a ftp client into a PHP script, but I haven't tested it and I am not sure if this would even work since I would still be running the PHP on top of the ftp portion. derby ps thanks Jason for all the details On Nov 19, 2008, at 13:03, Peter Snyder wrote: > Hi Wilfried, > > I agree that HTTP probably (ok, absolutely) isn't the most technically > sound way of doing this, but the client needs a dead-simple way for > his clients to submit large audio files for editing. So, sadly, HTTP > is the best tool for the job. > > I've tried two flash applets (SWFuploader and FancyUpload), and both > work well except they similarly stop sending data after 40 or 50mb. I > think this won't get around the problem since they're still submitting > data via HTTP POST anyway. Can you, or anyone else for that matter, > recommend a flash or java solution that you've had good luck with? > Anyone have any idea what sites like MegaUpload or YouTube or > othersites that allow users to upload mega amounts of data use? > > Thanks for your input Wilfred. Maybe you're right and its time to go > back to the client and say "are you sure this the way you want to > go..." :-) > > Pete > > > On Nov 19, 2008, at 12:50 PM, Wilfried Schobeiri wrote: > >> I sent this to the list but it didnt let me: >> >> You know, part of me wants to say if you're trying to move gigs of >> data around via web form, youre doing something wrong. >> >> Think: >> * tmp or /var space could run out, because its getting written to / >> var/ >> tmp then rebuilt to /tmp >> * PHP could run out of memory rebuilding the 1MB /var/tmp chunks (or >> so I read) >> * You're tying up an httpd instance for who knows how long >> * No Fault Tolerance... process manager might kill the process or the >> client might time out. >> >> Plus, HTTP wasn't designed for large file transfers. >> >> Then again, if its hosted locally, some of this may not apply. >> >> Try a Java or Flash applet instead, perhaps? Yes, i know... *groan*. >> On Nov 19, 2008, at 12:47 , Peter Snyder wrote: >> >>> Thank you Jason and Arlo for your suggestions. >>> >>> I checked to make sure that the php settings were reflected in >>> phpinfo() and they were, so I don't believe that could be the >>> problem. >>> >>> I also tried rewriting the sizes in .htaccess as 1000000000 instead >>> of >>> 1G, and tried adding to session.gc_maxlifetime to 14400. The only >>> difference I've from doing this is that Firefox gives me a >>> "Connection >>> Interrupted' error page instead of a "timed out error message". >>> >>> Both servers I've tested on are linux / apache ones, so thankfully I >>> don't need to worry about IIS issues. And there is no MAX_FILE_SIZE >>> form field, nor >>> >>> The only remaining issue I can think of might be with the >>> LimitRequestBody setting. I've emailed my hosting company to ask >>> them >>> if they have a limit enforced. In the meantime though, is there >>> someway I can test this on my own? >>> >>> Again, thank you both for your comments. They are greatly >>> appreciated! >>> >>> Pete >>> >>> >>> On Nov 19, 2008, at 8:12 AM, Jason Rexilius wrote: >>> >>>> A couple of feedback items from the google (off the top of my >>>> head I >>>> cant see anything obvious): >>>> >>>> 1) are you running newer PHP5? from manual: >>>> "G (for Gigabytes; available since PHP 5.1.0)" >>>> >>>> >>>> 2) IIS has som limits if you are on Windows (why, oh why): >>>> IIS7 has a upload limit of 30000000 (about 30mb) >>>> You can change this with the command (for 250mb): >>>> c:\windows\system32\inetsrv\appcmd set config - >>>> section:requestFiltering >>>> -requestLimits.maxAllowedContentLength:262144000 >>>> Or manual define it in: >>>> %windir%\system32\inetsrv\config\applicationhost.config >>>> Add this rule before the </requestFiltering> tag: >>>> <requestLimits maxAllowedContentLength ="262144000" /> >>>> >>>> >>>> 3) There has been reference to session.gc_maxlifetime default value >>>> 1440 >>>> (24min) causing GC to wack session duriung upload and cause >>>> problems. >>>> Not sure on that one.. >>>> >>>> >>>> 4) Also reported issues of MAX_FILE_SIZE hidden form field, and >>>> zlib.output_compression = On in Apache.. >>>> >>>> >>>> 5) Check Apache LimitRequestBody (max size in bytes) >>>> >>>> >>>> 6) Obscure but possible: >>>> "Because some systems send the packets with the headers last (or >>>> the >>>> header packet may be received after some of the data packets), >>>> firewalls >>>> can't filter this traffic based on destination port and address. >>>> Many >>>> firewalls (including iptables) have to be configured to allow >>>> fragments >>>> separately from standard traffic. Unfortunately, it's an all-or- >>>> nothing >>>> thing in these cases, and exploits based on packet fragmentation >>>> have >>>> been a problem in the past (teardrop, boink, etc.). Note that ICMP >>>> may >>>> be used to notify the host (your server) of oncoming fragmentation, >>>> so >>>> you may need to allow ICMP traffic as well." >>>> >>>> The iptables rules for this are as follows: >>>> # allow all fragments >>>> -A INPUT -f -j ACCEPT >>>> # allow icmp traffic >>>> -A INPUT -p icmp -j ACCEPT >>>> >>>> >>>> Most of the above thanks to manual page: >>>> >>>> http://us3.php.net/features.file-upload >>>> >>>> >>>> >>>> Peter Snyder wrote: >>>>> Hello Everyone, >>>>> >>>>> I'm having a problem creating an app for a client who will need to >>>>> upload very large files, around 1GB. I'm running into problems >>>>> though >>>>> with the upload. In an effort to rule out problems, I've boosted >>>>> all >>>>> the normal suspects to absurd levels (see below), but am still >>>>> getting >>>>> problems. If I just watch the uploads in the temp dir I can see >>>>> that >>>>> the server is receiving the uploads correctly, but for some reason >>>>> the >>>>> upload stops at around 40 - 50 MB each time. The browser will >>>>> putter >>>>> on for a while and then say that the server has timed out. >>>>> >>>>> Does anyone have any other ideas for possible problems? I've >>>>> tried >>>>> this on two different servers (clients and my staging one), >>>>> with no >>>>> luck. Any hints anyone could provide would be greatly >>>>> appreciated. >>>>> >>>>> Thanks! >>>>> >>>>> Sincerely, >>>>> Pete Snyder >>>>> >>>>> >>>>> >>>>> >>>>> ----- >>>>> .htaccess file >>>>> php_value memory_limit 2G >>>>> php_value post_max_size 2G >>>>> php_value upload_max_filesize 2G >>>>> php_value max_input_time 144000 >>>>> php_value max_execution_time 144000 >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------ >>>>> ------- >>>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>>> challenge >>>>> Build the coolest Linux based applications with Moblin SDK & win >>>>> great prizes >>>>> Grand prize is a trip for two to an Open Source event anywhere in >>>>> the world >>>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>>> _______________________________________________ >>>>> chiPHPug-discuss mailing list >>>>> chi...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >>>> >>>> ------------------------------------------------------------------- >>>> ------ >>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>> challenge >>>> Build the coolest Linux based applications with Moblin SDK & win >>>> great prizes >>>> Grand prize is a trip for two to an Open Source event anywhere in >>>> the world >>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>> _______________________________________________ >>>> chiPHPug-discuss mailing list >>>> chi...@li... >>>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >>> >>> >>> -------------------------------------------------------------------- >>> ----- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win >>> great prizes >>> Grand prize is a trip for two to an Open Source event anywhere in >>> the world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> chiPHPug-discuss mailing list >>> chi...@li... >>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> >> >> --------------------------------------------------------------------- >> ---- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win >> great prizes >> Grand prize is a trip for two to an Open Source event anywhere in >> the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > > ---------------------------------------------------------------------- > --- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: derby <der...@gm...> - 2008-11-20 06:17:37
|
Ah I missed it. On Nov 18, 2008, at 08:40, Jason Rexilius wrote: > Hey gang, > > Looks like we'll be meeting at 6pm at the Threadless office, 4043 > N Ravenswood ave tomorrow. I need a rough count of how many people > are going to make it. > > I'm going to give a short talk, is anyone else? > > -jason > > ---------------------------------------------------------------------- > --- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: Peter S. <sn...@gm...> - 2008-11-19 19:03:41
|
Hi Wilfried, I agree that HTTP probably (ok, absolutely) isn't the most technically sound way of doing this, but the client needs a dead-simple way for his clients to submit large audio files for editing. So, sadly, HTTP is the best tool for the job. I've tried two flash applets (SWFuploader and FancyUpload), and both work well except they similarly stop sending data after 40 or 50mb. I think this won't get around the problem since they're still submitting data via HTTP POST anyway. Can you, or anyone else for that matter, recommend a flash or java solution that you've had good luck with? Anyone have any idea what sites like MegaUpload or YouTube or othersites that allow users to upload mega amounts of data use? Thanks for your input Wilfred. Maybe you're right and its time to go back to the client and say "are you sure this the way you want to go..." :-) Pete On Nov 19, 2008, at 12:50 PM, Wilfried Schobeiri wrote: > I sent this to the list but it didnt let me: > > You know, part of me wants to say if you're trying to move gigs of > data around via web form, youre doing something wrong. > > Think: > * tmp or /var space could run out, because its getting written to / > var/ > tmp then rebuilt to /tmp > * PHP could run out of memory rebuilding the 1MB /var/tmp chunks (or > so I read) > * You're tying up an httpd instance for who knows how long > * No Fault Tolerance... process manager might kill the process or the > client might time out. > > Plus, HTTP wasn't designed for large file transfers. > > Then again, if its hosted locally, some of this may not apply. > > Try a Java or Flash applet instead, perhaps? Yes, i know... *groan*. > On Nov 19, 2008, at 12:47 , Peter Snyder wrote: > >> Thank you Jason and Arlo for your suggestions. >> >> I checked to make sure that the php settings were reflected in >> phpinfo() and they were, so I don't believe that could be the >> problem. >> >> I also tried rewriting the sizes in .htaccess as 1000000000 instead >> of >> 1G, and tried adding to session.gc_maxlifetime to 14400. The only >> difference I've from doing this is that Firefox gives me a >> "Connection >> Interrupted' error page instead of a "timed out error message". >> >> Both servers I've tested on are linux / apache ones, so thankfully I >> don't need to worry about IIS issues. And there is no MAX_FILE_SIZE >> form field, nor >> >> The only remaining issue I can think of might be with the >> LimitRequestBody setting. I've emailed my hosting company to ask >> them >> if they have a limit enforced. In the meantime though, is there >> someway I can test this on my own? >> >> Again, thank you both for your comments. They are greatly >> appreciated! >> >> Pete >> >> >> On Nov 19, 2008, at 8:12 AM, Jason Rexilius wrote: >> >>> A couple of feedback items from the google (off the top of my head I >>> cant see anything obvious): >>> >>> 1) are you running newer PHP5? from manual: >>> "G (for Gigabytes; available since PHP 5.1.0)" >>> >>> >>> 2) IIS has som limits if you are on Windows (why, oh why): >>> IIS7 has a upload limit of 30000000 (about 30mb) >>> You can change this with the command (for 250mb): >>> c:\windows\system32\inetsrv\appcmd set config - >>> section:requestFiltering >>> -requestLimits.maxAllowedContentLength:262144000 >>> Or manual define it in: >>> %windir%\system32\inetsrv\config\applicationhost.config >>> Add this rule before the </requestFiltering> tag: >>> <requestLimits maxAllowedContentLength ="262144000" /> >>> >>> >>> 3) There has been reference to session.gc_maxlifetime default value >>> 1440 >>> (24min) causing GC to wack session duriung upload and cause >>> problems. >>> Not sure on that one.. >>> >>> >>> 4) Also reported issues of MAX_FILE_SIZE hidden form field, and >>> zlib.output_compression = On in Apache.. >>> >>> >>> 5) Check Apache LimitRequestBody (max size in bytes) >>> >>> >>> 6) Obscure but possible: >>> "Because some systems send the packets with the headers last (or the >>> header packet may be received after some of the data packets), >>> firewalls >>> can't filter this traffic based on destination port and address. >>> Many >>> firewalls (including iptables) have to be configured to allow >>> fragments >>> separately from standard traffic. Unfortunately, it's an all-or- >>> nothing >>> thing in these cases, and exploits based on packet fragmentation >>> have >>> been a problem in the past (teardrop, boink, etc.). Note that ICMP >>> may >>> be used to notify the host (your server) of oncoming fragmentation, >>> so >>> you may need to allow ICMP traffic as well." >>> >>> The iptables rules for this are as follows: >>> # allow all fragments >>> -A INPUT -f -j ACCEPT >>> # allow icmp traffic >>> -A INPUT -p icmp -j ACCEPT >>> >>> >>> Most of the above thanks to manual page: >>> >>> http://us3.php.net/features.file-upload >>> >>> >>> >>> Peter Snyder wrote: >>>> Hello Everyone, >>>> >>>> I'm having a problem creating an app for a client who will need to >>>> upload very large files, around 1GB. I'm running into problems >>>> though >>>> with the upload. In an effort to rule out problems, I've boosted >>>> all >>>> the normal suspects to absurd levels (see below), but am still >>>> getting >>>> problems. If I just watch the uploads in the temp dir I can see >>>> that >>>> the server is receiving the uploads correctly, but for some reason >>>> the >>>> upload stops at around 40 - 50 MB each time. The browser will >>>> putter >>>> on for a while and then say that the server has timed out. >>>> >>>> Does anyone have any other ideas for possible problems? I've tried >>>> this on two different servers (clients and my staging one), with no >>>> luck. Any hints anyone could provide would be greatly appreciated. >>>> >>>> Thanks! >>>> >>>> Sincerely, >>>> Pete Snyder >>>> >>>> >>>> >>>> >>>> ----- >>>> .htaccess file >>>> php_value memory_limit 2G >>>> php_value post_max_size 2G >>>> php_value upload_max_filesize 2G >>>> php_value max_input_time 144000 >>>> php_value max_execution_time 144000 >>>> >>>> >>>> >>>> ------------------------------------------------------------------------- >>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>> challenge >>>> Build the coolest Linux based applications with Moblin SDK & win >>>> great prizes >>>> Grand prize is a trip for two to an Open Source event anywhere in >>>> the world >>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>> _______________________________________________ >>>> chiPHPug-discuss mailing list >>>> chi...@li... >>>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win >>> great prizes >>> Grand prize is a trip for two to an Open Source event anywhere in >>> the world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> chiPHPug-discuss mailing list >>> chi...@li... >>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win >> great prizes >> Grand prize is a trip for two to an Open Source event anywhere in >> the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: Wilfried S. <ws...@de...> - 2008-11-19 18:56:42
|
You know, part of me wants to say if you're trying to move gigs of data around via web form, youre doing something wrong. Think: * tmp or /var space could run out, because its getting written to / var/tmp then rebuilt to /tmp * PHP could run out of memory rebuilding the 1MB /var/tmp chunks (or so I read) * You're tying up an httpd instance for who knows how long * No Fault Tolerance... process manager might kill the process or the client might time out. Plus, HTTP wasn't designed for large file transfers. Then again, if its hosted locally, some of this may not apply. Try a Java or Flash applet instead, perhaps? Yes, i know... *groan*. On Nov 19, 2008, at 11:52 , Anacreo wrote: > Jason, > That's a great review of what the issues could be... I didn't know > about > the IIS config setting and the Firewall info is intriguing. I'm most > inclined to think it's the max time for the script to run. > > Is there anything recorded in the http_error log? > > Alec > > On Wed, Nov 19, 2008 at 8:12 AM, Jason Rexilius > <ja...@ho...>wrote: > >> A couple of feedback items from the google (off the top of my head I >> cant see anything obvious): >> >> 1) are you running newer PHP5? from manual: >> "G (for Gigabytes; available since PHP 5.1.0)" >> >> >> 2) IIS has som limits if you are on Windows (why, oh why): >> IIS7 has a upload limit of 30000000 (about 30mb) >> You can change this with the command (for 250mb): >> c:\windows\system32\inetsrv\appcmd set config - >> section:requestFiltering >> -requestLimits.maxAllowedContentLength:262144000 >> Or manual define it in: >> %windir%\system32\inetsrv\config\applicationhost.config >> Add this rule before the </requestFiltering> tag: >> <requestLimits maxAllowedContentLength ="262144000" /> >> >> >> 3) There has been reference to session.gc_maxlifetime default value >> 1440 >> (24min) causing GC to wack session duriung upload and cause problems. >> Not sure on that one.. >> >> >> 4) Also reported issues of MAX_FILE_SIZE hidden form field, and >> zlib.output_compression = On in Apache.. >> >> >> 5) Check Apache LimitRequestBody (max size in bytes) >> >> >> 6) Obscure but possible: >> "Because some systems send the packets with the headers last (or the >> header packet may be received after some of the data packets), >> firewalls >> can't filter this traffic based on destination port and address. Many >> firewalls (including iptables) have to be configured to allow >> fragments >> separately from standard traffic. Unfortunately, it's an all-or- >> nothing >> thing in these cases, and exploits based on packet fragmentation have >> been a problem in the past (teardrop, boink, etc.). Note that ICMP >> may >> be used to notify the host (your server) of oncoming fragmentation, >> so >> you may need to allow ICMP traffic as well." >> >> The iptables rules for this are as follows: >> # allow all fragments >> -A INPUT -f -j ACCEPT >> # allow icmp traffic >> -A INPUT -p icmp -j ACCEPT >> >> >> Most of the above thanks to manual page: >> >> http://us3.php.net/features.file-upload >> >> >> >> Peter Snyder wrote: >>> Hello Everyone, >>> >>> I'm having a problem creating an app for a client who will need to >>> upload very large files, around 1GB. I'm running into problems >>> though >>> with the upload. In an effort to rule out problems, I've boosted >>> all >>> the normal suspects to absurd levels (see below), but am still >>> getting >>> problems. If I just watch the uploads in the temp dir I can see >>> that >>> the server is receiving the uploads correctly, but for some reason >>> the >>> upload stops at around 40 - 50 MB each time. The browser will >>> putter >>> on for a while and then say that the server has timed out. >>> >>> Does anyone have any other ideas for possible problems? I've tried >>> this on two different servers (clients and my staging one), with no >>> luck. Any hints anyone could provide would be greatly appreciated. >>> >>> Thanks! >>> >>> Sincerely, >>> Pete Snyder >>> >>> >>> >>> >>> ----- >>> .htaccess file >>> php_value memory_limit 2G >>> php_value post_max_size 2G >>> php_value upload_max_filesize 2G >>> php_value max_input_time 144000 >>> php_value max_execution_time 144000 >>> >>> >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >>> Build the coolest Linux based applications with Moblin SDK & win >>> great >> prizes >>> Grand prize is a trip for two to an Open Source event anywhere in >>> the >> world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> chiPHPug-discuss mailing list >>> chi...@li... >>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win >> great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in >> the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: Wilfried S. <ws...@de...> - 2008-11-19 18:50:56
|
I sent this to the list but it didnt let me: You know, part of me wants to say if you're trying to move gigs of data around via web form, youre doing something wrong. Think: * tmp or /var space could run out, because its getting written to /var/ tmp then rebuilt to /tmp * PHP could run out of memory rebuilding the 1MB /var/tmp chunks (or so I read) * You're tying up an httpd instance for who knows how long * No Fault Tolerance... process manager might kill the process or the client might time out. Plus, HTTP wasn't designed for large file transfers. Then again, if its hosted locally, some of this may not apply. Try a Java or Flash applet instead, perhaps? Yes, i know... *groan*. On Nov 19, 2008, at 12:47 , Peter Snyder wrote: > Thank you Jason and Arlo for your suggestions. > > I checked to make sure that the php settings were reflected in > phpinfo() and they were, so I don't believe that could be the problem. > > I also tried rewriting the sizes in .htaccess as 1000000000 instead of > 1G, and tried adding to session.gc_maxlifetime to 14400. The only > difference I've from doing this is that Firefox gives me a "Connection > Interrupted' error page instead of a "timed out error message". > > Both servers I've tested on are linux / apache ones, so thankfully I > don't need to worry about IIS issues. And there is no MAX_FILE_SIZE > form field, nor > > The only remaining issue I can think of might be with the > LimitRequestBody setting. I've emailed my hosting company to ask them > if they have a limit enforced. In the meantime though, is there > someway I can test this on my own? > > Again, thank you both for your comments. They are greatly > appreciated! > > Pete > > > On Nov 19, 2008, at 8:12 AM, Jason Rexilius wrote: > >> A couple of feedback items from the google (off the top of my head I >> cant see anything obvious): >> >> 1) are you running newer PHP5? from manual: >> "G (for Gigabytes; available since PHP 5.1.0)" >> >> >> 2) IIS has som limits if you are on Windows (why, oh why): >> IIS7 has a upload limit of 30000000 (about 30mb) >> You can change this with the command (for 250mb): >> c:\windows\system32\inetsrv\appcmd set config - >> section:requestFiltering >> -requestLimits.maxAllowedContentLength:262144000 >> Or manual define it in: >> %windir%\system32\inetsrv\config\applicationhost.config >> Add this rule before the </requestFiltering> tag: >> <requestLimits maxAllowedContentLength ="262144000" /> >> >> >> 3) There has been reference to session.gc_maxlifetime default value >> 1440 >> (24min) causing GC to wack session duriung upload and cause problems. >> Not sure on that one.. >> >> >> 4) Also reported issues of MAX_FILE_SIZE hidden form field, and >> zlib.output_compression = On in Apache.. >> >> >> 5) Check Apache LimitRequestBody (max size in bytes) >> >> >> 6) Obscure but possible: >> "Because some systems send the packets with the headers last (or the >> header packet may be received after some of the data packets), >> firewalls >> can't filter this traffic based on destination port and address. Many >> firewalls (including iptables) have to be configured to allow >> fragments >> separately from standard traffic. Unfortunately, it's an all-or- >> nothing >> thing in these cases, and exploits based on packet fragmentation have >> been a problem in the past (teardrop, boink, etc.). Note that ICMP >> may >> be used to notify the host (your server) of oncoming fragmentation, >> so >> you may need to allow ICMP traffic as well." >> >> The iptables rules for this are as follows: >> # allow all fragments >> -A INPUT -f -j ACCEPT >> # allow icmp traffic >> -A INPUT -p icmp -j ACCEPT >> >> >> Most of the above thanks to manual page: >> >> http://us3.php.net/features.file-upload >> >> >> >> Peter Snyder wrote: >>> Hello Everyone, >>> >>> I'm having a problem creating an app for a client who will need to >>> upload very large files, around 1GB. I'm running into problems >>> though >>> with the upload. In an effort to rule out problems, I've boosted >>> all >>> the normal suspects to absurd levels (see below), but am still >>> getting >>> problems. If I just watch the uploads in the temp dir I can see >>> that >>> the server is receiving the uploads correctly, but for some reason >>> the >>> upload stops at around 40 - 50 MB each time. The browser will >>> putter >>> on for a while and then say that the server has timed out. >>> >>> Does anyone have any other ideas for possible problems? I've tried >>> this on two different servers (clients and my staging one), with no >>> luck. Any hints anyone could provide would be greatly appreciated. >>> >>> Thanks! >>> >>> Sincerely, >>> Pete Snyder >>> >>> >>> >>> >>> ----- >>> .htaccess file >>> php_value memory_limit 2G >>> php_value post_max_size 2G >>> php_value upload_max_filesize 2G >>> php_value max_input_time 144000 >>> php_value max_execution_time 144000 >>> >>> >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win >>> great prizes >>> Grand prize is a trip for two to an Open Source event anywhere in >>> the world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> chiPHPug-discuss mailing list >>> chi...@li... >>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win >> great prizes >> Grand prize is a trip for two to an Open Source event anywhere in >> the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: Peter S. <sn...@gm...> - 2008-11-19 18:48:10
|
Thank you Jason and Arlo for your suggestions. I checked to make sure that the php settings were reflected in phpinfo() and they were, so I don't believe that could be the problem. I also tried rewriting the sizes in .htaccess as 1000000000 instead of 1G, and tried adding to session.gc_maxlifetime to 14400. The only difference I've from doing this is that Firefox gives me a "Connection Interrupted' error page instead of a "timed out error message". Both servers I've tested on are linux / apache ones, so thankfully I don't need to worry about IIS issues. And there is no MAX_FILE_SIZE form field, nor The only remaining issue I can think of might be with the LimitRequestBody setting. I've emailed my hosting company to ask them if they have a limit enforced. In the meantime though, is there someway I can test this on my own? Again, thank you both for your comments. They are greatly appreciated! Pete On Nov 19, 2008, at 8:12 AM, Jason Rexilius wrote: > A couple of feedback items from the google (off the top of my head I > cant see anything obvious): > > 1) are you running newer PHP5? from manual: > "G (for Gigabytes; available since PHP 5.1.0)" > > > 2) IIS has som limits if you are on Windows (why, oh why): > IIS7 has a upload limit of 30000000 (about 30mb) > You can change this with the command (for 250mb): > c:\windows\system32\inetsrv\appcmd set config - > section:requestFiltering > -requestLimits.maxAllowedContentLength:262144000 > Or manual define it in: > %windir%\system32\inetsrv\config\applicationhost.config > Add this rule before the </requestFiltering> tag: > <requestLimits maxAllowedContentLength ="262144000" /> > > > 3) There has been reference to session.gc_maxlifetime default value > 1440 > (24min) causing GC to wack session duriung upload and cause problems. > Not sure on that one.. > > > 4) Also reported issues of MAX_FILE_SIZE hidden form field, and > zlib.output_compression = On in Apache.. > > > 5) Check Apache LimitRequestBody (max size in bytes) > > > 6) Obscure but possible: > "Because some systems send the packets with the headers last (or the > header packet may be received after some of the data packets), > firewalls > can't filter this traffic based on destination port and address. Many > firewalls (including iptables) have to be configured to allow > fragments > separately from standard traffic. Unfortunately, it's an all-or- > nothing > thing in these cases, and exploits based on packet fragmentation have > been a problem in the past (teardrop, boink, etc.). Note that ICMP may > be used to notify the host (your server) of oncoming fragmentation, so > you may need to allow ICMP traffic as well." > > The iptables rules for this are as follows: > # allow all fragments > -A INPUT -f -j ACCEPT > # allow icmp traffic > -A INPUT -p icmp -j ACCEPT > > > Most of the above thanks to manual page: > > http://us3.php.net/features.file-upload > > > > Peter Snyder wrote: >> Hello Everyone, >> >> I'm having a problem creating an app for a client who will need to >> upload very large files, around 1GB. I'm running into problems >> though >> with the upload. In an effort to rule out problems, I've boosted all >> the normal suspects to absurd levels (see below), but am still >> getting >> problems. If I just watch the uploads in the temp dir I can see that >> the server is receiving the uploads correctly, but for some reason >> the >> upload stops at around 40 - 50 MB each time. The browser will putter >> on for a while and then say that the server has timed out. >> >> Does anyone have any other ideas for possible problems? I've tried >> this on two different servers (clients and my staging one), with no >> luck. Any hints anyone could provide would be greatly appreciated. >> >> Thanks! >> >> Sincerely, >> Pete Snyder >> >> >> >> >> ----- >> .htaccess file >> php_value memory_limit 2G >> php_value post_max_size 2G >> php_value upload_max_filesize 2G >> php_value max_input_time 144000 >> php_value max_execution_time 144000 >> >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win >> great prizes >> Grand prize is a trip for two to an Open Source event anywhere in >> the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> chiPHPug-discuss mailing list >> chi...@li... >> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: Anacreo <an...@gm...> - 2008-11-19 17:52:17
|
Jason, That's a great review of what the issues could be... I didn't know about the IIS config setting and the Firewall info is intriguing. I'm most inclined to think it's the max time for the script to run. Is there anything recorded in the http_error log? Alec On Wed, Nov 19, 2008 at 8:12 AM, Jason Rexilius <ja...@ho...>wrote: > A couple of feedback items from the google (off the top of my head I > cant see anything obvious): > > 1) are you running newer PHP5? from manual: > "G (for Gigabytes; available since PHP 5.1.0)" > > > 2) IIS has som limits if you are on Windows (why, oh why): > IIS7 has a upload limit of 30000000 (about 30mb) > You can change this with the command (for 250mb): > c:\windows\system32\inetsrv\appcmd set config -section:requestFiltering > -requestLimits.maxAllowedContentLength:262144000 > Or manual define it in: > %windir%\system32\inetsrv\config\applicationhost.config > Add this rule before the </requestFiltering> tag: > <requestLimits maxAllowedContentLength ="262144000" /> > > > 3) There has been reference to session.gc_maxlifetime default value 1440 > (24min) causing GC to wack session duriung upload and cause problems. > Not sure on that one.. > > > 4) Also reported issues of MAX_FILE_SIZE hidden form field, and > zlib.output_compression = On in Apache.. > > > 5) Check Apache LimitRequestBody (max size in bytes) > > > 6) Obscure but possible: > "Because some systems send the packets with the headers last (or the > header packet may be received after some of the data packets), firewalls > can't filter this traffic based on destination port and address. Many > firewalls (including iptables) have to be configured to allow fragments > separately from standard traffic. Unfortunately, it's an all-or-nothing > thing in these cases, and exploits based on packet fragmentation have > been a problem in the past (teardrop, boink, etc.). Note that ICMP may > be used to notify the host (your server) of oncoming fragmentation, so > you may need to allow ICMP traffic as well." > > The iptables rules for this are as follows: > # allow all fragments > -A INPUT -f -j ACCEPT > # allow icmp traffic > -A INPUT -p icmp -j ACCEPT > > > Most of the above thanks to manual page: > > http://us3.php.net/features.file-upload > > > > Peter Snyder wrote: > > Hello Everyone, > > > > I'm having a problem creating an app for a client who will need to > > upload very large files, around 1GB. I'm running into problems though > > with the upload. In an effort to rule out problems, I've boosted all > > the normal suspects to absurd levels (see below), but am still getting > > problems. If I just watch the uploads in the temp dir I can see that > > the server is receiving the uploads correctly, but for some reason the > > upload stops at around 40 - 50 MB each time. The browser will putter > > on for a while and then say that the server has timed out. > > > > Does anyone have any other ideas for possible problems? I've tried > > this on two different servers (clients and my staging one), with no > > luck. Any hints anyone could provide would be greatly appreciated. > > > > Thanks! > > > > Sincerely, > > Pete Snyder > > > > > > > > > > ----- > > .htaccess file > > php_value memory_limit 2G > > php_value post_max_size 2G > > php_value upload_max_filesize 2G > > php_value max_input_time 144000 > > php_value max_execution_time 144000 > > > > > > > > ------------------------------------------------------------------------- > > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > > Build the coolest Linux based applications with Moblin SDK & win great > prizes > > Grand prize is a trip for two to an Open Source event anywhere in the > world > > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > _______________________________________________ > > chiPHPug-discuss mailing list > > chi...@li... > > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > |
|
From: Domenic R. <rod...@ya...> - 2008-11-19 16:55:47
|
I thought of that...but changing the address doesn't do anything. I tried the current one because gmail said mailed-by was: vps.homesalerelief.com Thanks for taking a look though. --- On Wed, 11/19/08, Adam Larsen <apl...@gm...> wrote: > From: Adam Larsen <apl...@gm...> > Subject: Re: [chiPHPug-discuss] PHP Mailer/Yahoo Problems > To: "'Discussions of PHP-related topics among members of the Chicago PHP User's Group.'" <chi...@li...> > Date: Wednesday, November 19, 2008, 10:24 AM > I see that the From: is this -- in...@vp... > But the message-id is this -- > dad...@fr... > > Is Yahoo! pretty anal about a message from a particular > domain trying to > appear as if from a different domain? I don't have > experience with their > particular filter. > > Adam > > -----Original Message----- > From: Wilfried Schobeiri [mailto:ws...@de...] > Sent: Wednesday, November 19, 2008 9:35 AM > To: Discussions of PHP-related topics among members of the > Chicago PHP > User's Group. > Subject: Re: [chiPHPug-discuss] PHP Mailer/Yahoo Problems > > Domenic, > > look into Domain Keys and DKIM. Best bet for solving this, > I've found, > is to make sure your outbound messages get signed by a > milter or such > (if you're using sendmail). > > Good luck, this can be a huge PITA depending on your MTA. > > >> Authentication-Results: > mta100.mail.ac4.yahoo.com > >> from=vps.homesalerelief.com; domainkeys=neutral > (no sig) > > > Wilfried > > > On Nov 19, 2008, at 09:30 , Domenic Roti wrote: > > > Hey everyone, I've got a problem thats been > driving me crazy and was > > wondering if anyone else might have experienced this > in the past. > > I'm on a clients server and am trying to send out > a confirmation > > email after registering for the site. The problem I > have is that > > Yahoo always blocks it, not just sends it to the SPAM > folder but > > completely blocks it. > > > > I have a GMAIL account that also forwards to my yahoo > account, and > > my GMAIL account receives the emails just fine. I > first started by > > using the mail function, but when I did that the > forwarded email > > wouldn't even go though to my yahoo account. > > > > So I switched to phpmailer and well it still > doesn't go to my yahoo > > account - GMAIL atleast forwards it. My code looks > like this: > > > > > > date_default_timezone_set('America/Chicago'); > > > //date_default_timezone_set(date_default_timezone_get()); > > > > include_once('class.phpmailer.php'); > > > > $mail = new PHPMailer(); > > $body = > $mail->getFile('/home/freeandc/public_html/ > > ConfirmationEmail.html'); > > $body = > eregi_replace("[\]",'',$body); > > > > $mail->IsSendmail(); // telling the class to use > SendMail transport > > > > $mail->From = > "in...@vp..."; > > $mail->FromName = "Mortgage Relief > Formula"; > > > > $mail->Subject = $subject; > > > > $mail->AltBody = "To view the message, > please use an HTML > > compatible email viewer!"; // optional, comment > out and test > > > > $mail->MsgHTML($body); > > > > > $mail->AddAddress("Dom...@gm...", > "Domenic Roti"); > > > > if(!$mail->Send()) { > > echo "Mailer Error: " . > $mail->ErrorInfo; > > } else { > > echo "Message sent!"; > > } > > > > > > Here are the headers that I get from the forwarded > email: > > > > > <domenic.roti+caf_=rodstir656=yah...@gm...> > > Authentication-Results: mta100.mail.ac4.yahoo.com > > from=vps.homesalerelief.com; domainkeys=neutral (no > sig) > > Received: from 72.14.220.158 (EHLO > fg-out-1718.google.com) > > (72.14.220.158) by mta100.mail.ac4.yahoo.com with > SMTP; Wed, 19 Nov > > 2008 07:20:57 -0800 > > Received: by fg-out-1718.google.com with SMTP id > l27so15628fgb.33 > > for <rod...@ya...>; Wed, 19 Nov 2008 > 07:20:56 -0800 (PST) > > Received: by 10.187.239.18 with SMTP id > q18mr219346far. > > 16.1227108056694; Wed, 19 Nov 2008 07:20:56 -0800 > (PST) > > Delivered-To: dom...@gm... > > Received: by 10.187.208.5 with SMTP id > k5cs253157faq; Wed, 19 > Nov > > 2008 07:20:55 -0800 (PST) > > Received: by 10.64.180.15 with SMTP id > c15mr1167647qbf. > > 80.1227108054218; Wed, 19 Nov 2008 07:20:54 -0800 > (PST) > > Return-Path: <no...@vp...> > > Received: from vps.homesalerelief.com > (vps.homesalerelief.com > > > [69.4.237.250]) by mx.google.com with ESMTP id > k29si11055191qba. > > 7.2008.11.19.07.20.53; Wed, 19 Nov 2008 07:20:54 -0800 > (PST) > > Received-SPF: pass (google.com: best guess record > for > domain of no...@vp... > > designates 69.4.237.250 as permitted sender) > client-ip=69.4.237.250; > > Authentication-Results: mx.google.com; spf=pass > (google.com: > best > > guess record for domain of > no...@vp... designates > > 69.4.237.250 as permitted sender) > smtp.mail=no...@vp... > > Received: from nobody by vps.homesalerelief.com with > local > (Exim > > 4.69) (envelope-from > <no...@vp...>) id > > 1L2orN-0000Wa-IM for Dom...@gm...; Wed, 19 > Nov 2008 > > 09:20:53 -0600 > > Date: Wed, 19 Nov 2008 09:20:53 -0600 > > To: Domenic Roti <Dom...@gm...> > > From: > > Mortgage Relief Formula > <in...@vp...> > > Add sender to Contacts > > Subject: > > Message-ID: > <dad...@fr...> > > MIME-Version: 1.0 > > Content-Type: multipart/alternative; > > > boundary="b1_dadbd41ef9512a26b9627d6fe560e8f2" > > Content-Length: 384 > > > > > > > > Does anyone have any idea what might be causing this? > > > > > ------------------------------------------------------------------------- > > This SF.Net email is sponsored by the Moblin Your Move > Developer's > > challenge > > Build the coolest Linux based applications with Moblin > SDK & win > > great prizes > > Grand prize is a trip for two to an Open Source event > anywhere in > > the world > > > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > _______________________________________________ > > chiPHPug-discuss mailing list > > chi...@li... > > > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move > Developer's challenge > Build the coolest Linux based applications with Moblin SDK > & win great > prizes > Grand prize is a trip for two to an Open Source event > anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move > Developer's challenge > Build the coolest Linux based applications with Moblin SDK > & win great prizes > Grand prize is a trip for two to an Open Source event > anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
|
From: Domenic R. <rod...@ya...> - 2008-11-19 16:41:53
|
Thanks for your response, I thought it might be domain keys - I simply don't know that much about they're implementation and I don't run this server so I was hoping it wasn't. I'm going to have to do some more research into it - Thank You. --- On Wed, 11/19/08, Wilfried Schobeiri <ws...@de...> wrote: > From: Wilfried Schobeiri <ws...@de...> > Subject: Re: [chiPHPug-discuss] PHP Mailer/Yahoo Problems > To: "Discussions of PHP-related topics among members of the Chicago PHP User's Group." <chi...@li...> > Date: Wednesday, November 19, 2008, 9:34 AM > Domenic, > > look into Domain Keys and DKIM. Best bet for solving this, > I've found, > is to make sure your outbound messages get signed by a > milter or such > (if you're using sendmail). > > Good luck, this can be a huge PITA depending on your MTA. > > >> Authentication-Results: > mta100.mail.ac4.yahoo.com > >> from=vps.homesalerelief.com; domainkeys=neutral > (no sig) > > > Wilfried > > > On Nov 19, 2008, at 09:30 , Domenic Roti wrote: > > > Hey everyone, I've got a problem thats been > driving me crazy and was > > wondering if anyone else might have experienced this > in the past. > > I'm on a clients server and am trying to send out > a confirmation > > email after registering for the site. The problem I > have is that > > Yahoo always blocks it, not just sends it to the SPAM > folder but > > completely blocks it. > > > > I have a GMAIL account that also forwards to my yahoo > account, and > > my GMAIL account receives the emails just fine. I > first started by > > using the mail function, but when I did that the > forwarded email > > wouldn't even go though to my yahoo account. > > > > So I switched to phpmailer and well it still > doesn't go to my yahoo > > account - GMAIL atleast forwards it. My code looks > like this: > > > > > > date_default_timezone_set('America/Chicago'); > > > //date_default_timezone_set(date_default_timezone_get()); > > > > include_once('class.phpmailer.php'); > > > > $mail = new PHPMailer(); > > $body = > $mail->getFile('/home/freeandc/public_html/ > > ConfirmationEmail.html'); > > $body = > eregi_replace("[\]",'',$body); > > > > $mail->IsSendmail(); // telling the class to use > SendMail transport > > > > $mail->From = > "in...@vp..."; > > $mail->FromName = "Mortgage Relief > Formula"; > > > > $mail->Subject = $subject; > > > > $mail->AltBody = "To view the message, > please use an HTML > > compatible email viewer!"; // optional, comment > out and test > > > > $mail->MsgHTML($body); > > > > > $mail->AddAddress("Dom...@gm...", > "Domenic Roti"); > > > > if(!$mail->Send()) { > > echo "Mailer Error: " . > $mail->ErrorInfo; > > } else { > > echo "Message sent!"; > > } > > > > > > Here are the headers that I get from the forwarded > email: > > > > > <domenic.roti+caf_=rodstir656=yah...@gm...> > > Authentication-Results: mta100.mail.ac4.yahoo.com > > from=vps.homesalerelief.com; domainkeys=neutral (no > sig) > > Received: from 72.14.220.158 (EHLO > fg-out-1718.google.com) > > (72.14.220.158) by mta100.mail.ac4.yahoo.com with > SMTP; Wed, 19 Nov > > 2008 07:20:57 -0800 > > Received: by fg-out-1718.google.com with SMTP id > l27so15628fgb.33 > > for <rod...@ya...>; Wed, 19 Nov 2008 > 07:20:56 -0800 (PST) > > Received: by 10.187.239.18 with SMTP id > q18mr219346far. > > 16.1227108056694; Wed, 19 Nov 2008 07:20:56 -0800 > (PST) > > Delivered-To: dom...@gm... > > Received: by 10.187.208.5 with SMTP id > k5cs253157faq; Wed, 19 Nov > > 2008 07:20:55 -0800 (PST) > > Received: by 10.64.180.15 with SMTP id > c15mr1167647qbf. > > 80.1227108054218; Wed, 19 Nov 2008 07:20:54 -0800 > (PST) > > Return-Path: <no...@vp...> > > Received: from vps.homesalerelief.com > (vps.homesalerelief.com > > [69.4.237.250]) by mx.google.com with ESMTP id > k29si11055191qba. > > 7.2008.11.19.07.20.53; Wed, 19 Nov 2008 07:20:54 -0800 > (PST) > > Received-SPF: pass (google.com: best guess record > for domain of no...@vp... > > designates 69.4.237.250 as permitted sender) > client-ip=69.4.237.250; > > Authentication-Results: mx.google.com; spf=pass > (google.com: best > > guess record for domain of > no...@vp... designates > > 69.4.237.250 as permitted sender) > smtp.mail=no...@vp... > > Received: from nobody by vps.homesalerelief.com with > local (Exim > > 4.69) (envelope-from > <no...@vp...>) id > > 1L2orN-0000Wa-IM for Dom...@gm...; Wed, 19 > Nov 2008 > > 09:20:53 -0600 > > Date: Wed, 19 Nov 2008 09:20:53 -0600 > > To: Domenic Roti <Dom...@gm...> > > From: > > Mortgage Relief Formula > <in...@vp...> > > Add sender to Contacts > > Subject: > > Message-ID: > <dad...@fr...> > > MIME-Version: 1.0 > > Content-Type: multipart/alternative; > > > boundary="b1_dadbd41ef9512a26b9627d6fe560e8f2" > > Content-Length: 384 > > > > > > > > Does anyone have any idea what might be causing this? > > > > > ------------------------------------------------------------------------- > > This SF.Net email is sponsored by the Moblin Your Move > Developer's > > challenge > > Build the coolest Linux based applications with Moblin > SDK & win > > great prizes > > Grand prize is a trip for two to an Open Source event > anywhere in > > the world > > > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > _______________________________________________ > > chiPHPug-discuss mailing list > > chi...@li... > > > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move > Developer's challenge > Build the coolest Linux based applications with Moblin SDK > & win great prizes > Grand prize is a trip for two to an Open Source event > anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > chiPHPug-discuss mailing list > chi...@li... > https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss |
149 messages has been excluded from this view by a project administrator.
