Thread: Web, PostgreSQL, C

Web, PostgreSQL, C

From
Margarita Barvinok
Date:
Hi All,

Sorry for stupid questions but all this stuff is new for me.
I am working on a CGI program to access Postgres DB from the Web.
I would like to use C for CGI.
I took standard post-query.c program that transfer data from Web to the
program.
Then I add some Postgres staff and compile the program with Postgres
libraries. And the program doesn't work. It dives this error:

Internal Server Error
The server encountered an internal error or misconfiguration and was
unable to complete your request.

Even more... If I compile (by gcc) post-query.c program adding to -I, -L,
-l options Postgres include and lib directories, the program gives the
same error.
What is wrong? Do I need to install something or change configuration
somewhere? 
I have PostgreSQL 6.5

Any help will be greatly appreciated.
Thank you,
-Margarita



Re: [INTERFACES] Web, PostgreSQL, C

From
"Brett W. McCoy"
Date:
On Tue, 10 Aug 1999, Margarita Barvinok wrote:

> Sorry for stupid questions but all this stuff is new for me.
> I am working on a CGI program to access Postgres DB from the Web.
> I would like to use C for CGI.
> I took standard post-query.c program that transfer data from Web to the
> program.
> Then I add some Postgres staff and compile the program with Postgres
> libraries. And the program doesn't work. It dives this error:
> 
> Internal Server Error
> The server encountered an internal error or misconfiguration and was
> unable to complete your request.
> 
> Even more... If I compile (by gcc) post-query.c program adding to -I, -L,
> -l options Postgres include and lib directories, the program gives the
> same error.
> What is wrong? Do I need to install something or change configuration
> somewhere? 
> I have PostgreSQL 6.5

Try running the CGI program from the command-line, if possible.  You may 
get more information from the program as to why it's crashing.

Have you looked into using the Perl interface for Postgres?  Perl has 
some really nice features for CGI programming, so you can focus on what 
your application does rather than how it is supposed to work.

Brett W. McCoy                                                   http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Any fool can paint a picture, but it takes a wise person to be able to
sell it.