Re: [GENERAL] Postgres' DBI(Pg) problems.

As your perl script is run by apache, LD_LIBRARY_PATH and PGLIB may
be defined *before* apache starting. If apache is run by a rc script,
define LD_LIBRARY_PATH and PGLIB in the rc script before apache is
started.

You do not need mod_perl for this script. mod_perl gives you the
benefits of having a persistant perl vm staying alive between the
execution of your cgi scripts. It will speedup things because you
can maintain a persistant state (your perl code compiled, your
database connections, ...) between executions of your scripts.

Rémi.

Kevin Lo writes:
 > Rimi Lehn wrote:
 >
 > >         Your script worked for me (I skipped everything related to
 > > forms-lib), but :
 > >
 > > - /* xxxx */ C-style comments are not allowed by perl (line #2)
 > > - you should $sth->finish() and $dbh->disconnect() at the end of your
 > >   script to avoid warnings ("Database handle destroyed without
 > >   explicit disconnect.")
 >
 > OK, added.
 >
 > >         I assumed that your table course has two fields, both are
 > > type text. Check that your fields are not numbers (inserted values
 > > are quoted (line #13)).
 > >
 > >         You can replace $sth->prepare() and $sth->execute() by a
 > > $sth->do( "your query" ); as your query has no output row.
 > >
 > >         Check your web server's logs. At least for apache, stderr
 > > of cgi scripts is dumped in an error log. Try running your script
 > > offline. A common mistake is not having access to your database
 > > with the uid endorsed by your web server (apache usually runs
 > > cgi scripts as nobody which may not have INSERT permissions on
 > > the table).
 >
 > I checked the log file of Apache server, I got an error message:
 >
 > [Mon Jan 18 18:12:01 1999] [notice] httpd: caught SIGTERM, shutting down
 > [Mon Jan 18 21:48:28 1999] [notice] Apache/1.3.1 (Unix) configured -- resuming
 > normal operations
 > install_driver(Pg) failed: Can't load
 > '/usr/local/lib/perl5/site_perl/i386-freebsd/auto/DBD/Pg/Pg.so' for module DBD::Pg:
 > Can't find shared library "libpq.so.2.0" at
 > /usr/local/lib/perl5/i386-freebsd/5.00404/DynaLoader.pm line 166.
 >
 >  at (eval 1) line 2
 >
 >  at /home/kevin/public_html/example.pl line 14
 >
 > I've already set enviroment variables PGLIB and LD_LIBRARY_PAHT in .login.
 > libpq.so.2.0 is in /usr/local/pgsql/lib directory. I don't install mod_perl with
 > Apache.
 > Should I install mod_perl?  Would you tell me how to solve this problem, thanks.
 >
 > Best regards,
 > Kevin.
 >