Re: [mapserver-users] MapServer IIS7
On 10/13/2016 11:10 AM, Vogt, Robert (RCIS) wrote: I have and it also works in mapserver but only while using Apache as the server. My point is that the apache service probably runs under a user like "apache", I'm sure IIS runs under some other user. Your SQL server and database needs to be configured to accept connections from whatever user IIS runs under, which is probably different from apache or even your user account. -Steve W -Original Message- From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Stephen Woodbridge Sent: Thursday, October 13, 2016 10:31 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] MapServer IIS7 Have you tried to connect to the sql server outside of mapserver using the same credentials? ie: make sure the the mapserver user is a valid user to do the connection with. -Steve W On 10/13/2016 10:18 AM, Vogt, Robert (RCIS) wrote: This is the full error... 502 - Web server received an invalid response while acting as a gateway or proxy server. There is a problem with the page you are looking for, and it cannot be displayed. When the Web server (while acting as a gateway or proxy) contacted the upstream content server, it received an invalid response from the content server. -Original Message- From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Vogt, Robert (RCIS) Sent: Thursday, October 13, 2016 10:12 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] MapServer IIS7 Good morning, I originally set up MapServer with WS4W and Apache server...I now have a requirement to put this on the same domain as our application which runs in IIS7. I have created the site and pointed my application at it and the results are mixed... Map files that are pointed at lizardtech for their source are working but map files that are pointed at SQL for their source are giving a 502(bad gateway) error. All map files worked when served through Apache, has anyone run into this or know what I should look at to fix it? Your help is greatly appreciated!! *** Map File *** MAP IMAGETYPE PNG24 CONFIG "PROJ_LIB" "E:/RCIS/Web/MapServerDlls/projlib" SIZE 256 256 FONTSET "E:/RCIS/Web/MapServerDlls/content/fontset.txt" IMAGECOLOR 255 255 255 TRANSPARENT ON PROJECTION "init=epsg:4326" END WEB METADATA "wms_title" "sections" "wms_enable_request" "*" END END LAYER NAME "States" TYPE POLYGON STATUS ON LABELCACHE ON PROCESSING 'LABEL_NO_CLIP=1' CONNECTIONTYPE PLUGIN PLUGIN "msplugin_mssql2008.dll" CONNECTION "OurConnectionString" DATA "shape(geography),ST_NAME_MC from NATIONALDB.sde.STATES USING INDEX STATES_SIDX USING UNIQUE STATES_ID USING SRID=4269" LABELITEM"ST_NAME_MC" PROCESSING "CLOSE_CONNECTION=DEFER" CLASS STYLE OUTLINECOLOR 000 153 000 WIDTH 3 END LABEL COLOR 000 153 000 TYPE TRUETYPE FONT Arial SIZE 12 ANTIALIAS FALSE POSITION AUTO PARTIALS FALSE END END PROJECTION "init=epsg:4326" END END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer IIS7
I have and it also works in mapserver but only while using Apache as the server. -Original Message- From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Stephen Woodbridge Sent: Thursday, October 13, 2016 10:31 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] MapServer IIS7 Have you tried to connect to the sql server outside of mapserver using the same credentials? ie: make sure the the mapserver user is a valid user to do the connection with. -Steve W On 10/13/2016 10:18 AM, Vogt, Robert (RCIS) wrote: > This is the full error... > 502 - Web server received an invalid response while acting as a gateway or > proxy server. > There is a problem with the page you are looking for, and it cannot be > displayed. When the Web server (while acting as a gateway or proxy) contacted > the upstream content server, it received an invalid response from the content > server. > > -Original Message- > From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] > On Behalf Of Vogt, Robert (RCIS) > Sent: Thursday, October 13, 2016 10:12 AM > To: mapserver-users@lists.osgeo.org > Subject: [mapserver-users] MapServer IIS7 > > Good morning, > > I originally set up MapServer with WS4W and Apache server...I now have a > requirement to put this on the same domain as our application which runs in > IIS7. > > I have created the site and pointed my application at it and the results are > mixed... > > Map files that are pointed at lizardtech for their source are working but map > files that are pointed at SQL for their source are giving a 502(bad gateway) > error. > > All map files worked when served through Apache, has anyone run into this or > know what I should look at to fix it? > > Your help is greatly appreciated!! > > *** > Map File *** > > MAP > IMAGETYPE PNG24 > CONFIG "PROJ_LIB" "E:/RCIS/Web/MapServerDlls/projlib" > SIZE 256 256 > FONTSET "E:/RCIS/Web/MapServerDlls/content/fontset.txt" > IMAGECOLOR 255 255 255 > TRANSPARENT ON > PROJECTION > "init=epsg:4326" > END > WEB > METADATA > "wms_title" "sections" > "wms_enable_request" "*" > END > END > LAYER > NAME "States" > TYPE POLYGON > STATUS ON > LABELCACHE ON > PROCESSING 'LABEL_NO_CLIP=1' > CONNECTIONTYPE PLUGIN > PLUGIN "msplugin_mssql2008.dll" > CONNECTION "OurConnectionString" > DATA "shape(geography),ST_NAME_MC from NATIONALDB.sde.STATES > USING INDEX STATES_SIDX USING UNIQUE STATES_ID USING SRID=4269" > LABELITEM"ST_NAME_MC" > PROCESSING "CLOSE_CONNECTION=DEFER" > CLASS > STYLE >OUTLINECOLOR 000 153 000 >WIDTH 3 > END >LABEL > COLOR 000 153 000 > TYPE TRUETYPE > FONT Arial > SIZE 12 > ANTIALIAS FALSE > POSITION AUTO > PARTIALS FALSE > > END > END > PROJECTION >"init=epsg:4326" > END > END > END > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer IIS7
Have you tried to connect to the sql server outside of mapserver using the same credentials? ie: make sure the the mapserver user is a valid user to do the connection with. -Steve W On 10/13/2016 10:18 AM, Vogt, Robert (RCIS) wrote: This is the full error... 502 - Web server received an invalid response while acting as a gateway or proxy server. There is a problem with the page you are looking for, and it cannot be displayed. When the Web server (while acting as a gateway or proxy) contacted the upstream content server, it received an invalid response from the content server. -Original Message- From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Vogt, Robert (RCIS) Sent: Thursday, October 13, 2016 10:12 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] MapServer IIS7 Good morning, I originally set up MapServer with WS4W and Apache server...I now have a requirement to put this on the same domain as our application which runs in IIS7. I have created the site and pointed my application at it and the results are mixed... Map files that are pointed at lizardtech for their source are working but map files that are pointed at SQL for their source are giving a 502(bad gateway) error. All map files worked when served through Apache, has anyone run into this or know what I should look at to fix it? Your help is greatly appreciated!! *** Map File *** MAP IMAGETYPE PNG24 CONFIG "PROJ_LIB" "E:/RCIS/Web/MapServerDlls/projlib" SIZE 256 256 FONTSET "E:/RCIS/Web/MapServerDlls/content/fontset.txt" IMAGECOLOR 255 255 255 TRANSPARENT ON PROJECTION "init=epsg:4326" END WEB METADATA "wms_title" "sections" "wms_enable_request" "*" END END LAYER NAME "States" TYPE POLYGON STATUS ON LABELCACHE ON PROCESSING 'LABEL_NO_CLIP=1' CONNECTIONTYPE PLUGIN PLUGIN "msplugin_mssql2008.dll" CONNECTION "OurConnectionString" DATA "shape(geography),ST_NAME_MC from NATIONALDB.sde.STATES USING INDEX STATES_SIDX USING UNIQUE STATES_ID USING SRID=4269" LABELITEM"ST_NAME_MC" PROCESSING "CLOSE_CONNECTION=DEFER" CLASS STYLE OUTLINECOLOR 000 153 000 WIDTH 3 END LABEL COLOR 000 153 000 TYPE TRUETYPE FONT Arial SIZE 12 ANTIALIAS FALSE POSITION AUTO PARTIALS FALSE END END PROJECTION "init=epsg:4326" END END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer IIS7
This is the full error... 502 - Web server received an invalid response while acting as a gateway or proxy server. There is a problem with the page you are looking for, and it cannot be displayed. When the Web server (while acting as a gateway or proxy) contacted the upstream content server, it received an invalid response from the content server. -Original Message- From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Vogt, Robert (RCIS) Sent: Thursday, October 13, 2016 10:12 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] MapServer IIS7 Good morning, I originally set up MapServer with WS4W and Apache server...I now have a requirement to put this on the same domain as our application which runs in IIS7. I have created the site and pointed my application at it and the results are mixed... Map files that are pointed at lizardtech for their source are working but map files that are pointed at SQL for their source are giving a 502(bad gateway) error. All map files worked when served through Apache, has anyone run into this or know what I should look at to fix it? Your help is greatly appreciated!! *** Map File *** MAP IMAGETYPE PNG24 CONFIG "PROJ_LIB" "E:/RCIS/Web/MapServerDlls/projlib" SIZE 256 256 FONTSET "E:/RCIS/Web/MapServerDlls/content/fontset.txt" IMAGECOLOR 255 255 255 TRANSPARENT ON PROJECTION "init=epsg:4326" END WEB METADATA "wms_title" "sections" "wms_enable_request" "*" END END LAYER NAME "States" TYPE POLYGON STATUS ON LABELCACHE ON PROCESSING 'LABEL_NO_CLIP=1' CONNECTIONTYPE PLUGIN PLUGIN "msplugin_mssql2008.dll" CONNECTION "OurConnectionString" DATA "shape(geography),ST_NAME_MC from NATIONALDB.sde.STATES USING INDEX STATES_SIDX USING UNIQUE STATES_ID USING SRID=4269" LABELITEM"ST_NAME_MC" PROCESSING "CLOSE_CONNECTION=DEFER" CLASS STYLE OUTLINECOLOR 000 153 000 WIDTH 3 END LABEL COLOR 000 153 000 TYPE TRUETYPE FONT Arial SIZE 12 ANTIALIAS FALSE POSITION AUTO PARTIALS FALSE END END PROJECTION "init=epsg:4326" END END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users