Thread: tourble migrating from linux/Apache/postgresql/perl to win2000/II S/postgresql/perl
tourble migrating from linux/Apache/postgresql/perl to win2000/II S/postgresql/perl
From
Rishi Sharma
Date:
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
Re: tourble migrating from linux/Apache/postgresql/perl to win2000/II S/postgresql/perl
From
Jason Tishler
Date:
Rishi, On Sat, Jun 09, 2001 at 05:15:12PM -0700, Rishi Sharma wrote: > 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. I have never done the above so I can only help you in a very limited way. > Just to recap: > - cygwin/cygipc are setup properly. Are you sure that gcc/binutils is set up correctly? See the following from your next posting: On Sat, Jun 09, 2001 at 05:40:51PM -0700, Rishi Sharma wrote: > 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 > - 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.) Why are you still using the pre-built PostgreSQL 7.0? If you can't build a 7.1.2 yourself, then I would recommend the one that I contributed to Cygwin. You can find one here: http://mirrors.rcn.net/pub/sourceware/cygwin/contrib/postgresql/postgresql-7.1.2-1.tar.gz or on other Cygwin mirrors. > 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. IMO, the Win32 stuff should not be part of a Cygwin package. Anyway, you can find a pre-built but *UNTESTED* Win32 package here: http://members-http-2.rwc1.sfba.home.net/jtishler/software/postgresql/postgresql-7.1.2-1-win32.tar.gz > Can you help? Sorry, the above is the best that I can do. Jason -- Jason Tishler Director, Software Engineering Phone: 732.264.8770 x235 Dot Hill Systems Corp. Fax: 732.264.8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com