PHP / MySQL Report Help

jpenn44 · 07-20-2011, 04:28 PM

Ok..i'm fighting through this, and I am to the point of it unpacking the .tar file, and I get the following...

Please wait...

Command: tar xzf "\\boswinfs03\home\users\web\b457\whl.jpenn44\loho \reports\reports.tar.gz" 2>&1:

Warning: passthru() [function.passthru]: Unable to fork [tar xzf "\\boswinfs03\home\users\web\b457\whl.jpenn44\loho \reports\reports.tar.gz" 2>&1] in \\boswinfs03\home\users\web\b457\whl.jpenn44\loho\ reports\unpackreports.php on line 51

Successfully unpacked the reports.tar.gz file...

Valid lines = 0, Invalid lines = 0, Inserts = 0, Updates = 0, Errors = 0, Success = 0
After finishing the job successfully, you should delete archive file, reports file and unpack script

Now....I'm working under the assumption that this is possibly a rights issue? But I've tried running it passing it my admin contact info. The MySQL user has full DB rights... so, just wondering if anybody sees anything obvious that I am missing.

Thanks for any help.

hbomb · 07-21-2011, 07:27 AM

If you look a few threads below, I was having a somewhat related problem. It could be a problem with your paths. Also have you checked your folder permissions. Might need to be 755 or 777.

jpenn44 · 07-21-2011, 09:36 AM

Yes, I searched the forums and saw your thread, and my issue is unique from yours. Folder permissions are fine, already chmod to 755. I have a PHP message board that runs fine.

As I said...I'm assuming it's some type of user permission, but i'm stumped right now. Anyone help please??

hbomb · 07-21-2011, 11:14 AM

Quote:

Originally Posted by jpenn44

Yes, I searched the forums and saw your thread, and my issue is unique from yours. Folder permissions are fine, already chmod to 755. I have a PHP message board that runs fine.

As I said...I'm assuming it's some type of user permission, but i'm stumped right now. Anyone help please??

Can you post your dbconfig file content, and your .htacess for this folder?
Thanks,

jpenn44 · 07-22-2011, 05:14 PM

<?php
$db_host = "********.mysql.com"; // MySQL Hostname, usually localhost
$db_name = "nabl_reports_1"; // MySQL Database
$db_user = "*****"; // MySQL Username
$db_pass = "******"; // MySQL Password
$db_port = "3306"; // MySQL Port, usually 3306
$db_table = "nabl_league_reports"; // Name of table for reports data
$reports_url = "http://www.ootp-loho.com/reports"; // URL of reports web space, for example: http://www.your-domain.com/your-league/reports/
$reports_url_path = "/reports"; // Path from document root to reports folder, i.e. if the URL is http://www.your-domain.com/your-league/reports/, the path is /your-league/reports/
?>

Not sure how the .htaccess is relevant... and in actuality...at this point I get a IIS error when .htaccess is in the directory. I have to rename it. But it's not even getting to that point I don't believe

RewriteEngine on
RewriteOptions MaxRedirects=1

RewriteRule ^box_scores/(.*)\.html$ '/reports/index.php?type=e&name=$1' [L]
RewriteRule ^coaches/(.*)\.html$ '/reports/index.php?type=g&name=$1' [L]
RewriteRule ^game_logs/(.*)\.html$ '/reports/index.php?type=f&name=$1' [L]
RewriteRule ^history/(.*)\.html$ '/reports/index.php?type=h&name=$1' [L]
RewriteRule ^leagues/(.*)\.html$ '/reports/index.php?type=b&name=$1' [L]
RewriteRule ^players/(.*)\.html$ '/reports/index.php?type=d&name=$1' [L]
RewriteRule ^teams/(.*)\.html$ '/reports/index.php?type=c&name=$1' [L]

jpenn44 · 08-01-2011, 05:03 PM

ok..have worked with my web host to get my configuration setup... FYI..anybody have a fork error on passthru(), it's a php config error in your setup...

So, now I get pass that, and end up with:

Please wait...

Command: tar xzf "\\boswinfs03\home\users\web\b457\whl.jpenn44\loho \reports/reports.tar.gz" 2>&1:

The unpack command returned $retval, looks like it was not completely successful.

1
Valid lines = 0, Invalid lines = 0, Inserts = 0, Updates = 0, Errors = 0, Success = 0
After finishing the job successfully, you should delete archive file, reports file and unpack script

FYI...the 1 above Valid lines is the $retval, added it to troubleshoot....
What's really odd is that I can then run the Delete, and it removes the tar and php files. Which tells me the path is correct???

