tourble migrating from linux/Apache/postgresql/perl to win2000/II S/postgresql/perl - Mailing list pgsql-cygwin

From Rishi Sharma
Subject tourble migrating from linux/Apache/postgresql/perl to win2000/II S/postgresql/perl
Date
Msg-id F902091518C1D411985D0008C7E6566C01FE05CE@ned.bigstep.net
Whole thread Raw
Responses Re: tourble migrating from linux/Apache/postgresql/perl to win2000/II S/postgresql/perl
List pgsql-cygwin
Hello Jason,

We previously communicated on the following post about a week ago:
http://fts.postgresql.org/db/mw/msg.html?mid=121056

I am still running into setup/config issues with postgresql and perl under
IIS.  I hope this new thread will find answers from people that have done
something similar in the past.

Just to recap:
- cygwin/cygipc are setup properly.

- I have taken the postgresql7.0 prebuilt NT binaries from
http://www.ca.postgresql.org/ftpsite/binary/v7.0/NT.  (I could not get the
lastest source to compile on our IIS box because some include files were not
part of the tar I downloaded.  Perhaps there are external dependencies
(visual c++?) that were not incluced in the tar.  If someone has been able
to compile the latest source for win32, please tell me where I can get it
prebuilt.)

- the database has been restored from my old linux box over to the IIS box
and I can see data using psql.

- old perl scripts have been moved over and configured to run under IIS

- Fred Yankowski pointed me to www.php.net, however, I belive if I take that
route, the perl cgi's I'm trying to migrate over to win2000 will need to be
re-written using php.  I think it's probabaly best to avoid re-writing code
for this migration - any way to avoid this if I use php?



ISSUES:
- I am not able to load the perl module in my cgi scripts.  There are many
posts regarding this issue... See
http://fts.postgresql.org/db/mw/msg.html?mid=120905 for more information.

I belive the problem is the prebuilt postgresql7.0 NT binary I downloaded.
There should be a libpq.dll (win32) library in this package but I only see a
libpq.a (unix) library.  I don't think the Pg.pm module can be loaded
properly w/o this library - but as I noted above, I'm not able to build it
myself on my IIS box.

Another possibility is that my environment may not have the path to right
Pg.pm module.  I can see the Pg.pm module in my
d:\cygin\usr\src\postgresql-7.1.1\src\interfaces\perl5\Pg.pm - Is this the
right place for this module?  If I pring out my the @INC array - the path
seems to be in there.
--------
#here is a test cgi I am testing with
test.cgi:
#!/usr/bin/perl
# -*- perl -*-   to tell emacs that this is a perl script
# Include any additional modules
push (@INC,
"d:\\cygwin\\usr\\src\\postgresql-7.1.1\\src\\interfaces\\perl5");

#also trying forward slash...
#push (@INC,
"d:\/cygwin\/usr\/src\/postgresql-7.1.1\/src\/interfaces\/perl5");

use CGI;
$q = new CGI;
print $q->header;

# Enable access to the SQL database
#use Pg;

print "INC=" . "@INC\n";

## Close the current script
exit (0);

--------
#here is the output
INC=D:/Perl/lib D:/Perl/site/lib .
d:\cygwin\usr\src\postgresql-7.1.1\src\interfaces\perl5
--------

I also saw some references to building an ODBC driver for postgresql - do I
need ODBC if I'm using cgi's?  I though that is necessary for clients that
are going via TCP/IP to the db (?)...

Can you help?

I will continue trying to find a solution to this in the meantime.

Best Regards,

-rishi

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: [GENERAL] Should Cygwin PostgreSQL contain all header files?
Next
From: Rishi Sharma
Date:
Subject: RE: tourble migrating from linux/Apache/postgresql/perl to win200 0/IIS/postgresql/perl