Installing OpenMeeting with MySQL

Posted by on 14 Mar 2013 in Applications

From Wikipedia OpenMeeting is:

OpenMeetings is software used for presenting, online training, web conferencing, collaborative whiteboard drawing and document editing, and user desktop sharing. The product is based on OpenLaszlo RIA framework and Red5 media server, which in turn are based on a bunch of open source components. Communication takes place in meeting rooms which are set to different communication, security and video quality modes. The recommended database for backend support is MySQL. The product can be set up as an installed server product, or used as a hosted product.

Today we will be installing OpenMeeting on CentOS 6.3 (64-bit). Find a nice place to work:

mkdir /home/dev cd /home/dev

Go to http://openmeetings.apache.org/downloads.html and download and unpack latest binary.

wget http://archive.apache.org/dist/incubator/openmeetings/2.0-incubating/apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz
mkdir openmeeting
cd openmeeting
tar -xzvf ../apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz

The default installation of OpenMeeting uses an integrated Apache Derby database to persist data at the back end. They recommend MySQL (or a real database) for production installations. I however, like to easily poke around the database and investigate how the product works. The trouble with an integrated database is that it won’t be available when the application is down and it may not be available to clients outside the application. OpenMeeting requires UTF8 so we’ll install MySQL and configure the collation.

Install PHP and MySQL with yum

yum install php mysql-server mysql

There are a few problems of setting the collation with MySQL so. Edit /etc/my.cnf and add the following lines to the mysqld section:
[mysqld] skip-character-set-client-handshake collation-server = utf8_unicode_ci init-connect=’SET NAMES utf8′ character-set-server = utf8
Then restart MySQL with:
/etc/init.d/mysqld restart

Now that we have MySQL installed, we’ll have to create a MySQL account for OpenMeeting to use.

Login to MySQL:
mysql -uroot
Create the database:
CREATE DATABASE openmeetings;
Create a MySQL user for the application:
CREATE USER openmeetings;
Set permissions:
GRANT ALL ON openmeetings.* TO openmeetings@localhost;
Set password (change **** to your password):
SET PASSWORD FOR openmeetings@localhost=PASSWORD(’****’);
Log out of MySQL:
exit;
Now we will just check that our new user is set up properly. (Where **** is the password)
mysql -uopenmeetings -p**** openmeetings

OpenMeeting isn’t bundled with all the database connectors so we’ll have to download and install the MySQL connector in order to talk to the database.

Start off in our dev area:
cd /home/dev
Go to http://www.mysql.com/downloads/connector/j/ and download the latest ConnectorJ (at the time of writing this was 5.1.24)
Unpack it:
tar -xvzf mysql-connector-java-5.1.24.tar.gz
Move the connector to the correct place in the OpenMeeting directory structure so it can be found by the application:
mv mysql-connector-java-5.1.24/mysql-connector-java-5.1.24-bin.jar openmeeting/webapps/openmeetings/WEB-INF/lib/

We are not using the default database type so we must change the configuration files so that the OpenMeeting installation process uses the MySQL configuration file instead of the integrated Derby configuration file.

Go to the connectors folder:
cd /home/dev/openmeeting/webapps/openmeetings/WEB-INF/classes/META-INF
Use the MySQL configuration template:
cp mysql_persistence.xml persistence.xml
Edit persistence.xml and change the MySQL credentials. At the bottom of the file you will see
value="DriverClassName=com.mysql.jdbc.Driver , Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect…. …. , MaxActive=100 , MaxWait=10000 , TestOnBorrow=true , poolPreparedStatements=true , Username=openmeetings , Password=****"/>
Change the Username and Password to what you set earlier. If you want to change the database name localhost:3306/openmeetings? will become localhost:3306/my_database?.

Now we are going to set up Enabling Image Upload and import to whiteboard. To install ImageMagick we’ll use the package manager:

yum install ImageMagick

Installing ImageMagick will install GhostScript as a dependency so we get part 1 of Enabling import of PDFs into whiteboard for free. Part 2 requires installing SWFTools which we will do now:

Start in our development directory:
cd /home/dev
Go to http://www.swftools.org/download.html and get the latest version:
wget http://www.swftools.org/swftools-0.9.2.tar.gz
Unpack with:
tar -xvzf swftools-0.9.2.tar.gz
If this is a minimal version of CentOS (or you type gcc and get bad command) then you’ll need to install the C compiler and tools:
yum install gcc* automake zlib-devel libjpeg-devel giflib-devel freetype-devel make
Prepare to build the software:
cd /home/dev/swftools-0.9.2
Run the pre-build configuration script:
./configure
Build SWFTools:
make

