What's new? | Help | Directory | Sign in
Google
Project Home
  
Downloads
  
Wiki
  
Issues
  
Source
    
Search
for
Updated May 12, 2008 by seba.wagner
InstallationOfRelease05  
Installation of 05 Final Release

Requirements

Database MUST listen and allow TCP/IP connections! And the default character-set/scheme must be UTF8! For example a fresh MySQL does not listen on TCP/IP by default and has not utf8 as default-character-set defined. You have to change these settings and restart your database server so that changes take effect (mysql-config is in my.cnf). Postgres for example does also not listen by default on TCP/IP but uses by default UTF8 (since postgres 7 or 8). To change Postgres listening on TCP/IP check postgresql.conf and add your host to the pg_hba.conf. In Postgres you need to create a database using template1 cause template1 create automatically a scheme called public which is needed (and since postgres 8 you can use several schemes inside one database public is the default one Postgres-Docs).
  • OpenOffice-Service started and listening on port 8100 (see OpenOfficeConverter, this is not necessary for installation but for running later on)
  • Installed ImageMagick (this is not necessary for installation but for running later on), you can get more information on http://www.imagemagick.org regarding installation. The instructions for installation can be found there http://www.imagemagick.org/script/binary-releases.php, however on most linux systems you can get it via your favorite package managers (apt-get it)
  • Installed GhostScript (this is not necessary for installation but for running later on), you can get more information on http://pages.cs.wisc.edu/~ghost/ regarding installation. The instructions for installation can be found there, however on most linux systems you can get it via your favorite package managers (apt-get it).
  • Installed SWFTools (this is not necessary for installation but for running later on), you can get more information on http://www.swftools.org/ regarding installation. Some of the Linux distributions already have it in there package manager see http://packages.debian.org/unstable/utils/swftools)

ScreenCast

Install Red5 Server v0.6.3

Install OpenMeetings

  1. Download OpenMeetings 0.5 Final from [ http://code.google.com/p/openmeetings/downloads/list OpenMeetings-Download-Page] (Please make sure that you use an up-to-date unzip-software)
  2. Unpack it to $RED5-HOME/webapps/ your new folder structure will be $RED5-HOME/webapps/openmeetings/ this is the base directory of OpenMeetings (following $OPENMEETINGS-HOME)
  3. Prepare Database Settings - go to $OPENMEETINGS-HOME/conf there are two pre-configured files for MySQL and Postgres: mysql_hibernate.cfg.xml and postgres_hibernate.cfg.xml. Following explains it for MySQL-Database-Users, Postgres-Database-Users and Any-Database-Users. Choose Your One!! Of course the database must already exist! Meaning if you want to use jdbc:mysql://localhost/openmeetings then the database openmeetings must be already an existing empty database (with character encoding utf8)!!
    • MySQL-Database-User: Rename mysql_hibernate.cfg.xml to hibernate.cfg.xml and alter following config values in (mysql_)hibernate.cfg.xml 
      • 		<property name="connection.username">root</property>
		<property name="connection.password"></property>

		<property name="connection.url">jdbc:mysql://YOUR_HOSTNAME/YOUR_DATABASE</property>
    If you have problems in connecting your database, a common error is that the Database does not listen to TCP/IP Connection, or you properly need to replace the jdbc-driver with the one for your mysql-version, see http://www.mysql.com/products/connector/j/ for drivers and replace the mysql-connector-java-3.1.14-bin.jar in openmeetings/WEB-INF/lib with the one you have downloaded. If your mysql server is not located in localhost make sure the mysql-server is listening on that network-interface. Of course you must alter YOUR_HOSTNAME/YOUR_DATABASE to fit your needs for example to:jdbc:mysql://localhost/openmeetings
    • Postgres-Database-Users: Rename postgres_hibernate.cfg.xml to hibernate.cfg.xml and alter following config values in (postgres_)hibernate.cfg.xml 
      • 		<!-- User  / Password -->
		<property name="connection.username">postgres</property>
		<property name="connection.password"></property>
		
		<property name="connection.url">jdbc:postgresql://YOUR_HOSTNAME/YOUR_DATABASE</property>
    If you go problems in connecting your database you properly need to replace the jdbc-driver with the one for your postgres-version, see http://jdbc.postgresql.org/download.html for drivers and replace the postgresql-8.2-504.jdbc2.jar in openmeetings/WEB-INF/lib with the one you have downloaded. Don't forget that the encoding of the database must be UTF8! Of course you must alter YOUR_HOSTNAME/YOUR_DATABASE to fit your needs for example to:jdbc:postgresql://localhost/openmeetings
    • Any-Database-Users: Rename any_hibernate.cfg.xml to hibernate.cfg.xml.
    Alter the following config values to fit your needs: 
    		<!-- User  / Password -->
		<property name="connection.username">user</property>
		<property name="connection.password">*****</property>
		
		<!-- Database Settings -->
		<property name="connection.driver_class">org.postgresql.Driver</property>
		<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
		<property name="connection.url">jdbc:postgresql://localhost/openmeetings</property>
    You can see a list of available dialect's here hibernate-SQL-dialects. You must download the driver for your database and copy it to $OPENMEETINGS-HOME/WEB-INF/lib
  4. (Re)start Red5 (The table's and default database scheme will be automatically created by hibernate if there is something wrong with your database values you will see errors in Red5 logfile, you can reduce Error log output by switching $RED5-HOME/conf/log4j.properties from DEBUG to ERROR to see only relevant value's)
  5. on Linux/OSX: Mage the converting-scripts writeable:
change directory to $OPENMEETINGS-HOME/jod, and do a: chmod +x .sh
  1. go to the Installer by accessing it via browser: http://$rmpthostlocal/openmeetings/install and follow the instructions

After Running the Installer all basics are installed. Now login and go to the Meeting-Rooms and check all features. You possibly will have some difficulties uploading files. Check if OpenOffice is really running, swftool, ImageMagick (including GhostScript) is available on your System-Path (or your customize the path in the Configuration). On Linux your possibly will have to make some shell-Script executable, you find them in $Openmeetings-Home/jod/.sh.

Tips and Tricks

Sign in to add a comment