RE: tourble migrating from linux/Apache/postgresql/perl to win200 0/IIS/postgresql/perl - Mailing list pgsql-cygwin
From | Rishi Sharma |
---|---|
Subject | RE: tourble migrating from linux/Apache/postgresql/perl to win200 0/IIS/postgresql/perl |
Date | |
Msg-id | F902091518C1D411985D0008C7E6566C01FE05D0@ned.bigstep.net Whole thread Raw |
List | pgsql-cygwin |
Just a little more info for you: When trying to build the latest postgresql-7.1.2 I get the following error: bash-2.05$ make make -C doc all make[1]: Entering directory `/usr/src/postgresql-7.1.2/doc' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/usr/src/postgresql-7.1.2/doc' make -C src all make[1]: Entering directory `/usr/src/postgresql-7.1.2/src' make -C backend all make[2]: Entering directory `/usr/src/postgresql-7.1.2/src/backend' prereqdir=`cd parser/ >/dev/null && pwd` && \ cd ../../src/include/parser/ && rm -f parse.h && \ ln -s $prereqdir/parse.h . make -C utils fmgroids.h make[3]: Entering directory `/usr/src/postgresql-7.1.2/src/backend/utils' CPP='gcc -E' AWK='gawk' /bin/sh.exe Gen_fmgrtab.sh ../../../src/include/catalog/ pg_proc.h -nThe system cannot find the file specified. cpp0.exe: output pipe has been closed Gen_fmgrtab.sh failed make[3]: *** [fmgroids.h] Error 1 make[3]: Leaving directory `/usr/src/postgresql-7.1.2/src/backend/utils' make[2]: *** [utils/fmgroids.h] Error 2 make[2]: Leaving directory `/usr/src/postgresql-7.1.2/src/backend' make[1]: *** [all] Error 2 make[1]: Leaving directory `/usr/src/postgresql-7.1.2/src' make: *** [all] Error 2 bash-2.05$ where is fmgroids.h? -----Original Message----- From: Rishi Sharma To: 'Jason Tishler ' Cc: 'Pgsql-Cygwin ' ' Sent: 6/9/01 5:15 PM Subject: tourble migrating from linux/Apache/postgresql/perl to win2000/IIS/postgresql/perl 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: