X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/63474e1f50d3d2678e17878ee6d689a025dda8ad..e3b8b8933044104bb515d34c3d36851caba78ac7:/db/README diff --git a/db/README b/db/README index 4f9fac629..db4f5c20e 100644 --- a/db/README +++ b/db/README @@ -32,6 +32,11 @@ Run this command in the db/functions directory: $ make libmyosm.so +You might also need to install: +- mysql client development libraries: $ sudo apt-get install libmysqlclient16-dev +- ruby development libraries: $ sudo apt-get install ruby1.8-dev +for build to succeed. + Make sure the db/functions directory is on the MySQL server's library path and restart the MySQL server. @@ -56,13 +61,18 @@ Run this command in the db/functions directory: $ make libpgosm.so +You might also need to install: +- postgresql development libraries: $ sudo apt-get install postgresql-server-dev-8.3 +- ruby development libraries: $ sudo apt-get install ruby1.8-dev +for build to succeed. + Now create the function as follows: $ psql openstreetmap (This may need authentication or a -u ) > CREATE FUNCTION maptile_for_point(int8, int8, int4) RETURNS int4 - AS '/path/to/rails-port/db/functions/libpgosm', 'maptile_for_point' + AS '/path/to/rails-port/db/functions/libpgosm.so', 'maptile_for_point' LANGUAGE C STRICT; Creating database skeleton tables @@ -73,3 +83,7 @@ Run this command from the root of your rails directory: $ rake db:migrate This will create the db for you + +You will need to make sure the database connection is configured in database.yml in config directory +You might start with example configuration provided: +$ cp config/mysql.example.database.yml config/database.yml