[sqr-users] sqr and php

["Kim Prisk & Joyce Fennell" <k.prisk@auckland.ac.nz>]

Colleagues,

I am using php and sqr to produce a pdf file.
I have a compiled sqt file for a report.
Using the php 'sytem' command in a php script,  I call sqrwt.exe together with 
the appropriate parameters to connect to our database and output the report in 
pdf format. This script would be normally invoked from a previous script or web 
page.
This used to work OK on a test web server using IIS5. I am aiming to migrate 
from an older server where an (almost!) identical setup is running OK.

Over a period of several months the Windows 2000 test server has had some MS 
updates applied, and additional software installed.
Now I cannot get a pdf output file to generate.
The sqrwt task runs when called by one page calling the script where the system 
call is,  but the task never terminates.

Testing done so far:
1.    I can run the php script page from the dos command prompt (console) and 
the pdf is produced OK. This proves that all sqrwt parameters are correct. I am 
logged in as administrator at this time.
2.    I have altered the web page and directory properties to run under 
administrator user credentials. This does not fix the problem.
3.    I have put the sqrwt and parameters in a batch file, and called the batch 
file using the php system command. Result same as 1. above from the command 
console, but sqrwt still 'hangs' when the web page/script is called from 
another.
4.    I have put a simple dos command in the batch file (dir > test.txt). This 
gets written to the sqrwt  output directory OK.
5.    I have checked permissions on all directories for appropriate rights for 
the IUSR account.
6.    As I have a setup as described above running on another server I have 
compared permissions between the 2 systems.

Any suggestions greatfully received.
Regards

Kim Prisk
Universty of Auckland
k dot prisk at auckland dot ac dot nz

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users