Andy, Sorry about the late reply. I am not opposed to perl/php. I just want something easy, and I would prefer not having to set up Mapserver and GeoServer.
Concerning the slow server: The person running the site added more RAM, so the system is not agonizingly slow. In addition it sounds like they are going to get a new machine next year. They said that they are okay with the performance so I am going to let it go and just hope the new server will help. Mark Volz, GISP GIS Specialist > -----Original Message----- > From: [email protected] [mailto:mapserver-users- > [email protected]] On Behalf Of mapserver-users- > [email protected] > Sent: Friday, August 09, 2013 10:41 AM > To: [email protected] > Subject: mapserver-users Digest, Vol 67, Issue 11 > > Send mapserver-users mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.osgeo.org/mailman/listinfo/mapserver-users > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific than "Re: > Contents of mapserver-users digest..." > > > Today's Topics: > > 1. securing mapserver layers (Mark Volz) > 2. Re: securing mapserver layers (andy) > 3. Re: securing mapserver layers (Basques, Bob (CI-StPaul)) > 4. Re: securing mapserver layers (Raffaele Morelli) > 5. Re: securing mapserver layers (Raffaele Morelli) > 6. MapServer UTFGrid driver (Francois Desjarlais) > 7. Re: drawing multiple layers from postgis (Michael McInnis) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 8 Aug 2013 20:36:24 +0000 > From: Mark Volz <[email protected]> > To: "[email protected]" > <[email protected]> > Subject: [mapserver-users] securing mapserver layers > Message-ID: > <[email protected] > al> > Content-Type: text/plain; charset="us-ascii" > > Hello > > I would like to set up mapserver so that some map files are open to anyone, > some open to only internal users, and other maps are only open to users that > enter in a user name and password. Is there a way to set up mapserver / > Apache so that I can secure the mapserver services for different types of > users? > > For example: > Public Users, or any users > http://geomoose.lyonco.org/cgi-bin/mapserv.exe?map=public_map > > Internal Users > http://geomoose.lyonco.org/cgi- > bin/mapserv.exe?map=internal_map > External users with the correct username and password > http://geomoose.lyonco.org/cgi- > bin/mapserv.exe?map=password_protected_map > > Thank You > > > p.s. I asked a similar question in the past, but I am having trouble finding > that > question and response. So I appologize for asking the same question again > > > Mark Volz, GISP > GIS Specialist > > > > > ------------------------------ > > Message: 2 > Date: Thu, 08 Aug 2013 16:00:14 -0500 > From: andy <[email protected]> > To: [email protected] > Subject: Re: [mapserver-users] securing mapserver layers > Message-ID: <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > On 8/8/2013 3:36 PM, Mark Volz wrote: > > Hello > > > > I would like to set up mapserver so that some map files are open to > anyone, some open to only internal users, and other maps are only open to > users that enter in a user name and password. Is there a way to set up > mapserver / Apache so that I can secure the mapserver services for different > types of users? > > > > For example: > > Public Users, or any users > > http://geomoose.lyonco.org/cgi-bin/mapserv.exe?map=public_map > > > Internal Users > > http://geomoose.lyonco.org/cgi- > bin/mapserv.exe?map=internal_map > > External users with the correct username and password > > > > http://geomoose.lyonco.org/cgi- > bin/mapserv.exe?map=password_protected_ > > map > > > > Thank You > > > > > > p.s. I asked a similar question in the past, but I am having trouble > > finding that question and response. So I appologize for asking the > > same question again > > > > > > Mark Volz, GISP > > GIS Specialist > > > > > How'd you feel about switching to perl/php and using mapscript? > > PS: how'd your slow live box/dev box problem go? get that fixed up? > > -Andy > > > > ------------------------------ > > Message: 3 > Date: Thu, 8 Aug 2013 21:45:49 +0000 > From: "Basques, Bob (CI-StPaul)" <[email protected]> > To: Mark Volz <[email protected]>, > "[email protected]" <mapserver- > [email protected]> > Subject: Re: [mapserver-users] securing mapserver layers > Message-ID: > <C9CEA89772DA74488B5A5B6EB17DC481066ABBC7@055-CH1MPN1- > 003.055d.mgd.msft.net> > > Content-Type: text/plain; charset="us-ascii" > > Mark, > > Early on we set up some Apache rules to handle this, but it's based on a > naming mechanism in the MAP files. > > If you look at our public facing MAPfile links, each mapfile name looks > something like: <mapfile-title>_public.map > > The "_public" chunk is read by Apache as something that is available > externally. We actually came up with five different classes of file types > originally, but this is really the only one that we use and it's intended to > allow > the Mapfile/data custodians a method of making their data available outside > if they want to. They just need to add that chunk of text to their Mapfile > and > apache lets outside access see them.i've been meaning to set up a whole > demo suite of our configuration for a while (few years) now, but just never > got around to it. We have other similar APACHE mod for other things as well > that I think others would be interested in. > > We have a couple of newer projects that might dictate that we set up some > demo product that might morph into some sort of demo eventually. > > Bobb > > > > -----Original Message----- > From: [email protected] [mailto:mapserver-users- > [email protected]] On Behalf Of Mark Volz > Sent: Thursday, August 08, 2013 3:36 PM > To: [email protected] > Subject: [mapserver-users] securing mapserver layers > > Hello > > I would like to set up mapserver so that some map files are open to anyone, > some open to only internal users, and other maps are only open to users that > enter in a user name and password. Is there a way to set up mapserver / > Apache so that I can secure the mapserver services for different types of > users? > > For example: > Public Users, or any users > http://geomoose.lyonco.org/cgi-bin/mapserv.exe?map=public_map > > Internal Users > http://geomoose.lyonco.org/cgi- > bin/mapserv.exe?map=internal_map > External users with the correct username and password > http://geomoose.lyonco.org/cgi- > bin/mapserv.exe?map=password_protected_map > > Thank You > > > p.s. I asked a similar question in the past, but I am having trouble finding > that > question and response. So I appologize for asking the same question again > > > Mark Volz, GISP > GIS Specialist > > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > ------------------------------ > > Message: 4 > Date: Fri, 9 Aug 2013 12:18:00 +0200 > From: Raffaele Morelli <[email protected]> > To: "[email protected]" > <[email protected]> > Subject: Re: [mapserver-users] securing mapserver layers > Message-ID: > <CAD4guxP=rn0h9eF66MLg=N++oGhKT+45FXirVAcbd5Ei7t5hTQ@ma > il.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > 2013/8/8 Mark Volz <[email protected]> > > > Hello > > > > I would like to set up mapserver so that some map files are open to > > anyone, some open to only internal users, and other maps are only open > > to users that enter in a user name and password. Is there a way to > > set up mapserver / Apache so that I can secure the mapserver services > > for different types of users? > > > > For example: > > Public Users, or any users > > http://geomoose.lyonco.org/cgi-bin/mapserv.exe?map=public_map > > Internal Users > > > > http://geomoose.lyonco.org/cgi-bin/mapserv.exe?map=internal_map > > External users with the correct username and password > > > > http://geomoose.lyonco.org/cgi- > bin/mapserv.exe?map=password_protected_ > > map > > > > Thank You > > > > > > p.s. I asked a similar question in the past, but I am having trouble > > finding that question and response. So I appologize for asking the > > same question again > > > > > > Mark Volz, GISP > > GIS Specialist > > > > You can use apache mod_aut* modules to setup a username/password > protected area. > If you are planning to use mapserver as WMS server, you should consider to > use allow/deny on a file type level (<files >and/or <location> directives) > according to ip addresses. > > If you are running a front end like pmapper or a openlayers based one you > can quickly grant access using both methods. > > /r > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/mapserver- > users/attachments/20130809/cdcd04e4/attachment-0001.html> > > ------------------------------ > > Message: 5 > Date: Fri, 9 Aug 2013 12:24:01 +0200 > From: Raffaele Morelli <[email protected]> > To: Mark Volz <[email protected]>, > "[email protected]" <mapserver- > [email protected]> > Subject: Re: [mapserver-users] securing mapserver layers > Message-ID: > <CAD4guxOru8HBgjeVTveQPOfUFHSEPNoGK31xM1k00FgVudnFjg@ > mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > 2013/8/8 Basques, Bob (CI-StPaul) <[email protected]> > > > Mark, > > > > Early on we set up some Apache rules to handle this, but it's based on > > a naming mechanism in the MAP files. > > > > If you look at our public facing MAPfile links, each mapfile name > > looks something like: <mapfile-title>_public.map > > > > The "_public" chunk is read by Apache as something that is available > > externally. We actually came up with five different classes of file > > types originally, but this is really the only one that we use and it's > > intended to allow the Mapfile/data custodians a method of making their > > data available outside if they want to. They just need to add that > > chunk of text to their Mapfile and apache lets outside access see > > them.i've been meaning to set up a whole demo suite of our > > configuration for a while (few > > years) now, but just never got around to it. We have other similar > > APACHE mod for other things as well that I think others would be > interested in. > > > > We have a couple of newer projects that might dictate that we set up > > some demo product that might morph into some sort of demo eventually. > > > > Bobb > > > Apache environment variables can do this but it's more related to hide the > mapfile path on the file system. > eg. a request for "YOUR_ALIAS" is turned into the real path from the > webserver, /your/real/path/to/the/mapfile.map > > This is accomplished by symbolic links (YOUR_ALIAS) to mapserver > executable in the cgi dir > > http://mapserver.org/ogc/wms_server.html#changing-the-online-resource- > url > > /r > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/mapserver- > users/attachments/20130809/65ac70e4/attachment-0001.html> > > ------------------------------ > > Message: 6 > Date: Fri, 9 Aug 2013 11:25:37 -0400 > From: Francois Desjarlais <[email protected]> > To: [email protected] > Subject: [mapserver-users] MapServer UTFGrid driver > Message-ID: > <CAK6wxNsTpRiGN5xK8DCV8iTWgCfmHoEFvH05BxgSFD+je0hY9w@ > mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Hi all, > > My name is Francois and I am a computer engineering student. This summer, > as part of the Google Summer of Code program, I worked on a UTFGrid > driver for MapServer. It is now functional and available. I also made a patch > for OpenLayers so that it supports UTFGrid with a WMS service for UTFGrid > driver. Recently, I modified the MapServer's docs to add this new output > format. All these can be found on my git. > > Any feedback about the driver is appreciated. > You can find all the doc and a working example at msgsoc.mapgears.com My > git : github.com/fdesj > > If you have any questiona about this new feature just ask . > > Regards, > Francois > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/mapserver- > users/attachments/20130809/f57f5f8e/attachment-0001.html> > > ------------------------------ > > Message: 7 > Date: Fri, 9 Aug 2013 08:40:28 -0700 > From: Michael McInnis <[email protected]> > To: "[email protected]" > <[email protected]> > Subject: Re: [mapserver-users] drawing multiple layers from postgis > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > > > > > I'm pretty sure that END is correctly ending the Symbol Clause. > The odd thing about this is I can draw all four layers if I call them > separately > but when I try to call them through php only numbers 1 and 3 work. All layers > were generated the same way inpostgresql/postgis (see sql below). > I'm going to regenerate layers 2 and 4 just in case but I think it's a problem > with php/ms_script. > // All these > work > > http://localhost/cgi- > bin/mapserv?map=/media/D_Drive/www/gis/business1.map&layers=busin > ess_rd1%20states&mode=map > > http://localhost/cgi- > bin/mapserv?map=/media/D_Drive/www/gis/business2.map&layers=busin > ess_rd2%20states&mode=map > > http://localhost/cgi- > bin/mapserv?map=/media/D_Drive/www/gis/business3.map&layers=busin > ess_rd3%20states&mode=map > > http://localhost/cgi- > bin/mapserv?map=/media/D_Drive/www/gis/business4.map&layers=busin > ess_rd4%20states&mode=map > > > > // Half of > these work > > http://mapserver0/business.php?num=1 works > > http://mapserver0/business.php?num=2 not > > http://mapserver0/business.php?num=3 works > > http://mapserver0/business.php?num=4 not > > // All these > work > > http://localhost/cgi- > bin/mapserv?map=/media/D_Drive/www/gis/business1.map&layers=busin > ess_rd1%20states&mode=map > > http://localhost/cgi- > bin/mapserv?map=/media/D_Drive/www/gis/business2.map&layers=busin > ess_rd2%20states&mode=map > > http://localhost/cgi- > bin/mapserv?map=/media/D_Drive/www/gis/business3.map&layers=busin > ess_rd3%20states&mode=map > > http://localhost/cgi- > bin/mapserv?map=/media/D_Drive/www/gis/business4.map&layers=busin > ess_rd4%20states&mode=map > > > > // Half of > these work > > http://mapserver0/business.php?num=1 works > > http://mapserver0/business.php?num=2 not > > http://mapserver0/business.php?num=3 works > > http://mapserver0/business.php?num=4 not > // Create rounded > lat lon table > > Select count(*), round(cast(ST_X(geom) as numeric),2) as lon, > > round(cast(ST_Y(geom) as numeric),2) as lat > > Into > business_rd2 > > From > business_loc > > Group By round(cast(ST_X(geom) as numeric),2), round(cast(ST_Y(geom) as > numeric),2) > > Order By count Desc > > > > // Add Geometry > > Alter Table business_rd2 Add > Column geom geometry(POINT,4326); > > Update > business_rd2 Set geom = > ST_SetSRID(ST_MakePoint(lon,lat),4326); > > Create Index indx_business_rd2_geom On > business_rd2 Using GIST(geom); > > > > // Now add a > primary key named id to enable mapserver drawing > > Alter Table > business_rd2 Add Column > id BIGSERIAL Primary Key; > > > Date: Fri, 9 Aug 2013 12:23:52 +0200 > > Subject: Re: [mapserver-users] drawing multiple layers from postgis > > From: [email protected] > > To: [email protected] > > > > On 8 August 2013 20:16, Michael McInnis <[email protected]> wrote: > > > Hopefully, this is an easy one. > > > > > > I'm trying to build a scale sensitive .map file using points from postgis. > > > > > > I can successfully draw the shapefile states with a single points > > > layer from postgis. > > > However, if I add an additional points layer and attempt to draw it > > > the layer comes up blank. > > > If I remove the leading postgis points layer from the .map file the > > > new points layer will now display. > > > IE I can only draw the first occurrence of a postgis layer in the map > > > file. > > > > > > How do you define multiple postgis layers so that you can pick and > > > choose layers for display? > > > > > > LAYER > > > NAME states > > > DATA STATES > > > STATUS ON > > > TYPE Polygon > > > > > > CLASS > > > OUTLINECOLOR 255 255 255 > > > COLOR 155 155 155 > > > END # Class > > > END # Layer > > > > > > LAYER > > > CONNECTIONTYPE POSTGIS > > > NAME business_rd2 > > > CONNECTION "host=localhost dbname=Business user=postgres > > > password=xxxx port=5432" > > > PROCESSING "CLOSE_CONNECTION=DEFER" > > > DATA "geom From business_rd2 as rd2 using unique id using > srid=4326" > > > #MINSCALE 100000 > > > STATUS ON > > > TYPE POINT > > > CLASS > > > SYMBOL 'circle' > > > SIZE 2 > > > COLOR 255 0 0 > > > END > > this END is bogus > > > > > END # Class > > > END # Layer > > > > > > LAYER > > > CONNECTIONTYPE POSTGIS > > > NAME business_rd1 > > > CONNECTION "host=localhost dbname=Business user=postgres > > > password=xxxx port=5432" > > > PROCESSING "CLOSE_CONNECTION=DEFER" > > > DATA "geom From business_rd1 as rd1 using unique id using > srid=4326" > > > #MINSCALE 100000 > > > STATUS ON > > > TYPE POINT > > > CLASS > > > SYMBOL 'circle' > > > SIZE 2 > > > COLOR 255 0 0 > > > END > > this one to > > > > > END # Class > > > END # Layer > > > > > > > > > _______________________________________________ > > > mapserver-users mailing list > > > [email protected] > > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/mapserver- > users/attachments/20130809/adeae762/attachment.html> > > ------------------------------ > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > End of mapserver-users Digest, Vol 67, Issue 11 > *********************************************** _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