There is a bug in the make install step so we’ll just fix that before running it.

Edit /home/dev/swftools-0.9.2/swfs/Makefile

Search for the install: directive and change:

        rm -f $(pkgdatadir)/swfs/default_viewer.swf -o -L $(pkgdatadir)/swfs/default_viewer.swf
        $(LN_S) $(pkgdatadir)/swfs/simple_viewer.swf $(pkgdatadir)/swfs/default_viewer.swf
        rm -f $(pkgdatadir)/swfs/default_loader.swf -o -L $(pkgdatadir)/swfs/default_loader.swf
        $(LN_S) $(pkgdatadir)/swfs/tessel_loader.swf $(pkgdatadir)/swfs/default_loader.swf

<TAB>rm -f $(pkgdatadir)/swfs/default_viewer.swf
<TAB>$(LN_S) $(pkgdatadir)/swfs/simple_viewer.swf $(pkgdatadir)/swfs/default_viewer.swf
<TAB>rm -f $(pkgdatadir)/swfs/default_loader.swf
<TAB>$(LN_S) $(pkgdatadir)/swfs/tessel_loader.swf $(pkgdatadir)/swfs/default_loader.swf

Make sure that the first and only character at the start of the replacement lines is a TAB and not a space.

Now we can run:
make install

Next we’ll install the dependencies for Enabling import of .doc, .docx, .ppt, .pptx, … all Office Documents into whitebaord. This also installs Oracle’s Java which is why we didn’t install it earlier.

Install Libre Office:
yum install libreoffice-writer

Enabling Recording and import of .avi, .flv, .mov and .mp4 into whiteboard requires FFMpeg which is not available via standard yum so we’ll add another repository that does contain it. Thanks to needlessly does a “yum update” which would probably update everything seeing as CentOS keep stable older version instead of the bleeding edge.

Edit /etc/yum.repos.d/dag.repo
Add:
[dag] name=DAG RPM Repository baseurl=http://apt.sw.be/redhat/el$releasever/en/$basearch/dag gpgcheck=1 enabled=1
Import keys so we can talk to the repository securely:
rpm −−import http://apt.sw.be/RPM-GPG-KEY.dag.txt
Start installation:
yum install ffmpeg

Enabling Recording and import of .avi, .flv, .mov and .mp4 into whiteboard also requires SOX but that is available on the standard yum so just install that.

yum install sox

I have read through the installation instructions for OpenMeeting and they are as clear as mud. Half the documents seem to say that JODConverter is needed and the other half say that it isn’t. Even the project page for JODConverter says that the project isn’t even maintained. It has some connection to OpenOffice/LibreOffice, so I’m installing it anyway just in case.

Change back to our scratch folder:
cd /home/dev
Go to http://code.google.com/p/jodconverter/
And download the latest version:
wget http://jodconverter.googlecode.com/files/jodconverter-core-3.0-beta-4-dist.zip
Then unzip it
unzip jodconverter-core-3.0-beta-4-dist.zip

Well that’s it for the dependencies. Hopefully OpenMeeting will find all the things it needs during it installation. After following the original instructions for installing OpenMeeting, the Oracle Java had been replaced by the GNU version of the Java runtime. When I started the OpenMeeting container it use that version instead of the Oracle implementation and didn’t work. If you install the dependencies in the order that I described above then Oracle’s Java should come out on top. We need to check to make sure though:

Get which version of Java are you running:
java -version
You should get:
java version “1.7.0_13″ Java™ SE Runtime Environment (build 1.7.0_13-b20) Java HotSpot™ 64-Bit Server VM (build 23.7-b01, mixed mode)
If you don’t then you’ll have to uninstall the GNU version:
yum remove gij rpm -e jre
And reinstall Oracle’s Java over the top:
1. Navigate to: http://www.java.com/en/download/manual.jsp
2. And download the appropriate version I selected “Linux x64 RPM".
3. Install via the Redhat Package Manager, you might see a couple of errors like “Error: Could not open input file” but you can ignore these.
  rpm -i jre-7u13-linux-x64.rpm

