Configuring MySQL

Before installing the UrbanCode Release server, create a MySQL database. Ideally the database will be installed on a machine other than the one where the server is located.

When you install UrbanCode Release, you will need the connection information, and a user account with table creation privileges.

  1. Create a MySQL database named UrbanCode Release.

  2. Create a user named UrbanCode Release and grant it all privileges on the database. The user password will be used in the conf file.

  3. Obtain the MySQL JDBC driver .jar file. The driver is unique to the edition you are using.

    Copy the JDBC .jar file to tomcat_directory\lib.

  4. Modify the following parameters in the server.properties file: 

    	database.type=mysql
	hibernate.connection.driver_class=com.mysql.jdbc.Driver
	hibernate.connection.url=jdbc\:mysql\://localhost\:3306/urelease
	hibernate.connection.username=urelease
	hibernate.connection.password=urelease

    Important

    Database configuration is done by modifying parameters in the server.properties file located at user_home_directory/.urbancode/urelease/conf. On Unix, the user_home_directory is /home; on Windows it is determined by the user profile, which typically is \Users\current_user. Because UrbanCode Release is deployed as a Tomcat web application, the conf file will not be created until UrbanCode Release is deployed, which means that the configuration changes cannot be made until after initial deployment.

    Note

    Initially, the password contains an encrypted string. Overwrite the string with the new password. The first time the password is entered it will be plain text, but will be encrypted the next time UrbanCode Release starts.

  5. When you are fished, restart the Tomcat server.

Prev  Up  Next
  Home