Setting up the Database

LSPS requires an lsps database with a dedicated user to store its system data. To set up such a database, do the following:

1. Make sure the database is supported by your application server.

2. Create a database with the character encoding to UTF-8.

   Example MySQL database setup with UTF-8

   CREATE DATABASE lsps DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
   GRANT ALL PRIVILEGES ON lsps.* TO lsps@'' IDENTIFIED BY 'lsps'; 
   FLUSH PRIVILEGES;

3. Initialize the database with the db-migration tool from the runtime suite: ./migrate.sh databaseUrl:<DATABASE_URL> user:<DB_USER> password:<ESCAPED_DB_PASSWD> (for details, refer to migratescriptparams).
4. Configure your database:
   • Microsoft SQL server:
     • Enable the XA transaction support. Refer to the relevant Microsoft documentation for information on your version of Microsoft SQL server and JDBC driver; for example, for Windows Server 2003 and sqljdbc4.jar, refer to http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 and http://msdn.microsoft.com/en-US/library/aa342335(v=sql.90).
     • It might be necessary to install MSDTC in Windows (Add/remove Windows components -> Application Server -> Details -> Enable network DTC access).
   • On MySQL, set the allowed packet size to 512 MBs and the default time zone in the configuration file of your mysql server, typically, the my.cnf or mysqld.conf files:

     [mysqld] 
       max_allowed_packet=512M
       default_time_zone='+0:00'