OpenMeeting uses a couple of ports to communicate with so make sure your firewall allows traffic on them. For development purposes the following will remove all firewall rules until you reboot.

iptables -F

To start OpenMeeting:

Change directory:
cd /home/dev/openmeeting
Type:
./red5.sh

It should print a lot of information on the screen. There will be pauses and gaps but when it starts repeating no Appointments in range you are ready for the next step. You can check [crudely] that the database has been created in MySQL by ensuring that there are plenty of files in: /var/lib/mysql/openmeetings/ The final part of the installation is run from the web interface so navigate to: http://localhost:5080/openmeetings/install where localhost is the machine you have installed OpenMeeting on. Click the link Continue with STEP 1. This will take you to the initial configuration screen where you can set up the application: In the Userdata section fill in the admin user Username: admin Password: admin Email: myemail@example.com In the Configuration section I didn’t touch anything but the names seem pretty self explanatory if you know how to set up your mail system (which is beyond the scope of this document). In the Converters section we need to add the paths to the support utilities as they won’t be available to the servlet container. All the Converter support applications should be in your path except jodconverter-core. I still don’t understand if or how JODConverter is needed, so add a reference to the JOD path anyway.

/home/dev/jodconverter-core-3.0-beta-4/lib

I leave all the other stuff to their defaults. Finally click INSTALL. The red5.sh screen will spend a couple of minutes spewing out data, so let it get on with it. When it has finished your web browser will sent you to the “Installation Complete!” page. Click Enter the Application and login with Username as admin and Password as admin. The rest is up to you! Good luck.

28 comments

Comment from: Amir [Visitor]

it is very much appreciating that you and your team is working on it for educational activity in the world, I belong to a poor country and we need education in remote areas but before this openmeeting I was unable to give education in remote areas but now I can do it with your help, God bless you.

Comment from: rockylee [Visitor]

install error

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error that prevented it from fulfilling this request.

exception

java.lang.NullPointerException

org.apache.velocity.tools.view.VelocityView.performMerge(VelocityView.java:942)
org.apache.velocity.tools.view.VelocityView.merge(VelocityView.java:902)
org.apache.velocity.tools.view.VelocityViewServlet.mergeTemplate(VelocityViewServlet.java:318)
org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:220)
org.apache.velocity.tools.view.VelocityViewServlet.doGet(VelocityViewServlet.java:182)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:77)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.34 logs. Apache Tomcat/7.0.34

how to fix it

Comment from: davidnewcomb [Member]

At what stage of the installation did you get this error?

Comment from: rockylee [Visitor]

The final part of the installation is run from the web interface so navigate to: http://localhost:5080/openmeetings/install

SET PASSWORD FOR openmeetings@localhost=PASSWORD(’****’);

, Username=openmeetings , Password=****"/>

password is the same but still error

Comment from: davidnewcomb [Member]

I didn’t understand your comment. You have gone to “http://localhost:5080/openmeetings/install” ok? Then what happened? What did you see on the screen? What was in the log?

Comment from: rockylee [Visitor]

i install ok but interface error like http://i62.photobucket.com/albums/h118/lee62817/Screenshot_zps8e8b2c09.png

my centos :6.3X64

how can use Chinese languare

Comment from: rockylee [Visitor]

thank you very much

it’s can work

Comment from: davidnewcomb [Member]

After installation log in and go to the Language Editor (Administration->Languages) and reset the language. Restart the server to take effect. https://code.google.com/p/openmeetings/wiki/LanguageEditor

Comment from: rockylee [Visitor]

OpenMeetings - Installation Continue with STEP 1

SWFTools Path:/usr/local/bin ImageMagick Path:/usr/bin FFMPEG Path:/usr/bin SoX Path:/usr/bin JOD Path:./jodconverter-core-3.0-beta-4/lib

OpenOffice/LibreOffice Path for jodconverter:/usr/lib64/libreoffice

when i install ok

i can upload pdf .jpg to room file

but when i upload .ppt and .xlsx

get something wrong

key: processSWF process: generateSwf command; [/usr/local/bin/pdf2swf, -s, insertstop, -s, poly2bitmap, -i, -j, 85, -s, zoom=72, /opt/openmeetings/webapps/openmeetings/upload/files/14496d669f593d9eb396e34316701364/14496d669f593d9eb396e34316701364.pdf, /opt/openmeetings/webapps/openmeetings/upload/files/14496d669f593d9eb396e34316701364/14496d669f593d9eb396e34316701364.swf] exception: null error: Error: Couldn’t open file ‘/opt/openmeetings/webapps/openmeetings/upload/files/14496d669f593d9eb396e34316701364/14496d669f593d9eb396e34316701364.pdf’

