Thursday, May 26, 2011

OpenMeetings 1_6_2_r3675 Ubuntu 10.04 x64 Server Edition

A few days ago, I just finished my installation on Ubuntu 10.04 Server Edition. I was installed OpenMeeting. You can download it from http://openmeetings.googlecode.com/files/openmeetings_1_6_2_r3675.zip

Since I found no tutorial on Installing OpenMeeting using Postgresql, I decided to  write my own. I hope it can help anyone who need it.


Here are the steps that I used :
    1. Install all necessary packages
    • sudo apt-get install -y mysql-server java-package sun-java6-bin sun-java6-jdk sun-java6-jre imagemagick gs-gpl libart-2.0-2 libt1-5 zip unzip bzip2 subversion git-core checkinstall yasm texi2html libfaac-dev libfaad-dev libmp3lame-dev libsdl1.2-dev libx11-dev libxfixes-dev libxvidcore-dev zlib1g-dev libogg-dev sox libvorbis0a libvorbis-dev libgsm1 libgsm1-dev libfaad2 flvtool2 lame swftools flashplugin-installer
       2. Copy openmeetings_1_6_2_r3675.zip into /opt directory
      • sudo cp openmeetings...zip /opt
          3. Extract it
          • sudo unzip openmeetings_1_6_2_r3675.zip
          4.  Configure user nobody as owner
          • sudo chown -R nobody /opt/red5  
          5. We make sure you have permission to execution
          • sudo chmod +x /opt/red5/*.sh 
          • sudo chmod +x /opt/red5/webapps/openmeetings/jod/*.sh
          6. Create file Red5 and OpenOffice as a service, which can be used for automatically load when boot.
          7. Let's give execute permissions.
          • sudo chmod +x /etc/init.d /red5
          • sudo chmod +x /etc/init.d /openoffice
          8. Finally if we have the red5 server and openoffice as a service execute these commands.
          • sudo update-rc.d red5 defaults
          • sudo update-rc.d openoffice defaults
          9. Postgresql Related 
          • Add user openmeetings on linux system : sudo adduser openmeetings
          • Give password for the user
          • Change into superuser : sudo su - postgres
          • Connect to database : psql template1
          • Add user openmeetings : CREATE USER openmeetings WITH PASSWORD 'your_password';
          • Add database openmeetings : CREATE DATABASE openmeetings;
          • Grant all privileges to database : GRANT ALL PRIVILEGES ON DATABASE openmeetings to openmeetings;
          • Quit : \q
          • Test User :
                su - openmeetings
                psql -d openmeetings -U openmeetings
             
          10. Go to http://your_ip:5080/openmeetings/install

          11. Fill these fields :
          • Username
          • Userpass
          • Email
          • User Time Zone
          • SMTP Server : can be skipped
          • SMTP Server Port : can be skipped
          • SMTP Username : can be skipped
          • SMTP Userpass : can be skipped
          • SWFTools Path : can be skipped. Fill the path only. Ex : /usr/bin NOT /usr/bin/pdf2swf
          • ImageMagick Path : can be skipped. Same as above
          • FFMPEG Path : can be skipped. Same as above
          • Make other field default values.
          12. Scroll the screen, and click Install Button.

          13. Go to http://your_ip:5080/openmeetings . If you can see the login screen, then Congratullations !! :)

          ----------------------
          Problem Solving
          ----------------------

          This problem solving, only error that I experienced. Sorry if I don't have solution for another error :)

          1. Found Error : Internal Server Error when I clicked Install Button.

          You will need to see red5 log file. It is located in /opt/red5/logs/red5.log
          I found this line.
          ERROR o.a.c.c.C.[.[.0.0.0.[.[Install] - Servlet.service() for servlet Install threw exception
          java.lang.AbstractMethodError: org.postgresql.jdbc2.Jdbc2DatabaseMetaData.getDatabaseMajorVersion()I
          Solution :

          2. Found error :
              Autoconnect
              NetConnection.Connect.Failed
              rtmpt://your_ip:8088/openmeetings/hibernate

          Solution :

          I'm not sure about this error. It seems caused by our proxy server block the 8088 port. When I switch to other connection which is not using proxy, I can see the login screen and login normally.
          There are a lots things which cause this. You can find more on the internet.

          References :
          http://bytes.com/topic/postgresql/answers/857378-client-encoding-postgresql
          http://www.cyberciti.biz/faq/howto-add-postgresql-user-account/
          http://docs.huihoo.com/ubuntu/9.10/serverguide/C/postgresql.html
          http://www.postgresql.org/docs/8.2/interactive/sql-createuser.html
          http://surabaya.di.blankon.in/install-openmeetings-pada-ubuntu-10-04blankon-ombilin -- Indonesian version
          http://code.google.com/p/openmeetings/wiki/InstallationOfRelease051
          http://www.757.org/~joat/wiki/index.php?n=Main.InstallationOfOpenMeetings
          http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/
          http://www.humbug.in/docs/ubuntu-server-guide-sk-10.04/postgresql.html
          http://code.google.com/p/openmeetings/wiki/ConvertersInstallation
          Post a Comment