Geoserver+mysql Installation and configuration process

GeoServer installation configuration please refer to http://simen-net.iteye.com/blog/609078

Since most of the Webgis is not just a map display, but also needs some business processing, will be useful to the database place, so I want to put the map into the database, so that the performance, security and other aspects have a great improvement, especially when modifying the map can be directly to the database operation. This tests the installation configuration in MySQL background.

1. Download and install MySQL5

2. Convert Map to Database

Download http://code.google.com/p/qogr2ogr/, this is a very good open source gadget, in fact, is Ogr2ogr GUI program, we should encourage more encouragement AH!!! This gadget can directly support MySQL input import, is the aspect, we refer to the following image to operate on it. The database name here is map

3. Download and install geoserver MySQL plugin

MySQL plugin (http://downloads.sourceforge.net/geoserver/geoserver-2.0.1-mysql-plugin.zip), Unzip the Geoserver-2.0.1-mysql-plugin.zip and copy the Gt-jdbc-mysql-2.6.1.jar and Mysql-connector-java-5.1.5.jar to the Webapps/geoserver Please restart Tomcat after/web-inf/lib

4. New MySQL Store

Here choose MySQL as the store, fill in the content should not have too much to be, everyone reference

After saving the following interface appears, this shows found in the database of three tables, but only useful bount_line, so we only publish him

The following need attention!!! Here are two menu [Data] and [publishing],data section reference http://simen-net.iteye.com/blog/609078 in the method of SHP configuration, here also need to set the following [Publishing] section

[Publishing] To set the default style for line, why? Because I'm using the Bount_line map, he's actually a line type, in http://simen-net.iteye.com/blog/609078 Does not need to set [publishing] feeling is because geoserver through the SHP file identified his type, but converted to a database after the recognition, if not set to line type, the publication can be successful, but the map is all point.

The rest is the same as http://simen-net.iteye.com/blog/609078.

Geoserver+mysql Installation and configuration process