exitValue: null out: key: processThumb process: generateBatchThumbByWidth command; [/usr/bin/convert, -thumbnail, 80, /opt/openmeetings/webapps/openmeetings/upload/files/14496d669f593d9eb396e34316701364/14496d669f593d9eb396e34316701364.pdf, /opt/openmeetings/webapps/openmeetings/upload/files/14496d669f593d9eb396e34316701364/_thumb_page-%04d.jpg] exception: null error: convert: unable to open image `/opt/openmeetings/webapps/openmeetings/upload/files/14496d669f593d9eb396e34316701364/14496d669f593d9eb396e34316701364.pdf’: 沒有此一檔案或目錄 @ blob.c/OpenBlob/2480. convert: missing an image filename `/opt/openmeetings/webapps/openmeetings/upload/files/14496d669f593d9eb396e34316701364/_thumb_page-%04d.jpg’ @ convert.c/ConvertImageCommand/2800.

exitValue: null out: key: processXML process: generateXMLDocument command; null exception: null error: null exitValue: null out: null key: processOpenOffice process: doJodConvert command; null exception: java.lang.Exception: Path to JOD Library folder does not exist error: Path to JOD Library folder does not exist exitValue: java.lang.Exception: Path to JOD Library folder does not exist out: null

please help me fix this error

Comment from: davidnewcomb [Member]

All error messages stem from the “exception: java.lang.Exception: Path to JOD Library folder does not exist".

Your “JOD Path” is relative. The trouble with relative paths is that it’s often difficult to work out where you are relative to! Change the JOD Path to an absolute path and you should be fine.

Comment from: rockylee [Visitor]

ppt & xls can not convert

it seem like not install program

i use you install libreoffice

all convert ok

thank you very much

Comment from: farah [Visitor]

can i edit template for the video in openmeetings to set place for each video conference for any room?

Comment from: davidnewcomb [Member]

Sorry, I don’t understand what you are asking for.

Comment from: Jose Hernandez [Visitor]

I did try the instructions step by step and no luck… please let me know how much it will cost to have you doing it for me. My server runs in CentOS 5 64-bit.

Comment from: Handy Firmansyah [Visitor]

i’ve got this error in my CentOS 6.4 32-bit Exception org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘red5.common’ defined in class path resource [red5.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.FileSystemXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘mbeanExporter’: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ’schedulingService’ defined in class path resource [red5-common.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: Cannot run without an instance id. Can you help me resolve this problem? Thank you

Best regard, Handy F

Comment from: Jerry Tse [Visitor]

the same error at installation step2. To rockylee and David, how to fix it? Thanks

Comment from: rockylee [Visitor] install error

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error that prevented it from fulfilling this request.

exception

java.lang.NullPointerException org.apache.velocity.tools.view.VelocityView.performMerge(VelocityView.java:942) org.apache.velocity.tools.view.VelocityView.merge(VelocityView.java:902) org.apache.velocity.tools.view.VelocityViewServlet.mergeTemplate(VelocityViewServlet.java:318) org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:220) org.apache.velocity.tools.view.VelocityViewServlet.doGet(VelocityViewServlet.java:182) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:77)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.34 logs. Apache Tomcat/7.0.34

Comment from: Dave [Visitor]

Tried. Worked great. I had to do a few adjustments but overall good procedure guide.

Comment from: davidnewcomb [Member]

If you tell me what the changes were, I’ll reincorporate them into the guide.

Comment from: Petter [Visitor]

Hello,davidnewcomb

I have installed openmeeting with this articiles.But it failed.

OS: CentOS 6.4 x86_64

