Sysdebian,

 

Do you have mysql-connector-java-5.1.20-bin.jar in your
red5/webapps/openmeetings/WEB-INF/lib folder ?  Of course there may be
another reason, but I wanted to check with you as missing this step has
been an issue for me in the past.

 

For me this is
"/usr/lib/red5/webapps/openmeetings/WEB-INF/lib/mysql-connector-java-5.1
.20-bin.jar". 

 

To my knowledge the mysql jar file is not longer shipped with
OpenMeetings and we need to download it and copy it into the lib folder
as a manual step.

 

Here is the URL

http://www.mysql.com/downloads/connector/j/

 

 

Thanks,

 

George Kirkham

 

 

From: sysdebian [mailto:[email protected]] 
Sent: Monday, 11 June 2012 11:31 PM
To: [email protected]
Subject: folder, probably your database user/pwd/host is wrong!

 

Hello,

I have install
apache-openmeetings-incubating-2.0.0.r1348677-10-06-2012_2307.tar.gz and
everything look fine but when I try the browser install I got this
message:
--------------------------------
OpenMeetings - Loading ...
The server is not yet completely initialized. Please try again in a
couple of seconds.
If this message persists for several minutes contact your
Sys-Administration.
If that message stays forever you should check the logs located in 

openmeetings_install_dir/log

folder, probably your database user/pwd/host is wrong! 
--------------------------------

The user/pwd/host is ok, here you are my
/usr/lib/red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.
xml related configuration:
--------------------------------
                        <property name="openjpa.ConnectionProperties"
 
value="DriverClassName=com.mysql.jdbc.Driver
                                        ,
Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&amp;useU
nicode=true&amp;createDatabaseIfNotExist=true&amp;characterEncoding=utf-
8&amp;connectionCollation=utf8_general_ci&amp;cachePrepStmts=true&amp;ca
cheCallableStatements=true&amp;cacheServerConfiguration=true&amp;useLoca
lSessionState=true&amp;elideSetAutoCommits=true&amp;alwaysSendSetIsolati
on=false&amp;enableQueryTimeouts=false&amp;prepStmtCacheSize=3000&amp;pr
epStmtCacheSqlLimit=1000
                                        , MaxActive=100
                                        , MaxWait=10000
                                        , TestOnBorrow=true
                                        , poolPreparedStatements=true
                                        , Username=openmeetings
                                        , Password=XXXX"/>
                        <property
name="openjpa.jdbc.SynchronizeMappings" value="buildSchema"/>
--------------------------------

And you can see the database setup is correct:
--------------------------------
# mysql -u openmeetings -pXXXX openmeetings
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 583
Server version: 5.1.61-0+squeeze1 (Debian)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights
reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> 
--------------------------------

These are the steps which I did to install openmeetings:
--------------------------------
aptitude install sun-java6-jdk
aptitude install openoffice.org-writer openoffice.org-calc
openoffice.org-impress openoffice.org-draw openoffice.org-math
aptitude install imagemagick
aptitude install sox
wget
https://builds.apache.org/job/openmeetings/lastSuccessfulBuild/artifact/
singlewebapp/dist/apache-openmeetings-incubating-2.0.0.r1348677-10-06-20
12_2307.tar.gz
mkdir openmeetings
cd openmeetings
tar zxf
apache-openmeetings-incubating-2.0.0.r1348677-10-06-2012_2307.tar.gz
mv openmeetings /usr/lib/red5
chown -R nobody /usr/lib/red5
chmod +x /usr/lib/red5/red5.sh
vim /etc/init.d/red5
chmod +x /etc/init.d/red5
cd /usr/lib/red5/
cp -a
webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
vim webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
/etc/init.d/red5 start
netstat -tanp|grep -i listen
tcp        0      0 127.0.0.1:3306          0.0.0.0:*
LISTEN      11799/mysqld    
tcp        0      0 127.0.0.1:8100          0.0.0.0:*
LISTEN      18994/soffice.bin
tcp6       0      0 :::1935                 :::*
LISTEN      18687/java      
tcp6       0      0 :::9999                 :::*
LISTEN      18687/java      
tcp6       0      0 :::8088                 :::*
LISTEN      18687/java      
tcp6       0      0 :::5080                 :::*
LISTEN      18687/java      
tcp6       0      0 :::53062                :::*
LISTEN      18687/java      
--------------------------------
And then I try the install browser:
http://hostname:5080/openmeetings/install and got the error.

The log output:
------------------------------
cd /usr/lib/red5/log
> 0.0.0.0_access.2012-06-11.log ; > error.log ;>openmeetings.log
;>red5.log 
#only red5.log writes something when I refresh the browser:

2012-06-11 15:30:27,179 [http-0.0.0.0-5080-1] INFO
o.a.c.c.C.[.[.0.0.0.[/openmeetings] -  Velocity  [debug] ResourceManager
: found booting_install.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader

------------------------------

Any Idea ?

Thanks and best regards.

Reply via email to