WiseMapping supports a wide variety of databases. However, we run intensively tests over HSQL and MySQL database.
In the following section, you are going to find a
detailled detailed explanation how to configure you WiseMapping using MySQL 5.5.
MySQL 5.5 Installation
Prerequisites
- Download and install MySQL. You can download it for free from:
Inside the WiseMapping binary distribution, you will find a directory "config/mysql". It contains all the SQL script required to configure a new WiseMapping database instance. You will find 4 scripts:
- create-database.sql: Create all wisemapping database and wisemapping user.
- create-schemas.sql: Create all database tables and index.
...
...
- schemas.sql: Creates a mind map example and an a test user "test@wisemapping.org" with password "test".
- drop-schemas.sql: Drop all wisemapping tables in case you want to have a fresh installation.
There are a lot of good tools you can use to run this scripts (eg: MySQLWorkbench). However, the simples way is to use the command line tool that is distributed as part of the MySQL installation.
If you are one brave hearts that is not afraid of the command line tools, open a terminar and execute the following lines:
Code Block |
---|
|
cd <WISEMAPPING-DIR>/config/database/mysql |
# Default MySQL installation creates a "root" user with empty password. You can connect to the database with this user if you are # logged in same machine where |
the the database is installed and must be |
executed logged executed logged as "root" |
#
# If you have changed the default database
#
# If you have changed the default database "root" password , you need to specify an additional -p parameter and |
provide the # new password.
mysql -uroot < create provide the
# new password.
mysql -uroot < create-database.sql |
# Create tables and default tests user |
mysql -uwisemapping -Dwisemapping -ppassword < create-schemas.sql |
mysql -uwisemapping -Dwisemapping -ppassword < |
testdata
Great, you have configured you database !. Let's configure WiseMapping now.
Configure WiseMapping
Next step, you must edit the file <WISEMAPING_DIR>/webapps/wisemapping/WEB-INF/app.properties and uncomment the MySQL configuration parameters and comment all HSQL configuration properties.
Done, you have configured WiseMapping to use MySQL!. If you want to start WiseMapping right now:
- Open a command line terminal within
wisemapping-<version>
directory - Finally, execute
~:>
java -Dorg.apache.jasper.compiler.disablejsr199=true -jar start.jar
...