Back to square 1. Nothing I do will cause this v2.0 to install and use a mysql database.
On Tue, Jun 12, 2012 at 9:34 AM, Robert Chalmers < [email protected]> wrote: > Well gee - isn't that handy. > > Thanks George. I've been struggling with this as well for a few days now > .... No word anywhere that this file wasn't even in the distrib. > > Thanks > Robert > > > On Tue, Jun 12, 2012 at 9:04 AM, George Kirkham <[email protected]>wrote: > >> 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&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=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-2012_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.**** >> > >
