[Mapserver-users] Mapserver Postgis connection issues

[Merlos]

Finally I ran a test with the SQL on windows and unfortunatelly the solution 
I gave was uncorrect, the php crashed because of a problem with the 
libpq.dll. So what I did this time was to copy again the mapserver binaries 
dll file on the system32 dir.

 What I find curious is that the posgres server seems to run ok even.

Well, at least, it seems to work for me.

I Hope you solve your problems. Juan.


On Saturday 17 July 2004 15:00, Merlos wrote:
> Ups! I made a mistake. The correct name of the dll is libpq.dll
>
> Sorry.
>
> On Saturday 17 July 2004 13:39, Merlos wrote:
> > Hi!
> >
> > These days I was wondering if there was any postgresql with postgis for
> > windows already compiled, so when I saw your link I downloaded it.
> >
> > After unpackaging and saving it in the c:\pgsql75win directory I tried to
> > run initdb.bat, but it throw an error. Some procedure call was not found
> > on pqsql.dll, I looked at the mapserver binaries dll and I noticed that
> > it included a pqsql with a 65 KB size (witch I already copied into
> > C:\windows\system32) and on C:\pgsql75win\lib there was another
> > pgsql.dll, this time with a size of 129KB, so what i did was the bigger
> > one on system32, now postgresql is running.
> >
> > I haven't tested if mapserver querys work (have to create the DBs,etc..)
> > but maybe your problem is related to this.
> >
> > I'm trying  with WinDoS XP home/apache1.3/php4.3.7/mapserver4.2 binaries
> > package
> >
> > Regards. Juan
> >
> > On Friday 16 July 2004 22:44, Swaminathan, Gayathri wrote:
> > > Ok I tried shp2img... As follows:
> > >
> > > C:\Inetpub\cgi-bin>shp2img -m c:\Inetpub\wwwroot\athena\mapODOC.map -o
> > > c:\out.png -l sqlSewerline
> > >
> > > and it returns a blank image with my IMAGEBACKGROUND set in the
> > > mapfile.
> > >
> > > sqlSewerline is my postgis layer.
> > >
> > > The above command works fine for shape files though and renders out.png
> > > with parcels...
> > >
> > > > -----Original Message-----
> > > > From: Tyler Mitchell [mailto:tjmitchell at riverside.bc.ca]
> > > > Sent: Friday, July 16, 2004 3:29 PM
> > > > To: Swaminathan, Gayathri
> > > > Cc: Vladimir Guzmán; Kathi Koebke;
> > > > mapserver-users at lists.gis.umn.edu;
> > > > mapserver-users-admin at lists.gis.umn.edu
> > > > Subject: Re: [Mapserver-users] Mapserver Postgis connection issues
> > > >
> > > > > If I added a Postgis layer however..I am having the mapserver cgi
> > > > > run indefinetely and locking up.
> > > >
> > > > Are you using any sort of java interface in your web page?
> > > > I would try to debug by using the command line shp2img
> > > > command instead.
> > > > See if it throws any errors.
> > >
> > > _______________________________________________
> > > Mapserver-users mailing list
> > > Mapserver-users at lists.gis.umn.edu
> > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users

-- 
--
http://www.merlos.biz