error: [INFO] [main] org.springframework.beans.factory.support.DefaultListableBeanFactory - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@139df700: defining beans [placeholderConfig,red5.common,red5.core,context.loader,pluginLauncher,tomcat.server,rtmpt.server]; root of factory hierarchy Exception org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘red5.common’ defined in class path resource [red5.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.FileSystemXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘mbeanExporter’: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ’schedulingService’ defined in class path resource [red5-common.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: Cannot run without an instance id.

How i can resolve it ? Can you help me ?

Comment from: bearclaw [Visitor]

to fix “cannot run without an instance id", your hostname must resolve: host $(cat /etc/hostname) must work.

Comment from: shamim [Visitor]

hello , I am facing an error the error is like:

this error occurs whe i do http://ip_address:5080/openmeetings/install …………………………………………….

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error that prevented it from fulfilling this request.

exception

java.lang.NullPointerException

org.apache.velocity.tools.view.VelocityView.performMerge(VelocityView.java:942)
org.apache.velocity.tools.view.VelocityView.merge(VelocityView.java:902)
org.apache.velocity.tools.view.VelocityViewServlet.mergeTemplate(VelocityViewServlet.java:318)
org.apache.velocity.tools.view.VelocityViewServlet.doRequest(VelocityViewServlet.java:220)
org.apache.velocity.tools.view.VelocityViewServlet.doGet(VelocityViewServlet.java:182)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:77)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.42 logs. Apache Tomcat/7.0.42

Comment from: shiv raj [Visitor]

I have installed openmeetings successfully and demo is also working on localhost:5080. After that i registered as user in openmeetings, login with this user, everything is fine. But when i checked database openmeetings, talbes users, no records i found. What is the issue?

Comment from: akshar [Visitor]

WARN 02-07 07:56:15.178 ConfigurationDao.java 117006 123 org.apache.openmeetings.db.dao.basic.ConfigurationDao [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-5] - Could not find key in configuration CONF_KEY: application.base.url WARN 02-07 07:56:15.179 ConfigurationDao.java 117007 123 org.apache.openmeetings.db.dao.basic.ConfigurationDao [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-5] - Could not find key in configuration CONF_KEY: number.minutes.reminder.send

any solution to this??

Comment from: ysh [Visitor]

I have a problem with my openmeetings page. I can upload file. In my openmeetings logs said this WARN 09-09 13:18:28.799 o.a.o.d.d.b.ConfigurationDao:118 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-2] - Could not find key in configurations: number.minutes.reminder.send any solution???

Comment from: ysh [Visitor]

any solution???

Comment from: Hayati TASTAN [Visitor]

WARN 01-13 09:52:10.058 ConfigurationDao.java 1742093 118 org.apache.openmeetin gs.db.dao.basic.ConfigurationDao [org.springframework.scheduling.quartz.Schedule rFactoryBean#0_Worker-7] - Could not find key in configurations: mail.smtp.timeo ut DEBUG 01-13 09:52:10.062 MailHandler.java 1742097 279 org.apache.openmeetings.co re.mail.MailHandler [org.springframework.scheduling.quartz.SchedulerFactoryBean# 0_Worker-7] - sendMails enter … DEBUG 01-13 09:52:10.063 MailHandler.java 1742098 281 org.apache.openmeetings.co re.mail.MailHandler [org.springframework.scheduling.quartz.SchedulerFactoryBean# 0_Worker-7] - Number of emails in init queue 0 DEBUG 01-13 09:52:10.064 MailHandler.java 1742099 286 org.apache.openmeetings.co re.mail.MailHandler [org.springframework.scheduling.quartz.SchedulerFactoryBean# 0_Worker-7] - … sendMails done. DEBUG 01-13 09:52:25.445 ReminderJob.java 1757480 44 org.apache.openmeetings.ser vice.quartz.scheduler.ReminderJob [org.springframework.scheduling.quartz.Schedul erFactoryBean#0_Worker-6] - ReminderJob.remindMeetings WARN 01-13 09:52:32.128 ConfigurationDao.java 1764163 118 org.apache.openmeetin gs.db.dao.basic.ConfigurationDao [org.springframework.scheduling.quartz.Schedule rFactoryBean#0_Worker-6] - Could not find key in configurations: application.bas e.url

any solution to this??

Comment from: Tshering [Visitor]

HI. Please help me. when I run red5.sh, I get to see the following

ERROR 03-13 14:34:36.952 o.a.o.s.q.s.ReminderJob:115 [Bean#0_Worker-5] - DB seems to be down DEBUG 03-13 14:34:36.953 o.a.o.u.c.CryptProvider:39 [Bean#0_Worker-5] - getInstanceOfCrypt:: configKeyCryptClassName: null

Comment from: Arbaces Fabian [Visitor]

Same Error, have you any idea can help me?? Thanks

Form is loading...

Mon	Tue	Wed	Thu	Fri	Sat	Sun
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31
<< <				> >>