Re: [sqr-users] sqr and php

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

This problem is now resolved.
It was caused by the lack of read permission on the windows directory, and
as a consequence, sqr being unable to find the sqr.ini file.
The way sqr is deployed in our case prevents error messages (such that one
would get if running sqrt 'directly') being seen.
Thanks to those who offered suggestions for a fix.
Cheers
KIM
----- Original Message ----- 
> > 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
> ----------------------------------------------------------------------
> Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
> Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>

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