Thread: problems compiling scripts.I'm near suicide
Hi. I have been compiling scripts for two days, and cannot resolve the problem with postgres. (working with solaris 2.7) I don't know if the problem is in the compilation because it isn't causes errors. I am compiling with: gcc x.c y.c z.c -o xyzcgi -L/usr/local/pgsql/lib -R/usr/local/pgsql/lib -lpq mv xyzcgi /export/home/httpd/cgi-bin/pruebacgi When the script is executed from a html page, returned this error to the navigator: Premature end of script headers: /export/home/httpd/cgi-bin/xyzcgi In the log file of Apache I can see the same message and other: Internal Server Error Premature end of script headers: /export/home/httpd/cgi-bin/pruebacgi Connection to database 'xyz' OK DECLARE CURSOR command failed [error] [client 127.0.0.1] Premature end of script headers Can anyone help me ? Pleeeeeease. I dont know how to continue. :-| Thanks to everyone.
Ximo Domenech wrote: > > Premature end of script headers: /export/home/httpd/cgi-bin/xyzcgi > > In the log file of Apache I can see the same message and other: > > Internal Server Error > Premature end of script headers: /export/home/httpd/cgi-bin/pruebacgi > > Connection to database 'xyz' OK > DECLARE CURSOR command failed If you are really seeing the above in the log file, it would indicate that 1) You may have an error in the DECLARE statement causing it to fail. 2) Most importantly, it looks like you are generating non http output (i.e. the "Connection to database 'xyz' OK). A typical header might read Content-type: text/html<CR> <Cr> <HTML> - and rest of html. As a test, I would start by try running a simple script from a command line and verifying that the output has the proper HTTP header on it followed by HTML. Below is an example of a script that displays the environment passed to the CGI task on a browser screen (I usually call this thing "env.sh". Start from something simple like this and work your way up. #!/bin/sh echo "Content-type: text/html" echo "" echo "<HTML>" echo "<BODY>" echo "<PRE>" env echo "</PRE>" echo "</BODY>" echo "</HTML>" > [error] [client 127.0.0.1] Premature end of script headers > > Can anyone help me ? Pleeeeeease. > I dont know how to continue. :-| > > Thanks to everyone. -- ------------------------------------------------------------ Thomas Reinke Tel: (416) 460-7021 Director of Technology Fax: (416) 598-2319 E-Soft Inc. http://www.e-softinc.com
On Tue, Aug 03, 1999 at 06:57:29PM -0100, Ximo Domenech wrote: > Premature end of script headers: /export/home/httpd/cgi-bin/xyzcgi > > In the log file of Apache I can see the same message and other: > > Internal Server Error > Premature end of script headers: /export/home/httpd/cgi-bin/pruebacgi > > Connection to database 'xyz' OK > DECLARE CURSOR command failed > [error] [client 127.0.0.1] Premature end of script headers It means that there is something wrong near "declare cursor" in your source code. First of all check syntax of delcare cursor. If everything is OK you should check permissions for all tables etc. inside "declare cursor", if they are accessible to account 'nobody' (assuming that your web-serwer is runnig as a nobody user). You should have postgres account nobody (create it by shell-command 'createuser nobody') and permisions (run psql your_database_name and than enter e.g.: 'grant all on your_table_name to nobody' ). You should also check pg_hba.conf. Good luck! --- Artur Pietruk, arturp@pdi.net
At 22:57 +0300 on 03/08/1999, Ximo Domenech wrote: > Internal Server Error > Premature end of script headers: /export/home/httpd/cgi-bin/pruebacgi > > Connection to database 'xyz' OK > DECLARE CURSOR command failed > [error] [client 127.0.0.1] Premature end of script headers I would say to check two things first: 1) That your first two lines of output are "Content-type: text/html" in the first line, followed by an empty line. If at all possible, output these two lines before even opening the database connection. 2) That your DECLARE CURSOR command is within a transaction block. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma