PHP shell exec not working in HTML browser but working on cmd prompt

Question

I am running PHP 5.2.14 on Apache/2.2.16 (Win32) and I have a script to run a shell command, which when tested in the command prompt works well but in browser mode (html), it doesn't.

Scripts:

mybatfile.bat

REM ...
REM process some folder details
REM code which does not work in browser mode but works in cmd mode
C:/somfolder/bin/mysqldump -u abc -pabcdef --result-file="C:/Apache22/somfolder/DBbackup/DBbackup.%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%.sql" --dump-date  --log-error="C:/Apache22/somfolder/DBbackup/DBbackup.%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%.log" dbname > dboutputresult.txt

REM process result of savedfile

calltobatfile.php

//process some folder information
$file = file_get_contents($folderroot."/exec/mybatfile.bat");
//var_dump($file);
    $strarr = explode("\n", $file);
    foreach($strarr as $line){
      if(strlen($line)>1){
        var_dump("line: ".$line."\n"); 
        $output = shell_exec($line);
        print_r($output);
     }
   }

//process result of savedfile additional information

What can I try next?

does the webserver userid have the rights to do whatever is being done in that batch file? working from cli but not from webserver is usually a permissions/path problem. — Marc B
– Marc B, Commented Oct 22, 2012 at 16:20
thanks for the suggestions. It was definitely a permission issue as it now works after tweaking with the folder permissions. — luhfluh
– luhfluh, Commented Oct 22, 2012 at 17:18

Jacek Sokolowski · Accepted Answer · 2012-10-22 16:25:26Z

3

Check the permissions to run it as a server. You can run this as owner, but there can be no possibilities to run it as other user - in your example as apache.

answered Oct 22, 2012 at 16:25

Jacek Sokolowski

5974 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cijagani · Accepted Answer · 2015-12-30 18:13:22Z

2

here is a my code and its working fine.

$result = mysqli_query($mysqli_link,'SHOW VARIABLES LIKE \'%basedir%\';');
    $row = mysqli_fetch_array($result);
    $pathtodump = "".$row['Value']."/bin/mysqldump";    
    $command= "$pathtodump -h " . $db_host . " -u " . $db_user . " -p".$db_pass. " " . $db_dbname . "> filename.sql";
    exec($command);

Note try to give mysqldump.exe file name with full path

answered Dec 30, 2015 at 18:13

cijagani

5235 silver badges23 bronze badges

Comments

Josejulio · Accepted Answer · 2012-10-22 16:22:01Z

1

Maybe is a permission related issue? In your command line you may be using other User rather than the web one which may not have the required permissions to execute or write in C:/Apache22/somfolder/DBbackup/ or dboutputresult.txt

answered Oct 22, 2012 at 16:22

Josejulio

1,2941 gold badge17 silver badges32 bronze badges

Collectives™ on Stack Overflow

PHP shell exec not working in HTML browser but working on cmd prompt

Scripts:

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Scripts:

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related