FW: [Mapserver-users] Mapserver Postgis connection issues

[Swaminathan, Gayathri]

-----Original Message-----
From: Swaminathan, Gayathri 
Sent: Sunday, July 18, 2004 11:57 AM
To: 'Tyler Mitchell'
Subject: RE: [Mapserver-users] Mapserver Postgis connection issues


So I finally had the issue solved...

I had registered the libpq.dll that came in Mark Ayland's snapshot for use with mapserver v.4.2.1

This dint work well...It had the mapserver cgi--hung up

So I took Tyler's suggestion and tried from shp2img...and checked my postgresql log and saw that there was no postgresql connection requests being made!!!

Then... I took  Juan's suggestion and replaced my libpq.dll with the one that came with mapserver 42 bundle (http://hypnos.cbs.umn.edu/projects/downloads/ms42pg.zip) and it works!!!!!!!!

So this was another mismatched dll-o-rama!

Thanks for all your help...and time

Gayathri

>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.
> -----Original Message-----
> From: Swaminathan, Gayathri
> Sent: Friday, July 16, 2004 3:45 PM
> To: 'Tyler Mitchell'
> 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
> 
> 
> 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.
> > 
> > 
> > 
>