[OSM-talk] osm2pgsql.exe available now for Windows users through MS4W
Sharing the news here with the OSM community, that the latest MS4W (MapServer for Windows) installer now also includes osm2pgsql.exe (master, -with-lua), which helps provide an easy SDI solution for Windows users, offering fast services of WMS/WFS/WFS-T,WCS,WPS,CSW,SOS and tiles, with a simple extract of a zipfile. Thanks to the OSM community and tile-serving team for the great osm2pgsql tool. -jeff Forwarded Message Hello all! Today is a big day as Gateway Geomatics is truly proud to announce that MS4W 4.0.0 is finally available! This is a huge release of changes, as every library (over 200 now) has been upgraded and built with a new compiler (Visual Studio 2017), and contains many great additions overall. Get it now at https://ms4w.com Please see MS4W's HISTORY.txt for all of the changes (or the bottom of this email for the full list), but here are some of the highlights: - PHP7 mapscript support (using the SWIG API) - PHP 7.2.16 - embedded Python 3.7.0 - running pycsw Catalogue Server - expanded ZOO-Project WPS support (all GDAL/OGR services, Python, PHP, CSharp, Java) - new Matomo Analytics package - simple map viewer on the localhost page - GDAL 2.4.0 - MapServer 7.4.0-dev - mod_wsgi for Apache - Mapbox Vector Tile output through MapServer (demo included) - osm2pgsql commandline utility - many HTTPS config changes and fixes (including a workaround for a show-stopping MapCache issue on some systems) - enhancements to the setup.exe installer - and many more... You can see that MS4W-4.0.0 is a full SDI for Windows environments, with ~40+ working mapfiles and over 1.7GB of files, empowering DevOps and organizations worldwide. Also note that this is a major release for MS4W, meaning that some things have changed dramatically (PHPmapscript will now use the SWIG API for example), so please follow MS4W's README for specific instructions for the many plugins and mapscripts. When installing, it is very important that (if you are using the .zip) your server must have the C++ Redistributable installed on it beforehand: execute the local file /ms4w/tmp/vcredist_x86.exe (alternatively if you use MS4W's setup.exe installer this is done automatically) As always please provide your requests for enhancements and issues through the MS4W tracker (so the feedback is not lost or forgotten): https://ms4w.com/trac/ You can also contact me directly for support. Thank you all for sharing your spatial information with MS4W !! "MS4W: open doors as well as windows" -jeff -- Jeff McKenna MapServer Consulting and Training Services https://gatewaygeomatics.com/ Full 4.0 Changelog -- 2019-03-12 * ms4w version 4.0.0 created. Notable changes are: - upgraded PHP to 7.2.16 (trac ticket 194) - re-add php_ogr.dll extension (trac ticket 190) - upgraded MapServer and MapScript (CSharp, Java, Python, PHP) to today's 7.4.0-dev - upgraded MapCache to today's 1.7dev - handle null MapCache CURL_CA_BUNDLE environment variable occuring on some systems (trac ticket 189) - include latest mapcache.xml.sample - added SSL_CERT_FILE path to setenv.bat - set certificates bundle path in php.ini (trac ticket 171) - set OPENSSL_CONF path in httpd.conf - added osm2pgsql commandline utility, with Visual Studio 2017 compiler (trac ticket 48) - clean unused files from the TinyOWS demo (trac ticket 183) 2019-02-11 * ms4w version 4.0.0-beta2 created. Notable changes are: - upgraded PHP to 7.2.15 (trac ticket 184) - upgraded APCu to 5.1.17 - upgraded MapServer and MapScript (CSharp, Java, Python, PHP) to today's 7.4.0-dev - moved mapscript plugins into /ms4w/msplugins - moved test-cgi-mapscript.py into /ms4w/msplugins/mapscript/python - use relative paths for MapCache and mod_wsgi Apache modules (trac ticket 185) - use relative paths for ZOO-Project's main.cfg 2019-02-04 * ms4w version 4.0.0-beta1 created. Notable changes are: - upgraded MapServer and MapScript (CSharp, Java, Python, PHP) to 7.4.0-dev with Visual Studio 2017 compiler - upgraded PHP to 7.2.14 (trac ticket 67) - added Python 3.7.0 into base installation, with Visual Studio 2017 compiler (trac ticket 65) - added Mapbox Vector Tile (MVT) output for MapServer with Visual Studio 2017 compiler (trac ticket 166) - added MVT demo, credit to Steve Lime - upgraded GDAL to 2.4.0 with Visual Studio 2017 compiler (trac ticket 164) - upgraded Apache HTTP Server to 2.4.38 with Visual Studio 2017 compiler (trac ticket 177) - added mod_wsgi 4.6.5 for Apache HTTP Server with Visual Studio 2017 compiler - rebuilt MapCache with Visual Studio 2017 compiler - moved MapServer plugins (MSSQL, Oracle) into /ms4w/msplugins/ - upgraded
[OSM-talk] osm2pgsql.exe for win32 | Cinnection to (public) database failed ....
My PostgreSQL-Server is running on localhost port 5432 and i've set up a database called 'postgis' but when i try to osm2pgsql -d:postgis planet.osm i get this error: fe_sendauth: no password supplied but the database is set to 'public' - so, why i get this password error ? regards, andrew [EMAIL PROTECTED] schrieb: Seems that there is more stuff out there people don't know about ( : http://artem.dev.openstreetmap.org/files/osm2pgsql_latest.exe.zip http://artem.dev.openstreetmap.org/files/osm2pgsql.exe Andrew Jan-Benedict Glaw schrieb: On Fri, 2008-09-12 15:13:23 +0200, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: My Source: http://wiki.openstreetmap.org/index.php/Mapnik I have installed everything under Windows 2000 (SP4) and the demo (with the 3 pictures) works fine. Now i've two questions: *Question 1: How to convert the PLANET IN FILE on Windows/WIN32 * I know i've to execute this Command ... * ./osm2pgsql osm-U-m-d f: / osm/planet-080910.osm * osm2pgsql is binary program written in C. It may compile eg. under Cygwin, even easily. As an alternative, you'd run it on a Linux box and use the PostGIS database on your Windows box, which should work fine. but where ... Python-Shell ... Windows-Command ... or do i have to compile this command before i can use it on my win32-OS and how does this compilation work ? I cannot really help you with the compilation. Either run it on a Linux box (Debian even has it as a package), or try to build it with Cygwin. If that works, it's by far the easiest way to get it build for Windows. *Question 2: RENDERN TILES OF THE WORLD? * I rendered the deom and it works fine, but what are all the other steps, i've to do, before i can use the generate_tiles.py srcript to generate the world map level x (x=1-14)? http://svn.openstreetmap.org/applications/rendering/mapnik/generate_tiles.py Don't know, never did that :) MfG, JBG ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] osm2pgsql.exe for win32 | Cinnection to (public) database failed ....
contact at living-structures.de contact at living-structures.de writes: My PostgreSQL-Server is running on localhost port 5432 and i've set up a database called 'postgis' but when i try to osm2pgsql -d:postgis planet.osm i get this error: fe_sendauth: no password supplied but the database is set to 'public' - so, why i get this password error ? regards, andrewcontact at living-structures.de schrieb: You need to change PosGIS settings in pg_hba.conf so that database does not require password. It means setting method to trust. This belongs to restrictions of osm2pgsql for Windows: you cannot give db host, no port, no username nor password but everything must be set up so that the defaults work. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] osm2pgsql.exe for win32 | Connection ok but function addgeometrycolum( does'nt exist
ok, this works - but a new error appears: ... function addgeometrycollum(...) does'nt exist ... Do i have to import some mapnik-tables first ? - where i can find the import-file for this/these functions ? regards, andrew Jukka Rahkonen schrieb: contact at living-structures.de contact at living-structures.de writes: My PostgreSQL-Server is running on localhost port 5432 and i've set up a database called 'postgis' but when i try to osm2pgsql -d:postgis planet.osm i get this error: fe_sendauth: no password supplied but the database is set to 'public' - so, why i get this password error ? regards, andrewcontact at living-structures.de schrieb: You need to change PosGIS settings in pg_hba.conf so that database does not require password. It means setting method to trust. This belongs to restrictions of osm2pgsql for Windows: you cannot give db host, no port, no username nor password but everything must be set up so that the defaults work. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] osm2pgsql.exe for win32 | Connection ok but function addgeometrycolum( does'nt exist
contact at living-structures.de contact at living-structures.de writes: ok, this works - but a new error appears: ... function addgeometrycollum(...) does'nt exist ... Do i have to import some mapnik-tables first ? - where i can find the import-file for this/these functions ? regards, andrew Hi, I guess that you are missing the PostGIS extensions for PostgreSQL. Osm2pgsql is standalone and all is does is to import osm xml formated data into PostgeSQL database (partly, it does not import everything). It does not need anything from Mapnik, but is does need these additional PostGIS functions. PostGIS is shipped with PostgreSQL and you can install it as an option, or install it separately. I am running postgresql 8.2.6 with postgis-pg82-1.3.2. They play for sure together with osm2pgsql. For some reason I seem to have downgraded from postgressql 8.3, but I do not remember why. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] osm2pgsql.exe for win32 | DB Connection ok -d postgis-import is running | is final DB-Size more than 20GB ?
Ah, i got the right hint. Yes, i've installed postgis but i used the wrong command with _-d gis_ instead of -*d postgis*. Now the import-process is running - but i checked the installation folder of postgresql and saw that there's only 24GB left of space. Is that enough ? If not, how can i move the /data/ folder of my current postgresql-installation to another harddrive. is there a config-file where i can change the location/path ? regards, Andrew Hi, I guess that you are missing the PostGIS extensions for PostgreSQL. Osm2pgsql is standalone and all is does is to import osm xml formated data into PostgeSQL database (partly, it does not import everything). It does not need anything from Mapnik, but is does need these additional PostGIS functions. PostGIS is shipped with PostgreSQL and you can install it as an option, or install it separately. I am running postgresql 8.2.6 with postgis-pg82-1.3.2. They play for sure together with osm2pgsql. For some reason I seem to have downgraded from postgressql 8.3, but I do not remember why. Rahkonen Jukka schrieb: Addition to my last mail to posting list: you may have PosGIS installed, but you have not created your database with PostGIS functions. I am no master in this, I have just created my new PostGIS databases with wizard by using PostGIS template. Regards, -Jukka- -Alkuperäinen viesti- Lähettäjä: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Lähetetty: pe 12.9.2008 19:23 Vastaanottaja: Rahkonen Jukka; talk@openstreetmap.org Aihe: osm2pgsql.exe for win32 | Connection ok but function addgeometrycolum( does'nt exist ok, this works - but a new error appears: ... function addgeometrycollum(...) does'nt exist ... Do i have to import some mapnik-tables first ? - where i can find the import-file for this/these functions ? regards, andrew Jukka Rahkonen schrieb: contact at living-structures.de contact at living-structures.de writes: My PostgreSQL-Server is running on localhost port 5432 and i've set up a database called 'postgis' but when i try to osm2pgsql -d:postgis planet.osm i get this error: fe_sendauth: no password supplied but the database is set to 'public' - so, why i get this password error ? regards, andrewcontact at living-structures.de schrieb: You need to change PosGIS settings in pg_hba.conf so that database does not require password. It means setting method to trust. This belongs to restrictions of osm2pgsql for Windows: you cannot give db host, no port, no username nor password but everything must be set up so that the defaults work. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] osm2pgsql.exe for win32 | Connection ok but function addgeometrycolum( does'nt exist
On Fri, 2008-09-12 at 18:23 +0200, [EMAIL PROTECTED] wrote: ok, this works - but a new error appears: ... function addgeometrycollum(...) does'nt exist ... Do i have to import some mapnik-tables first ? - where i can find the import-file for this/these functions ? You need postGIS which is an extension to PostgreSQL providing geospatial features: http://postgis.refractions.net/ Some instructions are on the Wiki but are none currently for Windows (you like might to add some) http://wiki.openstreetmap.org/index.php/Mapnik/PostGIS Jon ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] osm2pgsql.exe for win32 | DB Connection ok -d
[EMAIL PROTECTED] wrote: If not, how can i move the /data/ folder of my current postgresql-installation to another harddrive. is there a config-file where i can change the location/path ? The -D flag tells the postmaster where to look for its database files and config, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are ! -- ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] osm2pgsql.exe on Win32
Artem, As a follow up I managed to get Boost Build to work with simple files, but am stuck with something so complicated as osm2pgsql. I know this is way out of my depth, as I don't have the expertise to start playing around with compiling files meant for Linux systems, so I would appreciate any of the files you used to create the Windows build. By all means go and tell me to get Linux, but I'll probably wait until I can get one of those decent Asus Eees. Many thanks for your help Steve - Original Message From: Artem Pavlenko [EMAIL PROTECTED] To: S Knox [EMAIL PROTECTED] Cc: OpenStreetMap Openstreetmap talk@openstreetmap.org Sent: Wednesday, 23 January, 2008 12:14:35 PM Subject: Re: [OSM-talk] osm2pgsql.exe Hi Steve, My mail client junked your email - your date/time setting a bit ahead of time ?? Artem, Thanks very much for the Windows version of osm2pgsql. It's very fast and I have successfully used it to to create a Post GIS database. I don't know much about this, so excuse my ignorance if it is to lengthy to write about, but could you detail the steps you went through to compile the program for Windows. I I'm using Boost.Build.v2 and VC++ express for all win32 builds I had to modify osm2pgsql i.e. getopts was missing on win32 etc etc Also, I had to compile most of dependencies (geos, libxml, ??) from source to ensure they are linked to correct runtimes. My plan is to commit changes + Jamfiles to main osm svn at some point but I'm short of time at the moment. I am interested in possibly making a slightly customised version of the program that includes more tags in the database - i.e. not just for Mapnik use. Do you want to build it yourself ? I can gather bits and email it to you (possibly this weekend) Let me know. Many thanks Steve Cheers Artem Sent from Yahoo! - a smarter inbox. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk Sent from Yahoo! Mail. A Smarter Email. Sent from Yahoo! Mail. A Smarter Email. __ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk
Re: [OSM-talk] osm2pgsql.exe on Win32
On Mon, May 19, 2008 at 9:36 PM, S Knox [EMAIL PROTECTED] wrote: As a follow up I managed to get Boost Build to work with simple files, but am stuck with something so complicated as osm2pgsql. I know this is way out of my depth, as I don't have the expertise to start playing around with compiling files meant for Linux systems, so I would appreciate any of the files you used to create the Windows build. By all means go and tell me to get Linux, but I'll probably wait until I can get one of those decent Asus Eees. If you do get the source or a patch could you pass it on? If there's some simple changes that can be made to support windows then we could just incorporate them... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk
[OSM-talk] osm2pgsql.exe
Hello windows users, osm2pgsql.exe has arrived : http://artem.dev.openstreetmap.org/files/ osm2pgsql_latest.exe.zip Enjoy! Artem ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk