www_sql - Mailing list pgsql-admin

From Miguel Gonzalez
Subject www_sql
Date
Msg-id 037d01c0dc8d$9a3e5690$fa01a8c0@clientesql
Whole thread Raw
In response to psql produces core dump  (Reiner Dassing <dassing@wettzell.ifag.de>)
List pgsql-admin
dear all,

 Sorry because maybe this is not the place where I should address this
question, but
I thought that maybe someone on this list knows something about www_sql. If
not, sorry
for disturbing you with my email

Here it goes:

 I have downloaded www-sql 0.5.7 and trying to configure it
for Apache 1.3.14 and for PostgreSQL 7.0.3 (I only have this
database system, no mySQL).

 I have used the followind directives in the configure script:

 >./configure --with-database="pgsql" \
 --with-pgsql-headers="/usr/local/pgsql/include" \
 --with-pgsql-libs="/usr/local/pgsql/libs" \
 --enable-apache-action-check
 --enable-recursive

 >make

 >make install CGI_DIR="/usr/local/apache/cgi-bin"

 It seems that everything is fine, I have checked www-sql with the
example of test.in given in the www-sql.html document and www-sql
gives back the right answer.

 Then I copied the example.pgsql and changed it into ejemplo.sql. I
only tried to use it to query into a different database. But it doesnt
work. I checked then, the error_log of Apache and says the following:

 www-sql:error in loading shared-libraries:libpq.so.2.1:cannot open
shared object file:No such file or directory.

I changed permissions to this file for nobody (the default Apache user)
and didnt work either.

 I have different questions.

 1.- I have only PostgreSQL. I thought that when you use the directive
--with-database="pgsql" then only compiles for PostgreSQL. The output
of the configure script says that cant find mySQL libraries. It seems
that still tries also to compile for mySQL. Checking also config.status
there is an entry about mySQL libs. What is wrong?

 2.- After executing "make" then I got two executables "www-sql"
and "www-pgsql" but when I execute "make install CGI_DIR ..." only
installs in the cgi directory of Apache the www-sql binary. Why?

 3.- In the httpd.conf I added the directives

 Action www-sql /cgi-bin/www-sql
 AddHandler www-sql sql

 This means that I have to use .sql extension to make the cgi www-sql
to parse the file. But is this meant to be only for mySQL? I mean, I
am really confused about the www-sql www-pgsql binaries and dont know
exactly if having www-sql to access PostgreSQL databases I need to
use different directives and binaries (also different extensions
providing that the example given in the source files is called
example.pgsql).

 Sorry for the long email but I had to explain all the steps that I
have taken, but it was necessary to show you guys what I have done
and to focus really in the problem.

 Also I would like to know if there is any resource for www-sql,
tutorials, any other website apart of the main site, mailing-lists, etc.

 Thank you very much in advance and sorry for my English

 Miguel








pgsql-admin by date:

Previous
From: Reiner Dassing
Date:
Subject: Re: psql produces core dump
Next
From: "Sander Steffann"
Date:
Subject: Re: 7.1 ... wtf?