Anybody? Please help? I've been fighting this issue for awhile, slowly making progress...could really use someone with PHP knowledge and their help.

07-20-2011, 04:28 PM	#1
jpenn44 Minors (Single A) Join Date: Jan 2002 Posts: 81	PHP / MySQL Report Help Ok..i'm fighting through this, and I am to the point of it unpacking the .tar file, and I get the following... Please wait... Command: tar xzf "\\boswinfs03\home\users\web\b457\whl.jpenn44\loho \reports\reports.tar.gz" 2>&1: Warning: passthru() [function.passthru]: Unable to fork [tar xzf "\\boswinfs03\home\users\web\b457\whl.jpenn44\loho \reports\reports.tar.gz" 2>&1] in \\boswinfs03\home\users\web\b457\whl.jpenn44\loho\ reports\unpackreports.php on line 51 Successfully unpacked the reports.tar.gz file... Valid lines = 0, Invalid lines = 0, Inserts = 0, Updates = 0, Errors = 0, Success = 0 After finishing the job successfully, you should delete archive file, reports file and unpack script Now....I'm working under the assumption that this is possibly a rights issue? But I've tried running it passing it my admin contact info. The MySQL user has full DB rights... so, just wondering if anybody sees anything obvious that I am missing. Thanks for any help.

08-01-2011, 05:03 PM	#6
jpenn44 Minors (Single A) Join Date: Jan 2002 Posts: 81	Next Step ok..have worked with my web host to get my configuration setup... FYI..anybody have a fork error on passthru(), it's a php config error in your setup... So, now I get pass that, and end up with: Please wait... Command: tar xzf "\\boswinfs03\home\users\web\b457\whl.jpenn44\loho \reports/reports.tar.gz" 2>&1: The unpack command returned $retval, looks like it was not completely successful. 1 Valid lines = 0, Invalid lines = 0, Inserts = 0, Updates = 0, Errors = 0, Success = 0 After finishing the job successfully, you should delete archive file, reports file and unpack script FYI...the 1 above Valid lines is the $retval, added it to troubleshoot.... What's really odd is that I can then run the Delete, and it removes the tar and php files. Which tells me the path is correct??? Anybody? Please help? I've been fighting this issue for awhile, slowly making progress...could really use someone with PHP knowledge and their help.

07-21-2011, 07:27 AM	#2
hbomb Minors (Double A) Join Date: Jul 2008 Location: Toronto Canada Posts: 155	If you look a few threads below, I was having a somewhat related problem. It could be a problem with your paths. Also have you checked your folder permissions. Might need to be 755 or 777.

07-21-2011, 09:36 AM	#3
jpenn44 Minors (Single A) Join Date: Jan 2002 Posts: 81	Yes, I searched the forums and saw your thread, and my issue is unique from yours. Folder permissions are fine, already chmod to 755. I have a PHP message board that runs fine. As I said...I'm assuming it's some type of user permission, but i'm stumped right now. Anyone help please??

07-22-2011, 05:14 PM	#5
jpenn44 Minors (Single A) Join Date: Jan 2002 Posts: 81	<?php $db_host = "******.mysql.com"; // MySQL Hostname, usually localhost $db_name = "nabl_reports_1"; // MySQL Database $db_user = "*"; // MySQL Username $db_pass = "***"; // MySQL Password $db_port = "3306"; // MySQL Port, usually 3306 $db_table = "nabl_league_reports"; // Name of table for reports data $reports_url = "http://www.ootp-loho.com/reports"; // URL of reports web space, for example: http://www.your-domain.com/your-league/reports/ $reports_url_path = "/reports"; // Path from document root to reports folder, i.e. if the URL is http://www.your-domain.com/your-league/reports/, the path is /your-league/reports/ ?> Not sure how the .htaccess is relevant... and in actuality...at this point I get a IIS error when .htaccess is in the directory. I have to rename it. But it's not even getting to that point I don't believe RewriteEngine on RewriteOptions MaxRedirects=1 RewriteRule ^box_scores/(.)\.html$ '/reports/index.php?type=e&name=$1' [L] RewriteRule ^coaches/(.)\.html$ '/reports/index.php?type=g&name=$1' [L] RewriteRule ^game_logs/(.)\.html$ '/reports/index.php?type=f&name=$1' [L] RewriteRule ^history/(.)\.html$ '/reports/index.php?type=h&name=$1' [L] RewriteRule ^leagues/(.)\.html$ '/reports/index.php?type=b&name=$1' [L] RewriteRule ^players/(.)\.html$ '/reports/index.php?type=d&name=$1' [L] RewriteRule ^teams/(.)\.html$ '/reports/index.php?type=c&name=$1' [L]